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

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_CONSTITUENT_PLAN

AA_PROSPECT_MOVES_MANAGEMENT

PERSON_UID

ENTITY_UID

NA
AMRPLAN_PLAN_DATE AMAPLAN COMPOSITE VIEW

AA_CONSTITUENT_PLAN

AA_PROSPECT_MOVES_MANAGEMENT

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: