|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimStudentObjective |
| Database Table Name | DimStudentObjective |
| Schema | dbo |
| Friendly Name | DimStudentObjective |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
StudentObjectiveSK |
StudentObjectiveSK |
System.Int32 | ||
 |
StudentObjectiveAK |
StudentObjectiveAK |
System.String(23) | ||
|
StudentId |
StudentId |
System.String(9) | ||
|
ProgramCode |
ProgramCode |
System.String(5) | ||
|
Program |
Program |
System.String(30) | ||
|
EffectiveTerm |
EffectiveTerm |
System.String(6) | ||
|
EffectiveTermTitle |
EffectiveTermTitle |
System.String(30) | ||
|
SequenceNumber |
SequenceNumber |
System.Int32 | ||
|
AdmissionStatus |
AdmissionStatus |
System.String(3) | ||
|
AwardTypeCode |
AwardTypeCode |
System.String(3) | ||
|
AwardType |
AwardType |
System.String(30) | ||
|
PrimaryObjective |
PrimaryObjective |
System.String(3) | ||
|
ProgramStatusCode |
ProgramStatusCode |
System.String(3) | ||
|
GraduationStatusCode |
GraduationStatusCode |
System.String(3) | ||
|
ExpectedGraduationTerm |
ExpectedGraduationTerm |
System.String(6) | ||
|
ExpectedGraduationTermTitle |
ExpectedGraduationTermTitle |
System.String(30) | ||
|
ActualGraduationTerm |
ActualGraduationTerm |
System.String(6) | ||
|
ActualGraduationTermTitle |
ActualGraduationTermTitle |
System.String(30) | ||
|
GraduationAge |
GraduationAge |
System.Int16 | ||
|
GraduationAgeRange |
GraduationAgeRange |
System.String(10) | ||
|
GraduationHonorsCode |
GraduationHonorsCode |
System.String(3) | ||
|
TransferMajorCode |
TransferMajorCode |
System.String(6) | ||
|
TransferMajor |
TransferMajor |
System.String(30) | ||
|
TransferInstitutionId |
TransferInstitutionId |
System.String(8) | ||
|
TransferInstitution |
TransferInstitution |
System.String(50) | ||
|
ReportedTerm |
ReportedTerm |
System.String(6) | ||
|
ReportedTermTitle |
ReportedTermTitle |
System.String(30) | ||
|
RowIsCurrent |
RowIsCurrent |
System.String(1) | ||
|
RowStartDate |
RowStartDate |
System.DateTime | ||
|
RowEndDate |
RowEndDate |
System.DateTime | ||
|
GraduationAgeRangeSort |
System.String(13) | CASE WHEN LEFT(GraduationAgeRange,1) = '>' THEN 'zz1' + GraduationAgeRange WHEN GraduationAgeRange = 'Other' THEN 'zz2' + GraduationAgeRange WHEN GraduationAgeRange = 'N/A' THEN 'zz3' + GraduationAgeRange ELSE GraduationAgeRange END |
Sorting sequence for graduation age range. |
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 |
StudentObjectiveSK |
FactApplicationStatus |
Table |
False |
||
StudentObjectiveSK |
FactStudentSuccess_TermSnapshot |
Table |
False |
||
StudentObjectiveSK |
FactStudentSuccess_FirstYearSnapshot |
Table |
False |
||
StudentObjectiveSK |
FactStudentGraduation |
Table |
False |
| Powered by BI Documenter |
