DWStaging
 dbo.WF_CPS_0506 (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_0506
  Properties
Property Value
Name WF_CPS_0506
Schema dbo
Row Count 13594
Data Size 2784 KB
Index Size 248 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_0506
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_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_0506
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.WF_CPS_0506 depends on)
Name Type
  Child Dependencies (objects that depend on dbo.WF_CPS_0506)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[WF_CPS_0506] Script Date: 03/09/2017 16:46:40 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[WF_CPS_0506](
    [ISN_WF_CPS_0506] [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,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ISN_WF_CPS_0506 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_FAO WW_CDATE WW_HOLD WW_MDATE WW_STUDENT_ID
11601 2017-02-06T11:20:25.587-05:00 I 1188 99999 29760 R 1188 Y 001512 594188643AL04 12517 2005-08-23T00:00:00-04:00 594188643AL04 V A 2006-05-25T00:00:00-04:00 2006-05-24T00:00:00-04:00 2900 PB 2005-12-13T00:00:00-05:00 920417 2006-06-06T00:00:00-04:00 57570631031409049C
10454 2017-02-06T11:20:25.165-05:00 I 197 99999 19138 R 197 N 001512 264790220HU02 PB 2005-10-03T00:00:00-04:00 1024385 57570632501886746C
703 2017-02-06T11:20:21.655-05:00 I 14266 99999 44152 R 14266 N 001512 217780086AY01 PB 2005-04-12T00:00:00-04:00 809589 57570632008692503C
10396 2017-02-06T11:20:25.15-05:00 D 1385 99999 29095 R R 1385 35 1350 N 001512 594064301FE02 2700.00 9912 2005-09-28T00:00:00-04:00 1013.00 1 Y 1 2006-02-14T00:00:00-05:00 337.00 2 Y 1 2006-07-10T00:00:00-04:00 1350.00 3 Y 2 2700.00 2005-08-23T00:00:00-04:00 594064301FE02 A 2006-07-12T00:00:00-04:00 2006-07-11T00:00:00-04:00 A 2006-07-12T00:00:00-04:00 2006-04-19T00:00:00-04:00 2700 PB 2005-06-30T00:00:00-04:00 1517115 2006-07-19T00:00:00-04:00 57570632872759198C
11724 2017-02-06T11:20:25.618-05:00 I 1920 1920 9399 S 1920 Y 001512 329547912HO02 263.00 14892 2006-02-08T00:00:00-05:00 263.00 2 Y 1 263.00 2005-08-23T00:00:00-04:00 329547912HO02 V A 2006-04-06T00:00:00-04:00 2006-04-06T00:00:00-04:00 A 2006-05-04T00:00:00-04:00 2006-05-04T00:00:00-04:00 2100 PB 2005-10-11T00:00:00-04:00 1052504 2006-05-18T00:00:00-04:00 57570632961752482C
9943 2017-02-06T11:20:24.994-05:00 I 4781 99999 15778 R 4781 N 001512 424118176SW02 PB 2005-09-22T00:00:00-04:00 1707596 57570631269111003C
9575 2017-02-06T11:20:24.9-05:00 I 188 99999 19095 R 188 N 001512 589429129DI01 3413.00 12517 2005-09-28T00:00:00-04:00 488.00 1 Y 1 2006-01-20T00:00:00-05:00 1950.00 2 Y 1 2006-05-24T00:00:00-04:00 975.00 3 Y 1 3413.00 2005-08-23T00:00:00-04:00 589429129DI01 A 2006-05-25T00:00:00-04:00 2006-05-24T00:00:00-04:00 A 2006-06-14T00:00:00-04:00 2006-06-14T00:00:00-04:00 3900 PB 2005-09-07T00:00:00-04:00 1503344 2006-06-20T00:00:00-04:00 57570632932271510C
4042 2017-02-06T11:20:22.872-05:00 D 7930 99999 82033 R 5709 5709 R 2221 35 2186 N 001512 592834309ZO01 PB 2005-05-26T00:00:00-04:00 1745107 57570632503034098C
4675 2017-02-06T11:20:23.075-05:00 D 6020 99999 51641 R 6020 6020 R N 001512 594527234RO01 PB 2005-06-13T00:00:00-04:00 1513214 57570632858084008C
8527 2017-02-06T11:20:24.526-05:00 I 99999 19198 R N 001512 592292206JO02 PB 2005-08-18T00:00:00-04:00 839440 57570632914871839C
Powered by BI Documenter