Table - dbo.DimInstitutionalRetentionCohort

Property	Value
Name	DimInstitutionalRetentionCohort
Schema	dbo
Row Count	317327
Data Size	72720 KB
Index Size	288 KB
Create Date	1/28/2014 9:47 AM
Description	The dimension will contain one row per credit student. The cohort will capture information about the student as they begin their

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
AgeAtInstitutionalRetentionCohort	smallint(5, 0)	False	False	False			Age of the student, in years on the start date of the term.
AgeRangeAtInstitutionalRetentionCohort	varchar(10)	False	False	False			Age Range of the student on the start date of the term.
AwardType	varchar(30)	False	False	False			Descriptive name for the type of award the student is pursuing for the cohort term.
AwardTypeCode	varchar(3)	False	False	False			Code indicating the type of award the student is pursuing at the time the student is captured for the Institutional Retention cohort.
CohortTerm	varchar(6)	False	False	False			Time indication, relates to the academic calendar of the institution. The Cohort Term inidcates when Institutional Retention tracking for the student is initiated. Also used as teh business unqiue identifier for a term.
CohortTermTitle	varchar(30)	False	False	False			The title of the term. The title consists of a literal description of the term, followed by the word 'Term' and then the academic year in the format of YYYY (e.g. Fall term 2012).
CohortYear	smallint(5, 0)	False	False	False			Time indication for an Academic Year. This is the academic year of the Institutional Retention Cohort.
FirstTerm_FT_PT	varchar(10)	False	False	False			Indication of the enrollment status of the student during their initial term taking credit courses.
InstitutionalRetentionCohortAK	varchar(30)	False	False	False			The unique identifier assigned to the Institutional Retention Cohort, used by the data warehouse as the business key. Consists of the Student Id, Cohort Term, and Retention Cohort Type.
InstitutionalRetentionCohortSK	int(10, 0)	False	False	False	(1 / 1)		Surrogate Primary Key for the Institutional Retention Cohort dimension. Unique identifier for the Institutional Retention Cohort in numeric format.
Program	varchar(30)	False	False	False			Descriptive title of the program objective for the student for the cohort term.
ProgramAdmitStatus	varchar(3)	False	False	False			Indication if the student was admited into their Program at the end of the Institutional Retention cohort term.
ProgramCode	varchar(5)	False	False	False			Code indicating the program objective declared by the student at the time the Student is captured in the Institutional Retention cohort.
RetentionCohortType	varchar(60)	False	False	False			A descriptive name of the Institutional Retention Cohort for tracking year to year and term to term retention for students.
RetentionCohortTypeCode	varchar(15)	False	False	False			An indication of the type of Cohort for Institutional Retention tracking. There are five types of retention cohorts dividied into two groups. Fall to Fall and Spring to Spring are the year to year retention cohorts. Fall to Spring, Spring to Fall and Spring to Summer are the term to term retention cohorts.
RowEndDate	datetime(23, 3)	True	False	False		('12/31/9999')	When did this row become invalid? (12/31/9999 if current row)
RowIsCurrent	char(1)	False	False	False			Is this the current row for this member (Y/N)?
RowStartDate	datetime(23, 3)	False	False	False			When did this row become valid for this member?
StudentId	varchar(9)	False	False	False			Student identifier assigned by the source application and used by the Data Warehouse as the Business Key.

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
PK_dbo.DimInstitutionalRetentionCohort	True	InstitutionalRetentionCohortSK

Name

Columns

Referenced Table

Referenced Columns

Checked

Name

Text

Checked

Name	Type
dbo.FactInstitutionalRetentionSnapshot	Table

Name	Type
dbo.FactInstitutionalRetentionSnapshot	TABLE

