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

SGHE 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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACTIVITY_DATE Date record was inserted or updated    

NA

SYSDATE

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

NA

NA

 
ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity.    

AGBPLDG

AGRPMEM

APRCHIS

AGBPLDG_PSTA_CODE

AGRPMEM_MEMO_PIDM

APRCHIS_PIDM

 
FISCAL_YEAR1 Unique identifier or code for the fiscal year.    

ATVFISC

ATVFISC_CODE

 
FISCAL_YEAR2 Unique identifier or code for the fiscal year.    

ATVFISC

ATVFISC_CODE

 
FISCAL_YEAR3 Unique identifier or code for the fiscal year.    

ATVFISC

ATVFISC_CODE

 
FISCAL_YEAR4 Unique identifier or code for the fiscal year.    

ATVFISC

ATVFISC_CODE

 
FISCAL_YEAR5 Unique identifier or code for the fiscal year.    

ATVFISC

ATVFISC_CODE

 
FISCAL_YEAR6 Unique identifier or code for the fiscal year.    

ATVFISC

ATVFISC_CODE

 
HIGHEST_GIFT_AMOUNT1 Highest gift amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

 
HIGHEST_GIFT_AMOUNT2 Highest gift amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

 
HIGHEST_GIFT_AMOUNT3 Highest gift amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

 
HIGHEST_GIFT_AMOUNT4 Highest gift amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

 
HIGHEST_GIFT_AMOUNT5 Highest gift amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

 
HIGHEST_GIFT_AMOUNT6 Highest gift amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

 
HIGHEST_GIFT_AMOUNT_DATE1 Date of the highest gift amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

 
HIGHEST_GIFT_AMOUNT_DATE2 Date of the highest gift amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

 
HIGHEST_GIFT_AMOUNT_DATE3 Date of the highest gift amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

 
HIGHEST_GIFT_AMOUNT_DATE4 Date of the highest gift amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

 
HIGHEST_GIFT_AMOUNT_DATE5 Date of the highest gift amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

 
HIGHEST_GIFT_AMOUNT_DATE6 Date of the highest gift amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

 
HIGHEST_PLEDGE_AMOUNT1 Highest pledge amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

 
HIGHEST_PLEDGE_AMOUNT2 Highest pledge amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

 
HIGHEST_PLEDGE_AMOUNT3 Highest pledge amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

 
HIGHEST_PLEDGE_AMOUNT4 Highest pledge amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

 
HIGHEST_PLEDGE_AMOUNT5 Highest pledge amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

 
HIGHEST_PLEDGE_AMOUNT6 Highest pledge amount for the year.    

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.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

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

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.    

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.    

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.    

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.    

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.    

FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_ONE_PAY

 
TOTAL_ANT_MATCH_GIFT_PAY1 Total anticipated matching gifts for payments for the year.    

FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY

 
TOTAL_ANT_MATCH_GIFT_PAY2 Total anticipated matching gifts for payments for the year.    

FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY

 
TOTAL_ANT_MATCH_GIFT_PAY3 Total anticipated matching gifts for payments for the year.    

FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY

 
TOTAL_ANT_MATCH_GIFT_PAY4 Total anticipated matching gifts for payments for the year.    

FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY

 
TOTAL_ANT_MATCH_GIFT_PAY5 Total anticipated matching gifts for payments for the year.    

FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY

 
TOTAL_ANT_MATCH_GIFT_PAY6 Total anticipated matching gifts for payments for the year.    

FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY

 
TOTAL_GIVING1 Total giving for the year.    

FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

 
TOTAL_GIVING2 Total giving for the year.    

FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

 
TOTAL_GIVING3 Total giving for the year.    

FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

 
TOTAL_GIVING4 Total giving for the year.    

FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

 
TOTAL_GIVING5 Total giving for the year.    

FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

 
TOTAL_GIVING6 Total giving for the year.    

FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

 
TOTAL_NON_MATCH_GIFT_MEMO1 Non-matching gift memo total for the year.    

FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

 
TOTAL_NON_MATCH_GIFT_MEMO2 Non-matching gift memo total for the year.    

FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

 
TOTAL_NON_MATCH_GIFT_MEMO3 Non-matching gift memo total for the year.    

FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

 
TOTAL_NON_MATCH_GIFT_MEMO4 Non-matching gift memo total for the year.    

FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

 
TOTAL_NON_MATCH_GIFT_MEMO5 Non-matching gift memo total for the year.    

FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

 
TOTAL_NON_MATCH_GIFT_MEMO6 Non-matching gift memo total for the year.    

FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

 
TOTAL_NUMBER_OF_GIFTS1 Number of gifts for year.    

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

 
TOTAL_NUMBER_OF_GIFTS2 Number of gifts for year.    

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

 
TOTAL_NUMBER_OF_GIFTS3 Number of gifts for year.    

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

 
TOTAL_NUMBER_OF_GIFTS4 Number of gifts for year.    

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

 
TOTAL_NUMBER_OF_GIFTS5 Number of gifts for year.    

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

 
TOTAL_NUMBER_OF_GIFTS6 Number of gifts for year.    

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

 
TOTAL_NUMBER_OF_PLEDGES1 Total number of pledges for the year.    

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

 
TOTAL_NUMBER_OF_PLEDGES2 Total number of pledges for the year.    

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

 
TOTAL_NUMBER_OF_PLEDGES3 Total number of pledges for the year.    

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

 
TOTAL_NUMBER_OF_PLEDGES4 Total number of pledges for the year.    

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

 
TOTAL_NUMBER_OF_PLEDGES5 Total number of pledges for the year.    

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

 
TOTAL_NUMBER_OF_PLEDGES6 Total number of pledges for the year.    

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

 
TOTAL_PLEDGE_AMOUNT1 Total pledged amount for year.    

FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

 
TOTAL_PLEDGE_AMOUNT2 Total pledged amount for year.    

FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

 
TOTAL_PLEDGE_AMOUNT3 Total pledged amount for year.    

FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

 
TOTAL_PLEDGE_AMOUNT4 Total pledged amount for year.    

FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

 
TOTAL_PLEDGE_AMOUNT5 Total pledged amount for year.    

FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

 
TOTAL_PLEDGE_AMOUNT6 Total pledged amount for year.    

FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

 
TOTAL_PLEDGE_PAYMENTS1 Total pledge payments for year.    

FUNCTION

AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR

 
TOTAL_PLEDGE_PAYMENTS2 Total pledge payments for year.    

FUNCTION

AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR

 
TOTAL_PLEDGE_PAYMENTS3 Total pledge payments for year.    

FUNCTION

AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR

 
TOTAL_PLEDGE_PAYMENTS4 Total pledge payments for year.    

FUNCTION

AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR

 
TOTAL_PLEDGE_PAYMENTS5 Total pledge payments for year.    

FUNCTION

AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR

 
TOTAL_PLEDGE_PAYMENTS6 Total pledge payments for year.    

FUNCTION

AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR

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

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.    

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.    

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.    

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.    

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.    

FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY

 
TOTAL_REAL_MATCH_GIFT_PAY1 Total realized matching gifts for payments for year.    

FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY

 
TOTAL_REAL_MATCH_GIFT_PAY2 Total realized matching gifts for payments for year.    

FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY

 
TOTAL_REAL_MATCH_GIFT_PAY3 Total realized matching gifts for payments for year.    

FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY

 
TOTAL_REAL_MATCH_GIFT_PAY4 Total realized matching gifts for payments for year.    

FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY

 
TOTAL_REAL_MATCH_GIFT_PAY5 Total realized matching gifts for payments for year.    

FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY

 
TOTAL_REAL_MATCH_GIFT_PAY6 Total realized matching gifts for payments for year.    

FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY

 


Ver: 8.3