Banner EDW Source: AGBPLDG

RETURN TO BANNER EDW META DATA REPORTS LIST

**SGHE Enterprise Data Warehouse**
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	REPORTING VIEW	PLEDGE PLEDGE_TRANSACTION	PLEDGE_COMMENT PLEDGE_COMMENT	NA NA	NO NO
AGBPLDG_FEED_DATE	NO	REPORTING VIEW	PLEDGE_TRANSACTION PLEDGE	POST_DATE POST_DATE	NA NA	NO NO
AGBPLDG_FEED_DOC_CODE	NO	REPORTING VIEW	PLEDGE PLEDGE_TRANSACTION	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_TRANSACTION PLEDGE	FISCAL_YEAR FISCAL_YEAR	NA NA	NO NO
AGBPLDG_PACK_CODE	NO	REPORTING VIEW	PLEDGE PLEDGE_TRANSACTION	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 NA	NO NO
AGBPLDG_PCLS_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_PLEDGE WDT_PLEDGE WDT_PLEDGE PLEDGE PLEDGE_TRANSACTION	PLEDGE_CLASS_2 PLEDGE_CLASS_1 PLEDGE_CLASS_3 PLEDGE_CLASS PLEDGE_CLASS	ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT NA NA	NO NO NO NO NO
AGBPLDG_PCLS_CODE_2	NO	REPORTING VIEW	PLEDGE PLEDGE_TRANSACTION	PLEDGE_CLASS2 PLEDGE_CLASS2	NA NA	NO NO
AGBPLDG_PCLS_CODE_3	NO	REPORTING VIEW	PLEDGE PLEDGE_TRANSACTION	PLEDGE_CLASS3 PLEDGE_CLASS3	NA NA	NO NO
AGBPLDG_PGVE_CODE	NO	REPORTING VIEW	PLEDGE PLEDGE_MATCHING PLEDGE_MATCHING_TRANSACTION PLEDGE_TRANSACTION	PLEDGE_VEHICLE MATCH_VEHICLE MATCH_VEHICLE PLEDGE_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 NA	NO NO
AGBPLDG_PLEDGE_DATE	NO	REPORTING VIEW	PLEDGE PLEDGE_TRANSACTION	PLEDGE_DATE PLEDGE_DATE	NA NA	NO NO
AGBPLDG_PLEDGE_NO	NO	REPORTING VIEW	CONSTITUENT ORGANIZATIONAL_CONSTITUENT	MOST_RECENT_PLEDGE_NUMBER MOST_RECENT_PLEDGE_NUMBER	NA NA	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 ANNUAL_GIVING_SLOT PLEDGE_TRANSACTION	PLEDGE_STATUS ENTITY_UID PLEDGE_STATUS	ADVANCEMENT GIFT NA NA	NO NO NO
AGBPLDG_RECEIPT_DATE	NO	REPORTING VIEW	PLEDGE PLEDGE_TRANSACTION	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_TRANSACTION PLEDGE	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_TRANSACTION PLEDGE	POST_USER POST_USER	NA NA	NO NO

Ver: 8.4.3