Reporting View Target: ANNUAL_GIVING

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Advancement Reporting View Reports

Banner Operational Data Store
Reporting View Target: ANNUAL_GIVING_SLOT

Description Uses data from the ANNUAL_GIVING reporting view. Displays annual giving details for donors with giving activity in any of the 6 most recent fiscal years. There are currently no associated display rules.
Key & Frequency One row per entity.
Recommended Search Columns ENTITY_UID
ACTIVITY_DATE

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target

ACTIVITY_DATE Date record was inserted or updated. DATE
NA

SYSDATE

NO
NO

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

NO
NO

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

NO
NO
NO
NO

FISCAL_YEAR1 Unique identifier or code for the fiscal year. VARCHAR2(63)
ATVFISC

ATVFISC_CODE

NO
NO

FISCAL_YEAR2 Unique identifier or code for the fiscal year. VARCHAR2(63)
ATVFISC

ATVFISC_CODE

NO
NO

FISCAL_YEAR3 Unique identifier or code for the fiscal year. VARCHAR2(63)
ATVFISC

ATVFISC_CODE

NO
NO

FISCAL_YEAR4 Unique identifier or code for the fiscal year. VARCHAR2(63)
ATVFISC

ATVFISC_CODE

NO
NO

FISCAL_YEAR5 Unique identifier or code for the fiscal year. VARCHAR2(63)
ATVFISC

ATVFISC_CODE

NO
NO

FISCAL_YEAR6 Unique identifier or code for the fiscal year. VARCHAR2(63)
ATVFISC

ATVFISC_CODE

NO
NO

HIGHEST_GIFT_AMOUNT1 Highest gift amount for the year. NUMBER
FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

NO
NO

HIGHEST_GIFT_AMOUNT2 Highest gift amount for the year. NUMBER
FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

NO
NO

HIGHEST_GIFT_AMOUNT3 Highest gift amount for the year. NUMBER
FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

NO
NO

HIGHEST_GIFT_AMOUNT4 Highest gift amount for the year. NUMBER
FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

NO
NO

HIGHEST_GIFT_AMOUNT5 Highest gift amount for the year. NUMBER
FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

NO
NO

HIGHEST_GIFT_AMOUNT6 Highest gift amount for the year. NUMBER
FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

NO
NO

HIGHEST_GIFT_AMOUNT_DATE1 Date of the highest gift amount for the year. DATE
FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

NO
NO

HIGHEST_GIFT_AMOUNT_DATE2 Date of the highest gift amount for the year. DATE
FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

NO
NO

HIGHEST_GIFT_AMOUNT_DATE3 Date of the highest gift amount for the year. DATE
FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

NO
NO

HIGHEST_GIFT_AMOUNT_DATE4 Date of the highest gift amount for the year. DATE
FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

NO
NO

HIGHEST_GIFT_AMOUNT_DATE5 Date of the highest gift amount for the year. DATE
FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

NO
NO

HIGHEST_GIFT_AMOUNT_DATE6 Date of the highest gift amount for the year. DATE
FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

NO
NO

HIGHEST_PLEDGE_AMOUNT1 Highest pledge amount for the year. NUMBER
FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

NO
NO

HIGHEST_PLEDGE_AMOUNT2 Highest pledge amount for the year. NUMBER
FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

NO
NO

HIGHEST_PLEDGE_AMOUNT3 Highest pledge amount for the year. NUMBER
FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

NO
NO

HIGHEST_PLEDGE_AMOUNT4 Highest pledge amount for the year. NUMBER
FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

NO
NO

HIGHEST_PLEDGE_AMOUNT5 Highest pledge amount for the year. NUMBER
FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

NO
NO

HIGHEST_PLEDGE_AMOUNT6 Highest pledge amount for the year. NUMBER
FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

NO
NO

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 Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

NO
NO

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

NO
NO

TOTAL_ANT_MATCH_GIFT_ONE_PAY1 Total anticipated matching gifts for one-time payments for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY

NO
NO

TOTAL_ANT_MATCH_GIFT_ONE_PAY2 Total anticipated matching gifts for one-time payments for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY

