Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACTIVITY_DATE
|
Date record was inserted or updated.
|
DATE
|
NA
|
SYSDATE
|
ADMINISTRATIVE_GROUP
|
Administrative-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.
|
VARCHAR2(63)
|
ATVFISC
|
ATVFISC_CODE
|
FISCAL_YEAR2
|
Unique identifier or code for the fiscal year.
|
VARCHAR2(63)
|
ATVFISC
|
ATVFISC_CODE
|
FISCAL_YEAR3
|
Unique identifier or code for the fiscal year.
|
VARCHAR2(63)
|
ATVFISC
|
ATVFISC_CODE
|
FISCAL_YEAR4
|
Unique identifier or code for the fiscal year.
|
VARCHAR2(63)
|
ATVFISC
|
ATVFISC_CODE
|
FISCAL_YEAR5
|
Unique identifier or code for the fiscal year.
|
VARCHAR2(63)
|
ATVFISC
|
ATVFISC_CODE
|
FISCAL_YEAR6
|
Unique identifier or code for the fiscal year.
|
VARCHAR2(63)
|
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
|