Oracle® Communications Data Model Reference Release 11.3.2 E28440-05 |
|
|
PDF · Mobi · ePub |
This chapter provides information about the physical data model of Oracle Communications Data Model.
This chapter includes the following sections:
The Physical Data Model of the Oracle Communications Data Model is the physical manifestation of the logical data model into database tables and relationships (or foreign key constraints). Partitions, indexes, and Materialized Views have been added to aid performance.
The Physical data model includes the following:
Important:
Do not make changes to the schemas as such changes are not supported.Oracle Communications Data Model provides the following types of tables:
Reference tables contain information that is usually used as dimensions. They usually do not change often (or at all). Typically, Reference tables are PARTY, CUSTOMER, ADDRESS LOCATION, ACCOUNT, SUBSCRIPTION, and so on
Lookup tables in the foundation layer are added to save the definition of short codes used in other tables.
Base tables store information about any type of transactions (Calls Data Records or CDRs, Invoices, Payments, Business Interactions, and so on). They are usually transformed into facts.
Derived Tables in the analytic layer are usually transition tables to STARs. They are also leveraged for the Mining models.
Aggregate Tables, or materialized views, are the STAR schema themselves at a higher level of aggregation. They may be related to the OLAP cubes.
Other table types, as show in Table 4-2.
For more information on Oracle Communications Data Model table types, see "What is Oracle Communications Data Model".
Table 4-1 shows the table name prefix conventions. When you examine the predefined physical model, keep in mind the naming conventions shown in Table 4-1 that use DW (Data Warehouse) prefixes to identify the types of tables and views.
Table 4-3 briefly describes the Reference tables in Oracle Communications Data Model.
Table Name | More Information |
---|---|
DWR_ACCS_MTHD |
|
DWR_ACCS_MTHD_ACCT_ASGN |
|
DWR_ACCS_MTHD_ASGN |
|
DWR_ACCS_MTHD_ELMNT |
|
DWR_ACCS_MTHD_EQPMNT_ASGN |
|
DWR_ACCS_MTHD_GEO_ASGN |
|
DWR_ACCS_MTHD_POOL |
|
DWR_ACCS_MTHD_PROD_SBRP_ASGN |
|
DWR_ACCS_MTHD_PRTY_ASGN |
|
DWR_ACCS_MTHD_SGMNT |
|
DWR_ACCS_MTHD_SRVC_ASGN |
|
DWR_ACCSRS |
|
DWR_ACCSRS_INSTNC |
|
DWR_ACCT |
|
DWR_ACCT_AGRMNT_RLTN |
|
DWR_ACCT_ASGN |
|
DWR_ACCT_BAL_GRP |
|
DWR_ACCT_BLLG_CYCL_HIST |
|
DWR_ACCT_BLLG_FRQNCY_HIST |
|
DWR_ACCT_BLLG_PRD_HIST |
|
DWR_ACCT_BSNS_INTRACN_RL |
|
DWR_ACCT_PREF_INVC_DLVRY |
|
DWR_ACCT_PYMT_MTHD |
|
DWR_ACCT_PRFL |
|
DWR_ACCT_PROD_SBRP_ASGN |
|
DWR_ACCT_PRTY_PROD_OFR_RLTN |
|
DWR_ACCT_PYMT_PLN_ASGN |
|
DWR_ACCT_SGMNT |
|
DWR_ACCT_SGMNT_ASGN_HIST |
|
DWR_ACCT_SGMNT_MDL |
|
DWR_ACCT_TAX_EXMPT_ASGN |
|
DWR_ADDR_LOC |
|
DWR_ADDR_LOC_ADMIN_AREA_ASGN |
|
DWR_ADDR_LOC_NAME |
|
DWR_ADDR_PHONE |
|
DWR_ADDR_RLTD |
|
DWR_ADMINSTVE_AREA |
|
DWR_ADTNL_TXT |
|
DWR_ADVR_PRD |
|
DWR_ADVR_QTR |
|
DWR_ADVR_WK |
|
DWR_ADVR_YR |
|
DWR_AF_SRVC |
|
DWR_AGNT |
|
DWR_AGGRTN_INTRFC |
|
DWR_AGRMNT |
|
DWR_AGRMNT_ASGN |
|
DWR_AGRMNT_DOC |
|
DWR_AGRMNT_INTNT |
|
DWR_AGRMNT_ITEM |
|
DWR_AGRMNT_PROD_SPEC_ASGN |
|
DWR_AGRMNT_SRVCLVL_AGRMNT_RLTN |
|
DWR_ALWNCE_SBRP_PRICE_ALTRTN |
|
DWR_AM_SGMNT_PROD_CPBLTY_RL |
|
DWR_AMRCN_PRPTY_ADDR |
|
DWR_ANZSIC_CLSFCTN |
|
DWR_ASSET |
|
DWR_ASSET_PRTY_ASSOCTN |
|
DWR_ASSET_SITE_ASGN |
|
DWR_ATM_INTRFC |
|
DWR_ATONOMS_SYS |
|
DWR_AUXILIARY_CMPNT |
|
DWR_BASE_DAY |
|
DWR_BASE_STN_CNTRLR |
|
DWR_BASE_TRNSCVR_STN |
|
DWR_BLLG_CYCL |
|
DWR_BNK |
|
DWR_BNK_DRCT_DEBIT_CHNL |
|
DWR_BRDBND_RTNG_PLN |
|
DWR_BRDBND_SRVC |
|
DWR_BRDGNG_PROTCL |
|
DWR_BRND |
|
DWR_BROWSER_VRSN |
|
DWR_BSNS_ASSET |
|
DWR_BSNS_HLF_MO |
|
DWR_BSNS_HLF_YR |
|
DWR_BSNS_INTRACN_ASGN |
|
DWR_BSNS_INTRACN_CHAR |
|
DWR_BSNS_INTRACN_CHAR_VAL |
|
DWR_BSNS_INTRACN_ITEM_SPEC |
|
DWR_BSNS_INTRACN_LOC_ASGN |
|
DWR_BSNS_INTRACN_SPEC |
|
DWR_BSNS_MO |
|
DWR_BSNS_QTR |
|
DWR_BSNS_UNIT_JB_RL |
|
DWR_BSNS_UNIT_SHFT |
|
DWR_BSNS_WK |
|
DWR_BSNS_YR |
|
DWR_CALL_CNTR |
|
DWR_CALL_CNTR_AGNT |
|
DWR_CALL_CNTR_SRVC_CAPBLTY |
|
DWR_CALL_FRWD |
|
DWR_CALL_SRC_DSTN |
|
DWR_CALLR_ID |
|
DWR_CARD |
|
DWR_CARD_RLTN |
|
DWR_CBL |
|
DWR_CBL_MDM |
|
DWR_CELL |
|
DWR_CELL_SCTR |
|
DWR_CELL_SITE |
|
DWR_CFGBL_PROSPCCHAR_PROSPCAGN |
|
DWR_CFGBL_PROD_SPEC_CHAR |
|
DWR_CFS_SPEC_VRSN_DTL |
|
DWR_CHASSIS |
|
DWR_CHASSIS_POSN |
|
DWR_CHNL |
|
DWR_CLASS_BASEWTD_FAIRQUE_SRVC |
|
DWR_CLNDR_HLF_MO |
|
DWR_CLNDR_HLF_YR |
|
DWR_CLNDR_MO |
|
DWR_CLNDR_QTR |
|
DWR_CLNDR_WK |
|
DWR_CLNDR_YR |
|
DWR_CLNT_HOST |
|
DWR_CLSSIFR_SRVC |
|
DWR_CMPGN |
|
DWR_CMPGN_CHAR |
|
DWR_CMPGN_CHAR_VAL |
|
DWR_CMPGN_CHNL |
|
DWR_CMPGN_CHNL_ASGN |
|
DWR_CMPGN_DOC |
|
DWR_CMPGN_MEDIA |
|
DWR_CMPGN_MEDIA_SLNG_ITEM |
|
DWR_CMPGN_MGMT_HIST |
|
DWR_CMPGN_MSG |
|
DWR_CMPGN_MSG_DPCT |
|
DWR_CMPGN_RLTN |
|
DWR_CMPGN_TERM_VAL |
|
DWR_CMPND_CNDITNNG_ELMNT |
|
DWR_CMPND_RSCE_CMPND_DTL_ASGN |
|
DWR_CMPND_RSCE_COLLCTN |
|
DWR_CMPND_RSCE_DTL |
|
DWR_CMPND_RSCE_RL |
|
DWR_CMPND_RSCE_RL_ASGN |
|
DWR_CMPND_RSCE_RL_SPEC |
|
DWR_CMPND_RSCE_SPEC |
|
DWR_CMPND_RSCE_SPEC_ATMC |
|
DWR_CMPND_RSCE_SPEC_CMPST |
|
DWR_CMPND_RSCE_TP_DTL |
|
DWR_CMPND_RSCE_UNIT |
|
DWR_CMPND_RSCE |
|
DWR_CMPST_COMP_PROD_CRL_CHAR |
|
DWR_CMPST_PROD_SPEC |
|
DWR_CMPST_PROD_SPEC_ASGN |
|
DWR_CMPST_SRVC |
|
DWR_CMPST_SRVC_INCLSN |
|
DWR_CMPST_SRVC_TYP_INCLSN |
|
DWR_CMPTR |
|
DWR_CMPTR_INTLGNCE |
|
DWR_CMPTR_INTLGNCE_PRTY_RL |
|
DWR_CMPTR_MKT_SGMNT_ASGN |
|
DWR_CMPTR_MKT_SGMNT_SWOT |
|
DWR_CMPTR_PROD_CRLTN |
|
DWR_CMPTR_SWOT |
|
DWR_CMPTR_TIER_ASGN |
|
DWR_CMST_PRODOFR_PRC_CMNT_ASGN |
|
DWR_CMPTVE_TIER |
|
DWR_CNCT_LST |
|
DWR_CNCTN |
|
DWR_CNCTN_TMNT_PNT |
|
DWR_CNSEQ_PRFMNC_NTFCTN_SPEC |
|
DWR_CNTNT |
|
DWR_CNTNT_PRICE |
|
DWR_CNTNT_PRVDR |
|
DWR_COLLCTN |
|
DWR_COLLCTN_AGNCY |
|
DWR_COMP_INTL_CHAR |
|
DWR_COMP_INTL_CHAR_VAL |
|
DWR_COMP_INTL_MKT_SGMNT |
|
DWR_COMP_PROD_CRRL_CHAR |
|
DWR_COMP_PROD_CRRL_CHAR_ASGN |
|
DWR_COMP_PROD_CRRL_CHAR_RLTN |
|
DWR_COMP_PROD_CRRL_CHAR_VAL |
|
DWR_COMPLEX_ADDR |
|
DWR_COMUNICTN_SRVC |
|
DWR_CORE_INTRFC |
|
DWR_COST_CNTR |
|
DWR_COURIER |
|
DWR_CPCTY |
|
DWR_CPE_LGICL_DVC_RL |
|
DWR_CRCUT_CMPNT |
|
DWR_CRDT_CTGRY |
|
DWR_CRDT_SCR_PRVDR |
|
DWR_CRNCY_GEO_ENT_ASGN |
|
DWR_CROSSD_THRSHLD |
|
DWR_CSTM_QUENG_SRVC |
|
DWR_CUST |
|
DWR_CUST_ACCT |
|
DWR_CUST_ADDR |
|
DWR_CUST_AFFLTN |
|
DWR_CUST_CLASS_ASGN |
|
DWR_CUST_CLSTR |
|
DWR_CUST_COMMUNITY |
|
DWR_CUST_DOC |
|
DWR_CUST_FCNG_SRVC |
|
DWR_CUST_FCNG_SRVC_RL |
|
DWR_CUST_FCNG_SRVC_SPEC |
|
DWR_CUST_FCNG_SRVC_SPEC_ATMC |
|
DWR_CUST_FCNG_SRVC_SPEC_CMPST |
|
DWR_CUST_FCNG_SRVC_SPEC_RL |
|
DWR_CUST_FCNG_SRVC_SPEC_VRSN |
|
DWR_CUST_GRP_ASGN |
|
DWR_CUST_GRP_ITEM |
|
DWR_CUST_INDVL |
|
DWR_CUST_OCCSN |
|
DWR_CUST_ORDR_DOC |
|
DWR_CUST_ORG |
|
DWR_CUST_PREF |
|
DWR_CUST_RLTN |
|
DWR_CUST_RSTRCT_INFO |
|
DWR_CUST_RVN_BND_ASGN |
|
DWR_CUST_SCR |
|
DWR_CUST_SGMNT |
|
DWR_CUST_SGMNT_MDL |
|
DWR_CUST_SIC_ASGN |
|
DWR_CUST_SRC |
|
DWR_DAY |
|
DWR_DAY_ACT_CONDITION |
|
DWR_DAY_TODATE_TRANS |
|
DWR_DAY_TRANS |
|
DWR_DEAL |
|
DWR_DEAL_LN_ITEM |
|
DWR_DEMOG_ATRIB |
|
DWR_DEMOG_CHAR |
|
DWR_DEMOG_CHAR_VAL |
|
DWR_DEMOG_GRP |
|
DWR_DFCT_RND_RBIN_SCHDLNG_SRVC |
|
DWR_DIFFSERV_SRVC |
|
DWR_DISC_GRP |
|
DWR_DISC_SBRP_PRICE_ALTRTN |
|
DWR_DLR |
|
DWR_DLR_DISC_GRP_ASGN |
|
DWR_DOC_TYP_GRP_ASGN |
|
DWR_DOMAIN |
|
DWR_DRPPR_SRVC |
|
DWR_DRVD_VAL |
|
DWR_DSL_MDM |
|
DWR_DVC_INTRFC |
|
DWR_DVC_INTRFC_DTL |
|
DWR_DVC_INTRFC_PHY_PRT_ASGN |
|
DWR_DVC_INTRFC_RL |
|
DWR_DVC_INTRFC_TP_ASGN |
|
DWR_EDGE_INTRFC |
|
DWR_EF_SRVC |
|
DWR_EIGHT_ZERO_TWO_SRVC |
|
DWR_EML_ADDR |
|
DWR_EML_SRVC |
|
DWR_EMP |
|
DWR_EMP_DISC_GRP_ASGN |
|
DWR_EMP_JB_RL_ASGN |
|
DWR_EMP_LANG_CAPBLTY |
|
DWR_EMP_RSTRCT_INFO |
|
DWR_EMP_SCHL |
|
DWR_ENT |
|
DWR_ENT_RL |
|
DWR_ENT_SPEC |
|
DWR_EQPMNT |
|
DWR_EQPMNT_CNTR |
|
DWR_EQPMNT_FNCTNLTY |
|
DWR_EQPMNT_FNCTNLTY_ASGN |
|
DWR_EQPMNT_HLDR |
|
DWR_EQPMNT_INSTNC |
|
DWR_EQPMNT_RNTNG_AGRMNT |
|
DWR_EVT_LOC |
|
DWR_EVT_PRTY_INTRACN_CHAR_VAL |
|
DWR_EXCHNG_LOC |
|
DWR_EXCLD_PRT_DTL |
|
DWR_EXTRNL_CRDT_PRFL |
|
DWR_EXTRNL_CRDT_PRFL_ASGN |
|
DWR_EXTRNL_INFO_SRC |
|
DWR_EXTRNL_OPRTR |
|
DWR_FAIR_QUENG_SRVC |
|
DWR_FCTR_CMPNY |
|
DWR_FDA |
|
DWR_FIXED_LN_PRT |
|
DWR_FIXED_LN_RTNG_PLN |
|
DWR_FIXED_LN_SRVC |
|
DWR_FRWL_RL |
|
DWR_FSAM |
|
DWR_FSCL_HLF_MO |
|
DWR_FSCL_HLF_YR |
|
DWR_FSCL_MO |
|
DWR_FSCL_QTR |
|
DWR_FSCL_WK |
|
DWR_FSCL_YR |
|
DWR_FXBLE_CHAR |
|
DWR_FXBLE_CHAR_ASGN |
|
DWR_FXBLE_CHAR_RLTN |
|
DWR_FXBLE_CHAR_VAL |
|
DWR_FXBLE_CHAR_VAL_ASGN |
|
DWR_FXBLE_CHAR_VAL_RLTN |
|
DWR_GEO_BLDG |
|
DWR_GEO_CITY |
|
DWR_GEO_CNTRY |
|
DWR_GEO_CNTY |
|
DWR_GEO_COMPLEX |
|
DWR_GEO_DEMOG_ATRIB |
|
DWR_GEO_DEMOG_GRP |
|
DWR_GEO_DEMOG_VAL |
|
DWR_GEO_ENT |
|
DWR_GEO_ENT_ASGN |
|
DWR_GEO_ENT_HIER_LVL_ASGN |
|
DWR_GEO_HRCHY |
|
DWR_GEO_HRCHY_LVL |
|
DWR_GEO_HRCHY_LVL_ASGN |
|
DWR_GEO_LVL |
|
DWR_GEO_LVL_ATRIB |
|
DWR_GEO_LVL_ATRIB_VAL |
|
DWR_GEO_RGN |
|
DWR_GEO_SBRGN |
|
DWR_GEO_STATE |
|
DWR_GEO_STRT |
|
DWR_GEO_WORLD |
|
DWR_GL_ACCT |
|
DWR_GL_ACCT_ASGN |
|
DWR_GL_ACCT_SGMNT |
|
DWR_GL_COST_CNTR_SGMNT |
|
DWR_GL_LDGR |
|
DWR_GL_LDGR_ACCT_ASGN |
|
DWR_GL_ORG_BSNS_UNIT_SGMNT |
|
DWR_GL_PRD |
|
DWR_GL_PROD_SPEC_SGMNT |
|
DWR_GL_PROJ_SGMNT |
|
DWR_GL_REF |
|
DWR_GL_SBLDGR |
|
DWR_GL_SGMNT |
|
DWR_GPRS_SRVC |
|
DWR_HEAD_TAIL_DRPPR_SRVC |
|
DWR_HH |
|
DWR_HLDR_ATMC |
|
DWR_HLDR_CMPST |
|
DWR_HLF_HR |
|
DWR_HLF_MO_TODATE_TRANS |
|
DWR_HLF_MO_TRANS |
|
DWR_HLF_YR_TODATE_TRANS |
|
DWR_HLF_YR_TRANS |
|
DWR_HM_SBCRBR_SERVER |
|
DWR_HNDST_INSTNC |
|
DWR_HNDST_MDL |
|
DWR_HR |
|
DWR_HRDWR |
|
DWR_IDD |
|
DWR_IN_PLTFRM |
|
DWR_IN_RUTNG_DVC |
|
DWR_INDVL_DEMOG_PRFL |
|
DWR_INDVL_DEMOG_VAL |
|
DWR_INDVL_NAME |
|
DWR_INSTLMNT_AGRMNT |
|
DWR_INTRACN_CHNL |
|
DWR_INTRACN_NAVGTN_ASGN |
|
DWR_INTRACN_NAVGTN_ITEM |
|
DWR_INTRACN_NAVGTN_TYP_VRSN |
|
DWR_INV_LOC |
|
DWR_INVC_ADJ_QTA |
|
DWR_INVC_PRCS_ASGN |
|
DWR_IP_ADDR |
|
DWR_IP_ADDR_POOL |
|
DWR_IP_SUBNET |
|
DWR_IPV4_ADDR |
|
DWR_ISP |
|
DWR_ISP_BSNS |
|
DWR_ISP_BSNS_ASGN |
|
DWR_ISP_USER |
|
DWR_ITEM_CLASS |
|
DWR_ITEM_CLSTR |
|
DWR_ITEM_CMPNY |
|
DWR_ITEM_DEPT |
|
DWR_ITEM_DIV |
|
DWR_ITEM_GRP |
|
DWR_ITEM_SBC |
|
DWR_ITEM_SPEC |
|
DWR_IVR_MENU_CNTNT |
|
DWR_IVR_MENU_ITEM |
|
DWR_JB |
|
DWR_JB_RL |
|
DWR_JUR |
|
DWR_KEY_PRFMNC_IND_SLS_PARM |
|
DWR_KEY_QLTY_IND_SLS_PARM |
|
DWR_LAN |
|
DWR_LAN_PROTCL |
|
DWR_LAND_PARCEL_ADDR |
|
DWR_LANG_DIALECT |
|
DWR_LAYER_NTWK |
|
DWR_LCL_ADDR_LOC |
|
DWR_LGICL_CPCTY |
|
DWR_LGICL_DVC |
|
DWR_LGICL_DVC_ATMC |
|
DWR_LGICL_DVC_CMPST |
|
DWR_LGICL_DVC_OS_ASGN |
|
DWR_LGICL_DVC_RL |
|
DWR_LGICL_DVC_RL_SPEC |
|
DWR_LGICL_DVC_SPEC |
|
DWR_LGICL_INTRFC |
|
DWR_LGICL_RSCE |
|
DWR_LGICL_RSCE_PHY_SPPRT |
|
DWR_LGICL_RSCE_RL |
|
DWR_LGICL_RSCE_RL_ASGN |
|
DWR_LGICL_RSCE_RL_SPEC |
|
DWR_LGICL_RSCE_SPEC |
|
DWR_LGICL_RSCE_SPEC_ATMC |
|
DWR_LGICL_RSCE_SPEC_CMPST |
|
DWR_LGICL_RSCE_SPEC_PHY_SPPRT |
|
DWR_LGICL_RSCE_SPEC_VRSN |
|
DWR_LYLTY_PROG |
|
DWR_LYLTY_TIER |
|
DWR_LYLTY_TIER_CLASS |
|
DWR_MAILBOX |
|
DWR_MANAGED_ENT |
|
DWR_MANAGED_HRDWR |
|
DWR_MANAGED_TRNSMISN_ENT |
|
DWR_MBL_SWTCHNG_CNTR |
|
DWR_MBRSHIP_ACCT |
|
DWR_MDIA_ITRFC_LGL_INTRFC_ASGN |
|
DWR_MEDIA_INTRFC |
|
DWR_MEDIA_OBJ |
|
DWR_MEDIA_OBJ_ASGN |
|
DWR_MGMT_DOMAIN |
|
DWR_MGMT_INFO |
|
DWR_MGMT_PROTCL |
|
DWR_MKT_AREA |
|
DWR_MKT_AREA_LVL |
|
DWR_MKT_SGMNT |
|
DWR_MKT_SGMNT_CHAR |
|
DWR_MKT_SGMNT_CHAR_VAL |
|
DWR_MKT_STTSTCS |
|
DWR_MMS_SRVC |
|
DWR_MNITRD_CLASS_CRTRA |
|
DWR_MNITRD_INSTNCS_CRTRA |
|
DWR_MNITRD_OBJS_CRTRA |
|
DWR_MNT |
|
DWR_MO_TODATE_TRANS |
|
DWR_MO_TRANS |
|
DWR_MRKR_POOL |
|
DWR_MRKR_SRVC |
|
DWR_MRKR_SRVC_MRKR_POOL_ASGN |
|
DWR_MSRMNT_JB |
|
DWR_MTR_PRFL |
|
DWR_MTR_SRVC |
|
DWR_MTR_SRVC_PRFL_ASGN |
|
DWR_MUS_DNLD |
|
DWR_NAICS_CLSFCTN |
|
DWR_NAICS_INDSTRY |
|
DWR_NAICS_INDSTRY_GRP |
|
DWR_NAICS_INDSTRY_SCTR |
|
DWR_NAICS_INDSTRY_SUBSCTR |
|
DWR_NBR_AREA |
|
DWR_NBR_CNTRY |
|
DWR_NEGOTIATED_SRVC_LVL_SPEC |
|
DWR_NP_MBL_MSISDN |
|
DWR_NTWK |
|
DWR_NTWK_ADDR |
|
DWR_NTWK_ADDR_INTRFC_BNDNG |
|
DWR_NTWK_ASGN |
|
DWR_NTWK_ATMC |
|
DWR_NTWK_CMPST |
|
DWR_NTWK_CPCTY |
|
DWR_NTWK_DOMAIN |
|
DWR_NTWK_DOMAIN_ASGN |
|
DWR_NTWK_FRWRDNG_SRVC |
|
DWR_NTWK_ROUTE |
|
DWR_NTWK_ROUTE_PNT |
|
DWR_NTWK_ROUTE_PNT_ASGN |
|
DWR_NTWK_ROUTE_SECTN |
|
DWR_NTWK_SITE |
|
DWR_NTWK_SRVC_COVRG_ASGN |
|
DWR_NTWK_TCHPNT |
|
DWR_OPERTNG_SYS |
|
DWR_ORACLE_GEOMETRY |
|
DWR_ORG |
|
DWR_ORG_AREA |
|
DWR_ORG_BNR |
|
DWR_ORG_BSNS_ENT |
|
DWR_ORG_BSNS_UNIT |
|
DWR_ORG_CHAIN |
|
DWR_ORG_CMPNY |
|
DWR_ORG_CRPRT |
|
DWR_ORG_DIV |
|
DWR_ORG_DSTRCT |
|
DWR_ORG_HRCHY |
|
DWR_ORG_HRCHY_LVL |
|
DWR_ORG_HRCHY_LVL_ASGN |
|
DWR_ORG_HRCHY_VRSN |
|
DWR_ORG_ITEM_SLNG_PRICE |
|
DWR_ORG_LVL |
|
DWR_ORG_LVL_ATRIB_VAL |
|
DWR_ORG_LVL_ATTR |
|
DWR_ORG_MKT_DATA |
|
DWR_ORG_NAME |
|
DWR_ORG_RGN |
|
DWR_ORG_SRVC_WBSITE |
|
DWR_ORG_WRHS |
|
DWR_ORGNTL_DEMOG_VAL |
|
DWR_OS_LICNS_ASGN |
|
DWR_OTHR_INDVL |
|
DWR_P_LGICL_DVC_RL |
|
DWR_PASPRT |
|
DWR_PBLCTN |
|
DWR_PDSPC_CHRVL_RESPC_CHRVL_AN |
|
DWR_PE_LGICL_DVC_RL |
|
DWR_PG |
|
DWR_PHONE_NBR |
|
DWR_PHONE_NBR_POOL |
|
DWR_PHS |
|
DWR_PHY_CMPNT |
|
DWR_PHY_CNCTR |
|
DWR_PHY_CONTNR |
|
DWR_PHY_CPCTY |
|
DWR_PHY_CPCTY_DTL |
|
DWR_PHY_DVC |
|
DWR_PHY_DVC_ATMC |
|
DWR_PHY_DVC_CMPST |
|
DWR_PHY_DVC_RL_SPEC |
|
DWR_PHY_DVC_RL_SPEC_DTL |
|
DWR_PHY_DVC_SPEC |
|
DWR_PHY_EQPMNT |
|
DWR_PHY_LNK |
|
DWR_PHY_PRT |
|
DWR_PHY_PRT_RSCE_PRT_ASGN |
|
DWR_PHY_RSCE |
|
DWR_PHY_RSCE_ADDR |
|
DWR_PHY_RSCE_CHAR |
|
DWR_PHY_RSCE_PROD_SBRP |
|
DWR_PHY_RSCE_RL |
|
DWR_PHY_RSCE_RL_ASGN |
|
DWR_PHY_RSCE_RL_SPEC |
|
DWR_PHY_RSCE_RL_SPEC_DTL |
|
DWR_PHY_RSCE_SPEC |
|
DWR_PHY_RSCE_SPEC_ATMC |
|
DWR_PHY_RSCE_SPEC_CMPST |
|
DWR_PIPE |
|
DWR_PIT_CHAR |
|
DWR_PLCIR_SRVC |
|
DWR_PLCY |
|
DWR_PLCY_ACTN |
|
DWR_PLCY_ACTN_ASGN |
|
DWR_PLCY_ACTN_ATMC |
|
DWR_PLCY_ACTN_CMPST |
|
DWR_PLCY_ACTN_RULE_ASGN |
|
DWR_PLCY_ACTN_VNDR |
|
DWR_PLCY_APPLN_ASGN |
|
DWR_PLCY_CNDTN |
|
DWR_PLCY_CNDTN_ASGN |
|
DWR_PLCY_CNDTN_ATMC |
|
DWR_PLCY_CNDTN_CMPST |
|
DWR_PLCY_CNDTN_RULE_ASGN |
|
DWR_PLCY_CNDTN_TIME_PRD |
|
DWR_PLCY_CNDTN_VNDR |
|
DWR_PLCY_GRP |
|
DWR_PLCY_GRP_EXEC_DTL |
|
DWR_PLCY_OPRTR |
|
DWR_PLCY_OPRTR_VARBLE_ASGN |
|
DWR_PLCY_RL |
|
DWR_PLCY_RULE |
|
DWR_PLCY_SET |
|
DWR_PLCY_SET_ASGN |
|
DWR_PLCY_STMT |
|
DWR_PLCY_VAL |
|
DWR_PLCY_VARBLE |
|
DWR_PLCY_VARBLE_VAL_ASGN |
|
DWR_PLNG_PRD |
|
DWR_PLNG_QTR |
|
DWR_PLNG_SEASON |
|
DWR_PLNG_WK |
|
DWR_PLNG_YR |
|
DWR_PNT_BLCK |
|
DWR_PNT_CD |
|
DWR_POS_DEPT |
|
DWR_POSTCD |
|
DWR_PRAMBL_MRKNG_DTLS_ASGN |
|
DWR_PRAMBL_MRKR_SRVC |
|
DWR_PRBLM_TRBLE_TCKT_ASGN |
|
DWR_PRCS |
|
DWR_PRCE_EVT_PRODOFR_PRCE_ASGN |
|
DWR_PRCS_EVT_ASGN |
|
DWR_PRCS_PRMTR |
|
DWR_PRCS_PRMTR_ASGN |
|
DWR_PRCS_PRMTR_VAL |
|
DWR_PRCS_RLTN |
|
DWR_PRCS_SPEC |
|
DWR_PRCS_SPEC_RLTN |
|
DWR_PRD_TODATE_TRANS |
|
DWR_PRD_TRANS |
|
DWR_PRDSPC_CHR_RSCESPC_CHR_AGN |
|
DWR_PRFMNC_APLBLETY |
|
DWR_PRFMNC_CAT_CHAR_VAL |
|
DWR_PRFMNC_CAT_SPEC |
|
DWR_PRFMNC_CAT_SPEC_RLTN |
|
DWR_PRFMNC_CHAR_VAL |
|
DWR_PRFMNC_CTGRY |
|
DWR_PRFMNC_CTGRY_RLTN |
|
DWR_PRFMNC_IND_RLTN |
|
DWR_PRFMNC_IND_SPEC_RLTN |
|
DWR_PRFMNC_IND_SPEC |
|
DWR_PRFMNC_IP_ADDR |
|
DWR_PRFMNC_NTFCTN_SPEC |
|
DWR_PRFMNC_NTWK_ADDR |
|
DWR_PRFMNC_OBJ_APLBLETY_CNSEQ |
|
DWR_PRFMNC_OBJCTV |
|
DWR_PRFMNC_OBJCTV_APLBLETY |
|
DWR_PRFMNC_PNT_CD |
|
DWR_PRFMNC_SPEC |
|
DWR_PRFMNC_SPEC_INTRVL_CNVRSN |
|
DWR_PRFMNC_SPEC_INTRVL |
|
DWR_PRICE_DRVTN_RULE |
|
DWR_PRICE_TYP_RLTN |
|
DWR_PRIORITY_QUENG_SRVC |
|
DWR_PRMTN |
|
DWR_PRMTN_MSG_RNDRNG |
|
DWR_PRMTN_PROD_CTLG_ASGN |
|
DWR_PRMTN_PROD_OFR_ASGN |
|
DWR_PRMTN_RLTN |
|
DWR_PRMTN_SL_CHNL_ASGN |
|
DWR_PROD |
|
DWR_PRODOFR_PRODOFR_PRICE_ASGN |
|
DWR_PROD_CAPBLTY |
|
DWR_PROD_CAPBLTY_VAL |
|
DWR_PROD_CHAR_VAL |
|
DWR_PROD_COVRG_AREA |
|
DWR_PROD_COVRG_GEO_DTL |
|
DWR_PROD_CTLG |
|
DWR_PROD_CTLG_CHAR |
|
DWR_PROD_CTLG_CHAR_ASGN |
|
DWR_PROD_CTLG_CHAR_RLTN |
|
DWR_PROD_CTLG_CHAR_VAL |
|
DWR_PROD_CTLG_CHAR_VAL_ASGN |
|
DWR_PROD_CTLG_CHAR_VAL_RLTN |
|
DWR_PROD_CTLG_GEO_ASGN |
|
DWR_PROD_CTLG_PROD_OFR_ASGN |
|
DWR_PROD_CTLG_SL_CHNL_ASGN |
|
DWR_PROD_FNCTNLTY_DPNDNTCY |
|
DWR_PROD_GEO_ASGN |
|
DWR_PROD_OFR |
|
DWR_PROD_OFR_AVLBLTY |
|
DWR_PROD_OFR_DOC_REQRMNT |
|
DWR_PROD_OFR_GEO_ASGN |
|
DWR_PROD_OFR_GRP |
|
DWR_PROD_OFR_GRP_ASGN |
|
DWR_PROD_OFR_MKT_SGMNT_AVLBLTY |
|
DWR_PROD_OFR_ORG_AVLBLTY |
|
DWR_PROD_OFR_PRICE |
|
DWR_PROD_OFR_PRICE_CMPNT |
|
DWR_PROD_OFR_PRICE_CMPST |
|
DWR_PROD_OFR_PRICE_PLCY_ACTN |
|
DWR_PROD_OFR_PRICE_PLCY_CNDTN |
|
DWR_PROD_OFR_PRICE_PLCY_VAL |
|
DWR_PROD_OFR_PRICE_PLCY_VAR |
|
DWR_PROD_OFR_PRICE_RCRNG |
|
DWR_PROD_OFR_PRICE_RLTN |
|
DWR_PROD_OFR_PROD_ASGN |
|
DWR_PROD_OFR_PROD_SPEC_ASGN |
|
DWR_PROD_OFR_RLTN |
|
DWR_PROD_OFR_RTNG_PLN |
|
DWR_PROD_OFR_RTNG_PLN_DTL |
|
DWR_PROD_OFR_SUB_BY_DOC |
|
DWR_PROD_OFR_TERM |
|
DWR_PROD_PRICE_ALTRTN |
|
DWR_PROD_PRICE_CMPNT |
|
DWR_PROD_PRICE_PRTY_RL |
|
DWR_PROD_PROD_CAPBLTY_VAL_ASGN |
|
DWR_PROD_RLTN |
|
DWR_PROD_SBRP |
|
DWR_PROD_SBRP_ASGN |
|
DWR_PROD_SBRP_PRICE |
|
DWR_PROD_SBRP_PRICE_RLTN |
|
DWR_PROD_SBRP_PRODOFRPRIE_ASGN |
|
DWR_PROD_SPEC |
|
DWR_PROD_SPEC_ADTNL_TXT |
|
DWR_PROD_SPEC_CHAR |
|
DWR_PROD_SPEC_CHAR_CFG_ASGN |
PRODUCT SPECIFICATION CHARACTERISTIC CONFIGURABLE ASSIGNMENT |
DWR_PROD_SPEC_CHAR_RLTN |
|
DWR_PROD_SPEC_CHAR_USE |
|
DWR_PROD_SPEC_CHAR_VAL |
|
DWR_PROD_SPEC_CHAR_VAL_RLTN |
|
DWR_PROD_SPEC_CHAR_VAL_USE |
|
DWR_PROD_SPEC_GRP_ASGN |
|
DWR_PROD_SPEC_HIST |
|
DWR_PROD_SPEC_NTWK_ASGN |
|
DWR_PROD_SPEC_RLTN |
|
DWR_PROD_SPEC_VRSN |
|
DWR_PROD_USRNM |
|
DWR_PROJ |
|
DWR_PROJ_ELMNT |
|
DWR_PROPOSAL |
|
DWR_PROPOSAL_RLTN |
|
DWR_PROTCL |
|
DWR_PRPD_VCHR |
|
DWR_PRPD_VCHR_BTCH |
|
DWR_PRPD_VCHR_RCHRG_OPTN |
|
DWR_PRPD_VCHR_SPEC |
|
DWR_PRPTY |
|
DWR_PRPTY_ADDR_LOC_ASGN |
|
DWR_PRSPCT |
|
DWR_PRSPCT_INDVL |
|
DWR_PRSPCT_ORG |
|
DWR_PRSPCT_QLTY_SCR_VAL |
|
DWR_PRSPCT_RSTRCT_INFO |
|
DWR_PRTNR_PRMTN_PROG |
|
DWR_PRTY |
|
DWR_PRTY_ACCT_ASGN |
|
DWR_PRTY_ADDR_LOC_ASGN |
|
DWR_PRTY_AGRMNT_ASGN |
|
DWR_PRTY_ASGN |
|
DWR_PRTY_BSNS_INTRACN_RL |
|
DWR_PRTY_CNCT_INFO |
|
DWR_PRTY_DEMOG |
|
DWR_PRTY_DEMOG_VAL |
|
DWR_PRTY_GEO_ENT_ASGN |
|
DWR_PRTY_ID |
|
DWR_PRTY_LANG_CAPBLTY |
|
DWR_PRTY_MKT_SGMNT_ASGN |
|
DWR_PRTY_NAME |
|
DWR_PRTY_PRFL |
|
DWR_PRTY_PRFL_CHAR_ASGN |
|
DWR_PRTY_PRFL_TYP_CHAR |
|
DWR_PRTY_PRFL_TYP_CHAR_VAL |
|
DWR_PRTY_PROD_SBRP_ASGN |
|
DWR_PRTY_RL_ASGN |
|
DWR_PRTY_RL_CTGRY_ASGN |
|
DWR_PRTY_RL_OS_PRCS_ASGN |
|
DWR_PRTY_RL_PRFL_ASGN |
|
DWR_PRTY_RL_STAT |
|
DWR_PRTY_SIM_CARD_ASGN |
|
DWR_PRTY_SKILL |
|
DWR_PRTY_SRVC_ASGN |
|
DWR_PTS_EXPRY_BASIS |
|
DWR_PV_BIT_STRING_VAL |
|
DWR_PV_BOLEN_VAL |
|
DWR_PV_INTEGER_VAL |
|
DWR_PV_IP_ADDR_VAL |
|
DWR_PV_MAC_ADDR_VAL |
|
DWR_PV_STRING_VAL |
|
DWR_PVAR_1QCOS_VARBLE |
|
DWR_PVAR_BIT_STRING_VARBLE |
|
DWR_PVAR_DN_VARBLE |
|
DWR_PVAR_DSCP_VARBLE |
|
DWR_PVAR_ETHER_TYP_VARBLE |
|
DWR_PVAR_IPTOS_VARBLE |
|
DWR_PVAR_IPV4_VARBLE |
|
DWR_PVAR_IPV6_FLOW_ID_VARBLE |
|
DWR_PVAR_IPV6_VARBLE |
|
DWR_PVAR_IPVRSN_VARBLE |
|
DWR_PVAR_IP_PROTCL_VARBLE |
|
DWR_PVAR_MAC_VARBLE |
|
DWR_PVAR_PRT_VARBLE |
|
DWR_PVAR_STRING_VARBLE |
|
DWR_PVAR_VLAN_VARBLE |
|
DWR_PYMT_CHNL |
|
DWR_PYMT_PLN |
|
DWR_PYTV_SRVC |
|
DWR_QOS_SRVC |
|
DWR_QOS_SRVC_RLTN |
|
DWR_QUE_SRVC |
|
DWR_QTR_HR |
|
DWR_QTR_TODATE_TRANS |
|
DWR_QTR_TRANS |
|
DWR_RACK |
|
DWR_RED_DRPPR_SRVC |
|
DWR_RED_SRVC_ELMNT |
|
DWR_REFERRING_CTGRY |
|
DWR_REFERRING_CTGRY_LVL |
|
DWR_REFERRING_URL |
|
DWR_RF_CARRIER |
|
DWR_RFS_SPEC_VRSN_DTL |
|
DWR_RL |
|
DWR_RLS_HRCHY |
|
DWR_RND_RBIN_SCHDLNG_SRVC |
|
DWR_RNGTN |
|
DWR_ROOT_ENT |
|
DWR_ROUTED_PROTCL |
|
DWR_ROUTER |
|
DWR_RPLCMT_SET |
|
DWR_RSCE |
|
DWR_RSCE_CHAR |
|
DWR_RSCE_CHAR_ASGN |
|
DWR_RSCE_CHAR_RLTN |
|
DWR_RSCE_CHAR_VAL |
|
DWR_RSCE_CHAR_VAL_ASGN |
|
DWR_RSCE_CHAR_VAL_RLTN |
|
DWR_RSCE_FCNG_SRVC |
|
DWR_RSCE_FCNG_SRVC_RL |
|
DWR_RSCE_FCNG_SRVC_SPEC |
|
DWR_RSCE_FCNG_SRVC_SPEC_ATMC |
|
DWR_RSCE_FCNG_SRVC_SPEC_CMPST |
|
DWR_RSCE_FCNG_SRVC_SPEC_RL |
|
DWR_RSCE_FCNG_SRVC_SPEC_VRSN |
|
DWR_RSCE_INVLMNT_RL |
|
DWR_RSCE_PRFMNC_SPEC |
|
DWR_RSCE_PRT |
|
DWR_RSCE_PRTY_ASSOCTN |
|
DWR_RSCE_PRTY_MGMT |
|
DWR_RSCE_RL |
|
DWR_RSCE_RL_ASGN |
|
DWR_RSCE_RL_PRTY_ASGN |
|
DWR_RSCE_RL_PRTY_RL_DTLS |
|
DWR_RSCE_RL_SPEC |
|
DWR_RSCE_RLTN |
|
DWR_RSCE_SPEC |
|
DWR_RSCE_SPEC_CHAR |
|
DWR_RSCE_SPEC_CHAR_ASGN |
|
DWR_RSCE_SPEC_CHAR_RLTN |
|
DWR_RSCE_SPEC_CHAR_VAL |
|
DWR_RSCE_SPEC_CHAR_VAL_ASGN |
|
DWR_RSCE_SPEC_CHAR_VAL_RLTN |
|
DWR_RSCE_SPEC_PERF_RL |
|
DWR_RSCE_SPEC_VRSN |
|
DWR_RSCE_SPEC_VRSN_USG |
|
DWR_RTL_STORE |
|
DWR_RTL_TCHPNT |
|
DWR_RUTNG_DVC |
|
DWR_RUTNG_PROTCL |
|
DWR_RUTNG_RL |
|
DWR_SB_NTWK |
|
DWR_SBRP_RSCE_RL_ASGN |
|
DWR_SBRP_SRVC_ASGN |
|
DWR_SBRP_SRVC_CLASS_ASGN |
|
DWR_SCHDLNG_SRVC |
|
DWR_SCHDLNG_SRVC_ATMC |
|
DWR_SCHDLNG_SRVC_CMPST |
|
DWR_SCND |
|
DWR_SCRPT |
|
DWR_SCRPT_QUES |
|
DWR_SEARCH |
|
DWR_SECURE_HLDR |
|
DWR_SERVER |
|
DWR_SERVER_FARM |
|
DWR_SET_TOP_BOX |
|
DWR_SET_TOP_BOX_MDL |
|
DWR_SGMNT_CRTRA |
|
DWR_SGNLNG_PROTCL |
|
DWR_SHELF |
|
DWR_SHPR_SRVC |
|
DWR_SIC_ASGN |
|
DWR_SIC_DIV |
|
DWR_SIM_CARD |
|
DWR_SIM_CARD_ACCS_MTHD_ASGN |
|
DWR_SIM_CARD_HNDST_ASGN |
|
DWR_SIM_CARD_PROD_SBRP_ASGN |
|
DWR_SITE |
|
DWR_SITE_INTRFC_RL |
|
DWR_SITE_RL |
|
DWR_SKU_ITEM |
|
DWR_SL_CHNL |
|
DWR_SL_CHNL_RPRSTV |
|
DWR_SL_CMISN_PLN |
|
DWR_SL_CMISN_PLN_DTL |
|
DWR_SLNG_LOC |
|
DWR_SLT |
|
DWR_SLT_RLTN |
|
DWR_SMS_RTNG_PLN |
|
DWR_SMS_SRVC |
|
DWR_SOC_JB |
|
DWR_SOC_JB_CTGRY |
|
DWR_SOC_JB_GRP |
|
DWR_SOC_JB_MJR_GRP |
|
DWR_SOFTWARE |
|
DWR_SOFTWARE_ATMC |
|
DWR_SOFTWARE_CMND |
|
DWR_SOFTWARE_CMPST |
|
DWR_SOFTWARE_FTR_SETS |
|
DWR_SOFTWARE_OS_RLTN |
|
DWR_SPEC |
|
DWR_SPEC_RL |
|
DWR_SPLMNTR_SRVC |
|
DWR_SPNM_OTHR_PRTY_NBR |
|
DWR_SPTRUM_COVRG_AREA |
|
DWR_SRC_SYS |
|
DWR_SRC_SYS_KEY_MAPPING |
|
DWR_SRSPC_CHRVL_RESPC_CHRVL_AN |
SERVICE SPECIFICATION CHAR VAL RESOURCE SPEC CHAR VAL ASSIGNMENT |
DWR_SRVC |
|
DWR_SRVC_ADDR_LOC_ASGN |
|
DWR_SRVC_BNDL |
|
DWR_SRVC_BNDL_SPEC |
|
DWR_SRVC_BNDL_SPEC_ATMC |
|
DWR_SRVC_BNDL_SPEC_CMPST |
|
DWR_SRVC_CHAR_VAL |
|
DWR_SRVC_CHAR_VAL_RLTN |
|
DWR_SRVC_CHRVL_PROD_CHRVL_ASGN |
SERVICE CHARACTERISTIC VALUE PRODUCT CHARACTERISTIC VALUE ASSIGNMENT |
DWR_SRVC_COVRG_AREA |
|
DWR_SRVC_COVRG_GEO_DTL |
|
DWR_SRVC_DPNDCY |
|
DWR_SRVC_DVC_INTRFC_ASGN |
|
DWR_SRVC_EQPMNT_ASGN |
|
DWR_SRVC_LR_DPNDCY |
|
DWR_SRVC_LVL_AGRMNT |
|
DWR_SRVC_LVL_AGRMNT_ITEM |
|
DWR_SRVC_LVL_AGRMNT_RLTN |
|
DWR_SRVC_LVL_OBJCTV |
|
DWR_SRVC_LVL_SPEC_APLCBLTY |
|
DWR_SRVC_LVL_SPEC_CNSEQ |
|
DWR_SRVC_LVL_SPEC_PRMTR |
|
DWR_SRVC_PKG |
|
DWR_SRVC_PKG_BNDL_DTL |
|
DWR_SRVC_PKG_SPEC |
|
DWR_SRVC_PKG_SPEC_ATMC |
|
DWR_SRVC_PKG_SPEC_CMPST |
|
DWR_SRVC_PR_DPNDCY |
|
DWR_SRVC_PRBLM_CHAR |
|
DWR_SRVC_PRBLM_CHAR_VAL |
|
DWR_SRVC_PRFMNC_SPEC |
|
DWR_SRVC_PRTY_MGMT_HIST |
|
DWR_SRVC_RL |
|
DWR_SRVC_RSCE_ASGN |
|
DWR_SRVC_SPEC |
|
DWR_SRVC_SPEC_ATMC |
|
DWR_SRVC_SPEC_CHAR |
|
DWR_SRVC_SPEC_CHAR_RLTN |
|
DWR_SRVC_SPEC_CHAR_USE |
|
DWR_SRVC_SPEC_CHAR_VAL |
|
DWR_SRVC_SPEC_CHAR_VAL_ASGN |
|
DWR_SRVC_SPEC_CHAR_VAL_RLTN |
|
DWR_SRVC_SPEC_CHAR_VAL_USE |
|
DWR_SRVC_SPEC_CMPST |
|
DWR_SRVC_SPEC_PROD_SPEC_RLTN |
|
DWR_SRVC_SPEC_RLTN |
|
DWR_SRVC_SPEC_RL |
|
DWR_SRVC_SPEC_RSCE_SPEC_RLTN |
|
DWR_SRVC_SPEC_VRSN |
|
DWR_SRVC_UTLZTN_DTL |
|
DWR_SRVSPC_CHR_RSCESPC_CHR_AGN |
|
DWR_STNDRD_MRKR_SRVC |
|
DWR_STRCT_SCHDLNG_SRVC |
|
DWR_STRT_NAME |
|
DWR_STRT_SGMNT |
|
DWR_STRT_SGMNT_ADDR_ASGN |
|
DWR_STTSTCL_ENT |
|
DWR_SURVEY |
|
DWR_SWTCH |
|
DWR_SWTCH_CAPBLTY |
|
DWR_SWTCH_CMMND |
|
DWR_SWTCH_RUTNG_DVC_ASGN |
|
DWR_SWTCHNG_PROTCL |
|
DWR_SWTCHNG_RL |
|
DWR_SYMBLGY |
|
DWR_TASK |
|
DWR_TAX_AUTH |
|
DWR_TAX_EXMPT |
|
DWR_TEMPLATE_SRVC_LVL_SPEC |
|
DWR_TIME_BND |
|
DWR_TIME_SLT |
|
DWR_TIME_STNDRD_BY_DAY |
|
DWR_TIME_STNDRD_BY_WK |
|
DWR_TIME_TOT |
|
DWR_TMNT_PNT |
|
DWR_TNDR |
|
DWR_TOKN_BCKT |
|
DWR_TOS_SRVC |
|
DWR_TRAIL |
|
DWR_TRAIL_TMNT_PNT |
|
DWR_TRFC_CNDITNNG_SRVC |
|
DWR_TRFC_ID_SRVC |
|
DWR_TRFC_MTCH_CRTRA |
|
DWR_TRGT_ACCS_MTHD |
|
DWR_TRGT_ACCT |
|
DWR_TRGT_AGRMNT |
|
DWR_TRGT_GEO_AREA |
|
DWR_TRGT_MKT_SGMNT |
|
DWR_TV_CHNL |
|
DWR_UDR_EVT_CHAR |
|
DWR_UDR_EVT_CHAR_RLTN |
|
DWR_UDR_EVT_CHAR_VAL |
|
DWR_UDR_EVT_SPEC |
|
DWR_UDR_EVT_SPEC_CHAR |
|
DWR_UDR_EVT_SPEC_CHAR_USE |
|
DWR_UDR_EVT_SPEC_CHAR_VAL |
|
DWR_UDR_EVT_SPEC_CHAR_VAL_RLTN |
|
DWR_UDR_EVT_SPEC_CHAR_VAL_USE |
|
DWR_UDR_EVT_SPEC_RLTN |
|
DWR_UDR_EVT_SPEC_VRSN |
|
DWR_UDR_EVT_TYP_VRSN |
|
DWR_URBN_PRPTY_ADDR |
|
DWR_USER |
|
DWR_VAL_ADD_SRVC |
|
DWR_VAL_CSTM |
|
DWR_VAL_STNDRD |
|
DWR_VARBLE_CSTM |
|
DWR_VARBLE_STNDRD |
|
DWR_VAS_SBRP |
|
DWR_VHCL |
|
DWR_VISITOR |
|
DWR_VNDR |
|
DWR_VNDR_AGRMNT |
|
DWR_VNDR_FCTR_CMPNY_ASGN |
|
DWR_VNDR_RTNG |
|
DWR_VNDR_SITE |
|
DWR_VNDR_SITE_COURIER_ASGN |
|
DWR_VOI_MSG_SRVC |
|
DWR_VPN_LGICL_DVC_RL |
|
DWR_VPN_SRVC |
|
DWR_VRTL_TEAM |
|
DWR_WAN_PROTCL |
|
DWR_WEATHR_CNDTN |
|
DWR_WBSITE |
|
DWR_WBSITE_USER |
|
DWR_WEB_PG |
|
DWR_WEB_PG_CNTNT |
|
DWR_WK_TODATE_TRANS |
|
DWR_WK_TRANS |
|
DWR_WKDAY |
|
DWR_WRLS_RSCE |
|
DWR_WRLS_RTNG_PLN |
|
DWR_WRLS_SPTRUM |
|
DWR_WRLS_SRVC |
|
DWR_WTD_FAIR_QUENG_SRVC |
|
DWR_WTD_RND_RBIN_SCHDLNG_SRVC |
|
DWR_YR_TRANS |
Table 4-4 briefly describes the Lookup tables in Oracle Communications Data Model.
Table Name | More Information |
---|---|
DWL_ACCS_MTHD_ASGN_TYP |
|
DWL_ACCS_MTHD_ELMNT_TYP |
|
DWL_ACCS_MTHD_PRTY_ASGN_TYP |
|
DWL_ACCS_MTHD_STAT_RSN |
|
DWL_ACCS_MTHD_STAT_TYP |
|
DWL_ACCS_MTHD_TYP |
|
DWL_ACCT_ADJ_RSN |
|
DWL_ACCT_ASGN_RSN |
|
DWL_ACCT_ASGN_TYP |
|
DWL_ACCT_BAL_ADJ_TYP |
|
DWL_ACCT_BAL_TYP |
|
DWL_ACCT_CYCL |
|
DWL_ACCT_EVT_TYP |
|
DWL_ACCT_ITEM_CTGRY |
|
DWL_ACCT_PROD_SBRP_ASGN_RSN |
|
DWL_ACCT_PYMT_MTHD_STAT_RSN |
|
DWL_ACCT_PYMT_MTHD_STAT_TYP |
|
DWL_ACCT_RFND_RSN |
|
DWL_ACCT_RL_TYP |
|
DWL_ACCT_STAT_RSN |
|
DWL_ACCT_STAT_TYP |
|
DWL_ACCT_TYP |
|
DWL_ACTVTY_CTGRY |
|
DWL_ACTVTY_RSLT_TYP |
|
DWL_ACTVTY_TYP |
|
DWL_ADDR_RLTD_RSN |
|
DWL_ADDR_RLTD_TYP |
|
DWL_ADDR_STAT |
|
DWL_ADDR_STAT_RSN |
|
DWL_ADDR_TYP |
|
DWL_ADDR_VRFY_TYP |
|
DWL_ADJ_TYP |
|
DWL_AGE_BND |
|
DWL_AGE_GRP |
|
DWL_AGE_ON_NET_BND |
|
DWL_AGRMNT_ASGN_RSN |
|
DWL_AGRMNT_ASGN_TYP |
|
DWL_AGRMNT_CHNG_INTTR_TYP |
|
DWL_AGRMNT_CHNG_RSN |
|
DWL_AGRMNT_CHNG_TYP |
|
DWL_AGRMNT_STAT_RSN |
|
DWL_AGRMNT_STAT_TYP |
|
DWL_AGRMNT_TERM_TYP |
|
DWL_AGRMNT_TYP |
|
DWL_APNMNT_TYP |
|
DWL_ARPU_BND |
|
DWL_ASSET_TYP |
|
DWL_ATHRZTN_MTHD |
|
DWL_AWRD_LVL |
|
DWL_BARNG_RSN |
|
DWL_BER_FER_TYP |
|
DWL_BLLG_FRQNCY |
|
DWL_BLLG_OCCRNCE_TYP |
|
DWL_BLLG_PRD |
|
DWL_BLLG_STAT_CTGRY |
|
DWL_BLLG_STAT_RSN |
|
DWL_BLLG_STAT_TYP |
|
DWL_BROWSER_TYP |
|
DWL_BSNS_INTRACN_ASGN_TYP |
|
DWL_BSNS_INTRACN_CHAR_TYP |
|
DWL_BSNS_INTRACN_STAT_RSN |
|
DWL_BSNS_LEGAL_STAT |
|
DWL_CALL_CNTR_AGNT_TYP |
|
DWL_CALL_CNTR_CASE_SUB_TYP |
|
DWL_CALL_CNTR_CASE_TTL |
|
DWL_CALL_CNTR_CASE_TYP |
|
DWL_CALL_CTGRY |
|
DWL_CALL_DRCTN |
|
DWL_CALL_OTHR_TYP |
|
DWL_CALL_RCYLD_RSN |
|
DWL_CALL_RUTNG_TYP |
|
DWL_CALL_SRCHRG |
|
DWL_CALL_SRVC_TYP |
|
DWL_CALL_SUCC_FAIL_TYP |
|
DWL_CALL_TMNT_RSN |
|
DWL_CALL_TYP |
|
DWL_CARD_HLDR_VRFY_TYP |
|
DWL_CARD_TYP |
|
DWL_CELL_OUTAGE_RSN |
|
DWL_CELL_SITE_TYP |
|
DWL_CELL_TYP |
|
DWL_CHNG_PPSD_BY_TYP |
|
DWL_CHNL_TYP |
|
DWL_CMISN_TYP |
|
DWL_CMPGN_CHNL_TYP |
|
DWL_CMPGN_PRPS_TYP |
|
DWL_CMPGN_STAT |
|
DWL_CMPGN_TYP |
|
DWL_CMPND_RSCE_DTL_TYP |
|
DWL_CMPNSATRY_RSN |
|
DWL_CMPST_PROD_SPEC_CHRG_TYP |
|
DWL_CMPST_PROD_SPEC_TYP |
|
DWL_CNCT_LST_CHNG_RSN |
|
DWL_CNCT_LST_RECRNC_TYP |
|
DWL_CNCT_RLS |
|
DWL_CNTCT_MEDIUM |
|
DWL_CNTNT_PRCNG_TYP |
|
DWL_CNTNT_TYP |
|
DWL_COLLCTN_TYP |
|
DWL_COST_RSN |
|
DWL_COST_SUBTYP |
|
DWL_COST_TYP |
|
DWL_CPN_SCAN |
|
DWL_CPN_TYP |
|
DWL_CRCUT_CTGRY |
|
DWL_CRCUT_RNTL_EVT_TYP |
|
DWL_CRCUT_TYP |
|
DWL_CRNCY |
|
DWL_CRTFCT_TYP |
|
DWL_CUST_CLASS |
|
DWL_CUST_CLSTR_TYP |
|
DWL_CUST_GRP |
|
DWL_CUST_OCCSN_TYP |
|
DWL_CUST_ORDR_PRIORITY_TYP |
|
DWL_CUST_ORDR_STATE_CHNG_RSN |
|
DWL_CUST_RLTN_TYP |
|
DWL_CUST_RVN_BND |
|
DWL_CUST_RVN_TYP |
|
DWL_CUST_STAT_RSN |
|
DWL_CUST_TYP |
|
DWL_DEBT_AGNG_BND |
|
DWL_DOC_CNDTN_TYP |
|
DWL_DOC_TYP |
|
DWL_DOC_TYP_GRP |
|
DWL_DOMAIN_TYP |
|
DWL_DRCT_DEBIT_STAT_RSN |
|
DWL_DSPSTN_TYP |
|
DWL_DSTN_TYP |
|
DWL_DSTNC_BND |
|
DWL_DVRT_RTRV_RSN |
|
DWL_DVRT_RTRV_TYP |
|
DWL_EDU |
|
DWL_EMP_DESIG |
|
DWL_EMP_JB_RL_TYP |
|
DWL_EMP_TYP |
|
DWL_ENRL_CHNL |
|
DWL_ENRL_TYP |
|
DWL_ENTRY_MTHD |
|
DWL_ENV_TYP |
|
DWL_EQPMNT_INSTNC_STAT_TYP |
|
DWL_EVT_ASGN_RSN |
|
DWL_EVT_ASGN_TYP |
|
DWL_EVT_CLASS |
|
DWL_EVT_CTGRY |
|
DWL_EVT_PRTY_RL |
|
DWL_EVT_RESPN_RSN |
|
DWL_EVT_RSLT |
|
DWL_EVT_RSLTN |
|
DWL_EVT_RSN |
|
DWL_EVT_RSN_CTGRY |
|
DWL_EVT_STAT_RSN |
|
DWL_EVT_STAT_TYP |
|
DWL_EVT_TYP |
|
DWL_EXP_BASIS_TYP |
|
DWL_EXP_RPT_STATE_TYP |
|
DWL_EXP_TYP |
|
DWL_EXTRNL_ORG_TYP |
|
DWL_FLD_ACTVTY_RSLT_TYP |
|
DWL_FLD_ACTVTY_TYP |
|
DWL_FLT_RSLTN_TYP |
|
DWL_FLT_TYP |
|
DWL_FRAUD_PRFL_CLASS |
|
DWL_FUEL_SL_STAT |
|
DWL_FXBLE_CHAR_ASGN_TYP |
|
DWL_FXBLE_CHAR_TYP |
|
DWL_GIVE_AWAY_TYP |
|
DWL_GL_ACCT_TYP |
|
DWL_GL_JE_CTGRY |
|
DWL_GL_SGMNT_TYP |
|
DWL_GNDR |
|
DWL_IMPRESSION_EVT_TYP |
|
DWL_INTRACN_DRCTN |
|
DWL_INTRACN_NAVGTN_ITEM_TYP |
|
DWL_INTRACN_NAVGTN_LVL |
|
DWL_INTRACN_NAVGTN_TYP |
|
DWL_INTRACN_PRIORITY_TYP |
|
DWL_INTRACN_RSLT_TYP |
|
DWL_INTRACN_RSN |
|
DWL_INTRACN_STAT |
|
DWL_INTRACN_STAT_TYP |
|
DWL_INTRACN_TRNSFR_RSN |
|
DWL_INTRACN_TYP |
|
DWL_INTTV_RSLT_TYP |
|
DWL_INTTV_TYP |
|
DWL_INVC_ADJ_RSN |
|
DWL_INVC_ADJ_TYP |
|
DWL_INVC_DISC_RSN |
|
DWL_INVC_DISC_TYP |
|
DWL_INVC_DLVRY_FRMT |
|
DWL_INVC_DLVRY_TYP |
|
DWL_INVC_ITEM_DTL_TYP |
|
DWL_INVC_ITEM_TYP |
|
DWL_INVC_PYMT_TERM_TYP |
|
DWL_INVC_STAT |
|
DWL_INVC_TYP |
|
DWL_INVLMNT_RL |
|
DWL_ISP_BSNS_TYP |
|
DWL_ISP_TYP |
|
DWL_ITEM_LKUP_MTHD |
|
DWL_ITEM_TYP |
|
DWL_LANG |
|
DWL_LEGAL_PRCS_STAT_TYP |
|
DWL_LFCCL_TYP |
|
DWL_LND_USE_TYP |
|
DWL_LOOKUP |
|
DWL_LR_STAT |
|
DWL_LTTR_TYP |
|
DWL_MDL_TYP |
|
DWL_MDTN_STAT_CTGRY |
|
DWL_MDTN_STAT_RSN |
|
DWL_MDTN_STAT_TYP |
|
DWL_MEDIA_INTRFC_TYP |
|
DWL_MEDIA_OBJ_TYP |
|
DWL_MNG_ACTN_TYP |
|
DWL_MRKR_TYP |
|
DWL_MRTL_STAT |
|
DWL_NBR_NTWK_TYP |
|
DWL_NP_RQST_LN_ITEM_STATE_TYP |
|
DWL_NP_RQST_STATE_RSN |
|
DWL_NP_RQST_STATE_TYP |
|
DWL_NP_RQST_TYP |
|
DWL_NP_STEP |
|
DWL_NTFCTN_TYP |
|
DWL_NTNLTY |
|
DWL_NTWK_ADDR_TYP |
|
DWL_NTWK_ASGN_TYP |
|
DWL_NTWK_TCHPNT_CLASS |
|
DWL_NTWK_TCHPNT_STAT |
|
DWL_NTWK_TCHPNT_TYP |
|
DWL_NTWK_TYP |
|
DWL_ONOFF_NET |
|
DWL_OPRTR_GRP |
|
DWL_OPRTR_TYP |
|
DWL_ORDR_LN_ITEM_STATE |
|
DWL_ORDR_LN_ITEM_STATE_TYP |
|
DWL_ORDR_STATE |
|
DWL_ORDR_STATE_TYP |
|
DWL_ORDR_TYP |
|
DWL_ORG_BSNS_UNIT_TYP |
|
DWL_ORG_TYP |
|
DWL_PAY_CTGRY |
|
DWL_PAY_TYP |
|
DWL_PBLCTN_TYP |
|
DWL_PCHSE_ORDR_STATE_TYP |
|
DWL_PCU_OUTAGE_RSN |
|
DWL_PIT_CHAR_TYP |
|
DWL_PK_OFPK_TIME |
|
DWL_POS_IDNT_TYP |
|
DWL_POS_TYP |
|
DWL_POSTL_SRVC_TYP |
|
DWL_PPA_CTGRY |
|
DWL_PPA_DEDCTN_TYP |
|
DWL_PRBLM_ESCALATN_LVL |
|
DWL_PRCS_PRMTR_OPRTR |
|
DWL_PRCS_RLTN_TYP |
|
DWL_PRCS_STAT |
|
DWL_PRCS_TYP |
|
DWL_PREF_TYP |
|
DWL_PRFMNC_IND_GRP_SPEC |
|
DWL_PRICE_RSN |
|
DWL_PRICE_TYP |
|
DWL_PRICE_TYPE_RLTN_RSN |
|
DWL_PRMTN_RSLT_TYP |
|
DWL_PRMTN_TERM_TYP |
|
DWL_PRMTN_TYP |
|
DWL_PROD_BRND |
|
DWL_PROD_CAPBLTY_TYP |
|
DWL_PROD_CHAR_TYP |
|
DWL_PROD_CTLG_PRSNT_TYP |
|
DWL_PROD_CTLG_TYP |
|
DWL_PROD_LN |
|
DWL_PROD_OFR_ASGN_TYP |
|
DWL_PROD_OFR_GRP_TYP |
|
DWL_PROD_OFR_PRICE_RLTN_TYP |
|
DWL_PROD_OFR_PRICE_TYP |
|
DWL_PROD_OFR_RLTN_TYP |
|
DWL_PROD_OFR_TYP |
|
DWL_PROD_RLTN_TYP |
|
DWL_PROD_SBRP_ASGN_TYP |
|
DWL_PROD_SBRP_EVT_TYP |
|
DWL_PROD_SBRP_STAT |
|
DWL_PROD_SBRP_STAT_CTGRY |
|
DWL_PROD_SBRP_STAT_RSN |
|
DWL_PROD_SBRP_STAT_TYP |
|
DWL_PROD_SBRP_TERM_TYP |
|
DWL_PROD_SBRP_TYP |
|
DWL_PROD_SPEC_ASGN_RSN |
|
DWL_PROD_SPEC_COVRG_AREA_TYP |
|
DWL_PROD_SPEC_CTGRY |
|
DWL_PROD_SPEC_GRP |
|
DWL_PROD_SPEC_GRP_TYP |
|
DWL_PROD_SPEC_MGMT_RL |
|
DWL_PROD_SPEC_MGMT_RSN |
|
DWL_PROD_SPEC_STAT_TYP |
|
DWL_PROD_SPEC_TYP |
|
DWL_PROD_STAT_TYP |
|
DWL_PRPD_MBL_EVT_TYP |
|
DWL_PRSNL_ID_REQD_TYP |
|
DWL_PRSPCT_PRIORITY_TYP |
|
DWL_PRSPCT_QLTY_SCR_TYP |
|
DWL_PRSPCT_REJECT_RSN |
|
DWL_PRTNR_PYMT_TYP |
|
DWL_PRTNR_STLMNT_RSN |
|
DWL_PRTY_ACCT_ASGN_TYP |
|
DWL_PRTY_AGRMNT_ASGN_RL |
|
DWL_PRTY_AGRMNT_ASGN_TYP |
|
DWL_PRTY_ASGN_RSN |
|
DWL_PRTY_ASGN_TYP |
|
DWL_PRTY_CNCT_INFO_TYP |
|
DWL_PRTY_CNCT_LST_PRTCPTN |
|
DWL_PRTY_CNCT_LST_RL |
|
DWL_PRTY_EVT_TYP |
|
DWL_PRTY_IDNT_TYP |
|
DWL_PRTY_LOC_RSN |
|
DWL_PRTY_LOC_TYP |
|
DWL_PRTY_MGMT_RL |
|
DWL_PRTY_PRFL_TYP |
|
DWL_PRTY_ORDR_ASGN_TYP |
|
DWL_PRTY_PROD_SBRP_RL |
|
DWL_PRTY_RL |
|
DWL_PRTY_RL_CTGRY |
|
DWL_PRTY_RL_TYP |
|
DWL_PRTY_SGMNT_MTHD |
|
DWL_PRTY_SIM_CARD_RL |
|
DWL_PRTY_SRVC_ASGN_RL |
|
DWL_PRTY_SRVC_ASGN_RSN |
|
DWL_PRTY_STAT_CHNG_RSN |
|
DWL_PRTY_STAT_CTGRY |
|
DWL_PRTY_STAT_TYP |
|
DWL_PRTY_TYP |
|
DWL_PYMT_AGNG_CLASS |
|
DWL_PYMT_MTHD_TYP |
|
DWL_PYMT_TRX_TYP |
|
DWL_QOS_SRVC_SPEC_TYP |
|
DWL_RATABLE_UNIT_MEASUREMENT |
|
DWL_RDMPTN_TYP |
|
DWL_RECHRG_RVN_SLB |
|
DWL_RELGN |
|
DWL_RELIGIOUS_AFFLTN |
|
DWL_RFMP_MTHD |
|
DWL_RLTN_TYP |
|
DWL_RMNG_TYP |
|
DWL_ROOT_ENT_TYP |
|
DWL_RSCE_RLTN_TYP |
|
DWL_RSCE_SPEC_CTGRY |
|
DWL_RSCE_SPEC_TYP |
|
DWL_RSCE_STATE_RSN |
|
DWL_RSCE_STATE_TYP |
|
DWL_RSCE_USG_EVT_TYP |
|
DWL_RSN |
|
DWL_RSN_CTGRY |
|
DWL_RTL_TRML_STAT |
|
DWL_RTL_TRX_LI_TYP |
|
DWL_RTL_TYP |
|
DWL_RTNG_MTHD_TYP |
|
DWL_SBSCRP_ACTVTN_RSN |
|
DWL_SCRPT_QUES_TYP |
|
DWL_SCRTY_REQD_TYP |
|
DWL_SEASON |
|
DWL_SERVER_STAT |
|
DWL_SESSION_TYP |
|
DWL_SGMNT_TYP |
|
DWL_SIC_ASGN_RSN |
|
DWL_SIC_CLSFCTN |
|
DWL_SIC_INDSTRY_GRP |
|
DWL_SIM_CARD_ACCS_MTHD_RSN |
|
DWL_SIM_CARD_ACTVTN_RSN |
|
DWL_SIM_CARD_ACTVTN_TYP |
|
DWL_SIM_CARD_PROD_SBRP_RSN |
|
DWL_SIM_CARD_TYP |
|
DWL_SITE_TYP |
|
DWL_SKILL_TYP |
|
DWL_SKU_TYP |
|
DWL_SL_OR_RETRN_ACTN |
|
DWL_SLNG_LOC_TYP |
|
DWL_SPNM |
|
DWL_SRC_SYS_TYP |
|
DWL_SRVC_CLASS |
|
DWL_SRVC_CLASS_TYP |
|
DWL_SRVC_COVRG_AREA_TYP |
|
DWL_SRVC_CTGRY |
|
DWL_SRVC_LVL_AGRMNT_TYP |
|
DWL_SRVC_LVL_SPEC |
|
DWL_SRVC_LVL_UNMET_CNSEQ_TYP |
|
DWL_SRVC_PRBLM_CHAR_TYP |
|
DWL_SRVC_SPEC_TYP |
|
DWL_SRVC_STAT |
|
DWL_SRVC_STAT_CTGRY |
|
DWL_SRVC_STAT_RSN |
|
DWL_SRVC_TYP |
|
DWL_SRVC_USG_TYP |
|
DWL_SUBSDY_TYP |
|
DWL_SWOT_TYP |
|
DWL_SWTCH_CAPBLTY_TYP |
|
DWL_SWTCH_TYP |
|
DWL_TAX_CTGRY |
|
DWL_TCH_TYP |
|
DWL_TECH |
|
DWL_TECH_TYP |
|
DWL_TIER_CARD_TYP |
|
DWL_TIME_ZN |
|
DWL_TNDR_CLASS |
|
DWL_TRGT_TYP |
|
DWL_TRNK_GRP |
|
DWL_TRNSFR_TYP |
|
DWL_TRX_CTGRY |
|
DWL_TRX_TYP |
|
DWL_UDR_EVT_CHAR_TYP |
|
DWL_UDR_EVT_SPEC_TYP |
|
DWL_UDR_EVT_STAT |
|
DWL_UDR_EVT_TYP |
|
DWL_UMS_ACCS_TYP |
|
DWL_UMS_EVT_TYP |
|
DWL_UOM |
|
DWL_USG_TYP |
|
DWL_VAL_TYP |
|
DWL_VISITOR_TYP |
|
DWL_VNDR_CLASS |
|
DWL_VNDR_RTNG_TYP |
|
DWL_VNDR_SITE_TYP |
|
DWL_VOL_BND |
|
DWL_WEB_PG_RNDRNG_TYP |
|
DWL_WEB_PG_TYP |
Table 4-5 briefly describes the Base tables in Oracle Communications Data Model.
Table Name | More Information |
---|---|
DWB_ACCRUAL_EVT |
|
DWB_ACCS_MTHD_PORT_HIST |
|
DWB_ACCS_MTHD_STAT_HIST |
|
DWB_ACCT_ACCTNG_CYCL_HIST |
|
DWB_ACCT_BAL |
|
DWB_ACCT_BAL_IMPC |
|
DWB_ACCT_BLLG_OCCRNCE |
|
DWB_ACCT_COST |
|
DWB_ACCT_CRDT_LMT |
|
DWB_ACCT_DEBT |
|
DWB_ACCT_DEBT_HIST |
|
DWB_ACCT_MNGMNT_HIST |
|
DWB_ACCT_PROD_OFR_PRTCPTN_HIST |
|
DWB_ACCT_PYMT |
|
DWB_ACCT_PYMT_MTHD_STAT |
|
DWB_ACCT_PYMT_PYMT_PLN_ASGN |
|
DWB_ACCT_STAT_HIST |
|
DWB_ADDR_STAT_HIST |
|
DWB_ADHOC_COLLCTN |
|
DWB_AGRMNT_APRVL |
|
DWB_AGRMNT_APRVL_ASGN |
|
DWB_AGRMNT_STAT |
|
DWB_AGRMNT_TERM |
|
DWB_APNMNT |
|
DWB_APNMNT_CLNDR |
|
DWB_ASSET_APPRSL_HIST |
|
DWB_ASSET_CNDTN_HIST |
|
DWB_ASSET_DEPRCN_HIST |
|
DWB_BLK_LST_HIST |
|
DWB_BRDBND_USG_EVT |
|
DWB_BSNS_INTRACN |
|
DWB_BSNS_INTRACN_HIST |
|
DWB_BSNS_INTRACN_ITEM |
|
DWB_BSNS_INTRACN_ITEM_PRICE |
|
DWB_BSNS_INTRACN_PYMT_ASGN |
|
DWB_BSNS_INTRACN_RL |
|
DWB_BSNS_INTRACN_VRSN |
|
DWB_CELL_SITE_COST |
|
DWB_CHNL_COST |
|
DWB_CMPGN_COST |
|
DWB_CMPGN_MSG_CRTVE |
|
DWB_CNCT_LST_COST |
|
DWB_CNSEQ_PRFMNC_NTFCTN |
|
DWB_CNTNT_DLVRY_EVT |
|
DWB_COST |
|
DWB_COST_CNTR_BDGT |
|
DWB_COURIER_COST |
|
DWB_CRCUT_RNTL |
|
DWB_CRCUT_TRFC |
|
DWB_CRNCY_EXCHNG_RATE |
|
DWB_CUST_COST |
|
DWB_CUST_FLD_SRVC_ACTVTY |
|
DWB_CUST_FLD_SRVC_DTL |
|
DWB_CUST_ORDR |
|
DWB_CUST_ORDR_LN_ITEM |
|
DWB_CUST_ORDR_LN_ITEM_ST_ASGN |
|
DWB_CUST_ORDR_PYMT |
|
DWB_CUST_ORDR_STATE_ASGN |
|
DWB_DATA_SRVC_EVT |
|
DWB_DISC_LI |
|
DWB_EMP_ACT_LBR_HRLY |
|
DWB_EMP_ACT_LBR_SALARIED |
|
DWB_EMP_COST |
|
DWB_EMP_EXP_RPT |
|
DWB_EMP_EXP_RPT_ITEM |
|
DWB_EMP_EXP_RPT_STATE |
|
DWB_EMP_TRNG_REC |
|
DWB_EQPMNT_CNTR_COST |
|
DWB_ERRD_MDTD_CALL_EVT |
|
DWB_ERRD_RAW_WRLS_CALL_EVT |
|
DWB_ERRD_RTD_WRLS_CALL_EVT |
|
DWB_EVT |
|
DWB_EVT_ACCS_MTHD_ACTVTY |
|
DWB_EVT_ACCT |
|
DWB_EVT_AGRMNT |
|
DWB_EVT_ASGN |
|
DWB_EVT_CMPST_PROD_SPEC |
|
DWB_EVT_COST |
|
DWB_EVT_CRCUT_RNTL |
|
DWB_EVT_EMP_ACTVTY |
|
DWB_EVT_EMIT_DTL |
|
DWB_EVT_EMP_PYRL |
|
DWB_EVT_EQPMNT_INSTNC |
|
DWB_EVT_FINCL |
|
DWB_EVT_GEO |
|
DWB_EVT_LYLTY_PROG |
|
DWB_EVT_PROD_SBRP_WRLS |
|
DWB_EVT_PRPD_MBL |
|
DWB_EVT_PRTY_ASGN |
|
DWB_EVT_PRTY_INTRACN |
|
DWB_EVT_PRTY_INTRACN_CHAT_DTL |
|
DWB_EVT_PRTY_INTRACN_ITEM |
|
DWB_EVT_PRTY_INTRACN_PRTCPTN |
|
DWB_EVT_PRTY_PRFL |
|
DWB_EVT_SBRP_CHNG |
|
DWB_EVT_SIM_CARD |
|
DWB_EVT_STAT |
|
DWB_EVT_TRGR_DTL |
|
DWB_EXP_RPT_PRTY_ASGN |
|
DWB_FIXED_LN_CALL_EVT |
|
DWB_GL_BAL |
|
DWB_GL_JE |
|
DWB_GL_JE_BTCH |
|
DWB_GL_JE_LN |
|
DWB_GL_JE_LN_SBLDGR_ASGN |
|
DWB_GL_SBLDGR_JE |
|
DWB_GL_SBLDGR_JE_LN |
|
DWB_GPRS_USG_EVT |
|
DWB_IDD_CALL_EVT |
|
DWB_IMPRESSION |
|
DWB_INTRACN_ANSWR_CHOICE |
|
DWB_INTRACN_NAVGTN_HIST |
|
DWB_INTRACN_QUES_RESPN |
|
DWB_INTRACN_TRNSFR_HIST |
|
DWB_INTRNT_ACCS_EVT |
|
DWB_INV_ITEM_STATE |
|
DWB_INVC |
|
DWB_INVC_ADJ |
|
DWB_INVC_DISC |
|
DWB_INVC_GENRTN_PRCS |
|
DWB_INVC_ITEM |
|
DWB_INVC_ITEM_DTL |
|
DWB_INVC_ITEM_RLTN |
|
DWB_INVC_PYMT_ASGN |
|
DWB_INVC_PYMT_TERM |
|
DWB_INVC_STAT_HIST |
|
DWB_INVC_TAX_ITEM |
|
DWB_INV_ADJ_DOC_LI |
|
DWB_INV_CNTRL_DOC |
|
DWB_INV_CNTRL_DOC_LI |
|
DWB_ISP_USG_EVT |
|
DWB_IVR_INTRACN_NAVGTN_HIST |
|
DWB_JE_LN_CUST_ORDR_ITEM_ASGN |
|
DWB_JE_LN_INVC_ITEM_ASGN |
|
DWB_LYLTY_MBRSHIP_ENRL |
|
DWB_LYLTY_TIER_CHNG_HIST |
|
DWB_MBRSHIP_ACCT_BAL_HIST |
|
DWB_MDTD_CALL_EVT |
|
DWB_MEDIA_OBJ_COST |
|
DWB_MMS_EVT |
|
DWB_NP_RQST_HDR |
|
DWB_NP_RQST_LN_ITEM |
|
DWB_NP_RQST_LN_ITEM_STATE_HIST |
|
DWB_NP_RQST_STATE_HIST |
|
DWB_ORG_BSNS_UNIT_COST |
|
DWB_PCHSE_ORDR |
|
DWB_PCHSE_ORDR_LN_ITEM |
|
DWB_PCHSE_ORDR_LN_ITEM_STATE |
|
DWB_PCHSE_ORDR_STATE |
|
DWB_PHY_CNT_DOC |
|
DWB_PHY_CNT_DOC_LI |
|
DWB_PLCY_EVT |
|
DWB_PLCY_EVT_ATMC |
|
DWB_PLCY_EVT_CMPST |
|
DWB_PRBLM |
|
DWB_PRBLM_CMNTS |
|
DWB_PRBLM_LOC_ASGN |
|
DWB_PRBLM_RLTN |
|
DWB_PRBLM_RSCE_ASGN |
|
DWB_PRBLM_SRVC_ASGN |
|
DWB_PRBLM_STAT_HIST |
|
DWB_PRBLM_TRKNG_REC_ASGN |
|
DWB_PRCS_COST |
|
DWB_PRCS_EVT |
|
DWB_PRCS_INVC_DSPTCHG_EVT |
|
DWB_PRCS_INVC_GNRTN_EVT |
|
DWB_PRCS_INVC_ISSNG_EVT |
|
DWB_PRCSEVT_PRMTRVAL_OPRTR_ASG |
|
DWB_PRFMNC |
|
DWB_PRFMNC_CNSEQ |
|
DWB_PRFMNC_IND |
|
DWB_PRFMNC_IND_GRP |
|
DWB_PRFMNC_MBL_ADDR |
|
DWB_PRFMNC_NTFCTN |
|
DWB_PRICE_EVT |
|
DWB_PRMTN_CLSTR_USG |
|
DWB_PRMTN_CNCT_LST_UTLZTN |
|
DWB_PRMTN_COST |
|
DWB_PRMTN_MGMT_HIST |
|
DWB_PRMTN_TERM_VAL |
|
DWB_PROD_OFR_COST |
|
DWB_PROD_OFR_MGMT |
|
DWB_PROD_SBRP_STAT_HIST |
|
DWB_PROD_SPEC_COST |
|
DWB_PROD_SPEC_MGMT_HIST |
|
DWB_PROD_SPEC_STAT_HIST |
|
DWB_PROD_STAT_HIST |
|
DWB_PRPD_RCHRG |
|
DWB_PRTNR_PYMT |
|
DWB_PRTY_AM_PROD_OFR_ASGN_HIST |
|
DWB_PRTY_AM_PROD_OFR_ASGN_STAT |
|
DWB_PRTY_COST_ASGN |
|
DWB_PRTY_ORDR_ASGN |
|
DWB_PRTY_PRMTN_RESPN |
|
DWB_PRTY_STAT_HIST |
|
DWB_PTV_FULL_CHNL_ACTVTN |
|
DWB_PTV_QPI_SRVC_EVT |
|
DWB_PTV_USG_EVT |
|
DWB_RAW_MMS_EVT |
|
DWB_RAW_WRLS_CALL_EVT |
|
DWB_REDEM_EVT |
|
DWB_RSCE_ALRM |
|
DWB_RSCE_ALRM_CMNT |
|
DWB_RSCE_ALRM_RLTN |
|
DWB_RSCE_ALRM_RSCE_ASGN |
|
DWB_RSCE_ALRM_TRKNG_REC_ASGN |
|
DWB_RSCE_BSNS_INTRACN_RL |
|
DWB_RSCE_COST |
|
DWB_RSCE_FLT_ASGN |
|
DWB_RSCE_HIST |
|
DWB_RSCE_ORDR |
|
DWB_RSCE_ORDR_LN_ITEM |
|
DWB_RSCE_PRFMNC |
|
DWB_RSCE_STATE_HIST |
|
DWB_RTD_UDR_EVT |
|
DWB_RTL_SL_RTRN_LI |
|
DWB_RTL_TNDR_LI |
|
DWB_RTL_TRX |
|
DWB_RTL_TRX_LN_ITEM |
|
DWB_SBRP_TERM_VAL |
|
DWB_SESSION |
|
DWB_SL_CHNL_CMISN_PLN_ASGN |
|
DWB_SL_CMISN_DTL |
|
DWB_SL_CMISN_PYRL |
|
DWB_SMS_EVT |
|
DWB_SRVC_LVL_AGRMNT_VILTN |
|
DWB_SRVC_ORDR |
|
DWB_SRVC_ORDR_LN_ITEM |
|
DWB_SRVC_PRFMNC |
|
DWB_SRVC_PRBLM |
|
DWB_SRVC_PRBLM_RSCE_ALRM_ASGN |
|
DWB_SRVC_PRBLM_SBRP_ASGN |
|
DWB_SRVC_PRBLM_SRVC_ASGN |
|
DWB_SRVC_RQST |
|
DWB_SRVC_STAT_HIST |
|
DWB_TAP_IN_WRLS_RMNG_EVT |
|
DWB_TAP_OUT_WRLS_RMNG_EVT |
|
DWB_TNDR_CNTRL_TRX |
|
DWB_TRBLE_TCKT |
|
DWB_TRBLE_TCKT_FLD_SPPRT_ASGN |
|
DWB_TRBLE_TCKT_ITEM |
|
DWB_TRKNG_REC |
|
DWB_UDR_EVT |
|
DWB_UDR_EVT_ASGN |
|
DWB_UMS_EVT |
|
DWB_UNIT_ALWNCE |
|
DWB_VNDR_APNMNT |
|
DWB_VOIP_CALL_EVT |
|
DWB_WEB_INTRACN_NAVGTN_HIST |
|
DWB_WRLS_CALL_EVT |
|
DWB_WRLS_CNTNT_DNLDG_EVT |
|
DWB_WRLS_RMNG_EVT |
|
DWB_WRLS_RMNG_EVT_BTCH |
Table 4-6 Oracle Communications Data Model Derived Tables
Table Name | More Information |
---|---|
DWD_ACCT_BAL_MO |
|
DWD_ACCT_DEBT_MO |
Not used |
DWD_ACCT_FRST_ACTVTY |
|
DWD_ACCT_LAST_ACTVTY |
|
DWD_ACCT_PYMT_DAY |
|
DWD_ACCT_PYMT_MTHD_STAT_HIST |
|
DWD_AGRMNT |
|
DWD_AGRMNT_CHNG |
|
DWD_AGRMNT_RVN_DAY |
|
DWD_BER_FER_ERR_RATIO_DAY |
|
DWD_CANBLZTN_DTL_DAY |
|
DWD_CELL_STTSTC_DAY |
|
DWD_CMISN |
|
DWD_CMPGN_HIST_DAY |
|
DWD_CNT_DAY |
|
DWD_CNTCT_CNTR_DAY |
|
DWD_COST_CNTR |
|
DWD_CUST_COST |
|
DWD_CUST_DNA |
|
DWD_CUST_EQPMNT_INSTLTN_DAY |
|
DWD_CUST_ORDR_DAY |
|
DWD_CUST_ORDR_LN_ITEM_DAY |
|
DWD_CUST_RFMP_SCR |
|
DWD_CUST_SKU_SL_RETRN_DAY |
|
DWD_DATA_USG_DAY |
|
DWD_GIVE_AWAY_ITEM_DAY |
|
DWD_INVC_AGNG_DAY |
|
DWD_INVC_DAY |
|
DWD_INV_ADJ_ITEM_DAY |
Not used |
DWD_INV_POSN_ITEM_DAY |
|
DWD_INV_RCPT_ITEM_DAY |
|
DWD_INV_UNAVL_ITEM_DAY |
|
DWD_INV_VNDR_CMPLNC_DAY |
|
DWD_INV_XFER_ITEM_DAY |
|
DWD_IN_PLTFRM_DAY |
|
DWD_LYLTY_MBR_PNT_DAY |
|
DWD_MKT_SHARE |
|
DWD_MSC_TRFC_DAY |
|
DWD_NBR_PRT_DAY |
|
DWD_NTWK_AVLBLTY_DAY |
|
DWD_NTWK_TCHPNT |
|
DWD_ORG_BSNS_UNT_HRS_DAY |
|
DWD_POS_TNDR_FLOW |
|
DWD_PRCS_INVC_DAY |
|
DWD_PRPD_ACCT_STTSTC_DAY |
|
DWD_PRPD_ALWNCE_DAY |
Not used |
DWD_PRTNR_STLMNT |
|
DWD_RTL_SL_RETRN_ITEM_DAY |
|
DWD_RF_NTWK_CPCTY_DAY |
|
DWD_RVN_DAY |
|
DWD_SL_RPRSTV_STTSTC |
|
DWD_SPLMNTR_SRVC_USG |
|
DWD_SRVC_PRBLM_DAY |
|
DWD_STORE_EFFNCY_DAY |
|
DWD_TMF_KPI |
|
DWD_VAS_SBRP_QCK_SUMM |
|
DWD_VAS_USG_DAY |
|
DWD_VOI_CALL_DAY |
Table 4-7 briefly describes the Aggregate tables in Oracle Communications Data Model.
Table Name | More Information |
---|---|
DWA_ACCT_DEBT_MO |
|
DWA_ACCT_PYMT_MO |
|
DWA_ACCT_STTSTC_MO |
|
DWA_AGRMNT_ACCT_SBRP_PROD |
|
DWA_ARPU_BASE_CUST_TYP |
|
DWA_BER_FER_ERR_RATIO_MO |
|
DWA_CALL_CNTR_CALL_MO |
|
DWA_CALL_CNTR_CASE_MO |
|
DWA_CELL_STTSTC_MO |
|
DWA_CMISN_MO |
|
DWA_CNT_MO |
|
DWA_COST_CNTR_MO |
|
DWA_CUST_ACQSTN_SUMM_MO |
|
DWA_CUST_CHRN_MO |
|
DWA_CUST_COST_MO |
|
DWA_CUST_DEBT_COLLCTN_MO |
|
DWA_CUST_EQPMNT_INSTLTN_MO |
|
DWA_CUST_GROSS_ORDRS_QTR |
|
DWA_CUST_ORDR_MO |
|
DWA_DATA_USG_MO |
|
DWA_IN_PLTFRM_MO |
|
DWA_INV_POSN_DEPT_DAY |
|
DWA_INV_POSN_SBC_MO |
|
DWA_INVC_MO |
|
DWA_INVC_ADJ_MO |
|
DWA_LYLTY_PROG_MO |
|
DWA_MKT_SHARE |
|
DWA_MSC_TRFC_MO |
|
DWA_NBR_PRT_MO |
|
DWA_NTWK_AVLBLTY_MO |
|
DWA_NTWK_TCHPNT_MO |
|
DWA_PRPD_ALWNCE_MO |
|
DWA_PRTNR_STLMNT_MO |
|
DWA_RDMPTN_MO |
|
DWA_RF_NTWK_CPCTY_MO |
|
DWA_RVN_MO |
|
DWA_SBSCBR_STTSTC_MO |
|
DWA_SL_CMPGN_SUMM_MO |
|
DWA_SPLMNTR_SRVC_USG_MO |
Not used |
DWA_STORE_EFFNCY_MO |
|
DWA_VAS_SBRP_QCK_SUMM_MO |
|
DWA_VAS_USG_MO |
|
DWA_VOI_CALL_MO |
Table 4-8 and Table 4-9 briefly describes the temporary and control tables in Oracle Communications Data Model.
Table 4-8 Temporary Oracle Communications Data Model Tables
Table Name | Description |
---|---|
|
This entity gives order measures, number of orders and total order amount, in same quarters of consecutive years. |
|
This entity gives order measures, number of orders and total order amount, in consecutive quarters. |
|
This entity summarizes orders placed by customers at month level aggregation. Using this entity, order measures, number of orders and total order amount, across order status, order type, product, product type dimensions can be computed. |
TMP_DWD_CUST_RFMP_SCR_1 |
|
TMP_DWD_CUST_RFMP_SCR_2 |
Table Name | Description |
---|---|
|
Store ETL parameters such as etl start date and etl end date. For more information, see "Intra-ETL Load Parameters Control Table". |
|
Reports errors at the individual program level. For more information, see "Intra-ETL Monitoring Process Control Tables". |
|
Reports errors at the whole batch load level. For more information, see "Intra-ETL Monitoring Process Control Tables". |
|
|
|
Reports OLAP ETL parameter. For more information, see "Intra-ETL OLAP Mapping Control Table". |
Table 4-10 lists the sequence names in Oracle Communications Data Model.
Table 4-10 Sequence Name for Oracle Communications Data Model
Table Name | Sequence Name |
---|---|
DWC_INTRA_ETL_ACTIVITY |
INTRA_ETL_ACTIVITY_SEQ |
DWC_INTRA_ETL_PROCESS |
INTRA_ETL_PROCESS_SEQ |
DWD_TMF_KPI |
DWD_TMF_KPI_SEQ |
DWR_DAY_TODATE_TRANS |
DAY_TODATE_TRANS_SEQ |
DWR_HLF_MO_TODATE_TRANS |
HLF_MO_TODATE_TRANS_SEQ |
DWR_MO_TODATE_TRANS |
MO_TODATE_TRANS_SEQ |
DWR_MO_TRANS |
MO_TRANS_SEQ |
DWR_QTR_TODATE_TRANS |
QTR_TODATE_TRANS_SEQ |
DWR_QTR_TRANS |
QTR_TRANS_SEQ |
DWR_WK_TODATE_TRANS |
WK_TODATE_TRANS_SEQ |
DWR_YR_TRANS |
YR_TRANS_SEQ |
Table 4-11 lists the Compressed Tables in Oracle Communications Data Model. Oracle Communications Data Model uses Database Compression on these tables to save space and load times.
Table Name |
---|
DWA_ACCT_DEBT_MO |
DWA_ACCT_PYMT_MO |
DWA_ACCT_STTSTC_MO |
DWA_ARPU_BASE_CUST_TYP |
DWA_BER_FER_ERR_RATIO_MO |
DWA_CALL_CNTR_CALL_MO |
DWA_CALL_CNTR_CASE_MO |
DWA_CELL_STTSTC_MO |
DWA_CMISN_MO |
DWA_CNT_MO |
DWA_COST_CNTR_MO |
DWA_CUST_ACQSTN_SUMM_MO |
DWA_CUST_CHRN_MO |
DWA_CUST_COST_MO |
DWA_CUST_DEBT_COLLCTN_MO |
DWA_CUST_EQPMNT_INSTLTN_MO |
DWA_CUST_GROSS_ORDRS_QTR |
DWA_CUST_ORDR_MO |
DWA_DATA_USG_MO |
DWA_IN_PLTFRM_MO |
DWA_INV_POSN_DEPT_DAY |
DWA_INV_POSN_SBC_MO |
DWA_INVC_ADJ_MO |
DWA_INVC_MO |
DWA_LYLTY_PROG_MO |
DWA_MKT_SHARE |
DWA_MSC_TRFC_MO |
DWA_NBR_PRT_MO |
DWA_NTWK_AVLBLTY_MO |
DWA_NTWK_TCHPNT_MO |
DWA_PRPD_ALWNCE_MO |
DWA_PRTNR_STLMNT_MO |
DWA_RDMPTN_MO |
DWA_RF_NTWK_CPCTY_MO |
DWA_RVN_MO |
DWA_SBSCBR_STTSTC_MO |
DWA_SL_CMPGN_SUMM_MO |
DWA_SPLMNTR_SRVC_USG_MO |
DWA_STORE_EFFNCY_MO |
DWA_VAS_SBRP_QCK_SUMM_MO |
DWA_VAS_USG_MO |
DWA_VOI_CALL_MO |
DWB_ACCS_MTHD_PORT_HIST |
DWB_ACCS_MTHD_STAT_HIST |
DWB_ACCT_ACCTNG_CYCL_HIST |
DWB_ACCT_BAL_IMPC |
DWB_ACCT_BLLG_OCCRNCE |
DWB_ACCT_COST |
DWB_ACCT_CRDT_LMT |
DWB_ACCT_MNGMNT_HIST |
DWB_ACCT_PROD_OFR_PRTCPTN_HIST |
DWB_ACCT_PYMT |
DWB_ACCT_PYMT_MTHD_STAT |
DWB_ACCT_STAT_HIST |
DWB_ADDR_STAT_HIST |
DWB_AGRMNT_APRVL |
DWB_AGRMNT_STAT |
DWB_AGRMNT_TERM |
DWB_APNMNT_CLNDR |
DWB_BLK_LST_HIST |
DWB_BRDBND_USG_EVT |
DWB_BSNS_INTRACN |
DWB_BSNS_INTRACN_HIST |
DWB_BSNS_INTRACN_ITEM |
DWB_BSNS_INTRACN_ITEM_PRICE |
DWB_BSNS_UNIT_COST |
DWB_CELL_SITE_COST |
DWB_CHNL_COST |
DWB_CMPGN_COST |
DWB_CMPGN_MSG_CRTVE |
DWB_CNCT_LST_COST |
DWB_CNTNT_DLVRY_EVT |
DWB_COST |
DWB_COST_CNTR_BDGT |
DWB_COURIER_COST |
DWB_CRCUT_RNTL |
DWB_CRCUT_TRFC |
DWB_CRNCY_EXCHNG_RATE |
DWB_CUST_COST |
DWB_CUST_FLD_SRVC_ACTVTY |
DWB_CUST_FLD_SRVC_DTL |
DWB_CUST_ORDR |
DWB_CUST_ORDR_LN_ITEM |
DWB_CUST_ORDR_LN_ITEM_ST_ASGN |
DWB_CUST_ORDR_PYMT |
DWB_CUST_ORDR_STATE_ASGN |
DWB_DATA_SRVC_EVT |
DWB_DISC_LI |
DWB_EMP_ACT_LBR_HRLY |
DWB_EMP_ACT_LBR_SALARIED |
DWB_EMP_COST |
DWB_EMP_EXP_RPT |
DWB_EMP_TRNG_REC |
DWB_EQPMNT_CNTR_COST |
DWB_ERRD_MDTD_CALL_EVT |
DWB_ERRD_RAW_WRLS_CALL_EVT |
DWB_ERRD_RTD_WRLS_CALL_EVT |
DWB_EVT |
DWB_EVT_ACCS_MTHD_ACTVTY |
DWB_EVT_ACCT |
DWB_EVT_AGRMNT |
DWB_EVT_ASGN |
DWB_EVT_CMPST_PROD_SPEC |
DWB_EVT_COST |
DWB_EVT_CRCUT_RNTL |
DWB_EVT_EMP_PYRL |
DWB_EVT_EQPMNT_INSTNC |
DWB_EVT_FINCL |
DWB_EVT_GEO |
DWB_EVT_LYLTY_PROG |
DWB_EVT_PROD_SBRP_WRLS |
DWB_EVT_PRPD_MBL |
DWB_EVT_PRTY_ASGN |
DWB_EVT_PRTY_INTRACN |
DWB_EVT_PRTY_PRFL |
DWB_EVT_SBRP_CHNG |
DWB_EVT_SIM_CARD |
DWB_EVT_STAT |
DWB_EXP_RPT_PRTY_ASGN |
DWB_FIXED_LN_CALL_EVT |
DWB_GPRS_USG_EVT |
DWB_IDD_CALL_EVT |
DWB_INTRACN_QUES_RESPN |
DWB_INTRNT_ACCS_EVT |
DWB_INV_ADJ_DOC_LI |
DWB_INV_CNTRL_DOC |
DWB_INV_CNTRL_DOC_LI |
DWB_INV_ITEM_STATE |
DWB_INVC |
DWB_INVC_ADJ |
DWB_INVC_DISC |
DWB_INVC_ITEM |
DWB_INVC_ITEM_DTL |
DWB_INVC_PYMT_ASGN |
DWB_INVC_PYMT_TERM |
DWB_INVC_STAT_HIST |
DWB_ISP_USG_EVT |
DWB_MDTD_CALL_EVT |
DWB_MEDIA_OBJ_COST |
DWB_MMS_EVT |
DWB_NP_RQST_HDR |
DWB_NP_RQST_LN_ITEM |
DWB_NP_RQST_LN_ITEM_STATE_HIST |
DWB_NP_RQST_STATE_HIST |
DWB_PHY_CNT_DOC |
DWB_PHY_CNT_DOC_LI |
DWB_PLCY_EVT_ATMC |
DWB_PLCY_EVT_CMPST |
DWB_PRBLM_CMNTS |
DWB_PRBLM_LOC_ASGN |
DWB_PRBLM_RLTN |
DWB_PRBLM_RSCE_ASGN |
DWB_PRBLM_SRVC_ASGN |
DWB_PRCS_COST |
DWB_PRICE_EVT |
DWB_PRMTN_CLSTR_USG |
DWB_PRMTN_CNCT_LST_UTLZTN |
DWB_PRMTN_COST |
DWB_PRMTN_MGMT_HIST |
DWB_PRMTN_TERM_VAL |
DWB_PROD_OFR_COST |
DWB_PROD_OFR_MGMT |
DWB_PROD_SBRP_STAT_HIST |
DWB_PROD_SPEC_COST |
DWB_PROD_SPEC_MGMT_HIST |
DWB_PROD_SPEC_STAT_HIST |
DWB_PRPD_RCHRG |
DWB_PRTNR_PYMT |
DWB_PRTY_AM_PROD_OFR_ASGN_HIST |
DWB_PRTY_AM_PROD_OFR_ASGN_STAT |
DWB_PRTY_COST_ASGN |
DWB_PRTY_ORDR_ASGN |
DWB_PRTY_PRMTN_RESPN |
DWB_PRTY_STAT_HIST |
DWB_PTV_FULL_CHNL_ACTVTN |
DWB_PTV_QPI_SRVC_EVT |
DWB_PTV_USG_EVT |
DWB_RAW_MMS_EVT |
DWB_RAW_WRLS_CALL_EVT |
DWB_RSCE_COST |
DWB_RSCE_HIST |
DWB_RSCE_ORDR |
DWB_RSCE_ORDR_LN_ITEM |
DWB_RSCE_PRFMNC |
DWB_RSCE_STATE_HIST |
DWB_RTD_UDR_EVT |
DWB_RTL_SL_RTRN_LI |
DWB_RTL_TNDR_LI |
DWB_RTL_TRX |
DWB_SBRP_TERM_VAL |
DWB_SL_CMISN_DTL |
DWB_SL_CMISN_PYRL |
DWB_SMS_EVT |
DWB_SRVC_LVL_AGRMNT_VILTN |
DWB_SRVC_ORDR |
DWB_SRVC_ORDR_LN_ITEM |
DWB_SRVC_RQST |
DWB_TAP_IN_WRLS_RMNG_EVT |
DWB_TAP_OUT_WRLS_RMNG_EVT |
DWB_TNDR_CNTRL_TRX |
DWB_TRBLE_TCKT |
DWB_TRBLE_TCKT_FLD_SPPRT_ASGN |
DWB_TRBLE_TCKT_ITEM |
DWB_TRKNG_REC |
DWB_UDR_EVT |
DWB_UDR_EVT_ASGN |
DWB_UMS_EVT |
DWB_UNIT_ALWNCE |
DWB_VNDR_APNMNT |
DWB_VOIP_CALL_EVT |
DWB_WRLS_CALL_EVT |
DWB_WRLS_CNTNT_DNLDG_EVT |
DWB_WRLS_RMNG_EVT |
DWB_WRLS_RMNG_EVT_BTCH |
DWD_ACCT_BAL_MO |
DWD_ACCT_DEBT_MO |
DWD_ACCT_FRST_ACTVTY |
DWD_ACCT_LAST_ACTVTY |
DWD_ACCT_PYMT_DAY |
DWD_ACCT_PYMT_MTHD_STAT_HIST |
DWD_AGRMNT |
DWD_AGRMNT_CHNG |
DWD_AGRMNT_RVN_DAY |
DWD_BER_FER_ERR_RATIO_DAY |
DWD_CANBLZTN_DTL_DAY |
DWD_CELL_STTSTC_DAY |
DWD_CMISN |
DWD_CMPGN_HIST_DAY |
DWD_CNT_DAY |
DWD_CNTCT_CNTR_DAY |
DWD_COST_CNTR |
DWD_CUST_COST |
DWD_CUST_DNA |
DWD_CUST_EQPMNT_INSTLTN_DAY |
DWD_CUST_ORDR_DAY |
DWD_CUST_ORDR_LN_ITEM_DAY |
DWD_CUST_RFMP_SCR |
DWD_CUST_SKU_SL_RETRN_DAY |
DWD_DATA_USG_DAY |
DWD_GIVE_AWAY_ITEM_DAY |
DWD_IN_PLTFRM_DAY |
DWD_INV_ADJ_ITEM_DAY |
DWD_INV_POSN_ITEM_DAY |
DWD_INV_RCPT_ITEM_DAY |
DWD_INV_UNAVL_ITEM_DAY |
DWD_INV_VNDR_CMPLNC_DAY |
DWD_INV_XFER_ITEM_DAY |
DWD_INVC_AGNG_DAY |
DWD_INVC_DAY |
DWD_LYLTY_MBR_PNT_DAY |
DWD_MKT_SHARE |
DWD_MSC_TRFC_DAY |
DWD_NBR_PRT_DAY |
DWD_NTWK_AVLBLTY_DAY |
DWD_NTWK_TCHPNT |
DWD_ORG_BSNS_UNT_HRS_DAY |
DWD_POS_TNDR_FLOW |
DWD_PRCS_INVC_DAY |
DWD_PRPD_ACCT_STTSTC_DAY |
DWD_PRPD_ALWNCE_DAY |
DWD_PRTNR_STLMNT |
DWD_RF_NTWK_CPCTY_DAY |
DWD_RTL_SL_RETRN_ITEM_DAY |
DWD_RVN_DAY |
DWD_SL_RPRSTV_STTSTC |
DWD_SPLMNTR_SRVC_USG |
DWD_SRVC_PRBLM_DAY |
DWD_STORE_EFFNCY_DAY |
DWD_TMF_KPI |
DWD_VAS_SBRP_QCK_SUMM |
DWD_VAS_USG_DAY |
DWD_VOI_CALL_DAY |
This section includes information on the following:
Oracle OLAP Cube Views: Oracle OLAP cube views provide organizations with the ability to both improve the performance and analytic content of SQL-based business intelligence applications. OLAP cube views are relational views of OLAP cubes, dimensions, and hierarchies that reveal the full content of cubes and dimensions.
Cube MV (Materialized Cube Views): Cube-organized materialized views, introduced, in Oracle Database 11g, play the same role as table-based materialized views. That is, a summary management solution that is transparent to the querying application. Like table-based materialized views, the application queries the detail tables and the database automatically rewrites the query to access summary data in the materialized view. In the case of cube-organized materialized views, the data is managed in the cube rather than a table.
Table 4-12 shows the cube materialized views in ocdm_sys
schema.
Table 4-12 OLAP Cube Materialized Views in ocdm_sys Schema
Cube Materialized View Name | OLAP Object Name | OLAP Object Type | More Information |
---|---|---|---|
|
|
Cube |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Dimension_Hierarchy |
|
|
|
Cube |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Cube |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Cube |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Cube |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Cube |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
|
|
|
Dimension_Hierarchy |
Table 4-13 shows the OLAP cube views in ocdm_sys
schema.
Table 4-13 OLAP Cube Views in ocdm_sys schema
Cube View Name | OLAP Object Name | OLAP Object Type | More Information |
---|---|---|---|
|
|
Cube |
Customer Acquisition Forecast Statistic Cube: ACM_FCST_STTSTC |
|
|
Cube |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Cube |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Cube |
|
|
|
Hierarchy |
|
|
|
Hierarchy |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Cube |
|
|
|
Cube |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |
|
|
|
Hierarchy |
|
|
|
Dimension |