RETURN TO COMPOSITE VIEW REPORTS LIST
Advancement Composite View Reports

SGHE 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.

Target Column Business Definition Database Data Type Source Name Source Column
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

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

NA

NA

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

AGRPMEM

APRCHIS

AGRPMEM_MEMO_PIDM

APRCHIS_PIDM

FISCAL_YEAR Unique identifier or code for the fiscal year. NUMBER(4)

AGBPLDG

APRCHIS

AGBPLDG_FISC_CODE

APRCHIS_FISC_CODE

FISCAL_YEAR_DESC Fiscal year code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

HIGHEST_GIFT_AMOUNT Highest gift amount for the year. NUMBER

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

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

FUNCTION

AOKODSF.F_GET_HIGH_GIFT_AMOUNT_YEAR

HIGHEST_PLEDGE_AMOUNT Highest pledge amount for the year. NUMBER

FUNCTION

AOKODSF.F_GET_HIGH_PLEDGE_AMOUNT_YEAR

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

NA

NA

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

NA

NA

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

FUNCTION

AOKODSF.F_GET_TOT_ANT_MAT_GIFT_PAY

TOTAL_GIVING Total giving for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_GIVING_YEAR

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

FUNCTION

AOKODSF.F_GET_TOT_NON_MAT_GIFT_MEMO

TOTAL_NUMBER_OF_GIFTS Number of gifts for year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_GIFT_YEAR

TOTAL_NUMBER_OF_PLEDGES Total number of pledges for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_NUMBER_PLEDGE_YEAR

TOTAL_PLEDGE_AMOUNT Total pledged amount for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_PLEDGED_AMOUNT_YEAR

TOTAL_PLEDGE_PAYMENTS Total pledge payments for the year. NUMBER

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. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_ONE_PAY

TOTAL_REAL_MATCH_GIFT_PAY Total realized matching gifts for payments for the year. NUMBER

FUNCTION

AOKODSF.F_GET_TOT_RLZ_MAT_GIFT_PAY

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

NA

NA



Ver: 3.1