Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: AGBGIFT Advancement Reporting View Meta Data Reports
SGHE Banner Operational Data Store Reporting View Source: AGBGIFT - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
AGBGIFT_ACTIVITY_DATE AGAGIFT

REPORTING VIEW

GIFT_TRANSACTION

ACTIVITY_DATE

 
AGBGIFT_ADJ_IND AGCGIFT

REPORTING VIEW

GIFT_TRANSACTION

GIFT

GIFT_ADJUSTMENT_IND

GIFT_ADJUSTMENT_IND

NA
AGBGIFT_AMT_TOT

REPORTING VIEW

GIFT_TRANSACTION

GIFT_TRANSACTION_AMOUNT

 
AGBGIFT_COMMENT

REPORTING VIEW

GIFT_TRANSACTION

GIFT

GIFT_COMMENT

GIFT_COMMENT

 
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

GIFT_TRANSACTION

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_MEMO

GIFT_MULTIPLE

GIFT

GIFT_TRANSACTION

FISCAL_YEAR

FISCAL_YEAR

FISCAL_YEAR

FISCAL_YEAR

NA
AGBGIFT_GACK_CODE AGAGIFT

REPORTING VIEW

GIFT

GIFT_TRANSACTION

GIFT_RANGE

GIFT_RANGE

NA
AGBGIFT_GACK_IND AGAGIFT

REPORTING VIEW

GIFT_TRANSACTION

GIFT

GIFT_ACKNOWLEDGED_IND

GIFT_ACKNOWLEDGED_IND

NA
AGBGIFT_GCLS_CODE NA

REPORTING VIEW

GIFT

GIFT_MEMO

GIFT_MULTIPLE

GIFT_TRANSACTION

GIFT_CLASS

GIFT_CLASS

GIFT_CLASS

GIFT_CLASS

 
AGBGIFT_GCLS_CODE_2 NA

REPORTING VIEW

GIFT

GIFT_TRANSACTION

GIFT_CLASS2

GIFT_CLASS2

 
AGBGIFT_GCLS_CODE_3 NA

REPORTING VIEW

GIFT

GIFT_TRANSACTION

GIFT_CLASS3

GIFT_CLASS3

 
AGBGIFT_GIFT_CODE AGAGIFT

REPORTING VIEW

GIFT

GIFT_MEMO

GIFT_MULTIPLE

GIFT_TRANSACTION

GIFT_TYPE

GIFT_TYPE

GIFT_TYPE

GIFT_TYPE

NA
AGBGIFT_GIFT_DATE AGAGIFT

REPORTING VIEW

GIFT_TRANSACTION

GIFT_MULTIPLE

GIFT_MEMO

GIFT

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

CONSTITUENT

CONSTITUENT

GIFT_TRANSACTION

ORGANIZATIONAL_CONSTITUENT

HIGHEST_GIFT_NUMBER

MOST_RECENT_GIFT_NUMBER

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

GIFT_TRANSACTION

GIFT_MEMO

GIFT_MULTIPLE

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_TRANSACTION

GIFT

POST_CASHIER

POST_CASHIER

NA


Ver: 8.5