Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
AMRCONT_PROJ_CODE_2 |
AMAPLAN |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT |
PROJECT |
NO |
|
AMRCONT_PROJ_CODE_3 |
AMAPLAN |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT |
PROJECT |
NO |
|
AMRCONT_PROJ_CODE_4 |
AMAPLAN |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT |
PROJECT |
NO |
|
AMRPLAN_ACTIVITY_DATE |
AMAPLAN |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT |
PROSPECT_PLAN_ACTIVITY_DATE |
NO |
|
AMRPLAN_IDEN_CODE |
AMAPLAN |
NO |
|
|
|
|
NA |
AMRPLAN_MOVE_CODE |
ATVMOVE |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT |
MOVE |
NO |
NA |
AMRPLAN_PIDM |
NA |
NO |
REPORTING VIEW |
CONSTITUENT_PLAN PROSPECT_MOVES_MANAGEMENT |
PERSON_UID ENTITY_UID |
NO NO |
NA |
AMRPLAN_PLAN_DATE |
AMAPLAN |
NO |
REPORTING VIEW |
CONSTITUENT_PLAN PROSPECT_MOVES_MANAGEMENT |
PLANNED_MOVE_DATE PLANNED_MOVE_DATE |
NO NO |
NA |
AMRPLAN_PROJ_CODE |
AMAPLAN |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT |
PROJECT |
NO |
NA |
AMRPLAN_STGY_PLAN |
AMAPLAN |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT |
STRATEGY_PLAN |
NO |
|
AMRPLAN_SYS_IND |
AMAPLAN |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT |
PLANNED_MOVE_DATE_SOURCE |
NO |
|
AMRPLAN_WAIT_DAYS |
AMAPLAN |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT |
MOVE_INTERVAL |
NO |
|
DECODE(AMRPLAN_SYS_IND,'S','SYSTEM', 'MANUAL') |
TBD |
NO |
|
|
|
|
|