SGHE Enterprise Data Warehouse
Banner EDW Source: INSTITUTION_CHARACTERISTIC - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| DECODE(INST_CHARACTERISTIC, FOUR_YEAR_REC.MTVPARM_EXTERNAL_CODE, 1, 0) |
NO |
DIMENSION TABLE |
WDT_INSTITUTION |
FOUR_YEAR_INSTITUTION_IND |
STUDENT PROGRESS |
NO |
| DECODE(INST_CHARACTERISTIC, HOMESCHOOL_REC.MTVPARM_EXTERNAL_CODE, 1, 0) |
NO |
DIMENSION TABLE |
WDT_INSTITUTION |
HOMESCHOOL_IND |
STUDENT PROGRESS |
NO |
| DECODE(INST_CHARACTERISTIC, PRIVATE_REC.MTVPARM_EXTERNAL_CODE, 1, 0) |
NO |
DIMENSION TABLE |
WDT_INSTITUTION |
PRIVATE_INSTITUTION_IND |
STUDENT PROGRESS |
NO |
| DECODE(INST_CHARACTERISTIC, PUBLIC_REC.MTVPARM_EXTERNAL_CODE, 1, 0) |
NO |
DIMENSION TABLE |
WDT_INSTITUTION |
PUBLIC_INSTITUTION_IND |
STUDENT PROGRESS |
NO |
| DECODE(INST_CHARACTERISTIC, TWO_YEAR_REC.MTVPARM_EXTERNAL_CODE, 1, 0)) |
NO |
DIMENSION TABLE |
WDT_INSTITUTION |
TWO_YEAR_INSTITUTION_IND |
STUDENT PROGRESS |
NO |