|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_FactInstitutionalRetentionSnapshot |
| Database Table Name | FactInstitutionalRetentionSnapshot |
| Schema | dbo |
| Friendly Name | FactInstitutionalRetentionSnapshot |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
InstitutionalRetentionSnapshotSK |
InstitutionalRetentionSnapshotSK |
System.Int32 | ||
 |
InstitutionalRetentionCohortSK |
InstitutionalRetentionCohortSK |
System.Int32 | ||
|
InstitutionalRetentionCohortTermSK |
InstitutionalRetentionCohortTermSK |
System.Int32 | ||
|
StudentSK |
StudentSK |
System.Int32 | ||
|
InstitutionalRetentionTrackingTermSK |
InstitutionalRetentionTrackingTermSK |
System.Int32 | ||
|
RetentionCohortTypeSK |
RetentionCohortTypeSK |
System.Int32 | ||
|
RetentionYearCount |
RetentionYearCount |
System.Int16 | ||
|
RetentionTermCount |
RetentionTermCount |
System.Int16 | ||
|
EnrolledInTerm |
EnrolledInTerm |
System.Int16 | ||
|
Graduated |
Graduated |
System.Int16 | ||
|
NotEnrolledInTerm |
NotEnrolledInTerm |
System.Int16 |
Parent Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
InstitutionalRetentionTrackingTermSK |
DimTerm |
Table |
False |
||
InstitutionalRetentionCohortSK |
DimInstitutionalRetentionCohort |
Table |
False |
||
InstitutionalRetentionCohortTermSK |
DimTerm |
Table |
False |
||
StudentSK |
DimStudent |
Table |
False |
||
RetentionCohortTypeSK |
DimRetentionCohortType |
Table |
False |
||
RetentionYearCount |
PastYears |
View |
True |
Child Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
| Powered by BI Documenter |
