Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ASK_AMOUNT
|
Ask amount for the contact/project.
|
NUMBER
|
AMRCONT
|
AMRCONT_ASK_AMT
|
NO
|
NO
|
COMPLETE_DATE_FISCAL_YEAR
|
Unique identifier or code for the fiscal year.
|
VARCHAR2(4)
|
ATVFISC
|
ATVFISC_CODE
|
NO
|
NO
|
COMPLETE_DATE_FISCAL_YEAR_DESC
|
Fiscal year description.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
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 entity.
|
NUMBER
|
AMRCONT AMRPLAN
|
AMRCONT_PIDM AMRPLAN_PIDM
|
NO NO
|
NO
|
ITEM_REF_NUMBER
|
Internal generated number for each 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 associated with a plan or associated with a contact that is not plan related.
|
VARCHAR2(4)
|
AMRCONT AMRPLAN
|
AMRCONT_MOVE_CODE AMRPLAN_MOVE_CODE
|
NO NO
|
NO
|
MOVE_COMPLETION_DATE
|
Date the planned or unplanned move was completed.
|
DATE
|
AMRCONT
|
AMRCONT_CONTACT_DATE
|
NO
|
NO
|
MOVE_DESC
|
Move code description.
|
VARCHAR2(30)
|
ATVMOVE
|
ATVMOVE_DESC
|
NO
|
NO
|
MOVE_INTERVAL
|
Number of days between the previous move and the current move. For the first move in the strategy plan, this is the number of days that should pass after the day the plan is assigned to the prospect before the move is completed.
|
NUMBER
|
AMRPLAN
|
AMRPLAN_WAIT_DAYS
|
NO
|
NO
|
PERSON_COMPLETED_CONTACT_IDEN
|
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_COMPLETED_CONTACT_UID
|
System generated unique internal identification number assigned to this person.
|
NUMBER
|
GOBEACC
|
GOBEACC_PIDM
|
NO
|
NO
|
PERSON_RESPONSIBLE_IDEN
|
Staff identification code of the individual assigned as the moves manager, the person primarily responsible for completing the strategic plan.
|
VARCHAR2(5)
|
AMRCONT AMRPLAN
|
AMRCONT_IDEN_CODE AMRPLAN_IDEN_CODE
|
NO NO
|
NO
|
PERSON_RESPONSIBLE_IDEN_NAME
|
Name of the individual responsible for completing the strategy plan or reponsible for the contact.
|
VARCHAR2(60)
|
GURIDEN
|
GURIDEN_DESC
|
NO
|
NO
|
PERSON_RESPONSIBLE_UID
|
System generated unique internal identification number assigned to the responsible staff person.
|
NUMBER
|
GOBEACC
|
GOBEACC_PIDM
|
NO
|
NO
|
PLANNED_MOVE_COMPLETE_IND
|
Determines if the move to the next constituent action was completed.
|
VARCHAR2(1)
|
CALCULATION CONSTANT
|
DECODE(TO_CHAR(AMRCONT_MOVE_SEQNO),NULL,'N','Y') N
|
NO NO
|
NO
|
PLANNED_MOVE_DATE
|
Date of the planned move.
|
DATE
|
AMRPLAN
|
AMRPLAN_PLAN_DATE
|
NO
|
NO
|
PLANNED_MOVE_DATE_SOURCE
|
Determines if the planned move date was changed manually by the (U)ser or by the (S)ystem during a re-scheduling function.
|
VARCHAR2(1)
|
AMRPLAN
|
AMRPLAN_SYS_IND
|
NO
|
NO
|
PLANNED_MOVE_DATE_SOURCE_DESC
|
Planned moved date source description.
|
VARCHAR2(6)
|
AMRPLAN
|
DECODE(AMRPLAN_SYS_IND,'S','SYSTEM','MANUAL')
|
NO
|
NO
|
PLANNED_MOVE_FISCAL_YEAR
|
Unique identifier or code for the fiscal year.
|
VARCHAR2(4)
|
ATVFISC
|
ATVFISC_CODE
|
NO
|
NO
|
PLANNED_MOVE_FISCAL_YEAR_DESC
|
Fiscal year description.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PLANNED_MOVE_IND
|
Determines if the move was associated to a plan (Y)es or not associated to a plan (N)o.
|
VARCHAR2(1)
|
CONSTANT CONSTANT
|
N Y
|
NO NO
|
NO
|
PLANNED_MOVE_IND_DESC
|
Planned move indicator description.
|
VARCHAR2(14)
|
CONSTANT CONSTANT
|
PLANNED MOVE UNPLANNED MOVE
|
NO NO
|
NO
|
PLAN_MANAGER_IDEN
|
Staff identification code of the individual assigned as the moves manager, the person primarily responsible for completing the strategic plan.
|
VARCHAR2(5)
|
AMBPLAN
|
AMBPLAN_IDEN_CODE
|
NO
|
NO
|
PLAN_MANAGER_IDEN_NAME
|
Moves manager name.
|
VARCHAR2(60)
|
GURIDEN
|
GURIDEN_DESC
|
NO
|
NO
|
PLAN_MANAGER_UID
|
System generated unique internal identification number assigned to this person.
|
NUMBER
|
|
|
|
NO
|
PRIMARY_PROJECT_IND
|
Determines if the project from the contact is related directly to the strategic plan. (Y)es the project is directly related to the plan, (N)o the project is not directly related to the plan.
|
VARCHAR2(1)
|
|
|
|
NO
|
PRIMARY_STAFF_IDEN_CODE
|
Staff identification code.
|
VARCHAR2(5)
|
ARMSTAF
|
AMRSTAF_IDEN_CODE
|
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(60)
|
GURIDEN
|
GURIDEN_DESC
|
NO
|
NO
|
PRIMARY_STAFF_UID
|
System generated unique internal identification number assigned to this person.
|
NUMBER
|
SPRIDEN
|
SPRIDEN_PIDM
|
NO
|
NO
|
PROJECT
|
Project/interest code.
|
VARCHAR2(6)
|
AMRCONT AMRCONT AMRCONT AMRCONT AMRPLAN
|
AMRCONT_PROJ_CODE AMRCONT_PROJ_CODE_2 AMRCONT_PROJ_CODE_3 AMRCONT_PROJ_CODE_4 AMRPLAN_PROJ_CODE
|
NO NO NO NO NO
|
NO
|
PROJECT_DESC
|
Project/interest description.
|
VARCHAR2(30)
|
ATVPROJ
|
ATVPROJ_DESC
|
NO
|
NO
|
PROPOSAL
|
Proposal code associated to the prospect.
|
VARCHAR2(6)
|
AMRCONT
|
AMRCONT_PROP_CODE
|
NO
|
NO
|
PROPOSAL_SEQUENCE_NUMBER
|
Proposal code sequence number.
|
NUMBER
|
AMRCONT
|
AMRCONT_PROP_SEQ_NO
|
NO
|
NO
|
PROSPECT_PLAN_ACTIVITY_DATE
|
Date that information for this record in the table was entered or last updated.
|
DATE
|
AMRPLAN
|
AMRPLAN_ACTIVITY_DATE
|
NO
|
NO
|
START_DATE_FISCAL_YEAR
|
Unique identifier or code for the fiscal year.
|
VARCHAR2(4)
|
ATVFISC
|
ATVFISC_CODE
|
NO
|
NO
|
START_DATE_FISCAL_YEAR_DESC
|
Fiscal year description.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
STRATEGY_PLAN
|
Strategy plan.
|
VARCHAR2(15)
|
AMRCONT AMRPLAN
|
AMRCONT_STGY_PLAN AMRPLAN_STGY_PLAN
|
NO NO
|
NO
|
STRATEGY_PLAN_END_DATE
|
|
DATE
|
|
|
|
NO
|
STRATEGY_PLAN_SEQUENCE_NUMBER
|
|
NUMBER
|
|
|
|
NO
|
STRATEGY_PLAN_START_DATE
|
Strategy plan start date.
|
DATE
|
AMBPLAN
|
AMBPLAN_START_DATE
|
NO
|
NO
|
STRATEGY_PLAN_STATUS_IND
|
|
VARCHAR2(1)
|
|
|
|
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
|