|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimApplication |
| Database Table Name | DimApplication |
| Schema | dbo |
| Friendly Name | DimApplication |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
ApplicationSK |
ApplicationSK |
System.Int32 | ||
 |
ApplicationAK |
ApplicationAK |
System.String(23) | ||
|
StudentId |
StudentId |
System.String(9) | ||
|
ApplicationTerm |
ApplicationTerm |
System.String(6) | ||
|
ApplicationTermTitle |
ApplicationTermTitle |
System.String(30) | ||
|
ApplicationEntry |
ApplicationEntry |
System.String(15) | ||
|
ApplicationTypeCode |
ApplicationTypeCode |
System.String(3) | ||
|
ApplicationType |
ApplicationType |
System.String(60) | ||
|
CreditVocationalBachelorApplication |
CreditVocationalBachelorApplication |
System.String(15) | ||
|
InitialOrReadmitApplication |
InitialOrReadmitApplication |
System.String(15) | ||
|
BasisOfAdmissionCode |
BasisOfAdmissionCode |
System.String(3) | ||
|
BasisOfAdmission |
BasisOfAdmission |
System.String(30) | ||
|
EnrollmentStatusCode |
EnrollmentStatusCode |
System.String(3) | ||
|
EnrollmentStatus |
EnrollmentStatus |
System.String(30) | ||
|
FirstTimeInCollege |
FirstTimeInCollege |
System.String(3) | ||
|
BachelorApplicant |
BachelorApplicant |
System.String(3) | ||
|
ProgramCode |
ProgramCode |
System.String(5) | ||
|
Program |
Program |
System.String(30) | ||
|
AwardTypeCode |
AwardTypeCode |
System.String(3) | ||
|
AwardType |
AwardType |
System.String(30) | ||
|
ApplicationDate |
ApplicationDate |
System.DateTime | ||
|
FirstTermEnrolled |
FirstTermEnrolled |
System.String(6) | ||
|
FirstTermEnrolledTitle |
FirstTermEnrolledTitle |
System.String(30) | ||
|
HomeCampusCode |
HomeCampusCode |
System.String(3) | ||
|
HomeCampus |
HomeCampus |
System.String(50) | ||
|
RowIsCurrent |
RowIsCurrent |
System.String(1) | ||
|
RowStartDate |
RowStartDate |
System.DateTime | ||
|
RowEndDate |
RowEndDate |
System.DateTime |
Parent Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
Child Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
ApplicationSK |
FactApplicationStatus |
Table |
False |
| Powered by BI Documenter |
