Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ACTIVE_PROSPECT_IND
|
Prospect status active indicator determining if the status is active (Y)es, or inactive (N)o.
|
VARCHAR2(1)
|
ATVPRST
|
ATVPRST_ACTIVE_IND
|
NO
|
NO
|
ACTIVITY_DATE
|
Date that information for this record in the table was entered or last updated.
|
DATE
|
AMRINFO
|
AMRINFO_ACTIVITY_DATE
|
NO
|
NO
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
ADVANCEMENT_RATING_COUNT
|
Count of the recruitment ratings recorded for this person.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_ADVANCEMENT_RATING_COUNT
|
NO
|
NO
|
ALLOW_WEB_GIFT_IND
|
Determines if gifts from this prospect will be accepted from the Web. (Y)es accepted from the web or (N)ot accepted from the web.
|
VARCHAR2(1)
|
CALCULATION
|
NVL(AMRINFO_WEB_GIFT_IND,'N')
|
NO
|
NO
|
ALLOW_WEB_PLEDGE_IND
|
Determines if pledges from this prospect will be accepted from the Web. (Y)es accepted from the web or (N)ot accepted from the web.
|
VARCHAR2(1)
|
CALCULATION
|
NVL(AMRINFO_WEB_PLDG_IND,'N')
|
NO
|
NO
|
CONSTITUENT_CONTACT_COUNT
|
Count of the number of counts have been made by the institution and recorded for this constituent.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_COUNT_CONS_CONTACT
|
NO
|
NO
|
ENTITY_IND
|
Indicates whether the entity is a person or an organization.
|
VARCHAR2(1)
|
CONSTANT CONSTANT
|
'O' 'P'
|
NO NO
|
NO
|
ENTITY_UID
|
System generated, unique, internal identification number assigned to this person or organization entity.
|
NUMBER
|
AMRINFO
|
AMRINFO_PIDM
|
NO
|
NO
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
NAME
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
PREF_GEOGRAPHIC_REGION_COUNT
|
Count of geographic regions associated with this address.
|
NUMBER
|
FUNCTION
|
MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS
|
NO
|
NO
|
PREF_GEO_REGION_ADDR_TYPE
|
Address type of the address to be used as the preferred geographic region address.
|
VARCHAR2(63)
|
APBCONS
|
APBCONS_ATYP_CODE_GEOR
|
NO
|
NO
|
PREF_GEO_REGION_ADDR_TYPE_DESC
|
Preferred geographic region address type.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PRIMARY_STAFF_ASSIGN_IDEN
|
Primary staff identification code.
|
VARCHAR2(63)
|
AMRSTAF
|
AMRSTAF_IDEN_CODE
|
NO
|
NO
|
PRIMARY_STAFF_ASSIGN_IDEN_NAME
|
Name of the primary staff identification code.
|
VARCHAR2(255)
|
GURIDEN
|
GURIDEN_DESC
|
NO
|
NO
|
PRIMARY_STAFF_ASSIGN_TYPE
|
Primary staff type code.
|
VARCHAR2(63)
|
AMRSTAF
|
AMRSTAF_STFT_CODE
|
NO
|
NO
|
PRIMARY_STAFF_ASSIGN_TYPE_DESC
|
Primary staff type code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
PROSPECT_AMOUNT
|
Manually entered or system calculated prospect amount.
|
NUMBER
|
AMRINFO
|
AMRINFO_PROSP_RATE
|
NO
|
NO
|
PROSPECT_AMOUNT_ENTRY_DATE
|
Date the rating amount for the prospect was calculated or entered.
|
DATE
|
AMRINFO
|
AMRINFO_RATE_ENTRY_DATE
|
NO
|
NO
|
PROSPECT_AMOUNT_METHOD
|
Determines the method for calculating the prospect amount.
|
VARCHAR2(63)
|
AMRINFO
|
AMRINFO_SYS_IND
|
NO
|
NO
|
PROSPECT_AMOUNT_METHOD_DESC
|
Prospect amount method description. Explains how the prospect asking amount is calculated. If the value is 'N', the amount is manually entered and cannot be overridden. If the value is 'S', the amount is system calculated either from a primary indicated rate, or weighted-average of rate values.
|
VARCHAR2(255)
|
FUNCTION
|
CASE WHEN AMRINFO_SYS_IND
|
NO
|
NO
|
PROSPECT_STATUS
|
Identifies the reference assessment of the current state of the prospect.
|
VARCHAR2(63)
|
AMRINFO
|
AMRINFO_STATUS
|
NO
|
NO
|
PROSPECT_STATUS_DESC
|
Status description.
|
VARCHAR2(255)
|
ATVPRST
|
ATVPRST_DESC
|
NO
|
NO
|
REFERENCE
|
Reference code.
|
VARCHAR2(63)
|
AMRINFO
|
AMRINFO_REFR_CODE
|
NO
|
NO
|
REFERENCE_COMMENT
|
Prospect reference comment.
|
VARCHAR2(255)
|
AMRINFO
|
AMRINFO_REFERENCE
|
NO
|
NO
|
REFERENCE_DESC
|
Reference code description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
SOLICITOR_IND
|
Determines if the staff person is a solicitor (Y)es or not a solicitor (N)o.
|
VARCHAR2(1)
|
CALCULATION
|
NVL(AMRSTAF_SOLICIT_IND,'N')
|
NO
|
NO
|
STAFF_ASSIGNMENT_COUNT
|
Count of staff assignments.
|
NUMBER
|
FUNCTION
|
MAKFUNC.F_COUNT_STAFF_ASSIGNMENT
|
NO
|
NO
|
TARGET_ASK_DATE
|
Manually entered target asking date.
|
DATE
|
AMRINFO
|
AMRINFO_TARGET_ASK_DATE
|
NO
|
NO
|