SGHE Enterprise Data Warehouse
Banner EDW Source: AGBPLDG - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| AGBPLDG_ACTIVITY_DATE |
NO |
REPORTING VIEW |
PLEDGE_TRANSACTION |
ACTIVITY_DATE |
NA |
NO |
| AGBPLDG_ADJ_IND |
NO |
REPORTING VIEW |
PLEDGE_TRANSACTION PLEDGE |
PLEDGE_ADJUSTMENT_IND PLEDGE_ADJUSTMENT_IND |
NA NA |
NO NO |
| AGBPLDG_AMT_PLEDGED |
NO |
REPORTING VIEW |
PLEDGE_TRANSACTION |
PLEDGE_TRANSACTION_AMOUNT |
NA |
NO |
| AGBPLDG_COMMENT |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_PLEDGE_DETAIL PLEDGE_TRANSACTION PLEDGE |
PLEDGE_COMMENT PLEDGE_COMMENT PLEDGE_COMMENT |
ANALYZE FUNDRAISING, PLEDGE NA NA |
NO NO NO |
| AGBPLDG_FEED_DATE |
NO |
REPORTING VIEW |
PLEDGE PLEDGE_TRANSACTION |
POST_DATE POST_DATE |
NA NA |
NO NO |
| AGBPLDG_FEED_DOC_CODE |
NO |
REPORTING VIEW |
PLEDGE_TRANSACTION PLEDGE |
POST_BATCH_ID POST_BATCH_ID |
NA NA |
NO NO |
| AGBPLDG_FEED_IND |
NO |
REPORTING VIEW |
PLEDGE PLEDGE_TRANSACTION |
FINANCE_FEED_IND FINANCE_FEED_IND |
NA NA |
NO NO |
| AGBPLDG_FISC_CODE |
NO |
REPORTING VIEW |
PLEDGE PLEDGE_TRANSACTION |
FISCAL_YEAR FISCAL_YEAR |
NA NA |
NO NO |
| AGBPLDG_PACK_CODE |
NO |
REPORTING VIEW |
PLEDGE_TRANSACTION PLEDGE |
PLEDGE_RANGE PLEDGE_RANGE |
NA NA |
NO NO |
| AGBPLDG_PACK_IND |
NO |
REPORTING VIEW |
PLEDGE_TRANSACTION PLEDGE |
PLEDGE_ACKNOWLEDGED_IND PLEDGE_ACKNOWLEDGED_IND |
NA NA |
NO NO |
| AGBPLDG_PCAT_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_PLEDGE PLEDGE_TRANSACTION |
PLEDGE_CATEGORY PLEDGE_CATEGORY |
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE NA |
NO NO |
| AGBPLDG_PCLS_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_PLEDGE WDT_PLEDGE WDT_PLEDGE PLEDGE PLEDGE_TRANSACTION |
PLEDGE_CLASS_3 PLEDGE_CLASS_1 PLEDGE_CLASS_2 PLEDGE_CLASS PLEDGE_CLASS |
ADVANCEMENT GIFT ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE ADVANCEMENT GIFT NA NA |
NO NO NO NO NO |
| AGBPLDG_PCLS_CODE_2 |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_PLEDGE PLEDGE PLEDGE_TRANSACTION |
PLEDGE_CLASS_2 PLEDGE_CLASS2 PLEDGE_CLASS2 |
ANALYZE FUNDRAISING, PLEDGE NA NA |
NO NO NO |
| AGBPLDG_PCLS_CODE_3 |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_PLEDGE PLEDGE PLEDGE_TRANSACTION |
PLEDGE_CLASS_3 PLEDGE_CLASS3 PLEDGE_CLASS3 |
ANALYZE FUNDRAISING, PLEDGE NA NA |
NO NO NO |
| AGBPLDG_PGVE_CODE |
NO |
REPORTING VIEW |
PLEDGE_MATCHING_TRANSACTION PLEDGE_TRANSACTION PLEDGE PLEDGE_MATCHING |
MATCH_VEHICLE PLEDGE_VEHICLE PLEDGE_VEHICLE MATCH_VEHICLE |
NA NA NA NA |
NO NO NO NO |
| AGBPLDG_PLDG_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_PLEDGE PLEDGE_TRANSACTION |
PLEDGE_TYPE PLEDGE_TYPE |
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE NA |
NO NO |
| AGBPLDG_PLEDGE_DATE |
NO |
REPORTING VIEW |
PLEDGE_TRANSACTION PLEDGE |
PLEDGE_DATE PLEDGE_DATE |
NA NA |
NO NO |
| AGBPLDG_PLEDGE_NO |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_PLEDGE_DETAIL CONSTITUENT ORGANIZATIONAL_CONSTITUENT |
PLEDGE_NUMBER MOST_RECENT_PLEDGE_NUMBER MOST_RECENT_PLEDGE_NUMBER |
ANALYZE FUNDRAISING, PLEDGE NA NA |
NO NO NO |
| AGBPLDG_PRMD_CODE |
NO |
REPORTING VIEW |
PLEDGE PLEDGE_TRANSACTION |
PLEDGE_REMINDER PLEDGE_REMINDER |
NA NA |
NO NO |
| AGBPLDG_PSTA_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_PLEDGE PLEDGE_TRANSACTION ANNUAL_GIVING_SLOT |
PLEDGE_STATUS PLEDGE_STATUS ENTITY_UID |
ADVANCEMENT GIFT, ANALYZE FUNDRAISING, PLEDGE NA NA |
NO NO NO |
| AGBPLDG_RECEIPT_DATE |
NO |
REPORTING VIEW |
PLEDGE_TRANSACTION PLEDGE |
RECEIPT_DATE RECEIPT_DATE |
NA NA |
NO NO |
| AGBPLDG_RECEIPT_IND |
NO |
REPORTING VIEW |
PLEDGE_TRANSACTION PLEDGE |
RECEIPT_REQUIRED_IND RECEIPT_REQUIRED_IND |
NA NA |
NO NO |
| AGBPLDG_REM_COUNT |
NO |
REPORTING VIEW |
PLEDGE PLEDGE_TRANSACTION |
PLEDGE_REMINDER_COUNT PLEDGE_REMINDER_COUNT |
NA NA |
NO NO |
| AGBPLDG_REM_DATE |
NO |
REPORTING VIEW |
PLEDGE_TRANSACTION PLEDGE |
PLEDGE_REMINDER_DATE PLEDGE_REMINDER_DATE |
NA NA |
NO NO |
| AGBPLDG_USER |
NO |
REPORTING VIEW |
PLEDGE PLEDGE_TRANSACTION |
POST_USER POST_USER |
NA NA |
NO NO |