NO
NO

TOTAL_ANT_MATCH_GIFT_ONE_PAY3 Total anticipated matching gifts for one-time payments for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY

NO
NO

TOTAL_ANT_MATCH_GIFT_ONE_PAY4 Total anticipated matching gifts for one-time payments for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY

NO
NO

TOTAL_ANT_MATCH_GIFT_ONE_PAY5 Total anticipated matching gifts for one-time payments for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY

NO
NO

TOTAL_ANT_MATCH_GIFT_ONE_PAY6 Total anticipated matching gifts for one-time payments for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY

NO
NO

TOTAL_ANT_MATCH_GIFT_PAY1 Total anticipated matching gifts for payments for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY

NO
NO

TOTAL_ANT_MATCH_GIFT_PAY2 Total anticipated matching gifts for payments for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY

NO
NO

TOTAL_ANT_MATCH_GIFT_PAY3 Total anticipated matching gifts for payments for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY

NO
NO

TOTAL_ANT_MATCH_GIFT_PAY4 Total anticipated matching gifts for payments for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY

NO
NO

TOTAL_ANT_MATCH_GIFT_PAY5 Total anticipated matching gifts for payments for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY

NO
NO

TOTAL_ANT_MATCH_GIFT_PAY6 Total anticipated matching gifts for payments for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY

NO
NO

TOTAL_GIVING1 Total giving for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

NO
NO

TOTAL_GIVING2 Total giving for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

NO
NO

TOTAL_GIVING3 Total giving for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

NO
NO

TOTAL_GIVING4 Total giving for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

NO
NO

TOTAL_GIVING5 Total giving for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

NO
NO

TOTAL_GIVING6 Total giving for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

NO
NO

TOTAL_NON_MATCH_GIFT_MEMO1 Non-matching gift memo total for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

NO
NO

TOTAL_NON_MATCH_GIFT_MEMO2 Non-matching gift memo total for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

NO
NO

TOTAL_NON_MATCH_GIFT_MEMO3 Non-matching gift memo total for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

NO
NO

TOTAL_NON_MATCH_GIFT_MEMO4 Non-matching gift memo total for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

NO
NO

TOTAL_NON_MATCH_GIFT_MEMO5 Non-matching gift memo total for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

NO
NO

TOTAL_NON_MATCH_GIFT_MEMO6 Non-matching gift memo total for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

NO
NO

TOTAL_NUMBER_OF_GIFTS1 Number of gifts for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

NO
NO

TOTAL_NUMBER_OF_GIFTS2 Number of gifts for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

NO
NO

TOTAL_NUMBER_OF_GIFTS3 Number of gifts for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

NO
NO

TOTAL_NUMBER_OF_GIFTS4 Number of gifts for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

NO
NO

TOTAL_NUMBER_OF_GIFTS5 Number of gifts for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

NO
NO

TOTAL_NUMBER_OF_GIFTS6 Number of gifts for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

NO
NO

TOTAL_NUMBER_OF_PLEDGES1 Total number of pledges for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

NO
NO

TOTAL_NUMBER_OF_PLEDGES2 Total number of pledges for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

NO
NO

TOTAL_NUMBER_OF_PLEDGES3 Total number of pledges for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

NO
NO

TOTAL_NUMBER_OF_PLEDGES4 Total number of pledges for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

NO
NO

TOTAL_NUMBER_OF_PLEDGES5 Total number of pledges for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

NO
NO

TOTAL_NUMBER_OF_PLEDGES6 Total number of pledges for the year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

NO
NO

TOTAL_PLEDGE_AMOUNT1 Total pledged amount for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

NO
NO

TOTAL_PLEDGE_AMOUNT2 Total pledged amount for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

NO
NO

TOTAL_PLEDGE_AMOUNT3 Total pledged amount for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

NO
NO

TOTAL_PLEDGE_AMOUNT4 Total pledged amount for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

NO
NO

TOTAL_PLEDGE_AMOUNT5 Total pledged amount for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

NO
NO

TOTAL_PLEDGE_AMOUNT6 Total pledged amount for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

NO
NO

