DWStaging
 dbo.WF_CPS_0607 (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_CPS_0607
  Properties
Property Value
Name WF_CPS_0607
Schema dbo
Row Count 12959
Data Size 3480 KB
Index Size 240 KB
Create Date 2/13/2013 10:28 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ISN_WF_CPS_0607
int(10, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
WF_CP_A_DEP
varchar(1)
True
False
False
 
WF_CP_A_FC1
decimal(7, 0)
True
False
False
 
WF_CP_A_FC2
decimal(7, 0)
True
False
False
 
WF_CP_A_FISAP
decimal(7, 0)
True
False
False
 
WF_CP_A_PANAL
varchar(1)
True
False
False
 
WF_CP_A_PC
decimal(7, 0)
True
False
False
 
WF_CP_A_PCA
decimal(7, 0)
True
False
False
 
WF_CP_A_PCI
decimal(7, 0)
True
False
False
 
WF_CP_A_SANAL
varchar(1)
True
False
False
 
WF_CP_A_SC
decimal(7, 0)
True
False
False
 
WF_CP_A_SCA
decimal(7, 0)
True
False
False
 
WF_CP_A_SCI
decimal(7, 0)
True
False
False
 
WF_CP_A_VER
varchar(1)
True
False
False
 
WF_CP_C_DEF_OVR
varchar(1)
True
False
False
 
WF_CP_C_EFC_ADJ
varchar(1)
True
False
False
 
WF_CP_COLLEGE
varchar(6)
True
False
False
 
WF_CP_DRN
varchar(4)
True
False
False
 
WF_CP_FED_ID
varchar(13)
True
False
False
 
WF_CP_R_ACC_AWARD
decimal(7, 2)
True
False
False
 
WF_CP_R_ACC_COST
decimal(5, 0)
True
False
False
 
WF_CP_R_ACC_D01_DATE
date(10, 0)
True
False
False
 
WF_CP_R_ACC_D01_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_ACC_D01_DP
varchar(1)
True
False
False
 
WF_CP_R_ACC_D01_REL
varchar(1)
True
False
False
 
WF_CP_R_ACC_D01_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_ACC_D02_DATE
date(10, 0)
True
False
False
 
WF_CP_R_ACC_D02_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_ACC_D02_DP
varchar(1)
True
False
False
 
WF_CP_R_ACC_D02_REL
varchar(1)
True
False
False
 
WF_CP_R_ACC_D02_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_ACC_D03_DATE
date(10, 0)
True
False
False
 
WF_CP_R_ACC_D03_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_ACC_D03_DP
varchar(1)
True
False
False
 
WF_CP_R_ACC_D03_REL
varchar(1)
True
False
False
 
WF_CP_R_ACC_D03_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_ACC_D04_DATE
date(10, 0)
True
False
False
 
WF_CP_R_ACC_D04_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_ACC_D04_DP
varchar(1)
True
False
False
 
WF_CP_R_ACC_D04_REL
varchar(1)
True
False
False
 
WF_CP_R_ACC_D04_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_ACC_D05_DATE
date(10, 0)
True
False
False
 
WF_CP_R_ACC_D05_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_ACC_D05_DP
varchar(1)
True
False
False
 
WF_CP_R_ACC_D05_REL
varchar(1)
True
False
False
 
WF_CP_R_ACC_D05_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_ACC_D06_DATE
date(10, 0)
True
False
False
 
WF_CP_R_ACC_D06_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_ACC_D06_DP
varchar(1)
True
False
False
 
WF_CP_R_ACC_D06_REL
varchar(1)
True
False
False
 
WF_CP_R_ACC_D06_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_ACC_D07_DATE
date(10, 0)
True
False
False
 
WF_CP_R_ACC_D07_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_ACC_D07_DP
varchar(1)
True
False
False
 
WF_CP_R_ACC_D07_REL
varchar(1)
True
False
False
 
WF_CP_R_ACC_D07_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_ACC_D08_DATE
date(10, 0)
True
False
False
 
WF_CP_R_ACC_D08_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_ACC_D08_DP
varchar(1)
True
False
False
 
WF_CP_R_ACC_D08_REL
varchar(1)
True
False
False
 
WF_CP_R_ACC_D08_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_ACC_D09_DATE
date(10, 0)
True
False
False
 
WF_CP_R_ACC_D09_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_ACC_D09_DP
varchar(1)
True
False
False
 
WF_CP_R_ACC_D09_REL
varchar(1)
True
False
False
 
WF_CP_R_ACC_D09_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_ACC_D10_DATE
date(10, 0)
True
False
False
 
WF_CP_R_ACC_D10_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_ACC_D10_DP
varchar(1)
True
False
False
 
WF_CP_R_ACC_D10_REL
varchar(1)
True
False
False
 
WF_CP_R_ACC_D10_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_ACC_D11_DATE
date(10, 0)
True
False
False
 
WF_CP_R_ACC_D11_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_ACC_D11_DP
varchar(1)
True
False
False
 
WF_CP_R_ACC_D11_REL
varchar(1)
True
False
False
 
WF_CP_R_ACC_D11_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_ACC_D12_DATE
date(10, 0)
True
False
False
 
WF_CP_R_ACC_D12_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_ACC_D12_DP
varchar(1)
True
False
False
 
WF_CP_R_ACC_D12_REL
varchar(1)
True
False
False
 
WF_CP_R_ACC_D12_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_ACC_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_ACC_ENR_DATE
date(10, 0)
True
False
False
 
WF_CP_R_ACC_FC
decimal(5, 0)
True
False
False
 
WF_CP_R_ACC_ID
varchar(13)
True
False
False
 
WF_CP_R_ACC_VER
varchar(1)
True
False
False
 
WF_CP_R_AWARD
decimal(7, 2)
True
False
False
 
WF_CP_R_COST
decimal(5, 0)
True
False
False
 
WF_CP_R_D_ACK
varchar(1)
True
False
False
 
WF_CP_R_D_ACK_DATE
date(10, 0)
True
False
False
 
WF_CP_R_D_ACT
varchar(1)
True
False
False
 
WF_CP_R_D_ACT_DATE
date(10, 0)
True
False
False
 
WF_CP_R_D_ACT_RSN
varchar(2)
True
False
False
 
WF_CP_R_D_RPT_DATE
date(10, 0)
True
False
False
 
WF_CP_R_D01_DATE
date(10, 0)
True
False
False
 
WF_CP_R_D01_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_D01_DP
varchar(1)
True
False
False
 
WF_CP_R_D01_REL
varchar(1)
True
False
False
 
WF_CP_R_D01_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_D02_DATE
date(10, 0)
True
False
False
 
WF_CP_R_D02_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_D02_DP
varchar(1)
True
False
False
 
WF_CP_R_D02_REL
varchar(1)
True
False
False
 
WF_CP_R_D02_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_D03_DATE
date(10, 0)
True
False
False
 
WF_CP_R_D03_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_D03_DP
varchar(1)
True
False
False
 
WF_CP_R_D03_REL
varchar(1)
True
False
False
 
WF_CP_R_D03_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_D04_DATE
date(10, 0)
True
False
False
 
WF_CP_R_D04_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_D04_DP
varchar(1)
True
False
False
 
WF_CP_R_D04_REL
varchar(1)
True
False
False
 
WF_CP_R_D04_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_D05_DATE
date(10, 0)
True
False
False
 
WF_CP_R_D05_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_D05_DP
varchar(1)
True
False
False
 
WF_CP_R_D05_REL
varchar(1)
True
False
False
 
WF_CP_R_D05_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_D06_DATE
date(10, 0)
True
False
False
 
WF_CP_R_D06_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_D06_DP
varchar(1)
True
False
False
 
WF_CP_R_D06_REL
varchar(1)
True
False
False
 
WF_CP_R_D06_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_D07_DATE
date(10, 0)
True
False
False
 
WF_CP_R_D07_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_D07_DP
varchar(1)
True
False
False
 
WF_CP_R_D07_REL
varchar(1)
True
False
False
 
WF_CP_R_D07_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_D08_DATE
date(10, 0)
True
False
False
 
WF_CP_R_D08_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_D08_DP
varchar(1)
True
False
False
 
WF_CP_R_D08_REL
varchar(1)
True
False
False
 
WF_CP_R_D08_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_D09_DATE
date(10, 0)
True
False
False
 
WF_CP_R_D09_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_D09_DP
varchar(1)
True
False
False
 
WF_CP_R_D09_REL
varchar(1)
True
False
False
 
WF_CP_R_D09_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_D10_DATE
date(10, 0)
True
False
False
 
WF_CP_R_D10_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_D10_DP
varchar(1)
True
False
False
 
WF_CP_R_D10_REL
varchar(1)
True
False
False
 
WF_CP_R_D10_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_D11_DATE
date(10, 0)
True
False
False
 
WF_CP_R_D11_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_D11_DP
varchar(1)
True
False
False
 
WF_CP_R_D11_REL
varchar(1)
True
False
False
 
WF_CP_R_D11_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_D12_DATE
date(10, 0)
True
False
False
 
WF_CP_R_D12_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_D12_DP
varchar(1)
True
False
False
 
WF_CP_R_D12_REL
varchar(1)
True
False
False
 
WF_CP_R_D12_SEQ
int(10, 0)
True
False
False
 
WF_CP_R_DISB
decimal(7, 2)
True
False
False
 
WF_CP_R_ENR_DATE
date(10, 0)
True
False
False
 
WF_CP_R_FC
decimal(5, 0)
True
False
False
 
WF_CP_R_ID
varchar(13)
True
False
False
 
WF_CP_R_O_ACK
varchar(1)
True
False
False
 
WF_CP_R_O_ACK_DATE
date(10, 0)
True
False
False
 
WF_CP_R_O_ACT
varchar(1)
True
False
False
 
WF_CP_R_O_ACT_DATE
date(10, 0)
True
False
False
 
WF_CP_R_O_ACT_RSN
varchar(2)
True
False
False
 
WF_CP_R_O_RPT_DATE
date(10, 0)
True
False
False
 
WF_CP_R_SCH_GRANT
decimal(5, 0)
True
False
False
 
WF_CP_R_VER
varchar(1)
True
False
False
 
WF_CP_RA1_A_AWARD
decimal(7, 2)
True
False
False
 
WF_CP_RA1_A_DISB
decimal(7, 2)
True
False
False
 
WF_CP_RA1_A_ENR_DATE
date(10, 0)
True
False
False
 
WF_CP_RA1_A_FED_TRAN
varchar(2)
True
False
False
 
WF_CP_RA1_A_GRANT
int(10, 0)
True
False
False
 
WF_CP_RA1_A_HS_PROG
varchar(6)
True
False
False
 
WF_CP_RA1_A_PMT_RSN
varchar(2)
True
False
False
 
WF_CP_RA1_A_YR_COL
varchar(1)
True
False
False
 
WF_CP_RA1_D_ACK
varchar(1)
True
False
False
 
WF_CP_RA1_D_ACK_DATE
date(10, 0)
True
False
False
 
WF_CP_RA1_D_ACT
varchar(1)
True
False
False
 
WF_CP_RA1_D_ACT_DATE
date(10, 0)
True
False
False
 
WF_CP_RA1_D_ACT_RSN
varchar(2)
True
False
False
 
WF_CP_RA1_D_RPT_DATE
date(10, 0)
True
False
False
 
WF_CP_RA1_O_ACK
varchar(1)
True
False
False
 
WF_CP_RA1_O_ACK_DATE
date(10, 0)
True
False
False
 
WF_CP_RA1_O_ACT
varchar(1)
True
False
False
 
WF_CP_RA1_O_ACT_DATE
date(10, 0)
True
False
False
 
WF_CP_RA1_O_ACT_RSN
varchar(2)
True
False
False
 
WF_CP_RA1_O_RPT_DATE
date(10, 0)
True
False
False
 
WF_CP_RA1_R_AWARD
decimal(7, 2)
True
False
False
 
WF_CP_RA1_R_DISB
decimal(7, 2)
True
False
False
 
WF_CP_RA1_R_ENR_DATE
date(10, 0)
True
False
False
 
WF_CP_RA1_R_FED_TRAN
varchar(2)
True
False
False
 
WF_CP_RA1_R_GRANT
int(10, 0)
True
False
False
 
WF_CP_RA1_R_HS_PROG
varchar(6)
True
False
False
 
WF_CP_RA1_R_PMT_RSN
varchar(2)
True
False
False
 
WF_CP_RA1_R_YR_COL
varchar(1)
True
False
False
 
WF_CP_RA2_A_AWARD
decimal(7, 2)
True
False
False
 
WF_CP_RA2_A_DISB
decimal(7, 2)
True
False
False
 
WF_CP_RA2_A_ENR_DATE
date(10, 0)
True
False
False
 
WF_CP_RA2_A_FED_TRAN
varchar(2)
True
False
False
 
WF_CP_RA2_A_GRANT
int(10, 0)
True
False
False
 
WF_CP_RA2_A_HS_PROG
varchar(6)
True
False
False
 
WF_CP_RA2_A_PMT_RSN
varchar(2)
True
False
False
 
WF_CP_RA2_A_YR_COL
varchar(1)
True
False
False
 
WF_CP_RA2_D_ACK
varchar(1)
True
False
False
 
WF_CP_RA2_D_ACK_DATE
date(10, 0)
True
False
False
 
WF_CP_RA2_D_ACT
varchar(1)
True
False
False
 
WF_CP_RA2_D_ACT_DATE
date(10, 0)
True
False
False
 
WF_CP_RA2_D_ACT_RSN
varchar(2)
True
False
False
 
WF_CP_RA2_D_RPT_DATE
date(10, 0)
True
False
False
 
WF_CP_RA2_O_ACK
varchar(1)
True
False
False
 
WF_CP_RA2_O_ACK_DATE
date(10, 0)
True
False
False
 
WF_CP_RA2_O_ACT
varchar(1)
True
False
False
 
WF_CP_RA2_O_ACT_DATE
date(10, 0)
True
False
False
 
WF_CP_RA2_O_ACT_RSN
varchar(2)
True
False
False
 
WF_CP_RA2_O_RPT_DATE
date(10, 0)
True
False
False
 
WF_CP_RA2_R_AWARD
decimal(7, 2)
True
False
False
 
WF_CP_RA2_R_DISB
decimal(7, 2)
True
False
False
 
WF_CP_RA2_R_ENR_DATE
date(10, 0)
True
False
False
 
WF_CP_RA2_R_FED_TRAN
varchar(2)
True
False
False
 
WF_CP_RA2_R_GRANT
int(10, 0)
True
False
False
 
WF_CP_RA2_R_HS_PROG
varchar(6)
True
False
False
 
WF_CP_RA2_R_PMT_RSN
varchar(2)
True
False
False
 
WF_CP_RA2_R_YR_COL
varchar(1)
True
False
False
 
WF_CP_RS1_A_AWARD
decimal(7, 2)
True
False
False
 
WF_CP_RS1_A_CIP
varchar(7)
True
False
False
 
WF_CP_RS1_A_DISB
decimal(7, 2)
True
False
False
 
WF_CP_RS1_A_ENR_DATE
date(10, 0)
True
False
False
 
WF_CP_RS1_A_FED_TRAN
varchar(2)
True
False
False
 
WF_CP_RS1_A_GRANT
int(10, 0)
True
False
False
 
WF_CP_RS1_A_YR_COL
varchar(1)
True
False
False
 
WF_CP_RS1_D_ACK
varchar(1)
True
False
False
 
WF_CP_RS1_D_ACK_DATE
date(10, 0)
True
False
False
 
WF_CP_RS1_D_ACT
varchar(1)
True
False
False
 
WF_CP_RS1_D_ACT_DATE
date(10, 0)
True
False
False
 
WF_CP_RS1_D_ACT_RSN
varchar(2)
True
False
False
 
WF_CP_RS1_D_RPT_DATE
date(10, 0)
True
False
False
 
WF_CP_RS1_O_ACK
varchar(1)
True
False
False
 
WF_CP_RS1_O_ACK_DATE
date(10, 0)
True
False
False
 
WF_CP_RS1_O_ACT
varchar(1)
True
False
False
 
WF_CP_RS1_O_ACT_DATE
date(10, 0)
True
False
False
 
WF_CP_RS1_O_ACT_RSN
varchar(2)
True
False
False
 
WF_CP_RS1_O_RPT_DATE
date(10, 0)
True
False
False
 
WF_CP_RS1_R_AWARD
decimal(7, 2)
True
False
False
 
WF_CP_RS1_R_CIP
varchar(7)
True
False
False
 
WF_CP_RS1_R_DISB
decimal(7, 2)
True
False
False
 
WF_CP_RS1_R_ENR_DATE
date(10, 0)
True
False
False
 
WF_CP_RS1_R_FED_TRAN
varchar(2)
True
False
False
 
WF_CP_RS1_R_GRANT
int(10, 0)
True
False
False
 
WF_CP_RS1_R_YR_COL
varchar(1)
True
False
False
 
WF_CP_RS2_A_AWARD
decimal(7, 2)
True
False
False
 
WF_CP_RS2_A_CIP
varchar(7)
True
False
False
 
WF_CP_RS2_A_DISB
decimal(7, 2)
True
False
False
 
WF_CP_RS2_A_ENR_DATE
date(10, 0)
True
False
False
 
WF_CP_RS2_A_FED_TRAN
varchar(2)
True
False
False
 
WF_CP_RS2_A_GRANT
int(10, 0)
True
False
False
 
WF_CP_RS2_A_YR_COL
varchar(1)
True
False
False
 
WF_CP_RS2_D_ACK
varchar(1)
True
False
False
 
WF_CP_RS2_D_ACK_DATE
date(10, 0)
True
False
False
 
WF_CP_RS2_D_ACT
varchar(1)
True
False
False
 
WF_CP_RS2_D_ACT_DATE
date(10, 0)
True
False
False
 
WF_CP_RS2_D_ACT_RSN
varchar(2)
True
False
False
 
WF_CP_RS2_D_RPT_DATE
date(10, 0)
True
False
False
 
WF_CP_RS2_O_ACK
varchar(1)
True
False
False
 
WF_CP_RS2_O_ACK_DATE
date(10, 0)
True
False
False
 
WF_CP_RS2_O_ACT
varchar(1)
True
False
False
 
WF_CP_RS2_O_ACT_DATE
date(10, 0)
True
False
False
 
WF_CP_RS2_O_ACT_RSN
varchar(2)
True
False
False
 
WF_CP_RS2_O_RPT_DATE
date(10, 0)
True
False
False
 
WF_CP_RS2_R_AWARD
decimal(7, 2)
True
False
False
 
WF_CP_RS2_R_CIP
varchar(7)
True
False
False
 
WF_CP_RS2_R_DISB
decimal(7, 2)
True
False
False
 
WF_CP_RS2_R_ENR_DATE
date(10, 0)
True
False
False
 
WF_CP_RS2_R_FED_TRAN
varchar(2)
True
False
False
 
WF_CP_RS2_R_GRANT
int(10, 0)
True
False
False
 
WF_CP_RS2_R_YR_COL
varchar(1)
True
False
False
 
WF_FAO
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
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_WF_CPS_0607
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.WF_CPS_0607 depends on)
Name Type
  Child Dependencies (objects that depend on dbo.WF_CPS_0607)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[WF_CPS_0607] Script Date: 03/09/2017 16:46:40 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[WF_CPS_0607](
    [ISN_WF_CPS_0607] [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_CP_FED_ID] [varchar](13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_DRN] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_COLLEGE] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_A_VER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_A_DEP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_A_FC1] [decimal](7, 0) NULL,
    [WF_CP_A_FC2] [decimal](7, 0) NULL,
    [WF_CP_A_SANAL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_A_SC] [decimal](7, 0) NULL,
    [WF_CP_A_SCI] [decimal](7, 0) NULL,
    [WF_CP_A_SCA] [decimal](7, 0) NULL,
    [WF_CP_A_PANAL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_A_PC] [decimal](7, 0) NULL,
    [WF_CP_A_PCI] [decimal](7, 0) NULL,
    [WF_CP_A_PCA] [decimal](7, 0) NULL,
    [WF_CP_A_FISAP] [decimal](7, 0) NULL,
    [WF_CP_C_EFC_ADJ] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_C_DEF_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_SCH_GRANT] [decimal](5, 0) NULL,
    [WF_CP_R_O_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_O_ACT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_O_ACT_DATE] [date] NULL,
    [WF_CP_R_O_RPT_DATE] [date] NULL,
    [WF_CP_R_O_ACK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_O_ACK_DATE] [date] NULL,
    [WF_CP_R_D_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D_ACT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D_ACT_DATE] [date] NULL,
    [WF_CP_R_D_RPT_DATE] [date] NULL,
    [WF_CP_R_D_ACK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D_ACK_DATE] [date] NULL,
    [WF_CP_R_ID] [varchar](13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_FC] [decimal](5, 0) NULL,
    [WF_CP_R_COST] [decimal](5, 0) NULL,
    [WF_CP_R_VER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ENR_DATE] [date] NULL,
    [WF_CP_R_AWARD] [decimal](7, 2) NULL,
    [WF_CP_R_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_D01_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D01_SEQ] [int] NULL,
    [WF_CP_R_D01_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_D01_DATE] [date] NULL,
    [WF_CP_R_D01_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D02_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D02_SEQ] [int] NULL,
    [WF_CP_R_D02_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_D02_DATE] [date] NULL,
    [WF_CP_R_D02_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D03_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D03_SEQ] [int] NULL,
    [WF_CP_R_D03_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_D03_DATE] [date] NULL,
    [WF_CP_R_D03_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D04_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D04_SEQ] [int] NULL,
    [WF_CP_R_D04_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_D04_DATE] [date] NULL,
    [WF_CP_R_D04_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D05_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D05_SEQ] [int] NULL,
    [WF_CP_R_D05_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_D05_DATE] [date] NULL,
    [WF_CP_R_D05_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D06_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D06_SEQ] [int] NULL,
    [WF_CP_R_D06_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_D06_DATE] [date] NULL,
    [WF_CP_R_D06_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D07_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D07_SEQ] [int] NULL,
    [WF_CP_R_D07_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_D07_DATE] [date] NULL,
    [WF_CP_R_D07_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D08_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D08_SEQ] [int] NULL,
    [WF_CP_R_D08_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_D08_DATE] [date] NULL,
    [WF_CP_R_D08_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D09_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D09_SEQ] [int] NULL,
    [WF_CP_R_D09_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_D09_DATE] [date] NULL,
    [WF_CP_R_D09_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D10_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D10_SEQ] [int] NULL,
    [WF_CP_R_D10_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_D10_DATE] [date] NULL,
    [WF_CP_R_D10_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D11_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D11_SEQ] [int] NULL,
    [WF_CP_R_D11_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_D11_DATE] [date] NULL,
    [WF_CP_R_D11_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D12_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_D12_SEQ] [int] NULL,
    [WF_CP_R_D12_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_D12_DATE] [date] NULL,
    [WF_CP_R_D12_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_ID] [varchar](13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_FC] [decimal](5, 0) NULL,
    [WF_CP_R_ACC_COST] [decimal](5, 0) NULL,
    [WF_CP_R_ACC_VER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_ENR_DATE] [date] NULL,
    [WF_CP_R_ACC_AWARD] [decimal](7, 2) NULL,
    [WF_CP_R_ACC_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_ACC_D01_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D01_SEQ] [int] NULL,
    [WF_CP_R_ACC_D01_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_ACC_D01_DATE] [date] NULL,
    [WF_CP_R_ACC_D01_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D02_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D02_SEQ] [int] NULL,
    [WF_CP_R_ACC_D02_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_ACC_D02_DATE] [date] NULL,
    [WF_CP_R_ACC_D02_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D03_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D03_SEQ] [int] NULL,
    [WF_CP_R_ACC_D03_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_ACC_D03_DATE] [date] NULL,
    [WF_CP_R_ACC_D03_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D04_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D04_SEQ] [int] NULL,
    [WF_CP_R_ACC_D04_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_ACC_D04_DATE] [date] NULL,
    [WF_CP_R_ACC_D04_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D05_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D05_SEQ] [int] NULL,
    [WF_CP_R_ACC_D05_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_ACC_D05_DATE] [date] NULL,
    [WF_CP_R_ACC_D05_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D06_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D06_SEQ] [int] NULL,
    [WF_CP_R_ACC_D06_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_ACC_D06_DATE] [date] NULL,
    [WF_CP_R_ACC_D06_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D07_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D07_SEQ] [int] NULL,
    [WF_CP_R_ACC_D07_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_ACC_D07_DATE] [date] NULL,
    [WF_CP_R_ACC_D07_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D08_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D08_SEQ] [int] NULL,
    [WF_CP_R_ACC_D08_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_ACC_D08_DATE] [date] NULL,
    [WF_CP_R_ACC_D08_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D09_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D09_SEQ] [int] NULL,
    [WF_CP_R_ACC_D09_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_ACC_D09_DATE] [date] NULL,
    [WF_CP_R_ACC_D09_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D10_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D10_SEQ] [int] NULL,
    [WF_CP_R_ACC_D10_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_ACC_D10_DATE] [date] NULL,
    [WF_CP_R_ACC_D10_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D11_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D11_SEQ] [int] NULL,
    [WF_CP_R_ACC_D11_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_ACC_D11_DATE] [date] NULL,
    [WF_CP_R_ACC_D11_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D12_DP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_R_ACC_D12_SEQ] [int] NULL,
    [WF_CP_R_ACC_D12_DISB] [decimal](7, 2) NULL,
    [WF_CP_R_ACC_D12_DATE] [date] NULL,
    [WF_CP_R_ACC_D12_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA1_O_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA1_O_ACT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA1_O_ACT_DATE] [date] NULL,
    [WF_CP_RA1_O_RPT_DATE] [date] NULL,
    [WF_CP_RA1_O_ACK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA1_O_ACK_DATE] [date] NULL,
    [WF_CP_RA1_D_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA1_D_ACT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA1_D_ACT_DATE] [date] NULL,
    [WF_CP_RA1_D_RPT_DATE] [date] NULL,
    [WF_CP_RA1_D_ACK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA1_D_ACK_DATE] [date] NULL,
    [WF_CP_RA1_R_GRANT] [int] NULL,
    [WF_CP_RA1_R_PMT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA1_R_HS_PROG] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA1_R_FED_TRAN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA1_R_YR_COL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA1_R_ENR_DATE] [date] NULL,
    [WF_CP_RA1_R_AWARD] [decimal](7, 2) NULL,
    [WF_CP_RA1_R_DISB] [decimal](7, 2) NULL,
    [WF_CP_RA1_A_GRANT] [int] NULL,
    [WF_CP_RA1_A_PMT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA1_A_HS_PROG] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA1_A_FED_TRAN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA1_A_YR_COL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA1_A_ENR_DATE] [date] NULL,
    [WF_CP_RA1_A_AWARD] [decimal](7, 2) NULL,
    [WF_CP_RA1_A_DISB] [decimal](7, 2) NULL,
    [WF_CP_RA2_O_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA2_O_ACT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA2_O_ACT_DATE] [date] NULL,
    [WF_CP_RA2_O_RPT_DATE] [date] NULL,
    [WF_CP_RA2_O_ACK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA2_O_ACK_DATE] [date] NULL,
    [WF_CP_RA2_D_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA2_D_ACT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA2_D_ACT_DATE] [date] NULL,
    [WF_CP_RA2_D_RPT_DATE] [date] NULL,
    [WF_CP_RA2_D_ACK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA2_D_ACK_DATE] [date] NULL,
    [WF_CP_RA2_R_GRANT] [int] NULL,
    [WF_CP_RA2_R_PMT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA2_R_HS_PROG] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA2_R_FED_TRAN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA2_R_YR_COL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA2_R_ENR_DATE] [date] NULL,
    [WF_CP_RA2_R_AWARD] [decimal](7, 2) NULL,
    [WF_CP_RA2_R_DISB] [decimal](7, 2) NULL,
    [WF_CP_RA2_A_GRANT] [int] NULL,
    [WF_CP_RA2_A_PMT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA2_A_HS_PROG] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA2_A_FED_TRAN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA2_A_YR_COL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA2_A_ENR_DATE] [date] NULL,
    [WF_CP_RA2_A_AWARD] [decimal](7, 2) NULL,
    [WF_CP_RA2_A_DISB] [decimal](7, 2) NULL,
    [WF_CP_RS1_O_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS1_O_ACT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS1_O_ACT_DATE] [date] NULL,
    [WF_CP_RS1_O_RPT_DATE] [date] NULL,
    [WF_CP_RS1_O_ACK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS1_O_ACK_DATE] [date] NULL,
    [WF_CP_RS1_D_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS1_D_ACT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS1_D_ACT_DATE] [date] NULL,
    [WF_CP_RS1_D_RPT_DATE] [date] NULL,
    [WF_CP_RS1_D_ACK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS1_D_ACK_DATE] [date] NULL,
    [WF_CP_RS1_R_GRANT] [int] NULL,
    [WF_CP_RS1_R_CIP] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS1_R_FED_TRAN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS1_R_YR_COL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS1_R_ENR_DATE] [date] NULL,
    [WF_CP_RS1_R_AWARD] [decimal](7, 2) NULL,
    [WF_CP_RS1_R_DISB] [decimal](7, 2) NULL,
    [WF_CP_RS1_A_GRANT] [int] NULL,
    [WF_CP_RS1_A_CIP] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS1_A_FED_TRAN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS1_A_YR_COL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS1_A_ENR_DATE] [date] NULL,
    [WF_CP_RS1_A_AWARD] [decimal](7, 2) NULL,
    [WF_CP_RS1_A_DISB] [decimal](7, 2) NULL,
    [WF_CP_RS2_O_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS2_O_ACT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS2_O_ACT_DATE] [date] NULL,
    [WF_CP_RS2_O_RPT_DATE] [date] NULL,
    [WF_CP_RS2_O_ACK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS2_O_ACK_DATE] [date] NULL,
    [WF_CP_RS2_D_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS2_D_ACT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS2_D_ACT_DATE] [date] NULL,
    [WF_CP_RS2_D_RPT_DATE] [date] NULL,
    [WF_CP_RS2_D_ACK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS2_D_ACK_DATE] [date] NULL,
    [WF_CP_RS2_R_GRANT] [int] NULL,
    [WF_CP_RS2_R_CIP] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS2_R_FED_TRAN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS2_R_YR_COL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS2_R_ENR_DATE] [date] NULL,
    [WF_CP_RS2_R_AWARD] [decimal](7, 2) NULL,
    [WF_CP_RS2_R_DISB] [decimal](7, 2) NULL,
    [WF_CP_RS2_A_GRANT] [int] NULL,
    [WF_CP_RS2_A_CIP] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS2_A_FED_TRAN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS2_A_YR_COL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS2_A_ENR_DATE] [date] NULL,
    [WF_CP_RS2_A_AWARD] [decimal](7, 2) NULL,
    [WF_CP_RS2_A_DISB] [decimal](7, 2) NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ISN_WF_CPS_0607 RowUpdatedOn WF_CP_A_DEP WF_CP_A_FC1 WF_CP_A_FC2 WF_CP_A_FISAP WF_CP_A_PANAL WF_CP_A_PC WF_CP_A_PCI WF_CP_A_SANAL WF_CP_A_SC WF_CP_A_SCA WF_CP_A_SCI WF_CP_A_VER WF_CP_C_DEF_OVR WF_CP_C_EFC_ADJ WF_CP_COLLEGE WF_CP_DRN WF_CP_FED_ID WF_CP_R_ACC_AWARD WF_CP_R_ACC_COST WF_CP_R_ACC_D01_DATE WF_CP_R_ACC_D01_DISB WF_CP_R_ACC_D01_DP WF_CP_R_ACC_D01_REL WF_CP_R_ACC_D01_SEQ WF_CP_R_ACC_D02_DATE WF_CP_R_ACC_D02_DISB WF_CP_R_ACC_D02_DP WF_CP_R_ACC_D02_REL WF_CP_R_ACC_D02_SEQ WF_CP_R_ACC_D03_DATE WF_CP_R_ACC_D03_DISB WF_CP_R_ACC_D03_DP WF_CP_R_ACC_D03_REL WF_CP_R_ACC_D03_SEQ WF_CP_R_ACC_D04_DP WF_CP_R_ACC_D04_REL WF_CP_R_ACC_D05_DP WF_CP_R_ACC_D05_REL WF_CP_R_ACC_D06_DP WF_CP_R_ACC_D06_REL WF_CP_R_ACC_D07_DP WF_CP_R_ACC_D07_REL WF_CP_R_ACC_D08_DP WF_CP_R_ACC_D08_REL WF_CP_R_ACC_D09_DP WF_CP_R_ACC_D09_REL WF_CP_R_ACC_D10_DP WF_CP_R_ACC_D10_REL WF_CP_R_ACC_D11_DP WF_CP_R_ACC_D11_REL WF_CP_R_ACC_D12_DP WF_CP_R_ACC_D12_REL WF_CP_R_ACC_DISB WF_CP_R_ACC_ENR_DATE WF_CP_R_ACC_ID WF_CP_R_ACC_VER WF_CP_R_D_ACK WF_CP_R_D_ACK_DATE WF_CP_R_D_ACT WF_CP_R_D_ACT_RSN WF_CP_R_D_RPT_DATE WF_CP_R_D01_DP WF_CP_R_D01_REL WF_CP_R_D02_DP WF_CP_R_D02_REL WF_CP_R_D03_DP WF_CP_R_D03_REL WF_CP_R_D04_DP WF_CP_R_D04_REL WF_CP_R_D05_DP WF_CP_R_D05_REL WF_CP_R_D06_DP WF_CP_R_D06_REL WF_CP_R_D07_DP WF_CP_R_D07_REL WF_CP_R_D08_DP WF_CP_R_D08_REL WF_CP_R_D09_DP WF_CP_R_D09_REL WF_CP_R_D10_DP WF_CP_R_D10_REL WF_CP_R_D11_DP WF_CP_R_D11_REL WF_CP_R_D12_DP WF_CP_R_D12_REL WF_CP_R_ID WF_CP_R_O_ACK WF_CP_R_O_ACK_DATE WF_CP_R_O_ACT WF_CP_R_O_ACT_RSN WF_CP_R_O_RPT_DATE WF_CP_R_SCH_GRANT WF_CP_R_VER WF_CP_RA1_A_FED_TRAN WF_CP_RA1_A_HS_PROG WF_CP_RA1_A_PMT_RSN WF_CP_RA1_A_YR_COL WF_CP_RA1_D_ACK WF_CP_RA1_D_ACT WF_CP_RA1_D_ACT_RSN WF_CP_RA1_O_ACK WF_CP_RA1_O_ACT WF_CP_RA1_O_ACT_RSN WF_CP_RA1_R_FED_TRAN WF_CP_RA1_R_HS_PROG WF_CP_RA1_R_PMT_RSN WF_CP_RA1_R_YR_COL WF_CP_RA2_A_FED_TRAN WF_CP_RA2_A_HS_PROG WF_CP_RA2_A_PMT_RSN WF_CP_RA2_A_YR_COL WF_CP_RA2_D_ACK WF_CP_RA2_D_ACT WF_CP_RA2_D_ACT_RSN WF_CP_RA2_O_ACK WF_CP_RA2_O_ACT WF_CP_RA2_O_ACT_RSN WF_CP_RA2_R_FED_TRAN WF_CP_RA2_R_HS_PROG WF_CP_RA2_R_PMT_RSN WF_CP_RA2_R_YR_COL WF_CP_RS1_A_CIP WF_CP_RS1_A_FED_TRAN WF_CP_RS1_A_YR_COL WF_CP_RS1_D_ACK WF_CP_RS1_D_ACT WF_CP_RS1_D_ACT_RSN WF_CP_RS1_O_ACK WF_CP_RS1_O_ACT WF_CP_RS1_O_ACT_RSN WF_CP_RS1_R_CIP WF_CP_RS1_R_FED_TRAN WF_CP_RS1_R_YR_COL WF_CP_RS2_A_CIP WF_CP_RS2_A_FED_TRAN WF_CP_RS2_A_YR_COL WF_CP_RS2_D_ACK WF_CP_RS2_D_ACT WF_CP_RS2_D_ACT_RSN WF_CP_RS2_O_ACK WF_CP_RS2_O_ACT WF_CP_RS2_O_ACT_RSN WF_CP_RS2_R_CIP WF_CP_RS2_R_FED_TRAN WF_CP_RS2_R_YR_COL WF_FAO WW_CDATE WW_HOLD WW_MDATE WW_STUDENT_ID
