ANNUAL_GIVING - Report
| Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
| ENTITY_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
APBCONS |
APBCONS_PIDM |
UNKNOWN |
| ENTITY_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
APBORGN |
AOBORGN_PIDM |
UNKNOWN |
| FISCAL_YEAR |
A UNIQUE NUMERIC IDENTIFIER CODE FOR THE FISCAL YEAR BEING DEFINED. FUNCTION RETURNS A FOUR-DIGIT YEAR WHEN SUPPLIED A TWO-DIGIT YEAR. |
|
ATVFISC |
ATVFISC_CODE |
UNKNOWN |
| FISCAL_YEAR_DESC |
|
|
ATVFISC |
ATVFISC_DESC |
UNKNOWN |
| TOTAL_NUMBER_OF_GIFTS |
|
|
FUNCTION |
F_NUMBER_GIFT_YEAR |
UNKNOWN |
| TOTAL_GIVING |
|
|
FUNCTION |
F_TOTAL_GIVING_YEAR |
UNKNOWN |
| HIGHEST_GIFT_AMOUNT |
|
|
FUNCTION |
F_HIGH_GIFT_AMOUNT_YEAR |
UNKNOWN |
| HIGHEST_GIFT_AMOUNT_DATE |
|
|
FUNCTION |
F_HIGH_GIFT_AMOUNT_YEAR |
UNKNOWN |
| TOTAL_ANT_MATCH_GIFT_PAY |
|
|
FUNCTION |
F_TOTAL_ANT_MAT_GIFT_PAY |
UNKNOWN |
| TOTAL_REAL_MATCH_GIFT_PAY |
|
|
FUNCTION |
F_TOTAL_RLZ_MAT_GIFT_PAY |
UNKNOWN |
| TOTAL_ANT_MATCH_GIFT_ONE_PAY |
|
|
FUNCTION |
F_TOTAL_ANT_MAT_GIFT_ONE_PAY |
UNKNOWN |
| TOTAL_REAL_MATCH_GIFT_ONE_PAY |
|
|
FUNCTION |
F_TOTAL_RLZ_MAT_GIFT_ONE_PAY |
UNKNOWN |
| TOTAL_NON_MATCH_GIFT_MEMO |
|
|
FUNCTION |
F_TOTAL_NON_MAT_GIFT_MEMO |
UNKNOWN |
| TOTAL_NUMBER_OF_PLEDGES |
|
|
FUNCTION |
F_NUMBER_PLEDGE_YEAR |
UNKNOWN |
| TOTAL_PLEDGE_AMOUNT |
|
|
FUNCTION |
F_TOTAL_PLEDGED_AMOUNT_YEAR |
UNKNOWN |
| HIGHEST_PLEDGE_AMOUNT |
|
|
FUNCTION |
F_HIGH_PLEDGE_AMOUNT_YEAR |
UNKNOWN |
| TOTAL_PLEDGE_PAYMENTS |
|
|
FUNCTION |
F_TOTAL_PLEDGE_PAYMENT_YEAR |
UNKNOWN |
| GIFT_SOCIETY_COUNT |
NUMBER OF GIFT SOCIETIES ASSOCIATED WITH THE PERSON. |
|
MAKFUNC |
F_COUNT_GIFT_SOCIETY |
UNKNOWN |