DWStaging
 dbo.WF_FUND (Table)
Home  Diagrams  Documents  Images  DWStaging  Storage  Users  Roles  Schemas  Tables  Views  Indexes  Triggers  Stored Procedures  Functions  Data Types  XML Schemas  Rules  Defaults  Fulltext Catalogs  Synonyms  Keys  Partitions  Assemblies 
Current Path:  DWStaging   Tables   dbo.WF_FUND
  Properties
Property Value
Name WF_FUND
Schema dbo
Row Count 14949
Data Size 3096 KB
Index Size 264 KB
Create Date 2/13/2013 11:34 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ISN_WF_FUND
int(10, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
WF_FAO
varchar(2)
True
False
False
 
WF_FU_ACCT_1
varchar(15)
True
False
False
 
WF_FU_ACCT_2
varchar(15)
True
False
False
 
WF_FU_ACCT_SAR
varchar(15)
True
False
False
 
WF_FU_ACCT_SLN
varchar(15)
True
False
False
 
WF_FU_ALLOW_AWDS
varchar(1)
True
False
False
 
WF_FU_AWD_MAX
decimal(5, 0)
True
False
False
 
WF_FU_AWD_MIN
decimal(5, 0)
True
False
False
 
WF_FU_DIS_CHRS
varchar(1)
True
False
False
 
WF_FU_DIS_REQ1
varchar(6)
True
False
False
 
WF_FU_DIS_REQ1_AFF
varchar(1)
True
False
False
 
WF_FU_DIS_REQ1_PD
varchar(2)
True
False
False
 
WF_FU_DIS_REQ2
varchar(6)
True
False
False
 
WF_FU_DIS_REQ2_AFF
varchar(1)
True
False
False
 
WF_FU_DIS_REQ2_PD
varchar(2)
True
False
False
 
WF_FU_DIS_SNAP
varchar(1)
True
False
False
 
WF_FU_DIS_STATUS
varchar(1)
True
False
False
 
WF_FU_DIST
varchar(1)
True
False
False
 
WF_FU_EXT_REQ1
varchar(1)
True
False
False
 
WF_FU_EXT_REQ2
varchar(1)
True
False
False
 
WF_FU_EXT_REQ3
varchar(1)
True
False
False
 
WF_FU_FREEZE_DISB
varchar(1)
True
False
False
 
WF_FU_FREEZE_OFF
varchar(1)
True
False
False
 
WF_FU_J_AUTH_FMT
varchar(1)
True
False
False
 
WF_FU_L_ELEC_FMT
varchar(1)
True
False
False
 
WF_FU_L_INT_RATE
decimal(5, 2)
True
False
False
 
WF_FU_L_ORIG_CHG
varchar(1)
True
False
False
 
WF_FU_L_ORIG_FEE
decimal(5, 0)
True
False
False
 
WF_FU_L_ORIG_PCT
decimal(5, 2)
True
False
False
 
WF_FU_L_PROM_FMT
varchar(1)
True
False
False
 
WF_FU_LIMIT_AWDS
varchar(1)
True
False
False
 
WF_FU_MEET_NEED
varchar(1)
True
False
False
 
WF_FU_NAME
varchar(30)
True
False
False
 
WF_FU_NOT_ORDER
varchar(1)
True
False
False
 
WF_FU_NOT_PRINT
varchar(1)
True
False
False
 
WF_FU_OFF_STAFF
varchar(1)
True
False
False
 
WF_FU_PGM_ANN
decimal(5, 0)
True
False
False
 
WF_FU_PGM_AWARD
varchar(2)
True
False
False
 
WF_FU_PGM_FISAP
varchar(5)
True
False
False
 
WF_FU_PGM_LIF
decimal(7, 0)
True
False
False
 
WF_FU_PGM_TSCPT
varchar(5)
True
False
False
 
WF_FU_REPL_FC
varchar(1)
True
False
False
 
WF_FU_REPL_FUND
varchar(9)
True
False
False
 
WF_FU_REPL_RULE
varchar(1)
True
False
False
 
WF_FU_ROLL_FAO
varchar(2)
True
False
False
 
WF_FU_ROLL_FUND
varchar(9)
True
False
False
 
WF_FU_SAR_FEED
varchar(1)
True
False
False
 
WF_FU_SLN_FEED
varchar(1)
True
False
False
 
WF_FU_SRC
varchar(1)
True
False
False
 
WF_FU_STATUS
varchar(1)
True
False
False
 
WF_FU_TYPE
varchar(1)
True
False
False
 
WF_FU_U_A_NET
decimal(11, 2)
True
False
False
 
WF_FU_U_A_NET_CT
decimal(7, 0)
True
False
False
 
WF_FU_U_C_NET
decimal(11, 2)
True
False
False
 
WF_FU_U_C_NET_CT
decimal(7, 0)
True
False
False
 
WF_FU_U_D_CHKPT
decimal(11, 2)
True
False
False
 
WF_FU_U_D_LIM
decimal(11, 2)
True
False
False
 
WF_FU_U_D_NET
decimal(11, 2)
True
False
False
 
WF_FU_U_D_NET_CT
decimal(7, 0)
True
False
False
 
WF_FU_U_O_GRS
decimal(11, 2)
True
False
False
 
WF_FU_U_O_GRS_CT
decimal(7, 0)
True
False
False
 
WF_FU_U_O_LIM
decimal(11, 2)
True
False
False
 
WF_FU_U_O_NET
decimal(11, 2)
True
False
False
 
WF_FU_U_O_NET_CT
decimal(7, 0)
True
False
False
 
WF_FU_U_R_NET
decimal(11, 2)
True
False
False
 
WF_FU_U_R_NET_CT
decimal(7, 0)
True
False
False
 
WF_FUND_ID
char(18)
True
False
False
 
WF_NAME_FUND
varchar(30)
True
False
False
 
WW_CDATE
date(10, 0)
True
False
False
 
WW_EXTERNAL_ID
varchar(9)
True
False
False
 
WW_FISCAL_YEAR
varchar(4)
True
False
False
 
WW_HOLD
int(10, 0)
True
False
False
 
WW_MDATE
date(10, 0)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_WF_FUND
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.WF_FUND depends on)
Name Type
  Child Dependencies (objects that depend on dbo.WF_FUND)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[WF_FUND] Script Date: 03/09/2017 16:46:48 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[WF_FUND](
    [ISN_WF_FUND] [int] NOT NULL,
    [WF_FUND_ID] [char](18) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FAO] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_FISCAL_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NAME_FUND] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_HOLD] [int] NULL,
    [WW_CDATE] [date] NULL,
    [WW_MDATE] [date] NULL,
    [WF_FU_NAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_ACCT_1] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_ACCT_2] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_SRC] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_PGM_AWARD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_PGM_TSCPT] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_PGM_FISAP] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_FREEZE_OFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_FREEZE_DISB] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_LIMIT_AWDS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_ALLOW_AWDS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_ROLL_FAO] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_ROLL_FUND] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_REPL_RULE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_REPL_FUND] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_DIST] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_MEET_NEED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_REPL_FC] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_OFF_STAFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_AWD_MIN] [decimal](5, 0) NULL,
    [WF_FU_AWD_MAX] [decimal](5, 0) NULL,
    [WF_FU_PGM_ANN] [decimal](5, 0) NULL,
    [WF_FU_PGM_LIF] [decimal](7, 0) NULL,
    [WF_FU_NOT_PRINT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_NOT_ORDER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_SAR_FEED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_ACCT_SAR] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_SLN_FEED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_ACCT_SLN] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_DIS_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_DIS_SNAP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_DIS_CHRS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_DIS_REQ1] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_DIS_REQ1_PD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_DIS_REQ1_AFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_DIS_REQ2] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_DIS_REQ2_PD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_DIS_REQ2_AFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_EXTERNAL_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_EXT_REQ1] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_EXT_REQ2] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_EXT_REQ3] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_L_ORIG_CHG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_L_ORIG_PCT] [decimal](5, 2) NULL,
    [WF_FU_L_ORIG_FEE] [decimal](5, 0) NULL,
    [WF_FU_L_INT_RATE] [decimal](5, 2) NULL,
    [WF_FU_L_PROM_FMT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_L_ELEC_FMT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_J_AUTH_FMT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FU_U_D_CHKPT] [decimal](11, 2) NULL,
    [WF_FU_U_O_LIM] [decimal](11, 2) NULL,
    [WF_FU_U_D_LIM] [decimal](11, 2) NULL,
    [WF_FU_U_O_GRS] [decimal](11, 2) NULL,
    [WF_FU_U_O_NET] [decimal](11, 2) NULL,
    [WF_FU_U_C_NET] [decimal](11, 2) NULL,
    [WF_FU_U_A_NET] [decimal](11, 2) NULL,
    [WF_FU_U_R_NET] [decimal](11, 2) NULL,
    [WF_FU_U_D_NET] [decimal](11, 2) NULL,
    [WF_FU_U_O_GRS_CT] [decimal](7, 0) NULL,
    [WF_FU_U_O_NET_CT] [decimal](7, 0) NULL,
    [WF_FU_U_C_NET_CT] [decimal](7, 0) NULL,
    [WF_FU_U_A_NET_CT] [decimal](7, 0) NULL,
    [WF_FU_U_R_NET_CT] [decimal](7, 0) NULL,
    [WF_FU_U_D_NET_CT] [decimal](7, 0) NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ISN_WF_FUND RowUpdatedOn WF_FAO WF_FU_ACCT_1 WF_FU_ACCT_2 WF_FU_ACCT_SAR WF_FU_ACCT_SLN WF_FU_ALLOW_AWDS WF_FU_DIS_CHRS WF_FU_DIS_REQ1 WF_FU_DIS_REQ1_AFF WF_FU_DIS_REQ1_PD WF_FU_DIS_REQ2 WF_FU_DIS_REQ2_AFF WF_FU_DIS_REQ2_PD WF_FU_DIS_SNAP WF_FU_DIS_STATUS WF_FU_DIST WF_FU_EXT_REQ1 WF_FU_EXT_REQ2 WF_FU_EXT_REQ3 WF_FU_FREEZE_DISB WF_FU_FREEZE_OFF WF_FU_J_AUTH_FMT WF_FU_L_ELEC_FMT WF_FU_L_ORIG_CHG WF_FU_L_PROM_FMT WF_FU_LIMIT_AWDS WF_FU_MEET_NEED WF_FU_NAME WF_FU_NOT_ORDER WF_FU_NOT_PRINT WF_FU_OFF_STAFF WF_FU_PGM_AWARD WF_FU_PGM_FISAP WF_FU_PGM_TSCPT WF_FU_REPL_FC WF_FU_REPL_FUND WF_FU_REPL_RULE WF_FU_ROLL_FAO WF_FU_ROLL_FUND WF_FU_SAR_FEED WF_FU_SLN_FEED WF_FU_SRC WF_FU_STATUS WF_FU_TYPE WF_FU_U_A_NET WF_FU_U_A_NET_CT WF_FU_U_C_NET WF_FU_U_C_NET_CT WF_FU_U_D_CHKPT WF_FU_U_D_LIM WF_FU_U_D_NET WF_FU_U_D_NET_CT WF_FU_U_O_GRS WF_FU_U_O_GRS_CT WF_FU_U_O_LIM WF_FU_U_O_NET WF_FU_U_O_NET_CT WF_FUND_ID WF_NAME_FUND WW_CDATE WW_EXTERNAL_ID WW_FISCAL_YEAR WW_HOLD WW_MDATE
