DWStaging
 dbo.WF_REQUIREMENT (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_REQUIREMENT
  Properties
Property Value
Name WF_REQUIREMENT
Schema dbo
Row Count 792172
Data Size 127728 KB
Index Size 11880 KB
Create Date 2/13/2013 11:34 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ISN_WF_REQUIREMENT
int(10, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
WF_AID_YEAR
varchar(4)
True
False
False
 
WF_FAO
varchar(2)
True
False
False
 
WF_RE_D01_AFF
varchar(1)
True
False
False
 
WF_RE_D01_NOT
int(10, 0)
True
False
False
 
WF_RE_D01_ST_DOC
varchar(6)
True
False
False
 
WF_RE_D01_STAT
varchar(1)
True
False
False
 
WF_RE_D01_STAT_DATE
date(10, 0)
True
False
False
 
WF_RE_D01_TR_AY
varchar(4)
True
False
False
 
WF_RE_D01_TR_SCHL
varchar(9)
True
False
False
 
WF_RE_D01_TYPE
varchar(1)
True
False
False
 
WF_RE_D02_AFF
varchar(1)
True
False
False
 
WF_RE_D02_NOT
int(10, 0)
True
False
False
 
WF_RE_D02_ST_DOC
varchar(6)
True
False
False
 
WF_RE_D02_STAT
varchar(1)
True
False
False
 
WF_RE_D02_STAT_DATE
date(10, 0)
True
False
False
 
WF_RE_D02_TR_AY
varchar(4)
True
False
False
 
WF_RE_D02_TR_SCHL
varchar(9)
True
False
False
 
WF_RE_D02_TYPE
varchar(1)
True
False
False
 
WF_RE_D03_AFF
varchar(1)
True
False
False
 
WF_RE_D03_NOT
int(10, 0)
True
False
False
 
WF_RE_D03_ST_DOC
varchar(6)
True
False
False
 
WF_RE_D03_STAT
varchar(1)
True
False
False
 
WF_RE_D03_STAT_DATE
date(10, 0)
True
False
False
 
WF_RE_D03_TR_AY
varchar(4)
True
False
False
 
WF_RE_D03_TR_SCHL
varchar(9)
True
False
False
 
WF_RE_D03_TYPE
varchar(1)
True
False
False
 
WF_RE_D04_AFF
varchar(1)
True
False
False
 
WF_RE_D04_NOT
int(10, 0)
True
False
False
 
WF_RE_D04_ST_DOC
varchar(6)
True
False
False
 
WF_RE_D04_STAT
varchar(1)
True
False
False
 
WF_RE_D04_STAT_DATE
date(10, 0)
True
False
False
 
WF_RE_D04_TR_AY
varchar(4)
True
False
False
 
WF_RE_D04_TR_SCHL
varchar(9)
True
False
False
 
WF_RE_D04_TYPE
varchar(1)
True
False
False
 
WF_RE_D05_AFF
varchar(1)
True
False
False
 
WF_RE_D05_NOT
int(10, 0)
True
False
False
 
WF_RE_D05_ST_DOC
varchar(6)
True
False
False
 
WF_RE_D05_STAT
varchar(1)
True
False
False
 
WF_RE_D05_STAT_DATE
date(10, 0)
True
False
False
 
WF_RE_D05_TR_AY
varchar(4)
True
False
False
 
WF_RE_D05_TR_SCHL
varchar(9)
True
False
False
 
WF_RE_D05_TYPE
varchar(1)
True
False
False
 
WF_RE_D06_AFF
varchar(1)
True
False
False
 
WF_RE_D06_NOT
int(10, 0)
True
False
False
 
WF_RE_D06_ST_DOC
varchar(6)
True
False
False
 
WF_RE_D06_STAT
varchar(1)
True
False
False
 
WF_RE_D06_STAT_DATE
date(10, 0)
True
False
False
 
WF_RE_D06_TR_AY
varchar(4)
True
False
False
 
WF_RE_D06_TR_SCHL
varchar(9)
True
False
False
 
WF_RE_D06_TYPE
varchar(1)
True
False
False
 
WF_RE_D07_AFF
varchar(1)
True
False
False
 
WF_RE_D07_NOT
int(10, 0)
True
False
False
 
WF_RE_D07_ST_DOC
varchar(6)
True
False
False
 
WF_RE_D07_STAT
varchar(1)
True
False
False
 
WF_RE_D07_STAT_DATE
date(10, 0)
True
False
False
 
WF_RE_D07_TR_AY
varchar(4)
True
False
False
 
WF_RE_D07_TR_SCHL
varchar(9)
True
False
False
 
WF_RE_D07_TYPE
varchar(1)
True
False
False
 
WF_RE_D08_AFF
varchar(1)
True
False
False
 
WF_RE_D08_NOT
int(10, 0)
True
False
False
 
WF_RE_D08_ST_DOC
varchar(6)
True
False
False
 
WF_RE_D08_STAT
varchar(1)
True
False
False
 
WF_RE_D08_STAT_DATE
date(10, 0)
True
False
False
 
WF_RE_D08_TR_AY
varchar(4)
True
False
False
 
WF_RE_D08_TR_SCHL
varchar(9)
True
False
False
 
WF_RE_D08_TYPE
varchar(1)
True
False
False
 
WF_RE_D09_AFF
varchar(1)
True
False
False
 
WF_RE_D09_NOT
int(10, 0)
True
False
False
 
WF_RE_D09_ST_DOC
varchar(6)
True
False
False
 
WF_RE_D09_STAT
varchar(1)
True
False
False
 
WF_RE_D09_STAT_DATE
date(10, 0)
True
False
False
 
WF_RE_D09_TR_AY
varchar(4)
True
False
False
 
WF_RE_D09_TR_SCHL
varchar(9)
True
False
False
 
WF_RE_D09_TYPE
varchar(1)
True
False
False
 
WF_RE_D10_AFF
varchar(1)
True
False
False
 
WF_RE_D10_NOT
int(10, 0)
True
False
False
 
WF_RE_D10_ST_DOC
varchar(6)
True
False
False
 
WF_RE_D10_STAT
varchar(1)
True
False
False
 
WF_RE_D10_STAT_DATE
date(10, 0)
True
False
False
 
WF_RE_D10_TR_AY
varchar(4)
True
False
False
 
WF_RE_D10_TR_SCHL
varchar(9)
True
False
False
 
WF_RE_D10_TYPE
varchar(1)
True
False
False
 
WF_RE_D11_AFF
varchar(1)
True
False
False
 
WF_RE_D11_NOT
int(10, 0)
True
False
False
 
WF_RE_D11_ST_DOC
varchar(6)
True
False
False
 
WF_RE_D11_STAT
varchar(1)
True
False
False
 
WF_RE_D11_STAT_DATE
date(10, 0)
True
False
False
 
WF_RE_D11_TR_AY
varchar(4)
True
False
False
 
WF_RE_D11_TR_SCHL
varchar(9)
True
False
False
 
WF_RE_D11_TYPE
varchar(1)
True
False
False
 
WF_RE_D12_AFF
varchar(1)
True
False
False
 
WF_RE_D12_NOT
int(10, 0)
True
False
False
 
WF_RE_D12_ST_DOC
varchar(6)
True
False
False
 
WF_RE_D12_STAT
varchar(1)
True
False
False
 
WF_RE_D12_STAT_DATE
date(10, 0)
True
False
False
 
WF_RE_D12_TR_AY
varchar(4)
True
False
False
 
WF_RE_D12_TR_SCHL
varchar(9)
True
False
False
 
WF_RE_D12_TYPE
varchar(1)
True
False
False
 
WF_RE_D13_AFF
varchar(1)
True
False
False
 
WF_RE_D13_NOT
int(10, 0)
True
False
False
 
WF_RE_D13_ST_DOC
varchar(6)
True
False
False
 
WF_RE_D13_STAT
varchar(1)
True
False
False
 
WF_RE_D13_STAT_DATE
date(10, 0)
True
False
False
 
WF_RE_D13_TR_AY
varchar(4)
True
False
False
 
WF_RE_D13_TR_SCHL
varchar(9)
True
False
False
 
WF_RE_D13_TYPE
varchar(1)
True
False
False
 
WF_RE_D14_AFF
varchar(1)
True
False
False
 
WF_RE_D14_NOT
int(10, 0)
True
False
False
 
WF_RE_D14_ST_DOC
varchar(6)
True
False
False
 
WF_RE_D14_STAT
varchar(1)
True
False
False
 
WF_RE_D14_STAT_DATE
date(10, 0)
True
False
False
 
WF_RE_D14_TR_AY
varchar(4)
True
False
False
 
WF_RE_D14_TR_SCHL
varchar(9)
True
False
False
 
WF_RE_D14_TYPE
varchar(1)
True
False
False
 
WF_RE_D15_AFF
varchar(1)
True
False
False
 
WF_RE_D15_NOT
int(10, 0)
True
False
False
 
WF_RE_D15_ST_DOC
varchar(6)
True
False
False
 
WF_RE_D15_STAT
varchar(1)
True
False
False
 
WF_RE_D15_STAT_DATE
date(10, 0)
True
False
False
 
WF_RE_D15_TR_AY
varchar(4)
True
False
False
 
WF_RE_D15_TR_SCHL
varchar(9)
True
False
False
 
WF_RE_D15_TYPE
varchar(1)
True
False
False
 
WF_REQ_TYPE
varchar(1)
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_REQUIREMENT
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.WF_REQUIREMENT depends on)
Name Type
  Child Dependencies (objects that depend on dbo.WF_REQUIREMENT)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[WF_REQUIREMENT] Script Date: 03/09/2017 16:47:03 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[WF_REQUIREMENT](
    [ISN_WF_REQUIREMENT] [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,
    [WF_AID_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_REQ_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_HOLD] [int] NULL,
    [WW_CDATE] [date] NULL,
    [WW_MDATE] [date] NULL,
    [WF_RE_D01_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D01_AFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D01_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D01_STAT_DATE] [date] NULL,
    [WF_RE_D01_NOT] [int] NULL,
    [WF_RE_D01_TR_SCHL] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D01_TR_AY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D01_ST_DOC] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D02_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D02_AFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D02_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D02_STAT_DATE] [date] NULL,
    [WF_RE_D02_NOT] [int] NULL,
    [WF_RE_D02_TR_SCHL] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D02_TR_AY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D02_ST_DOC] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D03_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D03_AFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D03_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D03_STAT_DATE] [date] NULL,
    [WF_RE_D03_NOT] [int] NULL,
    [WF_RE_D03_TR_SCHL] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D03_TR_AY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D03_ST_DOC] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D04_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D04_AFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D04_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D04_STAT_DATE] [date] NULL,
    [WF_RE_D04_NOT] [int] NULL,
    [WF_RE_D04_TR_SCHL] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D04_TR_AY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D04_ST_DOC] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D05_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D05_AFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D05_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D05_STAT_DATE] [date] NULL,
    [WF_RE_D05_NOT] [int] NULL,
    [WF_RE_D05_TR_SCHL] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D05_TR_AY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D05_ST_DOC] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D06_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D06_AFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D06_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D06_STAT_DATE] [date] NULL,
    [WF_RE_D06_NOT] [int] NULL,
    [WF_RE_D06_TR_SCHL] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D06_TR_AY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D06_ST_DOC] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D07_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D07_AFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D07_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D07_STAT_DATE] [date] NULL,
    [WF_RE_D07_NOT] [int] NULL,
    [WF_RE_D07_TR_SCHL] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D07_TR_AY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D07_ST_DOC] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D08_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D08_AFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D08_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D08_STAT_DATE] [date] NULL,
    [WF_RE_D08_NOT] [int] NULL,
    [WF_RE_D08_TR_SCHL] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D08_TR_AY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D08_ST_DOC] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D09_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D09_AFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D09_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D09_STAT_DATE] [date] NULL,
    [WF_RE_D09_NOT] [int] NULL,
    [WF_RE_D09_TR_SCHL] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D09_TR_AY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D09_ST_DOC] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D10_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D10_AFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D10_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D10_STAT_DATE] [date] NULL,
    [WF_RE_D10_NOT] [int] NULL,
    [WF_RE_D10_TR_SCHL] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D10_TR_AY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D10_ST_DOC] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D11_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D11_AFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D11_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D11_STAT_DATE] [date] NULL,
    [WF_RE_D11_NOT] [int] NULL,
    [WF_RE_D11_TR_SCHL] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D11_TR_AY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D11_ST_DOC] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D12_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D12_AFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D12_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D12_STAT_DATE] [date] NULL,
    [WF_RE_D12_NOT] [int] NULL,
    [WF_RE_D12_TR_SCHL] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D12_TR_AY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D12_ST_DOC] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D13_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D13_AFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D13_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D13_STAT_DATE] [date] NULL,
    [WF_RE_D13_NOT] [int] NULL,
    [WF_RE_D13_TR_SCHL] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D13_TR_AY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D13_ST_DOC] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D14_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D14_AFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D14_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D14_STAT_DATE] [date] NULL,
    [WF_RE_D14_NOT] [int] NULL,
    [WF_RE_D14_TR_SCHL] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D14_TR_AY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D14_ST_DOC] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D15_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D15_AFF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D15_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D15_STAT_DATE] [date] NULL,
    [WF_RE_D15_NOT] [int] NULL,
    [WF_RE_D15_TR_SCHL] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D15_TR_AY] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_RE_D15_ST_DOC] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ISN_WF_REQUIREMENT RowUpdatedOn WF_AID_YEAR WF_FAO WF_RE_D01_AFF WF_RE_D01_NOT WF_RE_D01_ST_DOC WF_RE_D01_STAT WF_RE_D01_STAT_DATE WF_RE_D01_TR_AY WF_RE_D01_TR_SCHL WF_RE_D01_TYPE WF_RE_D02_AFF WF_RE_D02_NOT WF_RE_D02_ST_DOC WF_RE_D02_STAT WF_RE_D02_STAT_DATE WF_RE_D02_TR_AY WF_RE_D02_TR_SCHL WF_RE_D02_TYPE WF_RE_D03_AFF WF_RE_D03_NOT WF_RE_D03_ST_DOC WF_RE_D03_STAT WF_RE_D03_STAT_DATE WF_RE_D03_TR_AY WF_RE_D03_TR_SCHL WF_RE_D03_TYPE WF_RE_D04_AFF WF_RE_D04_NOT WF_RE_D04_ST_DOC WF_RE_D04_STAT WF_RE_D04_STAT_DATE WF_RE_D04_TR_AY WF_RE_D04_TR_SCHL WF_RE_D04_TYPE WF_RE_D05_AFF WF_RE_D05_ST_DOC WF_RE_D05_STAT WF_RE_D05_STAT_DATE WF_RE_D05_TR_AY WF_RE_D05_TR_SCHL WF_RE_D05_TYPE WF_RE_D06_AFF WF_RE_D06_ST_DOC WF_RE_D06_STAT WF_RE_D06_STAT_DATE WF_RE_D06_TR_AY WF_RE_D06_TR_SCHL WF_RE_D06_TYPE WF_RE_D07_AFF WF_RE_D07_ST_DOC WF_RE_D07_STAT WF_RE_D07_STAT_DATE WF_RE_D07_TR_AY WF_RE_D07_TR_SCHL WF_RE_D07_TYPE WF_RE_D08_AFF WF_RE_D08_ST_DOC WF_RE_D08_STAT WF_RE_D08_TR_AY WF_RE_D08_TR_SCHL WF_RE_D08_TYPE WF_RE_D09_AFF WF_RE_D09_ST_DOC WF_RE_D09_STAT WF_RE_D09_TR_AY WF_RE_D09_TR_SCHL WF_RE_D09_TYPE WF_RE_D10_AFF WF_RE_D10_ST_DOC WF_RE_D10_STAT WF_RE_D10_TR_AY WF_RE_D10_TR_SCHL WF_RE_D10_TYPE WF_RE_D11_AFF WF_RE_D11_ST_DOC WF_RE_D11_STAT WF_RE_D11_TR_AY WF_RE_D11_TR_SCHL WF_RE_D11_TYPE WF_RE_D12_AFF WF_RE_D12_ST_DOC WF_RE_D12_STAT WF_RE_D12_TR_AY WF_RE_D12_TR_SCHL WF_RE_D12_TYPE WF_RE_D13_AFF WF_RE_D13_ST_DOC WF_RE_D13_STAT WF_RE_D13_TR_AY WF_RE_D13_TR_SCHL WF_RE_D13_TYPE WF_RE_D14_AFF WF_RE_D14_ST_DOC WF_RE_D14_STAT WF_RE_D14_TR_AY WF_RE_D14_TR_SCHL WF_RE_D14_TYPE WF_RE_D15_AFF WF_RE_D15_ST_DOC WF_RE_D15_STAT WF_RE_D15_TR_AY WF_RE_D15_TR_SCHL WF_RE_D15_TYPE WF_REQ_TYPE WW_CDATE WW_HOLD WW_MDATE WW_STUDENT_ID
