RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: AGBGIFT Advancement Reporting View Meta Data Reports
SGHE Operational Data Store Reporting View Source: AGBGIFT

Source Column Source Form Target Type Target Target Column Calculation Formula
AGBGIFT_ADJ_IND AGCGIFT

REPORTING VIEW

GIFT

GIFT_TRANSACTION

GIFT_ADJUSTMENT_IND

GIFT_ADJUSTMENT_IND

NA
AGBGIFT_AMT_TOT AGAGIFT

REPORTING VIEW

GIFT_TRANSACTION

GIFT_TRANSACTION_AMOUNT

NA
AGBGIFT_COMMENT AGAGIFT

REPORTING VIEW

GIFT

GIFT_TRANSACTION

GIFT_COMMENT

GIFT_COMMENT

NA
AGBGIFT_ENTRY_DATE AGAGIFT

REPORTING VIEW

GIFT

GIFT_TRANSACTION

ENTRY_DATE

ENTRY_DATE

NA
AGBGIFT_FEED_DATE AGAGIFT

REPORTING VIEW

GIFT

GIFT_TRANSACTION

POSTING_DATE

POSTING_DATE

NA
AGBGIFT_FEED_DOC_CODE AGAGIFT

REPORTING VIEW

GIFT_TRANSACTION

GIFT

POST_BATCH_ID

POST_BATCH_ID

NA
AGBGIFT_FEED_IND AGAGIFT

REPORTING VIEW

GIFT_TRANSACTION

GIFT

FINANCE_FEED_IND

FINANCE_FEED_IND

NA
AGBGIFT_FISC_CODE AGAGIFT

REPORTING VIEW

GIFT

GIFT_MULTIPLE

GIFT_MEMO

GIFT_TRANSACTION

FISCAL_YEAR

FISCAL_YEAR

FISCAL_YEAR

FISCAL_YEAR

NA
AGBGIFT_GACK_CODE AGAGIFT

REPORTING VIEW

GIFT_TRANSACTION

GIFT

GIFT_RANGE

GIFT_RANGE

NA
AGBGIFT_GACK_IND AGAGIFT

REPORTING VIEW

GIFT

GIFT_TRANSACTION

GIFT_ACKNOWLEDGED_IND

GIFT_ACKNOWLEDGED_IND

NA
AGBGIFT_GCLS_CODE AGAGIFT

REPORTING VIEW

GIFT_MULTIPLE

GIFT

GIFT_TRANSACTION

GIFT_MEMO

GIFT_CLASS

GIFT_CLASS

GIFT_CLASS

GIFT_CLASS

NA
AGBGIFT_GCLS_CODE_2 AGAGIFT

REPORTING VIEW

GIFT_TRANSACTION

GIFT

GIFT_CLASS2

GIFT_CLASS2

NA
AGBGIFT_GCLS_CODE_3 AGAGIFT

REPORTING VIEW

GIFT

GIFT_TRANSACTION

GIFT_CLASS3

GIFT_CLASS3

NA
AGBGIFT_GIFT_CODE AGAGIFT

REPORTING VIEW

GIFT_MEMO

GIFT

GIFT_MULTIPLE

GIFT_TRANSACTION

GIFT_TYPE

GIFT_TYPE

GIFT_TYPE

GIFT_TYPE

NA
AGBGIFT_GIFT_DATE AGAGIFT

REPORTING VIEW

GIFT_TRANSACTION

GIFT_MULTIPLE

GIFT

GIFT_MEMO

GIFT_DATE

GIFT_DATE

GIFT_DATE

GIFT_DATE

NA
AGBGIFT_GIFT_DESC AGAGIFT

REPORTING VIEW

GIFT_TRANSACTION

GIFT

GIFT_TYPE_DESC

GIFT_TYPE_DESC

NA
AGBGIFT_GIFT_NO AGAGIFT

REPORTING VIEW

GIFT_TRANSACTION

CONSTITUENT

ORGANIZATIONAL_CONSTITUENT

CONSTITUENT

GIFT_NUMBER

HIGHEST_GIFT_NUMBER

MOST_RECENT_GIFT_NUMBER

MOST_RECENT_GIFT_NUMBER

NA
AGBGIFT_MATCH_RECEIVED AGAGIFT

REPORTING VIEW

GIFT

GIFT_TRANSACTION

MATCH_GIFT_FORM_RECEIVED_IND

MATCH_GIFT_FORM_RECEIVED_IND

NA
AGBGIFT_PGVE_CODE AGAGIFT

REPORTING VIEW

GIFT_MEMO

GIFT_MULTIPLE

GIFT_TRANSACTION

GIFT

GIFT_VEHICLE

GIFT_VEHICLE

GIFT_VEHICLE

GIFT_VEHICLE

NA
AGBGIFT_PIDM NA

REPORTING VIEW

GIFT_TRANSACTION

ENTITY_UID

NA
AGBGIFT_RECEIPT_DATE AGAGIFT

REPORTING VIEW

GIFT

GIFT_TRANSACTION

RECEIPT_DATE

RECEIPT_DATE

NA
AGBGIFT_RECEIPT_IND AGAGIFT

REPORTING VIEW

GIFT_TRANSACTION

GIFT

RECEIPT_REQUIRED_IND

RECEIPT_REQUIRED_IND

NA
AGBGIFT_USER AGAGIFT

REPORTING VIEW

GIFT

GIFT_TRANSACTION

POST_CASHIER

POST_CASHIER

NA


Ver: 3.1