SGHE Enterprise Data Warehouse
Banner EDW Source: FACULTY_FEEDBACK_DETAIL - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ACADEMIC_PERIOD |
NO |
|
|
|
|
|
| ACADEMIC_PERIOD_DESC |
NO |
|
|
|
|
|
| ACADEMIC_YEAR |
NO |
|
|
|
|
|
| ACADEMIC_YEAR_DESC |
NO |
|
|
|
|
|
| ADMINISTRATIVE_GROUP |
NO |
|
|
|
|
|
| COURSE_IDENTIFICATION |
NO |
|
|
|
|
|
| COURSE_NUMBER |
NO |
|
|
|
|
|
| COURSE_REFERENCE_NUMBER |
NO |
|
|
|
|
|
| COURSE_SECTION_NUMBER |
NO |
|
|
|
|
|
| FACULTY_FEEDBACK_ACTIVE_IND |
NO |
|
|
|
|
|
| FEEDBACK |
NO |
DIMENSION TABLE |
WDT_FEEDBACK |
FEEDBACK |
FEEDBACK |
NO |
| FEEDBACK_ACTIVITY_DATE |
NO |
FACT TABLE |
WFT_FEEDBACK |
LATEST_FEEDBACK_DATE |
FEEDBACK |
NO |
| FEEDBACK_COMMENT_IND |
NO |
|
|
|
|
|
| FEEDBACK_DATA_ORIGIN |
NO |
|
|
|
|
|
| FEEDBACK_DESC |
NO |
DIMENSION TABLE |
WDT_FEEDBACK WDT_FEEDBACK |
FEEDBACK_SD FEEDBACK_LD |
FEEDBACK FEEDBACK |
NO NO |
| FEEDBACK_ESTIMATED_GRADE_IND |
NO |
|
|
|
|
|
| FEEDBACK_KEY |
NO |
|
|
|
|
|
| FEEDBACK_SESSION_DESC |
NO |
|
|
|
|
|
| FEEDBACK_SESSION_KEY |
NO |
|
|
|
|
|
| FEEDBACK_TYPE |
NO |
DIMENSION TABLE |
WDT_FEEDBACK |
FEEDBACK_TYPE |
FEEDBACK |
NO |
| FEEDBACK_TYPE_DESC |
NO |
DIMENSION TABLE |
WDT_FEEDBACK WDT_FEEDBACK |
FEEDBACK_TYPE_LD FEEDBACK_TYPE_SD |
FEEDBACK FEEDBACK |
NO NO |
| FEEDBACK_USER |
NO |
|
|
|
|
|
| FEEDBACK_VERSION |
NO |
|
|
|
|
|
| ID |
NO |
|
|
|
|
|
| INSTRUCTOR_ID |
NO |
|
|
|
|
|
| INSTRUCTOR_NAME |
NO |
|
|
|
|
|
| INSTUCTOR_UID |
NO |
|
|
|
|
|
| MULTI_SOURCE |
NO |
|
|
|
|
|
| MULTI_SOURCE_DESC |
NO |
|
|
|
|
|
| NAME |
NO |
|
|
|
|
|
| PERSON_FEEDBACK_KEY |
NO |
|
|
|
|
|
| PERSON_UID |
NO |
|
|
|
|
|
| PROCESS_GROUP |
NO |
|
|
|
|
|
| STUDENT_MONITOR_IND |
NO |
|
|
|
|
|
| SUBJECT |
NO |
|
|
|
|
|
| SUBJECT_DESC |
NO |
|
|
|
|
|
| SUB_ACADEMIC_PERIOD |
NO |
|
|
|
|
|
| SUB_ACADEMIC_PERIOD_DESC |
NO |
|
|
|
|
|