SGHE Enterprise Data Warehouse
Banner EDW Source: INSTITUTION
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| CITY |
NO |
DIMENSION TABLE |
WDT_POSTAL |
CITY |
INSTITUTION |
NO |
| COUNTY |
NO |
DIMENSION TABLE |
WDT_POSTAL |
COUNTY |
INSTITUTION |
NO |
| COUNTY_DESC |
NO |
DIMENSION TABLE |
WDT_POSTAL WDT_POSTAL |
COUNTY_LD COUNTY_SD |
INSTITUTION INSTITUTION |
NO NO |
| FICE_CODE |
NO |
DIMENSION TABLE |
WDT_INSTITUTION |
FICE_CODE |
INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT |
NO |
| INSTITUTION |
NO |
DIMENSION TABLE |
WDT_INSTITUTION |
INSTITUTION |
INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT |
NO |
| INSTITUTION_TYPE |
NO |
DIMENSION TABLE |
WDT_INSTITUTION |
INSTITUTION_TYPE |
INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT |
NO |
| INSTITUTION_TYPE_DESC |
NO |
DIMENSION TABLE |
WDT_INSTITUTION WDT_INSTITUTION |
INSTITUTION_TYPE_LD INSTITUTION_TYPE_SD |
INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT |
NO NO |
| NAME |
NO |
DIMENSION TABLE |
WDT_INSTITUTION WDT_INSTITUTION |
INSTITUTION_LD INSTITUTION_SD |
INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT INSTITUTION, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, SECONDARY SCHOOL SUBJECT |
NO NO |
| NATION |
NO |
|
|
|
|
|
| NATION_DESC |
NO |
DIMENSION TABLE |
WDT_POSTAL WDT_POSTAL |
NATION_LD NATION_SD |
INSTITUTION INSTITUTION |
NO NO |
| POSTAL_CODE |
NO |
DIMENSION TABLE |
WDT_POSTAL |
POSTAL_CODE |
INSTITUTION |
NO |
| STATE_PROVINCE |
NO |
DIMENSION TABLE |
WDT_POSTAL |
STATE_PROVINCE |
INSTITUTION |
NO |
| STREET_LINE1 |
NO |
DIMENSION TABLE |
WDT_STREET_ADDRESS |
STREET_LINE1 |
INSTITUTION, PROSPECTIVE STUDENT |
NO |
| STREET_LINE2 |
NO |
DIMENSION TABLE |
WDT_STREET_ADDRESS |
STREET_LINE2 |
INSTITUTION, PROSPECTIVE STUDENT |
NO |
| STREET_LINE3 |
NO |
DIMENSION TABLE |
WDT_STREET_ADDRESS |
STREET_LINE3 |
INSTITUTION, PROSPECTIVE STUDENT |
NO |
| STREET_LINE4 |
NO |
DIMENSION TABLE |
WDT_STREET_ADDRESS |
STREET_LINE4 |
INSTITUTION, PROSPECTIVE STUDENT |
NO |