Table - dbo.DimProgramRetentionCohort

Property	Value
Name	DimProgramRetentionCohort
Schema	dbo
Row Count	77228
Data Size	18816 KB
Index Size	88 KB
Create Date	1/28/2014 9:47 AM
Description	The dimension will contain one row per student per primary program. Students will be added to cohorts based on their primary pr

Column Name	Data Type	Allow Nulls	Row Guid	Fulltext Indexed	Identity	Default	Description / Computed Formula
AgeAtProgramRetentionCohort	smallint(5, 0)	False	False	False			Age of the student, in years on the start date of the Cohort Term.
AgeRangeAtProgramRetentionCohort	varchar(10)	False	False	False			Age Range of the student on the start date of the Cohort 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 Program Retention cohort.
CIP	varchar(30)	False	False	False			Descriptive name for the CIP code of the program the student is pursuing for the cohort term.
CIPCode	varchar(10)	False	False	False			Code indicating the Classification of Instructional Program, used by the state and federal government for administration and management of programs.
CohortTerm	varchar(6)	False	False	False			Time indication, relates to the academic calendar of the institution. The Cohort Term indicates when Program Retention tracking for the student is initiated. Also used as the business unique 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 (Fall Term 2012).
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 Program 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 Program Retention cohort.
ProgramRetentionCohortAK	varchar(20)	False	False	False			The unique identifier assigned to the Program Retention Cohort, used by the data warehouse as the business key. Consists of the Student ID, Program Code and Cohort Term.
ProgramRetentionCohortSK	int(10, 0)	False	False	False	(1 / 1)		Surrogate Primary Key for the Program Retention Cohort dimension. Unique identifier for the Program Retention Cohort in numeric format.
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.
SwitchedAwardType	varchar(30)	False	False	False			Descriptive name for the type of award the student switched to from the program associated with the cohort.
SwitchedAwardTypeCode	varchar(3)	False	False	False			Code indicating the new type of award the student switched to from the program associated with the cohort.
SwitchedCIP	varchar(30)	False	False	False			Descriptive name for the new CIP code of the program the student switched to from the program associated with the cohort.
SwitchedCIPCode	varchar(10)	False	False	False			Code indicating the new Classification of Instructional Program the student switched to from the program associated with the cohort.
SwitchedProgram	varchar(30)	False	False	False			Descriptive title of the new program objective the student switched to from the program associated with the cohort.
SwitchedProgramCode	varchar(5)	False	False	False			Code indicating the new program objective the student switched to from the program associated with the cohort.
SwitchedTerm	varchar(6)	False	False	False			Time indication, relates to the academic calendar of the institution. The Switched Term indicates the term a student switched from the cohort program objective to a new program objective. Also used as the business unique identifier for a term.
SwitchedTermTitle	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 (Fall Term 2012).

Name

Insert

Update

Delete

Instead

Name	Clustered	Columns
PK_dbo.DimProgramRetentionCohort	True	ProgramRetentionCohortSK

Name

Columns

Referenced Table

Referenced Columns

Checked

Name

Text

Checked

Name	Type
dbo.FactProgramRetentionSnapshot	Table

Name	Type
dbo.FactProgramRetentionSnapshot	TABLE

