SGHE Enterprise Data Warehouse
Banner EDW Source: ENROLLMENT
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ACADEMIC_OUTCOME_ENROLLED_IND |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS |
ACADEMIC_OUTCOME_ENROLLED_IND |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT |
NO |
| ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_TIME |
ACADEMIC_PERIOD |
ENROLLMENT |
NO |
| ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME |
ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD |
ENROLLMENT ENROLLMENT |
NO NO |
| ACADEMIC_YEAR |
NO |
DIMENSION TABLE |
WDT_TIME |
ACADEMIC_YEAR |
ENROLLMENT |
NO |
| ACADEMIC_YEAR_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME |
ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD |
ENROLLMENT ENROLLMENT |
NO NO |
| ACTIVE_ACADEMIC_PERIODS |
NO |
FACT TABLE |
WFT_GRADUATION_COMPLETION |
ACTIVE_ACADEMIC_PERIODS |
GRADUATION COMPLETION |
NO |
| ADMINISTRATIVE_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
ADMINISTRATIVE_GROUP |
ENROLLMENT |
NO |
| CURRENT_TIME_STATUS |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS WDT_GRADUATION |
CURRENT_TIME_STATUS COMPLETION_TIME_STATUS |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT GRADUATION COMPLETION |
NO NO |
| CURRENT_TIME_STATUS_DESC |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS WDT_ENROLLMENT_STATUS WDT_GRADUATION WDT_GRADUATION |
CURRENT_TIME_STATUS_LD CURRENT_TIME_STATUS_SD COMPLETION_TIME_STATUS_LD COMPLETION_TIME_STATUS_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT GRADUATION COMPLETION GRADUATION COMPLETION |
NO NO NO NO |
| ENROLLED_IND |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS |
ENROLLED_IND |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT |
NO |
| ENROLLMENT_STATUS |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS |
ENROLLMENT_STATUS |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT |
NO |
| ENROLLMENT_STATUS_DESC |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS WDT_ENROLLMENT_STATUS |
ENROLLMENT_STATUS_LD ENROLLMENT_STATUS_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT |
NO NO |
| MULTI_SOURCE |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
MULTI_SOURCE |
ENROLLMENT |
NO |
| MULTI_SOURCE_DESC |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE WDT_MULTI_SOURCE |
MULTI_SOURCE_LD MULTI_SOURCE_SD |
ENROLLMENT ENROLLMENT |
NO NO |
| PROCESS_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
PROCESS_GROUP |
ENROLLMENT |
NO |
| REGISTERED_IND |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS |
REGISTERED_IND |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT |
NO |
| SUB_ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_TIME |
SUB_ACADEMIC_PERIOD |
ENROLLMENT |
NO |
| SUB_ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME |
SUB_ACADEMIC_PERIOD_SD SUB_ACADEMIC_PERIOD_LD |
ENROLLMENT, GENERAL LEDGER ENROLLMENT |
NO NO |