Table - dbo.ST_STDNT_ENDOFTERM

Property	Value
Name	ST_STDNT_ENDOFTERM_A
Schema	dbo
Row Count	1242127
Data Size	140888 KB
Index Size	18552 KB
Create Date	7/22/2013 9:39 AM
Description

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
ACDMC_STAT_CD	varchar(2)	True	False	False
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
CUM_GPA	numeric(17, 2)	True	False	False
CUM_GPA_HRS	numeric(17, 2)	True	False	False
CUM_GRD_PTS	numeric(17, 2)	True	False	False
CUM_HRS_ATT	numeric(17, 2)	True	False	False
CUM_HRS_ERN	numeric(17, 2)	True	False	False
DEGREE_100PCT_CMPLTD	varchar(1)	True	False	False
DEGREE_25PCT_CMPLTD	varchar(1)	True	False	False
DEGREE_50PCT_CMPLTD	varchar(1)	True	False	False
DEGREE_75PCT_CMPLTD	varchar(1)	True	False	False
DEGREE_LT25PCT_CMPLTD	varchar(1)	True	False	False
HOLD	int(10, 0)	True	False	False
ISN_ST_STDNT_ENDOFTERM_A	int(10, 0)	False	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
PGM_ID	varchar(5)	True	False	False
RowUpdatedOn	datetime2(27, 7)	True	False	False
STDNT_ENROLLED_FLG	varchar(1)	True	False	False
STDNT_GRAD_PROGRESS	varchar(2)	True	False	False
STDNT_ID	varchar(9)	True	False	False
TAKEN_COLLEXPR_COURSE	varchar(1)	True	False	False
TAKEN_GATEWAY_COURSE	varchar(1)	True	False	False
TRM_GPA	numeric(17, 2)	True	False	False
TRM_GPA_HRS	numeric(17, 2)	True	False	False
TRM_GRD_PTS	numeric(17, 2)	True	False	False
TRM_HRS_ATT	numeric(17, 2)	True	False	False
TRM_HRS_ERN	numeric(17, 2)	True	False	False
TRM_YR	varchar(6)	True	False	False

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
U3GM8N01LFJYND	False	ISN_ST_STDNT_ENDOFTERM_A

Name

Columns

Referenced Table

Referenced Columns

Checked

Name

Text

Checked

Name	Type
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_DimStudentSuccessCohort_Select	StoredProcedure
dbo.usp_FactInstitutionalRetentionT2TSnapshot_Select	StoredProcedure
dbo.usp_FactInstitutionalRetentionT2TSnapshot_Select2	StoredProcedure
dbo.usp_FactInstitutionalRetentionY2YSnapshot_Select	StoredProcedure
dbo.usp_FactProgramRetentionSnapshot_Select	StoredProcedure

Name	Type
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_DimStudentSuccessCohort_Select	STOREDPROCEDURE
dbo.usp_FactInstitutionalRetentionT2TSnapshot_Select	STOREDPROCEDURE
dbo.usp_FactInstitutionalRetentionT2TSnapshot_Select2	STOREDPROCEDURE
dbo.usp_FactInstitutionalRetentionY2YSnapshot_Select	STOREDPROCEDURE
dbo.usp_FactProgramRetentionSnapshot_Select	STOREDPROCEDURE

Object

Property

Value

Object

Property

Value

