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 |