Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date record was inserted or updated	DATE		NA	SYSDATE
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER		AGBPLDG AGRPMEM APRCHIS	AGBPLDG_PSTA_CODE AGRPMEM_MEMO_PIDM APRCHIS_PIDM
FISCAL_YEAR1	Fiscal Year 1	Unique identifier or code for the fiscal year.	VARCHAR2(63)		ATVFISC	ATVFISC_CODE
FISCAL_YEAR2	Fiscal Year 2	Unique identifier or code for the fiscal year.	VARCHAR2(63)		ATVFISC	ATVFISC_CODE
FISCAL_YEAR3	Fiscal Year 3	Unique identifier or code for the fiscal year.	VARCHAR2(63)		ATVFISC	ATVFISC_CODE
FISCAL_YEAR4	Fiscal Year 4	Unique identifier or code for the fiscal year.	VARCHAR2(63)		ATVFISC	ATVFISC_CODE
FISCAL_YEAR5	Fiscal Year 5	Unique identifier or code for the fiscal year.	VARCHAR2(63)		ATVFISC	ATVFISC_CODE
FISCAL_YEAR6	Fiscal Year 6	Unique identifier or code for the fiscal year.	VARCHAR2(63)		ATVFISC	ATVFISC_CODE
HIGHEST_GIFT_AMOUNT1	Highest Gift Amount 1	Highest gift amount for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR
HIGHEST_GIFT_AMOUNT2	Highest Gift Amount 2	Highest gift amount for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR
HIGHEST_GIFT_AMOUNT3	Highest Gift Amount 3	Highest gift amount for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR
HIGHEST_GIFT_AMOUNT4	Highest Gift Amount 4	Highest gift amount for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR
HIGHEST_GIFT_AMOUNT5	Highest Gift Amount 5	Highest gift amount for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR
HIGHEST_GIFT_AMOUNT6	Highest Gift Amount 6	Highest gift amount for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR
HIGHEST_GIFT_AMOUNT_DATE1	Highest Gift Amount Date 1	Date of the highest gift amount for the year.	DATE		FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR
HIGHEST_GIFT_AMOUNT_DATE2	Highest Gift Amount Date 2	Date of the highest gift amount for the year.	DATE		FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR
HIGHEST_GIFT_AMOUNT_DATE3	Highest Gift Amount Date 3	Date of the highest gift amount for the year.	DATE		FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR
HIGHEST_GIFT_AMOUNT_DATE4	Highest Gift Amount Date 4	Date of the highest gift amount for the year.	DATE		FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR
HIGHEST_GIFT_AMOUNT_DATE5	Highest Gift Amount Date 5	Date of the highest gift amount for the year.	DATE		FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR
HIGHEST_GIFT_AMOUNT_DATE6	Highest Gift Amount Date 6	Date of the highest gift amount for the year.	DATE		FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR
HIGHEST_PLEDGE_AMOUNT1	Highest Pledge Amount 1	Highest pledge amount for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR
HIGHEST_PLEDGE_AMOUNT2	Highest Pledge Amount 2	Highest pledge amount for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR
HIGHEST_PLEDGE_AMOUNT3	Highest Pledge Amount 3	Highest pledge amount for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR
HIGHEST_PLEDGE_AMOUNT4	Highest Pledge Amount 4	Highest pledge amount for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR
HIGHEST_PLEDGE_AMOUNT5	Highest Pledge Amount 5	Highest pledge amount for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR
HIGHEST_PLEDGE_AMOUNT6	Highest Pledge Amount 6	Highest pledge amount for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)		NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)		NA	NA
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
TOTAL_ANT_MATCH_GIFT_ONE_PAY1	Total Anticipated Matching Gifts for One-time Payments 1	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_ONE_PAY2	Total Anticipated Matching Gifts for One-time Payments 2	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_ONE_PAY3	Total Anticipated Matching Gifts for One-time Payments 3	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_ONE_PAY4	Total Anticipated Matching Gifts for One-time Payments 4	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_ONE_PAY5	Total Anticipated Matching Gifts for One-time Payments 5	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_ONE_PAY6	Total Anticipated Matching Gifts for One-time Payments 6	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_PAY1	Total Anticipated Matching Gifts for Pledge Payments 1	Total anticipated matching gifts for payments for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY
TOTAL_ANT_MATCH_GIFT_PAY2	Total Anticipated Matching Gifts for Pledge Payments 2	Total anticipated matching gifts for payments for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY
TOTAL_ANT_MATCH_GIFT_PAY3	Total Anticipated Matching Gifts for Pledge Payments 3	Total anticipated matching gifts for payments for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY
TOTAL_ANT_MATCH_GIFT_PAY4	Total Anticipated Matching Gifts for Pledge Payments 4	Total anticipated matching gifts for payments for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY
TOTAL_ANT_MATCH_GIFT_PAY5	Total Anticipated Matching Gifts for Pledge Payments 5	Total anticipated matching gifts for payments for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY
TOTAL_ANT_MATCH_GIFT_PAY6	Total Anticipated Matching Gifts for Pledge Payments 6	Total anticipated matching gifts for payments for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY
TOTAL_GIVING1	Total Giving 1	Total giving for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_GIVING_YEAR
TOTAL_GIVING2	Total Giving 2	Total giving for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_GIVING_YEAR
TOTAL_GIVING3	Total Giving 3	Total giving for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_GIVING_YEAR
TOTAL_GIVING4	Total Giving 4	Total giving for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_GIVING_YEAR
TOTAL_GIVING5	Total Giving 5	Total giving for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_GIVING_YEAR
TOTAL_GIVING6	Total Giving 6	Total giving for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_GIVING_YEAR
TOTAL_NON_MATCH_GIFT_MEMO1	Total Non Match Gift Memo 1	Non-matching gift memo total for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO
TOTAL_NON_MATCH_GIFT_MEMO2	Total Non Match Gift Memo 2	Non-matching gift memo total for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO
TOTAL_NON_MATCH_GIFT_MEMO3	Total Non Match Gift Memo 3	Non-matching gift memo total for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO
TOTAL_NON_MATCH_GIFT_MEMO4	Total Non Match Gift Memo 4	Non-matching gift memo total for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO
TOTAL_NON_MATCH_GIFT_MEMO5	Total Non Match Gift Memo 5	Non-matching gift memo total for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO
TOTAL_NON_MATCH_GIFT_MEMO6	Total Non Match Gift Memo 6	Non-matching gift memo total for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO
TOTAL_NUMBER_OF_GIFTS1	Total Number Of Gifts 1	Number of gifts for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR
TOTAL_NUMBER_OF_GIFTS2	Total Number Of Gifts 2	Number of gifts for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR
TOTAL_NUMBER_OF_GIFTS3	Total Number Of Gifts 3	Number of gifts for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR
TOTAL_NUMBER_OF_GIFTS4	Total Number Of Gifts 4	Number of gifts for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR
TOTAL_NUMBER_OF_GIFTS5	Total Number Of Gifts 5	Number of gifts for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR
TOTAL_NUMBER_OF_GIFTS6	Total Number Of Gifts 6	Number of gifts for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR
TOTAL_NUMBER_OF_PLEDGES1	Total Number Of Pledges 1	Total number of pledges for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR
TOTAL_NUMBER_OF_PLEDGES2	Total Number Of Pledges 2	Total number of pledges for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR
TOTAL_NUMBER_OF_PLEDGES3	Total Number Of Pledges 3	Total number of pledges for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR
TOTAL_NUMBER_OF_PLEDGES4	Total Number Of Pledges 4	Total number of pledges for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR
TOTAL_NUMBER_OF_PLEDGES5	Total Number Of Pledges 5	Total number of pledges for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR
TOTAL_NUMBER_OF_PLEDGES6	Total Number Of Pledges 6	Total number of pledges for the year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR
TOTAL_PLEDGE_AMOUNT1	Total Pledge Amount 1	Total pledged amount for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR
TOTAL_PLEDGE_AMOUNT2	Total Pledge Amount 2	Total pledged amount for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR
TOTAL_PLEDGE_AMOUNT3	Total Pledge Amount 3	Total pledged amount for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR
TOTAL_PLEDGE_AMOUNT4	Total Pledge Amount 4	Total pledged amount for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR
TOTAL_PLEDGE_AMOUNT5	Total Pledge Amount 5	Total pledged amount for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR
TOTAL_PLEDGE_AMOUNT6	Total Pledge Amount 6	Total pledged amount for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR
TOTAL_PLEDGE_PAYMENTS1	Total Pledge Payments 1	Total pledge payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR
TOTAL_PLEDGE_PAYMENTS2	Total Pledge Payments 2	Total pledge payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR
TOTAL_PLEDGE_PAYMENTS3	Total Pledge Payments 3	Total pledge payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR
TOTAL_PLEDGE_PAYMENTS4	Total Pledge Payments 4	Total pledge payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR
TOTAL_PLEDGE_PAYMENTS5	Total Pledge Payments 5	Total pledge payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR
TOTAL_PLEDGE_PAYMENTS6	Total Pledge Payments 6	Total pledge payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR
TOTAL_REAL_MATCH_GIFT_ONE_PAY1	Total Realized Matching Gifts for One-time Payments 1	Total realized matching gifts for one-time payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY
TOTAL_REAL_MATCH_GIFT_ONE_PAY2	Total Realized Matching Gifts for One-time Payments 2	Total realized matching gifts for one-time payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY
TOTAL_REAL_MATCH_GIFT_ONE_PAY3	Total Realized Matching Gifts for One-time Payments 3	Total realized matching gifts for one-time payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY
TOTAL_REAL_MATCH_GIFT_ONE_PAY4	Total Realized Matching Gifts for One-time Payments 4	Total realized matching gifts for one-time payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY
TOTAL_REAL_MATCH_GIFT_ONE_PAY5	Total Realized Matching Gifts for One-time Payments 5	Total realized matching gifts for one-time payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY
TOTAL_REAL_MATCH_GIFT_ONE_PAY6	Total Realized Matching Gifts for One-time Payments 6	Total realized matching gifts for one-time payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY
TOTAL_REAL_MATCH_GIFT_PAY1	Total Realized Matching Gifts for Pledge Payments 1	Total realized matching gifts for payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY
TOTAL_REAL_MATCH_GIFT_PAY2	Total Realized Matching Gifts for Pledge Payments 2	Total realized matching gifts for payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY
TOTAL_REAL_MATCH_GIFT_PAY3	Total Realized Matching Gifts for Pledge Payments 3	Total realized matching gifts for payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY
TOTAL_REAL_MATCH_GIFT_PAY4	Total Realized Matching Gifts for Pledge Payments 4	Total realized matching gifts for payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY
TOTAL_REAL_MATCH_GIFT_PAY5	Total Realized Matching Gifts for Pledge Payments 5	Total realized matching gifts for payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY
TOTAL_REAL_MATCH_GIFT_PAY6	Total Realized Matching Gifts for Pledge Payments 6	Total realized matching gifts for payments for year.	NUMBER		FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY

Ver: 9.0