CAMPAIGN_GIVING_HISTORY - 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. |
|
APRCHIS |
APRCHIS_PIDM |
UNKNOWN |
| ENTITY_IND |
ENTITY INDICATOR IS SET TO 'P' IF IT IS FOR A CONSTITUENT RECORD AND SET TO 'O' IF IT IS AN ORGANIZATION_CONSTITUENT RECORD. |
|
DECODE |
WITHIN ODS |
UNKNOWN |
| CAMPAIGN |
|
|
APRCHIS |
APRCHIS_CAMPAIGN |
UNKNOWN |
| CAMPAIGN_NAME |
|
|
AFBCAMP |
AFBCAMP_NAME |
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. |
|
APRCHIS |
APRCHIS_FISC_CODE |
UNKNOWN |
| FISCAL_YEAR_DESC |
|
|
ATVFISC |
ATVFISC_DESC |
UNKNOWN |
| CAMPAIGN_GIVING |
|
|
FUNCTION |
F_CAMPAIGN_GIVING |
UNKNOWN |
| AMOUNT_PLEDGED |
AMOUNT OF THE PLEDGE PAID. |
|
APRCHIS |
APRCHIS_AMT_PLEDGED |
UNKNOWN |
| AMOUNT_PLEDGE_PAYMENT |
AMOUNT OF THE PLEDGE PAID. |
|
APRCHIS |
APRCHIS_AMT_PLEDGED_PAID |
UNKNOWN |
| AMOUNT_GIFT |
AMOUNT OF THE GIFT. |
|
APRCHIS |
APRCHIS_AMT_GIFT |
UNKNOWN |
| AMOUNT_MATCHING_GIFT |
AMOUNT OF A MATCHING GIFT. |
|
FUNCTION |
F_CAMPAIGN_MATCHING_GIFT |
UNKNOWN |
| AMOUNT_MEMO_CREDIT |
AMOUNT RECORDED AS MEMO CREDIT. |
|
FUNCTION |
F_CAMPAIGN_MEMO_CREDIT |
UNKNOWN |
| CAMPAIGN_TYPE |
|
|
AFBCAMP |
AFBCAMP_CMTP_CODE |
UNKNOWN |
| CAMPAIGN_TYPE_DESC |
|
|
ATVCMTP |
ATVCMTP_DESC |
UNKNOWN |
| AMOUNT_MULTIPLE_CREDIT |
AMOUNT RECORDED FOR A MULTIPLE CREDIT GIFT. |
|
FUNCTION |
NOT AVAILABLE |
UNKNOWN |