Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: AMRPLAN Advancement Reporting View Meta Data Reports
SGHE Banner Operational Data Store Reporting View Source: AMRPLAN - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
AMRCONT_PROJ_CODE_2 AMAPLAN

REPORTING VIEW

PROSPECT_MOVES_MANAGEMENT

PROJECT

 
AMRCONT_PROJ_CODE_3 AMAPLAN

REPORTING VIEW

PROSPECT_MOVES_MANAGEMENT

PROJECT

 
AMRCONT_PROJ_CODE_4 AMAPLAN

REPORTING VIEW

PROSPECT_MOVES_MANAGEMENT

PROJECT

 
AMRPLAN_ACTIVITY_DATE AMAPLAN

REPORTING VIEW

PROSPECT_MOVES_MANAGEMENT

PROSPECT_PLAN_ACTIVITY_DATE

 
AMRPLAN_IDEN_CODE AMAPLAN       NA
AMRPLAN_MOVE_CODE ATVMOVE

REPORTING VIEW

PROSPECT_MOVES_MANAGEMENT

MOVE

NA
AMRPLAN_PIDM NA

REPORTING VIEW

CONSTITUENT_PLAN

PROSPECT_MOVES_MANAGEMENT

PERSON_UID

ENTITY_UID

NA
AMRPLAN_PLAN_DATE AMAPLAN

REPORTING VIEW

PROSPECT_MOVES_MANAGEMENT

CONSTITUENT_PLAN

PLANNED_MOVE_DATE

PLANNED_MOVE_DATE

NA
AMRPLAN_PROJ_CODE AMAPLAN

REPORTING VIEW

PROSPECT_MOVES_MANAGEMENT

PROJECT

NA
AMRPLAN_STGY_PLAN AMAPLAN

REPORTING VIEW

PROSPECT_MOVES_MANAGEMENT

STRATEGY_PLAN

 
AMRPLAN_SYS_IND AMAPLAN

REPORTING VIEW

PROSPECT_MOVES_MANAGEMENT

PLANNED_MOVE_DATE_SOURCE

 
AMRPLAN_WAIT_DAYS AMAPLAN

REPORTING VIEW

PROSPECT_MOVES_MANAGEMENT

MOVE_INTERVAL

 
DECODE(AMRPLAN_SYS_IND,'S','SYSTEM', 'MANUAL') TBD        


Ver: 9.0