SGHE Enterprise Data Warehouse
Banner EDW Source: COMMUNICATION - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| ACADEMIC_PERIOD |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME |
ACADEMIC_PERIOD |
BANNER COMMUNICATION |
NO |
| ACADEMIC_PERIOD_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME |
ACADEMIC_PERIOD_LD ACADEMIC_PERIOD_SD |
BANNER COMMUNICATION BANNER COMMUNICATION |
NO NO |
| ACADEMIC_YEAR |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME |
ACADEMIC_YEAR |
BANNER COMMUNICATION |
NO |
| ACADEMIC_YEAR_DESC |
NO |
DIMENSION TABLE |
WDT_ACADEMIC_TIME WDT_ACADEMIC_TIME |
ACADEMIC_YEAR_SD ACADEMIC_YEAR_LD |
BANNER COMMUNICATION BANNER COMMUNICATION |
NO NO |
| ADMINISTRATIVE_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
ADMINISTRATIVE_GROUP |
BANNER COMMUNICATION |
NO |
| COMMUNICATION |
NO |
DIMENSION TABLE |
WDT_BANNER_COMMUNICATION |
COMMUNICATION |
BANNER COMMUNICATION, STUDENT PROGRESS |
NO |
| COMMUNICATION_DESC |
NO |
DIMENSION TABLE |
WDT_BANNER_COMMUNICATION WDT_BANNER_COMMUNICATION |
COMMUNICATION_LD COMMUNICATION_SD |
BANNER COMMUNICATION, STUDENT PROGRESS BANNER COMMUNICATION, STUDENT PROGRESS |
NO NO |
| COMMUNICATION_PLAN |
NO |
DIMENSION TABLE |
WDT_BANNER_COMMUNICATION |
COMMUNICATION_PLAN |
BANNER COMMUNICATION, STUDENT PROGRESS |
NO |
| COMMUNICATION_PLAN_DESC |
NO |
DIMENSION TABLE |
WDT_BANNER_COMMUNICATION WDT_BANNER_COMMUNICATION |
COMMUNICATION_PLAN_SD COMMUNICATION_PLAN_LD |
BANNER COMMUNICATION, STUDENT PROGRESS BANNER COMMUNICATION, STUDENT PROGRESS |
NO NO |
| COMMUNICATION_SOURCE |
NO |
DIMENSION TABLE |
WDT_BANNER_COMMUNICATION |
COMMUNICATION_SOURCE |
BANNER COMMUNICATION, STUDENT PROGRESS |
NO |
| COMMUNICATION_SOURCE_DESC |
NO |
DIMENSION TABLE |
WDT_BANNER_COMMUNICATION WDT_BANNER_COMMUNICATION |
COMMUNICATION_SOURCE_SD COMMUNICATION_SOURCE_LD |
BANNER COMMUNICATION, STUDENT PROGRESS BANNER COMMUNICATION, STUDENT PROGRESS |
NO NO |
| COMMUNICATION_TYPE |
NO |
DIMENSION TABLE |
WDT_BANNER_COMMUNICATION |
COMMUNICATION_TYPE |
BANNER COMMUNICATION, STUDENT PROGRESS |
NO |
| COMMUNICATION_TYPE_DESC |
NO |
DIMENSION TABLE |
WDT_BANNER_COMMUNICATION WDT_BANNER_COMMUNICATION |
COMMUNICATION_TYPE_SD COMMUNICATION_TYPE_LD |
BANNER COMMUNICATION, STUDENT PROGRESS BANNER COMMUNICATION, STUDENT PROGRESS |
NO NO |
| MATERIAL |
NO |
DIMENSION TABLE |
WDT_BANNER_COMMUNICATION |
MATERIAL |
BANNER COMMUNICATION, STUDENT PROGRESS |
NO |
| MATERIAL_DESC |
NO |
DIMENSION TABLE |
WDT_BANNER_COMMUNICATION WDT_BANNER_COMMUNICATION |
MATERIAL_LD MATERIAL_SD |
BANNER COMMUNICATION, STUDENT PROGRESS BANNER COMMUNICATION, STUDENT PROGRESS |
NO NO |
| MULTI_SOURCE |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
MULTI_SOURCE |
BANNER COMMUNICATION |
NO |
| MULTI_SOURCE_DESC |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE WDT_MULTI_SOURCE |
MULTI_SOURCE_LD MULTI_SOURCE_SD |
BANNER COMMUNICATION BANNER COMMUNICATION |
NO NO |
| PERSON_UID |
NO |
DIMENSION TABLE
FACT TABLE |
WDT_PERSON WFT_BANNER_COMMUNICATION |
PERSON_UID PERSON_UID |
BANNER COMMUNICATION BANNER COMMUNICATION |
NO NO |
| PROCESS_GROUP |
NO |
DIMENSION TABLE |
WDT_MULTI_SOURCE |
PROCESS_GROUP |
BANNER COMMUNICATION |
NO |