Object	Property	Value
DimInstitutionalRetentionCohort	Display Name	IRetCohort
DimInstitutionalRetentionCohort	MS_Description	The dimension will contain one row per credit student. The cohort will capture information about the student as they begin their
DimInstitutionalRetentionCohort	Table Type	Dimension
AgeAtInstitutionalRetentionCohort	Display Name	Age At Institutional Retention Cohort
AgeAtInstitutionalRetentionCohort	Example Values	21, 31, 55
AgeAtInstitutionalRetentionCohort	MS_Description	Age of the student, in years on the start date of the term.
AgeAtInstitutionalRetentionCohort	SCD Type	1
AgeAtInstitutionalRetentionCohort	Source System	Derived
AgeRangeAtInstitutionalRetentionCohort	Display Name	Age Range At Institutional Retention Cohort
AgeRangeAtInstitutionalRetentionCohort	Example Values	20 - 21, 30 - 34, > 34
AgeRangeAtInstitutionalRetentionCohort	MS_Description	Age Range of the student on the start date of the term.
AgeRangeAtInstitutionalRetentionCohort	SCD Type	1
AgeRangeAtInstitutionalRetentionCohort	Source System	Derived
AwardType	Display Name	Award Type
AwardType	Example Values	Associate in Arts Degree, Bachelor of Arts Degree or Assocaite in Applied Science
AwardType	MS_Description	Descriptive name for the type of award the student is pursuing for the cohort term.
AwardType	SCD Type	1
AwardType	Source Field Name	MS_Description
AwardType	Source System	DWStaging
AwardType	Source Table	UTL_CODE_TABLE_A
AwardTypeCode	Display Name	Award Type Code
AwardTypeCode	Example Values	AA, BA, AAS
AwardTypeCode	MS_Description	Code indicating the type of award the student is pursuing at the time the student is captured for the Institutional Retention cohort.
AwardTypeCode	SCD Type	1
AwardTypeCode	Source Field Name	AWD_TY
AwardTypeCode	Source System	DWStaging
AwardTypeCode	Source Table	ST_PROGRAMS_A
CohortTerm	Display Name	Term
CohortTerm	Example Values	19921, 20103, 20121
CohortTerm	MS_Description	Time indication, relates to the academic calendar of the institution. The Cohort Term inidcates when Institutional Retention tracking for the student is initiated. Also used as teh business unqiue identifier for a term.
CohortTerm	SCD Type	1
CohortTerm	Source Field Name	TRM_YR
CohortTerm	Source System	DWStaging
CohortTerm	Source Table	ST_STDNT_ENDOFTERM_A
CohortTermTitle	Display Name	Term Title
CohortTermTitle	Example Values	Spring Term 2011, Fall Term 2013
CohortTermTitle	MS_Description	The title of the term. The title consists of a literal description of the term, followed by the word 'Term' and then the academic year in the format of YYYY (e.g. Fall term 2012).
CohortTermTitle	SCD Type	1
CohortTermTitle	Source Field Name	TRM_TRNSCRPT_TTL
CohortTermTitle	Source System	DWStaging
CohortTermTitle	Source Table	ST_TERM_A
CohortYear	Display Name	Year
CohortYear	Example Values	2003, 2011, 2013
CohortYear	MS_Description	Time indication for an Academic Year. This is the academic year of the Institutional Retention Cohort.
CohortYear	SCD Type	1
CohortYear	Source System	Derived
FirstTerm_FT_PT	MS_Description	Indication of the enrollment status of the student during their initial term taking credit courses.
InstitutionalRetentionCohortAK	Display Name	InstitutionalRetentionCohortAK
InstitutionalRetentionCohortAK	Example Values	A10022331210103 FallToFall, R0903441220121 SpringToSpring, T1000123520132 SpringToFall
InstitutionalRetentionCohortAK	MS_Description	The unique identifier assigned to the Institutional Retention Cohort, used by the data warehouse as the business key. Consists of the Student Id, Cohort Term, and Retention Cohort Type.
InstitutionalRetentionCohortAK	SCD Type	key
InstitutionalRetentionCohortAK	Source Field Name	STDNT_ID + TRM_YR
InstitutionalRetentionCohortAK	Source System	DWStaging
InstitutionalRetentionCohortAK	Source Table	ST_STDNT_ENDOFTERM_A
InstitutionalRetentionCohortSK	Display Name	InstitutionalRetentionCohortSK
InstitutionalRetentionCohortSK	Example Values	1, 2, 3?
InstitutionalRetentionCohortSK	MS_Description	Surrogate Primary Key for the Institutional Retention Cohort dimension. Unique identifier for the Institutional Retention Cohort in numeric format.
InstitutionalRetentionCohortSK	SCD Type	key
InstitutionalRetentionCohortSK	Source System	Derived
Program	Display Name	Program
Program	Example Values	Associate in Arts - General Transfer, Business AA, Health Management
Program	MS_Description	Descriptive title of the program objective for the student for the cohort term.
Program	SCD Type	1
Program	Source Field Name	PGM_SHRT_TTL
Program	Source System	DWStaging
Program	Source Table	ST_PROGRAMS_A
ProgramAdmitStatus	Display Name	Program Admission Status
ProgramAdmitStatus	Example Values	Yes, No
ProgramAdmitStatus	MS_Description	Indication if the student was admited into their Program at the end of the Institutional Retention cohort term.
ProgramAdmitStatus	SCD Type	1
ProgramAdmitStatus	Source Field Name	ADMT_STAT
ProgramAdmitStatus	Source System	DWStaging
ProgramAdmitStatus	Source Table	ST_STDNT_OBJ_AWD_LOG_A
ProgramCode	Display Name	Program Code
ProgramCode	Example Values	1000, 1010, T702
ProgramCode	MS_Description	Code indicating the program objective declared by the student at the time the Student is captured in the Institutional Retention cohort.
ProgramCode	SCD Type	1
ProgramCode	Source Field Name	PGM_ID
ProgramCode	Source System	DWStaging
ProgramCode	Source Table	ST_STDNT_ENDOFTERM_A
RetentionCohortType	Display Name	Retention Cohort Type
RetentionCohortType	Example Values	Fall to Fall Retention by Year, Spring to Fall Term Retention
RetentionCohortType	MS_Description	A descriptive name of the Institutional Retention Cohort for tracking year to year and term to term retention for students.
RetentionCohortType	SCD Type	1
RetentionCohortType	Source System	Derived
RetentionCohortTypeCode	Display Name	Retention Cohort Type Code
RetentionCohortTypeCode	Example Values	FallToFall, SpringToFall
RetentionCohortTypeCode	MS_Description	An indication of the type of Cohort for Institutional Retention tracking. There are five types of retention cohorts dividied into two groups. Fall to Fall and Spring to Spring are the year to year retention cohorts. Fall to Spring, Spring to Fall and Spring to Summer are the term to term retention cohorts.
RetentionCohortTypeCode	SCD Type	1
RetentionCohortTypeCode	Source System	Derived
RowEndDate	Display Folder	Exclude from cube
RowEndDate	Display Name	Row End Date
RowEndDate	Example Values	1/14/1998, 12/31/9999
RowEndDate	MS_Description	When did this row become invalid? (12/31/9999 if current row)
RowEndDate	SCD Type	n/a
RowEndDate	Source System	Derived
RowIsCurrent	Display Folder	Exclude from cube
RowIsCurrent	Display Name	Row Is Current
RowIsCurrent	Example Values	Y, N
RowIsCurrent	MS_Description	Is this the current row for this member (Y/N)?
RowIsCurrent	SCD Type	n/a
RowIsCurrent	Source System	Derived
RowStartDate	Display Folder	Exclude from cube
RowStartDate	Display Name	Row Start Date
RowStartDate	Example Values	1/24/2011
RowStartDate	MS_Description	When did this row become valid for this member?
RowStartDate	SCD Type	n/a
RowStartDate	Source System	Derived
StudentId	Display Name	Student ID
StudentId	Example Values	A100223312, R09034412
StudentId	MS_Description	Student identifier assigned by the source application and used by the Data Warehouse as the Business Key.
StudentId	SCD Type	1
StudentId	Source Field Name	STDNT_ID
StudentId	Source System	DWStaging
StudentId	Source Table	ST_STDNT_ENDOFTERM_A

