|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_FactPriorEnrollmentSnapshot |
| Database Table Name | FactPriorEnrollmentSnapshot |
| Schema | dbo |
| Friendly Name | FactPriorEnrollmentSnapshot |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
DateSK |
DateSK |
System.Int32 | ||
|
StudentSK |
StudentSK |
System.Int32 | ||
|
StudentTermSK |
StudentTermSK |
System.Int32 | ||
|
ActiveTermSK |
ActiveTermSK |
System.Int32 | ||
|
CurriculumSK |
CurriculumSK |
System.Int32 | ||
|
FTEClassificationSK |
FTEClassificationSK |
System.Int32 | ||
|
PriorTermSK |
PriorTermSK |
System.Int32 | ||
|
PriorRelativeDay |
PriorRelativeDay |
System.Int32 | ||
|
PriorEnrollment |
PriorEnrollment |
System.Int32 | ||
|
PriorPaidEnrollment |
PriorPaidEnrollment |
System.Int32 | ||
|
PriorCreditHours |
PriorCreditHours |
System.Decimal | ||
|
PriorClockHours |
PriorClockHours |
System.Decimal | ||
|
PriorFullTimeEquivalent |
PriorFullTimeEquivalent |
System.Decimal | ||
|
PriorPaidFullTimeEquivalent |
System.Decimal | |||
|
PriorCreditAndClockHoursCombined |
System.Decimal |
Parent Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
FTEClassificationSK |
DimFTEClassification |
Table |
False |
||
ActiveTermSK |
DimTerm |
Table |
False |
||
PriorTermSK |
DimTerm |
Table |
False |
||
StudentTermSK |
DimStudentTerm |
Table |
False |
||
StudentSK |
DimStudent |
Table |
False |
||
DateSK |
DimDate |
Table |
False |
||
CurriculumSK |
DimCurriculum |
Table |
False |
Child Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
| Powered by BI Documenter |
