EnterpriseDW_SSAS
 dbo_FactApplicationStatus (Data Source View Table)
  Properties
Property Value
Table Name dbo_FactApplicationStatus
Database Table Name FactApplicationStatus
Schema dbo
Friendly Name FactApplicationStatus
Table Type Table
Query Definition
Description
  Columns
 
Column Name
Friendly Name
Data Type
Computed Column Expression
Description
In Primary Key
ApplicationStatusSK
ApplicationStatusSK
System.Int32
ApplicationSK
ApplicationSK
System.Int32
ApplicationSourceSK
ApplicationSourceSK
System.Int32
StudentObjectiveSK
StudentObjectiveSK
System.Int32
ApplicationTermSK
ApplicationTermSK
System.Int32
StudentSK
StudentSK
System.Int32
ApplicationDateSK
ApplicationDateSK
System.Int32
StudentTermSK
StudentTermSK
System.Int32
NeedTesting
NeedTesting
System.Int16
NeedAdvising
NeedAdvising
System.Int16
NeedOrientation
NeedOrientation
System.Int16
NeedTranscripts
NeedTranscripts
System.Int16
ResidencyHold
ResidencyHold
System.Int16
NeedEducationalPlan
NeedEducationalPlan
System.Int16
OtherRegistrationHold
OtherRegistrationHold
System.Int16
NoAdmissionBarriers
NoAdmissionBarriers
System.Int16
NotEnrolled
NotEnrolled
System.Int16
EnrolledAfterApplicationTerm
EnrolledAfterApplicationTerm
System.Int16
EnrolledInApplicationTerm
EnrolledInApplicationTerm
System.Int16
  Parent Relations
Table Name
Using Column
Friendly Name
Table Type
Is Logical
Description
ApplicationSourceSK
DimApplicationSource
Table
False
ApplicationTermSK
DimTerm
Table
False
ApplicationSK
DimApplication
Table
False
StudentSK
DimStudent
Table
False
StudentTermSK
DimStudentTerm
Table
False
StudentObjectiveSK
DimStudentObjective
Table
False
  Child Relations
Table Name
Using Column
Friendly Name
Table Type
Is Logical
Description
Powered by BI Documenter