SGHE Enterprise Data Warehouse
Banner EDW Source: STUDENT_COURSE
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_TIME |
ACADEMIC_PERIOD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |
| ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME |
ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO NO |
| ACADEMIC_YEAR |
NO |
DIMENSION TABLE |
WDT_TIME |
ACADEMIC_YEAR |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |
| ACADEMIC_YEAR_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME |
ACADEMIC_YEAR_LD ACADEMIC_YEAR_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
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, TEST |
NO |
| CAMPUS |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_CAMPUS |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |
| CAMPUS_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE WDT_COURSE |
COURSE_CAMPUS_LD COURSE_CAMPUS_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO NO |
| COLLEGE |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_COLLEGE |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |
| COLLEGE_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE WDT_COURSE |
COURSE_COLLEGE_LD COURSE_COLLEGE_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO NO |
| COURSE_CREDITS |
NO |
FACT TABLE |
WFT_COURSE_REGISTRATION |
CREDITS_GENERATED |
COURSE REGISTRATION |
NO |
| COURSE_IDENTIFICATION |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_IDENTIFICATION |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |
| COURSE_LEVEL |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_LEVEL |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |
| COURSE_LEVEL_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE WDT_COURSE |
COURSE_LEVEL_LD COURSE_LEVEL_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO NO |
| COURSE_NUMBER |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_NUMBER |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |
| COURSE_REFERENCE_NUMBER |
NO |
FACT TABLE |
WFT_COURSE_REGISTRATION WFV_ACADEMIC_PROGRAM_COURSE |
COURSE_REFERENCE_NUMBER COURSE_REFERENCE_NUMBER |
COURSE REGISTRATION ACADEMIC PROGRAM COURSE |
NO NO |
| CREDITS_ATTEMPTED |
NO |
FACT TABLE |
WFT_COURSE_REGISTRATION |
CREDITS_ATTEMPTED |
COURSE REGISTRATION |
NO |
| CREDITS_EARNED |
NO |
FACT TABLE |
WFT_COURSE_REGISTRATION |
CREDITS_EARNED |
COURSE REGISTRATION |
NO |
| CREDITS_FOR_GPA |
NO |
FACT TABLE |
WFT_COURSE_REGISTRATION |
GPA_CREDITS |
COURSE REGISTRATION |
NO |
| CREDITS_GPA_CALCULATION |
NO |
|
|
|
|
|
| CREDITS_PASSED |
NO |
FACT TABLE |
WFT_COURSE_REGISTRATION |
CREDITS_PASSED |
COURSE REGISTRATION |
NO |
| DEPARTMENT |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_DEPARTMENT |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |
| DEPARTMENT_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE WDT_COURSE |
COURSE_DEPARTMENT_LD COURSE_DEPARTMENT_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO NO |
| DIVISION |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_DIVISION |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |
| DIVISION_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE WDT_COURSE |
COURSE_DIVISION_LD COURSE_DIVISION_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO NO |
| FINAL_GRADE |
NO |
DIMENSION TABLE |
WDT_REGISTRATION |
FINAL_GRADE |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |
| GRADE_TYPE |
NO |
DIMENSION TABLE |
WDT_REGISTRATION |
GRADE_TYPE |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |
| GRADE_TYPE_DESC |
NO |
DIMENSION TABLE |
WDT_REGISTRATION WDT_REGISTRATION |
GRADE_TYPE_LD GRADE_TYPE_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO 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, 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, 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, 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, TEST |
NO |
| QUALITY_POINTS |
NO |
FACT TABLE |
WFT_COURSE_REGISTRATION |
QUALITY_POINTS |
COURSE REGISTRATION |
NO |
| REGISTRATION_STATUS |
NO |
DIMENSION TABLE |
WDT_REGISTRATION |
REGISTRATION_STATUS |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |
| REGISTRATION_STATUS_DESC |
NO |
DIMENSION TABLE |
WDT_REGISTRATION WDT_REGISTRATION |
REGISTRATION_STATUS_LD REGISTRATION_STATUS_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO NO |
| SCHEDULE |
NO |
DIMENSION TABLE |
WDT_COURSE |
SCHEDULE |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |
| SCHEDULE_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE WDT_COURSE |
SCHEDULE_LD SCHEDULE_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO NO |
| SUBJECT |
NO |
DIMENSION TABLE |
WDT_COURSE |
SUBJECT |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |
| SUBJECT_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE WDT_COURSE |
SUBJECT_LD SUBJECT_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO NO |
| SUB_ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_TIME |
SUB_ACADEMIC_PERIOD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |
| SUB_ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_TIME WDT_TIME |
SUB_ACADEMIC_PERIOD_LD SUB_ACADEMIC_PERIOD_SD |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO NO |
| TITLE_LONG_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_TITLE_LONG |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |
| TITLE_SHORT_DESC |
NO |
DIMENSION TABLE |
WDT_COURSE |
COURSE_TITLE_SHORT |
ACADEMIC PROGRAM COURSE, COURSE REGISTRATION |
NO |