RETURN TO REPORTING VIEW REPORTS LIST
Advancement Reporting View Reports

SGHE 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
ACTIVITY_DATE Date record was inserted or updated DATE

NA

SYSDATE

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

NA

NA

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 Unique identifier or code for the fiscal year. NUMBER

ATVFISC

ATVFISC_CODE

FISCAL_YEAR2 Unique identifier or code for the fiscal year. NUMBER

ATVFISC

ATVFISC_CODE

FISCAL_YEAR3 Unique identifier or code for the fiscal year. NUMBER

ATVFISC

ATVFISC_CODE

FISCAL_YEAR4 Unique identifier or code for the fiscal year. NUMBER

ATVFISC

ATVFISC_CODE

FISCAL_YEAR5 Unique identifier or code for the fiscal year. NUMBER

ATVFISC

ATVFISC_CODE

FISCAL_YEAR6 Unique identifier or code for the fiscal year. NUMBER

ATVFISC

ATVFISC_CODE

HIGHEST_GIFT_AMOUNT1 Highest gift amount for the year. NUMBER

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

HIGHEST_GIFT_AMOUNT2 Highest gift amount for the year. NUMBER

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

HIGHEST_GIFT_AMOUNT3 Highest gift amount for the year. NUMBER

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

HIGHEST_GIFT_AMOUNT4 Highest gift amount for the year. NUMBER

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

HIGHEST_GIFT_AMOUNT5 Highest gift amount for the year. NUMBER

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

HIGHEST_GIFT_AMOUNT6 Highest gift amount for the year. NUMBER

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

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

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

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

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

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

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

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

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

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

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

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

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

HIGHEST_PLEDGE_AMOUNT1 Highest pledge amount for the year. NUMBER

FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

HIGHEST_PLEDGE_AMOUNT2 Highest pledge amount for the year. NUMBER

FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

HIGHEST_PLEDGE_AMOUNT3 Highest pledge amount for the year. NUMBER

FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

HIGHEST_PLEDGE_AMOUNT4 Highest pledge amount for the year. NUMBER

FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

HIGHEST_PLEDGE_AMOUNT5 Highest pledge amount for the year. NUMBER

FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

HIGHEST_PLEDGE_AMOUNT6 Highest pledge amount for the year. NUMBER

FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

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 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 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 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 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 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 for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY

TOTAL_ANT_MATCH_GIFT_PAY1 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 payments for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY

TOTAL_ANT_MATCH_GIFT_PAY3 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 payments for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY

TOTAL_ANT_MATCH_GIFT_PAY5 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 payments for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY

TOTAL_GIVING1 Total giving for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

TOTAL_GIVING2 Total giving for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

TOTAL_GIVING3 Total giving for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

TOTAL_GIVING4 Total giving for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

TOTAL_GIVING5 Total giving for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

TOTAL_GIVING6 Total giving for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

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

FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

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

FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

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

FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

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

FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

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

FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

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

FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

TOTAL_NUMBER_OF_GIFTS1 Number of gifts for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

TOTAL_NUMBER_OF_GIFTS2 Number of gifts for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

TOTAL_NUMBER_OF_GIFTS3 Number of gifts for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

TOTAL_NUMBER_OF_GIFTS4 Number of gifts for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

TOTAL_NUMBER_OF_GIFTS5 Number of gifts for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

TOTAL_NUMBER_OF_GIFTS6 Number of gifts for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

TOTAL_NUMBER_OF_PLEDGES1 Total number of pledges for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

TOTAL_NUMBER_OF_PLEDGES2 Total number of pledges for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

TOTAL_NUMBER_OF_PLEDGES3 Total number of pledges for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

TOTAL_NUMBER_OF_PLEDGES4 Total number of pledges for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

TOTAL_NUMBER_OF_PLEDGES5 Total number of pledges for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

TOTAL_NUMBER_OF_PLEDGES6 Total number of pledges for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

TOTAL_PLEDGE_AMOUNT1 Total pledged amount for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

TOTAL_PLEDGE_AMOUNT2 Total pledged amount for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

TOTAL_PLEDGE_AMOUNT3 Total pledged amount for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

TOTAL_PLEDGE_AMOUNT4 Total pledged amount for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

TOTAL_PLEDGE_AMOUNT5 Total pledged amount for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

TOTAL_PLEDGE_AMOUNT6 Total pledged amount for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

TOTAL_PLEDGE_PAYMENTS1 Total pledge payments for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR

TOTAL_PLEDGE_PAYMENTS2 Total pledge payments for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR

TOTAL_PLEDGE_PAYMENTS3 Total pledge payments for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR

TOTAL_PLEDGE_PAYMENTS4 Total pledge payments for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR

TOTAL_PLEDGE_PAYMENTS5 Total pledge payments for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR

TOTAL_PLEDGE_PAYMENTS6 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 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 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 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 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 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 for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY

TOTAL_REAL_MATCH_GIFT_PAY1 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 payments for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY

TOTAL_REAL_MATCH_GIFT_PAY3 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 payments for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY

TOTAL_REAL_MATCH_GIFT_PAY5 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 payments for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY



Ver: 3.1