|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimStudentTerm |
| Database Table Name | DimStudentTerm |
| Schema | dbo |
| Friendly Name | DimStudentTerm |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
StudentTermSK |
StudentTermSK |
System.Int32 | ||
 |
StudentTermAK |
StudentTermAK |
System.String(15) | ||
|
StudentId |
StudentId |
System.String(9) | ||
|
Term |
Term |
System.String(6) | ||
|
TermTitle |
TermTitle |
System.String(30) | ||
|
ResidencyCode |
ResidencyCode |
System.String(3) | ||
|
Residency |
Residency |
System.String(30) | ||
|
ProgramCode |
ProgramCode |
System.String(5) | ||
|
Program |
Program |
System.String(30) | ||
|
ProgramAdmitStatus |
ProgramAdmitStatus |
System.String(3) | ||
|
AcademicStatusCode |
AcademicStatusCode |
System.String(3) | ||
|
AcademicStatus |
AcademicStatus |
System.String(30) | ||
|
BasisOfAdmissionCode |
BasisOfAdmissionCode |
System.String(3) | ||
|
BasisOfAdmission |
BasisOfAdmission |
System.String(30) | ||
|
EnrollmentStatusCode |
EnrollmentStatusCode |
System.String(3) | ||
|
EnrollmentStatus |
EnrollmentStatus |
System.String(30) | ||
|
AgeAtTerm |
AgeAtTerm |
System.Int16 | ||
|
AgeRangeAtTerm |
AgeRangeAtTerm |
System.String(10) | ||
|
AwardTypeCode |
AwardTypeCode |
System.String(3) | ||
|
AwardType |
AwardType |
System.String(30) | ||
|
Advised |
Advised |
System.String(3) | ||
|
AdvisementStatusCode |
AdvisementStatusCode |
System.String(3) | ||
|
AdvisementStatus |
AdvisementStatus |
System.String(30) | ||
|
AdvisementMandatory |
AdvisementMandatory |
System.String(3) | ||
|
DateLastAdvised |
DateLastAdvised |
System.DateTime | ||
|
AdvisementProgramCode |
AdvisementProgramCode |
System.String(5) | ||
|
AdvisementProgram |
AdvisementProgram |
System.String(30) | ||
|
AdvisementAwardTypeCode |
AdvisementAwardTypeCode |
System.String(3) | ||
|
AdvisementAwardType |
AdvisementAwardType |
System.String(30) | ||
|
AdvisementAdvisorId |
AdvisementAdvisorId |
System.String(8) | ||
|
AdvisementAdvisor |
AdvisementAdvisor |
System.String(50) | ||
|
TransferMajorAdvisementCode |
TransferMajorAdvisementCode |
System.String(6) | ||
|
TransferMajorAdvisement |
TransferMajorAdvisement |
System.String(30) | ||
|
TransferInstitutionAdvisementId |
TransferInstitutionAdvisementId |
System.String(8) | ||
|
TransferInstitutionAdvisement |
TransferInstitutionAdvisement |
System.String(50) | ||
|
RowIsCurrent |
RowIsCurrent |
System.String(1) | ||
|
RowStartDate |
RowStartDate |
System.DateTime | ||
|
RowEndDate |
RowEndDate |
System.DateTime | ||
|
AgeRangeSort |
System.String(13) | CASE WHEN LEFT(AgeRangeAtTerm,1) = '>' THEN 'zz1' + AgeRangeAtTerm WHEN AgeRangeAtTerm = 'N/A' THEN 'zz2' + AgeRangeAtTerm ELSE AgeRangeAtTerm END |
Sorting sequence for age range. |
|
|
SdbAwardTypeCode |
System.String(3) |
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 |
StudentTermSK |
FactApplicationStatus |
Table |
False |
||
StudentTermSK |
FactStudentTotalFeesForClass |
Table |
False |
||
StudentTermSK |
FactStudentTotalFees |
Table |
False |
||
StudentTermSK |
FactStudentFeesPaid |
Table |
False |
||
StudentTermSK |
FactStudentGraduation |
Table |
False |
||
StudentTermSK |
FactStudentGrades |
Table |
False |
||
StudentTermSK |
FactEnrollmentActivity |
Table |
False |
||
StudentTermSK |
FactEnrollmentSnapshot |
Table |
False |
||
StudentTermSK |
FactPriorEnrollmentSnapshot |
Table |
False |
||
StudentTermSK |
FactEOTEnrollmentSnapshot |
Table |
False |
||
StudentTermSK |
FactActiveEnrollmentSnapshot |
Table |
False |
| Powered by BI Documenter |