Object	Property	Value
DimProgramRetentionCohort	Display Name	PRetCohort
DimProgramRetentionCohort	MS_Description	The dimension will contain one row per student per primary program. Students will be added to cohorts based on their primary pr
DimProgramRetentionCohort	Table Type	Dimension
AgeAtProgramRetentionCohort	Display Name	Age At Program Retention Cohort
AgeAtProgramRetentionCohort	Example Values	21, 31, 55
AgeAtProgramRetentionCohort	MS_Description	Age of the student, in years on the start date of the Cohort Term.
AgeAtProgramRetentionCohort	SCD Type	1
AgeAtProgramRetentionCohort	Source System	Derived
AgeRangeAtProgramRetentionCohort	Display Name	Age Range At Program Retention Cohort
AgeRangeAtProgramRetentionCohort	Example Values	20 - 21, 30 - 34, > 34
AgeRangeAtProgramRetentionCohort	MS_Description	Age Range of the student on the start date of the Cohort Term.
AgeRangeAtProgramRetentionCohort	SCD Type	1
AgeRangeAtProgramRetentionCohort	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 Program Retention cohort.
AwardTypeCode	SCD Type	1
AwardTypeCode	Source Field Name	AWD_TY
AwardTypeCode	Source System	DWStaging
AwardTypeCode	Source Table	ST_PROGRAMS_A
CIP	Display Name	CIP
CIP	Example Values	Landscape Technology, Paramedic, BS Information Technology
CIP	MS_Description	Descriptive name for the CIP code of the program the student is pursuing for the cohort term.
CIP	SCD Type	1
CIP	Source Field Name	MS_Description
CIP	Source System	DWStaging
CIP	Source Table	UTL_CODE_TABLE_A
CIPCode	Display Name	CIP Code
CIPCode	Example Values	01001010000, 0317040691, 1611080300
CIPCode	MS_Description	Code indicating the Classification of Instructional Program, used by the state and federal government for administration and management of programs.
CIPCode	SCD Type	1
CIPCode	Source Field Name	CIP_CD
CIPCode	Source System	DWStaging
CIPCode	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 indicates when Program Retention tracking for the student is initiated. Also used as the business unique 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 (Fall Term 2012).
CohortTermTitle	SCD Type	1
CohortTermTitle	Source Field Name	TRM_TRNSCRPT_TTL
CohortTermTitle	Source System	DWStaging
CohortTermTitle	Source Table	ST_TERM_A
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 Program 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 Program Retention cohort.
ProgramCode	SCD Type	1
ProgramCode	Source Field Name	PGM_ID
ProgramCode	Source System	DWStaging
ProgramCode	Source Table	ST_STDNT_ENDOFTERM_A
ProgramRetentionCohortAK	Display Name	ProgramRetentionCohortAK
ProgramRetentionCohortAK	Example Values	A100223311100 210103, R090344122103 20121 , T10001235R140 20132
ProgramRetentionCohortAK	MS_Description	The unique identifier assigned to the Program Retention Cohort, used by the data warehouse as the business key. Consists of the Student ID, Program Code and Cohort Term.
ProgramRetentionCohortAK	SCD Type	key
ProgramRetentionCohortAK	Source Field Name	STDNT_ID + TRM_YR
ProgramRetentionCohortAK	Source System	DWStaging
ProgramRetentionCohortAK	Source Table	ST_STDNT_ENDOFTERM_A
ProgramRetentionCohortSK	Display Name	ProgramRetentionCohortSK
ProgramRetentionCohortSK	Example Values	1, 2, 3?
ProgramRetentionCohortSK	MS_Description	Surrogate Primary Key for the Program Retention Cohort dimension. Unique identifier for the Program Retention Cohort in numeric format.
ProgramRetentionCohortSK	SCD Type	key
ProgramRetentionCohortSK	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
SwitchedAwardType	Display Name	Switched Award Type
SwitchedAwardType	Example Values	Associate in Arts Degree, Bachelor of Arts Degree or Assocaite in Applied Science
SwitchedAwardType	MS_Description	Descriptive name for the type of award the student switched to from the program associated with the cohort.
SwitchedAwardType	SCD Type	1
SwitchedAwardType	Source Field Name	MS_Description
SwitchedAwardType	Source System	DWStaging
SwitchedAwardType	Source Table	UTL_CODE_TABLE_A
SwitchedAwardTypeCode	Display Name	Switched Award Type Code
SwitchedAwardTypeCode	Example Values	AA, BA, AAS
SwitchedAwardTypeCode	MS_Description	Code indicating the new type of award the student switched to from the program associated with the cohort.
SwitchedAwardTypeCode	SCD Type	1
SwitchedAwardTypeCode	Source Field Name	AWD_TY
SwitchedAwardTypeCode	Source System	DWStaging
SwitchedAwardTypeCode	Source Table	ST_PROGRAMS_A
SwitchedCIP	Display Name	Switched CIP
SwitchedCIP	Example Values	Landscape Technology, Paramedic, BS Information Technology
SwitchedCIP	MS_Description	Descriptive name for the new CIP code of the program the student switched to from the program associated with the cohort.
SwitchedCIP	SCD Type	1
SwitchedCIP	Source Field Name	MS_Description
SwitchedCIP	Source System	DWStaging
SwitchedCIP	Source Table	UTL_CODE_TABLE_A
SwitchedCIPCode	Display Name	Switched CIP Code
SwitchedCIPCode	Example Values	01001010000, 0317040691, 1611080300
SwitchedCIPCode	MS_Description	Code indicating the new Classification of Instructional Program the student switched to from the program associated with the cohort.
SwitchedCIPCode	SCD Type	1
SwitchedCIPCode	Source Field Name	CIP_CD
SwitchedCIPCode	Source System	DWStaging
SwitchedCIPCode	Source Table	ST_PROGRAMS_A
SwitchedProgram	Display Name	Switched Program
SwitchedProgram	Example Values	Associate in Arts - General Transfer, Business AA, Health Management
SwitchedProgram	MS_Description	Descriptive title of the new program objective the student switched to from the program associated with the cohort.
SwitchedProgram	SCD Type	1
SwitchedProgram	Source Field Name	PGM_SHRT_TTL
SwitchedProgram	Source System	DWStaging
SwitchedProgram	Source Table	ST_PROGRAMS_A
SwitchedProgramCode	Display Name	Switched Program Code
SwitchedProgramCode	Example Values	1000, 1010, T702
SwitchedProgramCode	MS_Description	Code indicating the new program objective the student switched to from the program associated with the cohort.
SwitchedProgramCode	SCD Type	1
SwitchedProgramCode	Source Field Name	PGM_ID
SwitchedProgramCode	Source System	DWStaging
SwitchedProgramCode	Source Table	ST_STDNT_ENDOFTERM_A
SwitchedTerm	Display Name	Switched Term
SwitchedTerm	Example Values	19921, 20103, 20121
SwitchedTerm	MS_Description	Time indication, relates to the academic calendar of the institution. The Switched Term indicates the term a student switched from the cohort program objective to a new program objective. Also used as the business unique identifier for a term.
SwitchedTerm	SCD Type	1
SwitchedTerm	Source Field Name	TRM_YR
SwitchedTerm	Source System	DWStaging
SwitchedTerm	Source Table	ST_STDNT_ENDOFTERM_A
SwitchedTermTitle	Display Name	Switched Term Title
SwitchedTermTitle	Example Values	Spring Term 2011, Fall Term 2013
SwitchedTermTitle	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 (Fall Term 2012).
SwitchedTermTitle	SCD Type	1
SwitchedTermTitle	Source Field Name	TRM_TRNSCRPT_TTL
SwitchedTermTitle	Source System	DWStaging
SwitchedTermTitle	Source Table	ST_TERM_A

