Target Column	Business Name	Business Definition	Database Data Type	Business Data Type	Domain Value	Source Name	Source Column	Local Source	Local Target
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER			AMRCONT	AMRCONT_PIDM	NO	NO
PERSON_RESPONSIBLE_IDEN	Person Responsible ID	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	Person Responsible ID Name	Name of the person assigned to make the contact.	VARCHAR2(255)			GURIDEN	GURIDEN_DESC	NO	NO
PROJECT	Project	Project/interest code.	VARCHAR2(63)			AMRCONT	AMRCONT_PROJ_CODE	NO	NO
PROJECT_DESC	Project Description	Project/interest description.	VARCHAR2(255)			ATVPROJ	ATVPROJ_DESC	NO	NO
CONTACT_TYPE	Contact Type	Type of contact between the institution and person.	VARCHAR2(63)			AMRCONT	AMRCONT_SCNT_CODE	NO	NO
CONTACT_TYPE_DESC	Contact Type Description	Contact type description.	VARCHAR2(255)			ATVSCNT	ATVSCNT_DESC	NO	NO
ITEM_REF_NUMBER	Item Ref Number	Internal generated number for each contact.	NUMBER			AMRCONT	AMRCONT_ITEM_REFNO	NO	NO
PERSON_COMPLETED_IDEN	Person Completed ID	Identification code assigned to contact.	VARCHAR2(63)			AMRCONT	AMRCONT_IDEN_CODE_ASGN	NO	NO
PERSON_COMPLETED_IDEN_NAME	Person Completed ID Name	Staff member name responsible for the follow-up action.	VARCHAR2(255)			GURIDEN	GURIDEN_DESC	NO	NO
CONTACT_COMMENT	Contact Comment	Comment recorded for the contact made.	VARCHAR2(2000)			AMRCONT	AMRCONT_CONTACT	NO	NO
CONTACT_DATE	Contact Date	Date the contact was made.	DATE			AMRCONT	AMRCONT_CONTACT_DATE	NO	NO
TICKLER_MESSAGE	Tickler Message	Tickler message.	VARCHAR2(255)			AMRCONT	AMRCONT_TICKLER	NO	NO
TICKLER_DATE	Tickler Date	Tickler message date.	DATE			AMRCONT	AMRCONT_TICK_DATE	NO	NO
MOVE	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 Description	Move code description.	VARCHAR2(255)			ATVMOVE	ATVMOVE_DESC	NO	NO
ASKING_AMOUNT	Asking Amount	Asking amount for the contact/project.	NUMBER			AMRCONT	AMRCONT_ASK_AMT	NO	NO
PRIMARY_STAFF_IDEN	Primary Staff ID	Staff identification code of the person with primary responsibility for the prospect.	VARCHAR2(63)			AMRSTAF	AMRSTAF_IDEN_CODE	NO	NO
PRIMARY_STAFF_IDEN_NAME	Primary Staff ID Name	Name of the person with primary responsibility for this prospect.	VARCHAR2(255)			GURIDEN	GURIDEN_DESC	NO	NO
STAFF_ASSIGNED_COUNT	Staff Assigned Count	Count of staff assigned.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_STAFF_ASSIGNMENT	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
PERSON_RESPONSIBLE_UID	Person Responsible UID	System generated unique internal identification number assigned to this person.	NUMBER			SPRIDEN	SPRIDEN_PIDM	NO	NO
STRATEGY_PLAN	Strategy Plan	Strategy plan name.	VARCHAR2(63)			AMRCONT	AMRCONT_STGY_PLAN	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
PROJECT2	Project 2	Second project or interest area.	VARCHAR2(63)			AMRCONT	AMRCONT_PROJ_CODE_2	NO	NO
PROJECT_DESC2	Project Description 2	Second project or interest area description.	VARCHAR2(255)			ATVPROJ	ATVPROJ_DESC	NO	NO
ASK_AMOUNT2	Ask Amount 2	Second asking amount for the contact/project.	NUMBER			AMRCONT	AMRCONT_ASK_AMT_2	NO	NO
PROJECT3	Project 3	Third project or interest area.	VARCHAR2(63)			AMRCONT	AMRCONT_PROJ_CODE_3	NO	NO
PROJECT_DESC3	Project Description 3	Third project or interest area description.	VARCHAR2(255)			ATVPROJ	ATVPROJ_DESC	NO	NO
ASK_AMOUNT3	Ask Amount 3	Third asking amount for the contact/project.	NUMBER			AMRCONT	AMRCONT_ASK_AMT_3	NO	NO
PROJECT4	Project 4	Fourth project or interest area.	VARCHAR2(63)			AMRCONT	AMRCONT_PROJ_CODE_3	NO	NO
PROJECT_DESC4	Project Description 4	Fourth project or interest area description.	VARCHAR2(255)			ATVPROJ	ATVPROJ_DESC	NO	NO
ASK_AMOUNT4	Ask Amount 4	Fourth asking amount for the contact/project.	NUMBER			AMRCONT	AMRCONT_ASK_AMT_4	NO	NO
FOLLOWUP_ASSIGNEE_UID	Followup Assignee UID	System generated unique internal identification number assigned to this person.	NUMBER			GOBEACC	GOBEACC_PIDM	NO	NO
CONTACT_DATE_FISCAL_YEAR	Contact Date Fiscal Year	Unique identifier or code for the fiscal year.	VARCHAR2(63)			ATVFISC	ATVFISC_CODE	NO	NO
CONTACT_DATE_FISCAL_YEAR_DESC	Contact Date Fiscal Year Description	Fiscal year description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
CALL_REPORT_COMMENT	Call Report Comment	Call report used to elaborate on the contact explanation.	CLOB			AMRCONT	AMRCONT_CALL_REPORT	NO	NO
TICKLER_CONFIDENTIAL_IND	Tickler Confidential Indicator	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
CREATE_TICKLER_IND	Create Tickler Indicator	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
RECENT_TICKLER_STATUS	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	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
PLAN_MOVE_SEQUENCE_NUMBER	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
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
PROSPECT_CONTACT_IND	Prospect Contact Indicator	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
PRIMARY_STAFF_UID	Primary Staff UID	System generated unique internal identification number assigned to this person.	NUMBER			GOBEACC	GOBEACC_PIDM	NO	NO
TOTAL_EXPENSE	Total Expense	Total of all expenses for the contact.	NUMBER			FUNCTION	SUM(NVL(AMRPEXP_EXPN_AMT, 0))	NO	NO
PROSPECT_CONTACT_USER_ID	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
PROSPECT_CONTACT_ACTIVITY_DATE	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
MESSAGES_SENT_COUNT	Messages Sent Count	Number of messages sent for the contact.	NUMBER			GURTKLR	GURTKLR_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) active 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
TOTAL_STAFF_COUNT	Total Staff Count	Total number of staff attending the contact visit.	NUMBER			CALCULATION	COUNT(AMRATTN_PIDM)	NO	NO
CONTACT_CREATE_DATE	Contact Create Date	Date the contact was added.	DATE			AMRCONT	AMRCONT_CREATE_DATE	NO	NO

Ver: 9.2