Target Column	Business Name	Business Definition	Database Data Type	Business Data Type	Domain Value	Source Name	Source Column	Local Source	Local Target
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or entity.	NUMBER			AMRCONT AMRPLAN	AMRCONT_PIDM AMRPLAN_PIDM	NO NO	NO
STRATEGY_PLAN	Strategy Plan	Strategy plan.	VARCHAR2(63)			AMRCONT AMRPLAN	AMRCONT_STGY_PLAN AMRPLAN_STGY_PLAN	NO NO	NO
STRATEGY_PLAN_START_DATE	Strategy Plan Start Date	Strategy plan start date.	DATE			AMBPLAN	AMBPLAN_START_DATE	NO	NO
START_DATE_FISCAL_YEAR	Start Date Fiscal Year	Unique identifier or code for the fiscal year.	VARCHAR2(63)			ATVFISC	ATVFISC_CODE	NO	NO
START_DATE_FISCAL_YEAR_DESC	Start Date Fiscal Year Description	Fiscal year description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PLAN_MANAGER_IDEN	Plan Manager ID	Staff identification code of the individual assigned as the moves manager, the person primarily responsible for completing the strategic plan.	VARCHAR2(63)			AMBPLAN	AMBPLAN_IDEN_CODE	NO	NO
PLAN_MANAGER_IDEN_NAME	Plan Manager ID Name	Moves manager name.	VARCHAR2(255)			GURIDEN	GURIDEN_DESC	NO	NO
PLAN_MANAGER_UID	Plan Manager UID	System generated unique internal identification number assigned to this person.	NUMBER			GOBEACC	GOBEACC_PIDM	NO	NO
MOVE	Move	Move code associated with a plan or associated with a contact that is not plan related.	VARCHAR2(63)			AMRCONT AMRPLAN	AMRCONT_MOVE_CODE AMRPLAN_MOVE_CODE	NO NO	NO
MOVE_DESC	Move Description	Move code description.	VARCHAR2(255)			ATVMOVE	ATVMOVE_DESC	NO	NO
PLANNED_MOVE_IND	Planned Move Indicator	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	Planned move indicator description.	VARCHAR2(255)			CONSTANT CONSTANT	PLANNED MOVE UNPLANNED MOVE	NO NO	NO
MOVE_INTERVAL	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
PLANNED_MOVE_DATE	Planned Move Date	Date of the planned move.	DATE			AMRPLAN	AMRPLAN_PLAN_DATE	NO	NO
PLANNED_MOVE_COMPLETE_IND	Planned Move Completion Indicator	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
MOVE_COMPLETION_DATE	Move Completion Date	Date the planned or unplanned move was completed.	DATE			AMRCONT	AMRCONT_CONTACT_DATE	NO	NO
COMPLETE_DATE_FISCAL_YEAR	Completion Date Fiscal Year	Unique identifier or code for the fiscal year.	VARCHAR2(63)			TO BE FILLED IN BY DEVELOPER	ATVFISC_CODE	NO	NO
COMPLETE_DATE_FISCAL_YEAR_DESC	Completion Date Fiscal Year Description	Fiscal year description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PERSON_COMPLETED_CONTACT_IDEN	Person Completed Contact ID	Identification code assigned to contact.	VARCHAR2(63)			AMRCONT	AMRCONT_IDEN_CODE	NO	NO
PERSON_COMPLETED_CONTACT_NAME	Person Completed Contact Name	Name of the individual completing the contact.	VARCHAR2(255)			GURIDEN	GURIDEN_DESC	NO	NO
PERSON_COMPLETED_CONTACT_UID	Person Completed Contact UID	System generated unique internal identification number assigned to this person.	NUMBER			GOBEACC	GOBEACC_PIDM	NO	NO
ITEM_REF_NUMBER	Item Reference Number	Internal generated number for each contact.	NUMBER			AMRCONT	AMRCONT_ITEM_REFNO	NO	NO
PROPOSAL	Proposal	Proposal code associated to the prospect.	VARCHAR2(63)			AMRCONT	AMRCONT_PROP_CODE	NO	NO
PROPOSAL_SEQUENCE_NUMBER	Proposal Sequence Number	Proposal code sequence number.	NUMBER			AMRCONT	AMRCONT_PROP_SEQ_NO	NO	NO
PROJECT	Project	Project/interest code.	VARCHAR2(63)			AMRCONT AMRPLAN AMRPLAN AMRPLAN 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 Description	Project/interest description.	VARCHAR2(255)			ATVPROJ	ATVPROJ_DESC	NO	NO
PRIMARY_PROJECT_IND	Primary Project Indicator	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)			CALCULATION	DECODE(AMRPLAN_PROJ_CODE, AMRCONT_PROJ_CODE)	NO	NO
ASK_AMOUNT	Ask Amount	Ask amount for the contact/project.	NUMBER			AMRCONT	AMRCONT_ASK_AMT	NO	NO
PRIMARY_STAFF_IDEN_CODE	Primary Staff ID Code	Staff identification code.	VARCHAR2(63)			ARMSTAF	AMRSTAF_IDEN_CODE	NO	NO
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	NO	NO
PRIMARY_STAFF_UID	Primary Staff UID	System generated unique internal identification number assigned to this person.	NUMBER			GOBEACC	GOBEACC_PIDM	NO	NO
PROSPECT_PLAN_ACTIVITY_DATE	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
MULTI_SOURCE	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	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)			NA	NA	NO	NO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
PLANNED_MOVE_FISCAL_YEAR	Planned Move Fiscal Year	Unique identifier or code for the fiscal year.	VARCHAR2(63)			ATVFISC	ATVFISC_CODE	NO	NO
PLANNED_MOVE_FISCAL_YEAR_DESC	Planned Move Fiscal Year Description	Fiscal year description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	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(255)			AMRCONT	DECODE(TO_CHAR(AMRCONT_MOVE_SEQNO),NULL,'N','Y')	NO	NO
PERSON_RESPONSIBLE_IDEN	Person Responsible IDEN	Staff identification code of the person primarily responsible for completing the strategic plan or responsible for the contact.	VARCHAR2(63)			AMRCONT GOBEACC	AMRCONT_IDEN_CODE GOBEACC_PIDM	NO NO	NO
PERSON_RESPONSIBLE_IDEN_NAME	Person Responsible IDEN Name	Name of the individual responsible for completing the strategy plan or reponsible for the contact.	VARCHAR2(255)			GURIDEN	GURIDEN_DESC	NO	NO
PERSON_RESPONSIBLE_UID	Person Responsible UID	System generated unique internal identification number assigned to the responsible staff person.	NUMBER			GOBEACC	GOBEACC_PIDM	NO	NO
STRATEGY_PLAN_END_DATE	Strategy Plan End Date	Strategy plan end date.	DATE			CALCULATION	NVL(AMBPLAN_END_DATE,'31-DEC-2099')	NO	NO
STRATEGY_PLAN_STATUS_IND	Strategy Plan Status Indicator	Indicates whether the strategy plan is (1) acitve or (0) inactive.	VARCHAR2(1)			AMBPLAN	AMBPLAN_ACTIVE_IND	NO	NO
STRATEGY_PLAN_STATUS_IND_DESC	Strategy Plan Status Indicator Description	Strategy plan status description.	VARCHAR2(255)			AMBPLAN	AMBPLAN_STATUS_IND	NO	NO
ACTIVE_PROSPECT_STRATEGY_IND	Active Prospect Strategy Indicator	Indicates whether the strategy plan is active based upon its status and if the system date is between the start and end date of the strategy plan.	CHAR(1)			CALCULATION	CASE WHEN STRATEGY_PLAN_STATUS_IND	NO	NO
STRATEGY_PLAN_SEQUENCE_NUMBER	Strategy Plan Sequence Number	Internal sequence number allowing multiple strategies for the strategy plan.	NUMBER			AMBPLAN	AMBPLAN_PLAN_SEQ_NO	NO	NO

Ver: 9.2