SGHE Enterprise Data Warehouse
Banner EDW Source: MGKUTIL.F_GETCALENDARRECORDS - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| FISCAL_DATE |
NO |
DIMENSION TABLE |
WDT_FISCAL_DATE |
FISCAL_DATE |
ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION |
NO |
| FISCAL_MONTH_DATE |
NO |
DIMENSION TABLE |
WDT_FISCAL_DATE |
FISCAL_MONTH_DATE |
ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION |
NO |
| FISCAL_PERIOD |
NO |
DIMENSION TABLE |
WDT_FISCAL_DATE |
FISCAL_PERIOD |
ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION |
NO |
| FISCAL_PERIOD_LD |
NO |
DIMENSION TABLE |
WDT_FISCAL_DATE |
FISCAL_PERIOD_LD |
ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION |
NO |
| FISCAL_PERIOD_SD |
NO |
DIMENSION TABLE |
WDT_FISCAL_DATE |
FISCAL_PERIOD_SD |
ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION |
NO |
| FISCAL_QUARTER |
NO |
DIMENSION TABLE |
WDT_FISCAL_DATE |
FISCAL_QUARTER |
ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION |
NO |
| FISCAL_YEAR |
NO |
DIMENSION TABLE |
WDT_FISCAL_DATE |
FISCAL_YEAR |
ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION |
NO |
| FISCAL_YEAR_LD |
NO |
DIMENSION TABLE |
WDT_FISCAL_DATE |
FISCAL_YEAR_LD |
ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION |
NO |
| FISCAL_YEAR_SD |
NO |
DIMENSION TABLE |
WDT_FISCAL_DATE |
FISCAL_YEAR_SD |
ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION |
NO |
| SYSTEM_LOAD_TMSTMP |
NO |
DIMENSION TABLE |
WDT_FISCAL_DATE |
SYSTEM_LOAD_TMSTMP |
ANALYZE FUNDRAISING, MANAGE PROSPECT PIPELINE, MANAGE PROSPECT PIPELINE A, MANAGE PROSPECT PIPELINE B, RQPP ENTITY, RQPP YEARLY DES COLL, RQPP YEARLY DES DEPT, RQPP YEARLY INSTITUTION |
NO |