Provides information about the physical data model of Oracle Communications Data Model.
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:
Note:
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-1 Table Name Prefix Conventions
Prefix | Description |
---|---|
DWA_ |
Aggregate table |
DWB_ |
Base transaction table |
DWD_ |
Derived table (Mining included) |
DWL_ |
Lookup table |
DWR_ |
Reference data table |
Table 4-2 Other Table Name Prefix Conventions
Prefix | Description |
---|---|
DM$ DR$ |
Created when the mining models are trained. Used to store trained model and logs. |
CUBE |
Created when OLAP cubes are built. Used to store logs and results. |
Provides information on the Reference tables in Oracle Communications Data Model.
Table 4-3 Reference Tables
Table Name | More Information |
---|---|
DWR_ACCS_MTHD |
|
DWR_ACCS_MTHD_ACCT_ASGN |
|
DWR_ACCS_MTHD_ASGN |
|
DWR_ACCS_MTHD_ELMNT |
|
DWR_ACCS_MTHD_ELMNT_ASGN |
|
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_RSCE_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_ACTVTY_PROVSN_PLN |
|
DWR_ACTVTY_PROVSN_PLN_DTL |
|
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_SLA_RLTN | AGREEMENT SLA RELATIONSHIP |
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_DOC |
|
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 |
CONFIGURABLE PRODSPECCHARRACTERISTIC PRODSPECIFICATION ASSIGNMENT |
DWR_CFGBL_PROD_SPEC_CHAR |
|
DWR_CFS_NTWK_SRVC_ASGN | CFS NETWORK SERVICE ASSIGNMENT |
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 |
|
DWR_CLNT_HOST |
|
DWR_CLNT_VRSN |
|
DWR_CLSSIFR_SRVC |
|
DWR_CMPGN |
|
DWR_CMPGN_CHAR |
|
DWR_CMPGN_CHAR_RLTN |
|
DWR_CMPGN_CHAR_VAL |
|
DWR_CMPGN_CHAR_VAL_USE |
|
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_CHARVALUSE |
|
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_CRCUT_XREF |
|
DWR_CRDT_CTGRY |
|
DWR_CRDT_SCR_PRVDR |
|
DWR_CRNCY_GEO_ENT_ASGN |
|
DWR_CROSSD_THRSHLD |
|
DWR_CSTM_QUENG_SRVC |
|
DWR_CSTM_TAB_CLMN_CHAR |
|
DWR_CTLG | CATALOG |
DWR_CTLG_ASGN | CATALOG ASSIGNMENT |
DWR_CTLG_CTLG_ITEM_ASGN | CATALOG CATALOG ITEM ASSIGNMENT |
DWR_CTLG_ITEM | CATALOG ITEM |
DWR_CTLG_ITEM_ASGN | CATALOG ITEM ASSIGNMENT |
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_ASGN |
|
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_DRCTD_EDGE_VRTX_RLTN | TBS |
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_FXBLE_CHAR_VAL_USE |
|
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_FRWRDNG_GRAPH | FORWARDING GRAPH NETWORK SERVICE ASSIGNMENT |
DWR_FRWRDNG_GRPH_NTWK_SVC_ASGN | FORWARDING GRAPH NETWORK SERVICE ASSIGNMENT |
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_GRAPH_DRCTD_EDGE_RLTN | GRAPH DIRECTED EDGE RELATIONSHIP |
DWR_GRAPH_VRTX_RLTN | GRAPH DIRECTED EDGE RELATIONSHIP |
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_LGICL_RSCE_VRTL_RSCE_ASGN | LOGICAL RESOURCE VIRTUAL RESOURCE ASSIGNMENT |
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_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_FNCTN | NETWORK FUNCTION |
DWR_NTWK_FNCTN_ASGN | NETWORK FUNCTION ASSIGNMENT |
DWR_NTWK_FNCTN_INTRNL_TPLG | NETWORK FUNCTION ASSIGNMENT |
DWR_NTWK_FNCTN_TRNSFR_FNCTN | NETWORK FUNCTION ASSIGNMENT |
DWR_NTWK_FNCTN_VRTL_RSCE_ASGN | NETWORK FUNCTION ASSIGNMENT |
DWR_NTWK_FRWRDNG_SRVC |
|
DWR_NTWK_NODE |
|
DWR_NTWK_ROUTE |
|
DWR_NTWK_ROUTE_PNT |
|
DWR_NTWK_ROUTE_PNT_ASGN |
|
DWR_NTWK_ROUTE_SECTN |
|
DWR_NTWK_SITE |
|
DWR_NTWK_SITE_ADDR_LOC_HIST |
|
DWR_NTWK_SITE_ADDTXT |
|
DWR_NTWK_SRVC | NETWORK SERVICE |
DWR_NTWK_SRVC_ASGN | NETWORK SERVICE ASSIGNMENT |
DWR_NTWK_SRVC_COVRG_ASGN |
|
DWR_NTWK_SRVC_NTWK_FNCTN_ASGN | NETWORK SERVICE NETWORK FUNCTION ASSIGNMENT |
DWR_NTWK_TCHPNT |
|
DWR_OPERTNG_SYS |
|
DWR_ORACLE_GEOMETRY | 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 |
PRODUCT SPECIFICATION CHARACTERISTIC VAL RESOURCE CHARACTERISTIC VAL ASSIGNMENT |
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_LCL_ADDR_ASGN |
|
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_PHY_RSCE_VRTL_RSCE_ASGN | PHYSICAL RESOURCE ROLE ASSIGNMENT |
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_SPEC |
|
DWR_PLCY_ACTN_VNDR |
|
DWR_PLCY_APPLN |
|
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_SPEC |
|
DWR_PLCY_CNDTN_TIME_PRD |
|
DWR_PLCY_CNDTN_VNDR |
|
DWR_PLCY_DMN |
|
DWR_PLCY_EVT_SPEC |
|
DWR_PLCY_GRP |
|
DWR_PLCY_GRP_EXEC_DTL |
|
DWR_PLCY_OPRTR |
|
DWR_PLCY_OPRTR_VARBLE_ASGN |
|
DWR_PLCY_PLCY_ACTN_ASGN |
|
DWR_PLCY_RL |
|
DWR_PLCY_RULE |
|
DWR_PLCY_RULE_ASGN |
|
DWR_PLCY_RULE_SPEC |
|
DWR_PLCY_SET |
|
DWR_PLCY_SET_ASGN |
|
DWR_PLCY_SET_SPEC |
|
DWR_PLCY_STMT |
|
DWR_PLCY_TBL |
|
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_PLTFRM |
|
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 |
PRODUCT SPECIFICATION CHARACTERISTIC RESOURCE SPECIFICATION CHARACTERISTIC ASSIGNMENT |
DWR_PRFMNC_ALRM_SPECFTN |
|
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_DRVTN_PRMTR |
|
DWR_PRFMNC_IND_RLTN |
|
DWR_PRFMNC_IND_SPEC_RLTN |
|
DWR_PRFMNC_IND_SPEC |
|
DWR_PRFMNC_IP_ADDR |
|
DWR_PRFMNC_MBL_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_PRFMNC_THRSHLD |
|
DWR_PRFMNC_THRSHLD_APLBLETY |
|
DWR_PRFMNC_THRSHLD_APLBLTY_CSQ |
|
DWR_PRFMNC_THRSHLD_RULE |
|
DWR_PRFMNC_THRSHLD_RULE_DEF |
|
DWR_PRFMNC_THRSH_RLE_PREDE_PRM |
|
DWR_PRICE_DRVTN_RULE |
|
DWR_PRICE_TYP_RLTN |
|
DWR_PRIORITY_HRCHY_LVL | PRIORITY HIERARCHY LEVEL |
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_CTLG_SPEC |
|
DWR_PROD_FNCTNLTY_DPNDCY | PRODUCT FUNCTIONALITY DEPENDENCY |
DWR_PROD_SPEC_CHAR_CFGBL_ASGN | PRODUCT SPECIFICATION CHARACTERISTIC CONFIGURABLE ASSIGNMENT |
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_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_CNTCT_INFO | PARTY CONTACT INFORMATION |
DWR_PRTY_DEMOG |
|
DWR_PRTY_DEMOG_ASGN |
|
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_ASGN |
|
DWR_PRTY_PRFL_TYP_CHAR_RLTN |
|
DWR_PRTY_PRFL_TYP_CHAR_VAL |
|
DWR_PRTY_PRFL_TYP_CHAR_VALASGN |
|
DWR_PRTY_PROD_SBRP_ASGN |
|
DWR_PRTY_PRTY_PRFL_ASGN |
|
DWR_PRTY_PRTY_PRFL_VAL_USE |
|
DWR_PRTY_RL |
|
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_SITE |
|
DWR_REFERRING_URL |
|
DWR_RF_CARRIER |
|
DWR_RFS_NTWK_SRVC_ASGN | TBS |
DWR_RFS_SPEC_VRSN_DTL |
|
DWR_RL |
|
DWR_RL_HRCHY |
|
DWR_RND_RBIN_SCHDLNG_SRVC |
|
DWR_RNGTN |
|
DWR_ROOT_ENT |
|
DWR_ROUTED_PROTCL |
|
DWR_ROUTER |
|
DWR_RPLCMT_SET |
|
DWR_RSCE |
|
DWR_RSCE_CANDIDATE |
|
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_CTLG |
|
DWR_RSCE_CTLG_CANDIDATE_ASGN |
|
DWR_RSCE_CTLG_SPEC |
|
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_MGMT_PLCY |
|
DWR_RSCE_NOTE |
|
DWR_RSCE_PRFMNC_SPEC |
|
DWR_RSCE_PRT |
|
DWR_RSCE_PRTY_ASSOCTN |
|
DWR_RSCE_PRTY_MGMT |
|
DWR_RSCE_PRTY_PLCY_MGMT_ASGN |
|
DWR_RSCE_RL |
|
DWR_RSCE_RL_ASGN |
|
DWR_RSCE_RL_PRTY_ASGN |
|
DWR_RSCE_RL_PRTY_RL_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_RSCE_XREF |
|
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 CHARACTERISTIC VAL RESOURCE SPECIFICATION CHARACTERISTIC 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_BSNS_ACTOR |
|
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_AREA_RLTN | SERVICE COVERAGE AREA RELATIONSHIP |
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_MGMT_PLCY |
|
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_PRTY_PLCY_MGMT_ASGN |
|
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 |
SERVICE SPECIFICATION CHAR RESOURCE SPECIFICATION CHARACTERISTIC ASSIGNMENT |
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_TFC_NTWK |
|
DWR_TIME_OF_DAY_PRD_BND | TIME OF DAY PERIOD BAND |
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_CHAR_VAL_USE |
|
DWR_UDR_EVT_SPEC |
|
DWR_UDR_EVT_SPEC_CHAR |
|
DWR_UDR_EVT_SPEC_CHAR_RLTN |
|
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_RSCE | VIRTUAL RESOURCE |
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 4-4 Lookup Tables
Table Name | More Information |
---|---|
DWL_ACCT_BAL_IMPC_RSN | ACCOUNT BALANCE IMPACT REASON |
DWL_ACCS_MTHD_ASGN_TYP |
|
DWL_ACCS_MTHD_CTGRY |
|
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 |
TBS |
DWL_ACCT_PRFL_TYP |
|
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_JEOPARDY_RSN |
|
DWL_ACTVTY_JEOPARDY_TYP |
|
DWL_ACTVTY_RLTN_TYP |
|
DWL_ACTVTY_RSLT_TYP |
|
DWL_ACTVTY_TYP |
|
DWL_ADDR_LOC_CTGRY |
|
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_GRP_CTGRY | AGE GROUP CATEGORY |
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_DRCTN |
|
DWL_CALL_DRTN_BND | CALL DURATION BAND |
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_CARD_HLDR_VRFY_TYP |
|
DWL_CARD_TYP |
|
DWL_CELL_OUTG_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_CNTCT_LST_CHNG_RSN | CONTACT LIST CHANGE REASON |
DWL_CNTCT_LST_RECRNC_TYP | CONTACT LIST RECURRENCE TYPE |
DWL_CNTCT_MEDIUM |
|
DWL_CNTCT_RL | CONTACT ROLES |
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_CMPNT_TYP | CIRCUIT COMPONENT TYPE |
DWL_CRCUT_CTGRY |
|
DWL_CRCUT_RNTL_EVT_TYP |
|
DWL_CRCUT_TYP |
|
DWL_CRNCY |
|
DWL_CRTFCT_TYP |
|
DWL_CTLG_TYP |
|
DWL_CUST_CLASS |
|
DWL_CUST_CLSTR_TYP |
|
DWL_CUST_GRP |
|
DWL_CUST_OCCSN_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_IP_CAN_TYP |
|
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_AREA_TYP | NUMBER AREA TYPE |
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_FNCTN_STATE | NETWORK FUNCTION INTERNAL TOPOLOGY |
DWL_NTWK_TCHPNT_CLASS |
|
DWL_NTWK_TCHPNT_STAT |
|
DWL_NTWK_TCHPNT_TYP |
|
DWL_NTWK_TYP |
|
DWL_ONOFF_NET_TYP | ON OFF NET TYPE |
DWL_OPRTR_GRP |
|
DWL_OPRTR_TYP | OPERATOR TYPE |
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_OUTG_RSN |
|
DWL_PIT_CHAR_TYP |
|
DWL_PK_OFPK_TIME |
|
DWL_PLCY_EVT_SPEC_TYP |
|
DWL_PLCY_EVT_TRGR_MSK |
|
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_PRIORITY_CTGRY | PRIORITY CATEGORY |
DWL_PRIORITY_HRCHY | PRIORITY HIERARCHY |
DWL_PRMTN_RSLT_TYP |
|
DWL_PRMTN_TERM_TYP |
|
DWL_PRMTN_TYP |
|
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_CNTCT_INFO_TYP |
|
DWL_PRTY_CNTCT_LST_PRTCPTN |
|
DWL_PRTY_CNTCT_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_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_RSLT | PAYMENT RESULT |
DWL_PYMT_TRX_TYP |
|
DWL_QOS_SRVC_SPEC_TYP |
|
DWL_QTA_USG_BND |
|
DWL_RAT_TYP |
|
DWL_RATABLE_UNIT_MEASUREMENT |
|
DWL_RDMPTN_TYP |
|
DWL_RCHRG_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 |
|
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_SBCRBR_ACTVTN_RSN |
|
DWL_SCRPT_QUES_TYP |
|
DWL_SCRTY_REQD_TYP |
|
DWL_SEASON |
|
DWL_SRVR_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_SITE_TYP_CTGRY |
|
DWL_SKILL_TYP |
|
DWL_SKU_TYP |
|
DWL_SL_OR_RETRN_ACTN |
|
DWL_SLNG_LOC_TYP |
|
DWL_SPNM |
|
DWL_SRC_DSTN_TYP |
|
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_UNSUCC_CALL_RSN | UNSUCCESSFUL CALL REASON |
DWL_UOM |
|
DWL_UOM_TYP | UNIT OF MEASURE TYPE |
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 4-5 Base Tables
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_ACTION | ACCOUNT DEBT ACTION |
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_ACTVTY_JEOPARDY |
|
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_CHAR_VAL_USE |
|
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_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_FIXED_LN_CALL_EVT | ERRORED FIXED LINE CALL EVENT |
DWB_ERRD_GPRS_USG_EVT | ERRORED RAW WIRELESS CALL EVENT |
DWB_ERRD_MDTD_CALL_EVT |
|
DWB_ERRD_MMS_EVT | ERRORED MMS EVENT |
DWB_ERRD_RAW_WRLS_CALL_EVT |
|
DWB_ERRD_RTD_WRLS_CALL_EVT |
|
DWB_ERRD_SMS_EVT | ERRORED SMS EVENT |
DWB_ERRD_WRLS_CNTNT_DNLDG_EVT | ERRORED RAW WIRELESS CALL EVENT |
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_EVTEMP_ACTPRTY_INTRACNASGN |
|
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 | GPRS USAGE EVENT |
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_ITEM_USG_DTL | INVOICE ITEM USAGE DETAIL |
DWB_INVC_ITEM_USG_DTL_SPEC | INVOICE ITEM USAGE DETAIL |
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_LATE_FIXED_LN_CALL_EVT | LATE FIXED LINE CALL EVENT |
DWB_LATE_UDR_EVT | LATE UDR EVENT |
DWB_LATE_WRLS_CALL_EVT | LATE WIRELESS CALL EVENT |
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 | MMS EVENT |
DWB_MNGMT_JB |
|
DWB_MSRMNT_JB |
|
DWB_MSRMNT_THRSHLD_JB |
|
DWB_MTCHD_PLCY |
Note: this table is reserved for use by the Oracle Communications Policy and Charging Analytics solution. |
DWB_MTCHD_PLCY_TBL |
Note: this table is reserved for use by the Oracle Communications Policy and Charging Analytics solution. |
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_ASGN |
|
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_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_GPRS_USG_EVT | RAW GPRS USAGE EVENT |
DWB_RAW_MMS_EVT |
|
DWB_RAW_SMS_EVT | RAW SMS EVENT |
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_SCRPT_ANSWR | SCRIPT ANSWER |
DWB_SESSION |
|
DWB_SL_CHNL_CMISN_PLN_ASGN |
|
DWB_SL_CMISN_DTL |
|
DWB_SL_CMISN_PYRL |
|
DWB_SMS_EVT | TBS |
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_RQST_HIST | SERVICE REQUEST HISTORY |
DWB_SRVC_RQST_LN_ITEM |
|
DWB_SRVC_RQST_LN_ITEM_HIST | SERVICE REQUEST LINE ITEM |
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_WRK_QUE |
|
DWB_WRLS_CALL_EVT | WIRELESS CALL EVENT |
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_CANBLZTN_DTL_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_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 4-7 Aggregate Tables
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 4-9 Control Tables
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 |
Compressed Tables
This section 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.
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_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_CANBLZTN_DTL_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-11 shows the cube materialized views in ocdm_sys
schema.
Table 4-11 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-12 shows the OLAP cube views in ocdm_sys
schema.
Table 4-12 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 |