DWStaging
 dbo.WF_CPS_0809 (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_0809
  Properties
Property Value
Name WF_CPS_0809
Schema dbo
Row Count 20583
Data Size 3608 KB
Index Size 352 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_0809
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_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_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_ACT
varchar(1)
True
False
False
 
WF_CP_RA1_ACT_DATE
date(10, 0)
True
False
False
 
WF_CP_RA1_ACT_RSN
varchar(2)
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_O_ACK
varchar(1)
True
False
False
 
WF_CP_RA1_O_ACK_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_RA1_RPT_DATE
date(10, 0)
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_ACT
varchar(1)
True
False
False
 
WF_CP_RA2_ACT_DATE
date(10, 0)
True
False
False
 
WF_CP_RA2_ACT_RSN
varchar(2)
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_O_ACK
varchar(1)
True
False
False
 
WF_CP_RA2_O_ACK_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_RA2_RPT_DATE
date(10, 0)
True
False
False
 
WF_CP_RP_A_AWARD
decimal(7, 2)
True
False
False
 
WF_CP_RP_A_COST
decimal(5, 0)
True
False
False
 
WF_CP_RP_A_DISB
decimal(7, 2)
True
False
False
 
WF_CP_RP_A_ENR_DATE
date(10, 0)
True
False
False
 
WF_CP_RP_A_FED_TRAN
varchar(2)
True
False
False
 
WF_CP_RP_A_VER
varchar(1)
True
False
False
 
WF_CP_RP_ACT
varchar(1)
True
False
False
 
WF_CP_RP_ACT_DATE
date(10, 0)
True
False
False
 
WF_CP_RP_ACT_RSN
varchar(2)
True
False
False
 
WF_CP_RP_D_ACK
varchar(1)
True
False
False
 
WF_CP_RP_D_ACK_DATE
date(10, 0)
True
False
False
 
WF_CP_RP_O_ACK
varchar(1)
True
False
False
 
WF_CP_RP_O_ACK_DATE
date(10, 0)
True
False
False
 
WF_CP_RP_R_AWARD
decimal(7, 2)
True
False
False
 
WF_CP_RP_R_COST
decimal(5, 0)
True
False
False
 
WF_CP_RP_R_DISB
decimal(7, 2)
True
False
False
 
WF_CP_RP_R_ENR_DATE
date(10, 0)
True
False
False
 
WF_CP_RP_R_FED_TRAN
varchar(2)
True
False
False
 
WF_CP_RP_R_VER
varchar(1)
True
False
False
 
WF_CP_RP_RPT_DATE
date(10, 0)
True
False
False
 
WF_CP_RP_SCH_GRANT
decimal(5, 0)
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_ACT
varchar(1)
True
False
False
 
WF_CP_RS1_ACT_DATE
date(10, 0)
True
False
False
 
WF_CP_RS1_ACT_RSN
varchar(2)
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_O_ACK
varchar(1)
True
False
False
 
WF_CP_RS1_O_ACK_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_RS1_RPT_DATE
date(10, 0)
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_ACT
varchar(1)
True
False
False
 
WF_CP_RS2_ACT_DATE
date(10, 0)
True
False
False
 
WF_CP_RS2_ACT_RSN
varchar(2)
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_O_ACK
varchar(1)
True
False
False
 
WF_CP_RS2_O_ACK_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_CP_RS2_RPT_DATE
date(10, 0)
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_0809
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.WF_CPS_0809 depends on)
Name Type
  Child Dependencies (objects that depend on dbo.WF_CPS_0809)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[WF_CPS_0809] Script Date: 03/09/2017 16:46:41 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[WF_CPS_0809](
    [ISN_WF_CPS_0809] [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_DEF_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RP_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RP_ACT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RP_ACT_DATE] [date] NULL,
    [WF_CP_RP_RPT_DATE] [date] NULL,
    [WF_CP_RP_O_ACK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RP_O_ACK_DATE] [date] NULL,
    [WF_CP_RP_D_ACK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RP_D_ACK_DATE] [date] NULL,
    [WF_CP_RP_R_FED_TRAN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RP_R_COST] [decimal](5, 0) NULL,
    [WF_CP_RP_R_VER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RP_R_ENR_DATE] [date] NULL,
    [WF_CP_RP_R_AWARD] [decimal](7, 2) NULL,
    [WF_CP_RP_R_DISB] [decimal](7, 2) NULL,
    [WF_CP_RP_A_FED_TRAN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RP_A_COST] [decimal](5, 0) NULL,
    [WF_CP_RP_A_VER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RP_A_ENR_DATE] [date] NULL,
    [WF_CP_RP_A_AWARD] [decimal](7, 2) NULL,
    [WF_CP_RP_A_DISB] [decimal](7, 2) NULL,
    [WF_CP_RP_SCH_GRANT] [decimal](5, 0) NULL,
    [WF_CP_RA1_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA1_ACT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA1_ACT_DATE] [date] NULL,
    [WF_CP_RA1_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_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_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA2_ACT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RA2_ACT_DATE] [date] NULL,
    [WF_CP_RA2_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_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_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS1_ACT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS1_ACT_DATE] [date] NULL,
    [WF_CP_RS1_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_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_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS2_ACT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RS2_ACT_DATE] [date] NULL,
    [WF_CP_RS2_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_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_0809 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_PCA 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_COLLEGE WF_CP_DRN WF_CP_FED_ID 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_ACT WF_CP_RA1_ACT_RSN WF_CP_RA1_D_ACK WF_CP_RA1_O_ACK 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_ACT WF_CP_RA2_ACT_RSN WF_CP_RA2_D_ACK WF_CP_RA2_O_ACK 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_RP_A_AWARD WF_CP_RP_A_COST WF_CP_RP_A_DISB WF_CP_RP_A_ENR_DATE WF_CP_RP_A_FED_TRAN WF_CP_RP_A_VER WF_CP_RP_ACT WF_CP_RP_ACT_RSN WF_CP_RP_D_ACK WF_CP_RP_D_ACK_DATE WF_CP_RP_O_ACK WF_CP_RP_O_ACK_DATE WF_CP_RP_R_FED_TRAN WF_CP_RP_R_VER WF_CP_RP_RPT_DATE WF_CP_RP_SCH_GRANT WF_CP_RS1_A_CIP WF_CP_RS1_A_FED_TRAN WF_CP_RS1_A_YR_COL WF_CP_RS1_ACT WF_CP_RS1_ACT_RSN WF_CP_RS1_D_ACK WF_CP_RS1_O_ACK 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_ACT WF_CP_RS2_ACT_RSN WF_CP_RS2_D_ACK WF_CP_RS2_O_ACK 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
3078 2017-02-06T11:16:51.428-05:00 D 99999 26408 Z Z N 001512 075940878TO01 4731.00 13150 4731.00 2008-08-22T00:00:00-04:00 01 A 2009-02-17T00:00:00-05:00 A 2008-09-19T00:00:00-04:00 2009-02-17T00:00:00-05:00 4731 PB 2008-04-16T00:00:00-04:00 831463 2009-02-18T00:00:00-05:00 57570633622563306C
18007 2017-02-06T11:16:55.843-05:00 I 99999 11907 Z Y 001512 772056049LU01 PB 2009-01-09T00:00:00-05:00 959544 57570633454198777C
8253 2017-02-06T11:16:52.864-05:00 I 2098 99999 11217 R 2098 N 001512 766264964JA01 PB 2008-07-10T00:00:00-04:00 1652463 57570633828415663C
16828 2017-02-06T11:16:55.453-05:00 D 35984 99999 108496 R 32674 29268 3406 R 3310 1 3309 N 001512 590842032BA04 PB 2008-12-04T00:00:00-05:00 1255141 57570633955281140C
15590 2017-02-06T11:16:55.079-05:00 I 99999 18176 Z N 001512 769344520LE01 2957.00 16200 2957.00 2008-08-22T00:00:00-04:00 01 A 2009-07-02T00:00:00-04:00 A 2009-06-23T00:00:00-04:00 2009-07-02T00:00:00-04:00 4731 PB 2008-10-09T00:00:00-04:00 909475 2009-07-06T00:00:00-04:00 57570633906738992C
14874 2017-02-06T11:16:54.829-05:00 D 99999 15933 Z Z Y 001512 592583857KI01 PB 2008-10-06T00:00:00-04:00 932373 57570633904183573C
4744 2017-02-06T11:16:51.865-05:00 D 21096 99999 105291 R 18618 18618 R 2478 70 2408 N 001512 595740339SM01 PB 2008-05-13T00:00:00-04:00 1815133 57570633778353132C
5515 2017-02-06T11:16:52.084-05:00 D 63 99999 24821 R 63 63 R Y 001512 766445041IV01 4681.00 13150 4681.00 2008-08-22T00:00:00-04:00 01 V A 2009-02-03T00:00:00-05:00 A 2008-09-19T00:00:00-04:00 2009-02-03T00:00:00-05:00 4681 PB 2008-05-28T00:00:00-04:00 833355 2009-02-04T00:00:00-05:00 57570633547367280C
449 2017-02-06T11:16:50.68-05:00 D 26416 99999 110820 R 26176 26176 R 240 240 N 001512 144880811KR01 PB 2008-04-01T00:00:00-04:00 1529234 57570633722961996C
7558 2017-02-06T11:16:52.661-05:00 I 850 99999 25182 S 850 N 001512 263792515BA01 2911.00 16200 2911.00 2008-08-22T00:00:00-04:00 01 A 2009-06-01T00:00:00-04:00 A 2009-05-20T00:00:00-04:00 2009-06-01T00:00:00-04:00 3881 PB 2009-04-15T00:00:00-04:00 1553500 2009-06-02T00:00:00-04:00 57570634069220888C
Powered by BI Documenter