Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVE_PROSPECT_STRATEGY_IND	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
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
ASK_AMOUNT2	Second asking amount for the contact/project.	NUMBER	AMRCONT	AMRCONT_ASK_AMT_2	NO	NO
ASK_AMOUNT3	Third asking amount for the contact/project.	NUMBER	AMRCONT	AMRCONT_ASK_AMT_3	NO	NO
ASK_AMOUNT4	Fourth asking amount for the contact/project.	NUMBER	AMRCONT	AMRCONT_ASK_AMT_4	NO	NO
CALL_REPORT_COMMENT	Call report used to elaborate on the contact explanation.	CLOB	AMRCONT	AMRCONT_CALL_REPORT	NO	NO
CONTACT_COMMENT	Comment recorded for the contact made.	VARCHAR2(2000)	AMRCONT	AMRCONT_CONTACT	NO	NO
CONTACT_CREATE_DATE	Date the contact was added.	DATE	AMRCONT	AMRCONT_CREATE_DATE	NO	NO
CONTACT_DATE	Date the contact was made.	DATE	AMRCONT	AMRCONT_CONTACT_DATE	NO	NO
CONTACT_DATE_FISCAL_YEAR	Unique identifier or code for the fiscal year.	VARCHAR2(63)	ATVFISC	ATVFISC_CODE	NO	NO
CONTACT_DATE_FISCAL_YEAR_DESC	Fiscal year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
CONTACT_TYPE	Type of contact between the institution and person.	VARCHAR2(63)	AMRCONT	AMRCONT_SCNT_CODE	NO	NO
CONTACT_TYPE_DESC	Contact type description.	VARCHAR2(255)	ATVSCNT	ATVSCNT_DESC	NO	NO
CREATE_TICKLER_IND	Determines if a follow-up action message is to be created. (Y)es it will be created, (N)o, it does not need to be created.	VARCHAR2(1)	AMRCONT	AMRCONT_CREATE_TICKLER	NO	NO
FOLLOWUP_ASSIGNEE_UID	System generated unique internal identification number assigned to this person.	NUMBER	GOBEACC	GOBEACC_PIDM	NO	NO
ITEM_REF_NUMBER	Internal generated number for each contact.	NUMBER	AMRCONT	AMRCONT_ITEM_REFNO	NO	NO
MESSAGES_SENT_COUNT	Number of messages sent for the contact.	NUMBER	GURTKLR	GURTKLR_PIDM	NO	NO
MOVE	Move code associated with a plan or associated with a contact that is not plan related.	VARCHAR2(63)	AMRCONT	AMRCONT_MOVE_CODE	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_ASGN	NO	NO
PERSON_COMPLETED_IDEN_NAME	Staff member name responsible for the follow-up action.	VARCHAR2(255)	GURIDEN	GURIDEN_DESC	NO	NO
PERSON_RESPONSIBLE_IDEN	Staff identification code of the person responsible for originating and carrying out the contact.	VARCHAR2(63)	AMRCONT	AMRCONT_IDEN_CODE	NO	NO
PERSON_RESPONSIBLE_IDEN_NAME	Name of the person assigned to make the contact.	VARCHAR2(255)	GURIDEN	GURIDEN_DESC	NO	NO
PERSON_RESPONSIBLE_UID	System generated unique internal identification number assigned to this person.	NUMBER	SPRIDEN	SPRIDEN_PIDM	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	AMRCONT	AMRCONT_PIDM	NO	NO
PLAN_MOVE_SEQUENCE_NUMBER	When populated, move sequence number determines that the move is complete because a plan is associated to the move.	NUMBER	AMRCONT	AMRCONT_MOVE_SEQ_NO	NO	NO
PRIMARY_STAFF_IDEN	Staff identification code of the person with primary responsibility for the prospect.	VARCHAR2(63)	AMRSTAF	AMRSTAF_IDEN_CODE	NO	NO
PRIMARY_STAFF_IDEN_NAME	Name of the person with primary responsibility for this prospect.	VARCHAR2(255)	GURIDEN	GURIDEN_DESC	NO	NO
PRIMARY_STAFF_UID	System generated unique internal identification number assigned to this person.	NUMBER	GOBEACC	GOBEACC_PIDM	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
PROJECT2	Second project or interest area.	VARCHAR2(63)	AMRCONT	AMRCONT_PROJ_CODE_2	NO	NO
PROJECT3	Third project or interest area.	VARCHAR2(63)	AMRCONT	AMRCONT_PROJ_CODE_3	NO	NO
PROJECT4	Fourth project or interest area.	VARCHAR2(63)	AMRCONT	AMRCONT_PROJ_CODE_3	NO	NO
PROJECT_DESC	Project/interest description.	VARCHAR2(255)	ATVPROJ	ATVPROJ_DESC	NO	NO
PROJECT_DESC2	Second project or interest area description.	VARCHAR2(255)	ATVPROJ	ATVPROJ_DESC	NO	NO
PROJECT_DESC3	Third project or interest area description.	VARCHAR2(255)	ATVPROJ	ATVPROJ_DESC	NO	NO
PROJECT_DESC4	Fourth project or interest area description.	VARCHAR2(255)	ATVPROJ	ATVPROJ_DESC	NO	NO
PROPOSAL	Proposal code associated to the prospect.	VARCHAR2(63)	AMRCONT	AMRCONT_PROP_CODE	NO	NO
PROPOSAL_SEQUENCE_NUMBER	Proposal code sequence number.	NUMBER	AMRCONT	AMRCONT_PROP_SEQ_NO	NO	NO
PROSPECT_CONTACT_ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	AMRCONT	AMRCONT_ACTIVITY_DATE	NO	NO
PROSPECT_CONTACT_IND	Identifies the constituent for the contact as a prospect (Y)es or a general constituent contact (N)o.	VARCHAR2(1)	CALCULATION	CASE(AMRCONT_GEN_CONTACT_IND)	NO	NO
PROSPECT_CONTACT_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	AMRCONT	AMRCONT_USER_ID	NO	NO
RECENT_TICKLER_STATUS	Determines the most recent follow-up action tickler status. Follow-up action is (C)omplete, Follow-up action has not yet occurred, (P)ending, Follow-up action is no longer pending, although it is still planned and on (H)old.	VARCHAR2(63)	AMRCONT	AMRCONT_TICK_STATUS	NO	NO
RECENT_TICKLER_STATUS_DESC	Recent tickler status description.	VARCHAR2(255)	MGT_VALIDATION	SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TICKLER_STATUS' AND VALUE = RECENT_TICKLER_STATUS	NO	NO
STAFF_ASSIGNED_COUNT	Count of staff assigned.	NUMBER	FUNCTION	MAKFUNC.F_COUNT_STAFF_ASSIGNMENT	NO	NO
START_DATE_FISCAL_YEAR	Unique identifier or code for the fiscal year.	VARCHAR2(63)	ATVFISC	ATVFISC_CODE	NO	NO
START_DATE_FISCAL_YEAR_DESC	Fiscal year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
STRATEGY_PLAN	Strategy plan name.	VARCHAR2(63)	AMRCONT	AMRCONT_STGY_PLAN	NO	NO
STRATEGY_PLAN_END_DATE	Strategy plan end date.	DATE	CALCULATION	NVL(AMBPLAN_END_DATE,'31-DEC-2099')	NO	NO
STRATEGY_PLAN_SEQUENCE_NUMBER	Internal sequence number allowing multiple strategies for the strategy plan.	NUMBER	AMBPLAN	AMBPLAN_PLAN_SEQ_NO	NO	NO
STRATEGY_PLAN_START_DATE	Strategy plan start date.	DATE	AMBPLAN	AMBPLAN_START_DATE	NO	NO
STRATEGY_PLAN_STATUS_IND	Indicates whether the strategy plan is (1) active or (0) inactive.	VARCHAR2(1)	AMBPLAN	AMBPLAN_ACTIVE_IND	NO	NO
STRATEGY_PLAN_STATUS_IND_DESC	Strategy plan status description.	VARCHAR2(255)	AMBPLAN	AMBPLAN_STATUS_IND	NO	NO
TICKLER_CONFIDENTIAL_IND	Determines if the follow-up message is to remain confidential. (Y)es confidential, (N)ot confidential.	VARCHAR2(1)	CALCULATION	NVL(AMRCONT_CONFID_IND)	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
TOTAL_EXPENSE	Total of all expenses for the contact.	NUMBER	FUNCTION	SUM(NVL(AMRPEXP_EXPN_AMT, 0))	NO	NO
TOTAL_STAFF_COUNT	Total number of staff attending the contact visit.	NUMBER	CALCULATION	COUNT(AMRATTN_PIDM)	NO	NO

Ver: 9.2