3994 2017-02-06T11:25:22.659-05:00 PB 58215000-215111 90-68001 2307 Y N N N N Y FD Bailey Paramedic Scholarshi Y Y FD N Y P A S 1500.00 6 500.00 2 1500.00 6792.00 1500.00 6 2000.00 8 6792.00 1500.00 6 46444241494C455920 FDBAILEYPARAMEDICSCHOLARSHI 2007-05-21T00:00:00-04:00 2008 3468 2016-11-10T00:00:00-05:00
9483 2017-02-06T11:25:23.611-05:00 PB 58215100-151519 90-68001 2307 Y N N N N Y PD GROUNDWATER AND ENVIRONMENT Y Y T N Y P A S 504447524F554E4420 PDGROUNDWATERANDENVIRONMENT 2013-05-21T00:00:00-04:00 2014 215 2016-11-10T00:00:00-05:00
8107 2017-02-06T11:25:23.408-05:00 PB 58215000-215236 90-68001 2307 Y N N N N Y FD Glades Area Scholarship Y Y FD N Y P A S 13750.00 21 1250.00 3 13750.00 13750.00 13750.00 21 15250.00 21 14000.00 14000.00 21 4644474C4144455341 FDGLADESAREASCHOLARSHIP 2012-05-21T00:00:00-04:00 2013 7498 2016-11-10T00:00:00-05:00
10076 2017-02-06T11:25:23.751-05:00 PB 58215000-215186 90-68001 2307 Y N N N Y FD PBCC Math Problem of Week Y Y FD N Y P A S 46444A41484E472020 FDPBCCMATHPROBLEMOFWEEK 2014-06-10T00:00:00-04:00 2015 230 2016-11-10T00:00:00-05:00
9643 2017-02-06T11:25:23.673-05:00 PB 58215100-151507 90-68001 2307 Y N N N N Y PD OUTREACH OF AMERICA Y Y PD N Y P A S 50444F555452454143 PDOUTREACHOFAMERICA 2013-05-21T00:00:00-04:00 2014 219 2016-11-10T00:00:00-05:00
11944 2017-02-06T11:25:24.016-05:00 PB 58215100-151403 90-68001 2307 Y N A N N N Y PD PALM BEACH CENTRAL HS 3 Y Y PD N Y P A S 504450424348532020 PDPALMBEACHCENTRALHS 2015-05-11T00:00:00-04:00 2016 289 2016-11-10T00:00:00-05:00
6784 2017-02-06T11:25:23.174-05:00 PB 58215000-215243 90-68001 2307 Y N N N N Y FD D&D Gallon Scholarship Y Y FD N Y P A S 500.00 500.00 46444444474C4E2020 FDD&DGALLONSCHOLARSHIP 2010-06-23T00:00:00-04:00 2011 121 2016-11-10T00:00:00-05:00
1424 2017-02-06T11:25:22.16-05:00 PB 2307 Y N A N N N Y PD ROTARY CLUB OF DELRAY BEACH Y Y PD N Y P A S 1000.00 2 1000.00 1000.00 1000.00 2 1000.00 2 1000.00 1000.00 2 5044524F5444454C52 PDROTARYCLUBOFDELRAYBEACH 2002-05-15T00:00:00-04:00 2003 1581 2016-11-10T00:00:00-05:00
10846 2017-02-06T11:25:23.86-05:00 PB 58215100-151510 90-68001 2307 Y N N N N Y PD CAUSARINA WOMAN'S CLUB Y Y PD N Y P A S 500.00 1 500.00 500.00 500.00 1 500.00 1 500.00 500.00 1 504443415553415249 PDCAUSARINAWOMANSCLUB 2013-05-21T00:00:00-04:00 2014 9372 2016-11-10T00:00:00-05:00
11799 2017-02-06T11:25:24.001-05:00 PB 58215100-151859 90-68001 2307 Y N N N N Y PD JUPITER COMMUNITY HIGH SCHL Y Y PD N Y P A S 50444A504348532020 PDJUPITERCOMMUNITYHIGHSCHL 2015-05-11T00:00:00-04:00 2016 285 2016-11-10T00:00:00-05:00
Powered by BI Documenter