SGHE Enterprise Data Warehouse
Banner EDW Source: INSTITUTION_DEMOGRAPHIC
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ACCREDITATION_TYPE |
NO |
DIMENSION TABLE |
WDT_INSTITUTION |
ACCREDITATION_TYPE |
INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT |
NO |
| ACCREDITATION_TYPE_DESC |
NO |
DIMENSION TABLE |
WDT_INSTITUTION WDT_INSTITUTION |
ACCREDITATION_TYPE_LD ACCREDITATION_TYPE_SD |
INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT |
NO NO |
| APPROVED_IND |
NO |
DIMENSION TABLE |
WDT_INSTITUTION |
APPROVED_IND |
INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT |
NO |
| CALENDAR_YEAR |
NO |
DIMENSION TABLE |
WDT_INSTITUTION |
DEMOGRAPHIC_CALENDAR_YEAR |
INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT |
NO |
| ENROLLMENT |
NO |
FACT TABLE |
WFT_INSTITUTION |
ENROLLMENT |
INSTITUTION |
NO |
| MEAN_FAMILY_INCOME |
NO |
FACT TABLE |
WFT_INSTITUTION |
MEAN_FAMILY_INCOME |
INSTITUTION |
NO |
| NUMBER_OF_SENIORS |
NO |
FACT TABLE |
WFT_INSTITUTION |
NUMBER_OF_SENIORS |
INSTITUTION |
NO |
| PERCENT_COLLEGE_BOUND |
NO |
FACT TABLE |
WFT_INSTITUTION |
PERCENT_COLLEGE_BOUND |
INSTITUTION |
NO |