Reporting View Source: AMRPLAN

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

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

Ver: 8.3