RETURN TO BANNER EDW META DATA REPORTS LIST |
Source Column | Local Source | Target Type | Target | Target Column | Star Name | Local Target |
---|---|---|---|---|---|---|
AMRCONT_ACTIVITY_DATE | NO | REPORTING VIEW |
NA | NO |
||
AMRCONT_ASK_AMT | NO | FACT TABLE REPORTING VIEW |
CONTACT REPORT NA NA NA |
NO NO NO NO |
||
AMRCONT_ASK_AMT_2 | NO | REPORTING VIEW |
NA | NO |
||
AMRCONT_ASK_AMT_3 | NO | REPORTING VIEW |
NA | NO |
||
AMRCONT_ASK_AMT_4 | NO | REPORTING VIEW |
NA | NO |
||
AMRCONT_CALL_REPORT | NO | REPORTING VIEW |
NA | NO |
||
AMRCONT_CONTACT | NO | DIMENSION TABLE REPORTING VIEW |
CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE NA |
NO NO |
||
AMRCONT_CONTACT_DATE | NO | FACT TABLE REPORTING VIEW |
CONTACT REPORT CREDIT NA NA NA |
NO NO NO NO |
||
AMRCONT_CREATE_DATE | NO | REPORTING VIEW |
NA | NO |
||
AMRCONT_CREATE_TICKLER | NO | REPORTING VIEW |
NA | NO |
||
AMRCONT_IDEN_CODE | NO | FACT TABLE REPORTING VIEW |
CONTACT REPORT CREDIT NA NA NA NA NA NA |
NO NO NO NO NO NO NO |
||
AMRCONT_IDEN_CODE_ASGN | NO | REPORTING VIEW |
NA NA |
NO NO |
||
AMRCONT_ITEM_REFNO | NO | REPORTING VIEW |
NA NA NA |
NO NO NO |
||
AMRCONT_MOVE_CODE | NO | DIMENSION TABLE REPORTING VIEW |
CONTACT REPORT, MANAGE PROSPECT PIPELINE NA NA NA NA |
NO NO NO NO NO |
||
AMRCONT_MOVE_SEQ_NO | NO | REPORTING VIEW |
NA | NO |
||
AMRCONT_PIDM | NO | REPORTING VIEW |
NA NA NA NA |
NO NO NO NO |
||
AMRCONT_PROJ_CODE | NO | REPORTING VIEW |
NA NA NA |
NO NO NO |
||
AMRCONT_PROJ_CODE_2 | NO | REPORTING VIEW |
NA | NO |
||
AMRCONT_PROJ_CODE_3 | NO | REPORTING VIEW |
NA NA |
NO NO |
||
AMRCONT_PROJ_CODE_4 | NO | |||||
AMRCONT_PROP_CODE | NO | REPORTING VIEW |
NA NA |
NO NO |
||
AMRCONT_PROP_SEQ_NO | NO | REPORTING VIEW |
NA NA |
NO NO |
||
AMRCONT_SCNT_CODE | NO | DIMENSION TABLE REPORTING VIEW |
CONTACT REPORT CREDIT CONTACT REPORT, MANAGE PROSPECT PIPELINE NA |
NO NO NO |
||
AMRCONT_STGY_PLAN | NO | DIMENSION TABLE REPORTING VIEW |
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 |
CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE NA NA |
NO NO NO |
||
AMRCONT_TICK_DATE | NO | REPORTING VIEW |
NA NA |
NO NO |
||
AMRCONT_TICK_STATUS | NO | DIMENSION TABLE REPORTING VIEW |
CONTACT REPORT, CONTACT REPORT CREDIT, MANAGE PROSPECT PIPELINE NA |
NO NO |
||
AMRCONT_USER_ID | NO | REPORTING VIEW |
NA | NO |
||
AMRPEXP_ACTIVITY_DATE | NO | REPORTING VIEW |
NA | NO |
||
DECODE(TO_CHAR(AMRCONT_MOVE_SEQNO),NULL, 'N','Y') | NO | REPORTING VIEW |
NA | NO |