| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| AMRCONT_ACTIVITY_DATE |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
PROSPECT_CONTACT_ACTIVITY_DATE |
NO |
|
| AMRCONT_ASK_AMT |
AMACONT |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT CONSTITUENT_CONTACT CONSTITUENT_PLAN |
ASK_AMOUNT ASKING_AMOUNT ASKING_AMOUNT |
NO NO NO |
|
| AMRCONT_ASK_AMT_2 |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
ASK_AMOUNT2 |
NO |
|
| AMRCONT_ASK_AMT_3 |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
ASK_AMOUNT3 |
NO |
|
| AMRCONT_ASK_AMT_4 |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
ASK_AMOUNT4 |
NO |
|
| AMRCONT_CALL_REPORT |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
CALL_REPORT_COMMENT |
NO |
|
| AMRCONT_CONTACT |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
CONTACT_COMMENT |
NO |
|
| AMRCONT_CONTACT_DATE |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT CONSTITUENT_PLAN PROSPECT_MOVES_MANAGEMENT |
CONTACT_DATE MOVE_COMPLETION_DATE MOVE_COMPLETION_DATE |
NO NO NO |
|
| AMRCONT_CREATE_DATE |
AMRCONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
CONTACT_CREATE_DATE |
NO |
|
| AMRCONT_CREATE_TICKLER |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
CREATE_TICKLER_IND |
NO |
|
| AMRCONT_IDEN_CODE |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT CONSTITUENT_PLAN PROSPECT_MOVES_MANAGEMENT PROSPECT_MOVES_MANAGEMENT CONSTITUENT_PLAN PROSPECT_STAFF_ASSIGNMENT |
PERSON_RESPONSIBLE_IDEN PERSON_COMPLETED_IDEN PERSON_COMPLETED_CONTACT_IDEN PERSON_RESPONSIBLE_IDEN PERSON_RESPONSIBLE_IDEN STAFF_IDEN |
NO NO NO NO NO NO |
|
| AMRCONT_IDEN_CODE_ASGN |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT CONSTITUENT_PLAN |
PERSON_COMPLETED_IDEN PRIMARY_STAFF_IDEN |
NO NO |
NA |
| AMRCONT_ITEM_REFNO |
AMACONT |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT CONSTITUENT_PLAN CONSTITUENT_CONTACT |
ITEM_REF_NUMBER ITEM_REF_NUMBER ITEM_REF_NUMBER |
NO NO NO |
NA |
| AMRCONT_MOVE_CODE |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_PLAN CONSTITUENT_PLAN PROSPECT_MOVES_MANAGEMENT CONSTITUENT_CONTACT |
MOVE UNPLANNED_MOVE MOVE MOVE |
NO NO NO NO |
|
| AMRCONT_MOVE_SEQ_NO |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
PLAN_MOVE_SEQUENCE_NUMBER |
NO |
|
| AMRCONT_PIDM |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_PLAN PROSPECT_STAFF_ASSIGNMENT CONSTITUENT_CONTACT PROSPECT_MOVES_MANAGEMENT |
PERSON_UID ENTITY_UID PERSON_UID ENTITY_UID |
NO NO NO NO |
NA |
| AMRCONT_PROJ_CODE |
AMACONT |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT CONSTITUENT_CONTACT CONSTITUENT_PLAN |
PROJECT PROJECT PROJECT |
NO NO NO |
NA |
| AMRCONT_PROJ_CODE_2 |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
PROJECT2 |
NO |
|
| AMRCONT_PROJ_CODE_3 |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT CONSTITUENT_CONTACT |
PROJECT3 PROJECT4 |
NO NO |
|
| AMRCONT_PROJ_CODE_4 |
AMACONT |
NO |
|
|
|
|
|
| AMRCONT_PROP_CODE |
AMACONT |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT CONSTITUENT_CONTACT |
PROPOSAL PROPOSAL |
NO NO |
|
| AMRCONT_PROP_SEQ_NO |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT PROSPECT_MOVES_MANAGEMENT |
PROPOSAL_SEQUENCE_NUMBER PROPOSAL_SEQUENCE_NUMBER |
NO NO |
|
| AMRCONT_SCNT_CODE |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
CONTACT_TYPE |
NO |
|
| AMRCONT_STGY_PLAN |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT PROSPECT_MOVES_MANAGEMENT |
STRATEGY_PLAN STRATEGY_PLAN |
NO NO |
|
| AMRCONT_TICKLER |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_PLAN CONSTITUENT_CONTACT |
TICKLER_MESSAGE TICKLER_MESSAGE |
NO NO |
|
| AMRCONT_TICK_DATE |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT CONSTITUENT_PLAN |
TICKLER_DATE TICKLER_DATE |
NO NO |
NA |
| AMRCONT_TICK_STATUS |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
RECENT_TICKLER_STATUS |
NO |
|
| AMRCONT_USER_ID |
AMACONT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
PROSPECT_CONTACT_USER_ID |
NO |
|
| AMRPEXP_ACTIVITY_DATE |
AMACONT |
NO |
REPORTING VIEW |
PROSPECT_CONTACT_EXPENSE |
CONTACT_EXPENSE_ACTIVITY_DATE |
NO |
|
| DECODE(TO_CHAR(AMRCONT_MOVE_SEQNO),NULL, 'N','Y') |
CALCULATION |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT |
PLANNED_MOVE_DATE_SOURCE_DESC |
NO |
|