Composite View Source: AMRPLAN

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

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
AMRCONT_PROJ_CODE_2	AMAPLAN
AMRCONT_PROJ_CODE_3	AMAPLAN
AMRCONT_PROJ_CODE_4	AMAPLAN
AMRPLAN_ACTIVITY_DATE	AMAPLAN	AA_PROSPECT_MOVES_MANAGEMENT	PROSPECT_PLAN_ACTIVITY_DATE
AMRPLAN_IDEN_CODE	AMAPLAN	AA_CONSTITUENT_PLAN AA_PROSPECT_MOVES_MANAGEMENT	PERSON_RESPONSIBLE_ID PERSON_RESPONSIBLE_IDEN
AMRPLAN_MOVE_CODE	ATVMOVE	AA_CONSTITUENT_PLAN AA_PROSPECT_MOVES_MANAGEMENT	MOVE MOVE
AMRPLAN_PIDM	NA	AA_PROSPECT_MOVES_MANAGEMENT AA_CONSTITUENT_PLAN	ENTITY_UID PERSON_UID
AMRPLAN_PLAN_DATE	AMAPLAN	AA_PROSPECT_MOVES_MANAGEMENT AA_CONSTITUENT_PLAN	PLANNED_MOVE_DATE PLANNED_MOVE_DATE
AMRPLAN_PROJ_CODE	AMAPLAN	AA_CONSTITUENT_PLAN AA_PROSPECT_MOVES_MANAGEMENT	PROJECT PROJECT
AMRPLAN_STGY_PLAN	AMAPLAN	AA_PROSPECT_MOVES_MANAGEMENT	STRATEGY_PLAN
AMRPLAN_SYS_IND	AMAPLAN	AA_PROSPECT_MOVES_MANAGEMENT	PLANNED_MOVE_DATE_SOURCE
AMRPLAN_WAIT_DAYS	AMAPLAN	AA_PROSPECT_MOVES_MANAGEMENT	MOVE_INTERVAL
DECODE(AMRPLAN_SYS_IND,'S','SYSTEM', 'MANUAL')	TBD	AA_PROSPECT_MOVES_MANAGEMENT	PLANNED_MOVE_DATE_SOURCE_DESC

Ver: 8.3