Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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(8)		AGRPMEM APRCHIS	AGRPMEM_MEMO_PIDM APRCHIS_PIDM
FISCAL_YEAR		Unique identifier or code for the fiscal year.	NUMBER(4)		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: