Composite View Source: AGBGIFT

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: AGBGIFT Advancement

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
AGBGIFT_ACTIVITY_DATE	AGAGIFT	COMPOSITE VIEW	AA_GIFT	GIFT_ACTIVITY_DATE
AGBGIFT_ADJ_IND	AGCGIFT	COMPOSITE VIEW	AA_GIFT	GIFT_ADJUSTMENT_IND	NA
AGBGIFT_AMT_TOT		COMPOSITE VIEW	AA_ORGANIZATIONAL_CONSTITUENT AA_CONSTITUENT	MOST_RECENT_GIFT_AMT MOST_RECENT_GIFT_AMT
AGBGIFT_COMMENT		COMPOSITE VIEW	AA_GIFT	GIFT_COMMENT
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	COMPOSITE VIEW	AA_GIFT	FINANCE_FEED_IND	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	COMPOSITE VIEW	AA_GIFT	GIFT_RANGE	NA
AGBGIFT_GACK_IND	AGAGIFT	COMPOSITE VIEW	AA_GIFT	GIFT_ACKNOWLEDGED_IND	NA
AGBGIFT_GCLS_CODE	NA	COMPOSITE VIEW	AA_GIFT_MULTIPLE AA_GIFT_MEMO AA_GIFT	GIFT_CLASS GIFT_CLASS GIFT_CLASS
AGBGIFT_GCLS_CODE_2	NA	COMPOSITE VIEW	AA_GIFT	GIFT_CLASS2
AGBGIFT_GCLS_CODE_3	NA	COMPOSITE VIEW	AA_GIFT	GIFT_CLASS3
AGBGIFT_GIFT_CODE	AGAGIFT	COMPOSITE VIEW	AA_GIFT_MEMO AA_GIFT AA_GIFT_MULTIPLE	GIFT_TYPE GIFT_TYPE GIFT_TYPE	NA
AGBGIFT_GIFT_DATE	AGAGIFT	COMPOSITE VIEW	AA_GIFT_MEMO AA_GIFT_MULTIPLE AA_ORGANIZATIONAL_CONSTITUENT AA_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_ORGANIZATIONAL_CONSTITUENT AA_CONSTITUENT	MOST_RECENT_GIFT_NUMBER MOST_RECENT_GIFT_NUMBER HIGHEST_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 AA_GIFT_MULTIPLE AA_GIFT_MEMO	GIFT_VEHICLE GIFT_VEHICLE GIFT_VEHICLE	NA
AGBGIFT_PIDM	NA				NA
AGBGIFT_RECEIPT_DATE	AGAGIFT	COMPOSITE VIEW	AA_GIFT	RECEIPT_DATE	NA
AGBGIFT_RECEIPT_IND	AGAGIFT	COMPOSITE VIEW	AA_GIFT	RECEIPT_REQUIRED_IND	NA
AGBGIFT_USER	AGAGIFT	COMPOSITE VIEW	AA_GIFT	POST_USER	NA

Ver: