GIFT_MEMO - 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. |
|
AGRGMMO |
AGRGMMO_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 |
| MEMO_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
AGRGMMO |
AGRGMMO_XREF_PIDM |
UNKNOWN |
| GIFT_NUMBER |
|
|
AGRGMMO |
AGRGMMO_GIFT_NO |
UNKNOWN |
| PLEDGE_NUMBER |
|
|
AGRGMMO |
AGRGMMO_PLEDGE_NO |
UNKNOWN |
| CAMPAIGN |
|
|
AGRGMMO |
AGRGMMO_CAMPAIGN |
UNKNOWN |
| CAMPAIGN_NAME |
|
|
AFBCAMP |
AFBCAMP_NAME |
UNKNOWN |
| DESIGNATION |
|
|
AGRGMMO |
AGRGMMO_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. |
|
AGBGIFT |
AGBGIFT_FISC_CODE |
UNKNOWN |
| FISCAL_YEAR_DESC |
|
|
ATVFISC |
ATVFISC_DESC |
UNKNOWN |
| GIFT_DATE |
|
|
AGBGIFT |
AGBGIFT_GIFT_DATE |
UNKNOWN |
| GIFT_TYPE |
|
|
AGBGIFT |
AGBGIFT_GIFT_CODE |
UNKNOWN |
| GIFT_TYPE_DESC |
|
|
ATVGIFT |
ATVGIFT_DESC |
UNKNOWN |
| GIFT_CLASS |
|
|
AGBGIFT |
AGBGIFT_GCLS_CODE |
UNKNOWN |
| GIFT_CLASS_DESC |
|
|
ATVGCLS |
ATVGCLS_DESC |
UNKNOWN |
| GIFT_AMOUNT |
|
|
AGRGDES |
AGRGDES_AMT |
UNKNOWN |
| GIFT_CREDIT |
|
|
AGRGMMO |
AGRGMMO_CREDIT |
UNKNOWN |
| GIFT_VEHICLE |
|
|
AGBGIFT |
AGBGIFT_PGVE_CODE |
UNKNOWN |
| GIFT_VEHICLE_DESC |
|
|
ATVPGVE |
ATVPGVE_DESC |
UNKNOWN |
| CAMPAIGN_TYPE |
|
|
AFBCAMP |
AFBCAMP_CMTP_CODE |
UNKNOWN |
| CAMPAIGN_TYPE_DESC |
|
|
ATVCMTP |
ATVCMTP_DESC |
UNKNOWN |
| MEMO_MATCH_GIFT_IND |
|
|
FUNCTION |
F_MEMO_DETAIL_MATCHING_GIFT |
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 |
| PAYMENT_3PP_AMOUNT |
|
|
AGRGMMO |
AGRGMMO_3PP_AMT |
UNKNOWN |
| PAYMENT_3PP_PLEDGE_NO |
|
|
AGRGMMO |
AGRGMMO_3PP_PLEDGE_NO |
UNKNOWN |