Target Column	Business Definition	Database Data Type	Source Name	Source Column
ASK_AMOUNT	Ask amount for the contact/project.	NUMBER	AMRCONT	AMRCONT_ASK_AMT
COMPLETE_DATE_FISCAL_YEAR	Unique identifier or code for the fiscal year.	VARCHAR2(4)	ATVFISC	ATVFISC_CODE
COMPLETE_DATE_FISCAL_YEAR_DESC	Fiscal year description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
ENTITY_UID	System generated, unique, internal identification number assigned to this person or entity.	NUMBER	AMRCONT AMRPLAN	AMRCONT_PIDM AMRPLAN_PIDM
ITEM_REF_NUMBER	Internal generated number for each contact.	NUMBER	AMRCONT	AMRCONT_ITEM_REFNO
MIF_DESC	Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
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
MOVE_COMPLETION_DATE	Date the planned or unplanned move was completed.	DATE	AMRCONT	AMRCONT_CONTACT_DATE
MOVE_DESC	Move code description.	VARCHAR2(30)	ATVMOVE	ATVMOVE_DESC
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
PERSON_COMPLETED_CONTACT_IDEN	Identification code assigned to contact.	VARCHAR2(5)	AMRCONT	AMRCONT_IDEN_CODE
PERSON_COMPLETED_CONTACT_NAME	Name of the individual completing the contact.	VARCHAR2(60)	GURIDEN	GURIDEN_DESC
PERSON_COMPLETED_CONTACT_UID	System generated unique internal identification number assigned to this person.	NUMBER	GOBEACC	GOBEACC_PIDM
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
PERSON_RESPONSIBLE_IDEN_NAME	Name of the individual responsible for completing the strategy plan or reponsible for the contact.	VARCHAR2(60)	GURIDEN	GURIDEN_DESC
PERSON_RESPONSIBLE_UID	System generated unique internal identification number assigned to the responsible staff person.	NUMBER	GOBEACC	GOBEACC_PIDM
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
PLANNED_MOVE_DATE	Date of the planned move.	DATE	AMRPLAN	AMRPLAN_PLAN_DATE
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
PLANNED_MOVE_DATE_SOURCE_DESC	Planned moved date source description.	VARCHAR2(6)	AMRPLAN	DECODE(AMRPLAN_SYS_IND,'S','SYSTEM','MANUAL')
PLANNED_MOVE_FISCAL_YEAR	Unique identifier or code for the fiscal year.	VARCHAR2(4)	ATVFISC	ATVFISC_CODE
PLANNED_MOVE_FISCAL_YEAR_DESC	Fiscal year description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
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
PLANNED_MOVE_IND_DESC	Planned move indicator description.	VARCHAR2(14)	CONSTANT CONSTANT	PLANNED MOVE UNPLANNED MOVE
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
PLAN_MANAGER_IDEN_NAME	Moves manager name.	VARCHAR2(60)	GURIDEN	GURIDEN_DESC
PLAN_MANAGER_UID	System generated unique internal identification number assigned to this person.	NUMBER
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)
PRIMARY_STAFF_IDEN_CODE	Staff identification code.	VARCHAR2(5)	ARMSTAF	AMRSTAF_IDEN_CODE
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
PRIMARY_STAFF_UID	System generated unique internal identification number assigned to this person.	NUMBER	SPRIDEN	SPRIDEN_PIDM
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
PROJECT_DESC	Project/interest description.	VARCHAR2(30)	ATVPROJ	ATVPROJ_DESC
PROPOSAL	Proposal code associated to the prospect.	VARCHAR2(6)	AMRCONT	AMRCONT_PROP_CODE
PROPOSAL_SEQUENCE_NUMBER	Proposal code sequence number.	NUMBER	AMRCONT	AMRCONT_PROP_SEQ_NO
PROSPECT_PLAN_ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	AMRPLAN	AMRPLAN_ACTIVITY_DATE
START_DATE_FISCAL_YEAR	Unique identifier or code for the fiscal year.	VARCHAR2(4)	ATVFISC	ATVFISC_CODE
START_DATE_FISCAL_YEAR_DESC	Fiscal year description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
STRATEGY_PLAN	Strategy plan.	VARCHAR2(15)	AMRCONT AMRPLAN	AMRCONT_STGY_PLAN AMRPLAN_STGY_PLAN
STRATEGY_PLAN_END_DATE		DATE
STRATEGY_PLAN_SEQUENCE_NUMBER		NUMBER
STRATEGY_PLAN_START_DATE	Strategy plan start date.	DATE	AMBPLAN	AMBPLAN_START_DATE
STRATEGY_PLAN_STATUS_IND		VARCHAR2(1)
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: