Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Advancement Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AA_ANNUAL_GIVING

Description Source composite view contains summary detail for all giving per fiscal year for persons and organizations.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

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

NA

NA

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

AGRPMEM

APRCHIS

AGRPMEM_MEMO_PIDM

APRCHIS_PIDM

 
FISCAL_YEAR Unique identifier or code for the fiscal year.    

AGBPLDG

APRCHIS

AGBPLDG_FISC_CODE

APRCHIS_FISC_CODE

 
FISCAL_YEAR_DESC Fiscal year code description.    

ATVFISC

ATVFISC_DESC

 
HIGHEST_GIFT_AMOUNT Highest gift amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

 
HIGHEST_GIFT_AMOUNT_DATE Date of the highest gift amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

 
HIGHEST_PLEDGE_AMOUNT Highest pledge amount for the year.    

FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

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

NA

NA

 
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
TOTAL_ANT_MATCH_GIFT_ONE_PAY 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_PAY Total anticipated matching gifts for payments for the year.    

FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY

 
TOTAL_GIVING Total giving for the year.    

FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

 
TOTAL_NON_MATCH_GIFT_MEMO Non-matching gift memo total for the year.    

FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

 
TOTAL_NUMBER_OF_GIFTS Number of gifts for year.    

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

 
TOTAL_NUMBER_OF_PLEDGES Total number of pledges for the year.    

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

 
TOTAL_PLEDGE_AMOUNT Total pledged amount for the year.    

FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

 
TOTAL_PLEDGE_PAYMENTS Total pledge payments for the year.    

FUNCTION

AOKODSF.F_GET_TOT_PLEDGE_PAYMENT_YEAR

 
TOTAL_REAL_MATCH_GIFT_ONE_PAY Total realized matching gifts for one-time payments for the year.    

FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY

 
TOTAL_REAL_MATCH_GIFT_PAY Total realized matching gifts for payments for the year.    

FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY

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

NA

NA

 


Ver: 8.3