EnterpriseDW
 dbo.FactProgramRetentionSnapshot (Table)
Home  Diagrams  Documents  Images  EnterpriseDW  Storage  Users  Roles  Schemas  Tables  Views  Indexes  Triggers  Stored Procedures  Functions  Data Types  XML Schemas  Rules  Defaults  Fulltext Catalogs  Synonyms  Keys  Partitions  Assemblies 
Current Path:  EnterpriseDW   Tables   dbo.FactProgramRetentionSnapshot
  Properties
Property Value
Name FactProgramRetentionSnapshot
Schema dbo
Row Count 430497
Data Size 18072 KB
Index Size 6432 KB
Create Date 1/28/2014 9:47 AM
Description The fact will contain one row per student per term for every term for 4 years from the cohort term. The information will be cap
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
EnrolledInTerm
smallint(5, 0)
False
False
False
 
Indication if the student is enrolled for the Retention tracking term.
Graduated
smallint(5, 0)
False
False
False
 
Indication if the student is enrolled for the Retention tracking term.
NotEnrolledInTerm
smallint(5, 0)
False
False
False
 
Indication if the student is enrolled for the Retention tracking term.
Foreign Key
ProgramRetentionCohortSK
int(10, 0)
False
False
False
 
Key identifier for the Program Retention Cohort, used to reference the Program Retention cohort dimension.
Foreign Key
ProgramRetentionCohortTermSK
int(10, 0)
False
False
False
 
Key identifier for the Term dimension, represents the original cohort term for the student.
In Primary Key
ProgramRetentionSnapshotSK
int(10, 0)
False
False
False
(1 / 1)
Primary Key for the Program Retention Term measures.
Foreign Key
ProgramRetentionTrackingTermSK
int(10, 0)
False
False
False
 
Key identifier for the Term dimension, represents the Program Retention tracking term for the student.
RetentionTermCount
smallint(5, 0)
False
False
False
 
Indication of the terms for retention tracking for a student.
Foreign Key
StudentSK
int(10, 0)
False
False
False
 
Key identifier for the student, used to reference the student dimension.
SwitchedPrograms
smallint(5, 0)
False
False
False
 
Indication of the student has switched programs from the program of the cohort.
TrackingYearsAfterCohortTerm
smallint(5, 0)
False
False
False
 
Indication of the number of full years since the cohort term for a student. Equals -1 when tracking term is not same term type as cohort term.
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ProgramRetentionSnapshotSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
ProgramRetentionCohortSK
DimProgramRetentionCohort
ProgramRetentionCohortSK
True
ProgramRetentionCohortTermSK
DimTerm
TermSK
True
ProgramRetentionTrackingTermSK
DimTerm
TermSK
True
StudentSK
DimStudent
StudentSK
True
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FactProgramRetentionSnapshot depends on)
Name Type
Table
Table
Table
  Child Dependencies (objects that depend on dbo.FactProgramRetentionSnapshot)
