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
|
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
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
ENTITY_UID
|
System generated, unique, internal identification number assigned to this person or organization entity.
|
NUMBER
|
AMRINFO
|
AMRINFO_PIDM
|
NO
|
NO
|
MIF_DESC
|
Institution description for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
PREF_GEO_REGION_ADDR_TYPE
|
Address type of the address to be used as the preferred geographic region address.
|
VARCHAR2(2)
|
APBCONS
|
APBCONS_ATYP_CODE_GEOR
|
NO
|
NO
|
PREF_GEO_REGION_ADDR_TYPE_DESC
|
Preferred geographic region address type.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PRIMARY_STAFF_ASSIGN_IDEN_CODE
|
Primary staff identification code.
|
VARCHAR2(5)
|
AMRSTAF
|
AMRSTAF_IDEN_CODE
|
NO
|
NO
|
PRIMARY_STAFF_ASSIGN_IDEN_DESC
|
Name of the primary staff identification code.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PRIMARY_STAFF_ASSIGN_TYPE
|
Primary staff type code.
|
VARCHAR2(4)
|
AMRSTAF
|
AMRSTAF_STFT_CODE
|
NO
|
NO
|
PRIMARY_STAFF_ASSIGN_TYPE_DESC
|
Primary staff type code description.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
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(1)
|
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(30)
|
FUNCTION
|
CASE WHEN AMRINFO_SYS_IND
|
NO
|
NO
|
PROSPECT_STATUS
|
Status.
|
VARCHAR2(6)
|
AMRINFO
|
AMRINFO_STATUS
|
NO
|
NO
|
PROSPECT_STATUS_DESC
|
Prospect status description.
|
VARCHAR2(30)
|
ATVPRST
|
ATVPRST_DESC
|
NO
|
NO
|
REFERENCE
|
Reference code.
|
VARCHAR2(2)
|
AMRINFO
|
AMRINFO_REFR_CODE
|
NO
|
NO
|
REFERENCE_COMMENT
|
Prospect reference comment.
|
VARCHAR2(30)
|
AMRINFO
|
AMRINFO_REFERENCE
|
NO
|
NO
|
REFERENCE_DESC
|
Reference code description.
|
VARCHAR2(30)
|
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
|
TARGET_ASK_DATE
|
Manually entered target asking date.
|
DATE
|
AMRINFO
|
AMRINFO_TARGET_ASK_DATE
|
NO
|
NO
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|