Table - dbo.ST_PROGRAMS

Property	Value
Name	ST_PROGRAMS_A
Schema	dbo
Row Count	119322
Data Size	44848 KB
Index Size	1816 KB
Create Date	2/26/2016 9:04 AM
Description

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
ADD_DATE	varchar(8)	True	False	False
ADD_PGM	varchar(8)	True	False	False
ADD_TIME	varchar(7)	True	False	False
ADD_USER_ID	varchar(8)	True	False	False
ADM_STAT	varchar(1)	True	False	False
ALLOW_REMOTE_CHANGE_IND	varchar(1)	True	False	False
ANNUAL_COST	numeric(11, 2)	True	False	False
AUDIT_AVAIL_FLG	varchar(1)	True	False	False
AUTO_APPLY_UNCL_CRS	varchar(1)	True	False	False
AUTO_POST_GRAD_MSG	varchar(1)	True	False	False
AWD_TY	varchar(3)	True	False	False
CIP_CD	varchar(10)	True	False	False
CLR_FIN_OBLGTN	varchar(1)	True	False	False
COMPLETE_BY_ALL_DL	varchar(1)	True	False	False
CRD_HNRS_PGM	numeric(4, 2)	True	False	False
CRS_ID_X	varchar(10)	True	False	False
DA_NOTE_TYPE	varchar(2)	True	False	False
DIV_DEPT_CD	varchar(8)	True	False	False
EFF_TRM_9S_COMP_A	varchar(6)	True	False	False
EFF_TRM_9S_COMP_C	varchar(6)	True	False	False
EFF_TRM_9S_COMP_D	varchar(6)	True	False	False
EFF_TRM_9S_COMP_N	varchar(6)	True	False	False
EFF_TRM_A	varchar(6)	True	False	False
EFF_TRM_C	varchar(6)	True	False	False
EFF_TRM_D	varchar(6)	True	False	False
EFF_TRM_G	varchar(6)	True	False	False
EFF_TRM_GR	varchar(6)	True	False	False
EFF_TRM_N	varchar(6)	True	False	False
EFF_TRM_X	varchar(6)	True	False	False
END_TRM	varchar(6)	True	False	False
EXIT_TEST	varchar(4)	True	False	False
FEE_GRP	varchar(2)	True	False	False
FEE_GRP_DLR_AMT	numeric(5, 2)	True	False	False
FIN_AID_APPRVD	varchar(1)	True	False	False
GEN_ED_AREA	varchar(1)	True	False	False
GORDON_RULE_MIN_WORDS	int(10, 0)	True	False	False
GRADUATION_AVAILABLE	varchar(1)	True	False	False
HGH_HNR_GPA	numeric(4, 2)	True	False	False
HNR_GPA	numeric(4, 2)	True	False	False
HOLD	int(10, 0)	True	False	False
HRS_BEFORE_PLACE_ENFORCE	int(10, 0)	True	False	False
HRS_BEFORE_PLACE_EXIST	int(10, 0)	True	False	False
HS_GRADUATION_REQUIRED	varchar(1)	True	False	False
ICS_NUM	varchar(5)	True	False	False
ISN_ST_PROGRAMS_A	int(10, 0)	False	False	False
LA_APPL	varchar(1)	True	False	False
LA_DENIED_PGM	varchar(5)	True	False	False
LA_GRAD_AWD	varchar(35)	True	False	False
LA_INDV_PNTS	varchar(1)	True	False	False
LA_PREPGM_ID	varchar(5)	True	False	False
LA_STAT	varchar(1)	True	False	False
LA_TOT_PNTS	varchar(1)	True	False	False
LIM_ACCEL_MECH_HRS_ALL	numeric(4, 2)	True	False	False
LIM_ENS_CRSES_TO_AREA	varchar(3)	True	False	False
LIM_ENS_HRS	numeric(4, 2)	True	False	False
LIM_MUS_SPC_DRA_CRSES_TO_AREA	varchar(3)	True	False	False
LIM_MUS_SPC_DRA_HRS	numeric(4, 2)	True	False	False
LIM_PE_DANCE	numeric(4, 2)	True	False	False
LIM_PE_DANCE_CRSES_TO_AREA	varchar(3)	True	False	False
LIM_TV_HRS	numeric(4, 2)	True	False	False
MAINT_DATE	varchar(8)	True	False	False
MAINT_PGM	varchar(8)	True	False	False
MAINT_TIME	varchar(7)	True	False	False
MAINT_USER_ID	varchar(8)	True	False	False
MIN_CNTCT_HRS	numeric(6, 2)	True	False	False
MIN_CRED_HRS	numeric(5, 2)	True	False	False
MIN_CRS_HR_AND_OR_OPTN	varchar(1)	True	False	False
MIN_GEN_ED_HRS	numeric(5, 2)	True	False	False
MIN_GRD_HNRS_PGM	varchar(2)	True	False	False
MUST_APPLY_FOR_GRAD	varchar(1)	True	False	False
PGM_APP_FEE_AMT	numeric(11, 2)	True	False	False
PGM_APP_FEE_ASSESSMENT	varchar(1)	True	False	False
PGM_APP_FEE_IND	varchar(1)	True	False	False
PGM_APP_TYPE	varchar(2)	True	False	False
PGM_AREA	int(10, 0)	True	False	False
PGM_AREA_GROUP	int(10, 0)	True	False	False
PGM_AREA_LABS_RQRD	int(10, 0)	True	False	False
PGM_AREA_MAX_CNTCT_HRS	numeric(6, 2)	True	False	False
PGM_AREA_MAX_CRED_HRS	numeric(4, 2)	True	False	False
PGM_AREA_MIN_CNTCT_HRS	numeric(6, 2)	True	False	False
PGM_AREA_MIN_CRED_HRS	numeric(4, 2)	True	False	False
PGM_AREA_MIN_CRS	int(10, 0)	True	False	False
PGM_AREA_MIN_CRS_HR_OPTN	varchar(1)	True	False	False
PGM_AREA_MIN_GPA	numeric(3, 2)	True	False	False
PGM_AREA_MIN_GRD_A	varchar(2)	True	False	False
PGM_AREA_NOTE_CD	varchar(3)	True	False	False
PGM_AREA_OPTN_CD	varchar(2)	True	False	False
PGM_AREA_OPTN_OPER	varchar(1)	True	False	False
PGM_AREA_TYPE	varchar(3)	True	False	False
PGM_CD	varchar(5)	True	False	False
PGM_CD_X	varchar(5)	True	False	False
PGM_DEPOSIT_AMT	numeric(11, 2)	True	False	False
PGM_DEPOSIT_ASSESSMENT	varchar(1)	True	False	False
PGM_DEPOSIT_IND	varchar(1)	True	False	False
PGM_FEE_AMT	numeric(11, 2)	True	False	False
PGM_FEE_TYPE	varchar(2)	True	False	False
PGM_LMTD_ACCSS	varchar(1)	True	False	False
PGM_MIN_GPA	numeric(4, 2)	True	False	False
PGM_OFFCL_TTL	varchar(60)	True	False	False
PGM_PRT_OFFCL_IND	varchar(1)	True	False	False
PGM_PRT_SHRT_IND	varchar(1)	True	False	False
PGM_PRT_SHRT_TRK_IND	varchar(1)	True	False	False
PGM_PRT_TRK_IND	varchar(1)	True	False	False
PGM_SHRT_TRK_TTL	varchar(60)	True	False	False
PGM_SHRT_TTL	varchar(60)	True	False	False
PGM_STATUS	varchar(1)	True	False	False
PGM_TRK_TTL	varchar(60)	True	False	False
PGM_TTL_CRD_HRS	numeric(5, 2)	True	False	False
PGM_TTL_GE_HRS_REQD	numeric(5, 2)	True	False	False
PGM_TTL_MIN_CNTCT_HRS_REQD	numeric(6, 2)	True	False	False
PGM_VA_SPPRTD	varchar(1)	True	False	False
PLACEMENT_REQ	varchar(1)	True	False	False
PPP_CRED_TY_REST	varchar(2)	True	False	False
PPP_NON_MAJOR_CIP_CD	varchar(10)	True	False	False
PROGRAM_PROGRESSION_URL	varchar(60)	True	False	False
PUBLISH_PGM_LENGTH	numeric(6, 3)	True	False	False
PUBLISH_PGM_LENGTH_MSRMNT	varchar(1)	True	False	False
QLFYNG_RESD	varchar(1)	True	False	False
QUAL_FOR_GEN_ED_WAIVERS	varchar(1)	True	False	False
RES_CNTCT_HRS	numeric(6, 2)	True	False	False
RES_CRED_HRS	numeric(5, 2)	True	False	False
RES_RQMNT	varchar(1)	True	False	False
RowUpdatedOn	datetime2(27, 7)	True	False	False
SDB_AWARD_LEVEL	varchar(1)	True	False	False
SDB_AWARD_TYPE	varchar(1)	True	False	False
SDB_DEGREE_GRANTED	varchar(1)	True	False	False
SEQ	int(10, 0)	True	False	False
SUBSTN_WVR_ROLL	varchar(1)	True	False	False
TEACHER_PGM_MIN_GPA	numeric(4, 2)	True	False	False
TEACHER_PGM_TRNSCRPT_NT	varchar(2)	True	False	False
TEACHER_PROGRAM	varchar(1)	True	False	False
TRNSFR_CRD_EVL	varchar(1)	True	False	False
VALID_CATALOGS	varchar(2)	True	False	False
VRY_HGH_HNR_GPA	numeric(4, 2)	True	False	False

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
UI3QFTHOB4ABQ	False	ISN_ST_PROGRAMS_A