Name Type
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
FactProgramRetentionSnapshot
Display Name
PRSnapshot
FactProgramRetentionSnapshot
MS_Description
The fact will contain one row per student per term for every term for 4 years from the cohort term. The information will be cap
FactProgramRetentionSnapshot
Table Type
Fact
EnrolledInTerm
Display Name
Enrolled in the Term
EnrolledInTerm
Example Values
0,1
EnrolledInTerm
MS_Description
Indication if the student is enrolled for the Retention tracking term.
EnrolledInTerm
Source Field Name
STDNT_ENROLLED_FLG
EnrolledInTerm
Source System
DWStaging
EnrolledInTerm
Source Table
ST_STDNT_ENDOFTERM_A
Graduated
Display Name
Graduated
Graduated
Example Values
0,1
Graduated
MS_Description
Indication if the student is enrolled for the Retention tracking term.
Graduated
Source Field Name
STDNT_GRAD_PROGRESS
Graduated
Source System
DWStaging
Graduated
Source Table
ST_STDNT_ENDOFTERM_A
NotEnrolledInTerm
Display Name
Not Enrolled in The Term
NotEnrolledInTerm
Example Values
0,1
NotEnrolledInTerm
MS_Description
Indication if the student is enrolled for the Retention tracking term.
NotEnrolledInTerm
Source Field Name
STDNT_ENROLLED_FLG
NotEnrolledInTerm
Source System
DWStaging
NotEnrolledInTerm
Source Table
ST_STDNT_ENDOFTERM_A
ProgramRetentionCohortSK
Display Name
ProgramRetentionCohortSK
ProgramRetentionCohortSK
Example Values
1,2,3
ProgramRetentionCohortSK
MS_Description
Key identifier for the Program Retention Cohort, used to reference the Program Retention cohort dimension.
ProgramRetentionCohortSK
Source Field Name
ProgramRetentionCohortSK
ProgramRetentionCohortSK
Source System
EnterpriseDW
ProgramRetentionCohortSK
Source Table
dbo.DimProgramRetentionCohort
ProgramRetentionCohortTermSK
Display Name
ProgramRetentionCohortTermSK
ProgramRetentionCohortTermSK
Example Values
1992, 20103, 20121
ProgramRetentionCohortTermSK
MS_Description
Key identifier for the Term dimension, represents the original cohort term for the student.
ProgramRetentionCohortTermSK
Source Field Name
CohortTerm
ProgramRetentionCohortTermSK
Source System
EnterpriseDW
ProgramRetentionCohortTermSK
Source Table
dbo.DimProgramRetentionCohort
ProgramRetentionSnapshotSK
Display Name
ProgramRetentionSnapshotSK
ProgramRetentionSnapshotSK
Example Values
1,2,3
ProgramRetentionSnapshotSK
MS_Description
Primary Key for the Program Retention Term measures.
ProgramRetentionTrackingTermSK
Display Name
ProgramRetentionTrackingTermSK
ProgramRetentionTrackingTermSK
Example Values
1992, 20103, 20121
ProgramRetentionTrackingTermSK
MS_Description
Key identifier for the Term dimension, represents the Program Retention tracking term for the student.
ProgramRetentionTrackingTermSK
Source Field Name
TRM_YR
ProgramRetentionTrackingTermSK
Source System
DWStaging
ProgramRetentionTrackingTermSK
Source Table
ST_STDNT_ENDOFTERM_A
RetentionTermCount
Display Name
Retention Terms
RetentionTermCount
Example Values
1,2,3
RetentionTermCount
MS_Description
Indication of the terms for retention tracking for a student.
RetentionTermCount
Source System
Derived
StudentSK
Display Name
StudentSK
StudentSK
Example Values
1,2,3
StudentSK
MS_Description
Key identifier for the student, used to reference the student dimension.
StudentSK
Source Field Name
STDNT_ID
StudentSK
Source System
DWStaging
StudentSK
Source Table
ST_STDNT_ENDOFTERM_A
SwitchedPrograms
Display Name
Switched Programs
SwitchedPrograms
Example Values
0,1
SwitchedPrograms
MS_Description
Indication of the student has switched programs from the program of the cohort.
SwitchedPrograms
Source Field Name
PGM_ID
SwitchedPrograms
Source System
DWStaging
SwitchedPrograms
Source Table
ST_STDNT_ENDOFTERM_A
TrackingYearsAfterCohortTerm
Display Name
Retention Years
TrackingYearsAfterCohortTerm
Example Values
1,2,3,4,
TrackingYearsAfterCohortTerm
MS_Description
Indication of the number of full years since the cohort term for a student. Equals -1 when tracking term is not same term type as cohort term.
TrackingYearsAfterCohortTerm
Source Field Name
TrackingYearsAfterCohortTerm
Source System
Derived
TrackingYearsAfterCohortTerm
Source Table
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FactProgramRetentionSnapshot] Script Date: 03/09/2017 17:14:59 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactProgramRetentionSnapshot](
    [ProgramRetentionSnapshotSK] [int] IDENTITY(1,1) NOT NULL,
    [ProgramRetentionCohortSK] [int] NOT NULL,
    [ProgramRetentionCohortTermSK] [int] NOT NULL,
    [StudentSK] [int] NOT NULL,
    [ProgramRetentionTrackingTermSK] [int] NOT NULL,
    [TrackingYearsAfterCohortTerm] [smallint] NOT NULL,
    [RetentionTermCount] [smallint] NOT NULL,
    [EnrolledInTerm] [smallint] NOT NULL,
    [Graduated] [smallint] NOT NULL,
    [SwitchedPrograms] [smallint] NOT NULL,
    [NotEnrolledInTerm] [smallint] NOT NULL,
 CONSTRAINT [PK_dbo.FactProgramRetentionSnapshot] PRIMARY KEY NONCLUSTERED 
(
    [ProgramRetentionSnapshotSK] 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].[FactProgramRetentionSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactProgramRetentionSnapshot_ProgramRetentionCohortSK] FOREIGN KEY([ProgramRetentionCohortSK])
REFERENCES [DimProgramRetentionCohort] ([ProgramRetentionCohortSK])
ALTER TABLE [dbo].[FactProgramRetentionSnapshot] CHECK CONSTRAINT [FK_dbo_FactProgramRetentionSnapshot_ProgramRetentionCohortSK]
ALTER TABLE [dbo].[FactProgramRetentionSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactProgramRetentionSnapshot_ProgramRetentionCohortTermSK] FOREIGN KEY([ProgramRetentionCohortTermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactProgramRetentionSnapshot] CHECK CONSTRAINT [FK_dbo_FactProgramRetentionSnapshot_ProgramRetentionCohortTermSK]
ALTER TABLE [dbo].[FactProgramRetentionSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactProgramRetentionSnapshot_ProgramRetentionTrackingTermSK] FOREIGN KEY([ProgramRetentionTrackingTermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactProgramRetentionSnapshot] CHECK CONSTRAINT [FK_dbo_FactProgramRetentionSnapshot_ProgramRetentionTrackingTermSK]
ALTER TABLE [dbo].[FactProgramRetentionSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactProgramRetentionSnapshot_StudentSK] FOREIGN KEY([StudentSK])
REFERENCES [DimStudent] ([StudentSK])
ALTER TABLE [dbo].[FactProgramRetentionSnapshot] CHECK CONSTRAINT [FK_dbo_FactProgramRetentionSnapshot_StudentSK]


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The fact will contain one row per student per term for every term for 4 years from the cohort term. The information will be cap' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot'


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Enrolled in the Term' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'EnrolledInTerm'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'0,1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'EnrolledInTerm'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication if the student is enrolled for the Retention tracking term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'EnrolledInTerm'


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'0,1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'Graduated'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication if the student is enrolled for the Retention tracking term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'Graduated'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Not Enrolled in The Term' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'NotEnrolledInTerm'


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'0,1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'NotEnrolledInTerm'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication if the student is enrolled for the Retention tracking term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'NotEnrolledInTerm'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'ProgramRetentionCohortSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @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'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'ProgramRetentionCohortSK'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the Program Retention Cohort, used to reference the Program Retention cohort dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'ProgramRetentionCohortSK'


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


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the Term dimension, represents the original cohort term for the student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'ProgramRetentionCohortTermSK'


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


EXEC sys.sp_addextendedproperty @name=N'Source System', @value=N'EnterpriseDW' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'ProgramRetentionCohortTermSK'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary Key for the Program Retention Term measures.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'ProgramRetentionSnapshotSK'


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


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the Term dimension, represents the Program Retention tracking term for the student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'ProgramRetentionTrackingTermSK'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Retention Terms' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'RetentionTermCount'


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication of the terms for retention tracking for a student.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'RetentionTermCount'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the student, used to reference the student dimension.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'StudentSK'


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Example Values', @value=N'0,1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'SwitchedPrograms'


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication of the student has switched programs from the program of the cohort.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'SwitchedPrograms'


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'Retention Years' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'TrackingYearsAfterCohortTerm'


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication of the number of full years since the cohort term for a student. Equals -1 when tracking term is not same term type as cohort term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'TrackingYearsAfterCohortTerm'


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


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


EXEC sys.sp_addextendedproperty @name=N'Source Table', @value=N' ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactProgramRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'TrackingYearsAfterCohortTerm'
  Sample Data
EnrolledInTerm Graduated NotEnrolledInTerm ProgramRetentionCohortSK ProgramRetentionCohortTermSK ProgramRetentionSnapshotSK ProgramRetentionTrackingTermSK RetentionTermCount StudentSK SwitchedPrograms TrackingYearsAfterCohortTerm
0 0 1 114419 20143 206184 20152 3 23155792 0 -1
0 0 1 75640 20142 31710 20162 7 22776158 0 2
1 0 0 92258 20141 108617 20162 8 22935926 0 -1
0 0 1 73665 20142 29529 20151 3 22775226 0 -1
0 0 1 128728 20141 269721 20163 9 23330128 0 -1
0 0 1 112259 20142 197751 20153 5 23153352 0 -1
0 0 1 89877 20152 96183 20153 2 22767961 0 -1
0 0 1 111554 20141 192248 20153 6 23152096 0 -1
0 0 1 138082 20151 412530 20161 4 23597511 0 1
0 0 1 92019 20141 107793 20162 8 22929190 0 -1
Powered by BI Documenter