PROSPECT_INFO - 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. |
|
AMRINFO |
AMRINFO_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 |
| REFERENCE |
|
|
AMRINFO |
AMRINFO_REFR_CODE |
UNKNOWN |
| REFERENCE_DESC |
|
|
ATVREFR |
ATVREFR_DESC |
UNKNOWN |
| PROSPECT_STATUS |
|
|
AMRINFO |
AMRINFO_STATUS |
UNKNOWN |
| PROSPECT_AMOUNT |
|
|
AMRINFO |
AMRINFO_PROSP_RATE |
UNKNOWN |
| TARGET_ASK_DATE |
|
|
AMRINFO |
AMRINFO_TARGET_ASK_DATE |
UNKNOWN |
| PRIMARY_STAFF_ASSIGN_TYPE |
|
|
AMRSTAF |
AMRSTAF_STFT_CODE |
UNKNOWN |
| PRIMARY_STAFF_ASSIGN_TYPE_DESC |
|
|
ATVSTFT |
ATVSTFT_DESC |
UNKNOWN |
| PRIMARY_STAFF_ASSIGN_IDEN |
|
|
AMRSTAF |
AMRSTAF_IDEN_CODE |
UNKNOWN |
| PRIMARY_STAFF_ASSIGN_IDEN_NAME |
|
|
GURIDEN |
GURIDEN_DESC |
UNKNOWN |
| STAFF_ASSIGNMENT_COUNT |
|
|
FUNCTION |
NOT AVAILABLE |
UNKNOWN |
| ADVANCEMENT_RATING_COUNT |
NUMBER OF ADVANCEMENT RATINGS RECORDED FOR THIS CONSTITUENT OR CONSTITUENT ENTITY. |
|
MAKFUNC |
F_ADVANCEMENT_RATING_COUNT |
UNKNOWN |
| CONSTITUENT_CONTACT_COUNT |
|
|
MAKFUNC |
F_COUNT_CONS_CONTACT |
UNKNOWN |
| PREF_GEO_REGION_ADDR_TYPE |
|
|
APBCONS |
APBCONS_ATYP_CODE_GEOR |
UNKNOWN |
| PREF_GEO_REGION_ADDR_TYPE_DESC |
|
|
STVATYP |
STVATYP_DESC |
UNKNOWN |
| PREF_GEOGRAPHIC_REGION_COUNT |
|
|
FUNCTION |
? |
UNKNOWN |