Reporting View Source: AMRCONT

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: AMRCONT Advancement Reporting View Meta Data Reports

**Banner Operational Data Store**
Source Column	Source Form	Local Source	Target Type	Target	Target Column	Local Target	Calculation Formula
AMRCONT_ACTIVITY_DATE	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT	PROSPECT_CONTACT_ACTIVITY_DATE	NO
AMRCONT_ASK_AMT	AMACONT	NO	REPORTING VIEW	PROSPECT_MOVES_MANAGEMENT CONSTITUENT_CONTACT CONSTITUENT_PLAN	ASK_AMOUNT ASKING_AMOUNT ASKING_AMOUNT	NO NO NO
AMRCONT_ASK_AMT_2	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT	ASK_AMOUNT2	NO
AMRCONT_ASK_AMT_3	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT	ASK_AMOUNT3	NO
AMRCONT_ASK_AMT_4	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT	ASK_AMOUNT4	NO
AMRCONT_CALL_REPORT	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT	CALL_REPORT_COMMENT	NO
AMRCONT_CONTACT	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT	CONTACT_COMMENT	NO
AMRCONT_CONTACT_DATE	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT CONSTITUENT_PLAN PROSPECT_MOVES_MANAGEMENT	CONTACT_DATE MOVE_COMPLETION_DATE MOVE_COMPLETION_DATE	NO NO NO
AMRCONT_CREATE_DATE	AMRCONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT	CONTACT_CREATE_DATE	NO
AMRCONT_CREATE_TICKLER	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT	CREATE_TICKLER_IND	NO
AMRCONT_IDEN_CODE	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT CONSTITUENT_PLAN PROSPECT_MOVES_MANAGEMENT PROSPECT_MOVES_MANAGEMENT CONSTITUENT_PLAN PROSPECT_STAFF_ASSIGNMENT	PERSON_RESPONSIBLE_IDEN PERSON_COMPLETED_IDEN PERSON_COMPLETED_CONTACT_IDEN PERSON_RESPONSIBLE_IDEN PERSON_RESPONSIBLE_IDEN STAFF_IDEN	NO NO NO NO NO NO
AMRCONT_IDEN_CODE_ASGN	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT CONSTITUENT_PLAN	PERSON_COMPLETED_IDEN PRIMARY_STAFF_IDEN	NO NO	NA
AMRCONT_ITEM_REFNO	AMACONT	NO	REPORTING VIEW	PROSPECT_MOVES_MANAGEMENT CONSTITUENT_PLAN CONSTITUENT_CONTACT	ITEM_REF_NUMBER ITEM_REF_NUMBER ITEM_REF_NUMBER	NO NO NO	NA
AMRCONT_MOVE_CODE	AMACONT	NO	REPORTING VIEW	CONSTITUENT_PLAN CONSTITUENT_PLAN PROSPECT_MOVES_MANAGEMENT CONSTITUENT_CONTACT	MOVE UNPLANNED_MOVE MOVE MOVE	NO NO NO NO
AMRCONT_MOVE_SEQ_NO	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT	PLAN_MOVE_SEQUENCE_NUMBER	NO
AMRCONT_PIDM	AMACONT	NO	REPORTING VIEW	CONSTITUENT_PLAN PROSPECT_STAFF_ASSIGNMENT CONSTITUENT_CONTACT PROSPECT_MOVES_MANAGEMENT	PERSON_UID ENTITY_UID PERSON_UID ENTITY_UID	NO NO NO NO	NA
AMRCONT_PROJ_CODE	AMACONT	NO	REPORTING VIEW	PROSPECT_MOVES_MANAGEMENT CONSTITUENT_CONTACT CONSTITUENT_PLAN	PROJECT PROJECT PROJECT	NO NO NO	NA
AMRCONT_PROJ_CODE_2	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT	PROJECT2	NO
AMRCONT_PROJ_CODE_3	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT CONSTITUENT_CONTACT	PROJECT3 PROJECT4	NO NO
AMRCONT_PROJ_CODE_4	AMACONT	NO
AMRCONT_PROP_CODE	AMACONT	NO	REPORTING VIEW	PROSPECT_MOVES_MANAGEMENT CONSTITUENT_CONTACT	PROPOSAL PROPOSAL	NO NO
AMRCONT_PROP_SEQ_NO	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT PROSPECT_MOVES_MANAGEMENT	PROPOSAL_SEQUENCE_NUMBER PROPOSAL_SEQUENCE_NUMBER	NO NO
AMRCONT_SCNT_CODE	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT	CONTACT_TYPE	NO
AMRCONT_STGY_PLAN	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT PROSPECT_MOVES_MANAGEMENT	STRATEGY_PLAN STRATEGY_PLAN	NO NO
AMRCONT_TICKLER	AMACONT	NO	REPORTING VIEW	CONSTITUENT_PLAN CONSTITUENT_CONTACT	TICKLER_MESSAGE TICKLER_MESSAGE	NO NO
AMRCONT_TICK_DATE	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT CONSTITUENT_PLAN	TICKLER_DATE TICKLER_DATE	NO NO	NA
AMRCONT_TICK_STATUS	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT	RECENT_TICKLER_STATUS	NO
AMRCONT_USER_ID	AMACONT	NO	REPORTING VIEW	CONSTITUENT_CONTACT	PROSPECT_CONTACT_USER_ID	NO
AMRPEXP_ACTIVITY_DATE	AMACONT	NO	REPORTING VIEW	PROSPECT_CONTACT_EXPENSE	CONTACT_EXPENSE_ACTIVITY_DATE	NO
DECODE(TO_CHAR(AMRCONT_MOVE_SEQNO),NULL, 'N','Y')	CALCULATION	NO	REPORTING VIEW	PROSPECT_MOVES_MANAGEMENT	PLANNED_MOVE_DATE_SOURCE_DESC	NO

Ver: 9.2