SGHE Enterprise Data Warehouse
Banner EDW Source: STUDENT
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| EDUCATION_GOAL |
NO |
DIMENSION TABLE |
WDT_STUDENT |
EDUCATION_GOAL |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION |
NO |
| EDUCATION_GOAL_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT |
EDUCATION_GOAL_LD EDUCATION_GOAL_SD |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION |
NO NO |
| EDUCATION_LEVEL |
NO |
DIMENSION TABLE |
WDT_STUDENT |
EDUCATION_LEVEL |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION |
NO |
| EDUCATION_LEVEL_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT |
EDUCATION_LEVEL_LD EDUCATION_LEVEL_SD |
COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION |
NO NO |
| HOUSING_IND |
NO |
DIMENSION TABLE |
WDT_STUDENT |
HOUSING_IND |
ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION |
NO |
| RESIDENCY |
NO |
DIMENSION TABLE |
WDT_STUDENT |
RESIDENCY |
ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION |
NO |
| RESIDENCY_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT WDT_STUDENT |
RESIDENCY_LD RESIDENCY_SD |
ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION |
NO NO |
| RESIDENCY_IND |
NO |
DIMENSION TABLE |
WDT_STUDENT |
RESIDENCY_IND |
ADMISSIONS RECRUITMENT, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION |
NO |
| TOTAL_BILLING |
NO |
FACT TABLE |
WFT_ENROLLMENT |
TOTAL_BILLING |
ENROLLMENT |
NO |
| TOTAL_CEU_BILLING |
NO |
FACT TABLE |
WFT_ENROLLMENT |
TOTAL_CEU_BILLING |
ENROLLMENT |
NO |
| TOTAL_CEU_CREDITS |
NO |
FACT TABLE |
WFT_ENROLLMENT |
TOTAL_CEU |
ENROLLMENT |
NO |
| TOTAL_CREDITS |
NO |
FACT TABLE |
WFT_ENROLLMENT |
TOTAL_CREDITS_GENERATED |
ENROLLMENT |
NO |