DWStaging
 dbo.WF_CPS_0708 (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_0708
  Properties
Property Value
Name WF_CPS_0708
Schema dbo
Row Count 15195
Data Size 2864 KB
Index Size 272 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_0708
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_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_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_D_ACK
varchar(1)
True
False
False
 
WF_CP_RP_D_ACK_DATE
date(10, 0)
True
False
False
 
WF_CP_RP_D_ACT
varchar(1)
True
False
False
 
WF_CP_RP_D_ACT_DATE
date(10, 0)
True
False
False
 
WF_CP_RP_D_ACT_RSN
varchar(2)
True
False
False
 
WF_CP_RP_D_RPT_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_O_ACT
varchar(1)
True
False
False
 
WF_CP_RP_O_ACT_DATE
date(10, 0)
True
False
False
 
WF_CP_RP_O_ACT_RSN
varchar(2)
True
False
False
 
WF_CP_RP_O_RPT_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_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_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_0708
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.WF_CPS_0708 depends on)
Name Type
  Child Dependencies (objects that depend on dbo.WF_CPS_0708)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[WF_CPS_0708] Script Date: 03/09/2017 16:46:41 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[WF_CPS_0708](
    [ISN_WF_CPS_0708] [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_RP_O_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RP_O_ACT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RP_O_ACT_DATE] [date] NULL,
    [WF_CP_RP_O_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_ACT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RP_D_ACT_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_CP_RP_D_ACT_DATE] [date] NULL,
    [WF_CP_RP_D_RPT_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_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_0708 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_C_EFC_ADJ 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_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_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_D_ACK WF_CP_RP_D_ACK_DATE WF_CP_RP_D_ACT WF_CP_RP_D_ACT_RSN WF_CP_RP_D_RPT_DATE WF_CP_RP_O_ACK WF_CP_RP_O_ACK_DATE WF_CP_RP_O_ACT WF_CP_RP_O_ACT_RSN WF_CP_RP_O_RPT_DATE WF_CP_RP_R_FED_TRAN WF_CP_RP_R_VER 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_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
351 2017-02-06T11:18:56.51-05:00 I 701 99999 27709 R 701 Y 001512 092585892MC02 2225.00 14061 2225.00 2007-08-23T00:00:00-04:00 02 V A 2008-08-04T00:00:00-04:00 2008-08-04T00:00:00-04:00 A 2008-08-04T00:00:00-04:00 2008-05-21T00:00:00-04:00 3560 PB 2007-05-04T00:00:00-04:00 839324 2008-08-05T00:00:00-04:00 57570632253206280C
11644 2017-02-06T11:19:00.535-05:00 D 99999 8852 Z Z Y 001512 595139931EV01 PB 2007-11-13T00:00:00-05:00 933052 57570633620791850C
11731 2017-02-06T11:19:00.566-05:00 I 2094 2094 11087 S 2094 N 001512 769300031IS01 2260.00 14061 2260.00 2007-08-23T00:00:00-04:00 01 A 2008-08-04T00:00:00-04:00 2008-08-04T00:00:00-04:00 A 2008-08-04T00:00:00-04:00 2008-03-20T00:00:00-04:00 2260 PB 2007-11-08T00:00:00-05:00 840265 2008-08-05T00:00:00-04:00 57570633616687459C
14433 2017-02-06T11:19:01.455-05:00 I 5628 99999 35736 R 5628 N 001512 106662454KA02 PB 2008-04-01T00:00:00-04:00 1002150 57570633741769350C
3602 2017-02-06T11:18:57.618-05:00 I 99999 Z Y 001512 592052125JO05 PB 2007-05-16T00:00:00-04:00 829238 2007-10-15T00:00:00-04:00 57570633463670234C
5250 2017-02-06T11:18:58.164-05:00 D 48054 99999 100248 R 44711 54912 -10201 R 3343 2220 1123 N 001512 593769464AR01 PB 2007-06-26T00:00:00-04:00 1701035 57570633500100633C
6541 2017-02-06T11:18:58.663-05:00 D 19670 99999 97884 R 17924 17924 R 1746 1 1745 N 001512 592785432GO01 PB 2007-07-19T00:00:00-04:00 1012196 57570633203817800C
3770 2017-02-06T11:18:57.664-05:00 D 288 288 23783 S 288 288 S Y 001512 591441591AL04 PB 2007-05-21T00:00:00-04:00 902439 2008-01-07T00:00:00-05:00 57570633039391117C
3414 2017-02-06T11:18:57.524-05:00 I 9167 9167 27797 S 9167 N 001512 593640875AN01 PB 2007-05-14T00:00:00-04:00 1239407 57570632503670546C
11441 2017-02-06T11:19:00.41-05:00 I 1464 1464 27916 S 1464 Y 001512 263675665O'02 715.00 14061 715.00 2007-08-23T00:00:00-04:00 02 V R 2008-06-12T00:00:00-04:00 2008-06-03T00:00:00-04:00 A 2008-06-12T00:00:00-04:00 2008-05-21T00:00:00-04:00 2860 PB 2007-11-05T00:00:00-05:00 1608201 2008-07-31T00:00:00-04:00 57570633614053674C
Powered by BI Documenter