|
![]() |
Property | Value |
Name | WF_FEDERAL_1011 |
Schema | dbo |
Row Count | 32453 |
Data Size | 10072 KB |
Index Size | 528 KB |
Create Date | 2/13/2013 10:28 AM |
Description |
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
![]() |
![]() |
ISN_WF_FEDERAL_1011 |
int(10, 0) |
False |
False |
False |
|||
![]() |
![]() |
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
|||
![]() |
![]() |
WF_FAO |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_A_BLANKS |
varchar(200) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_A_SGN |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_A_SGN_DATE |
date(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_A_SSREG |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_ASM1_OVR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_ASM2_OVR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_ASM3_OVR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_ASM4_OVR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_ASM5_OVR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_ASM6_OVR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_DEP_OVR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_LOCK |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_LOCK_ACG |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_PROF_JUDG |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_REJ12_OVR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_REJ20_OVR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_REJ3_OVR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_REJA_OVR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_REJB_OVR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_REJC_OVR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_REJG_OVR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_REJJ_OVR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_REJK_OVR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_REJN_OVR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_F_REJW_OVR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_A_COOP |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_A_CPAY |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_A_CSPD |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_A_EDCR |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_A_GRNT |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_A_WORK |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_AGI |
decimal(7, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_BUS_FRM |
decimal(7, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_CASH |
decimal(7, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_DLW |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_FA_INC |
decimal(7, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_FA_LEV |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_FAM_COL |
decimal(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_FAM_SIZE |
decimal(3, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_FED_TAX |
decimal(7, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_FILER |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_FORM |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_INV |
decimal(7, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_MAR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_MAR_DATE |
date(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_MO_INC |
decimal(7, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_MO_LEV |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_MT_LUNCH |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_MT_SSI |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_MT_STAMP |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_MT_TANF |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_MT_WIC |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_RES |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_RES_5YR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_RES_DATE |
date(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_SFORM |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_TAX_EXEM |
decimal(3, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_U_CSUP |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_U_DIST |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_U_INT |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_U_IRA |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_U_LIV |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_U_OTHER |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_U_PEN |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_U_PENS |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_P_U_VET |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_A_COOP |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_A_CPAY |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_A_CSPD |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_A_EDCR |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_A_GRNT |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_A_WORK |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_AGI |
decimal(7, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_BACH_DEG |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_BUS_FRM |
decimal(7, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_CASH |
decimal(7, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_CIT |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_DEG |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_DLW |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_DRUG |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_ENR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_FAM_COL |
decimal(1, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_FAM_SIZE |
decimal(3, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_FED_TAX |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_FILER |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_FORM |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_HS_AP_IB |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_HS_GED |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_HS_PROG |
varchar(6) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_HS_RIGOR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_HS_STATE |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_HS_YEAR |
varchar(4) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_HSG |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_INT |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_INV |
decimal(7, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_MALE |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_MAR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_MAR_DATE |
date(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_MT_LUNCH |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_MT_SSI |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_MT_STAMP |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_MT_TANF |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_MT_WIC |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_RES |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_RES_5YR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_RES_DATE |
date(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_SFORM |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_SP_INC |
decimal(7, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_ST_INC |
decimal(7, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_TAX_EXEM |
decimal(3, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_TCH |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_TEST_ACTV |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_TEST_CHL |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_TEST_DEP |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_TEST_DOB |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_TEST_EMAN |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_TEST_GRAD |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_TEST_GUAR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_TEST_HMLS |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_TEST_MAR |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_TEST_ORPH |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_TEST_UYHU |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_TEST_UYSD |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_TEST_VET |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_U_CSUP |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_U_DIST |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_U_INT |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_U_IRA |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_U_LIV |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_U_MONEY |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_U_OTHER |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_U_PEN |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_U_PENS |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_U_VET |
decimal(5, 0) |
True |
False |
False |
|||
![]() |
![]() |
WF_FE_S_YR_COL |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
WW_CDATE |
date(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
WW_HOLD |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
WW_MDATE |
date(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
WW_STUDENT_ID |
char(18) |
True |
False |
False |
Name | Insert | Update | Delete | Instead |
Name | Clustered | Columns |
False |
ISN_WF_FEDERAL_1011 |
Name | Columns | Referenced Table | Referenced Columns | Checked |
Name | Text | Checked |
Name | Type |
Name | Type |
Object | Property | Value |
Object | Property | Value |
/****** Object: Table [dbo].[WF_FEDERAL_1011] Script Date: 03/09/2017 16:46:46 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[WF_FEDERAL_1011]( [ISN_WF_FEDERAL_1011] [int] NOT NULL, [WW_STUDENT_ID] [char](18) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FAO] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WW_HOLD] [int] NULL, [WW_CDATE] [date] NULL, [WW_MDATE] [date] NULL, [WF_FE_S_CIT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_RES] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_RES_5YR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_RES_DATE] [date] NULL, [WF_FE_S_MAR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_MAR_DATE] [date] NULL, [WF_FE_S_FAM_SIZE] [decimal](3, 0) NULL, [WF_FE_S_FAM_COL] [decimal](1, 0) NULL, [WF_FE_S_DLW] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_MT_SSI] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_MT_STAMP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_MT_LUNCH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_MT_TANF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_MT_WIC] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_TEST_DOB] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_TEST_MAR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_TEST_GRAD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_TEST_ACTV] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_TEST_VET] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_TEST_CHL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_TEST_DEP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_TEST_ORPH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_TEST_EMAN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_TEST_GUAR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_TEST_UYSD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_TEST_UYHU] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_TEST_HMLS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_MALE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_DRUG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_HS_GED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_HS_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_HS_STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_HS_PROG] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_HS_AP_IB] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_HS_RIGOR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_BACH_DEG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_YR_COL] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_DEG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_ENR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_HSG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_INT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_TCH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_FILER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_FORM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_SFORM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_S_TAX_EXEM] [decimal](3, 0) NULL, [WF_FE_S_AGI] [decimal](7, 0) NULL, [WF_FE_S_FED_TAX] [decimal](5, 0) NULL, [WF_FE_S_ST_INC] [decimal](7, 0) NULL, [WF_FE_S_SP_INC] [decimal](7, 0) NULL, [WF_FE_S_A_EDCR] [decimal](5, 0) NULL, [WF_FE_S_A_CSPD] [decimal](5, 0) NULL, [WF_FE_S_A_WORK] [decimal](5, 0) NULL, [WF_FE_S_A_GRNT] [decimal](5, 0) NULL, [WF_FE_S_A_CPAY] [decimal](5, 0) NULL, [WF_FE_S_A_COOP] [decimal](5, 0) NULL, [WF_FE_S_U_PEN] [decimal](5, 0) NULL, [WF_FE_S_U_IRA] [decimal](5, 0) NULL, [WF_FE_S_U_CSUP] [decimal](5, 0) NULL, [WF_FE_S_U_INT] [decimal](5, 0) NULL, [WF_FE_S_U_DIST] [decimal](5, 0) NULL, [WF_FE_S_U_PENS] [decimal](5, 0) NULL, [WF_FE_S_U_LIV] [decimal](5, 0) NULL, [WF_FE_S_U_VET] [decimal](5, 0) NULL, [WF_FE_S_U_OTHER] [decimal](5, 0) NULL, [WF_FE_S_U_MONEY] [decimal](5, 0) NULL, [WF_FE_S_CASH] [decimal](7, 0) NULL, [WF_FE_S_INV] [decimal](7, 0) NULL, [WF_FE_S_BUS_FRM] [decimal](7, 0) NULL, [WF_FE_P_RES] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_P_RES_5YR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_P_RES_DATE] [date] NULL, [WF_FE_P_MAR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_P_MAR_DATE] [date] NULL, [WF_FE_P_FAM_SIZE] [decimal](3, 0) NULL, [WF_FE_P_FAM_COL] [decimal](1, 0) NULL, [WF_FE_P_DLW] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_P_MT_SSI] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_P_MT_STAMP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_P_MT_LUNCH] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_P_MT_TANF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_P_MT_WIC] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_P_FA_LEV] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_P_MO_LEV] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_P_FILER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_P_FORM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_P_SFORM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_P_TAX_EXEM] [decimal](3, 0) NULL, [WF_FE_P_AGI] [decimal](7, 0) NULL, [WF_FE_P_FED_TAX] [decimal](7, 0) NULL, [WF_FE_P_FA_INC] [decimal](7, 0) NULL, [WF_FE_P_MO_INC] [decimal](7, 0) NULL, [WF_FE_P_A_EDCR] [decimal](5, 0) NULL, [WF_FE_P_A_CSPD] [decimal](5, 0) NULL, [WF_FE_P_A_WORK] [decimal](5, 0) NULL, [WF_FE_P_A_GRNT] [decimal](5, 0) NULL, [WF_FE_P_A_CPAY] [decimal](5, 0) NULL, [WF_FE_P_A_COOP] [decimal](5, 0) NULL, [WF_FE_P_U_PEN] [decimal](5, 0) NULL, [WF_FE_P_U_IRA] [decimal](5, 0) NULL, [WF_FE_P_U_CSUP] [decimal](5, 0) NULL, [WF_FE_P_U_INT] [decimal](5, 0) NULL, [WF_FE_P_U_DIST] [decimal](5, 0) NULL, [WF_FE_P_U_PENS] [decimal](5, 0) NULL, [WF_FE_P_U_LIV] [decimal](5, 0) NULL, [WF_FE_P_U_VET] [decimal](5, 0) NULL, [WF_FE_P_U_OTHER] [decimal](5, 0) NULL, [WF_FE_P_CASH] [decimal](7, 0) NULL, [WF_FE_P_INV] [decimal](7, 0) NULL, [WF_FE_P_BUS_FRM] [decimal](7, 0) NULL, [WF_FE_A_SSREG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_A_SGN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_A_SGN_DATE] [date] NULL, [WF_FE_A_BLANKS] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_DEP_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_REJ3_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_REJ12_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_REJ20_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_REJA_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_REJB_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_REJC_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_REJG_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_REJJ_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_REJK_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_REJN_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_REJW_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_ASM1_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_ASM2_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_ASM3_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_ASM4_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_ASM5_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_ASM6_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_LOCK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_LOCK_ACG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WF_FE_F_PROF_JUDG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
ISN_WF_FEDERAL_1011 | RowUpdatedOn | WF_FAO | WF_FE_A_BLANKS | WF_FE_A_SGN | WF_FE_A_SGN_DATE | WF_FE_A_SSREG | WF_FE_F_ASM1_OVR | WF_FE_F_ASM2_OVR | WF_FE_F_ASM3_OVR | WF_FE_F_ASM4_OVR | WF_FE_F_ASM5_OVR | WF_FE_F_ASM6_OVR | WF_FE_F_DEP_OVR | WF_FE_F_LOCK | WF_FE_F_LOCK_ACG | WF_FE_F_PROF_JUDG | WF_FE_F_REJ12_OVR | WF_FE_F_REJ20_OVR | WF_FE_F_REJ3_OVR | WF_FE_F_REJA_OVR | WF_FE_F_REJB_OVR | WF_FE_F_REJC_OVR | WF_FE_F_REJG_OVR | WF_FE_F_REJJ_OVR | WF_FE_F_REJK_OVR | WF_FE_F_REJN_OVR | WF_FE_F_REJW_OVR | WF_FE_P_A_EDCR | WF_FE_P_AGI | WF_FE_P_CASH | WF_FE_P_DLW | WF_FE_P_FA_INC | WF_FE_P_FA_LEV | WF_FE_P_FAM_COL | WF_FE_P_FAM_SIZE | WF_FE_P_FED_TAX | WF_FE_P_FILER | WF_FE_P_FORM | WF_FE_P_MAR | WF_FE_P_MAR_DATE | WF_FE_P_MO_INC | WF_FE_P_MO_LEV | WF_FE_P_MT_LUNCH | WF_FE_P_MT_SSI | WF_FE_P_MT_STAMP | WF_FE_P_MT_TANF | WF_FE_P_MT_WIC | WF_FE_P_RES | WF_FE_P_RES_5YR | WF_FE_P_SFORM | WF_FE_P_TAX_EXEM | WF_FE_P_U_CSUP | WF_FE_S_A_EDCR | WF_FE_S_AGI | WF_FE_S_BACH_DEG | WF_FE_S_CASH | WF_FE_S_CIT | WF_FE_S_DEG | WF_FE_S_DLW | WF_FE_S_DRUG | WF_FE_S_ENR | WF_FE_S_FAM_COL | WF_FE_S_FAM_SIZE | WF_FE_S_FED_TAX | WF_FE_S_FILER | WF_FE_S_FORM | WF_FE_S_HS_AP_IB | WF_FE_S_HS_GED | WF_FE_S_HS_PROG | WF_FE_S_HS_RIGOR | WF_FE_S_HS_STATE | WF_FE_S_HS_YEAR | WF_FE_S_HSG | WF_FE_S_INT | WF_FE_S_INV | WF_FE_S_MALE | WF_FE_S_MAR | WF_FE_S_MAR_DATE | WF_FE_S_MT_LUNCH | WF_FE_S_MT_SSI | WF_FE_S_MT_STAMP | WF_FE_S_MT_TANF | WF_FE_S_MT_WIC | WF_FE_S_RES | WF_FE_S_RES_5YR | WF_FE_S_RES_DATE | WF_FE_S_SFORM | WF_FE_S_SP_INC | WF_FE_S_ST_INC | WF_FE_S_TAX_EXEM | WF_FE_S_TCH | WF_FE_S_TEST_ACTV | WF_FE_S_TEST_CHL | WF_FE_S_TEST_DEP | WF_FE_S_TEST_DOB | WF_FE_S_TEST_EMAN | WF_FE_S_TEST_GRAD | WF_FE_S_TEST_GUAR | WF_FE_S_TEST_HMLS | WF_FE_S_TEST_MAR | WF_FE_S_TEST_ORPH | WF_FE_S_TEST_UYHU | WF_FE_S_TEST_UYSD | WF_FE_S_TEST_VET | WF_FE_S_U_OTHER | WF_FE_S_U_CSUP | WF_FE_S_U_PEN | WF_FE_S_YR_COL | WW_CDATE | WW_HOLD | WW_MDATE | WW_STUDENT_ID |
894 | 2017-02-06T11:14:57.516-05:00 | PB | Y | B | 2010-03-31T00:00:00-04:00 | 541 | 43566 | 500 | N | 21299 | H | 1 | 4 | F | L | M | 1988-08-01T00:00:00-04:00 | 22267 | H | FL | Y | N | 4 | 7035 | N | 1000 | U | 4 | E | F | 134 | F | S | G | DD0001 | Y | FL | 2008 | P | W | M | S | FL | Y | Y | 7035 | N | N | N | N | N | N | N | N | N | N | N | N | N | FR | 2010-04-08T00:00:00-04:00 | 1147530 | 2010-06-21T00:00:00-04:00 | 57570634227305889C | ||||||||||||||||||||||||||||||||||||||||||||||||
167 | 2017-02-06T11:14:57.314-05:00 | PB | Y YY YY | A | 2010-02-09T00:00:00-05:00 | U | H | 23532 | N | U | 9 | N | E | F | 1 | 1 | 1709 | F | S | G | O | L | F | S | FL | Y | Y | 23532 | 1 | Y | N | N | Y | N | N | FP | 2010-04-08T00:00:00-04:00 | 1630079 | 57570634378770078C | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
468 | 2017-02-06T11:14:57.36-05:00 | PB | Y YY YY | A | 2010-02-03T00:00:00-05:00 | H | H | 45908 | N | 3700 | U | 1 | N | E | F | 1 | 1 | 3904 | F | L | D | O | 2000 | S | FL | N | 2008-07-01T00:00:00-04:00 | U | 45908 | 1 | N | N | Y | N | N | JR | 2010-04-08T00:00:00-04:00 | 1631335 | 57570634171309332C | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5036 | 2017-02-06T11:14:58.889-05:00 | PB | Y | B | 2010-03-30T00:00:00-04:00 | 13252 | N | E | 3 | 8 | F | L | X | 1994-06-01T00:00:00-04:00 | 14260 | E | Y | Y | Y | FL | Y | Y | 4 | 2424 | 1295 | 34651 | N | U | 3 | E | F | 2086 | F | L | D | Y | FL | 2006 | O | B | M | S | FL | Y | Y | 34651 | 1 | N | N | N | N | N | N | N | N | N | N | N | N | N | FP | 2010-04-08T00:00:00-04:00 | 304180 | 2011-05-06T00:00:00-04:00 | 57570634153330999C | |||||||||||||||||||||||||||||||||||||||||||||||
10727 | 2017-02-06T11:15:00.605-05:00 | PB | Y YY YY | A | 2010-04-30T00:00:00-04:00 | H | H | H | 6898 | N | 2000 | U | 3 | N | E | F | 1 | 2 | F | S | D | O | B | 20 | F | S | FL | Y | Y | 6898 | 2 | Y | N | Y | N | N | 900 | FP | 2010-05-17T00:00:00-04:00 | 1052426 | 57570633622564862C | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
24466 | 2017-02-06T11:15:04.661-05:00 | PB | Y YY YY | A | 2010-09-02T00:00:00-04:00 | U | U | 11805 | N | U | 4 | N | E | 1 | 3 | F | L | D | O | F | S | FL | Y | Y | 9697 | 3 | Y | N | Y | N | N | 2400 | FR | 2010-09-07T00:00:00-04:00 | 312113 | 2011-05-06T00:00:00-04:00 | 57570634509847197C | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4118 | 2017-02-06T11:14:58.593-05:00 | PB | YYYYYYYYYYYYYYYYYYYY YY YY | A | 2010-01-26T00:00:00-05:00 | U | U | 15018 | N | U | 3 | Y | E | F | 1 | 2 | F | S | D | O | B | M | S | FL | Y | Y | 15000 | 2 | Y | N | Y | Y | N | N | JR | 2010-04-08T00:00:00-04:00 | 1115287 | 2011-04-18T00:00:00-04:00 | 57570633741876441C | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
31317 | 2017-02-06T11:15:06.814-05:00 | PB | YY YYYYYYYYYYYYYYYYYYY YY YY | A | 2011-04-11T00:00:00-04:00 | H | H | N | U | 3 | N | E | 1 | 4 | F | L | G | O | M | M | 2009-11-01T00:00:00-04:00 | Y | FL | Y | 8159 | 700761 | Y | N | Y | N | Y | FP | 2011-04-13T00:00:00-04:00 | 1337588 | 2011-05-09T00:00:00-04:00 | 57570633865314898C | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
8089 | 2017-02-06T11:14:59.825-05:00 | PB | YYY YYYY | B | 2010-04-16T00:00:00-04:00 | 1360 | 43801 | N | H | 3 | 4 | 986 | F | S | S | 43801 | H | FL | Y | Y | 4 | N | U | 3 | E | F | N | D | O | L | M | S | FL | Y | N | N | N | N | N | N | N | N | N | N | N | N | N | JR | 2010-04-22T00:00:00-04:00 | 1026541 | 2010-08-02T00:00:00-04:00 | 57570633492977949C | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
23717 | 2017-02-06T11:15:04.474-05:00 | PB | Y YY YY | A | 2010-03-24T00:00:00-04:00 | Y | U | U | 833 | 28131 | N | 6200 | E | 3 | N | E | H | 3 | 3 | F | L | D | O | L | F | D | 2008-01-01T00:00:00-05:00 | FL | Y | Y | 28131 | 3 | Y | N | Y | N | N | 4368 | 520 | FP | 2010-08-25T00:00:00-04:00 | 311576 | 2011-05-06T00:00:00-04:00 | 57570634498595203C |
Powered by BI Documenter |