SGHE Enterprise Data Warehouse
Banner EDW Source: AMRCONT - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| AMRCONT_ACTIVITY_DATE |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
PROSPECT_CONTACT_ACTIVITY_DATE |
NA |
NO |
| AMRCONT_ASK_AMT |
NO |
FACT TABLE
REPORTING VIEW |
WFT_CONTACT_REPORT CONSTITUENT_CONTACT CONSTITUENT_PLAN PROSPECT_MOVES_MANAGEMENT |
ASK_AMOUNT ASKING_AMOUNT ASKING_AMOUNT ASK_AMOUNT |
CONTACT REPORT NA NA NA |
NO NO NO NO |
| AMRCONT_ASK_AMT_2 |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
ASK_AMOUNT2 |
NA |
NO |
| AMRCONT_ASK_AMT_3 |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
ASK_AMOUNT3 |
NA |
NO |
| AMRCONT_ASK_AMT_4 |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
ASK_AMOUNT4 |
NA |
NO |
| AMRCONT_CALL_REPORT |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
CALL_REPORT_COMMENT |
NA |
NO |
| AMRCONT_CONTACT |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_CONTACT_REPORT CONSTITUENT_CONTACT |
CONTACT_DESCRIPTION CONTACT_COMMENT |
CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE NA |
NO NO |
| AMRCONT_CONTACT_DATE |
NO |
FACT TABLE
REPORTING VIEW |
WFT_CONTACT_REPORT_CREDIT PROSPECT_MOVES_MANAGEMENT CONSTITUENT_CONTACT CONSTITUENT_PLAN |
CONTACT_DATE MOVE_COMPLETION_DATE CONTACT_DATE MOVE_COMPLETION_DATE |
CONTACT REPORT CREDIT NA NA NA |
NO NO NO NO |
| AMRCONT_CREATE_DATE |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
CONTACT_CREATE_DATE |
NA |
NO |
| AMRCONT_CREATE_TICKLER |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
CREATE_TICKLER_IND |
NA |
NO |
| AMRCONT_IDEN_CODE |
NO |
FACT TABLE
REPORTING VIEW |
WFT_CONTACT_REPORT_CREDIT CONSTITUENT_CONTACT PROSPECT_STAFF_ASSIGNMENT CONSTITUENT_PLAN CONSTITUENT_PLAN PROSPECT_MOVES_MANAGEMENT PROSPECT_MOVES_MANAGEMENT |
CREDIT_RECIPIENT_ID PERSON_RESPONSIBLE_IDEN STAFF_IDEN PERSON_RESPONSIBLE_IDEN PERSON_COMPLETED_IDEN PERSON_COMPLETED_CONTACT_IDEN PERSON_RESPONSIBLE_IDEN |
CONTACT REPORT CREDIT NA NA NA NA NA NA |
NO NO NO NO NO NO NO |
| AMRCONT_IDEN_CODE_ASGN |
NO |
REPORTING VIEW |
CONSTITUENT_PLAN CONSTITUENT_CONTACT |
PRIMARY_STAFF_IDEN PERSON_COMPLETED_IDEN |
NA NA |
NO NO |
| AMRCONT_ITEM_REFNO |
NO |
REPORTING VIEW |
CONSTITUENT_PLAN PROSPECT_MOVES_MANAGEMENT CONSTITUENT_CONTACT |
ITEM_REF_NUMBER ITEM_REF_NUMBER ITEM_REF_NUMBER |
NA NA NA |
NO NO NO |
| AMRCONT_MOVE_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_CONTACT_REPORT_ATTRIBUTE CONSTITUENT_CONTACT CONSTITUENT_PLAN CONSTITUENT_PLAN PROSPECT_MOVES_MANAGEMENT |
CONTACT_REPORT_PURPOSE MOVE MOVE UNPLANNED_MOVE MOVE |
CONTACT REPORT, MANAGE PROSPECT PIPELINE NA NA NA NA |
NO NO NO NO NO |
| AMRCONT_MOVE_SEQ_NO |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
PLAN_MOVE_SEQUENCE_NUMBER |
NA |
NO |
| AMRCONT_PIDM |
NO |
REPORTING VIEW |
PROSPECT_STAFF_ASSIGNMENT CONSTITUENT_CONTACT CONSTITUENT_PLAN PROSPECT_MOVES_MANAGEMENT |
ENTITY_UID PERSON_UID PERSON_UID ENTITY_UID |
NA NA NA NA |
NO NO NO NO |
| AMRCONT_PROJ_CODE |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT CONSTITUENT_PLAN PROSPECT_MOVES_MANAGEMENT |
PROJECT PROJECT PROJECT |
NA NA NA |
NO NO NO |
| AMRCONT_PROJ_CODE_2 |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
PROJECT2 |
NA |
NO |
| AMRCONT_PROJ_CODE_3 |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT CONSTITUENT_CONTACT |
PROJECT3 PROJECT4 |
NA NA |
NO NO |
| AMRCONT_PROJ_CODE_4 |
NO |
|
|
|
|
|
| AMRCONT_PROP_CODE |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT PROSPECT_MOVES_MANAGEMENT |
PROPOSAL PROPOSAL |
NA NA |
NO NO |
| AMRCONT_PROP_SEQ_NO |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT CONSTITUENT_CONTACT |
PROPOSAL_SEQUENCE_NUMBER PROPOSAL_SEQUENCE_NUMBER |
NA NA |
NO NO |
| AMRCONT_SCNT_CODE |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_CONTACT_REPORT_CREDIT WDT_CONTACT_REPORT_ATTRIBUTE CONSTITUENT_CONTACT |
CONTACT_CREDIT_TYPE CONTACT_REPORT_TYPE CONTACT_TYPE |
CONTACT REPORT CREDIT CONTACT REPORT, MANAGE PROSPECT PIPELINE NA |
NO NO NO |
| AMRCONT_STGY_PLAN |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_CONTACT_REPORT WDT_CONTACT_REPORT WDT_CONTACT_REPORT CONSTITUENT_CONTACT PROSPECT_MOVES_MANAGEMENT |
CONTACT_STRATEGY CONTACT_STRATEGY_SD CONTACT_STRATEGY_LD STRATEGY_PLAN STRATEGY_PLAN |
CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE NA NA |
NO NO NO NO NO |
| AMRCONT_TICKLER |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_CONTACT_REPORT CONSTITUENT_CONTACT CONSTITUENT_PLAN |
CONTACT_ACTION_COMMENT TICKLER_MESSAGE TICKLER_MESSAGE |
CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE NA NA |
NO NO NO |
| AMRCONT_TICK_DATE |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT CONSTITUENT_PLAN |
TICKLER_DATE TICKLER_DATE |
NA NA |
NO NO |
| AMRCONT_TICK_STATUS |
NO |
DIMENSION TABLE
REPORTING VIEW |
WDT_CONTACT_REPORT CONSTITUENT_CONTACT |
CONTACT_ACTION_STATUS RECENT_TICKLER_STATUS |
CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE NA |
NO NO |
| AMRCONT_USER_ID |
NO |
REPORTING VIEW |
CONSTITUENT_CONTACT |
PROSPECT_CONTACT_USER_ID |
NA |
NO |
| AMRPEXP_ACTIVITY_DATE |
NO |
REPORTING VIEW |
PROSPECT_CONTACT_EXPENSE |
CONTACT_EXPENSE_ACTIVITY_DATE |
NA |
NO |
| DECODE(TO_CHAR(AMRCONT_MOVE_SEQNO),NULL, 'N','Y') |
NO |
REPORTING VIEW |
PROSPECT_MOVES_MANAGEMENT |
PLANNED_MOVE_DATE_SOURCE_DESC |
NA |
NO |