TOTAL_PLEDGE_PAYMENTS1 Total pledge payments for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR

NO
NO

TOTAL_PLEDGE_PAYMENTS2 Total pledge payments for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR

NO
NO

TOTAL_PLEDGE_PAYMENTS3 Total pledge payments for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR

NO
NO

TOTAL_PLEDGE_PAYMENTS4 Total pledge payments for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR

NO
NO

TOTAL_PLEDGE_PAYMENTS5 Total pledge payments for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR

NO
NO

TOTAL_PLEDGE_PAYMENTS6 Total pledge payments for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR

NO
NO

TOTAL_REAL_MATCH_GIFT_ONE_PAY1 Total realized matching gifts for one-time payments for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY

NO
NO

TOTAL_REAL_MATCH_GIFT_ONE_PAY2 Total realized matching gifts for one-time payments for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY

NO
NO

TOTAL_REAL_MATCH_GIFT_ONE_PAY3 Total realized matching gifts for one-time payments for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY

NO
NO

TOTAL_REAL_MATCH_GIFT_ONE_PAY4 Total realized matching gifts for one-time payments for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY

NO
NO

TOTAL_REAL_MATCH_GIFT_ONE_PAY5 Total realized matching gifts for one-time payments for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY

NO
NO

TOTAL_REAL_MATCH_GIFT_ONE_PAY6 Total realized matching gifts for one-time payments for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY

NO
NO

TOTAL_REAL_MATCH_GIFT_PAY1 Total realized matching gifts for payments for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY

NO
NO

TOTAL_REAL_MATCH_GIFT_PAY2 Total realized matching gifts for payments for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY

NO
NO

TOTAL_REAL_MATCH_GIFT_PAY3 Total realized matching gifts for payments for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY

NO
NO

TOTAL_REAL_MATCH_GIFT_PAY4 Total realized matching gifts for payments for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY

NO
NO

TOTAL_REAL_MATCH_GIFT_PAY5 Total realized matching gifts for payments for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY

NO
NO

TOTAL_REAL_MATCH_GIFT_PAY6 Total realized matching gifts for payments for year. NUMBER
FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY

NO
NO

Ver: 9.2

