SGHE Enterprise Data Warehouse
Banner EDW Source: STUDENT_COURSE - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_TIME WDT_ACADEMIC_TIME |
ACADEMIC_PERIOD ACADEMIC_PERIOD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION STUDENT COURSE |
NO NO |
| ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME WDT_TIME |
ACADEMIC_PERIOD_SD ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD ACADEMIC_PERIOD_LD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION STUDENT COURSE STUDENT COURSE ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO NO NO NO |
| ACADEMIC_YEAR |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_TIME |
ACADEMIC_YEAR ACADEMIC_YEAR |
STUDENT COURSE ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO NO |
| ACADEMIC_YEAR_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME WDT_TIME |
ACADEMIC_YEAR_SD ACADEMIC_YEAR_SD ACADEMIC_YEAR_LD ACADEMIC_YEAR_LD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION STUDENT COURSE STUDENT COURSE ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO NO NO NO |
| ADMINISTRATIVE_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
ADMINISTRATIVE_GROUP |
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, STUDENT COURSE, TEST |
NO |
| CAMPUS |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_CAMPUS |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO |
| CAMPUS_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE WDT_COURSE |
COURSE_CAMPUS_SD COURSE_CAMPUS_LD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO NO |
| COLLEGE |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_COLLEGE |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO |
| COLLEGE_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE WDT_COURSE |
COURSE_COLLEGE_SD COURSE_COLLEGE_LD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO NO |
| COURSE_ATTEMPTED_IND |
NO |
DIMENSION TABLE |
WDT_REGISTRATION |
COURSE_ATTEMPTED_IND |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE |
NO |
| COURSE_CREDITS |
NO |
FACT TABLE |
WFT_STUDENT_COURSE WFT_COURSE_REGISTRATION |
COURSE_CREDITS CREDITS_GENERATED |
STUDENT COURSE COURSE REGISTRATION |
NO NO |
| COURSE_FAILED_IND |
NO |
DIMENSION TABLE |
WDT_REGISTRATION |
COURSE_FAILED_IND |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE |
NO |
| COURSE_IDENTIFICATION |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_IDENTIFICATION |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO |
| COURSE_LEVEL |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_LEVEL |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO |
| COURSE_LEVEL_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE WDT_COURSE |
COURSE_LEVEL_LD COURSE_LEVEL_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO NO |
| COURSE_NUMBER |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_NUMBER |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO |
| COURSE_PASSED_IND |
NO |
DIMENSION TABLE |
WDT_REGISTRATION |
COURSE_PASSED_IND |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE |
NO |
| COURSE_REFERENCE_NUMBER |
NO |
DIMENSION TABLE
FACT TABLE |
WDT_COURSE_REFERENCE_NUMBER WFV_ACADEMIC_PROGRAM_COURSE WFT_COURSE_REGISTRATION |
COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER |
STUDENT COURSE ACADEMIC PROGRAM COURSE COURSE REGISTRATION |
NO NO NO |
| COURSE_REGISTER_IND |
NO |
DIMENSION TABLE |
WDT_REGISTRATION |
COURSE_REGISTER_IND |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE |
NO |
| COURSE_TITLE_LONG |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_TITLE_LONG |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO |
| COURSE_TITLE_SHORT |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_TITLE_SHORT |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO |
| CREDITS_ATTEMPTED |
NO |
FACT TABLE |
WFT_COURSE_REGISTRATION WFT_STUDENT_COURSE |
CREDITS_ATTEMPTED COURSE_CREDITS_ATTEMPTED |
COURSE REGISTRATION STUDENT COURSE |
NO NO |
| CREDITS_EARNED |
NO |
FACT TABLE |
WFT_STUDENT_COURSE WFT_COURSE_REGISTRATION |
COURSE_CREDITS_EARNED CREDITS_EARNED |
STUDENT COURSE COURSE REGISTRATION |
NO NO |
| CREDITS_FOR_GPA |
NO |
FACT TABLE |
WFT_STUDENT_COURSE WFT_COURSE_REGISTRATION |
COURSE_CREDITS_FOR_GPA GPA_CREDITS |
STUDENT COURSE COURSE REGISTRATION |
NO NO |
| CREDITS_PASSED |
NO |
FACT TABLE |
WFT_COURSE_REGISTRATION WFT_STUDENT_COURSE |
CREDITS_PASSED COURSE_CREDITS_PASSED |
COURSE REGISTRATION STUDENT COURSE |
NO NO |
| DEPARTMENT |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_DEPARTMENT |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO |
| DEPARTMENT_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE WDT_COURSE |
COURSE_DEPARTMENT_LD COURSE_DEPARTMENT_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO NO |
| DIVISION |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_DIVISION |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO |
| DIVISION_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE WDT_COURSE |
COURSE_DIVISION_SD COURSE_DIVISION_LD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO NO |
| FINAL_GRADE |
NO |
DIMENSION TABLE
FACT TABLE |
WDT_REGISTRATION WFT_STUDENT_COURSE |
FINAL_GRADE FINAL_GRADE |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE STUDENT COURSE |
NO NO |
| FINAL_GRADE_DATE |
NO |
FACT TABLE |
WFT_STUDENT_COURSE |
FINAL_GRADE_DATE |
STUDENT COURSE |
NO |
| GRADE_TYPE |
NO |
DIMENSION TABLE |
WDT_REGISTRATION |
GRADE_TYPE |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE |
NO |
| GRADE_TYPE_DESC |
NO |
DIMENSION TABLE |
WDT_REGISTRATION WDT_REGISTRATION |
GRADE_TYPE_SD GRADE_TYPE_LD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE |
NO NO |
| INSTITUTION_COURSE_IND |
NO |
FACT TABLE |
WFT_STUDENT_COURSE |
INSTITUTION_COURSE_IND |
STUDENT COURSE |
NO |
| IN_PROGRESS_COURSE_IND |
NO |
FACT TABLE |
WFT_STUDENT_COURSE |
IN_PROGRESS_COURSE_IND |
STUDENT COURSE |
NO |
| MID_TERM_GRADE |
NO |
FACT TABLE |
WFT_STUDENT_COURSE |
MID_TERM_GRADE |
STUDENT COURSE |
NO |
| MULTI_SOURCE |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
MULTI_SOURCE |
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, HOLD, INSTITUTION, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, STUDENT COURSE, TEST |
NO |
| MULTI_SOURCE_DESC |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE WDT_MULTI_SOURCE |
MULTI_SOURCE_SD MULTI_SOURCE_LD |
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, HOLD, INSTITUTION, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, STUDENT COURSE, TEST ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, HOLD, INSTITUTION, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, STUDENT COURSE, TEST |
NO NO |
| PROCESS_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
PROCESS_GROUP |
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, HOLD, INSTITUTION, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, STUDENT COURSE, TEST |
NO |
| QUALITY_POINTS |
NO |
FACT TABLE |
WFT_STUDENT_COURSE WFT_COURSE_REGISTRATION |
FINAL_GRADE_QUALITY_POINTS QUALITY_POINTS |
STUDENT COURSE COURSE REGISTRATION |
NO NO |
| REGISTER_CENSUS_DATE1_IND |
NO |
DIMENSION TABLE |
WDT_REGISTRATION |
REGISTER_CENSUS_DATE1_IND |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE |
NO |
| REGISTER_CENSUS_DATE2_IND |
NO |
DIMENSION TABLE |
WDT_REGISTRATION |
REGISTER_CENSUS_DATE2_IND |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE |
NO |
| REGISTRATION_OVERRIDE_IND |
NO |
DIMENSION TABLE |
WDT_REGISTRATION |
REGISTRATION_OVERRIDE_IND |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE |
NO |
| REGISTRATION_STATUS |
NO |
DIMENSION TABLE |
WDT_REGISTRATION |
REGISTRATION_STATUS |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE |
NO |
| REGISTRATION_STATUS_DATE |
NO |
FACT TABLE |
WFT_STUDENT_COURSE |
REGISTRATION_STATUS_DATE |
STUDENT COURSE |
NO |
| REGISTRATION_STATUS_DESC |
NO |
DIMENSION TABLE |
WDT_REGISTRATION WDT_REGISTRATION |
REGISTRATION_STATUS_LD REGISTRATION_STATUS_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE |
NO NO |
| REPEAT_COURSE_IND |
NO |
FACT TABLE |
WFT_STUDENT_COURSE |
REPEAT_COURSE_IND |
STUDENT COURSE |
NO |
| SCHEDULE_TYPE |
NO |
DIMENSION TABLE |
WDT_COURSE |
SCHEDULE |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO |
| SCHEDULE_TYPE_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE WDT_COURSE |
SCHEDULE_SD SCHEDULE_LD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO NO |
| SECTION_ADD_DATE |
NO |
FACT TABLE |
WFT_STUDENT_COURSE |
INITIAL_REGISTRATION_DATE |
STUDENT COURSE |
NO |
| SPECIAL_APPROVAL_IND |
NO |
FACT TABLE |
WFT_STUDENT_COURSE |
SPECIAL_APPROVAL_IND |
STUDENT COURSE |
NO |
| SUBJECT |
NO |
DIMENSION TABLE |
WDT_COURSE |
SUBJECT |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO |
| SUBJECT_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE WDT_COURSE |
SUBJECT_LD SUBJECT_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO NO |
| SUB_ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_SUB_ACADEMIC_PERIOD WDT_TIME |
SUB_ACADEMIC_PERIOD SUB_ACADEMIC_PERIOD |
STUDENT COURSE ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO NO |
| SUB_ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME WDT_SUB_ACADEMIC_PERIOD WDT_SUB_ACADEMIC_PERIOD |
SUB_ACADEMIC_PERIOD_LD SUB_ACADEMIC_PERIOD_SD SUB_ACADEMIC_PERIOD_SD SUB_ACADEMIC_PERIOD_LD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION ACADEMIC PROGRAM COURSE, COURSE REGISTRATION STUDENT COURSE STUDENT COURSE |
NO NO NO NO |
| SYSTEM_LOAD_PROCESS |
NO |
DIMENSION TABLE |
WDT_REGISTRATION |
SYSTEM_LOAD_PROCESS |
STUDENT COURSE |
NO |
| SYSTEM_LOAD_TMSTMP |
NO |
DIMENSION TABLE |
WDT_REGISTRATION |
SYSTEM_LOAD_TMSTMP |
STUDENT COURSE |
NO |
| TRANSFER_COURSE_IND |
NO |
FACT TABLE |
WFT_STUDENT_COURSE |
TRANSFER_COURSE_IND |
STUDENT COURSE |
NO |
| WITHDRAWN_IND |
NO |
DIMENSION TABLE |
WDT_REGISTRATION |
COURSE_WITHDRAWN_IND |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, STUDENT COURSE |
NO |