Composite View Source: AMRCONT

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: AMRCONT Advancement

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
AMRCONT_ACTIVITY_DATE	AMACONT	AA_CONSTITUENT_CONTACT	PROSPECT_CONTACT_ACTIVITY_DATE
AMRCONT_ASK_AMT	AMACONT	AA_CONSTITUENT_CONTACT AA_CONSTITUENT_PLAN AA_PROSPECT_MOVES_MANAGEMENT	ASKING_AMOUNT ASKING_AMOUNT ASK_AMOUNT
AMRCONT_ASK_AMT_2	AMACONT	AA_CONSTITUENT_CONTACT	ASK_AMOUNT2
AMRCONT_ASK_AMT_3	AMACONT	AA_CONSTITUENT_CONTACT	ASK_AMOUNT3
AMRCONT_ASK_AMT_4	AMACONT	AA_CONSTITUENT_CONTACT	ASK_AMOUNT4
AMRCONT_CALL_REPORT	AMACONT	AA_CONSTITUENT_CONTACT	CALL_REPORT_COMMENT
AMRCONT_CONTACT	AMACONT	AA_CONSTITUENT_CONTACT	CONTACT_COMMENT
AMRCONT_CONTACT_DATE	AMACONT	AA_CONSTITUENT_CONTACT AA_CONSTITUENT_PLAN AA_PROSPECT_MOVES_MANAGEMENT	CONTACT_DATE MOVE_COMPLETION_DATE MOVE_COMPLETION_DATE
AMRCONT_CREATE_TICKLER	AMACONT	AA_CONSTITUENT_CONTACT	CREATE_TICKLER_IND
AMRCONT_IDEN_CODE	AMACONT	AA_PROSPECT_MOVES_MANAGEMENT AA_CONSTITUENT_CONTACT AA_CONSTITUENT_PLAN AA_PROSPECT_MOVES_MANAGEMENT AA_PROSPECT_STAFF_ASSIGNMENT AA_CONSTITUENT_PLAN	PERSON_COMPLETED_CONTACT_IDEN PERSON_RESPONSIBLE_ID PERSON_COMPLETED_CONTACT_ID PERSON_RESPONSIBLE_IDEN STAFF_IDEN PERSON_RESPONSIBLE_ID
AMRCONT_IDEN_CODE_ASGN	AMACONT	AA_CONSTITUENT_CONTACT	PERSON_COMPLETED_CONTACT_ID
AMRCONT_ITEM_REFNO	AMACONT	AA_PROSPECT_MOVES_MANAGEMENT AA_CONSTITUENT_PLAN AA_CONSTITUENT_CONTACT	ITEM_REF_NUMBER ITEM_REF_NUMBER ITEM_REF_NUMBER
AMRCONT_MOVE_CODE	AMACONT	AA_CONSTITUENT_PLAN AA_PROSPECT_MOVES_MANAGEMENT AA_CONSTITUENT_CONTACT	UNPLANNED_MOVE MOVE MOVE
AMRCONT_MOVE_SEQ_NO	AMACONT	AA_CONSTITUENT_CONTACT	PLAN_MOVE_SEQUENCE_NUMBER
AMRCONT_PIDM	NA	AA_PROSPECT_MOVES_MANAGEMENT AA_CONSTITUENT_CONTACT AA_CONSTITUENT_PLAN AA_PROSPECT_STAFF_ASSIGNMENT	ENTITY_UID PERSON_UID PERSON_UID ENTITY_UID
AMRCONT_PROJ_CODE	AMACONT	AA_PROSPECT_MOVES_MANAGEMENT AA_CONSTITUENT_CONTACT AA_CONSTITUENT_PLAN	PROJECT PROJECT PROJECT
AMRCONT_PROJ_CODE_2	AMACONT	AA_PROSPECT_MOVES_MANAGEMENT AA_CONSTITUENT_CONTACT	PROJECT PROJECT2
AMRCONT_PROJ_CODE_3	AMACONT	AA_CONSTITUENT_CONTACT AA_PROSPECT_MOVES_MANAGEMENT AA_CONSTITUENT_CONTACT	PROJECT3 PROJECT PROJECT4
AMRCONT_PROJ_CODE_4	AMACONT	AA_PROSPECT_MOVES_MANAGEMENT	PROJECT
AMRCONT_PROP_CODE	AMACONT	AA_PROSPECT_MOVES_MANAGEMENT AA_CONSTITUENT_CONTACT	PROPOSAL PROPOSAL
AMRCONT_PROP_SEQ_NO	AMACONT	AA_PROSPECT_MOVES_MANAGEMENT AA_CONSTITUENT_CONTACT	PROPOSAL_SEQUENCE_NUMBER PROPOSAL_SEQUENCE_NUMBER
AMRCONT_SCNT_CODE	AMACONT	AA_CONSTITUENT_CONTACT	CONTACT_TYPE
AMRCONT_STGY_PLAN	AMACONT	AA_PROSPECT_MOVES_MANAGEMENT AA_CONSTITUENT_CONTACT	STRATEGY_PLAN STRATEGY_PLAN
AMRCONT_TICKLER	AMACONT	AA_CONSTITUENT_PLAN AA_CONSTITUENT_CONTACT	TICKLER_MESSAGE TICKLER_MESSAGE
AMRCONT_TICK_DATE	AMACONT	AA_CONSTITUENT_CONTACT AA_CONSTITUENT_PLAN	TICKLER_DATE TICKLER_DATE
AMRCONT_TICK_STATUS	AMACONT	AA_CONSTITUENT_CONTACT	RECENT_TICKLER_STATUS
AMRCONT_USER_ID	AMACONT	AA_CONSTITUENT_CONTACT	PROSPECT_CONTACT_USER_ID
AMRPEXP_ACTIVITY_DATE	AMACONT	AA_PROSPECT_CONTACT_EXPENSE	CONTACT_EXPENSE_ACTIVITY_DATE
DECODE(TO_CHAR(AMRCONT_MOVE_SEQNO),NULL, 'N','Y')	TBD

Ver: 8.3