Object

Property

Value

/****** Object: Table [dbo].[DimProgramRetentionCohort] Script Date: 03/09/2017 17:14:55 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DimProgramRetentionCohort](
    [ProgramRetentionCohortSK] [int] IDENTITY(1,1) NOT NULL,
    [ProgramRetentionCohortAK] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [StudentId] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS 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,
    [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,
    [CIPCode] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CIP] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [AgeAtProgramRetentionCohort] [smallint] NOT NULL,
    [AgeRangeAtProgramRetentionCohort] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SwitchedProgramCode] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SwitchedProgram] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SwitchedTerm] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SwitchedTermTitle] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SwitchedAwardTypeCode] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SwitchedAwardType] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SwitchedCIPCode] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SwitchedCIP] [varchar](30) 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.DimProgramRetentionCohort] PRIMARY KEY CLUSTERED
(
    [ProgramRetentionCohortSK] 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].[DimProgramRetentionCohort] ADD  CONSTRAINT [DF__DimProgra__RowEn__67A95F59]  DEFAULT ('12/31/9999') FOR [RowEndDate]

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The dimension will contain one row per student per primary program. Students will be added to cohorts based on their primary pr' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort'

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

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

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

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

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

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

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

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'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'AgeRangeAtProgramRetentionCohort'

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Award Type ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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 Program Retention cohort.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'AwardTypeCode'

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

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Landscape Technology, Paramedic, BS Information Technology' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'CIP'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the CIP code of the program the student is pursuing for the cohort term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'CIP'

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

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

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

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'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'CIP'

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

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'01001010000, 0317040691, 1611080300' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'CIPCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the Classification of Instructional Program, used by the state and federal government for administration and management of programs.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'CIPCode'

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

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Term ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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 indicates when Program Retention tracking for the student is initiated. Also used as the business unique identifier for a term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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 (Fall Term 2012).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'CohortTermTitle'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Program ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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 Program Retention cohort term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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 Program Retention cohort.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'ProgramCode'

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

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'A100223311100 210103, R090344122103 20121 , T10001235R140 20132 ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'ProgramRetentionCohortAK'

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

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

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'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'ProgramRetentionCohortAK'

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

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'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'ProgramRetentionCohortAK'

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

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

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Display Folder', @value=N'Exclude from cube' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @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'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'StudentId'

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

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'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedAwardType'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the type of award the student switched to from the program associated with the cohort.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedAwardType'

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

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

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

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'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedAwardType'

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

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the new type of award the student switched to from the program associated with the cohort.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedAwardTypeCode'

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

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

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

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

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Switched CIP ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedCIP'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'Landscape Technology, Paramedic, BS Information Technology' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedCIP'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive name for the new CIP code of the program the student switched to from the program associated with the cohort.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedCIP'

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

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

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

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'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedCIP'

EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Switched CIP Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedCIPCode'

EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'01001010000, 0317040691, 1611080300' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedCIPCode'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the new Classification of Instructional Program the student switched to from the program associated with the cohort.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedCIPCode'

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

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

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

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

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

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'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedProgram'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Descriptive title of the new program objective the student switched to from the program associated with the cohort.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedProgram'

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

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'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedProgram'

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

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

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

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Code indicating the new program objective the student switched to from the program associated with the cohort.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedProgramCode'

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

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

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

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'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedProgramCode'

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

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Time indication, relates to the academic calendar of the institution. The Switched Term indicates the term a student switched from the cohort program objective to a new program objective. Also used as the business unique identifier for a term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedTerm'

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

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

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

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'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedTerm'

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

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'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedTermTitle'

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 (Fall Term 2012).' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedTermTitle'

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

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'DimProgramRetentionCohort', @level2type=N'COLUMN',@level2name=N'SwitchedTermTitle'

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

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

AgeAtProgramRetentionCohort

AgeRangeAtProgramRetentionCohort

AwardType

AwardTypeCode

CIP

CIPCode

CohortTerm

CohortTermTitle

Program

ProgramAdmitStatus

ProgramCode

ProgramRetentionCohortAK

ProgramRetentionCohortSK

RowIsCurrent

RowStartDate

StudentId

SwitchedAwardType

SwitchedAwardTypeCode

SwitchedCIP

SwitchedCIPCode

SwitchedProgram

SwitchedProgramCode

SwitchedTerm

SwitchedTermTitle

18

< 19

Associate In Arts Degree

AA

Associate In Arts

1192401010

20161

Fall Term 2015

Associate In Arts

Yes

1000

T151312791000 20161

138288

Y

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

T15131279

N/A

32

30 - 39

Associate In Arts Degree

AA

Associate In Arts

1192401010

20153

Summer Term 2015

Associate In Arts

Yes

1000

S146618621000 20153

132547

Y

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

S14661862

N/A

22

22 - 29

Associate In Arts Degree

AA

Associate In Arts

1192401010

20152

Spring Term 2015

Associate In Arts

Yes

1000

D132011161000 20152

92059

Y

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

D13201116

N/A

29

22 - 29

Non-Degree Seeking

ND

Non-Credit

9999999999

20171

Fall Term 2016

Transient Student

Yes

3409

K065445223409 20171

122103

Y

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

K06544522

N/A

19

19 - 21

Associate In Science Degree

AS

Interior Design Tech As

1450040801

20163

Summer Term 2016

Interior Design Technology

Yes

2012

M146559712012 20163

69523

Y

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

M14655971

N/A

18

< 19

Associate In Arts Degree

AA

Associate In Arts

1192401010

20171

Fall Term 2016

Associate In Arts

Yes

1000

B151806231000 20171

84188

Y

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

B15180623

N/A

36

30 - 39

Associate In Arts Degree

AA

Associate In Arts

1192401010

20153

Summer Term 2015

Associate In Arts

Yes

1000

A149228191000 20153

74767

Y

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

A14922819

N/A

20

19 - 21

Associate In Science Degree

AS

Nursing As

1351380100

20141

Fall Term 2013

Nursing

No

2301

S136339042301 20141

120006

Y

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

S13633904

N/A

18

< 19

Associate In Arts Degree

AA

Associate In Arts

1192401010

20161

Fall Term 2015

Associate In Arts

Yes

1000

J150639771000 20161

114985

Y

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

J15063977

N/A

19

19 - 21

Non-Degree Seeking

ND

Non-Credit

9999999999

20143

Summer Term 2014

Transient Student

Yes

3409

K140054823409 20143

121410

Y

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

K14005482

N/A