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_ACADEMIC_TIME WDT_TIME |
ACADEMIC_PERIOD ACADEMIC_PERIOD |
ENROLLMENT ENROLLMENT |
NO NO |
| ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME WDT_TIME WDT_TIME |
ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD |
ENROLLMENT ENROLLMENT ENROLLMENT ENROLLMENT |
NO NO 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_LD ACADEMIC_YEAR_SD |
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_SD COMPLETION_TIME_STATUS_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 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_ENROLLMENT_STATUS WDT_RETENTION_MULTI_YEAR WDT_RETENTION_MULTI_YEAR WDT_RETENTION_MULTI_YEAR WDT_PRE_STUDENT_STATUS WDT_STUDENT_STATUS WDT_RETENTION_MULTI_YEAR WDT_RETENTION_MULTI_YEAR WDT_RETENTION_MULTI_YEAR |
YEAR2_RETAINED_IND ENROLLED_IND YEAR8_RETAINED_IND YEAR3_RETAINED_IND YEAR6_RETAINED_IND ENROLLED_IND ENROLLED_IND YEAR4_RETAINED_IND YEAR5_RETAINED_IND YEAR7_RETAINED_IND |
RETENTION MULTI YEAR, STUDENT PROGRESS ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, ENROLLMENT, FINANCIAL AID STUDENT, STUDENT, STUDENT PROGRESS RETENTION MULTI YEAR, STUDENT PROGRESS RETENTION MULTI YEAR, STUDENT PROGRESS RETENTION MULTI YEAR, STUDENT PROGRESS STUDENT, STUDENT PROGRESS STUDENT, 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_SD MULTI_SOURCE_LD |
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_LD REGISTRATION_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 |
| 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_LD SUB_ACADEMIC_PERIOD_SD |
ENROLLMENT 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_SD WITHDRAWAL_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 |
| WITHDRAWN_IND |
NO |
DIMENSION TABLE |
WDT_STUDENT_STATUS |
WITHDRAWN_IND |
STUDENT, STUDENT PROGRESS |
NO |