Reporting View Source: AMRCONT

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

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

Ver: 8.4.1