SGHE Enterprise Data Warehouse
Banner EDW Source: ENROLLMENT - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ACADEMIC_HISTORY_EXISTS_IND |
NO |
DIMENSION TABLE |
WDT_STUDENT_STATUS |
ACAD_HISTORY_EXISTS_IND |
STUDENT, STUDENT PROGRESS |
NO |
| 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_STANDING_END |
NO |
DIMENSION TABLE |
WDT_STUDENT_PERFORMANCE |
ACADEMIC_STANDING_END |
STUDENT, STUDENT PROGRESS |
NO |
| ACADEMIC_STANDING_END_DESC |
NO |
DIMENSION TABLE |
WDT_STUDENT_PERFORMANCE WDT_STUDENT_PERFORMANCE |
ACADEMIC_STANDING_END_LD ACADEMIC_STANDING_END_SD |
STUDENT, STUDENT PROGRESS STUDENT, STUDENT PROGRESS |
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_SD ACADEMIC_YEAR_LD |
ENROLLMENT ENROLLMENT |
NO 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, STUDENT, STUDENT PROGRESS GRADUATION COMPLETION |
NO NO |
| CURRENT_TIME_STATUS_DATE |
NO |
FACT TABLE |
WFT_STUDENT |
CURRENT_TIME_STATUS_DATE |
STUDENT |
NO |
| CURRENT_TIME_STATUS_DESC |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS WDT_ENROLLMENT_STATUS WDT_GRADUATION WDT_GRADUATION |
CURRENT_TIME_STATUS_SD CURRENT_TIME_STATUS_LD COMPLETION_TIME_STATUS_LD COMPLETION_TIME_STATUS_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS GRADUATION COMPLETION GRADUATION COMPLETION |
NO NO NO NO |
| DEPOSIT_IND |
NO |
DIMENSION TABLE |
WDT_PRE_STUDENT_STATUS |
TUITION_DEPOSITED_IND |
STUDENT, STUDENT PROGRESS |
NO |
| ENROLLED_IND |
NO |
DIMENSION TABLE |
WDT_RETENTION_MULTI_YEAR WDT_RETENTION_MULTI_YEAR WDT_ENROLLMENT_STATUS WDT_STUDENT_STATUS WDT_RETENTION_MULTI_YEAR WDT_PRE_STUDENT_STATUS WDT_RETENTION_MULTI_YEAR WDT_RETENTION_MULTI_YEAR WDT_RETENTION_MULTI_YEAR WDT_RETENTION_MULTI_YEAR |
YEAR4_RETAINED_IND YEAR8_RETAINED_IND ENROLLED_IND ENROLLED_IND YEAR5_RETAINED_IND ENROLLED_IND YEAR3_RETAINED_IND YEAR2_RETAINED_IND YEAR6_RETAINED_IND YEAR7_RETAINED_IND |
RETENTION MULTI YEAR, STUDENT PROGRESS RETENTION MULTI YEAR, STUDENT PROGRESS ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS STUDENT, STUDENT PROGRESS RETENTION MULTI YEAR, STUDENT PROGRESS STUDENT, STUDENT PROGRESS RETENTION MULTI YEAR, STUDENT PROGRESS RETENTION MULTI YEAR, STUDENT PROGRESS RETENTION MULTI YEAR, STUDENT PROGRESS RETENTION MULTI YEAR, STUDENT PROGRESS |
NO NO NO NO NO NO NO NO NO NO |
| ENROLLMENT_ADD_DATE |
NO |
FACT TABLE |
WFT_STUDENT |
INITIAL_ENROLL_STATUS_DATE |
STUDENT |
NO |
| ENROLLMENT_STATUS |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS |
ENROLLMENT_STATUS |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS |
NO |
| ENROLLMENT_STATUS_DATE |
NO |
FACT TABLE |
WFT_STUDENT |
ENROLLMENT_STATUS_DATE |
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, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS |
NO NO |
| ENROLL_CENSUS_DATE1_IND |
NO |
DIMENSION TABLE |
WDT_STUDENT_STATUS |
ENROLL_BY_CENSUS_DATE1_IND |
STUDENT, STUDENT PROGRESS |
NO |
| ENROLL_CENSUS_DATE2_IND |
NO |
DIMENSION TABLE |
WDT_STUDENT_STATUS |
ENROLL_BY_CENSUS_DATE2_IND |
STUDENT, STUDENT PROGRESS |
NO |
| HOUSING_IND |
NO |
DIMENSION TABLE |
WDT_STUDENT |
HOUSING_IND |
STUDENT, STUDENT PROGRESS |
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, STUDENT, STUDENT PROGRESS |
NO |
| REGISTRATION_REASON |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS |
REGISTRATION_REASON |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS |
NO |
| REGISTRATION_REASON_DESC |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS WDT_ENROLLMENT_STATUS |
REGISTRATION_REASON_SD REGISTRATION_REASON_LD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS |
NO 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 |
| TRANSFER_TO_INSTITUTION |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS |
INSTITUTION_ATTENDING |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS |
NO |
| TRANSFER_TO_INSTITUTION_DESC |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS WDT_ENROLLMENT_STATUS |
INSTITUTION_ATTENDING_SD INSTITUTION_ATTENDING_LD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS |
NO NO |
| WITHDRAWAL_REASON |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS |
WITHDRAWAL_REASON |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS |
NO |
| WITHDRAWAL_REASON_DESC |
NO |
DIMENSION TABLE |
WDT_ENROLLMENT_STATUS WDT_ENROLLMENT_STATUS |
WITHDRAWAL_REASON_LD WITHDRAWAL_REASON_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS |
NO NO |
| WITHDRAWN_IND |
NO |
DIMENSION TABLE |
WDT_STUDENT_STATUS |
WITHDRAWN_IND |
STUDENT, STUDENT PROGRESS |
NO |