SGHE Enterprise Data Warehouse
Banner EDW Source: ADDRESS - NULL
Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
CITY |
NO |
DIMENSION TABLE |
WDT_POSTAL |
CITY |
ADVANCEMENT GIFT, ENROLLMENT, GRADUATION COMPLETION, PROSPECTIVE STUDENT, STUDENT, STUDENT PROGRESS |
NO |
COUNTY |
NO |
DIMENSION TABLE |
WDT_POSTAL WDT_POSTAL |
COUNTY COUNTY_SD |
ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ENROLLMENT, GRADUATION COMPLETION, PROSPECTIVE STUDENT, STUDENT, STUDENT PROGRESS GRADUATION COMPLETION |
NO NO |
COUNTY_DESC |
NO |
DIMENSION TABLE |
WDT_POSTAL WDT_POSTAL |
COUNTY_SD COUNTY_LD |
ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ENROLLMENT, PROSPECTIVE STUDENT, STUDENT, STUDENT PROGRESS ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ENROLLMENT, GRADUATION COMPLETION, PROSPECTIVE STUDENT, STUDENT, STUDENT PROGRESS |
NO NO |
NATION |
NO |
DIMENSION TABLE |
WDT_POSTAL |
NATION |
ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ENROLLMENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS |
NO |
NATION_DESC |
NO |
DIMENSION TABLE |
WDT_POSTAL WDT_POSTAL |
NATION_LD NATION_SD |
ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ENROLLMENT, GRADUATION COMPLETION, PROSPECTIVE STUDENT, STUDENT, STUDENT PROGRESS ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ENROLLMENT, GRADUATION COMPLETION, PROSPECTIVE STUDENT, STUDENT, STUDENT PROGRESS |
NO NO |
POSTAL_CODE |
NO |
DIMENSION TABLE |
WDT_POSTAL |
POSTAL_CODE |
ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ENROLLMENT, GRADUATION COMPLETION, PROSPECTIVE STUDENT, STUDENT, STUDENT PROGRESS |
NO |
STATE_PROVINCE |
NO |
DIMENSION TABLE |
WDT_POSTAL |
STATE_PROVINCE |
ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, ENROLLMENT, GRADUATION COMPLETION, PROSPECTIVE STUDENT, STUDENT, STUDENT PROGRESS |
NO |
STATE_PROVINCE_DESC |
NO |
DIMENSION TABLE |
WDT_POSTAL WDT_POSTAL |
STATE_PROVINCE_LD STATE_PROVINCE_SD |
ADVANCEMENT GIFT, ENROLLMENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS ADVANCEMENT GIFT, ENROLLMENT, GRADUATION COMPLETION, STUDENT, STUDENT PROGRESS |
NO NO |
STREET_LINE1 |
NO |
DIMENSION TABLE |
WDT_STREET_ADDRESS |
STREET_LINE1 |
PROSPECTIVE STUDENT, STUDENT, STUDENT PROGRESS |
NO |
STREET_LINE2 |
NO |
DIMENSION TABLE |
WDT_STREET_ADDRESS |
STREET_LINE2 |
PROSPECTIVE STUDENT, STUDENT, STUDENT PROGRESS |
NO |
STREET_LINE3 |
NO |
DIMENSION TABLE |
WDT_STREET_ADDRESS |
STREET_LINE3 |
PROSPECTIVE STUDENT, STUDENT, STUDENT PROGRESS |
NO |
STREET_LINE4 |
NO |
DIMENSION TABLE |
WDT_STREET_ADDRESS |
STREET_LINE4 |
PROSPECTIVE STUDENT, STUDENT, STUDENT PROGRESS |
NO |