Target Column	Business Name	Business Definition	Database Data Type	Business Data Type	Domain Value	Source Name	Source Column	Local Source	Local Target
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER			AGRPMEM APRCHIS	AGRPMEM_MEMO_PIDM APRCHIS_PIDM	NO NO	NO
ENTITY_IND	Entity Indicator	Indicates whether the entity is a person or an organization.	VARCHAR2(1)			CONSTANT CONSTANT	'O' 'P'	NO NO	NO
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
FISCAL_YEAR	Fiscal Year	Unique identifier or code for the fiscal year.	VARCHAR2(63)			ATVFISC	ATVFISC_CODE	NO	NO
FISCAL_YEAR_DESC	Fiscal Year Description	Fiscal year code description.	VARCHAR2(255)			ATVFISC	ATVFISC_DESC	NO	NO
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
TOTAL_NUMBER_OF_GIFTS	Total Number Of Gifts	Number of gifts for year.	NUMBER			FUNCTION	AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR	NO	NO
TOTAL_GIVING	Total Giving	Total giving for the year.	NUMBER			FUNCTION	AOKODSF.F_GET_TOT_GIVING_YEAR	NO	NO
HIGHEST_GIFT_AMOUNT	Highest Gift Amount	Highest gift amount for the year.	NUMBER			FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR	NO	NO
HIGHEST_GIFT_AMOUNT_DATE	Highest Gift Amount Date	Date of the highest gift amount for the year.	DATE			FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR	NO	NO
TOTAL_ANT_MATCH_GIFT_PAY	Total Anticipated Matching Gifts for Pledge Payments	Total anticipated matching gifts for pledge payments received for the year.	NUMBER			FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY	NO	NO
TOTAL_REAL_MATCH_GIFT_PAY	Total Realized Matching Gifts for Pledge Payments	Total realized matching gifts for pledge payments received for the year.	NUMBER			FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY	NO	NO
TOTAL_ANT_MATCH_GIFT_ONE_PAY	Total Anticipated Matching Gifts for Onetime Payments	Total anticipated matching gifts for one-time payments or outright gifts received for the year.	NUMBER			FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY	NO	NO
TOTAL_REAL_MATCH_GIFT_ONE_PAY	Total Realized Matching Gifts for One-time Payments	Total realized matching gifts for one-time payments or outright gifts received for the year.	NUMBER			FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY	NO	NO
TOTAL_NUMBER_OF_PLEDGES	Total Number Of Pledges	Total number of pledges for the year.	NUMBER			FUNCTION	AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR	NO	NO
TOTAL_NON_MATCH_GIFT_MEMO	Total Non-Matching Gift Memo Credit	Total non-matching gift memo or soft credit received for the year.	NUMBER			FUNCTION	AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO	NO	NO
TOTAL_PLEDGE_AMOUNT	Total Pledge Amount	Total pledged amount for year.	NUMBER			FUNCTION	AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR	NO	NO
HIGHEST_PLEDGE_AMOUNT	Highest Pledge Amount	Highest pledge amount for the year.	NUMBER			FUNCTION	AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR	NO	NO
TOTAL_PLEDGE_PAYMENTS	Total Pledge Payments	Total pledge payments for year.	NUMBER			FUNCTION	AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR	NO	NO
GIFT_SOCIETY_COUNT	Gift Society Count	Count of gift societies.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_GIFT_SOCIETY	NO	NO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)			NA	NA	NO	NO
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)			NA	NA	NO	NO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO

Ver: 9.2