EnterpriseDW
 dbo.FactInstitutionalRetentionSnapshot (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.FactInstitutionalRetentionSnapshot
  Properties
Property Value
Name FactInstitutionalRetentionSnapshot
Schema dbo
Row Count 618466
Data Size 26936 KB
Index Size 9232 KB
Create Date 1/28/2014 9:47 AM
Description The fact will contain one row per student per term for each applicable tracking term for the retention cohorts. The information
  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 graduated in the Retention tracking term.
Foreign Key
InstitutionalRetentionCohortSK
int(10, 0)
False
False
False
 
Key identifier for the Institutional Retention Cohort, used to reference the Institutional Retention cohort dimension.
Foreign Key
InstitutionalRetentionCohortTermSK
int(10, 0)
False
False
False
 
Key identifier for the Term dimension, represents the original cohort term for the student.
In Primary Key
InstitutionalRetentionSnapshotSK
int(10, 0)
False
False
False
(1 / 1)
Primary Key for the Institutional Retention Term measures.
Foreign Key
InstitutionalRetentionTrackingTermSK
int(10, 0)
False
False
False
 
Key identifier for the Term dimension, represents the Institutional Retention tracking term for the student.
NotEnrolledInTerm
smallint(5, 0)
False
False
False
 
Indication if the student is not enrolled for the Retention tracking term.
Foreign Key
RetentionCohortTypeSK
int(10, 0)
False
False
False
 
Key identifier for the Retention Cohort type, represents the type of retention tracking.
RetentionTermCount
smallint(5, 0)
False
False
False
 
Indication of the terms for retention tracking for a student.
RetentionYearCount
smallint(5, 0)
False
False
False
 
Indication of the years 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.
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
InstitutionalRetentionSnapshotSK
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
InstitutionalRetentionCohortSK
DimInstitutionalRetentionCohort
InstitutionalRetentionCohortSK
True
InstitutionalRetentionCohortTermSK
DimTerm
TermSK
True
InstitutionalRetentionTrackingTermSK
DimTerm
TermSK
True
RetentionCohortTypeSK
DimRetentionCohortType
RetentionCohortTypeSK
True
StudentSK
DimStudent
StudentSK
True
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FactInstitutionalRetentionSnapshot depends on)
Name Type
Table
Table
Table
Table
  Child Dependencies (objects that depend on dbo.FactInstitutionalRetentionSnapshot)
Name Type
TABLE
TABLE
TABLE
TABLE
  Extended Properties