227152 2017-02-06T10:33:05.822-05:00 2007 PB Y ISIR C 2006-06-07T00:00:00-04:00 S Y MY1 C 2007-04-12T00:00:00-04:00 S Y MY2 C 2007-04-12T00:00:00-04:00 S Y MY3 C 2007-05-29T00:00:00-04:00 S A 2006-06-07T00:00:00-04:00 1049458 2007-05-29T00:00:00-04:00 57570632998022051C
235033 2017-02-06T10:33:08.038-05:00 2008 PB Y 2 EP W 2007-05-21T00:00:00-04:00 S Y ISIR C 2007-05-21T00:00:00-04:00 S Y 2 IVFI C 2007-07-26T00:00:00-04:00 S Y 2 S-TAX C 2007-07-26T00:00:00-04:00 S Y MY1 C 2007-09-14T00:00:00-04:00 S Y MY2 C 2008-01-28T00:00:00-05:00 S Y MY3 C 2008-06-04T00:00:00-04:00 S A 2007-05-21T00:00:00-04:00 1656449 2008-06-04T00:00:00-04:00 57570633468720347C
641204 2017-02-06T10:34:53.915-05:00 2014 PB N SAP3 R 2014-05-08T00:00:00-04:00 S D 2014-05-08T00:00:00-04:00 829403 57570635362795063C
706486 2017-02-06T10:35:10.998-05:00 PB Y 1 ATBW8A C 2015-07-28T00:00:00-04:00 2016 S A 2015-04-27T00:00:00-04:00 1048139 2015-07-28T00:00:00-04:00 57570635972764345C
233549 2017-02-06T10:33:07.632-05:00 2008 PB Y 2 INS C 2007-10-08T00:00:00-04:00 S Y INSVER C 2007-10-08T00:00:00-04:00 S Y ISIR C 2007-05-04T00:00:00-04:00 S Y NR-NA W 2008-05-09T00:00:00-04:00 S Y MY3 C 2008-06-04T00:00:00-04:00 S A 2007-05-04T00:00:00-04:00 1653381 2008-06-04T00:00:00-04:00 57570633144193106C
193335 2017-02-06T10:32:56.603-05:00 2006 PB Y ISIR C 2005-07-25T00:00:00-04:00 S Y MY1 C 2005-09-20T00:00:00-04:00 S Y MY2 C 2006-02-03T00:00:00-05:00 S Y MY3 C 2006-05-31T00:00:00-04:00 S A 2005-07-25T00:00:00-04:00 1859483 2006-05-31T00:00:00-04:00 57570632381187731C
225542 2017-02-06T10:33:05.432-05:00 2007 PB N LOANRQ R 2006-08-22T00:00:00-04:00 S D 2006-08-22T00:00:00-04:00 436484 57570632805352975C
314117 2017-02-06T10:33:28.552-05:00 2010 PB N FEEATH C 2009-07-06T00:00:00-04:00 S Y 1 IVFI C 2009-07-08T00:00:00-04:00 S Y 1 S-TAX C 2009-07-08T00:00:00-04:00 S N V-WKFL C 2009-07-08T00:00:00-04:00 S Y MY3 C 2010-06-02T00:00:00-04:00 S Y NR-NA W 2010-05-19T00:00:00-04:00 S A 2009-06-16T00:00:00-04:00 1526231 2010-06-02T00:00:00-04:00 57570633851513719C
277967 2017-02-06T10:33:19.301-05:00 PB Y ATBW8A C 2008-08-29T00:00:00-04:00 2009 S A 2008-08-26T00:00:00-04:00 1123345 57570633868826144C
566372 2017-02-06T10:34:34.228-05:00 2013 PB Y SAP2 C 2013-02-21T00:00:00-05:00 S D 2013-02-06T00:00:00-05:00 1158316 2013-02-21T00:00:00-05:00 57570633536362362C
Powered by BI Documenter