131 2017-02-06T11:19:40.877-05:00 I 347 99999 33527 R 347 N 001512 264977904KN01 PB 2006-03-28T00:00:00-05:00 1621045 57570632272158922C
4398 2017-02-06T11:19:43.498-05:00 D 6288 99999 59881 R 6288 6288 R N 001512 011701842CA02 PB 2006-07-11T00:00:00-04:00 1220163 57570632900159177C
9306 2017-02-06T11:19:46.618-05:00 I 5553 5640 28000 S 5553 N 001512 022628373FA02 PB 2006-11-07T00:00:00-05:00 1225515 57570631206933235C
135 2017-02-06T11:19:40.877-05:00 I 5563 5563 18076 S 5563 Y 001512 266930284JA03 PB 2006-03-28T00:00:00-05:00 1621110 57570630948379631C
5642 2017-02-06T11:19:44.356-05:00 I 9139 99999 30096 S 9139 N 001512 576082900FR01 PB 2006-07-26T00:00:00-04:00 1505058 57570630995324122C
1547 2017-02-06T11:19:41.813-05:00 I 976 976 7742 S 976 N 001512 769260682JE01 PB 2006-03-30T00:00:00-05:00 1421335 57570632744028657C
3383 2017-02-06T11:19:42.889-05:00 D 99999 14457 R R Y 001512 589804818DA02 4050.00 11250 2006-09-21T00:00:00-04:00 1519.00 1 Y 1 2007-01-29T00:00:00-05:00 1519.00 2 Y 1 2007-06-26T00:00:00-04:00 1012.00 3 Y 2 4050.00 2006-08-23T00:00:00-04:00 589804818DA02 V A 2007-06-26T00:00:00-04:00 2007-06-26T00:00:00-04:00 A 2007-06-26T00:00:00-04:00 2007-04-04T00:00:00-04:00 4050 PB 2006-06-01T00:00:00-04:00 1438565 2007-07-05T00:00:00-04:00 57570632945416972C
5003 2017-02-06T11:19:43.981-05:00 D 4069 99999 71599 R 1966 1966 R 2103 23 2080 N 001512 591583832ED01 PB 2006-07-17T00:00:00-04:00 1418284 57570632229743961C
10788 2017-02-06T11:19:47.507-05:00 I 99999 20754 Z Y 001512 264278800RE04 1013.00 13700 2007-01-29T00:00:00-05:00 507.00 2 Y 1 2007-05-30T00:00:00-04:00 506.00 3 Y 1 1013.00 2006-08-23T00:00:00-04:00 264278800RE04 V A 2007-05-31T00:00:00-04:00 2007-05-31T00:00:00-04:00 A 2007-05-31T00:00:00-04:00 2007-03-26T00:00:00-04:00 4050 PB 2006-04-10T00:00:00-04:00 926069 2007-06-05T00:00:00-04:00 57570631726984392C
8181 2017-02-06T11:19:45.962-05:00 I S Y 001512 592482674CO02 4050.00 13700 2006-09-21T00:00:00-04:00 2025.00 1 Y 1 2007-01-29T00:00:00-05:00 2025.00 2 Y 1 4050.00 2006-08-23T00:00:00-04:00 592482674CO02 V A 2007-01-29T00:00:00-05:00 2007-01-29T00:00:00-05:00 A 2007-01-29T00:00:00-05:00 2006-09-15T00:00:00-04:00 4050 PB 2006-03-30T00:00:00-05:00 904003 2007-02-01T00:00:00-05:00 57570632733685228C
Powered by BI Documenter