SGHE Enterprise Data Warehouse
Banner EDW Source: FUND_HIERARCHY - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| FUND_DESC_1 |
NO |
DIMENSION TABLE |
WDT_FUND WDT_FUND |
FUND_LEVEL_1_LD FUND_LEVEL_1_SD |
RECEIVABLE REVENUE RECEIVABLE REVENUE |
NO NO |
| FUND_DESC_2 |
NO |
DIMENSION TABLE |
WDT_FUND WDT_FUND |
FUND_LEVEL_2_LD FUND_LEVEL_2_SD |
RECEIVABLE REVENUE RECEIVABLE REVENUE |
NO NO |
| FUND_DESC_3 |
NO |
DIMENSION TABLE |
WDT_FUND WDT_FUND |
FUND_LEVEL_3_SD FUND_LEVEL_3_LD |
RECEIVABLE REVENUE RECEIVABLE REVENUE |
NO NO |
| FUND_DESC_4 |
NO |
DIMENSION TABLE |
WDT_FUND WDT_FUND |
FUND_LEVEL_4_LD FUND_LEVEL_4_SD |
RECEIVABLE REVENUE RECEIVABLE REVENUE |
NO NO |
| FUND_DESC_5 |
NO |
DIMENSION TABLE |
WDT_FUND WDT_FUND |
FUND_LEVEL_5_LD FUND_LEVEL_5_SD |
RECEIVABLE REVENUE RECEIVABLE REVENUE |
NO NO |
| FUND_LEVEL_1 |
NO |
DIMENSION TABLE |
WDT_FUND |
FUND_LEVEL_1 |
RECEIVABLE REVENUE |
NO |
| FUND_LEVEL_2 |
NO |
DIMENSION TABLE |
WDT_FUND |
FUND_LEVEL_2 |
RECEIVABLE REVENUE |
NO |
| FUND_LEVEL_3 |
NO |
DIMENSION TABLE |
WDT_FUND |
FUND_LEVEL_3 |
RECEIVABLE REVENUE |
NO |
| FUND_LEVEL_4 |
NO |
DIMENSION TABLE |
WDT_FUND |
FUND_LEVEL_4 |
RECEIVABLE REVENUE |
NO |
| FUND_LEVEL_5 |
NO |
DIMENSION TABLE |
WDT_FUND |
FUND_LEVEL_5 |
RECEIVABLE REVENUE |
NO |
| FUND_POOL |
NO |
DIMENSION TABLE |
WDT_FUND |
FUND_POOL |
GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE |
NO |
| FUND_POOL_DESC |
NO |
DIMENSION TABLE |
WDT_FUND WDT_FUND |
FUND_POOL_LD FUND_POOL_SD |
GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE |
NO NO |
| FUND_TYPE |
NO |
DIMENSION TABLE |
WDT_FUND |
FUND_TYPE |
GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE |
NO |
| FUND_TYPE_DESC |
NO |
DIMENSION TABLE |
WDT_FUND WDT_FUND |
FUND_TYPE_LD FUND_TYPE_SD |
GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE |
NO NO |
| FUND_TYPE_DESC_1 |
NO |
DIMENSION TABLE |
WDT_FUND WDT_FUND |
FUND_TYPE_LEVEL_1_SD FUND_TYPE_LEVEL_1_LD |
RECEIVABLE REVENUE RECEIVABLE REVENUE |
NO NO |
| FUND_TYPE_DESC_2 |
NO |
DIMENSION TABLE |
WDT_FUND WDT_FUND |
FUND_TYPE_LEVEL_2_SD FUND_TYPE_LEVEL_2_LD |
RECEIVABLE REVENUE RECEIVABLE REVENUE |
NO NO |
| FUND_TYPE_LEVEL_1 |
NO |
DIMENSION TABLE |
WDT_FUND |
FUND_TYPE_LEVEL_1 |
RECEIVABLE REVENUE |
NO |
| FUND_TYPE_LEVEL_2 |
NO |
DIMENSION TABLE |
WDT_FUND |
FUND_TYPE_LEVEL_2 |
RECEIVABLE REVENUE |
NO |