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 |