DESIGNATION_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. |
|
APRDHIS |
APRDHIS_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 |
| DESIGNATION |
|
|
APRDHIS |
APRDHIS_DESG |
UNKNOWN |
| DESIGNATION_NAME |
|
|
ADBDESG |
ADBDESG_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. |
|
APRDHIS |
APRDHIS_FISC_CODE |
UNKNOWN |
| FISCAL_YEAR_DESC |
|
|
ATVFISC |
ATVFISC_DESC |
UNKNOWN |
| DESIGNATION_GIVING |
|
|
FUNCTION |
F_DESIGNATION_GIVING |
UNKNOWN |
| AMOUNT_PLEDGED |
AMOUNT OF THE PLEDGE PAID. |
|
APRDHIS |
APRDHIS_AMT_PLEDGED |
UNKNOWN |
| AMOUNT_PLEDGE_PAYMENT |
AMOUNT OF THE PLEDGE PAID. |
|
APRDHIS |
APRDHIS_AMT_PLEDGED_PAID |
UNKNOWN |
| AMOUNT_GIFT |
AMOUNT OF THE GIFT. |
|
APRDHIS |
APRDHIS_AMT_GIFT |
UNKNOWN |
| AMOUNT_MATCHING_GIFT |
AMOUNT OF A MATCHING GIFT. |
|
FUNCTION |
F_DESIGNATION_MATCHING_GIFT |
UNKNOWN |
| AMOUNT_MEMO_CREDIT |
AMOUNT RECORDED AS MEMO CREDIT. |
|
FUNCTION |
F_DESIGNATION_MEMO_CREDIT |
UNKNOWN |
| DESG_TYPE |
|
|
ADBDESG |
ADBDESG_DSTP_CODE |
UNKNOWN |
| DESG_TYPE_DESC |
|
|
ATVDSTP |
ATVDSTP_DESC |
UNKNOWN |
| DESG_COLLEGE |
FIRST LAYER OF THE INSTITUTION ORGANIZATION. |
|
ADBDESG |
ADBDESG_COLL_CODE |
UNKNOWN |
| DESG_COLLEGE_DESC |
NAME OF THE FIRST LAYER (COLLEGE) OF THE INSTITUTION ORGANIZATION. |
|
STVCOLL |
STVCOLL_DESC |
UNKNOWN |
| DESG_VSE |
|
|
ADBDESG |
ADBDESG_CFAE_CODE |
UNKNOWN |
| DESG_VSE_DESC |
|
|
ATVCFAE |
ATVCFAE_DESC |
UNKNOWN |
| AMOUNT_MULTIPLE_CREDIT |
AMOUNT RECORDED FOR A MULTIPLE CREDIT GIFT. |
|
FUNCTION |
NOT AVAILABLE |
UNKNOWN |