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

Banner Operational Data Store
Reporting View Target: ANNUAL_GIVING

Description Contains giving history for all donors on a per fiscal year basis for any years in which donations were received or promised. Includes total number of gifts and pledges, total giving amounts, pledge payments received, highest gift amount, total matching gifts, gift society counts and more.
Key & Frequency One row per entity per fiscal year.
Recommended Search Columns ENTITY_UID, FISCAL_YEAR

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