Object

Property

Value

/****** Object: Table [dbo].[DimInstitutionalRetentionCohort] Script Date: 03/09/2017 17:14:55 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimInstitutionalRetentionCohort](
    [InstitutionalRetentionCohortSK] [int] IDENTITY(1,1) NOT NULL,
    [InstitutionalRetentionCohortAK] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [StudentId] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CohortYear] [smallint] NOT NULL,
    [CohortTerm] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CohortTermTitle] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [FirstTerm_FT_PT] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RetentionCohortTypeCode] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RetentionCohortType] [varchar](60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ProgramCode] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Program] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ProgramAdmitStatus] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AwardTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AwardType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AgeAtInstitutionalRetentionCohort] [smallint] NOT NULL,
    [AgeRangeAtInstitutionalRetentionCohort] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowIsCurrent] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [RowStartDate] [datetime] NOT NULL,
    [RowEndDate] [datetime] NULL,
CONSTRAINT [PK_dbo.DimInstitutionalRetentionCohort] PRIMARY KEY CLUSTERED
(
    [InstitutionalRetentionCohortSK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [dbo].[DimInstitutionalRetentionCohort] ADD  CONSTRAINT [DF__DimInstit__RowEn__64CCF2AE]  DEFAULT ('12/31/9999') FOR [RowEndDate]

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'IRetCohort' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The dimension will contain one row per credit student. The cohort will capture information about the student as they begin their' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort'

EXEC sys.sp_addextendedproperty @name=N'Table Type', @value=N'Dimension' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Age At Institutional Retention Cohort' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AgeAtInstitutionalRetentionCohort'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'21, 31, 55' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AgeAtInstitutionalRetentionCohort'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Age of the student, in years on the start date of the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AgeAtInstitutionalRetentionCohort'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AgeAtInstitutionalRetentionCohort'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AgeAtInstitutionalRetentionCohort'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Age Range At Institutional Retention Cohort' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AgeRangeAtInstitutionalRetentionCohort'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'20 - 21, 30 - 34, > 34' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AgeRangeAtInstitutionalRetentionCohort'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Age Range of the student on the start date of the term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AgeRangeAtInstitutionalRetentionCohort'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AgeRangeAtInstitutionalRetentionCohort'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AgeRangeAtInstitutionalRetentionCohort'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Award Type ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AwardType'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Associate in Arts Degree, Bachelor of Arts Degree or Assocaite in Applied Science' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AwardType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the type of award the student is pursuing for the cohort term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AwardType'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AwardType'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AwardType'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AwardType'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'UTL_CODE_TABLE_A' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AwardType'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Award Type Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AwardTypeCode'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'AA, BA, AAS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AwardTypeCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the type of award the student is pursuing at the time the student is captured for the Institutional Retention cohort.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AwardTypeCode'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AwardTypeCode'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'AWD_TY' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AwardTypeCode'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AwardTypeCode'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'ST_PROGRAMS_A' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'AwardTypeCode'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Term ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortTerm'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'19921, 20103, 20121' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortTerm'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Time indication, relates to the academic calendar of the institution. The Cohort Term inidcates when Institutional Retention tracking for the student is initiated. Also used as teh business unqiue identifier for a term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortTerm'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortTerm'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'TRM_YR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortTerm'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortTerm'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'ST_STDNT_ENDOFTERM_A' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortTerm'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Term Title' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortTermTitle'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Spring Term 2011, Fall Term 2013' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortTermTitle'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The title of the term. The title consists of a literal description of the term, followed by the word ''Term'' and then the academic year in the format of YYYY (e.g. Fall term 2012).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortTermTitle'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortTermTitle'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'TRM_TRNSCRPT_TTL' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortTermTitle'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortTermTitle'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'ST_TERM_A' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortTermTitle'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Year' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortYear'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'2003, 2011, 2013' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortYear'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Time indication for an Academic Year. This is the academic year of the Institutional Retention Cohort.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortYear'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortYear'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortYear'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication of the enrollment status of the student during their initial term taking credit courses.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'FirstTerm_FT_PT'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'InstitutionalRetentionCohortAK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'InstitutionalRetentionCohortAK'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'A10022331210103 FallToFall, R0903441220121 SpringToSpring, T1000123520132 SpringToFall' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'InstitutionalRetentionCohortAK'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The unique identifier assigned to the Institutional Retention Cohort, used by the data warehouse as the business key. Consists of the Student Id, Cohort Term, and Retention Cohort Type.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'InstitutionalRetentionCohortAK'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'InstitutionalRetentionCohortAK'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'STDNT_ID + TRM_YR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'InstitutionalRetentionCohortAK'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'InstitutionalRetentionCohortAK'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'ST_STDNT_ENDOFTERM_A' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'InstitutionalRetentionCohortAK'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'InstitutionalRetentionCohortSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'InstitutionalRetentionCohortSK'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1, 2, 3?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'InstitutionalRetentionCohortSK'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Surrogate Primary Key for the Institutional Retention Cohort dimension. Unique identifier for the Institutional Retention Cohort in numeric format.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'InstitutionalRetentionCohortSK'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'key' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'InstitutionalRetentionCohortSK'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'InstitutionalRetentionCohortSK'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Program ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'Program'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Associate in Arts - General Transfer, Business AA, Health Management' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'Program'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive title of the program objective for the student for the cohort term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'Program'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'Program'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'PGM_SHRT_TTL' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'Program'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'Program'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'ST_PROGRAMS_A' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'Program'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Program Admission Status' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'ProgramAdmitStatus'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Yes, No' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'ProgramAdmitStatus'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication if the student was admited into their Program at the end of the Institutional Retention cohort term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'ProgramAdmitStatus'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'ProgramAdmitStatus'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'ADMT_STAT' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'ProgramAdmitStatus'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'ProgramAdmitStatus'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'ST_STDNT_OBJ_AWD_LOG_A' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'ProgramAdmitStatus'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Program Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'ProgramCode'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1000, 1010, T702' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'ProgramCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the program objective declared by the student at the time the Student is captured in the Institutional Retention cohort.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'ProgramCode'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'ProgramCode'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'PGM_ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'ProgramCode'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'ProgramCode'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'ST_STDNT_ENDOFTERM_A' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'ProgramCode'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Retention Cohort Type' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RetentionCohortType'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Fall to Fall Retention by Year, Spring to Fall Term Retention' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RetentionCohortType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A descriptive name of the Institutional Retention Cohort for tracking year to year and term to term retention for students.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RetentionCohortType'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RetentionCohortType'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RetentionCohortType'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Retention Cohort Type Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RetentionCohortTypeCode'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'FallToFall, SpringToFall' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RetentionCohortTypeCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'An indication of the type of Cohort for Institutional Retention tracking. There are five types of retention cohorts dividied into two groups. Fall to Fall and Spring to Spring are the year to year retention cohorts. Fall to Spring, Spring to Fall and Spring to Summer are the term to term retention cohorts.
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RetentionCohortTypeCode'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RetentionCohortTypeCode'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RetentionCohortTypeCode'

EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'Exclude from cube' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RowEndDate'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Row End Date' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RowEndDate'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1/14/1998, 12/31/9999' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RowEndDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'When did this row become invalid? (12/31/9999 if current row)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RowEndDate'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'n/a' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RowEndDate'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RowEndDate'

EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'Exclude from cube' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Row Is Current' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Y, N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Is this the current row for this member (Y/N)?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'n/a' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RowIsCurrent'

EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'Exclude from cube' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Row Start Date' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'1/24/2011' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'When did this row become valid for this member?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'n/a' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'Derived' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'RowStartDate'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Student ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'StudentId'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'A100223312, R09034412' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'StudentId'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Student identifier assigned by the source application and used by the Data Warehouse as the Business Key.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'StudentId'

EXEC sys.sp_addextendedproperty @name=N'SCD Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'StudentId'

EXEC sys.sp_addextendedproperty @name=N'Source Field Name', @value=N'STDNT_ID ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'StudentId'

EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'DWStaging' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'StudentId'

EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N'ST_STDNT_ENDOFTERM_A' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimInstitutionalRetentionCohort', @level2type=N'COLUMN',@level2name=N'StudentId'

AgeAtInstitutionalRetentionCohort

AgeRangeAtInstitutionalRetentionCohort

AwardType

AwardTypeCode

CohortTerm

CohortTermTitle

CohortYear

FirstTerm_FT_PT

InstitutionalRetentionCohortAK

InstitutionalRetentionCohortSK

Program

ProgramAdmitStatus

ProgramCode

RetentionCohortType

RetentionCohortTypeCode

RowIsCurrent

RowStartDate

StudentId

27

22 - 29

Bachelor Of Applied Science

BAS

20171

Fall Term 2016

2017

Full-time

C1264221120171 FallToSpring

308959

Supervision & Management

Yes

T701A

Fall To Spring Term Retention

FallToSpring

Y

2017-03-09T12:21:00-05:00

C12642211

21

19 - 21

Associate In Science Degree

AS

20142

Spring Term 2014

2014

Part-time

A1395543020142 SpringToSummer

254601

Nursing

No

2301

Spring To Summer Term Retention

SpringToSummer

Y

2017-03-09T12:21:00-05:00

A13955430

21

19 - 21

Associate In Arts Degree

AA

20161

Fall Term 2015

2016

Part-time

N1429298120161 FallToSpring

475059

Associate In Arts

Yes

1000

Fall To Spring Term Retention

FallToSpring

Y

2017-03-09T12:21:00-05:00

N14292981

29

22 - 29

Associate In Arts Degree

AA

20152

Spring Term 2015

2015

Part-time

N1356091720152 SpringToSummer

459677

Associate In Arts

Yes

1000

Spring To Summer Term Retention

SpringToSummer

Y

2017-03-09T12:21:00-05:00

N13560917

20

19 - 21

Associate In Arts Degree

AA

20162

Spring Term 2016

2016

Part-time

J1402714820162 SpringToSummer

263484

Associate In Arts

Yes

1000

Spring To Summer Term Retention

SpringToSummer

Y

2017-03-09T12:21:00-05:00

J14027148

16

< 19

Non-Degree Seeking

ND

20142

Spring Term 2014

2014

Part-time

N1444404620142 SpringToFall

466262

Hs Dual Enrollment

Yes

3800

Spring To Fall Term Retention

SpringToFall

Y

2017-03-09T12:21:00-05:00

N14444046

19

19 - 21

Associate In Arts Degree

AA

20152

Spring Term 2015

2015

Part-time

V1475701720152 SpringToSummer

535372

Associate In Arts

Yes

1000

Spring To Summer Term Retention

SpringToSummer

Y

2017-03-09T12:21:00-05:00

V14757017

17

< 19

Non-Degree Seeking

ND

20152

Spring Term 2015

2015

Part-time

A1437995220152 SpringToFall

260443

Hs Dual Enrollment

Yes

3800

Spring To Fall Term Retention

SpringToFall

Y

2017-03-09T12:21:00-05:00

A14379952

26

22 - 29

Associate In Science Degree

AS

20151

Fall Term 2014

2015

Part-time

L1478122320151 FallToSpring

434466

Interior Design Technology

Yes

2012

Fall To Spring Term Retention

FallToSpring

Y

2017-03-09T12:21:00-05:00

L14781223

53

39 - 64

Bachelor Of Applied Science

BAS

20151

Fall Term 2014

2015

Part-time

N0724732320151 FallToSpring

462041

Supervision & Management

Yes

T701A

Fall To Spring Term Retention

FallToSpring

Y

2017-03-09T12:21:00-05:00

N07247323