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

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

AA_GIFT

GIFT_ADJUSTMENT_IND

NA
AGBGIFT_AMT_TOT AGAGIFT COMPOSITE VIEW

AA_ORGANIZATIONAL_CONSTITUENT

AA_CONSTITUENT

MOST_RECENT_GIFT_AMT

MOST_RECENT_GIFT_AMT

NA
AGBGIFT_COMMENT AGAGIFT COMPOSITE VIEW

AA_GIFT

GIFT_COMMENT

NA
AGBGIFT_ENTRY_DATE AGAGIFT COMPOSITE VIEW

AA_GIFT

ENTRY_DATE

NA
AGBGIFT_FEED_DATE AGAGIFT COMPOSITE VIEW

AA_GIFT

POST_DATE

NA
AGBGIFT_FEED_DOC_CODE AGAGIFT COMPOSITE VIEW

AA_GIFT

POST_BATCH_ID

NA
AGBGIFT_FEED_IND AGAGIFT       NA
AGBGIFT_FISC_CODE AGAGIFT COMPOSITE VIEW

AA_GIFT_MULTIPLE

AA_GIFT

AA_GIFT_MEMO

FISCAL_YEAR

FISCAL_YEAR

FISCAL_YEAR

NA
AGBGIFT_GACK_CODE AGAGIFT       NA
AGBGIFT_GACK_IND AGAGIFT       NA
AGBGIFT_GCLS_CODE AGAGIFT COMPOSITE VIEW

AA_GIFT

AA_GIFT_MEMO

AA_GIFT_MULTIPLE

GIFT_CLASS

GIFT_CLASS

GIFT_CLASS

NA
AGBGIFT_GCLS_CODE_2 AGAGIFT COMPOSITE VIEW

AA_GIFT

GIFT_CLASS2

NA
AGBGIFT_GCLS_CODE_3 AGAGIFT COMPOSITE VIEW

AA_GIFT

GIFT_CLASS3

NA
AGBGIFT_GIFT_CODE AGAGIFT COMPOSITE VIEW

AA_GIFT

AA_GIFT_MULTIPLE

AA_GIFT_MEMO

GIFT_TYPE

GIFT_TYPE

GIFT_TYPE

NA
AGBGIFT_GIFT_DATE AGAGIFT COMPOSITE VIEW

AA_GIFT_MEMO

AA_GIFT_MULTIPLE

AA_CONSTITUENT

AA_ORGANIZATIONAL_CONSTITUENT

AA_GIFT

GIFT_DATE

GIFT_DATE

MOST_RECENT_GIFT_DATE

MOST_RECENT_GIFT_DATE

GIFT_DATE

NA
AGBGIFT_GIFT_DESC AGAGIFT COMPOSITE VIEW

AA_GIFT

GIFT_TYPE_DESC

NA
AGBGIFT_GIFT_NO AGAGIFT COMPOSITE VIEW

AA_CONSTITUENT

AA_CONSTITUENT

AA_ORGANIZATIONAL_CONSTITUENT

HIGHEST_GIFT_NUMBER

MOST_RECENT_GIFT_NUMBER

MOST_RECENT_GIFT_NUMBER

NA
AGBGIFT_MATCH_RECEIVED AGAGIFT COMPOSITE VIEW

AA_GIFT

MATCH_GIFT_FORM_RECEIVED_IND

NA
AGBGIFT_PGVE_CODE AGAGIFT COMPOSITE VIEW

AA_GIFT_MULTIPLE

AA_GIFT_MEMO

AA_GIFT

GIFT_VEHICLE

GIFT_VEHICLE

GIFT_VEHICLE

NA
AGBGIFT_PIDM NA       NA
AGBGIFT_RECEIPT_DATE AGAGIFT       NA
AGBGIFT_RECEIPT_IND AGAGIFT       NA
AGBGIFT_USER AGAGIFT COMPOSITE VIEW

AA_GIFT

POST_USER

NA


Ver: 3.1