|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_FactProgramRetentionSnapshot |
| Database Table Name | FactProgramRetentionSnapshot |
| Schema | dbo |
| Friendly Name | FactProgramRetentionSnapshot |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
ProgramRetentionSnapshotSK |
ProgramRetentionSnapshotSK |
System.Int32 | ||
 |
ProgramRetentionCohortSK |
ProgramRetentionCohortSK |
System.Int32 | ||
|
ProgramRetentionCohortTermSK |
ProgramRetentionCohortTermSK |
System.Int32 | ||
|
StudentSK |
StudentSK |
System.Int32 | ||
|
ProgramRetentionTrackingTermSK |
ProgramRetentionTrackingTermSK |
System.Int32 | ||
|
RetentionTermCount |
RetentionTermCount |
System.Int16 | ||
|
EnrolledInTerm |
EnrolledInTerm |
System.Int16 | ||
|
Graduated |
Graduated |
System.Int16 | ||
|
SwitchedPrograms |
SwitchedPrograms |
System.Int16 | ||
|
NotEnrolledInTerm |
NotEnrolledInTerm |
System.Int16 | ||
|
TrackingYearsAfterCohortTerm |
System.Int16 |
Parent Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
ProgramRetentionCohortSK |
DimProgramRetentionCohort |
Table |
False |
||
StudentSK |
DimStudent |
Table |
False |
||
ProgramRetentionTrackingTermSK |
DimTerm |
Table |
False |
||
ProgramRetentionCohortTermSK |
DimTerm |
Table |
False |
||
TrackingYearsAfterCohortTerm |
TrackingYears |
View |
True |
Child Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
| Powered by BI Documenter |