Name

Columns

Referenced Table

Referenced Columns

Checked

Name

Text

Checked

Name	Type
dbo.arch_StudentPrimaryAward	View
dbo.usp_DimApplication_Select	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select_LogTime	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select_Old	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2_LogTime	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2_Old	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select_LogTime	StoredProcedure
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select_Old	StoredProcedure
dbo.usp_DimProgramRetentionCohort_Select	StoredProcedure
dbo.usp_DimStudentObjective_Select	StoredProcedure
dbo.usp_DimStudentSuccessCohort_Select	StoredProcedure
dbo.usp_DimStudentTerm_Select	StoredProcedure
dbo.usp_FactApplicationStatus_Select	StoredProcedure

Name	Type
dbo.arch_StudentPrimaryAward	VIEW
dbo.usp_DimApplication_Select	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select_LogTime	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select_Old	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2_LogTime	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortT2T_Select2_Old	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select_LogTime	STOREDPROCEDURE
dbo.usp_DimInstitutionalRetentionCohortY2Y_Select_Old	STOREDPROCEDURE
dbo.usp_DimProgramRetentionCohort_Select	STOREDPROCEDURE
dbo.usp_DimStudentObjective_Select	STOREDPROCEDURE
dbo.usp_DimStudentSuccessCohort_Select	STOREDPROCEDURE
dbo.usp_DimStudentTerm_Select	STOREDPROCEDURE
dbo.usp_FactApplicationStatus_Select	STOREDPROCEDURE

