|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimStudent |
| Database Table Name | DimStudent |
| Schema | dbo |
| Friendly Name | DimStudent |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
StudentSK |
StudentSK |
System.Int32 | ||
 |
StudentIdAK |
StudentIdAK |
System.String(9) | ||
|
StudentId |
StudentId |
System.String(9) | ||
|
FullName |
FullName |
System.String(50) | ||
|
LastName |
LastName |
System.String(50) | ||
|
FirstName |
FirstName |
System.String(30) | ||
|
MiddleName |
MiddleName |
System.String(20) | ||
|
GenderCode |
GenderCode |
System.String(3) | ||
|
Gender |
Gender |
System.String(10) | ||
|
EthnicityCode |
EthnicityCode |
System.String(3) | ||
|
Ethnicity |
Ethnicity |
System.String(30) | ||
|
FirstTimeInCollege |
FirstTimeInCollege |
System.String(3) | ||
|
PrimaryLanguageCode |
PrimaryLanguageCode |
System.String(3) | ||
|
PrimaryLanguage |
PrimaryLanguage |
System.String(30) | ||
|
HighSchoolInstitutionId |
HighSchoolInstitutionId |
System.String(8) | ||
|
HighSchool |
HighSchool |
System.String(50) | ||
|
HomePhoneNumber |
HomePhoneNumber |
System.String(25) | ||
|
CellPhoneNumber |
CellPhoneNumber |
System.String(25) | ||
|
InstitutionalEmailAddress |
InstitutionalEmailAddress |
System.String(75) | ||
|
PersonalEmailAddress |
PersonalEmailAddress |
System.String(75) | ||
|
ImmigrationStatusCode |
ImmigrationStatusCode |
System.String(3) | ||
|
ImmigrationStatus |
ImmigrationStatus |
System.String(30) | ||
|
ResidencyCode |
ResidencyCode |
System.String(3) | ||
|
Residency |
Residency |
System.String(30) | ||
|
ResidencyCountyCode |
ResidencyCountyCode |
System.String(3) | ||
|
ResidencyCounty |
ResidencyCounty |
System.String(30) | ||
|
ResidencyStateCode |
ResidencyStateCode |
System.String(3) | ||
|
ResidencyState |
ResidencyState |
System.String(30) | ||
|
ZipCode |
ZipCode |
System.String(11) | ||
|
DateOfBirth |
DateOfBirth |
System.DateTime | ||
|
FERPARequested |
FERPARequested |
System.String(3) | ||
|
RaceWhite |
RaceWhite |
System.String(3) | ||
|
RaceAfricanAmerican |
RaceAfricanAmerican |
System.String(3) | ||
|
RacePacificIslander |
RacePacificIslander |
System.String(3) | ||
|
RaceAsian |
RaceAsian |
System.String(3) | ||
|
RaceAmericanIndian |
RaceAmericanIndian |
System.String(3) | ||
|
RaceUnreported |
RaceUnreported |
System.String(3) | ||
|
CountryOfBirthCode |
CountryOfBirthCode |
System.String(3) | ||
|
CountryOfBirth |
CountryOfBirth |
System.String(30) | ||
|
CountryOfCitizenshipCode |
CountryOfCitizenshipCode |
System.String(3) | ||
|
CountryOfCitizenship |
CountryOfCitizenship |
System.String(30) | ||
|
RowIsCurrent |
RowIsCurrent |
System.String(1) | ||
|
RowStartDate |
RowStartDate |
System.DateTime | ||
|
RowEndDate |
RowEndDate |
System.DateTime | ||
|
HomeCampusCode |
System.String(3) | |||
|
HomeCampus |
System.String(50) | |||
|
InitialPrepStatus |
System.String(20) | |||
|
VeteranStudent |
System.String(3) | |||
|
StudentAthlete |
System.String(3) | |||
|
InternationalStudent |
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 |
StudentSK |
FactApplicationStatus |
Table |
False |
||
StudentSK |
FactStudentTotalFeesForClass |
Table |
False |
||
StudentSK |
FactStudentTotalFees |
Table |
False |
||
StudentSK |
FactStudentReceiptTotals |
Table |
False |
||
StudentSK |
FactStudentReceiptPayments |
Table |
False |
||
StudentSK |
FactStudentFeesPaid |
Table |
False |
||
StudentSK |
FactProgramRetentionSnapshot |
Table |
False |
||
StudentSK |
FactInstitutionalRetentionSnapshot |
Table |
False |
||
StudentSK |
FactStudentSuccess_TermSnapshot |
Table |
False |
||
StudentSK |
FactStudentSuccess_FirstYearSnapshot |
Table |
False |
||
StudentSK |
FactStudentGraduation |
Table |
False |
||
StudentSK |
FactStudentGrades |
Table |
False |
||
StudentSK |
FactEnrollmentActivity |
Table |
False |
||
StudentSK |
FactEnrollmentSnapshot |
Table |
False |
||
StudentSK |
FactPriorEnrollmentSnapshot |
Table |
False |
||
StudentSK |
FactEOTEnrollmentSnapshot |
Table |
False |
||
StudentSK |
FactActiveEnrollmentSnapshot |
Table |
False |
| Powered by BI Documenter |
