DWStaging
 dbo.WF_NSLDS_0506 (Table)
  Properties
Property Value
Name WF_NSLDS_0506
Schema dbo
Row Count 13594
Data Size 4424 KB
Index Size 248 KB
Create Date 2/13/2013 10:29 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ISN_WF_NSLDS_0506
int(10, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
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_CMB_LIMIT
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_DLP_MPN
varchar(1)
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_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_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_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_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_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_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_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_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(5)
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_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(5)
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_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(5)
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
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_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_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_0506
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.WF_NSLDS_0506 depends on)
Name Type
  Child Dependencies (objects that depend on dbo.WF_NSLDS_0506)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[WF_NSLDS_0506] Script Date: 03/09/2017 16:46:57 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[WF_NSLDS_0506](
    [ISN_WF_NSLDS_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_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_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_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_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_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_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_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_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_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_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_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_SUB_LIMIT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_CMB_LIMIT] [varchar](1) 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](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P1_AWARD] [varchar](6) 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](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P2_AWARD] [varchar](6) 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](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_NS_P3_AWARD] [varchar](6) 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_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_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_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_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_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,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ISN_WF_NSLDS_0506 RowUpdatedOn WF_FAO WF_NS_BANKRUPT WF_NS_BANKRUPT_CHG WF_NS_CMB_LIMIT 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_DLP_MPN 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_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_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_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_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_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_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_REP WF_NS_LOAN_REP_CHG WF_NS_OVPMT_CHG 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_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_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 WF_NS_SUB_OUT WF_NS_SUB_PEND WF_NS_SUB_TOTAL WF_NS_UNS_OUT WF_NS_UNS_PEND WF_NS_UNS_TOTAL WW_CDATE WW_HOLD WW_MDATE WW_STUDENT_ID
13514 2017-02-06T11:20:27.739-05:00 PB N 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/A N/A N N/A N/A N N N/A N N/A N/A N/A N/A N/A N/A 2006-07-11T00:00:00-04:00 959200 57570633193230326C
11399 2017-02-06T11:20:26.975-05:00 PB N 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/A N/A N N/A N/A N N N/A N N/A N/A N/A N/A N/A N/A 2005-11-22T00:00:00-05:00 1424282 57570632998022681C
11820 2017-02-06T11:20:27.131-05:00 PB N 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/A N/A N N/A N/A N N N/A N N/A N/A N/A N/A N/A N/A 2005-12-13T00:00:00-05:00 930428 57570633015990426C
7445 2017-02-06T11:20:25.618-05:00 PB N 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/A N/A N N/A N/A N N N/A N N/A N/A N/A N/A N/A N/A 2005-07-18T00:00:00-04:00 737346 57570632888050545C
4420 2017-02-06T11:20:24.51-05:00 PB N 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/A N/A N N/A N/A N N N/A N N/A N/A N/A N/A N/A N/A 2005-10-11T00:00:00-04:00 1456117 57570632961753710C
3466 2017-02-06T11:20:24.136-05:00 PB N 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/A N/A N N/A N/A N N N/A N N/A N/A N/A N/A N/A N/A 2006-03-30T00:00:00-05:00 1455062 57570633108633061C
7728 2017-02-06T11:20:25.743-05:00 PB N 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/A N/A N N/A N/A N N N/A N N/A N/A N/A N/A N/A N/A 2005-10-07T00:00:00-04:00 1304077 2005-11-01T00:00:00-05:00 57570632958105998C
5123 2017-02-06T11:20:24.822-05:00 PB N 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/A N/A N N/A N/A N N N/A N N/A N/A N/A N/A N/A N/A 2005-06-02T00:00:00-04:00 803301 2005-08-16T00:00:00-04:00 57570631916271679C
3577 2017-02-06T11:20:24.229-05:00 PB N 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/A N/A N N/A N/A N N N/A N N/A N/A N/A N/A N/A N/A 2005-05-04T00:00:00-04:00 1358574 57570632823479370C
8462 2017-02-06T11:20:25.977-05:00 PB N 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/A N/A N N/A N/A N N N/A N N/A N/A N/A N/A N/A N/A 2005-08-01T00:00:00-04:00 802461 57570631651733695C
Powered by BI Documenter