Composite View Source: AMRPLAN

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

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

Ver: