DWStaging
 dbo.WF_AIDYEAR (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_AIDYEAR
  Properties
Property Value
Name WF_AIDYEAR
Schema dbo
Row Count 456533
Data Size 131992 KB
Index Size 7240 KB
Create Date 2/24/2014 10:16 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ISN_WF_AIDYEAR
int(10, 0)
False
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
WF_AID_YEAR
varchar(4)
True
False
False
 
WF_AY_A_NOT_C_FMT
varchar(1)
True
False
False
 
WF_AY_A_NOT_DATE
date(10, 0)
True
False
False
 
WF_AY_A_NOT_F_FMT
varchar(1)
True
False
False
 
WF_AY_A_NOT_FREQ
varchar(1)
True
False
False
 
WF_AY_A_NOT_I_FMT
varchar(1)
True
False
False
 
WF_AY_A_NOT_MAX
int(10, 0)
True
False
False
 
WF_AY_A_NOT_OVR
varchar(1)
True
False
False
 
WF_AY_A_NOT_OVR_DATE
date(10, 0)
True
False
False
 
WF_AY_A_NOT_OVR_RSN
varchar(2)
True
False
False
 
WF_AY_A_NOT_START
date(10, 0)
True
False
False
 
WF_AY_A_NOT_STOP
date(10, 0)
True
False
False
 
WF_AY_A_NOT_TOTAL
int(10, 0)
True
False
False
 
WF_AY_A_NOT_TYPE
varchar(1)
True
False
False
 
WF_AY_A_STAT
varchar(1)
True
False
False
 
WF_AY_A_STAT_DATE
date(10, 0)
True
False
False
 
WF_AY_A_STAT_REQ
varchar(1)
True
False
False
 
WF_AY_B_C1_T
varchar(1)
True
False
False
 
WF_AY_B_C2_T
varchar(1)
True
False
False
 
WF_AY_B_C3_T
varchar(1)
True
False
False
 
WF_AY_B_C4_T
varchar(1)
True
False
False
 
WF_AY_B_C5_T
varchar(1)
True
False
False
 
WF_AY_B_C6_T
varchar(1)
True
False
False
 
WF_AY_B_C7_T
varchar(1)
True
False
False
 
WF_AY_B_C8_T
varchar(1)
True
False
False
 
WF_AY_B_M1_DTL
varchar(1)
True
False
False
 
WF_AY_B_M1_GRP
varchar(1)
True
False
False
 
WF_AY_B_M1_LOCK
varchar(1)
True
False
False
 
WF_AY_B_M2_DTL
varchar(1)
True
False
False
 
WF_AY_B_M2_GRP
varchar(1)
True
False
False
 
WF_AY_B_M2_LOCK
varchar(1)
True
False
False
 
WF_AY_B_M3_DTL
varchar(1)
True
False
False
 
WF_AY_B_M3_GRP
varchar(1)
True
False
False
 
WF_AY_B_M3_LOCK
varchar(1)
True
False
False
 
WF_AY_B_SP1
varchar(2)
True
False
False
 
WF_AY_B_SP2
varchar(2)
True
False
False
 
WF_AY_B_SP3
varchar(2)
True
False
False
 
WF_AY_D_INC_AR
varchar(1)
True
False
False
 
WF_AY_D_NOT_C_FMT
varchar(1)
True
False
False
 
WF_AY_D_NOT_DATE
date(10, 0)
True
False
False
 
WF_AY_D_NOT_F_FMT
varchar(1)
True
False
False
 
WF_AY_D_NOT_FREQ
varchar(1)
True
False
False
 
WF_AY_D_NOT_I_FMT
varchar(1)
True
False
False
 
WF_AY_D_NOT_MAX
int(10, 0)
True
False
False
 
WF_AY_D_NOT_OVR
varchar(1)
True
False
False
 
WF_AY_D_NOT_OVR_DATE
date(10, 0)
True
False
False
 
WF_AY_D_NOT_OVR_RSN
varchar(2)
True
False
False
 
WF_AY_D_NOT_START
date(10, 0)
True
False
False
 
WF_AY_D_NOT_STOP
date(10, 0)
True
False
False
 
WF_AY_D_NOT_TOTAL
int(10, 0)
True
False
False
 
WF_AY_D_NOT_TYPE
varchar(1)
True
False
False
 
WF_AY_D_OVR
varchar(1)
True
False
False
 
WF_AY_D_OVR_DATE
date(10, 0)
True
False
False
 
WF_AY_D_OVR_RSN
varchar(2)
True
False
False
 
WF_AY_D_STAT
varchar(1)
True
False
False
 
WF_AY_D_STAT_DATE
date(10, 0)
True
False
False
 
WF_AY_D_STAT_REQ
varchar(1)
True
False
False
 
WF_AY_D_STOP_AR
varchar(1)
True
False
False
 
WF_AY_M1_ASSUM
varchar(1)
True
False
False
 
WF_AY_M1_BUDGET
decimal(5, 0)
True
False
False
 
WF_AY_M1_C1
decimal(5, 0)
True
False
False
 
WF_AY_M1_C2
decimal(5, 0)
True
False
False
 
WF_AY_M1_C3
decimal(5, 0)
True
False
False
 
WF_AY_M1_C4
decimal(5, 0)
True
False
False
 
WF_AY_M1_C5
decimal(5, 0)
True
False
False
 
WF_AY_M1_C6
decimal(5, 0)
True
False
False
 
WF_AY_M1_C7
decimal(5, 0)
True
False
False
 
WF_AY_M1_C8
decimal(5, 0)
True
False
False
 
WF_AY_M1_DEP
varchar(1)
True
False
False
 
WF_AY_M1_FC
decimal(7, 0)
True
False
False
 
WF_AY_M1_FC_OVR
varchar(1)
True
False
False
 
WF_AY_M1_FISAP
decimal(9, 0)
True
False
False
 
WF_AY_M1_NEED
decimal(5, 0)
True
False
False
 
WF_AY_M1_ORES
decimal(5, 0)
True
False
False
 
WF_AY_M1_PANAL
varchar(1)
True
False
False
 
WF_AY_M1_PC
decimal(7, 0)
True
False
False
 
WF_AY_M1_PCA
decimal(7, 0)
True
False
False
 
WF_AY_M1_PCI
decimal(7, 0)
True
False
False
 
WF_AY_M1_REJ1
varchar(2)
True
False
False
 
WF_AY_M1_REJ2
varchar(2)
True
False
False
 
WF_AY_M1_REJ3
varchar(2)
True
False
False
 
WF_AY_M1_REJ4
varchar(2)
True
False
False
 
WF_AY_M1_REJ5
varchar(2)
True
False
False
 
WF_AY_M1_REJ6
varchar(2)
True
False
False
 
WF_AY_M1_REJ7
varchar(2)
True
False
False
 
WF_AY_M1_REJECT
varchar(1)
True
False
False
 
WF_AY_M1_SANAL
varchar(1)
True
False
False
 
WF_AY_M1_SC
decimal(7, 0)
True
False
False
 
WF_AY_M1_SCA
decimal(7, 0)
True
False
False
 
WF_AY_M1_SCI
decimal(7, 0)
True
False
False
 
WF_AY_M2_ASSUM
varchar(1)
True
False
False
 
WF_AY_M2_BUDGET
decimal(5, 0)
True
False
False
 
WF_AY_M2_C1
decimal(5, 0)
True
False
False
 
WF_AY_M2_C2
decimal(5, 0)
True
False
False
 
WF_AY_M2_C3
decimal(5, 0)
True
False
False
 
WF_AY_M2_C4
decimal(5, 0)
True
False
False
 
WF_AY_M2_C5
decimal(5, 0)
True
False
False
 
WF_AY_M2_C6
decimal(5, 0)
True
False
False
 
WF_AY_M2_C7
decimal(5, 0)
True
False
False
 
WF_AY_M2_C8
decimal(5, 0)
True
False
False
 
WF_AY_M2_DEP
varchar(1)
True
False
False
 
WF_AY_M2_FC
decimal(7, 0)
True
False
False
 
WF_AY_M2_FC_OVR
varchar(1)
True
False
False
 
WF_AY_M2_FISAP
decimal(9, 0)
True
False
False
 
WF_AY_M2_NEED
decimal(5, 0)
True
False
False
 
WF_AY_M2_ORES
decimal(5, 0)
True
False
False
 
WF_AY_M2_PANAL
varchar(1)
True
False
False
 
WF_AY_M2_PC
decimal(7, 0)
True
False
False
 
WF_AY_M2_PCA
decimal(7, 0)
True
False
False
 
WF_AY_M2_PCI
decimal(7, 0)
True
False
False
 
WF_AY_M2_REJ1
varchar(2)
True
False
False
 
WF_AY_M2_REJ2
varchar(2)
True
False
False
 
WF_AY_M2_REJ3
varchar(2)
True
False
False
 
WF_AY_M2_REJ4
varchar(2)
True
False
False
 
WF_AY_M2_REJ5
varchar(2)
True
False
False
 
WF_AY_M2_REJ6
varchar(2)
True
False
False
 
WF_AY_M2_REJ7
varchar(2)
True
False
False
 
WF_AY_M2_REJECT
varchar(1)
True
False
False
 
WF_AY_M2_SANAL
varchar(1)
True
False
False
 
WF_AY_M2_SC
decimal(7, 0)
True
False
False
 
WF_AY_M2_SCA
decimal(7, 0)
True
False
False
 
WF_AY_M2_SCI
decimal(7, 0)
True
False
False
 
WF_AY_M3_ASSUM
varchar(1)
True
False
False
 
WF_AY_M3_BUDGET
decimal(5, 0)
True
False
False
 
WF_AY_M3_C1
decimal(5, 0)
True
False
False
 
WF_AY_M3_C2
decimal(5, 0)
True
False
False
 
WF_AY_M3_C3
decimal(5, 0)
True
False
False
 
WF_AY_M3_C4
decimal(5, 0)
True
False
False
 
WF_AY_M3_C5
decimal(5, 0)
True
False
False
 
WF_AY_M3_C6
decimal(5, 0)
True
False
False
 
WF_AY_M3_C7
decimal(5, 0)
True
False
False
 
WF_AY_M3_C8
decimal(5, 0)
True
False
False
 
WF_AY_M3_DEP
varchar(1)
True
False
False
 
WF_AY_M3_FC
decimal(7, 0)
True
False
False
 
WF_AY_M3_FC_OVR
varchar(1)
True
False
False
 
WF_AY_M3_FISAP
decimal(9, 0)
True
False
False
 
WF_AY_M3_NEED
decimal(5, 0)
True
False
False
 
WF_AY_M3_ORES
decimal(5, 0)
True
False
False
 
WF_AY_M3_PANAL
varchar(1)
True
False
False
 
WF_AY_M3_PC
decimal(7, 0)
True
False
False
 
WF_AY_M3_PCA
decimal(7, 0)
True
False
False
 
WF_AY_M3_PCI
decimal(7, 0)
True
False
False
 
WF_AY_M3_REJ1
varchar(2)
True
False
False
 
WF_AY_M3_REJ2
varchar(2)
True
False
False
 
WF_AY_M3_REJ3
varchar(2)
True
False
False
 
WF_AY_M3_REJ4
varchar(2)
True
False
False
 
WF_AY_M3_REJ5
varchar(2)
True
False
False
 
WF_AY_M3_REJ6
varchar(2)
True
False
False
 
WF_AY_M3_REJ7
varchar(2)
True
False
False
 
WF_AY_M3_REJECT
varchar(1)
True
False
False
 
WF_AY_M3_SANAL
varchar(1)
True
False
False
 
WF_AY_M3_SC
decimal(7, 0)
True
False
False
 
WF_AY_M3_SCA
decimal(7, 0)
True
False
False
 
WF_AY_M3_SCI
decimal(7, 0)
True
False
False
 
WF_AY_N_DUR
int(10, 0)
True
False
False
 
WF_AY_N_M1
varchar(1)
True
False
False
 
WF_AY_N_M2
varchar(1)
True
False
False
 
WF_AY_N_M3
varchar(1)
True
False
False
 
WF_AY_N_VREJ
varchar(1)
True
False
False
 
WF_AY_P_DEN_F_FMT
varchar(1)
True
False
False
 
WF_AY_P_DEN_I_FMT
varchar(1)
True
False
False
 
WF_AY_P_NOT_DATE
date(10, 0)
True
False
False
 
WF_AY_P_NOT_F_FMT
varchar(1)
True
False
False
 
WF_AY_P_NOT_I_FMT
varchar(1)
True
False
False
 
WF_AY_P_NOT_OVR
varchar(1)
True
False
False
 
WF_AY_P_NOT_OVR_DATE
date(10, 0)
True
False
False
 
WF_AY_P_NOT_OVR_RSN
varchar(2)
True
False
False
 
WF_AY_P_NOT_TOTAL
int(10, 0)
True
False
False
 
WF_AY_P_NOT_TYPE
varchar(1)
True
False
False
 
WF_AY_P_STAT
varchar(1)
True
False
False
 
WF_AY_P_STAT_DATE
date(10, 0)
True
False
False
 
WF_AY_PAYMETH_FED
varchar(1)
True
False
False
 
WF_AY_S_RT1_SAP
varchar(1)
True
False
False
 
WF_AY_S_RT1_SAP_DATE
date(10, 0)
True
False
False
 
WF_AY_S_RT1_SAP_RSN
varchar(2)
True
False
False
 
WF_AY_S_RT2_SAP
varchar(1)
True
False
False
 
WF_AY_S_RT2_SAP_DATE
date(10, 0)
True
False
False
 
WF_AY_S_RT2_SAP_RSN
varchar(2)
True
False
False
 
WF_AY_S_RT3_SAP
varchar(1)
True
False
False
 
WF_AY_S_RT3_SAP_DATE
date(10, 0)
True
False
False
 
WF_AY_S_RT3_SAP_RSN
varchar(2)
True
False
False
 
WF_AY_S_RT4_SAP
varchar(1)
True
False
False
 
WF_AY_S_RT4_SAP_DATE
date(10, 0)
True
False
False
 
WF_AY_S_RT4_SAP_RSN
varchar(2)
True
False
False
 
WF_AY_SCHED
varchar(1)
True
False
False
 
WF_AY_SCHED_FED
varchar(1)
True
False
False
 
WF_AY_W_AID
decimal(7, 2)
True
False
False
 
WF_AY_W_AID_FC
decimal(7, 2)
True
False
False
 
WF_AY_W_AID_MN
decimal(7, 2)
True
False
False
 
WF_AY_W_AID_PC
decimal(7, 2)
True
False
False
 
WF_AY_W_AID_SC
decimal(7, 2)
True
False
False
 
WF_AY_W_AID_ST
decimal(7, 2)
True
False
False
 
WF_FAO
varchar(2)
True
False
False
 
WW_CDATE
date(10, 0)
True
False
False
 
WW_HOLD
int(10, 0)
True
False
False
 
WW_MDATE
date(10, 0)
True
False
False
 
WW_STUDENT_ID
char(18)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_WF_AIDYEAR
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.WF_AIDYEAR depends on)
Name Type
  Child Dependencies (objects that depend on dbo.WF_AIDYEAR)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[WF_AIDYEAR] Script Date: 03/09/2017 16:46:39 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[WF_AIDYEAR](
    [ISN_WF_AIDYEAR] [int] NOT NULL,
    [WW_STUDENT_ID] [char](18) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_FAO] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AID_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WW_HOLD] [int] NULL,
    [WW_CDATE] [date] NULL,
    [WW_MDATE] [date] NULL,
    [WF_AY_SCHED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_SCHED_FED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_PAYMETH_FED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_N_DUR] [int] NULL,
    [WF_AY_N_VREJ] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_N_M1] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_N_M2] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_N_M3] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_C1_T] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_C2_T] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_C3_T] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_C4_T] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_C5_T] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_C6_T] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_C7_T] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_C8_T] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_M1_LOCK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_M2_LOCK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_M3_LOCK] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_M1_DTL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_M2_DTL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_M3_DTL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_M1_GRP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_M2_GRP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_M3_GRP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_SP1] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_SP2] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_B_SP3] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_S_RT1_SAP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_S_RT1_SAP_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_S_RT1_SAP_DATE] [date] NULL,
    [WF_AY_S_RT2_SAP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_S_RT2_SAP_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_S_RT2_SAP_DATE] [date] NULL,
    [WF_AY_S_RT3_SAP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_S_RT3_SAP_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_S_RT3_SAP_DATE] [date] NULL,
    [WF_AY_S_RT4_SAP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_S_RT4_SAP_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_S_RT4_SAP_DATE] [date] NULL,
    [WF_AY_W_AID] [decimal](7, 2) NULL,
    [WF_AY_W_AID_MN] [decimal](7, 2) NULL,
    [WF_AY_W_AID_FC] [decimal](7, 2) NULL,
    [WF_AY_W_AID_SC] [decimal](7, 2) NULL,
    [WF_AY_W_AID_PC] [decimal](7, 2) NULL,
    [WF_AY_W_AID_ST] [decimal](7, 2) NULL,
    [WF_AY_M1_REJECT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M1_REJ1] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M1_REJ2] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M1_REJ3] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M1_REJ4] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M1_REJ5] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M1_REJ6] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M1_REJ7] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M1_ASSUM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M1_DEP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M1_FISAP] [decimal](9, 0) NULL,
    [WF_AY_M1_FC_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M1_FC] [decimal](7, 0) NULL,
    [WF_AY_M1_SANAL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M1_SC] [decimal](7, 0) NULL,
    [WF_AY_M1_SCI] [decimal](7, 0) NULL,
    [WF_AY_M1_SCA] [decimal](7, 0) NULL,
    [WF_AY_M1_PANAL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M1_PC] [decimal](7, 0) NULL,
    [WF_AY_M1_PCI] [decimal](7, 0) NULL,
    [WF_AY_M1_PCA] [decimal](7, 0) NULL,
    [WF_AY_M1_ORES] [decimal](5, 0) NULL,
    [WF_AY_M1_BUDGET] [decimal](5, 0) NULL,
    [WF_AY_M1_C1] [decimal](5, 0) NULL,
    [WF_AY_M1_C2] [decimal](5, 0) NULL,
    [WF_AY_M1_C3] [decimal](5, 0) NULL,
    [WF_AY_M1_C4] [decimal](5, 0) NULL,
    [WF_AY_M1_C5] [decimal](5, 0) NULL,
    [WF_AY_M1_C6] [decimal](5, 0) NULL,
    [WF_AY_M1_C7] [decimal](5, 0) NULL,
    [WF_AY_M1_C8] [decimal](5, 0) NULL,
    [WF_AY_M1_NEED] [decimal](5, 0) NULL,
    [WF_AY_M2_REJECT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M2_REJ1] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M2_REJ2] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M2_REJ3] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M2_REJ4] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M2_REJ5] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M2_REJ6] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M2_REJ7] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M2_ASSUM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M2_DEP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M2_FISAP] [decimal](9, 0) NULL,
    [WF_AY_M2_FC_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M2_FC] [decimal](7, 0) NULL,
    [WF_AY_M2_SANAL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M2_SC] [decimal](7, 0) NULL,
    [WF_AY_M2_SCI] [decimal](7, 0) NULL,
    [WF_AY_M2_SCA] [decimal](7, 0) NULL,
    [WF_AY_M2_PANAL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M2_PC] [decimal](7, 0) NULL,
    [WF_AY_M2_PCI] [decimal](7, 0) NULL,
    [WF_AY_M2_PCA] [decimal](7, 0) NULL,
    [WF_AY_M2_ORES] [decimal](5, 0) NULL,
    [WF_AY_M2_BUDGET] [decimal](5, 0) NULL,
    [WF_AY_M2_C1] [decimal](5, 0) NULL,
    [WF_AY_M2_C2] [decimal](5, 0) NULL,
    [WF_AY_M2_C3] [decimal](5, 0) NULL,
    [WF_AY_M2_C4] [decimal](5, 0) NULL,
    [WF_AY_M2_C5] [decimal](5, 0) NULL,
    [WF_AY_M2_C6] [decimal](5, 0) NULL,
    [WF_AY_M2_C7] [decimal](5, 0) NULL,
    [WF_AY_M2_C8] [decimal](5, 0) NULL,
    [WF_AY_M2_NEED] [decimal](5, 0) NULL,
    [WF_AY_M3_REJECT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M3_REJ1] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M3_REJ2] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M3_REJ3] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M3_REJ4] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M3_REJ5] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M3_REJ6] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M3_REJ7] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M3_ASSUM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M3_DEP] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M3_FISAP] [decimal](9, 0) NULL,
    [WF_AY_M3_FC_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M3_FC] [decimal](7, 0) NULL,
    [WF_AY_M3_SANAL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M3_SC] [decimal](7, 0) NULL,
    [WF_AY_M3_SCI] [decimal](7, 0) NULL,
    [WF_AY_M3_SCA] [decimal](7, 0) NULL,
    [WF_AY_M3_PANAL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_M3_PC] [decimal](7, 0) NULL,
    [WF_AY_M3_PCI] [decimal](7, 0) NULL,
    [WF_AY_M3_PCA] [decimal](7, 0) NULL,
    [WF_AY_M3_ORES] [decimal](5, 0) NULL,
    [WF_AY_M3_BUDGET] [decimal](5, 0) NULL,
    [WF_AY_M3_C1] [decimal](5, 0) NULL,
    [WF_AY_M3_C2] [decimal](5, 0) NULL,
    [WF_AY_M3_C3] [decimal](5, 0) NULL,
    [WF_AY_M3_C4] [decimal](5, 0) NULL,
    [WF_AY_M3_C5] [decimal](5, 0) NULL,
    [WF_AY_M3_C6] [decimal](5, 0) NULL,
    [WF_AY_M3_C7] [decimal](5, 0) NULL,
    [WF_AY_M3_C8] [decimal](5, 0) NULL,
    [WF_AY_M3_NEED] [decimal](5, 0) NULL,
    [WF_AY_A_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_A_STAT_REQ] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_A_STAT_DATE] [date] NULL,
    [WF_AY_A_NOT_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_A_NOT_OVR_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_A_NOT_OVR_DATE] [date] NULL,
    [WF_AY_A_NOT_I_FMT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_A_NOT_F_FMT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_A_NOT_C_FMT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_A_NOT_FREQ] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_A_NOT_MAX] [int] NULL,
    [WF_AY_A_NOT_START] [date] NULL,
    [WF_AY_A_NOT_STOP] [date] NULL,
    [WF_AY_A_NOT_TOTAL] [int] NULL,
    [WF_AY_A_NOT_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_A_NOT_DATE] [date] NULL,
    [WF_AY_P_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_P_STAT_DATE] [date] NULL,
    [WF_AY_P_NOT_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_P_NOT_OVR_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_P_NOT_OVR_DATE] [date] NULL,
    [WF_AY_P_NOT_I_FMT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_P_NOT_F_FMT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_P_DEN_I_FMT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_P_DEN_F_FMT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_P_NOT_TOTAL] [int] NULL,
    [WF_AY_P_NOT_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_P_NOT_DATE] [date] NULL,
    [WF_AY_D_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_D_OVR_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_D_OVR_DATE] [date] NULL,
    [WF_AY_D_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_D_STAT_REQ] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_D_STAT_DATE] [date] NULL,
    [WF_AY_D_NOT_OVR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_D_NOT_OVR_RSN] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_D_NOT_OVR_DATE] [date] NULL,
    [WF_AY_D_NOT_I_FMT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_D_NOT_F_FMT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_D_NOT_C_FMT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_D_NOT_FREQ] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_D_NOT_MAX] [int] NULL,
    [WF_AY_D_NOT_START] [date] NULL,
    [WF_AY_D_NOT_STOP] [date] NULL,
    [WF_AY_D_NOT_TOTAL] [int] NULL,
    [WF_AY_D_NOT_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_D_NOT_DATE] [date] NULL,
    [WF_AY_D_STOP_AR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WF_AY_D_INC_AR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ISN_WF_AIDYEAR RowUpdatedOn WF_AID_YEAR WF_AY_A_NOT_C_FMT WF_AY_A_NOT_DATE WF_AY_A_NOT_F_FMT WF_AY_A_NOT_FREQ WF_AY_A_NOT_I_FMT WF_AY_A_NOT_MAX WF_AY_A_NOT_OVR WF_AY_A_NOT_OVR_RSN WF_AY_A_NOT_TOTAL WF_AY_A_NOT_TYPE WF_AY_A_STAT WF_AY_A_STAT_DATE WF_AY_A_STAT_REQ WF_AY_B_C1_T WF_AY_B_C2_T WF_AY_B_C3_T WF_AY_B_C4_T WF_AY_B_C5_T WF_AY_B_C6_T WF_AY_B_C7_T WF_AY_B_C8_T WF_AY_B_M1_DTL WF_AY_B_M1_GRP WF_AY_B_M1_LOCK WF_AY_B_M2_DTL WF_AY_B_M2_GRP WF_AY_B_M2_LOCK WF_AY_B_M3_DTL WF_AY_B_M3_GRP WF_AY_B_M3_LOCK WF_AY_B_SP1 WF_AY_B_SP2 WF_AY_B_SP3 WF_AY_D_INC_AR WF_AY_D_NOT_C_FMT WF_AY_D_NOT_DATE WF_AY_D_NOT_F_FMT WF_AY_D_NOT_FREQ WF_AY_D_NOT_I_FMT WF_AY_D_NOT_MAX WF_AY_D_NOT_OVR WF_AY_D_NOT_OVR_RSN WF_AY_D_NOT_TOTAL WF_AY_D_NOT_TYPE WF_AY_D_OVR WF_AY_D_OVR_DATE WF_AY_D_OVR_RSN WF_AY_D_STAT WF_AY_D_STAT_DATE WF_AY_D_STAT_REQ WF_AY_D_STOP_AR WF_AY_M1_ASSUM WF_AY_M1_BUDGET WF_AY_M1_C1 WF_AY_M1_C2 WF_AY_M1_C3 WF_AY_M1_C4 WF_AY_M1_C5 WF_AY_M1_DEP WF_AY_M1_FC WF_AY_M1_FC_OVR WF_AY_M1_FISAP WF_AY_M1_NEED WF_AY_M1_PANAL WF_AY_M1_REJ1 WF_AY_M1_REJ2 WF_AY_M1_REJ3 WF_AY_M1_REJ4 WF_AY_M1_REJ5 WF_AY_M1_REJ6 WF_AY_M1_REJ7 WF_AY_M1_REJECT WF_AY_M1_SANAL WF_AY_M1_SC WF_AY_M2_ASSUM WF_AY_M2_BUDGET WF_AY_M2_C1 WF_AY_M2_C2 WF_AY_M2_C3 WF_AY_M2_C4 WF_AY_M2_C5 WF_AY_M2_DEP WF_AY_M2_FC WF_AY_M2_FC_OVR WF_AY_M2_FISAP WF_AY_M2_NEED WF_AY_M2_PANAL WF_AY_M2_REJ1 WF_AY_M2_REJ2 WF_AY_M2_REJ3 WF_AY_M2_REJ4 WF_AY_M2_REJ5 WF_AY_M2_REJ6 WF_AY_M2_REJ7 WF_AY_M2_REJECT WF_AY_M2_SANAL WF_AY_M2_SC WF_AY_M3_ASSUM WF_AY_M3_DEP WF_AY_M3_FC_OVR WF_AY_M3_PANAL WF_AY_M3_REJ1 WF_AY_M3_REJ2 WF_AY_M3_REJ3 WF_AY_M3_REJ4 WF_AY_M3_REJ5 WF_AY_M3_REJ6 WF_AY_M3_REJ7 WF_AY_M3_REJECT WF_AY_M3_SANAL WF_AY_N_DUR WF_AY_N_M1 WF_AY_N_M2 WF_AY_N_M3 WF_AY_N_VREJ WF_AY_P_DEN_F_FMT WF_AY_P_DEN_I_FMT WF_AY_P_NOT_DATE WF_AY_P_NOT_F_FMT WF_AY_P_NOT_I_FMT WF_AY_P_NOT_OVR WF_AY_P_NOT_OVR_RSN WF_AY_P_NOT_TOTAL WF_AY_P_NOT_TYPE WF_AY_P_STAT WF_AY_P_STAT_DATE WF_AY_PAYMETH_FED WF_AY_S_RT1_SAP WF_AY_S_RT1_SAP_DATE WF_AY_S_RT1_SAP_RSN WF_AY_S_RT2_SAP WF_AY_S_RT2_SAP_DATE WF_AY_S_RT2_SAP_RSN WF_AY_S_RT3_SAP WF_AY_S_RT3_SAP_DATE WF_AY_S_RT3_SAP_RSN WF_AY_S_RT4_SAP WF_AY_S_RT4_SAP_RSN WF_AY_SCHED WF_AY_SCHED_FED WF_AY_W_AID WF_AY_W_AID_MN WF_AY_W_AID_ST WF_FAO WW_CDATE WW_HOLD WW_MDATE WW_STUDENT_ID
406986 2017-02-06T10:40:43.904-05:00 2016 F C M Q 3 C 2015-07-20T00:00:00-04:00 C U R P N B L D 1 T T F K M S 3 P 2016-05-10T00:00:00-04:00 C 15518 2948 6300 1170 3600 1500 D 1785 15518 B B 15518 2948 6300 1170 3600 1500 D 1785 15518 B B 9 9 F D D 2015-07-22T00:00:00-04:00 Z Z 1 N P 2015-07-22T00:00:00-04:00 1 C 2015-08-11T00:00:00-04:00 C 2015-12-18T00:00:00-05:00 G 2016-05-09T00:00:00-04:00 WW L 3 6525.00 6525.00 6525.00 PB 2015-07-20T00:00:00-04:00 526149 2016-07-30T00:00:00-04:00 57570636045204567C
311439 2017-02-06T10:39:58.383-05:00 2014 F I M H 3 C 2013-03-27T00:00:00-04:00 C U R P N B L D 1 T T F K M S 3 P 2014-06-02T00:00:00-04:00 C 15248 2948 6300 900 3600 1500 D 19479 15248 B R B 14205 2555 6300 900 3150 1300 D 19479 14205 B R B 9 9 F D D 2013-06-17T00:00:00-04:00 A A 1 N P 2013-06-17T00:00:00-04:00 1 C 2013-05-10T00:00:00-04:00 C 2013-05-10T00:00:00-04:00 C 2014-05-08T00:00:00-04:00 L 3 6240.00 6240.00 6240.00 PB 2013-03-27T00:00:00-04:00 18490 2014-08-01T00:00:00-04:00 57570634728557855C
152862 2017-02-06T10:38:46.123-05:00 2009 F 2008-11-10T00:00:00-05:00 I M H 2 1 I C 2009-06-10T00:00:00-04:00 C U R P N B L D 1 T T K M J 2 I 2008-11-10T00:00:00-05:00 C 16200 2300 8100 900 3600 1300 I 1920 16200 B I 1920 B 9 9 F D D A Z U 2008-12-01T00:00:00-05:00 1 H 2008-11-07T00:00:00-05:00 H 2008-12-18T00:00:00-05:00 H 2009-05-08T00:00:00-04:00 P 3 PB 2008-11-07T00:00:00-05:00 38094 2009-08-06T00:00:00-04:00 57570633931850003C
234373 2017-02-06T10:39:23.454-05:00 2012 F 2011-07-13T00:00:00-04:00 N M M 3 3 F I 2011-04-21T00:00:00-04:00 I U R P N B L D 1 T T F 2012-05-08T00:00:00-04:00 K M S 3 2 I I 2011-08-26T00:00:00-04:00 I 17430 2880 8550 900 3600 1500 I 1581 12188 15849 S 1581 I 1581 12188 S 1581 9 9 F D D A A 1 B 2011-05-09T00:00:00-04:00 B 2011-05-09T00:00:00-04:00 B 2012-05-07T00:00:00-04:00 L 3 PB 2011-04-21T00:00:00-04:00 459588 2012-08-13T00:00:00-04:00 57570634705365239C
163091 2017-02-06T10:38:51.131-05:00 2010 F 2009-08-06T00:00:00-04:00 C M Q 2 2 F C 2010-06-02T00:00:00-04:00 C U R P N B L D 1 T T F K M J 2 2010-01-15T00:00:00-05:00 P 2010-05-19T00:00:00-04:00 I 16425 2525 8100 900 3600 1300 I 30414 16425 S 5785 685 3600 400 800 300 I 30414 5785 S 4 9 F D D 2009-10-28T00:00:00-04:00 A Z 1 N P 2009-10-28T00:00:00-04:00 1 C 2009-06-30T00:00:00-04:00 C 2009-12-17T00:00:00-05:00 C 2010-05-07T00:00:00-04:00 P 3 1338.00 1338.00 1338.00 PB 2009-06-30T00:00:00-04:00 12225 2010-08-05T00:00:00-04:00 57570633946509852C
443577 2017-02-06T10:41:01.391-05:00 2017 F 2016-07-20T00:00:00-04:00 C M Q 3 1 I C 2016-08-25T00:00:00-04:00 P U R P N B L D 1 T T F K M S 3 15620 3050 6300 1170 3600 1500 D 19633 15620 R R 13436 2141 6300 1170 2700 1125 D 19633 13436 R R 9 9 F D D 2016-08-25T00:00:00-04:00 Z Z 1 N P 2016-08-25T00:00:00-04:00 1 C 2016-08-17T00:00:00-04:00 C 2016-08-17T00:00:00-04:00 C 2016-08-17T00:00:00-04:00 L 3 3634.00 3634.00 3634.00 PB 2016-07-19T00:00:00-04:00 643196 2016-12-10T00:00:00-05:00 57570635688362423C
80317 2017-02-06T10:38:11.553-05:00 2007 F 2006-10-04T00:00:00-04:00 C M Q 2 2 F I 2006-08-24T00:00:00-04:00 I U R P N B L D 1 T T K M J 2 I 2006-08-28T00:00:00-04:00 C 13700 2046 7650 700 2304 1000 I 2305 28732 11395 R 2305 I 2305 28732 R 2305 9 9 F D D A Z 1 Q 2006-08-24T00:00:00-04:00 C 2008-01-09T00:00:00-05:00 Q 2007-05-07T00:00:00-04:00 P 3 PB 2006-08-24T00:00:00-04:00 1400589 2008-02-07T00:00:00-05:00 57570631862529746C
229380 2017-02-06T10:39:21.067-05:00 2012 F N M M 3 C 2011-04-21T00:00:00-04:00 C U R P N B L D 1 T T F 2012-05-08T00:00:00-04:00 K M S 3 2 I P 2012-05-08T00:00:00-04:00 I 15180 2880 6300 900 3600 1500 D 28469 15180 B B 19323 3648 8400 1200 4200 1875 D 28469 19323 B B 12 9 F D D 2011-06-22T00:00:00-04:00 A A 1 N P 2011-06-22T00:00:00-04:00 1 C 2011-05-09T00:00:00-04:00 C 2011-05-09T00:00:00-04:00 H 2012-05-07T00:00:00-04:00 L 3 10837.00 10837.00 10837.00 PB 2011-04-21T00:00:00-04:00 435156 2012-08-13T00:00:00-04:00 57570634268828323C
323201 2017-02-06T10:40:03.936-05:00 2014 F 2013-07-16T00:00:00-04:00 I M H 3 1 I C 2013-07-15T00:00:00-04:00 C U R P N B L D 1 T T F K M S 3 P 2014-06-02T00:00:00-04:00 C 17837 3287 8550 900 3600 1500 17837 17837 3287 8550 900 3600 1500 17837 9 9 F D D A A 1 C 2013-07-15T00:00:00-04:00 C 2013-07-15T00:00:00-04:00 C 2014-05-08T00:00:00-04:00 L 3 3890.00 3890.00 3890.00 PB 2013-07-15T00:00:00-04:00 44568 2014-08-01T00:00:00-04:00 57570635056116741C
390977 2017-02-06T10:40:36.369-05:00 2016 F C M Q 3 P 2016-06-10T00:00:00-04:00 C U R P N B L D 1 T T F K M S 3 C 2016-05-12T00:00:00-04:00 C 17768 2948 8550 1170 3600 1500 I 9832 17768 B 10075 1965 4275 585 2250 1000 I 9832 10075 B 9 9 F D D 2015-08-13T00:00:00-04:00 Z Z 1 N P 2015-08-12T00:00:00-04:00 1 C 2015-08-11T00:00:00-04:00 C 2015-12-18T00:00:00-05:00 C 2016-05-09T00:00:00-04:00 L 3 3010.00 3010.00 2710.00 PB 2015-04-27T00:00:00-04:00 447221 2016-07-30T00:00:00-04:00 57570635767934661C
Powered by BI Documenter