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_TIME WDT_ACADEMIC_TIME |
ACADEMIC_YEAR ACADEMIC_YEAR |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION STUDENT COURSE |
NO NO |
| ACADEMIC_YEAR_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_TIME WDT_ACADEMIC_TIME WDT_TIME |
ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD ACADEMIC_YEAR_SD ACADEMIC_YEAR_LD |
STUDENT COURSE ACADEMIC PROGRAM COURSE, COURSE REGISTRATION 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, HOLD, INSTITUTION, 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_LD COURSE_CAMPUS_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 |
| COLLEGE |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_COLLEGE |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO |
| COLLEGE |
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_IDENTIFICATION |
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 |
NO |
|
|
|
|
|
| COURSE_LEVEL_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE WDT_COURSE |
COURSE_LEVEL_SD COURSE_LEVEL_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_LEVEL_DESC |
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_NUMBER |
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_LONG |
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 |
| COURSE_TITLE_SHORT |
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_COURSE_REGISTRATION WFT_STUDENT_COURSE |
CREDITS_EARNED COURSE_CREDITS_EARNED |
COURSE REGISTRATION STUDENT COURSE |
NO NO |
| CREDITS_FOR_GPA |
NO |
FACT TABLE |
WFT_COURSE_REGISTRATION WFT_STUDENT_COURSE |
GPA_CREDITS COURSE_CREDITS_FOR_GPA |
COURSE REGISTRATION STUDENT COURSE |
NO NO |
| CREDITS_PASSED |
NO |
FACT TABLE |
WFT_STUDENT_COURSE WFT_COURSE_REGISTRATION |
COURSE_CREDITS_PASSED CREDITS_PASSED |
STUDENT COURSE COURSE REGISTRATION |
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 |
NO |
|
|
|
|
|
| DEPARTMENT_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE WDT_COURSE |
COURSE_DEPARTMENT_SD COURSE_DEPARTMENT_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 |
| DIVISION |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_DIVISION |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE |
NO |
| DIVISION |
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_LD GRADE_TYPE_SD |
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_LD MULTI_SOURCE_SD |
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 |
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 |
| SUBJECT_DESC |
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_SUB_ACADEMIC_PERIOD WDT_TIME WDT_SUB_ACADEMIC_PERIOD WDT_TIME |
SUB_ACADEMIC_PERIOD_LD SUB_ACADEMIC_PERIOD_LD SUB_ACADEMIC_PERIOD_SD SUB_ACADEMIC_PERIOD_SD |
STUDENT COURSE ACADEMIC PROGRAM COURSE, COURSE REGISTRATION STUDENT COURSE ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO NO NO NO |
| SUB_ACADEMIC_PERIOD_DESC |
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 |