Description	Uses data from the ANNUAL_GIVING reporting view. Displays annual giving details for donors with giving activity in any of the 6 most recent fiscal years. There are currently no associated display rules.
Key & Frequency	One row per entity.
Recommended Search Columns	ENTITY_UID ACTIVITY_DATE

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date record was inserted or updated.	DATE	NA	SYSDATE	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
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	NO NO NO	NO
FISCAL_YEAR1	Unique identifier or code for the fiscal year.	VARCHAR2(63)	ATVFISC	ATVFISC_CODE	NO	NO
FISCAL_YEAR2	Unique identifier or code for the fiscal year.	VARCHAR2(63)	ATVFISC	ATVFISC_CODE	NO	NO
FISCAL_YEAR3	Unique identifier or code for the fiscal year.	VARCHAR2(63)	ATVFISC	ATVFISC_CODE	NO	NO
FISCAL_YEAR4	Unique identifier or code for the fiscal year.	VARCHAR2(63)	ATVFISC	ATVFISC_CODE	NO	NO
FISCAL_YEAR5	Unique identifier or code for the fiscal year.	VARCHAR2(63)	ATVFISC	ATVFISC_CODE	NO	NO
FISCAL_YEAR6	Unique identifier or code for the fiscal year.	VARCHAR2(63)	ATVFISC	ATVFISC_CODE	NO	NO
HIGHEST_GIFT_AMOUNT1	Highest gift amount for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR	NO	NO
HIGHEST_GIFT_AMOUNT2	Highest gift amount for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR	NO	NO
HIGHEST_GIFT_AMOUNT3	Highest gift amount for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR	NO	NO
HIGHEST_GIFT_AMOUNT4	Highest gift amount for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR	NO	NO
HIGHEST_GIFT_AMOUNT5	Highest gift amount for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR	NO	NO
HIGHEST_GIFT_AMOUNT6	Highest gift amount for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR	NO	NO
HIGHEST_GIFT_AMOUNT_DATE1	Date of the highest gift amount for the year.	DATE	FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR	NO	NO
HIGHEST_GIFT_AMOUNT_DATE2	Date of the highest gift amount for the year.	DATE	FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR	NO	NO
HIGHEST_GIFT_AMOUNT_DATE3	Date of the highest gift amount for the year.	DATE	FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR	NO	NO
HIGHEST_GIFT_AMOUNT_DATE4	Date of the highest gift amount for the year.	DATE	FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR	NO	NO
HIGHEST_GIFT_AMOUNT_DATE5	Date of the highest gift amount for the year.	DATE	FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR	NO	NO
HIGHEST_GIFT_AMOUNT_DATE6	Date of the highest gift amount for the year.	DATE	FUNCTION	AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR	NO	NO
HIGHEST_PLEDGE_AMOUNT1	Highest pledge amount for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR	NO	NO
HIGHEST_PLEDGE_AMOUNT2	Highest pledge amount for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR	NO	NO
HIGHEST_PLEDGE_AMOUNT3	Highest pledge amount for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR	NO	NO
HIGHEST_PLEDGE_AMOUNT4	Highest pledge amount for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR	NO	NO
HIGHEST_PLEDGE_AMOUNT5	Highest pledge amount for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR	NO	NO
HIGHEST_PLEDGE_AMOUNT6	Highest pledge amount for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR	NO	NO
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	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
TOTAL_ANT_MATCH_GIFT_ONE_PAY1	Total anticipated matching gifts for one-time payments for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY	NO	NO
TOTAL_ANT_MATCH_GIFT_ONE_PAY2	Total anticipated matching gifts for one-time payments for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY	NO	NO
TOTAL_ANT_MATCH_GIFT_ONE_PAY3	Total anticipated matching gifts for one-time payments for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY	NO	NO
TOTAL_ANT_MATCH_GIFT_ONE_PAY4	Total anticipated matching gifts for one-time payments for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY	NO	NO
TOTAL_ANT_MATCH_GIFT_ONE_PAY5	Total anticipated matching gifts for one-time payments for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY	NO	NO
TOTAL_ANT_MATCH_GIFT_ONE_PAY6	Total anticipated matching gifts for one-time payments for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY	NO	NO
TOTAL_ANT_MATCH_GIFT_PAY1	Total anticipated matching gifts for payments for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY	NO	NO
TOTAL_ANT_MATCH_GIFT_PAY2	Total anticipated matching gifts for payments for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY	NO	NO
TOTAL_ANT_MATCH_GIFT_PAY3	Total anticipated matching gifts for payments for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY	NO	NO
TOTAL_ANT_MATCH_GIFT_PAY4	Total anticipated matching gifts for payments for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY	NO	NO
TOTAL_ANT_MATCH_GIFT_PAY5	Total anticipated matching gifts for payments for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY	NO	NO
TOTAL_ANT_MATCH_GIFT_PAY6	Total anticipated matching gifts for payments for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY	NO	NO
TOTAL_GIVING1	Total giving for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_GIVING_YEAR	NO	NO
TOTAL_GIVING2	Total giving for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_GIVING_YEAR	NO	NO
TOTAL_GIVING3	Total giving for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_GIVING_YEAR	NO	NO
TOTAL_GIVING4	Total giving for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_GIVING_YEAR	NO	NO
TOTAL_GIVING5	Total giving for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_GIVING_YEAR	NO	NO
TOTAL_GIVING6	Total giving for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_GIVING_YEAR	NO	NO
TOTAL_NON_MATCH_GIFT_MEMO1	Non-matching gift memo total for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO	NO	NO
TOTAL_NON_MATCH_GIFT_MEMO2	Non-matching gift memo total for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO	NO	NO
TOTAL_NON_MATCH_GIFT_MEMO3	Non-matching gift memo total for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO	NO	NO
TOTAL_NON_MATCH_GIFT_MEMO4	Non-matching gift memo total for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO	NO	NO
TOTAL_NON_MATCH_GIFT_MEMO5	Non-matching gift memo total for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO	NO	NO
TOTAL_NON_MATCH_GIFT_MEMO6	Non-matching gift memo total for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO	NO	NO
TOTAL_NUMBER_OF_GIFTS1	Number of gifts for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR	NO	NO
TOTAL_NUMBER_OF_GIFTS2	Number of gifts for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR	NO	NO
TOTAL_NUMBER_OF_GIFTS3	Number of gifts for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR	NO	NO
TOTAL_NUMBER_OF_GIFTS4	Number of gifts for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR	NO	NO
TOTAL_NUMBER_OF_GIFTS5	Number of gifts for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR	NO	NO
TOTAL_NUMBER_OF_GIFTS6	Number of gifts for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR	NO	NO
TOTAL_NUMBER_OF_PLEDGES1	Total number of pledges for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR	NO	NO
TOTAL_NUMBER_OF_PLEDGES2	Total number of pledges for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR	NO	NO
TOTAL_NUMBER_OF_PLEDGES3	Total number of pledges for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR	NO	NO
TOTAL_NUMBER_OF_PLEDGES4	Total number of pledges for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR	NO	NO
TOTAL_NUMBER_OF_PLEDGES5	Total number of pledges for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR	NO	NO
TOTAL_NUMBER_OF_PLEDGES6	Total number of pledges for the year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR	NO	NO
TOTAL_PLEDGE_AMOUNT1	Total pledged amount for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR	NO	NO
TOTAL_PLEDGE_AMOUNT2	Total pledged amount for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR	NO	NO
TOTAL_PLEDGE_AMOUNT3	Total pledged amount for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR	NO	NO
TOTAL_PLEDGE_AMOUNT4	Total pledged amount for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR	NO	NO
TOTAL_PLEDGE_AMOUNT5	Total pledged amount for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR	NO	NO
TOTAL_PLEDGE_AMOUNT6	Total pledged amount for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR	NO	NO
TOTAL_PLEDGE_PAYMENTS1	Total pledge payments for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR	NO	NO
TOTAL_PLEDGE_PAYMENTS2	Total pledge payments for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR	NO	NO
TOTAL_PLEDGE_PAYMENTS3	Total pledge payments for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR	NO	NO
TOTAL_PLEDGE_PAYMENTS4	Total pledge payments for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR	NO	NO
TOTAL_PLEDGE_PAYMENTS5	Total pledge payments for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR	NO	NO
TOTAL_PLEDGE_PAYMENTS6	Total pledge payments for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR	NO	NO
TOTAL_REAL_MATCH_GIFT_ONE_PAY1	Total realized matching gifts for one-time payments for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY	NO	NO
TOTAL_REAL_MATCH_GIFT_ONE_PAY2	Total realized matching gifts for one-time payments for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY	NO	NO
TOTAL_REAL_MATCH_GIFT_ONE_PAY3	Total realized matching gifts for one-time payments for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY	NO	NO
TOTAL_REAL_MATCH_GIFT_ONE_PAY4	Total realized matching gifts for one-time payments for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY	NO	NO
TOTAL_REAL_MATCH_GIFT_ONE_PAY5	Total realized matching gifts for one-time payments for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY	NO	NO
TOTAL_REAL_MATCH_GIFT_ONE_PAY6	Total realized matching gifts for one-time payments for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY	NO	NO
TOTAL_REAL_MATCH_GIFT_PAY1	Total realized matching gifts for payments for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY	NO	NO
TOTAL_REAL_MATCH_GIFT_PAY2	Total realized matching gifts for payments for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY	NO	NO
TOTAL_REAL_MATCH_GIFT_PAY3	Total realized matching gifts for payments for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY	NO	NO
TOTAL_REAL_MATCH_GIFT_PAY4	Total realized matching gifts for payments for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY	NO	NO
TOTAL_REAL_MATCH_GIFT_PAY5	Total realized matching gifts for payments for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY	NO	NO
TOTAL_REAL_MATCH_GIFT_PAY6	Total realized matching gifts for payments for year.	NUMBER	FUNCTION	AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY	NO	NO