DWStaging
 dbo.WF_AWARD (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_AWARD
  Properties
Property Value
Name WF_AWARD
Schema dbo
Row Count 507477
Data Size 92368 KB
Index Size 8024 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_AWARD
int(10, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
WF_AID_YEAR
varchar(4)
True
False
False
 
WF_AW_ACC
decimal(7, 2)
True
False
False
 
WF_AW_CAN
decimal(7, 2)
True
False
False
 
WF_AW_D01_A_DATE
date(10, 0)
True
False
False
 
WF_AW_D01_A_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D01_A_NUM
int(10, 0)
True
False
False
 
WF_AW_D01_A_REL
varchar(1)
True
False
False
 
WF_AW_D01_A_SEQ
int(10, 0)
True
False
False
 
WF_AW_D01_ACC
decimal(7, 2)
True
False
False
 
WF_AW_D01_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D01_OFF
decimal(7, 2)
True
False
False
 
WF_AW_D01_R_DATE
date(10, 0)
True
False
False
 
WF_AW_D01_R_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D01_R_NUM
int(10, 0)
True
False
False
 
WF_AW_D01_R_REL
varchar(1)
True
False
False
 
WF_AW_D01_R_SEQ
int(10, 0)
True
False
False
 
WF_AW_D02_A_DATE
date(10, 0)
True
False
False
 
WF_AW_D02_A_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D02_A_NUM
int(10, 0)
True
False
False
 
WF_AW_D02_A_REL
varchar(1)
True
False
False
 
WF_AW_D02_A_SEQ
int(10, 0)
True
False
False
 
WF_AW_D02_ACC
decimal(7, 2)
True
False
False
 
WF_AW_D02_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D02_OFF
decimal(7, 2)
True
False
False
 
WF_AW_D02_R_DATE
date(10, 0)
True
False
False
 
WF_AW_D02_R_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D02_R_NUM
int(10, 0)
True
False
False
 
WF_AW_D02_R_REL
varchar(1)
True
False
False
 
WF_AW_D02_R_SEQ
int(10, 0)
True
False
False
 
WF_AW_D03_A_DATE
date(10, 0)
True
False
False
 
WF_AW_D03_A_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D03_A_NUM
int(10, 0)
True
False
False
 
WF_AW_D03_A_REL
varchar(1)
True
False
False
 
WF_AW_D03_A_SEQ
int(10, 0)
True
False
False
 
WF_AW_D03_ACC
decimal(7, 2)
True
False
False
 
WF_AW_D03_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D03_OFF
decimal(7, 2)
True
False
False
 
WF_AW_D03_R_DATE
date(10, 0)
True
False
False
 
WF_AW_D03_R_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D03_R_NUM
int(10, 0)
True
False
False
 
WF_AW_D03_R_REL
varchar(1)
True
False
False
 
WF_AW_D03_R_SEQ
int(10, 0)
True
False
False
 
WF_AW_D04_A_DATE
date(10, 0)
True
False
False
 
WF_AW_D04_A_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D04_A_NUM
int(10, 0)
True
False
False
 
WF_AW_D04_A_REL
varchar(1)
True
False
False
 
WF_AW_D04_A_SEQ
int(10, 0)
True
False
False
 
WF_AW_D04_ACC
decimal(7, 2)
True
False
False
 
WF_AW_D04_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D04_OFF
decimal(7, 2)
True
False
False
 
WF_AW_D04_R_DATE
date(10, 0)
True
False
False
 
WF_AW_D04_R_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D04_R_NUM
int(10, 0)
True
False
False
 
WF_AW_D04_R_REL
varchar(1)
True
False
False
 
WF_AW_D04_R_SEQ
int(10, 0)
True
False
False
 
WF_AW_D05_A_DATE
date(10, 0)
True
False
False
 
WF_AW_D05_A_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D05_A_NUM
int(10, 0)
True
False
False
 
WF_AW_D05_A_REL
varchar(1)
True
False
False
 
WF_AW_D05_A_SEQ
int(10, 0)
True
False
False
 
WF_AW_D05_ACC
decimal(7, 2)
True
False
False
 
WF_AW_D05_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D05_OFF
decimal(7, 2)
True
False
False
 
WF_AW_D05_R_DATE
date(10, 0)
True
False
False
 
WF_AW_D05_R_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D05_R_NUM
int(10, 0)
True
False
False
 
WF_AW_D05_R_REL
varchar(1)
True
False
False
 
WF_AW_D05_R_SEQ
int(10, 0)
True
False
False
 
WF_AW_D06_A_DATE
date(10, 0)
True
False
False
 
WF_AW_D06_A_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D06_A_NUM
int(10, 0)
True
False
False
 
WF_AW_D06_A_REL
varchar(1)
True
False
False
 
WF_AW_D06_A_SEQ
int(10, 0)
True
False
False
 
WF_AW_D06_ACC
decimal(7, 2)
True
False
False
 
WF_AW_D06_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D06_OFF
decimal(7, 2)
True
False
False
 
WF_AW_D06_R_DATE
date(10, 0)
True
False
False
 
WF_AW_D06_R_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D06_R_NUM
int(10, 0)
True
False
False
 
WF_AW_D06_R_REL
varchar(1)
True
False
False
 
WF_AW_D06_R_SEQ
int(10, 0)
True
False
False
 
WF_AW_D07_A_DATE
date(10, 0)
True
False
False
 
WF_AW_D07_A_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D07_A_NUM
int(10, 0)
True
False
False
 
WF_AW_D07_A_REL
varchar(1)
True
False
False
 
WF_AW_D07_A_SEQ
int(10, 0)
True
False
False
 
WF_AW_D07_ACC
decimal(7, 2)
True
False
False
 
WF_AW_D07_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D07_OFF
decimal(7, 2)
True
False
False
 
WF_AW_D07_R_DATE
date(10, 0)
True
False
False
 
WF_AW_D07_R_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D07_R_NUM
int(10, 0)
True
False
False
 
WF_AW_D07_R_REL
varchar(1)
True
False
False
 
WF_AW_D07_R_SEQ
int(10, 0)
True
False
False
 
WF_AW_D08_A_DATE
date(10, 0)
True
False
False
 
WF_AW_D08_A_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D08_A_NUM
int(10, 0)
True
False
False
 
WF_AW_D08_A_REL
varchar(1)
True
False
False
 
WF_AW_D08_A_SEQ
int(10, 0)
True
False
False
 
WF_AW_D08_ACC
decimal(7, 2)
True
False
False
 
WF_AW_D08_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D08_OFF
decimal(7, 2)
True
False
False
 
WF_AW_D08_R_DATE
date(10, 0)
True
False
False
 
WF_AW_D08_R_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D08_R_NUM
int(10, 0)
True
False
False
 
WF_AW_D08_R_REL
varchar(1)
True
False
False
 
WF_AW_D08_R_SEQ
int(10, 0)
True
False
False
 
WF_AW_D09_A_DATE
date(10, 0)
True
False
False
 
WF_AW_D09_A_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D09_A_NUM
int(10, 0)
True
False
False
 
WF_AW_D09_A_REL
varchar(1)
True
False
False
 
WF_AW_D09_A_SEQ
int(10, 0)
True
False
False
 
WF_AW_D09_ACC
decimal(7, 2)
True
False
False
 
WF_AW_D09_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D09_OFF
decimal(7, 2)
True
False
False
 
WF_AW_D09_R_DATE
date(10, 0)
True
False
False
 
WF_AW_D09_R_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D09_R_NUM
int(10, 0)
True
False
False
 
WF_AW_D09_R_REL
varchar(1)
True
False
False
 
WF_AW_D09_R_SEQ
int(10, 0)
True
False
False
 
WF_AW_D10_A_DATE
date(10, 0)
True
False
False
 
WF_AW_D10_A_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D10_A_NUM
int(10, 0)
True
False
False
 
WF_AW_D10_A_REL
varchar(1)
True
False
False
 
WF_AW_D10_A_SEQ
int(10, 0)
True
False
False
 
WF_AW_D10_ACC
decimal(7, 2)
True
False
False
 
WF_AW_D10_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D10_OFF
decimal(7, 2)
True
False
False
 
WF_AW_D10_R_DATE
date(10, 0)
True
False
False
 
WF_AW_D10_R_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D10_R_NUM
int(10, 0)
True
False
False
 
WF_AW_D10_R_REL
varchar(1)
True
False
False
 
WF_AW_D10_R_SEQ
int(10, 0)
True
False
False
 
WF_AW_D11_A_DATE
date(10, 0)
True
False
False
 
WF_AW_D11_A_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D11_A_NUM
int(10, 0)
True
False
False
 
WF_AW_D11_A_REL
varchar(1)
True
False
False
 
WF_AW_D11_A_SEQ
int(10, 0)
True
False
False
 
WF_AW_D11_ACC
decimal(7, 2)
True
False
False
 
WF_AW_D11_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D11_OFF
decimal(7, 2)
True
False
False
 
WF_AW_D11_R_DATE
date(10, 0)
True
False
False
 
WF_AW_D11_R_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D11_R_NUM
int(10, 0)
True
False
False
 
WF_AW_D11_R_REL
varchar(1)
True
False
False
 
WF_AW_D11_R_SEQ
int(10, 0)
True
False
False
 
WF_AW_D12_A_DATE
date(10, 0)
True
False
False
 
WF_AW_D12_A_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D12_A_NUM
int(10, 0)
True
False
False
 
WF_AW_D12_A_REL
varchar(1)
True
False
False
 
WF_AW_D12_A_SEQ
int(10, 0)
True
False
False
 
WF_AW_D12_ACC
decimal(7, 2)
True
False
False
 
WF_AW_D12_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D12_OFF
decimal(7, 2)
True
False
False
 
WF_AW_D12_R_DATE
date(10, 0)
True
False
False
 
WF_AW_D12_R_DIS
decimal(7, 2)
True
False
False
 
WF_AW_D12_R_NUM
int(10, 0)
True
False
False
 
WF_AW_D12_R_REL
varchar(1)
True
False
False
 
WF_AW_D12_R_SEQ
int(10, 0)
True
False
False
 
WF_AW_DIS
decimal(7, 2)
True
False
False
 
WF_AW_DIST
varchar(1)
True
False
False
 
WF_AW_OFF
decimal(7, 2)
True
False
False
 
WF_AW_REJ
decimal(7, 2)
True
False
False
 
WF_FAO
varchar(2)
True
False
False
 
WF_FUND_ID
varchar(9)
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_AWARD
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.WF_AWARD depends on)
Name Type
  Child Dependencies (objects that depend on dbo.WF_AWARD)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[WF_AWARD] Script Date: 03/09/2017 16:46:39 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[WF_AWARD](
    [ISN_WF_AWARD] [int] NOT NULL,
    [WW_STUDENT_ID] [char](18) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FUND_ID] [varchar](9) 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,
    [WW_HOLD] [int] NULL,
    [WW_CDATE] [date] NULL,
    [WW_MDATE] [date] NULL,
    [WF_AW_DIST] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_OFF] [decimal](7, 2) NULL,
    [WF_AW_CAN] [decimal](7, 2) NULL,
    [WF_AW_ACC] [decimal](7, 2) NULL,
    [WF_AW_REJ] [decimal](7, 2) NULL,
    [WF_AW_DIS] [decimal](7, 2) NULL,
    [WF_AW_D01_OFF] [decimal](7, 2) NULL,
    [WF_AW_D01_ACC] [decimal](7, 2) NULL,
    [WF_AW_D01_DIS] [decimal](7, 2) NULL,
    [WF_AW_D01_R_NUM] [int] NULL,
    [WF_AW_D01_R_SEQ] [int] NULL,
    [WF_AW_D01_R_DIS] [decimal](7, 2) NULL,
    [WF_AW_D01_R_DATE] [date] NULL,
    [WF_AW_D01_R_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D01_A_NUM] [int] NULL,
    [WF_AW_D01_A_SEQ] [int] NULL,
    [WF_AW_D01_A_DIS] [decimal](7, 2) NULL,
    [WF_AW_D01_A_DATE] [date] NULL,
    [WF_AW_D01_A_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D02_OFF] [decimal](7, 2) NULL,
    [WF_AW_D02_ACC] [decimal](7, 2) NULL,
    [WF_AW_D02_DIS] [decimal](7, 2) NULL,
    [WF_AW_D02_R_NUM] [int] NULL,
    [WF_AW_D02_R_SEQ] [int] NULL,
    [WF_AW_D02_R_DIS] [decimal](7, 2) NULL,
    [WF_AW_D02_R_DATE] [date] NULL,
    [WF_AW_D02_R_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D02_A_NUM] [int] NULL,
    [WF_AW_D02_A_SEQ] [int] NULL,
    [WF_AW_D02_A_DIS] [decimal](7, 2) NULL,
    [WF_AW_D02_A_DATE] [date] NULL,
    [WF_AW_D02_A_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D03_OFF] [decimal](7, 2) NULL,
    [WF_AW_D03_ACC] [decimal](7, 2) NULL,
    [WF_AW_D03_DIS] [decimal](7, 2) NULL,
    [WF_AW_D03_R_NUM] [int] NULL,
    [WF_AW_D03_R_SEQ] [int] NULL,
    [WF_AW_D03_R_DIS] [decimal](7, 2) NULL,
    [WF_AW_D03_R_DATE] [date] NULL,
    [WF_AW_D03_R_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D03_A_NUM] [int] NULL,
    [WF_AW_D03_A_SEQ] [int] NULL,
    [WF_AW_D03_A_DIS] [decimal](7, 2) NULL,
    [WF_AW_D03_A_DATE] [date] NULL,
    [WF_AW_D03_A_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D04_OFF] [decimal](7, 2) NULL,
    [WF_AW_D04_ACC] [decimal](7, 2) NULL,
    [WF_AW_D04_DIS] [decimal](7, 2) NULL,
    [WF_AW_D04_R_NUM] [int] NULL,
    [WF_AW_D04_R_SEQ] [int] NULL,
    [WF_AW_D04_R_DIS] [decimal](7, 2) NULL,
    [WF_AW_D04_R_DATE] [date] NULL,
    [WF_AW_D04_R_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D04_A_NUM] [int] NULL,
    [WF_AW_D04_A_SEQ] [int] NULL,
    [WF_AW_D04_A_DIS] [decimal](7, 2) NULL,
    [WF_AW_D04_A_DATE] [date] NULL,
    [WF_AW_D04_A_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D05_OFF] [decimal](7, 2) NULL,
    [WF_AW_D05_ACC] [decimal](7, 2) NULL,
    [WF_AW_D05_DIS] [decimal](7, 2) NULL,
    [WF_AW_D05_R_NUM] [int] NULL,
    [WF_AW_D05_R_SEQ] [int] NULL,
    [WF_AW_D05_R_DIS] [decimal](7, 2) NULL,
    [WF_AW_D05_R_DATE] [date] NULL,
    [WF_AW_D05_R_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D05_A_NUM] [int] NULL,
    [WF_AW_D05_A_SEQ] [int] NULL,
    [WF_AW_D05_A_DIS] [decimal](7, 2) NULL,
    [WF_AW_D05_A_DATE] [date] NULL,
    [WF_AW_D05_A_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D06_OFF] [decimal](7, 2) NULL,
    [WF_AW_D06_ACC] [decimal](7, 2) NULL,
    [WF_AW_D06_DIS] [decimal](7, 2) NULL,
    [WF_AW_D06_R_NUM] [int] NULL,
    [WF_AW_D06_R_SEQ] [int] NULL,
    [WF_AW_D06_R_DIS] [decimal](7, 2) NULL,
    [WF_AW_D06_R_DATE] [date] NULL,
    [WF_AW_D06_R_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D06_A_NUM] [int] NULL,
    [WF_AW_D06_A_SEQ] [int] NULL,
    [WF_AW_D06_A_DIS] [decimal](7, 2) NULL,
    [WF_AW_D06_A_DATE] [date] NULL,
    [WF_AW_D06_A_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D07_OFF] [decimal](7, 2) NULL,
    [WF_AW_D07_ACC] [decimal](7, 2) NULL,
    [WF_AW_D07_DIS] [decimal](7, 2) NULL,
    [WF_AW_D07_R_NUM] [int] NULL,
    [WF_AW_D07_R_SEQ] [int] NULL,
    [WF_AW_D07_R_DIS] [decimal](7, 2) NULL,
    [WF_AW_D07_R_DATE] [date] NULL,
    [WF_AW_D07_R_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D07_A_NUM] [int] NULL,
    [WF_AW_D07_A_SEQ] [int] NULL,
    [WF_AW_D07_A_DIS] [decimal](7, 2) NULL,
    [WF_AW_D07_A_DATE] [date] NULL,
    [WF_AW_D07_A_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D08_OFF] [decimal](7, 2) NULL,
    [WF_AW_D08_ACC] [decimal](7, 2) NULL,
    [WF_AW_D08_DIS] [decimal](7, 2) NULL,
    [WF_AW_D08_R_NUM] [int] NULL,
    [WF_AW_D08_R_SEQ] [int] NULL,
    [WF_AW_D08_R_DIS] [decimal](7, 2) NULL,
    [WF_AW_D08_R_DATE] [date] NULL,
    [WF_AW_D08_R_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D08_A_NUM] [int] NULL,
    [WF_AW_D08_A_SEQ] [int] NULL,
    [WF_AW_D08_A_DIS] [decimal](7, 2) NULL,
    [WF_AW_D08_A_DATE] [date] NULL,
    [WF_AW_D08_A_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D09_OFF] [decimal](7, 2) NULL,
    [WF_AW_D09_ACC] [decimal](7, 2) NULL,
    [WF_AW_D09_DIS] [decimal](7, 2) NULL,
    [WF_AW_D09_R_NUM] [int] NULL,
    [WF_AW_D09_R_SEQ] [int] NULL,
    [WF_AW_D09_R_DIS] [decimal](7, 2) NULL,
    [WF_AW_D09_R_DATE] [date] NULL,
    [WF_AW_D09_R_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D09_A_NUM] [int] NULL,
    [WF_AW_D09_A_SEQ] [int] NULL,
    [WF_AW_D09_A_DIS] [decimal](7, 2) NULL,
    [WF_AW_D09_A_DATE] [date] NULL,
    [WF_AW_D09_A_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D10_OFF] [decimal](7, 2) NULL,
    [WF_AW_D10_ACC] [decimal](7, 2) NULL,
    [WF_AW_D10_DIS] [decimal](7, 2) NULL,
    [WF_AW_D10_R_NUM] [int] NULL,
    [WF_AW_D10_R_SEQ] [int] NULL,
    [WF_AW_D10_R_DIS] [decimal](7, 2) NULL,
    [WF_AW_D10_R_DATE] [date] NULL,
    [WF_AW_D10_R_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D10_A_NUM] [int] NULL,
    [WF_AW_D10_A_SEQ] [int] NULL,
    [WF_AW_D10_A_DIS] [decimal](7, 2) NULL,
    [WF_AW_D10_A_DATE] [date] NULL,
    [WF_AW_D10_A_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D11_OFF] [decimal](7, 2) NULL,
    [WF_AW_D11_ACC] [decimal](7, 2) NULL,
    [WF_AW_D11_DIS] [decimal](7, 2) NULL,
    [WF_AW_D11_R_NUM] [int] NULL,
    [WF_AW_D11_R_SEQ] [int] NULL,
    [WF_AW_D11_R_DIS] [decimal](7, 2) NULL,
    [WF_AW_D11_R_DATE] [date] NULL,
    [WF_AW_D11_R_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D11_A_NUM] [int] NULL,
    [WF_AW_D11_A_SEQ] [int] NULL,
    [WF_AW_D11_A_DIS] [decimal](7, 2) NULL,
    [WF_AW_D11_A_DATE] [date] NULL,
    [WF_AW_D11_A_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D12_OFF] [decimal](7, 2) NULL,
    [WF_AW_D12_ACC] [decimal](7, 2) NULL,
    [WF_AW_D12_DIS] [decimal](7, 2) NULL,
    [WF_AW_D12_R_NUM] [int] NULL,
    [WF_AW_D12_R_SEQ] [int] NULL,
    [WF_AW_D12_R_DIS] [decimal](7, 2) NULL,
    [WF_AW_D12_R_DATE] [date] NULL,
    [WF_AW_D12_R_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AW_D12_A_NUM] [int] NULL,
    [WF_AW_D12_A_SEQ] [int] NULL,
    [WF_AW_D12_A_DIS] [decimal](7, 2) NULL,
    [WF_AW_D12_A_DATE] [date] NULL,
    [WF_AW_D12_A_REL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ISN_WF_AWARD RowUpdatedOn WF_AID_YEAR WF_AW_ACC WF_AW_CAN WF_AW_D01_A_REL WF_AW_D01_ACC WF_AW_D01_DIS WF_AW_D01_OFF WF_AW_D01_R_REL WF_AW_D02_A_REL WF_AW_D02_ACC WF_AW_D02_DIS WF_AW_D02_OFF WF_AW_D02_R_REL WF_AW_D03_A_REL WF_AW_D03_ACC WF_AW_D03_DIS WF_AW_D03_OFF WF_AW_D03_R_REL WF_AW_D04_A_REL WF_AW_D04_ACC WF_AW_D04_DIS WF_AW_D04_OFF WF_AW_D04_R_REL WF_AW_D05_A_REL WF_AW_D05_R_REL WF_AW_D06_A_REL WF_AW_D06_R_REL WF_AW_D07_A_DATE WF_AW_D07_A_DIS WF_AW_D07_A_NUM WF_AW_D07_A_REL WF_AW_D07_A_SEQ WF_AW_D07_ACC WF_AW_D07_DIS WF_AW_D07_OFF WF_AW_D07_R_REL WF_AW_D08_A_REL WF_AW_D08_R_REL WF_AW_D09_A_REL WF_AW_D09_R_REL WF_AW_D10_A_REL WF_AW_D10_R_REL WF_AW_D11_A_REL WF_AW_D11_R_REL WF_AW_D12_A_REL WF_AW_D12_R_REL WF_AW_DIS WF_AW_DIST WF_AW_OFF WF_FAO WF_FUND_ID WW_CDATE WW_HOLD WW_MDATE WW_STUDENT_ID
11738 2017-02-06T10:37:26.297-05:00 2000 1563.00 E PB FEDPELL 1999-12-16T00:00:00-05:00 1400507 2000-05-23T00:00:00-04:00 57570630946640786C
322446 2017-02-06T10:39:21.925-05:00 2012 2082.00 2012-06-20T00:00:00-04:00 2082.00 1 Y 1 2082.00 2082.00 2082.00 2082.00 E 2082.00 PB FEDPELL 2012-04-23T00:00:00-04:00 1137362 2012-06-25T00:00:00-04:00 57570634732939500C
268551 2017-02-06T10:39:02.706-05:00 2011 1200.00 C PB FDSTEWVOC 2010-10-20T00:00:00-04:00 1125385 2010-10-22T00:00:00-04:00 57570634081559635C
244798 2017-02-06T10:38:53.112-05:00 2011 4500.00 2250.00 2250.00 2250.00 2250.00 2250.00 2250.00 4500.00 4500.00 PB FEDDLSUB 2010-06-16T00:00:00-04:00 532076 2011-01-25T00:00:00-05:00 57570634117880046C
23716 2017-02-06T10:37:31.118-05:00 2000 1859.00 1115.00 1115.00 1115.00 744.00 744.00 744.00 1859.00 A 1859.00 PB FEDPELL 2000-09-22T00:00:00-04:00 1415109 2000-09-26T00:00:00-04:00 57570631179295124C
46091 2017-02-06T10:37:39.448-05:00 2002 600.00 300.00 300.00 300.00 300.00 300.00 300.00 600.00 B 600.00 PB SEOGM 2002-03-28T00:00:00-05:00 934362 2002-04-17T00:00:00-04:00 57570631323487593C
405863 2017-02-06T10:39:52.689-05:00 2015 4302.00 A PB PELL-EST 2014-07-02T00:00:00-04:00 1429524 2015-03-03T00:00:00-05:00 57570633531816493C
351219 2017-02-06T10:39:32.986-05:00 2013 1000.00 500.00 500.00 500.00 500.00 500.00 500.00 1000.00 C 1000.00 PB FDOPPORT2 2012-10-22T00:00:00-04:00 556550 2013-01-23T00:00:00-05:00 57570634764907548C
220220 2017-02-06T10:38:43.923-05:00 2010 375.00 B PB FLFSAGPT 2009-08-31T00:00:00-04:00 535525 2009-09-29T00:00:00-04:00 57570632448485801C
257424 2017-02-06T10:38:58.166-05:00 2011 1750.00 1750.00 A 3500.00 PB FEDDLSUB 2010-08-16T00:00:00-04:00 550165 57570634087427099C
Powered by BI Documenter