Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
ASKING_AMOUNT
|
Asking amount for the contact/project.
|
NUMBER
|
AMRCONT
|
AMRCONT_ASK_AMT
|
NO
|
NO
|
ITEM_REF_NUMBER
|
Associated reference number to contact.
|
NUMBER
|
AMRCONT
|
AMRCONT_ITEM_REFNO
|
NO
|
NO
|
MOVE
|
Move code.
|
VARCHAR2(63)
|
AMRCONT
|
AMRCONT_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(255)
|
ATVMOVE
|
ATVMOVE_DESC
|
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
|
PERSON_COMPLETED_IDEN
|
Identification code assigned to contact.
|
VARCHAR2(63)
|
AMRCONT
|
AMRCONT_IDEN_CODE
|
NO
|
NO
|
PERSON_COMPLETED_IDEN_NAME
|
Name of the individual completing the contact.
|
VARCHAR2(255)
|
GURIDEN
|
GURIDEN_DESC
|
NO
|
NO
|
PERSON_RESPONSIBLE_IDEN
|
Identification code of the individual assigned to make the contact.
|
VARCHAR2(63)
|
AMRCONT
|
AMRCONT_IDEN_CODE
|
NO
|
NO
|
PERSON_RESPONSIBLE_IDEN_NAME
|
Name of the individual assigned to make the contact.
|
VARCHAR2(255)
|
GURIDEN
|
GURIDEN_DESC
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this 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
|
Identification code assigned to contact.
|
VARCHAR2(63)
|
AMRCONT AMRSTAF
|
AMRCONT_IDEN_CODE_ASGN AMRSTAF_IDEN_CODE
|
NO NO
|
NO
|
PRIMARY_STAFF_IDEN_NAME
|
Name of the person with primary responsibility for this prospect as displayed on the internal person identification page.
|
VARCHAR2(255)
|
GURIDEN
|
GURIDEN_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
|
PROJECT
|
Project/interest code.
|
VARCHAR2(63)
|
AMRCONT
|
AMRCONT_PROJ_CODE
|
NO
|
NO
|
PROJECT_DESC
|
Project/interest description.
|
VARCHAR2(255)
|
ATVPROJ
|
ATVPROJ_DESC
|
NO
|
NO
|
TICKLER_DATE
|
Tickler message date.
|
DATE
|
AMRCONT
|
AMRCONT_TICK_DATE
|
NO
|
NO
|
TICKLER_MESSAGE
|
Tickler message.
|
VARCHAR2(255)
|
AMRCONT
|
AMRCONT_TICKLER
|
NO
|
NO
|
UNPLANNED_MOVE
|
Move identified within contact never associated with plan.
|
VARCHAR2(63)
|
AMRCONT
|
AMRCONT_MOVE_CODE
|
NO
|
NO
|
UNPLANNED_MOVE_DESC
|
Unplanned move description.
|
VARCHAR2(255)
|
ATVMOVE
|
ATVMOVE_DESC
|
NO
|
NO
|