Banner EDW Source: AGBGIFT

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
AGBGIFT_ACTIVITY_DATE	NO	REPORTING VIEW	GIFT_TRANSACTION	ACTIVITY_DATE	NA	NO
AGBGIFT_ADJ_IND	NO	REPORTING VIEW	GIFT GIFT_TRANSACTION	GIFT_ADJUSTMENT_IND GIFT_ADJUSTMENT_IND	NA NA	NO NO
AGBGIFT_AMT_TOT	NO	FACT TABLE REPORTING VIEW	WFT_MATCHING_CLAIM GIFT_TRANSACTION	OVERALL_TRANSACTION_AMOUNT GIFT_TRANSACTION_AMOUNT	MATCHING CLAIM NA	NO NO
AGBGIFT_COMMENT	NO	DIMENSION TABLE REPORTING VIEW	WDT_GIFT_DETAIL GIFT_TRANSACTION GIFT	GIFT_COMMENT GIFT_COMMENT GIFT_COMMENT	ANALYZE FUNDRAISING, GIFT NA NA	NO NO NO
AGBGIFT_ENTRY_DATE	NO	REPORTING VIEW	GIFT_TRANSACTION GIFT	ENTRY_DATE ENTRY_DATE	NA NA	NO NO
AGBGIFT_FEED_DATE	NO	REPORTING VIEW	GIFT_TRANSACTION GIFT	POSTING_DATE POSTING_DATE	NA NA	NO NO
AGBGIFT_FEED_DOC_CODE	NO	REPORTING VIEW	GIFT GIFT_TRANSACTION	POST_BATCH_ID POST_BATCH_ID	NA NA	NO NO
AGBGIFT_FEED_IND	NO	REPORTING VIEW	GIFT_TRANSACTION GIFT	FINANCE_FEED_IND FINANCE_FEED_IND	NA NA	NO NO
AGBGIFT_FISC_CODE	NO	REPORTING VIEW	GIFT_MEMO GIFT_MULTIPLE GIFT GIFT_TRANSACTION	FISCAL_YEAR FISCAL_YEAR FISCAL_YEAR FISCAL_YEAR	NA NA NA NA	NO NO NO NO
AGBGIFT_GACK_CODE	NO	REPORTING VIEW	GIFT_TRANSACTION GIFT	GIFT_RANGE GIFT_RANGE	NA NA	NO NO
AGBGIFT_GACK_IND	NO	REPORTING VIEW	GIFT_TRANSACTION GIFT	GIFT_ACKNOWLEDGED_IND GIFT_ACKNOWLEDGED_IND	NA NA	NO NO
AGBGIFT_GCLS_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_GIFT GIFT_MEMO GIFT_MULTIPLE GIFT GIFT_TRANSACTION	GIFT_CLASS_1 GIFT_CLASS GIFT_CLASS GIFT_CLASS GIFT_CLASS	ADVANCEMENT GIFT NA NA NA NA	NO NO NO NO NO
AGBGIFT_GCLS_CODE_2	NO	DIMENSION TABLE REPORTING VIEW	WDT_GIFT GIFT_TRANSACTION GIFT	GIFT_CLASS_2 GIFT_CLASS2 GIFT_CLASS2	ADVANCEMENT GIFT NA NA	NO NO NO
AGBGIFT_GCLS_CODE_3	NO	DIMENSION TABLE REPORTING VIEW	WDT_GIFT GIFT GIFT_TRANSACTION	GIFT_CLASS_3 GIFT_CLASS3 GIFT_CLASS3	ADVANCEMENT GIFT NA NA	NO NO NO
AGBGIFT_GIFT_CODE	NO	REPORTING VIEW	GIFT GIFT_MEMO GIFT_TRANSACTION GIFT_MULTIPLE	GIFT_TYPE GIFT_TYPE GIFT_TYPE GIFT_TYPE	NA NA NA NA	NO NO NO NO
AGBGIFT_GIFT_DATE	NO	REPORTING VIEW	GIFT_MULTIPLE GIFT_MEMO GIFT GIFT_TRANSACTION	GIFT_DATE GIFT_DATE GIFT_DATE GIFT_DATE	NA NA NA NA	NO NO NO NO
AGBGIFT_GIFT_DESC	NO	REPORTING VIEW	GIFT GIFT_TRANSACTION	GIFT_TYPE_DESC GIFT_TYPE_DESC	NA NA	NO NO
AGBGIFT_GIFT_NO	NO	REPORTING VIEW	CONSTITUENT GIFT_TRANSACTION ORGANIZATIONAL_CONSTITUENT	HIGHEST_GIFT_NUMBER GIFT_NUMBER MOST_RECENT_GIFT_NUMBER	NA NA NA	NO NO NO
AGBGIFT_MATCH_RECEIVED	NO	REPORTING VIEW	GIFT GIFT_TRANSACTION	MATCH_GIFT_FORM_RECEIVED_IND MATCH_GIFT_FORM_RECEIVED_IND	NA NA	NO NO
AGBGIFT_PGVE_CODE	NO	REPORTING VIEW	GIFT GIFT_MEMO GIFT_MULTIPLE GIFT_TRANSACTION	GIFT_VEHICLE GIFT_VEHICLE GIFT_VEHICLE GIFT_VEHICLE	NA NA NA NA	NO NO NO NO
AGBGIFT_PIDM	NO	REPORTING VIEW	GIFT_TRANSACTION	ENTITY_UID	NA	NO
AGBGIFT_RECEIPT_DATE	NO	REPORTING VIEW	GIFT_TRANSACTION GIFT	RECEIPT_DATE RECEIPT_DATE	NA NA	NO NO
AGBGIFT_RECEIPT_IND	NO	REPORTING VIEW	GIFT_TRANSACTION GIFT	RECEIPT_REQUIRED_IND RECEIPT_REQUIRED_IND	NA NA	NO NO
AGBGIFT_USER	NO	REPORTING VIEW	GIFT GIFT_TRANSACTION	POST_CASHIER POST_CASHIER	NA NA	NO NO

Ver: 9.0