Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
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
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
ASKING_AMOUNT	Asking Amount	Asking amount for the contact/project.	NUMBER		AMRCONT	AMRCONT_ASK_AMT
ASK_AMOUNT2	Ask Amount 2	Second asking amount for the contact/project.	NUMBER		AMRCONT	AMRCONT_ASK_AMT_2
ASK_AMOUNT3	Ask Amount 3	Third asking amount for the contact/project.	NUMBER		AMRCONT	AMRCONT_ASK_AMT_3
ASK_AMOUNT4	Ask Amount 4	Fourth asking amount for the contact/project.	NUMBER		AMRCONT	AMRCONT_ASK_AMT_4
CALL_REPORT_COMMENT	Call Report Comment	Call report used to elaborate on the contact explanation.	CLOB		AMRCONT	AMRCONT_CALL_REPORT
CONTACT_COMMENT	Contact Comment	Comment recorded for the contact made.	VARCHAR2(2000)		AMRCONT	AMRCONT_CONTACT
CONTACT_CREATE_DATE	Contact Create Date	Date the contact was added.	DATE		AMRCONT	AMRCONT_CREATE_DATE
CONTACT_DATE	Contact Date	Date the contact was made.	DATE		AMRCONT	AMRCONT_CONTACT_DATE
CONTACT_DATE_FISCAL_YEAR	Contact Date Fiscal Year	Unique identifier or code for the fiscal year.	VARCHAR2(63)		ATVFISC	ATVFISC_CODE
CONTACT_DATE_FISCAL_YEAR_DESC	Contact Date Fiscal Year Description	Fiscal year description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
CONTACT_TYPE	Contact Type	Type of contact between the institution and person.	VARCHAR2(63)		AMRCONT	AMRCONT_SCNT_CODE
CONTACT_TYPE_DESC	Contact Type Description	Contact type description.	VARCHAR2(255)		ATVSCNT	ATVSCNT_DESC
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
FOLLOWUP_ASSIGNEE_UID	Followup Assignee UID	System generated unique internal identification number assigned to this person.	NUMBER		GOBEACC	GOBEACC_PIDM
ITEM_REF_NUMBER	Item Ref Number	Internal generated number for each contact.	NUMBER		AMRCONT	AMRCONT_ITEM_REFNO
MESSAGES_SENT_COUNT	Messages Sent Count	Number of messages sent for the contact.	NUMBER		GURTKLR	GURTKLR_PIDM
MOVE	Move	Move code associated with a plan or associated with a contact that is not plan related.	VARCHAR2(63)		AMRCONT	AMRCONT_MOVE_CODE
MOVE_DESC	Move Description	Move code description.	VARCHAR2(255)		ATVMOVE	ATVMOVE_DESC
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)		NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)		NA	NA
PERSON_COMPLETED_IDEN	Person Completed ID	Identification code assigned to contact.	VARCHAR2(63)		AMRCONT	AMRCONT_IDEN_CODE_ASGN
PERSON_COMPLETED_IDEN_NAME	Person Completed ID Name	Staff member name responsible for the follow-up action.	VARCHAR2(255)		GURIDEN	GURIDEN_DESC
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
PERSON_RESPONSIBLE_IDEN_NAME	Person Responsible ID Name	Name of the person assigned to make the contact.	VARCHAR2(255)		GURIDEN	GURIDEN_DESC
PERSON_RESPONSIBLE_UID	Person Responsible UID	System generated unique internal identification number assigned to this person.	NUMBER		SPRIDEN	SPRIDEN_PIDM
PERSON_UID	Person UID	System generated Banner unique ID which gets assigned to all person and non-person records within Banner.	NUMBER		AMRCONT	AMRCONT_PIDM
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
PRIMARY_STAFF_IDEN	Primary Staff ID	Staff identification code of the person with primary responsibility for the prospect.	VARCHAR2(63)		AMRSTAF	AMRSTAF_IDEN_CODE
PRIMARY_STAFF_IDEN_NAME	Primary Staff ID Name	Name of the person with primary responsibility for this prospect.	VARCHAR2(255)		GURIDEN	GURIDEN_DESC
PRIMARY_STAFF_UID	Primary Staff UID	System generated unique internal identification number assigned to this person.	NUMBER		GOBEACC	GOBEACC_PIDM
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
PROJECT	Project	Project/interest code.	VARCHAR2(63)		AMRCONT	AMRCONT_PROJ_CODE
PROJECT2	Project 2	Second project or interest area.	VARCHAR2(63)		AMRCONT	AMRCONT_PROJ_CODE_2
PROJECT3	Project 3	Third project or interest area.	VARCHAR2(63)		AMRCONT	AMRCONT_PROJ_CODE_3
PROJECT4	Project 4	Fourth project or interest area.	VARCHAR2(63)		AMRCONT	AMRCONT_PROJ_CODE_3
PROJECT_DESC	Project Description	Project/interest description.	VARCHAR2(255)		ATVPROJ	ATVPROJ_DESC
PROJECT_DESC2	Project Description 2	Second project or interest area description.	VARCHAR2(255)		ATVPROJ	ATVPROJ_DESC
PROJECT_DESC3	Project Description 3	Third project or interest area description.	VARCHAR2(255)		ATVPROJ	ATVPROJ_DESC
PROJECT_DESC4	Project Description 4	Fourth project or interest area description.	VARCHAR2(255)		ATVPROJ	ATVPROJ_DESC
PROPOSAL	Proposal	Proposal code associated to the prospect.	VARCHAR2(63)		AMRCONT	AMRCONT_PROP_CODE
PROPOSAL_SEQUENCE_NUMBER	Proposal Sequence Number	Proposal code sequence number.	NUMBER		AMRCONT	AMRCONT_PROP_SEQ_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
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)
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
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
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
STAFF_ASSIGNED_COUNT	Staff Assigned Count	Count of staff assigned.	NUMBER		FUNCTION	MAKFUNC.F_COUNT_STAFF_ASSIGNMENT
START_DATE_FISCAL_YEAR	Start Date Fiscal Year	Unique identifier or code for the fiscal year.	VARCHAR2(63)		ATVFISC	ATVFISC_CODE
START_DATE_FISCAL_YEAR_DESC	Start Date Fiscal Year Description	Fiscal year description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
STRATEGY_PLAN	Strategy Plan	Strategy plan name.	VARCHAR2(63)		AMRCONT	AMRCONT_STGY_PLAN
STRATEGY_PLAN_END_DATE	Strategy Plan End Date	Strategy plan end date.	DATE		CALCULATION	NVL(AMBPLAN_END_DATE,'31-DEC-2099')
STRATEGY_PLAN_SEQUENCE_NUMBER	Strategy Plan Sequence Number	Internal sequence number allowing multiple strategies for the strategy plan.	NUMBER		AMBPLAN	AMBPLAN_PLAN_SEQ_NO
STRATEGY_PLAN_START_DATE	Strategy Plan Start Date	Strategy plan start date.	DATE		AMBPLAN	AMBPLAN_START_DATE
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
STRATEGY_PLAN_STATUS_IND_DESC	Strategy Plan Status Indicator Description	Strategy plan status description.	VARCHAR2(255)		AMBPLAN	AMBPLAN_STATUS_IND
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)
TICKLER_DATE	Tickler Date	Tickler message date.	DATE		AMRCONT	AMRCONT_TICK_DATE
TICKLER_MESSAGE	Tickler Message	Tickler message.	VARCHAR2(255)		AMRCONT	AMRCONT_TICKLER
TOTAL_EXPENSE	Total Expense	Total of all expenses for the contact.	NUMBER		FUNCTION	SUM(NVL(AMRPEXP_EXPN_AMT, 0))
TOTAL_STAFF_COUNT	Total Staff Count	Total number of staff attending the contact visit.	NUMBER		CALCULATION	COUNT(AMRATTN_PIDM)

Ver: 9.0