Object Property Value
FactInstitutionalRetentionSnapshot
Display Name
IRSnapshot
FactInstitutionalRetentionSnapshot
MS_Description
The fact will contain one row per student per term for each applicable tracking term for the retention cohorts. The information
FactInstitutionalRetentionSnapshot
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 graduated in the Retention tracking term.
Graduated
Source Field Name
STDNT_GRAD_PROGRESS
Graduated
Source System
DWStaging
Graduated
Source Table
ST_STDNT_ENDOFTERM_A
InstitutionalRetentionCohortSK
Display Name
InstitutionalRetentionCohortSK
InstitutionalRetentionCohortSK
Example Values
1,2,3
InstitutionalRetentionCohortSK
MS_Description
Key identifier for the Institutional Retention Cohort, used to reference the Institutional Retention cohort dimension.
InstitutionalRetentionCohortSK
Source Field Name
InstitutionalRetentionCohortSK
InstitutionalRetentionCohortSK
Source System
EnterpriseDW
InstitutionalRetentionCohortSK
Source Table
dbo.DimInstitutionalRetentionCohort
InstitutionalRetentionCohortTermSK
Display Name
InstitutionalRetentionCohortTermSK
InstitutionalRetentionCohortTermSK
Example Values
1992, 20103, 20121
InstitutionalRetentionCohortTermSK
MS_Description
Key identifier for the Term dimension, represents the original cohort term for the student.
InstitutionalRetentionCohortTermSK
Source Field Name
CohortTerm
InstitutionalRetentionCohortTermSK
Source System
EnterpriseDW
InstitutionalRetentionCohortTermSK
Source Table
dbo.DimInstitutionalRetentionCohort
InstitutionalRetentionSnapshotSK
Display Name
InstitutionalRetentionSnapshotSK
InstitutionalRetentionSnapshotSK
Example Values
1,2,3
InstitutionalRetentionSnapshotSK
MS_Description
Primary Key for the Institutional Retention Term measures.
InstitutionalRetentionTrackingTermSK
Display Name
InstitutionalRetentionTrackingTermSK
InstitutionalRetentionTrackingTermSK
Example Values
1992, 20103, 20121
InstitutionalRetentionTrackingTermSK
MS_Description
Key identifier for the Term dimension, represents the Institutional Retention tracking term for the student.
InstitutionalRetentionTrackingTermSK
Source Field Name
TRM_YR
InstitutionalRetentionTrackingTermSK
Source System
DWStaging
InstitutionalRetentionTrackingTermSK
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 not enrolled for the Retention tracking term.
NotEnrolledInTerm
Source Field Name
STDNT_ENROLLED_FLG
NotEnrolledInTerm
Source System
DWStaging
NotEnrolledInTerm
Source Table
ST_STDNT_ENDOFTERM_A
RetentionCohortTypeSK
Display Name
RetentionCohortTypeSK
RetentionCohortTypeSK
Example Values
1,2,3
RetentionCohortTypeSK
MS_Description
Key identifier for the Retention Cohort type, represents the type of retention tracking.
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
RetentionYearCount
Display Name
Retention Years
RetentionYearCount
Example Values
1,2,3,4,
RetentionYearCount
MS_Description
Indication of the years for retention tracking for a student.
RetentionYearCount
Source Field Name
RetentionYearCount
Source System
Derived
RetentionYearCount
Source Table
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
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FactInstitutionalRetentionSnapshot] Script Date: 03/09/2017 17:14:58 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FactInstitutionalRetentionSnapshot](
    [InstitutionalRetentionSnapshotSK] [int] IDENTITY(1,1) NOT NULL,
    [InstitutionalRetentionCohortSK] [int] NOT NULL,
    [InstitutionalRetentionCohortTermSK] [int] NOT NULL,
    [StudentSK] [int] NOT NULL,
    [InstitutionalRetentionTrackingTermSK] [int] NOT NULL,
    [RetentionCohortTypeSK] [int] NOT NULL,
    [RetentionYearCount] [smallint] NOT NULL,
    [RetentionTermCount] [smallint] NOT NULL,
    [EnrolledInTerm] [smallint] NOT NULL,
    [Graduated] [smallint] NOT NULL,
    [NotEnrolledInTerm] [smallint] NOT NULL,
 CONSTRAINT [PK_dbo.FactInstitutionalRetentionSnapshot] PRIMARY KEY NONCLUSTERED 
(
    [InstitutionalRetentionSnapshotSK] 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].[FactInstitutionalRetentionSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactInstitutionalRetentionSnapshot_InstitutionalRetentionCohortSK] FOREIGN KEY([InstitutionalRetentionCohortSK])
REFERENCES [DimInstitutionalRetentionCohort] ([InstitutionalRetentionCohortSK])
ALTER TABLE [dbo].[FactInstitutionalRetentionSnapshot] CHECK CONSTRAINT [FK_dbo_FactInstitutionalRetentionSnapshot_InstitutionalRetentionCohortSK]
ALTER TABLE [dbo].[FactInstitutionalRetentionSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactInstitutionalRetentionSnapshot_InstitutionalRetentionCohortTermSK] FOREIGN KEY([InstitutionalRetentionCohortTermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactInstitutionalRetentionSnapshot] CHECK CONSTRAINT [FK_dbo_FactInstitutionalRetentionSnapshot_InstitutionalRetentionCohortTermSK]
ALTER TABLE [dbo].[FactInstitutionalRetentionSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactInstitutionalRetentionSnapshot_InstitutionalRetentionTrackingTermSK] FOREIGN KEY([InstitutionalRetentionTrackingTermSK])
REFERENCES [DimTerm] ([TermSK])
ALTER TABLE [dbo].[FactInstitutionalRetentionSnapshot] CHECK CONSTRAINT [FK_dbo_FactInstitutionalRetentionSnapshot_InstitutionalRetentionTrackingTermSK]
ALTER TABLE [dbo].[FactInstitutionalRetentionSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactInstitutionalRetentionSnapshot_RetentionCohortTypeSK] FOREIGN KEY([RetentionCohortTypeSK])
REFERENCES [DimRetentionCohortType] ([RetentionCohortTypeSK])
ALTER TABLE [dbo].[FactInstitutionalRetentionSnapshot] CHECK CONSTRAINT [FK_dbo_FactInstitutionalRetentionSnapshot_RetentionCohortTypeSK]
ALTER TABLE [dbo].[FactInstitutionalRetentionSnapshot]  WITH CHECK ADD  CONSTRAINT [FK_dbo_FactInstitutionalRetentionSnapshot_StudentSK] FOREIGN KEY([StudentSK])
REFERENCES [DimStudent] ([StudentSK])
ALTER TABLE [dbo].[FactInstitutionalRetentionSnapshot] CHECK CONSTRAINT [FK_dbo_FactInstitutionalRetentionSnapshot_StudentSK]


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The fact will contain one row per student per term for each applicable tracking term for the retention cohorts. The information' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactInstitutionalRetentionSnapshot'


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


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication if the student graduated in the Retention tracking term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactInstitutionalRetentionSnapshot', @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'FactInstitutionalRetentionSnapshot', @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'FactInstitutionalRetentionSnapshot', @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'FactInstitutionalRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'Graduated'


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indication if the student is not enrolled for the Retention tracking term.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactInstitutionalRetentionSnapshot', @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'FactInstitutionalRetentionSnapshot', @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'FactInstitutionalRetentionSnapshot', @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'FactInstitutionalRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'NotEnrolledInTerm'


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


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


EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Key identifier for the Retention Cohort type, represents the type of retention tracking.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactInstitutionalRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'RetentionCohortTypeSK'


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


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


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


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


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


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


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


EXEC sys.sp_addextendedproperty @name=N'Display Name', @value=N'StudentSK' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FactInstitutionalRetentionSnapshot', @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'FactInstitutionalRetentionSnapshot', @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'FactInstitutionalRetentionSnapshot', @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'FactInstitutionalRetentionSnapshot', @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'FactInstitutionalRetentionSnapshot', @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'FactInstitutionalRetentionSnapshot', @level2type=N'COLUMN',@level2name=N'StudentSK'
  Sample Data
EnrolledInTerm Graduated InstitutionalRetentionCohortSK InstitutionalRetentionCohortTermSK InstitutionalRetentionSnapshotSK InstitutionalRetentionTrackingTermSK NotEnrolledInTerm RetentionCohortTypeSK RetentionTermCount RetentionYearCount StudentSK
1 0 424216 20152 361323 20153 0 6 2 0 23252864
1 0 529998 20141 594179 20141 0 4 1 0 23589275
1 0 363286 20161 178239 20171 0 2 0 2 22944785
1 0 239027 20152 1778 20161 0 5 2 0 22746957
1 0 384819 20151 301326 20152 0 4 2 0 23156604
1 0 340241 20171 157084 20171 0 4 1 0 22928621
1 0 426512 20142 386354 20151 0 5 2 0 23316848
0 0 344501 20162 149009 20163 1 6 2 0 22936078
0 0 288410 20162 88465 20171 1 5 2 0 22821860
1 0 291748 20162 233263 20163 0 6 2 0 23032529
Powered by BI Documenter