Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ASKING_AMOUNT
|
Asking amount for the contact/project.
|
NUMBER
|
AMRCONT
|
AMRCONT_ASK_AMT
|
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
|
ITEM_REF_NUMBER
|
Associated reference number to contact.
|
NUMBER
|
AMRCONT
|
AMRCONT_ITEM_REFNO
|
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
|
MOVE
|
Move code.
|
VARCHAR2(4)
|
AMRPLAN
|
AMRPLAN_MOVE_CODE
|
NO
|
NO
|
MOVE_COMPLETION_DATE
|
Date the move is complete.
|
DATE
|
AMRCONT
|
AMRCONT_CONTACT_DATE
|
NO
|
NO
|
MOVE_COMPLETION_IND
|
Indicates whether the move to the next constituent action was completed.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(TO_CHAR(AMRCONT_MOVE_SEQNO),NULL,'N','Y')
|
NO
|
NO
|
MOVE_DESC
|
Move code description.
|
VARCHAR2(30)
|
ATVMOVE
|
ATVMOVE_DESC
|
NO
|
NO
|
PERSON_COMPLETED_CONTACT_ID
|
Identification code assigned to contact.
|
VARCHAR2(5)
|
AMRCONT
|
AMRCONT_IDEN_CODE
|
NO
|
NO
|
PERSON_COMPLETED_CONTACT_NAME
|
Name of the individual completing the contact.
|
VARCHAR2(60)
|
GURIDEN
|
GURIDEN_DESC
|
NO
|
NO
|
PERSON_RESPONSIBLE_ID
|
Identification code of the individual assigned to make the contact.
|
VARCHAR2(5)
|
AMRCONT AMRPLAN
|
AMRCONT_IDEN_CODE AMRPLAN_IDEN_CODE
|
NO NO
|
NO
|
PERSON_RESPONSIBLE_NAME
|
Name of the person with primary responsibility for this prospect.
|
VARCHAR2(60)
|
GURIDEN
|
GURIDEN_DESC
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to the person.
|
NUMBER
|
AMRCONT AMRPLAN
|
AMRCONT_PIDM AMRPLAN_PIDM
|
NO NO
|
NO
|
PLANNED_MOVE_DATE
|
Date of the planned move.
|
DATE
|
AMRPLAN
|
AMRPLAN_PLAN_DATE
|
NO
|
NO
|
PRIMARY_STAFF_IDEN_CODE
|
Staff identification code.
|
VARCHAR2(5)
|
AMRSTAF
|
AMRSTAF_IDEN_CODE
|
NO
|
NO
|
PRIMARY_STAFF_IDEN_DESC
|
Name of the person with primary responsibility for this prospect as displayed on the internal person identification page.
|
VARCHAR2(60)
|
GURIDEN
|
GURIDEN_DESC
|
NO
|
NO
|
PROJECT
|
Project/interest code.
|
VARCHAR2(6)
|
AMRCONT AMRPLAN
|
AMRCONT_PROJ_CODE AMRPLAN_PROJ_CODE
|
NO NO
|
NO
|
PROJECT_DESC
|
Project/interest description.
|
VARCHAR2(30)
|
ATVPROJ
|
ATVPROJ_DESC
|
NO
|
NO
|
TICKLER_DATE
|
Tickler message date.
|
DATE
|
AMRCONT
|
AMRCONT_TICK_DATE
|
NO
|
NO
|
TICKLER_MESSAGE
|
Tickler message.
|
VARCHAR2(180)
|
AMRCONT
|
AMRCONT_TICKLER
|
NO
|
NO
|
UNPLANNED_MOVE
|
Move identified within contact never associated with plan.
|
VARCHAR2(4)
|
AMRCONT
|
AMRCONT_MOVE_CODE
|
NO
|
NO
|
UNPLANNED_MOVE_DESC
|
Unplanned move description.
|
VARCHAR2(30)
|
ATVMOVE
|
ATVMOVE_DESC
|
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
|