Target Column	Business Definition	Database Data Type	Source Name	Source Column
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	AGRPMEM APRCHIS	AGRPMEM_MEMO_PIDM APRCHIS_PIDM
FISCAL_YEAR	Unique identifier or code for the fiscal year.	NUMBER	AGBPLDG APRCHIS	AGBPLDG_FISC_CODE APRCHIS_FISC_CODE
FISCAL_YEAR_DESC	Fiscal year code description.	VARCHAR2(30)	ATVFISC	ATVFISC_DESC
HIGHEST_GIFT_AMOUNT	Highest gift amount for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR
HIGHEST_GIFT_AMOUNT_DATE	Date of the highest gift amount for the year.	DATE	FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR
HIGHEST_PLEDGE_AMOUNT	Highest pledge amount for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
TOTAL_ANT_MATCH_GIFT_ONE_PAY	Total anticipated matching gifts for one-time payments for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY
TOTAL_ANT_MATCH_GIFT_PAY	Total anticipated matching gifts for payments for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY
TOTAL_GIVING	Total giving for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_GIVING_YEAR
TOTAL_NON_MATCH_GIFT_MEMO	Non-matching gift memo total for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO
TOTAL_NUMBER_OF_GIFTS	Number of gifts for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR
TOTAL_NUMBER_OF_PLEDGES	Total number of pledges for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR
TOTAL_PLEDGE_AMOUNT	Total pledged amount for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR
TOTAL_PLEDGE_PAYMENTS	Total pledge payments for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR
TOTAL_REAL_MATCH_GIFT_ONE_PAY	Total realized matching gifts for one-time payments for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY
TOTAL_REAL_MATCH_GIFT_PAY	Total realized matching gifts for payments for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA

Ver: