| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
ASKING_AMOUNT
|
Asking Amount
|
Asking amount for the contact/project.
|
NUMBER
|
|
AMRCONT
|
AMRCONT_ASK_AMT
|
|
ITEM_REF_NUMBER
|
Item Ref Number
|
Associated reference number to contact.
|
NUMBER
|
|
AMRCONT
|
AMRCONT_ITEM_REFNO
|
|
MOVE
|
Move
|
Move code.
|
VARCHAR2(63)
|
|
AMRCONT
|
AMRCONT_MOVE_CODE
|
|
MOVE_COMPLETION_DATE
|
Move Completion Date
|
Date the move is complete.
|
DATE
|
|
AMRCONT
|
AMRCONT_CONTACT_DATE
|
|
MOVE_COMPLETION_IND
|
Move Completion Indicator
|
Indicates whether the move to the next constituent action was completed.
|
VARCHAR2(1)
|
|
CALCULATION
|
DECODE(TO_CHAR(AMRCONT_MOVE_SEQNO),NULL,'N','Y')
|
|
MOVE_DESC
|
Move Description
|
Move code description.
|
VARCHAR2(255)
|
|
ATVMOVE
|
ATVMOVE_DESC
|
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
PERSON_COMPLETED_IDEN
|
Person Completed ID
|
Identification code assigned to contact.
|
VARCHAR2(63)
|
|
AMRCONT
|
AMRCONT_IDEN_CODE
|
|
PERSON_COMPLETED_IDEN_NAME
|
Person Completed ID Name
|
Name of the individual completing the contact.
|
VARCHAR2(255)
|
|
GURIDEN
|
GURIDEN_DESC
|
|
PERSON_RESPONSIBLE_IDEN
|
Person Responsible ID
|
Identification code of the individual assigned to make the contact.
|
VARCHAR2(63)
|
|
AMRCONT
|
AMRCONT_IDEN_CODE
|
|
PERSON_RESPONSIBLE_IDEN_NAME
|
Person Responsible ID Name
|
Name of the individual assigned to make the contact.
|
VARCHAR2(255)
|
|
GURIDEN
|
GURIDEN_DESC
|
|
PERSON_UID
|
Person UID
|
System generated Banner unique ID which gets assigned to all person and non-person records within Banner.
|
NUMBER
|
|
AMRCONT AMRPLAN
|
AMRCONT_PIDM AMRPLAN_PIDM
|
|
PLANNED_MOVE_DATE
|
Planned Move Date
|
Date of the planned move.
|
DATE
|
|
AMRPLAN
|
AMRPLAN_PLAN_DATE
|
|
PRIMARY_STAFF_IDEN
|
Primary Staff ID
|
Identification code assigned to contact.
|
VARCHAR2(63)
|
|
AMRCONT AMRSTAF
|
AMRCONT_IDEN_CODE_ASGN AMRSTAF_IDEN_CODE
|
|
PRIMARY_STAFF_IDEN_NAME
|
Primary Staff ID Name
|
Name of the person with primary responsibility for this prospect as displayed on the internal person identification page.
|
VARCHAR2(255)
|
|
GURIDEN
|
GURIDEN_DESC
|
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
PROJECT
|
Project
|
Project/interest code.
|
VARCHAR2(63)
|
|
AMRCONT
|
AMRCONT_PROJ_CODE
|
|
PROJECT_DESC
|
Project Description
|
Project/interest description.
|
VARCHAR2(255)
|
|
ATVPROJ
|
ATVPROJ_DESC
|
|
TICKLER_DATE
|
Tickler Date
|
Tickler message date.
|
DATE
|
|
AMRCONT
|
AMRCONT_TICK_DATE
|
|
TICKLER_MESSAGE
|
Tickler Message
|
Tickler message.
|
VARCHAR2(255)
|
|
AMRCONT
|
AMRCONT_TICKLER
|
|
UNPLANNED_MOVE
|
Unplanned Move
|
Move identified within contact never associated with plan.
|
VARCHAR2(63)
|
|
AMRCONT
|
AMRCONT_MOVE_CODE
|
|
UNPLANNED_MOVE_DESC
|
Unplanned Move Description
|
Unplanned move description.
|
VARCHAR2(255)
|
|
ATVMOVE
|
ATVMOVE_DESC
|