DWStaging
 dbo.WF_NSLDS_1516 (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_NSLDS_1516
  Properties
Property Value
Name WF_NSLDS_1516
Schema dbo
Row Count 34432
Data Size 14208 KB
Index Size 552 KB
Create Date 3/4/2015 10:09 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ISN_WF_NSLDS_1516
int(10, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
WF_FAO
varchar(2)
True
False
False
 
WF_NS_BANKRUPT
varchar(1)
True
False
False
 
WF_NS_BANKRUPT_CHG
varchar(1)
True
False
False
 
WF_NS_C_ENR_PATTERN
varchar(1)
True
False
False
 
WF_NS_C_LEU
varchar(7)
True
False
False
 
WF_NS_C_LEU_FLAG
varchar(1)
True
False
False
 
WF_NS_C_SUB_LE_FLAG
varchar(1)
True
False
False
 
WF_NS_C_SUB_USAGE_PD
varchar(6)
True
False
False
 
WF_NS_CMB_LIMIT_GR
varchar(1)
True
False
False
 
WF_NS_CMB_LIMIT_UG
varchar(1)
True
False
False
 
WF_NS_CMB_OUT
varchar(6)
True
False
False
 
WF_NS_CMB_PEND
varchar(6)
True
False
False
 
WF_NS_CMB_TOTAL
varchar(6)
True
False
False
 
WF_NS_CON_OUT
varchar(6)
True
False
False
 
WF_NS_CON_TOTAL
varchar(6)
True
False
False
 
WF_NS_DL_MPN
varchar(1)
True
False
False
 
WF_NS_DLG_MPN
varchar(1)
True
False
False
 
WF_NS_DLP_MPN
varchar(1)
True
False
False
 
WF_NS_FILLER_006A
varchar(6)
True
False
False
 
WF_NS_IAAS_OVP
varchar(1)
True
False
False
 
WF_NS_IAAS_OVP_CTC
varchar(8)
True
False
False
 
WF_NS_L01_AMT
varchar(6)
True
False
False
 
WF_NS_L01_BEG_DATE
varchar(8)
True
False
False
 
WF_NS_L01_CAP
varchar(1)
True
False
False
 
WF_NS_L01_CHG
varchar(1)
True
False
False
 
WF_NS_L01_CONTACT
varchar(8)
True
False
False
 
WF_NS_L01_CTC_TYPE
varchar(3)
True
False
False
 
WF_NS_L01_DSB
varchar(6)
True
False
False
 
WF_NS_L01_DSB_DATE
varchar(8)
True
False
False
 
WF_NS_L01_END_DATE
varchar(8)
True
False
False
 
WF_NS_L01_GA
varchar(3)
True
False
False
 
WF_NS_L01_LEVEL
varchar(3)
True
False
False
 
WF_NS_L01_OUT
varchar(6)
True
False
False
 
WF_NS_L01_OUT_DATE
varchar(8)
True
False
False
 
WF_NS_L01_PROG
varchar(2)
True
False
False
 
WF_NS_L01_SCHOOL
varchar(8)
True
False
False
 
WF_NS_L01_SEQ
varchar(2)
True
False
False
 
WF_NS_L01_STA
varchar(2)
True
False
False
 
WF_NS_L01_STA_DATE
varchar(8)
True
False
False
 
WF_NS_L01_SUBSIDY
varchar(1)
True
False
False
 
WF_NS_L01_SUBSIDY_DT
varchar(8)
True
False
False
 
WF_NS_L01_TYPE
varchar(1)
True
False
False
 
WF_NS_L01_XUNS
varchar(1)
True
False
False
 
WF_NS_L02_AMT
varchar(6)
True
False
False
 
WF_NS_L02_BEG_DATE
varchar(8)
True
False
False
 
WF_NS_L02_CAP
varchar(1)
True
False
False
 
WF_NS_L02_CHG
varchar(1)
True
False
False
 
WF_NS_L02_CONTACT
varchar(8)
True
False
False
 
WF_NS_L02_CTC_TYPE
varchar(3)
True
False
False
 
WF_NS_L02_DSB
varchar(6)
True
False
False
 
WF_NS_L02_DSB_DATE
varchar(8)
True
False
False
 
WF_NS_L02_END_DATE
varchar(8)
True
False
False
 
WF_NS_L02_GA
varchar(3)
True
False
False
 
WF_NS_L02_LEVEL
varchar(3)
True
False
False
 
WF_NS_L02_OUT
varchar(6)
True
False
False
 
WF_NS_L02_OUT_DATE
varchar(8)
True
False
False
 
WF_NS_L02_PROG
varchar(2)
True
False
False
 
WF_NS_L02_SCHOOL
varchar(8)
True
False
False
 
WF_NS_L02_SEQ
varchar(2)
True
False
False
 
WF_NS_L02_STA
varchar(2)
True
False
False
 
WF_NS_L02_STA_DATE
varchar(8)
True
False
False
 
WF_NS_L02_SUBSIDY
varchar(1)
True
False
False
 
WF_NS_L02_SUBSIDY_DT
varchar(8)
True
False
False
 
WF_NS_L02_TYPE
varchar(1)
True
False
False
 
WF_NS_L02_XUNS
varchar(1)
True
False
False
 
WF_NS_L03_AMT
varchar(6)
True
False
False
 
WF_NS_L03_BEG_DATE
varchar(8)
True
False
False
 
WF_NS_L03_CAP
varchar(1)
True
False
False
 
WF_NS_L03_CHG
varchar(1)
True
False
False
 
WF_NS_L03_CONTACT
varchar(8)
True
False
False
 
WF_NS_L03_CTC_TYPE
varchar(3)
True
False
False
 
WF_NS_L03_DSB
varchar(6)
True
False
False
 
WF_NS_L03_DSB_DATE
varchar(8)
True
False
False
 
WF_NS_L03_END_DATE
varchar(8)
True
False
False
 
WF_NS_L03_GA
varchar(3)
True
False
False
 
WF_NS_L03_LEVEL
varchar(3)
True
False
False
 
WF_NS_L03_OUT
varchar(6)
True
False
False
 
WF_NS_L03_OUT_DATE
varchar(8)
True
False
False
 
WF_NS_L03_PROG
varchar(2)
True
False
False
 
WF_NS_L03_SCHOOL
varchar(8)
True
False
False
 
WF_NS_L03_SEQ
varchar(2)
True
False
False
 
WF_NS_L03_STA
varchar(2)
True
False
False
 
WF_NS_L03_STA_DATE
varchar(8)
True
False
False
 
WF_NS_L03_SUBSIDY
varchar(1)
True
False
False
 
WF_NS_L03_SUBSIDY_DT
varchar(8)
True
False
False
 
WF_NS_L03_TYPE
varchar(1)
True
False
False
 
WF_NS_L03_XUNS
varchar(1)
True
False
False
 
WF_NS_L04_AMT
varchar(6)
True
False
False
 
WF_NS_L04_BEG_DATE
varchar(8)
True
False
False
 
WF_NS_L04_CAP
varchar(1)
True
False
False
 
WF_NS_L04_CHG
varchar(1)
True
False
False
 
WF_NS_L04_CONTACT
varchar(8)
True
False
False
 
WF_NS_L04_CTC_TYPE
varchar(3)
True
False
False
 
WF_NS_L04_DSB
varchar(6)
True
False
False
 
WF_NS_L04_DSB_DATE
varchar(8)
True
False
False
 
WF_NS_L04_END_DATE
varchar(8)
True
False
False
 
WF_NS_L04_GA
varchar(3)
True
False
False
 
WF_NS_L04_LEVEL
varchar(3)
True
False
False
 
WF_NS_L04_OUT
varchar(6)
True
False
False
 
WF_NS_L04_OUT_DATE
varchar(8)
True
False
False
 
WF_NS_L04_PROG
varchar(2)
True
False
False
 
WF_NS_L04_SCHOOL
varchar(8)
True
False
False
 
WF_NS_L04_SEQ
varchar(2)
True
False
False
 
WF_NS_L04_STA
varchar(2)
True
False
False
 
WF_NS_L04_STA_DATE
varchar(8)
True
False
False
 
WF_NS_L04_SUBSIDY
varchar(1)
True
False
False
 
WF_NS_L04_SUBSIDY_DT
varchar(8)
True
False
False
 
WF_NS_L04_TYPE
varchar(1)
True
False
False
 
WF_NS_L04_XUNS
varchar(1)
True
False
False
 
WF_NS_L05_AMT
varchar(6)
True
False
False
 
WF_NS_L05_BEG_DATE
varchar(8)
True
False
False
 
WF_NS_L05_CAP
varchar(1)
True
False
False
 
WF_NS_L05_CHG
varchar(1)
True
False
False
 
WF_NS_L05_CONTACT
varchar(8)
True
False
False
 
WF_NS_L05_CTC_TYPE
varchar(3)
True
False
False
 
WF_NS_L05_DSB
varchar(6)
True
False
False
 
WF_NS_L05_DSB_DATE
varchar(8)
True
False
False
 
WF_NS_L05_END_DATE
varchar(8)
True
False
False
 
WF_NS_L05_GA
varchar(3)
True
False
False
 
WF_NS_L05_LEVEL
varchar(3)
True
False
False
 
WF_NS_L05_OUT
varchar(6)
True
False
False
 
WF_NS_L05_OUT_DATE
varchar(8)
True
False
False
 
WF_NS_L05_PROG
varchar(2)
True
False
False
 
WF_NS_L05_SCHOOL
varchar(8)
True
False
False
 
WF_NS_L05_SEQ
varchar(2)
True
False
False
 
WF_NS_L05_STA
varchar(2)
True
False
False
 
WF_NS_L05_STA_DATE
varchar(8)
True
False
False
 
WF_NS_L05_SUBSIDY
varchar(1)
True
False
False
 
WF_NS_L05_SUBSIDY_DT
varchar(8)
True
False
False
 
WF_NS_L05_TYPE
varchar(1)
True
False
False
 
WF_NS_L05_XUNS
varchar(1)
True
False
False
 
WF_NS_L06_AMT
varchar(6)
True
False
False
 
WF_NS_L06_BEG_DATE
varchar(8)
True
False
False
 
WF_NS_L06_CAP
varchar(1)
True
False
False
 
WF_NS_L06_CHG
varchar(1)
True
False
False
 
WF_NS_L06_CONTACT
varchar(8)
True
False
False
 
WF_NS_L06_CTC_TYPE
varchar(3)
True
False
False
 
WF_NS_L06_DSB
varchar(6)
True
False
False
 
WF_NS_L06_DSB_DATE
varchar(8)
True
False
False
 
WF_NS_L06_END_DATE
varchar(8)
True
False
False
 
WF_NS_L06_GA
varchar(3)
True
False
False
 
WF_NS_L06_LEVEL
varchar(3)
True
False
False
 
WF_NS_L06_OUT
varchar(6)
True
False
False
 
WF_NS_L06_OUT_DATE
varchar(8)
True
False
False
 
WF_NS_L06_PROG
varchar(2)
True
False
False
 
WF_NS_L06_SCHOOL
varchar(8)
True
False
False
 
WF_NS_L06_SEQ
varchar(2)
True
False
False
 
WF_NS_L06_STA
varchar(2)
True
False
False
 
WF_NS_L06_STA_DATE
varchar(8)
True
False
False
 
WF_NS_L06_SUBSIDY
varchar(1)
True
False
False
 
WF_NS_L06_SUBSIDY_DT
varchar(8)
True
False
False
 
WF_NS_L06_TYPE
varchar(1)
True
False
False
 
WF_NS_L06_XUNS
varchar(1)
True
False
False
 
WF_NS_LOAN_ADTNL
varchar(1)
True
False
False
 
WF_NS_LOAN_CHG
varchar(1)
True
False
False
 
WF_NS_LOAN_DEF
varchar(1)
True
False
False
 
WF_NS_LOAN_DEF_CHG
varchar(1)
True
False
False
 
WF_NS_LOAN_DIS
varchar(1)
True
False
False
 
WF_NS_LOAN_DIS_CHG
varchar(1)
True
False
False
 
WF_NS_LOAN_FRD
varchar(1)
True
False
False
 
WF_NS_LOAN_FRD_CHG
varchar(1)
True
False
False
 
WF_NS_LOAN_REP
varchar(1)
True
False
False
 
WF_NS_LOAN_REP_CHG
varchar(1)
True
False
False
 
WF_NS_OVPMT_CHG
varchar(1)
True
False
False
 
WF_NS_P1_ADDL_ELIG
varchar(1)
True
False
False
 
WF_NS_P1_AWARD
varchar(6)
True
False
False
 
WF_NS_P1_DATE
varchar(8)
True
False
False
 
WF_NS_P1_EFC
varchar(6)
True
False
False
 
WF_NS_P1_PAID
varchar(6)
True
False
False
 
WF_NS_P1_SCH_AWD
varchar(6)
True
False
False
 
WF_NS_P1_SCH_PCT
varchar(7)
True
False
False
 
WF_NS_P1_SCHOOL
varchar(8)
True
False
False
 
WF_NS_P1_SEQ
varchar(2)
True
False
False
 
WF_NS_P1_TRAN
varchar(2)
True
False
False
 
WF_NS_P1_VER
varchar(3)
True
False
False
 
WF_NS_P2_ADDL_ELIG
varchar(1)
True
False
False
 
WF_NS_P2_AWARD
varchar(6)
True
False
False
 
WF_NS_P2_DATE
varchar(8)
True
False
False
 
WF_NS_P2_EFC
varchar(6)
True
False
False
 
WF_NS_P2_PAID
varchar(6)
True
False
False
 
WF_NS_P2_SCH_AWD
varchar(6)
True
False
False
 
WF_NS_P2_SCH_PCT
varchar(7)
True
False
False
 
WF_NS_P2_SCHOOL
varchar(8)
True
False
False
 
WF_NS_P2_SEQ
varchar(2)
True
False
False
 
WF_NS_P2_TRAN
varchar(2)
True
False
False
 
WF_NS_P2_VER
varchar(3)
True
False
False
 
WF_NS_P3_ADDL_ELIG
varchar(1)
True
False
False
 
WF_NS_P3_AWARD
varchar(6)
True
False
False
 
WF_NS_P3_DATE
varchar(8)
True
False
False
 
WF_NS_P3_EFC
varchar(6)
True
False
False
 
WF_NS_P3_PAID
varchar(6)
True
False
False
 
WF_NS_P3_SCH_AWD
varchar(6)
True
False
False
 
WF_NS_P3_SCH_PCT
varchar(7)
True
False
False
 
WF_NS_P3_SCHOOL
varchar(8)
True
False
False
 
WF_NS_P3_SEQ
varchar(2)
True
False
False
 
WF_NS_P3_TRAN
varchar(2)
True
False
False
 
WF_NS_P3_VER
varchar(3)
True
False
False
 
WF_NS_PELL_ADTNL
varchar(1)
True
False
False
 
WF_NS_PELL_CHG
varchar(1)
True
False
False
 
WF_NS_PELL_OVP
varchar(1)
True
False
False
 
WF_NS_PELL_OVP_CTC
varchar(8)
True
False
False
 
WF_NS_PERK_CUR
varchar(6)
True
False
False
 
WF_NS_PERK_OVP
varchar(1)
True
False
False
 
WF_NS_PERK_OVP_CTC
varchar(8)
True
False
False
 
WF_NS_PERK_TOTAL
varchar(6)
True
False
False
 
WF_NS_PERKINS_CHG
varchar(1)
True
False
False
 
WF_NS_SEOG_OVP
varchar(1)
True
False
False
 
WF_NS_SEOG_OVP_CTC
varchar(8)
True
False
False
 
WF_NS_SUB_LIMIT_GR
varchar(1)
True
False
False
 
WF_NS_SUB_LIMIT_UG
varchar(1)
True
False
False
 
WF_NS_SUB_OUT
varchar(6)
True
False
False
 
WF_NS_SUB_PEND
varchar(6)
True
False
False
 
WF_NS_SUB_TOTAL
varchar(6)
True
False
False
 
WF_NS_T1_AWARD
varchar(6)
True
False
False
 
WF_NS_T1_AWDYEAR
varchar(4)
True
False
False
 
WF_NS_T1_CONV
varchar(1)
True
False
False
 
WF_NS_T1_DATE
varchar(8)
True
False
False
 
WF_NS_T1_LEVEL
varchar(1)
True
False
False
 
WF_NS_T1_PAID
varchar(6)
True
False
False
 
WF_NS_T1_SCH_AWD
varchar(6)
True
False
False
 
WF_NS_T1_SCHOOL
varchar(8)
True
False
False
 
WF_NS_T1_SEQ
varchar(2)
True
False
False
 
WF_NS_T1_SEQCODE
varchar(3)
True
False
False
 
WF_NS_T1_TRAN
varchar(2)
True
False
False
 
WF_NS_T2_AWARD
varchar(6)
True
False
False
 
WF_NS_T2_AWDYEAR
varchar(4)
True
False
False
 
WF_NS_T2_CONV
varchar(1)
True
False
False
 
WF_NS_T2_DATE
varchar(8)
True
False
False
 
WF_NS_T2_LEVEL
varchar(1)
True
False
False
 
WF_NS_T2_PAID
varchar(6)
True
False
False
 
WF_NS_T2_SCH_AWD
varchar(6)
True
False
False
 
WF_NS_T2_SCHOOL
varchar(8)
True
False
False
 
WF_NS_T2_SEQ
varchar(2)
True
False
False
 
WF_NS_T2_SEQCODE
varchar(3)
True
False
False
 
WF_NS_T2_TRAN
varchar(2)
True
False
False
 
WF_NS_T3_AWARD
varchar(6)
True
False
False
 
WF_NS_T3_AWDYEAR
varchar(4)
True
False
False
 
WF_NS_T3_CONV
varchar(1)
True
False
False
 
WF_NS_T3_DATE
varchar(8)
True
False
False
 
WF_NS_T3_LEVEL
varchar(1)
True
False
False
 
WF_NS_T3_PAID
varchar(6)
True
False
False
 
WF_NS_T3_SCH_AWD
varchar(6)
True
False
False
 
WF_NS_T3_SCHOOL
varchar(8)
True
False
False
 
WF_NS_T3_SEQ
varchar(2)
True
False
False
 
WF_NS_T3_SEQCODE
varchar(3)
True
False
False
 
WF_NS_T3_TRAN
varchar(2)
True
False
False
 
WF_NS_TCH_ADTNL
varchar(1)
True
False
False
 
WF_NS_TCH_CHG
varchar(1)
True
False
False
 
WF_NS_TCH_CONV
varchar(1)
True
False
False
 
WF_NS_TCH_CONV_CHG
varchar(1)
True
False
False
 
WF_NS_TCH_OUT
varchar(6)
True
False
False
 
WF_NS_TCH_OVP
varchar(1)
True
False
False
 
WF_NS_TCH_OVP_CTC
varchar(8)
True
False
False
 
WF_NS_TCH_TOTAL
varchar(6)
True
False
False
 
WF_NS_TCH_TOTAL_GR
varchar(6)
True
False
False
 
WF_NS_TCH_TOTAL_UG
varchar(6)
True
False
False
 
WF_NS_UNS_OUT
varchar(6)
True
False
False
 
WF_NS_UNS_PEND
varchar(6)
True
False
False
 
WF_NS_UNS_TOTAL
varchar(6)
True
False
False
 
WW_CDATE
date(10, 0)
True
False
False
 
WW_FILLER_007A
varchar(3)
True
False
False
 
WW_FILLER_007B
varchar(3)
True
False
False
 
WW_FILLER_007C
varchar(3)
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_NSLDS_1516
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.WF_NSLDS_1516 depends on)
Name Type
  Child Dependencies (objects that depend on dbo.WF_NSLDS_1516)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[WF_NSLDS_1516] Script Date: 03/09/2017 16:47:01 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[WF_NSLDS_1516](
    [ISN_WF_NSLDS_1516] [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_NS_PELL_OVP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_PELL_OVP_CTC] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_SEOG_OVP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_SEOG_OVP_CTC] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_PERK_OVP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_PERK_OVP_CTC] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_TCH_OVP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_TCH_OVP_CTC] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_IAAS_OVP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_IAAS_OVP_CTC] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_LOAN_DEF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_LOAN_DIS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_LOAN_FRD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_LOAN_REP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_BANKRUPT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_TCH_CONV] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_SUB_OUT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_UNS_OUT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_CMB_OUT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_CON_OUT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_TCH_OUT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_SUB_PEND] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_UNS_PEND] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_CMB_PEND] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_SUB_TOTAL] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_UNS_TOTAL] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_CMB_TOTAL] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_CON_TOTAL] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_TCH_TOTAL] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_PERK_TOTAL] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_PERK_CUR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_TCH_TOTAL_UG] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_TCH_TOTAL_GR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_LOAN_DEF_CHG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_LOAN_DIS_CHG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_LOAN_FRD_CHG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_LOAN_REP_CHG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_BANKRUPT_CHG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_TCH_CONV_CHG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_OVPMT_CHG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_LOAN_CHG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_PERKINS_CHG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_PELL_CHG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_TCH_CHG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_PELL_ADTNL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_LOAN_ADTNL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_TCH_ADTNL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_DL_MPN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_DLP_MPN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_DLG_MPN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_SUB_LIMIT_UG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_CMB_LIMIT_UG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_SUB_LIMIT_GR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_CMB_LIMIT_GR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_C_LEU_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_C_LEU] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_C_SUB_LE_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_C_SUB_USAGE_PD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_C_ENR_PATTERN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_FILLER_006A] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P1_SEQ] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P1_VER] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P1_EFC] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P1_SCHOOL] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P1_TRAN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P1_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P1_SCH_AWD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P1_PAID] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P1_SCH_PCT] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P1_AWARD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P1_ADDL_ELIG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_FILLER_007A] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P2_SEQ] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P2_VER] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P2_EFC] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P2_SCHOOL] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P2_TRAN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P2_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P2_SCH_AWD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P2_PAID] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P2_SCH_PCT] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P2_AWARD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P2_ADDL_ELIG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_FILLER_007B] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P3_SEQ] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P3_VER] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P3_EFC] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P3_SCHOOL] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P3_TRAN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P3_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P3_SCH_AWD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P3_PAID] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P3_SCH_PCT] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P3_AWARD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P3_ADDL_ELIG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_FILLER_007C] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T1_SEQ] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T1_SCHOOL] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T1_TRAN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T1_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T1_SCH_AWD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T1_PAID] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T1_AWARD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T1_LEVEL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T1_SEQCODE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T1_AWDYEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T1_CONV] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T2_SEQ] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T2_SCHOOL] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T2_TRAN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T2_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T2_SCH_AWD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T2_PAID] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T2_AWARD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T2_LEVEL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T2_SEQCODE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T2_AWDYEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T2_CONV] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T3_SEQ] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T3_SCHOOL] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T3_TRAN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T3_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T3_SCH_AWD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T3_PAID] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T3_AWARD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T3_LEVEL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T3_SEQCODE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T3_AWDYEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_T3_CONV] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_SEQ] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_CHG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_PROG] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_AMT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_STA] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_STA_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_OUT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_OUT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_BEG_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_GA] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_CTC_TYPE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_SCHOOL] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_CONTACT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_LEVEL] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_XUNS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_CAP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_DSB] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_DSB_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_SUBSIDY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L01_SUBSIDY_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_SEQ] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_CHG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_PROG] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_AMT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_STA] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_STA_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_OUT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_OUT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_BEG_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_GA] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_CTC_TYPE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_SCHOOL] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_CONTACT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_LEVEL] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_XUNS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_CAP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_DSB] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_DSB_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_SUBSIDY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L02_SUBSIDY_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_SEQ] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_CHG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_PROG] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_AMT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_STA] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_STA_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_OUT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_OUT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_BEG_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_GA] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_CTC_TYPE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_SCHOOL] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_CONTACT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_LEVEL] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_XUNS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_CAP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_DSB] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_DSB_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_SUBSIDY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L03_SUBSIDY_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_SEQ] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_CHG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_PROG] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_AMT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_STA] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_STA_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_OUT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_OUT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_BEG_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_GA] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_CTC_TYPE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_SCHOOL] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_CONTACT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_LEVEL] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_XUNS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_CAP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_DSB] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_DSB_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_SUBSIDY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L04_SUBSIDY_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_SEQ] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_CHG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_PROG] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_AMT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_STA] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_STA_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_OUT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_OUT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_BEG_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_GA] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_CTC_TYPE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_SCHOOL] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_CONTACT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_LEVEL] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_XUNS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_CAP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_DSB] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_DSB_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_SUBSIDY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L05_SUBSIDY_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_SEQ] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_CHG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_PROG] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_AMT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_STA] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_STA_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_OUT] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_OUT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_BEG_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_GA] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_CTC_TYPE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_SCHOOL] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_CONTACT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_LEVEL] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_XUNS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_CAP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_DSB] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_DSB_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_SUBSIDY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_L06_SUBSIDY_DT] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ISN_WF_NSLDS_1516 RowUpdatedOn WF_FAO WF_NS_BANKRUPT WF_NS_BANKRUPT_CHG WF_NS_C_ENR_PATTERN WF_NS_C_LEU WF_NS_C_LEU_FLAG WF_NS_C_SUB_LE_FLAG WF_NS_C_SUB_USAGE_PD WF_NS_CMB_LIMIT_GR WF_NS_CMB_LIMIT_UG WF_NS_CMB_OUT WF_NS_CMB_PEND WF_NS_CMB_TOTAL WF_NS_CON_OUT WF_NS_CON_TOTAL WF_NS_DL_MPN WF_NS_DLG_MPN WF_NS_DLP_MPN WF_NS_FILLER_006A WF_NS_IAAS_OVP WF_NS_IAAS_OVP_CTC WF_NS_L01_AMT WF_NS_L01_BEG_DATE WF_NS_L01_CAP WF_NS_L01_CHG WF_NS_L01_CONTACT WF_NS_L01_CTC_TYPE WF_NS_L01_DSB WF_NS_L01_DSB_DATE WF_NS_L01_END_DATE WF_NS_L01_GA WF_NS_L01_LEVEL WF_NS_L01_OUT WF_NS_L01_OUT_DATE WF_NS_L01_PROG WF_NS_L01_SCHOOL WF_NS_L01_SEQ WF_NS_L01_STA WF_NS_L01_STA_DATE WF_NS_L01_SUBSIDY WF_NS_L01_SUBSIDY_DT WF_NS_L01_TYPE WF_NS_L01_XUNS WF_NS_L02_AMT WF_NS_L02_BEG_DATE WF_NS_L02_CAP WF_NS_L02_CHG WF_NS_L02_CONTACT WF_NS_L02_CTC_TYPE WF_NS_L02_DSB WF_NS_L02_DSB_DATE WF_NS_L02_END_DATE WF_NS_L02_GA WF_NS_L02_LEVEL WF_NS_L02_OUT WF_NS_L02_OUT_DATE WF_NS_L02_PROG WF_NS_L02_SCHOOL WF_NS_L02_SEQ WF_NS_L02_STA WF_NS_L02_STA_DATE WF_NS_L02_SUBSIDY WF_NS_L02_SUBSIDY_DT WF_NS_L02_TYPE WF_NS_L02_XUNS WF_NS_L03_AMT WF_NS_L03_BEG_DATE WF_NS_L03_CAP WF_NS_L03_CHG WF_NS_L03_CONTACT WF_NS_L03_CTC_TYPE WF_NS_L03_DSB WF_NS_L03_DSB_DATE WF_NS_L03_END_DATE WF_NS_L03_GA WF_NS_L03_LEVEL WF_NS_L03_OUT WF_NS_L03_OUT_DATE WF_NS_L03_PROG WF_NS_L03_SCHOOL WF_NS_L03_SEQ WF_NS_L03_STA WF_NS_L03_STA_DATE WF_NS_L03_SUBSIDY WF_NS_L03_SUBSIDY_DT WF_NS_L03_TYPE WF_NS_L03_XUNS WF_NS_L04_AMT WF_NS_L04_BEG_DATE WF_NS_L04_CAP WF_NS_L04_CHG WF_NS_L04_CONTACT WF_NS_L04_CTC_TYPE WF_NS_L04_DSB WF_NS_L04_DSB_DATE WF_NS_L04_END_DATE WF_NS_L04_GA WF_NS_L04_LEVEL WF_NS_L04_OUT WF_NS_L04_OUT_DATE WF_NS_L04_PROG WF_NS_L04_SCHOOL WF_NS_L04_SEQ WF_NS_L04_STA WF_NS_L04_STA_DATE WF_NS_L04_SUBSIDY WF_NS_L04_SUBSIDY_DT WF_NS_L04_TYPE WF_NS_L04_XUNS WF_NS_L05_AMT WF_NS_L05_BEG_DATE WF_NS_L05_CAP WF_NS_L05_CHG WF_NS_L05_CONTACT WF_NS_L05_CTC_TYPE WF_NS_L05_DSB WF_NS_L05_DSB_DATE WF_NS_L05_END_DATE WF_NS_L05_GA WF_NS_L05_LEVEL WF_NS_L05_OUT WF_NS_L05_OUT_DATE WF_NS_L05_PROG WF_NS_L05_SCHOOL WF_NS_L05_SEQ WF_NS_L05_STA WF_NS_L05_STA_DATE WF_NS_L05_SUBSIDY WF_NS_L05_SUBSIDY_DT WF_NS_L05_TYPE WF_NS_L05_XUNS WF_NS_L06_AMT WF_NS_L06_BEG_DATE WF_NS_L06_CAP WF_NS_L06_CHG WF_NS_L06_CONTACT WF_NS_L06_CTC_TYPE WF_NS_L06_DSB WF_NS_L06_DSB_DATE WF_NS_L06_END_DATE WF_NS_L06_GA WF_NS_L06_LEVEL WF_NS_L06_OUT WF_NS_L06_OUT_DATE WF_NS_L06_PROG WF_NS_L06_SCHOOL WF_NS_L06_SEQ WF_NS_L06_STA WF_NS_L06_STA_DATE WF_NS_L06_SUBSIDY WF_NS_L06_SUBSIDY_DT WF_NS_L06_TYPE WF_NS_L06_XUNS WF_NS_LOAN_ADTNL WF_NS_LOAN_CHG WF_NS_LOAN_DEF WF_NS_LOAN_DEF_CHG WF_NS_LOAN_DIS WF_NS_LOAN_DIS_CHG WF_NS_LOAN_FRD WF_NS_LOAN_FRD_CHG WF_NS_LOAN_REP WF_NS_LOAN_REP_CHG WF_NS_OVPMT_CHG WF_NS_P1_ADDL_ELIG WF_NS_P1_AWARD WF_NS_P1_DATE WF_NS_P1_EFC WF_NS_P1_PAID WF_NS_P1_SCH_AWD WF_NS_P1_SCH_PCT WF_NS_P1_SCHOOL WF_NS_P1_SEQ WF_NS_P1_TRAN WF_NS_P1_VER WF_NS_P2_ADDL_ELIG WF_NS_P2_AWARD WF_NS_P2_DATE WF_NS_P2_EFC WF_NS_P2_PAID WF_NS_P2_SCH_AWD WF_NS_P2_SCH_PCT WF_NS_P2_SCHOOL WF_NS_P2_SEQ WF_NS_P2_TRAN WF_NS_P2_VER WF_NS_P3_ADDL_ELIG WF_NS_P3_AWARD WF_NS_P3_DATE WF_NS_P3_EFC WF_NS_P3_PAID WF_NS_P3_SCH_AWD WF_NS_P3_SCH_PCT WF_NS_P3_SCHOOL WF_NS_P3_SEQ WF_NS_P3_TRAN WF_NS_P3_VER WF_NS_PELL_ADTNL WF_NS_PELL_CHG WF_NS_PELL_OVP WF_NS_PELL_OVP_CTC WF_NS_PERK_CUR WF_NS_PERK_OVP WF_NS_PERK_OVP_CTC WF_NS_PERK_TOTAL WF_NS_PERKINS_CHG WF_NS_SEOG_OVP WF_NS_SEOG_OVP_CTC WF_NS_SUB_LIMIT_GR WF_NS_SUB_LIMIT_UG WF_NS_SUB_OUT WF_NS_SUB_PEND WF_NS_SUB_TOTAL WF_NS_T1_AWARD WF_NS_T1_AWDYEAR WF_NS_T1_CONV WF_NS_T1_DATE WF_NS_T1_LEVEL WF_NS_T1_PAID WF_NS_T1_SCH_AWD WF_NS_T1_SCHOOL WF_NS_T1_SEQ WF_NS_T1_SEQCODE WF_NS_T1_TRAN WF_NS_T2_AWARD WF_NS_T2_AWDYEAR WF_NS_T2_CONV WF_NS_T2_DATE WF_NS_T2_LEVEL WF_NS_T2_PAID WF_NS_T2_SCH_AWD WF_NS_T2_SCHOOL WF_NS_T2_SEQ WF_NS_T2_SEQCODE WF_NS_T2_TRAN WF_NS_T3_AWARD WF_NS_T3_AWDYEAR WF_NS_T3_CONV WF_NS_T3_DATE WF_NS_T3_LEVEL WF_NS_T3_PAID WF_NS_T3_SCH_AWD WF_NS_T3_SCHOOL WF_NS_T3_SEQ WF_NS_T3_SEQCODE WF_NS_T3_TRAN WF_NS_TCH_ADTNL WF_NS_TCH_CHG WF_NS_TCH_CONV WF_NS_TCH_CONV_CHG WF_NS_TCH_OUT WF_NS_TCH_OVP WF_NS_TCH_OVP_CTC WF_NS_TCH_TOTAL WF_NS_TCH_TOTAL_GR WF_NS_TCH_TOTAL_UG WF_NS_UNS_OUT WF_NS_UNS_PEND WF_NS_UNS_TOTAL WW_CDATE WW_FILLER_007A WW_FILLER_007B WW_FILLER_007C WW_HOLD WW_MDATE WW_STUDENT_ID