/****** Object: Table [dbo].[ST_STDNT_ENDOFTERM_A] Script Date: 03/09/2017 16:46:25 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_STDNT_ENDOFTERM_A](
    [ISN_ST_STDNT_ENDOFTERM_A] [int] NOT 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,
    [HOLD] [int] NULL,
    [STDNT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRM_YR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACDMC_STAT_CD] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STDNT_ENROLLED_FLG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STDNT_GRAD_PROGRESS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUM_GPA] [numeric](17, 2) NULL,
    [CUM_GRD_PTS] [numeric](17, 2) NULL,
    [CUM_HRS_ERN] [numeric](17, 2) NULL,
    [CUM_HRS_ATT] [numeric](17, 2) NULL,
    [CUM_GPA_HRS] [numeric](17, 2) NULL,
    [TRM_GPA] [numeric](17, 2) NULL,
    [TRM_GRD_PTS] [numeric](17, 2) NULL,
    [TRM_HRS_ERN] [numeric](17, 2) NULL,
    [TRM_HRS_ATT] [numeric](17, 2) NULL,
    [TRM_GPA_HRS] [numeric](17, 2) NULL,
    [PGM_ID] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEGREE_LT25PCT_CMPLTD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEGREE_25PCT_CMPLTD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEGREE_50PCT_CMPLTD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEGREE_75PCT_CMPLTD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEGREE_100PCT_CMPLTD] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TAKEN_COLLEXPR_COURSE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TAKEN_GATEWAY_COURSE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)

ACDMC_STAT_CD	ADD_DATE	ADD_PGM	ADD_TIME	ADD_USER_ID	CUM_GPA	CUM_GPA_HRS	CUM_GRD_PTS	CUM_HRS_ATT	CUM_HRS_ERN	DEGREE_100PCT_CMPLTD	DEGREE_25PCT_CMPLTD	DEGREE_50PCT_CMPLTD	DEGREE_75PCT_CMPLTD	DEGREE_LT25PCT_CMPLTD	HOLD	ISN_ST_STDNT_ENDOFTERM_A	MAINT_DATE	MAINT_PGM	MAINT_TIME	MAINT_USER_ID	PGM_ID	RowUpdatedOn	STDNT_ENROLLED_FLG	STDNT_GRAD_PROGRESS	STDNT_ID	TAKEN_COLLEXPR_COURSE	TAKEN_GATEWAY_COURSE	TRM_GPA	TRM_GPA_HRS	TRM_GRD_PTS	TRM_HRS_ATT	TRM_HRS_ERN	TRM_YR
C0	20170129	STR332N1	2324067	ZCTBK	2.00	3.00	6.00	3.00	3.00	N	N	N	N	Y	2324067	1107679					1000	2017-02-06T09:48:07.847-05:00	N	NE	S14243950	Y	N						20142
C0	20170129	STR332N1	0734113	ZCTBK	2.47	51.00	126.00	54.00	48.00	N	N	N	Y	N	734113	721850					1000	2017-02-06T09:47:25.088-05:00	Y	EN	P13510672	Y	Y	1.66	9.00	15.00	9.00	9.00	20152
C0	20170129	STR332N1	1306425	ZCTBK	4.00	6.00	24.00	9.00	6.00	N	N	Y	N	N	1306425	850822					4322	2017-02-06T09:47:39.596-05:00	N	NE	R12945895	N	N						20151
P3	20170128	STR332N1	2325441	ZCTBK	1.70	30.00	51.00	45.00	18.00	N	N	N	N	Y	2325441	543884					2050	2017-02-06T09:47:05.151-05:00	N	NE	F12375622	Y	Y						20153
P1	20170128	STR332N1	1614055	ZCTBK		10.00		19.00		N	N	N	N	Y	1614055	394385					2606	2017-02-06T09:46:48.661-05:00	N	EN	B14404487	N	Y						20161
S2	20170128	STR332N1	2214583	ZCTBK	0.68	22.00	15.00	46.00	6.00	N	N	N	N	Y	2214583	519415					2313	2017-02-06T09:47:02.389-05:00	N	NE	B13663133	N	Y						20153
C0	20170129	STR332N1	0740393	ZCTBK	2.00	3.00	6.00	3.00	3.00	N	N	N	N	Y	740393	724254					1000	2017-02-06T09:47:25.368-05:00	N	NE	R11967973	Y	N						20152
C0	20170128	STR332N1	0916071	ZCTBK	2.76	59.00	163.00	71.00	59.00	N	N	N	Y	N	916071	260762					1000	2017-02-06T09:46:33.436-05:00	Y	EN	A14316046	Y	Y	3.00	4.00	12.00	7.00	4.00	20162
P1	20170129	STR332N1	1812544	ZCTBK		3.00		3.00		N	N	N	N	Y	1812544	978200					5233	2017-02-06T09:47:53.464-05:00	N	NE	S11756913	N	N						20143
C0	20170130	STR332N1	0321442	ZCTBK	3.00	3.00	9.00	3.00	3.00	N	N	N	N	Y	321442	1207232					3800	2017-02-06T09:48:19.189-05:00	Y	EN	M14480057	N	Y	3.00	3.00	9.00	3.00	3.00	20141