Object

Property

Value

Object

Property

Value

/****** Object: Table [dbo].[ST_PROGRAMS_A] Script Date: 03/09/2017 16:46:12 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_PROGRAMS_A](
    [ISN_ST_PROGRAMS_A] [int] NOT NULL,
    [AWD_TY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_CD] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TRM_D] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TRM_A] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TRM_C] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TRM_G] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [END_TRM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TRM_9S_COMP_D] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AUDIT_AVAIL_FLG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_STATUS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_OFFCL_TTL] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_SHRT_TTL] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_TRK_TTL] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_SHRT_TRK_TTL] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_PRT_OFFCL_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_PRT_SHRT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_PRT_TRK_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_PRT_SHRT_TRK_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_LMTD_ACCSS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_VA_SPPRTD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ICS_NUM] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CIP_CD] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_TTL_CRD_HRS] [numeric](5, 2) NULL,
    [PGM_TTL_GE_HRS_REQD] [numeric](5, 2) NULL,
    [PGM_TTL_MIN_CNTCT_HRS_REQD] [numeric](6, 2) NULL,
    [PGM_AREA] [int] NULL,
    [HOLD] [int] NULL,
    [ADD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADD_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MAINT_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEQ] [int] NULL,
    [PGM_AREA_TYPE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_AREA_MIN_CRED_HRS] [numeric](4, 2) NULL,
    [PGM_AREA_MIN_CNTCT_HRS] [numeric](6, 2) NULL,
    [PGM_AREA_NOTE_CD] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_AREA_MIN_CRS] [int] NULL,
    [EFF_TRM_9S_COMP_A] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TRM_9S_COMP_C] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_AREA_MAX_CRED_HRS] [numeric](4, 2) NULL,
    [PGM_AREA_MAX_CNTCT_HRS] [numeric](6, 2) NULL,
    [EFF_TRM_N] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TRM_9S_COMP_N] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DA_NOTE_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TRM_GR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADM_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_RQMNT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RES_CRED_HRS] [numeric](5, 2) NULL,
    [RES_CNTCT_HRS] [numeric](6, 2) NULL,
    [MIN_CRED_HRS] [numeric](5, 2) NULL,
    [MIN_CNTCT_HRS] [numeric](6, 2) NULL,
    [MIN_GEN_ED_HRS] [numeric](5, 2) NULL,
    [LIM_TV_HRS] [numeric](4, 2) NULL,
    [LIM_ENS_HRS] [numeric](4, 2) NULL,
    [LIM_MUS_SPC_DRA_HRS] [numeric](4, 2) NULL,
    [EXIT_TEST] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLR_FIN_OBLGTN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VALID_CATALOGS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MUST_APPLY_FOR_GRAD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AUTO_POST_GRAD_MSG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LIM_PE_DANCE] [numeric](4, 2) NULL,
    [LIM_ACCEL_MECH_HRS_ALL] [numeric](4, 2) NULL,
    [CRS_ID_X] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFF_TRM_X] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_CD_X] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SUBSTN_WVR_ROLL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HNR_GPA] [numeric](4, 2) NULL,
    [HGH_HNR_GPA] [numeric](4, 2) NULL,
    [VRY_HGH_HNR_GPA] [numeric](4, 2) NULL,
    [PGM_AREA_MIN_GPA] [numeric](3, 2) NULL,
    [PGM_AREA_MIN_GRD_A] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_AREA_LABS_RQRD] [int] NULL,
    [QLFYNG_RESD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CRD_HNRS_PGM] [numeric](4, 2) NULL,
    [MIN_GRD_HNRS_PGM] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEE_GRP] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FEE_GRP_DLR_AMT] [numeric](5, 2) NULL,
    [TRNSFR_CRD_EVL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FIN_AID_APPRVD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PLACEMENT_REQ] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HRS_BEFORE_PLACE_EXIST] [int] NULL,
    [HRS_BEFORE_PLACE_ENFORCE] [int] NULL,
    [SDB_AWARD_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SDB_AWARD_LEVEL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SDB_DEGREE_GRANTED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_AREA_MIN_CRS_HR_OPTN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GORDON_RULE_MIN_WORDS] [int] NULL,
    [LIM_ENS_CRSES_TO_AREA] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LIM_MUS_SPC_DRA_CRSES_TO_AREA] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LIM_PE_DANCE_CRSES_TO_AREA] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GRADUATION_AVAILABLE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HS_GRADUATION_REQUIRED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PPP_CRED_TY_REST] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PPP_NON_MAJOR_CIP_CD] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ALLOW_REMOTE_CHANGE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DIV_DEPT_CD] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [QUAL_FOR_GEN_ED_WAIVERS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ANNUAL_COST] [numeric](11, 2) NULL,
    [PGM_APP_FEE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_APP_FEE_AMT] [numeric](11, 2) NULL,
    [PGM_APP_FEE_ASSESSMENT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_DEPOSIT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_DEPOSIT_AMT] [numeric](11, 2) NULL,
    [PGM_DEPOSIT_ASSESSMENT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MIN_CRS_HR_AND_OR_OPTN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AUTO_APPLY_UNCL_CRS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_AREA_GROUP] [int] NULL,
    [PGM_AREA_OPTN_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_AREA_OPTN_OPER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LA_APPL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LA_STAT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LA_TOT_PNTS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LA_INDV_PNTS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LA_GRAD_AWD] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LA_PREPGM_ID] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_FEE_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_APP_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_FEE_AMT] [numeric](11, 2) NULL,
    [TEACHER_PROGRAM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TEACHER_PGM_MIN_GPA] [numeric](4, 2) NULL,
    [TEACHER_PGM_TRNSCRPT_NT] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROGRAM_PROGRESSION_URL] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LA_DENIED_PGM] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COMPLETE_BY_ALL_DL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GEN_ED_AREA] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PUBLISH_PGM_LENGTH] [numeric](6, 3) NULL,
    [PUBLISH_PGM_LENGTH_MSRMNT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PGM_MIN_GPA] [numeric](4, 2) NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]

ADD_DATE

ADD_PGM

ADD_TIME

ADD_USER_ID

ADM_STAT

ALLOW_REMOTE_CHANGE_IND

AUDIT_AVAIL_FLG

AUTO_APPLY_UNCL_CRS

AUTO_POST_GRAD_MSG

AWD_TY

CIP_CD

CLR_FIN_OBLGTN

COMPLETE_BY_ALL_DL

CRS_ID_X

DA_NOTE_TYPE

DIV_DEPT_CD

EFF_TRM_9S_COMP_A

EFF_TRM_9S_COMP_C

EFF_TRM_9S_COMP_D

EFF_TRM_9S_COMP_N

EFF_TRM_A

EFF_TRM_C

EFF_TRM_D

EFF_TRM_G

EFF_TRM_GR

EFF_TRM_N

EFF_TRM_X

END_TRM

EXIT_TEST

FEE_GRP

FIN_AID_APPRVD

GEN_ED_AREA

GRADUATION_AVAILABLE

HOLD

HS_GRADUATION_REQUIRED

ICS_NUM

ISN_ST_PROGRAMS_A

LA_APPL

LA_DENIED_PGM

LA_GRAD_AWD

LA_INDV_PNTS

LA_PREPGM_ID

LA_STAT

LA_TOT_PNTS

LIM_ENS_CRSES_TO_AREA

LIM_MUS_SPC_DRA_CRSES_TO_AREA

LIM_PE_DANCE_CRSES_TO_AREA

MAINT_DATE

MAINT_PGM

MAINT_TIME

MAINT_USER_ID

MIN_CRS_HR_AND_OR_OPTN

MIN_GRD_HNRS_PGM

MUST_APPLY_FOR_GRAD

PGM_APP_FEE_ASSESSMENT

PGM_APP_FEE_IND

PGM_APP_TYPE

PGM_AREA

PGM_AREA_GROUP

PGM_AREA_MIN_CRS_HR_OPTN

PGM_AREA_MIN_GRD_A

PGM_AREA_NOTE_CD

PGM_AREA_OPTN_CD

PGM_AREA_OPTN_OPER

PGM_AREA_TYPE

PGM_CD

PGM_CD_X

PGM_DEPOSIT_ASSESSMENT

PGM_DEPOSIT_IND

PGM_FEE_TYPE

PGM_LMTD_ACCSS

PGM_OFFCL_TTL

PGM_PRT_OFFCL_IND

PGM_PRT_SHRT_IND

PGM_PRT_SHRT_TRK_IND

PGM_PRT_TRK_IND

PGM_SHRT_TRK_TTL

PGM_SHRT_TTL

PGM_STATUS

PGM_TRK_TTL

PGM_VA_SPPRTD

PLACEMENT_REQ

PPP_CRED_TY_REST

PPP_NON_MAJOR_CIP_CD

PROGRAM_PROGRESSION_URL

PUBLISH_PGM_LENGTH_MSRMNT

QLFYNG_RESD

QUAL_FOR_GEN_ED_WAIVERS

RES_RQMNT

RowUpdatedOn

SDB_AWARD_LEVEL

SDB_AWARD_TYPE

SDB_DEGREE_GRANTED

SEQ

SUBSTN_WVR_ROLL

TEACHER_PGM_TRNSCRPT_NT

TEACHER_PROGRAM

TRNSFR_CRD_EVL

VALID_CATALOGS

799089

20091

1152139

59119

1

5170

2017-02-06T10:36:39.528-05:00

1

20110601

STD516N0

1414253

E011387

20112

526421

66882

20140314

STD516N0

0526421

OPER2

1

2

21

A

T801A

2017-02-06T10:36:41.4-05:00

ECO*

20132

78050

T701

2017-02-06T10:36:44.161-05:00

ECO2013

20141

104673

2505

2017-02-06T10:36:50.901-05:00

ARH2050

20011

31924

2606

2017-02-06T10:36:32.773-05:00

GRA2151C

20131

93907

2011

2017-02-06T10:36:48.155-05:00

HIM1282C

20091

53382

6528

2017-02-06T10:36:38.109-05:00

MGF1106

20011

83108

2345

2017-02-06T10:36:45.534-05:00

GEA1000

20021

32285

2449

2017-02-06T10:36:32.867-05:00

FRE1120

20132

78647

S901

2017-02-06T10:36:44.317-05:00