13010 2017-02-06T11:28:52.231-05:00 PB N N N 0286946 N N 000000 N N 011250 000000 011250 N/A N/A A N N 002250 20150107 N N 580 GA 001125 20150319 20150508 580 2 002250 20150430 D1 00151200 01 IA 20150218 N N/A R N 002250 20140512 N N 580 GA 002250 20140625 20140805 580 2 002250 20150430 D1 00151200 02 IA 20140625 N N/A R N 003500 20120823 Y N 580 GA 001750 20130122 20130501 580 1 003434 20150430 D1 00147700 03 DA 20150107 N N/A R N 003500 20110823 N N 580 GA 001750 20120124 20120504 580 1 003376 20150430 D1 00147700 04 DA 20150107 N N/A R N N N N N N N N N N N N N N N N/A N/A N N/A N/A N N N/A N N 011250 000000 011250 N/A N/A N/A 2015-05-18T00:00:00-04:00 1341046 57570635380142516C
2959 2017-02-06T11:28:46.319-05:00 PB N N N 0341657 N N 000000 N N 034947 000000 034947 N/A N/A A N N 006000 20140203 N N 578 GA 003000 20140616 20150130 578 1 006000 20150406 D2 03832300 01 IG 20150116 N N/A R N 003500 20140203 N N 578 GA 001750 20140616 20150130 578 1 003500 20150406 D1 03832300 02 IG 20150116 N N/A R N 002010 20110228 Y N 578 GA 000000 20110426 20110710 578 2 002575 20150406 D2 00814600 03 RP 20150402 N N/A R N 001729 20091005 Y N 05 EDR 001500 20100122 20100620 556 2 003043 20150217 SF 00850100 04 DX 20130807 N N/A R N 002667 20091005 Y N 05 EDR 001333 20100122 20100620 556 2 002932 20150217 SU 00850100 05 DX 20130807 N N/A R N 001333 20091005 Y N 05 EDR 000666 20100122 20100620 556 2 001466 20150217 SU 00850100 06 DX 20130807 N N/A R N Y N N N N N N N Y N N N N N N/A N/A N N/A N/A N N N/A N N 012229 000000 012229 022718 000000 022718 2015-04-27T00:00:00-04:00 1141356 2015-09-22T00:00:00-04:00 57570635912074070C
33975 2017-02-06T11:29:03.681-05:00 PB N N N 0000000 N N 000000 N N N/A N/A N/A N/A N/A N N N N N N N N N N N N N N N N N N/A N/A N N/A N/A N N N/A N N N/A N/A N/A N/A N/A N/A 2016-05-31T00:00:00-04:00 832212 57570636318163411C
23655 2017-02-06T11:28:58.034-05:00 PB N N N 0200008 N N 000000 N N N/A N/A N/A N/A N/A N N N N N N N N N N N N N N N N N N/A N/A N N/A N/A N N N/A N N N/A N/A N/A N/A N/A N/A 2015-08-07T00:00:00-04:00 828415 57570635355961399C
25003 2017-02-06T11:28:58.814-05:00 PB N N N 0000000 N N 000000 N N N/A N/A N/A N/A N/A N N N N N N N N N N N N N N N N N N/A N/A N N/A N/A N N N/A N N N/A N/A N/A N/A N/A N/A 2015-08-17T00:00:00-04:00 1257259 2015-09-22T00:00:00-04:00 57570636069330559C
27807 2017-02-06T11:29:00.296-05:00 PB N N N 0200000 N N 000000 N N N/A N/A N/A N/A N/A N N N N N N N N N N N N N N N N N N/A N/A N N/A N/A N N N/A N N N/A N/A N/A N/A N/A N/A 2015-09-22T00:00:00-04:00 1302326 57570634378784921C
2443 2017-02-06T11:28:46.038-05:00 PB N N N 0597894 C N 000000 N N 008792 000000 008792 N/A N/A N N N 002667 20001002 Y # 800 GA 001333 20010108 20010323 800 2 004043 20160723 SU 02280800 01 DF 20160715 N N/A D N 002333 20001002 Y # 800 GA 001166 20010108 20010323 800 2 002697 20160723 SF 02280800 02 DF 20160715 N N/A D N 001167 20000403 Y N 700191 LNS 001167 20000405 20001215 800 2 001340 20160630 SF 02280800 03 RP 20160306 N N/A R N 002625 19990706 Y N 700191 LNS 000875 20000104 20000317 800 1 003013 20160630 SF 02280800 04 RP 20160306 N N/A R N 000000 20090107 N N 712 GA N/A N/A 20090508 712 2 000000 20090211 SF 00151200 05 CA 20090211 N N/A R N N N Y # N N N N N N N N N N N/A N/A N N/A N/A N N N/A N N 006125 000000 006125 002667 000000 002667 2015-04-27T00:00:00-04:00 827112 2016-07-27T00:00:00-04:00 57570632205610113C
20815 2017-02-06T11:28:56.412-05:00 PB N N N 0100000 N Y 000900 N N 005500 000000 005500 N/A N/A A N N 003500 20140818 N N 579 GA 001750 20150123 20150507 579 1 003500 20150630 D0 00345100 01 IA 20140827 N N/A R N 002000 20140818 N N 579 GA 001000 20150123 20150507 579 1 002000 20150630 D2 00345100 02 IA 20140827 N N/A R N N N N N N N N N N N N N # N N/A N/A N N/A N/A N N N/A N N 003500 000000 003500 002000 000000 002000 2015-07-20T00:00:00-04:00 1025207 57570636045207206C
25517 2017-02-06T11:28:59.095-05:00 PB N N N 0000000 N N 000000 N N N/A N/A N/A N/A N/A N N N N N N N N N N N N N N N N N N/A N/A N N/A N/A N N N/A N N N/A N/A N/A N/A N/A N/A 2015-08-24T00:00:00-04:00 1109096 2015-09-22T00:00:00-04:00 57570636075381701C
27799 2017-02-06T11:29:00.296-05:00 PB N N N 0314418 N N 000000 N N 017122 000000 017122 N/A N/A N N N 001500 20091003 Y N 700578 LNS 001500 20091008 20100619 578 2 001580 20150907 SF 01303900 01 RP 20140419 N N/A R N 000206 20091003 Y N 700578 LNS 002000 20091008 20100619 578 2 000260 20150907 SU 01303900 02 RP 20140419 N N/A R N 002080 20090404 Y N 700578 LNS 002080 20090413 20090620 578 2 002550 20150907 SU 01303900 03 RP 20140419 N N/A R N 002223 20090404 Y N 700578 LNS 002223 20090413 20090620 578 2 002477 20150907 SF 01303900 04 RP 20140419 N N/A R N 002277 20081004 Y N 700578 LNS 001500 20090120 20090620 578 2 002536 20150907 SF 01303900 05 RP 20140419 N N/A R N 002000 20081004 Y N 700578 LNS 002000 20090120 20090620 578 2 002529 20150907 SU 01303900 06 RP 20140419 N N/A R N Y N N N N N N N N N N N N N N/A N/A N N/A N/A N N N/A N N 009108 000000 009108 008014 000000 008014 2015-09-22T00:00:00-04:00 1241490 57570631916275436C
Powered by BI Documenter