This chapter provides the partitioning strategy for the Oracle Communications Data Model physical base, derived, and aggregate tables.
This chapter includes the following section:
All base, derived, and aggregate tables are partitioned, with the (standard) compression and parallel option activated by default. These tables are partitioned due to their nature (size) for performance and scalability and to improve performance. The default partition method used is INTERVAL partitioning, which creates automatically equi-sized partitions as data arrives. For partitioning, usually, a column of data type DATE is used (DAY or MONTH level).
If Exadata is used with the Hybrid Columnar Compression option, the option is leveraged for use with Oracle Communications Data Model.
For more information, see Oracle Communications Data Model Implementation and Operations Guide.
Table 6-1 shows the partitioning strategy for the Oracle Communications Data Model physical base, derived, and aggregate tables.
Table 6-1 Physical Data Model Partitioning
| Physical Table Name | Partitioning Type | Partition Key Column | Partition Level | Default Tablespace Name |
|---|---|---|---|---|
|
DWA_ACCT_DEBT_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_ACCT_PYMT_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_ACCT_STTSTC_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_ARPU_BASE_CUST_TYP |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_BER_FER_ERR_RATIO_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_CALL_CNTR_CALL_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_CALL_CNTR_CASE_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_CELL_STTSTC_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_CMISN_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_CNT_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_COST_CNTR_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_CUST_ACQSTN_SUMM_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_CUST_CHRN_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_CUST_COST_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_CUST_DEBT_COLLCTN_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_CUST_EQPMNT_INSTLTN_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_CUST_GROSS_ORDRS_QTR |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_CUST_ORDR_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_DATA_USG_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_INVC_ADJ_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_INVC_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_INV_POSN_DEPT_DAY |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_INV_POSN_SBC_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_IN_PLTFRM_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_LYLTY_PROG_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_MKT_SHARE |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_MSC_TRFC_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_NBR_PRT_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_NTWK_AVLBLTY_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_NTWK_TCHPNT_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_PRPD_ALWNCE_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_PRTNR_STLMNT_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_RDMPTN_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_RF_NTWK_CPCTY_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_RVN_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_SBSCBR_STTSTC_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_SL_CMPGN_SUMM_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_SPLMNTR_SRVC_USG_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_STORE_EFFNCY_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_VAS_SBRP_QCK_SUMM_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_VAS_USG_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWA_VOI_CALL_MO |
RANGE |
MO_KEY |
MONTH |
TBS_MV |
|
DWB_ACCS_MTHD_PORT_HIST |
RANGE |
ACT_CTVR_DT |
QUARTER |
TBS_BASE |
|
DWB_ACCS_MTHD_STAT_HIST |
RANGE |
EFF_FROM_DT |
QUARTER |
TBS_BASE |
|
DWB_ACCT_ACCTNG_CYCL_HIST |
RANGE |
EFF_FROM_DT |
QUARTER |
TBS_BASE |
|
DWB_ACCT_BAL_IMPC |
RANGE |
IMPC_DT |
MONTH |
TBS_BASE |
|
DWB_ACCT_BLLG_OCCRNCE |
RANGE |
BLLG_DT |
QUARTER |
TBS_BASE |
|
DWB_ACCT_COST |
RANGE |
INCURR_DT |
MONTH |
TBS_BASE |
|
DWB_ACCT_CRDT_LMT |
RANGE |
CRDT_RTNG_DT |
MONTH |
TBS_BASE |
|
DWB_ACCT_MNGMNT_HIST |
RANGE |
ASGN_STRT_DT |
MONTH |
TBS_BASE |
|
DWB_ACCT_PROD_OFR_PRTCPTN_HIST |
RANGE |
RLTN_STRT_DT |
MONTH |
TBS_BASE |
|
DWB_ACCT_PYMT |
RANGE |
PYMT_DT |
MONTH |
TBS_BASE |
|
DWB_ACCT_PYMT_MTHD_STAT |
RANGE |
EFF_FROM_DT |
MONTH |
TBS_BASE |
|
DWB_ACCT_STAT_HIST |
RANGE |
EFF_FROM_DT |
MONTH |
TBS_BASE |
|
DWB_ADDR_STAT_HIST |
RANGE |
EFF_FROM_DT |
QUARTER |
TBS_BASE |
|
DWB_AGRMNT_APRVL |
RANGE |
AGRMNT_APRVL_DT |
MONTH |
TBS_BASE |
|
DWB_AGRMNT_STAT |
RANGE |
EFF_FROM_DT |
MONTH |
TBS_BASE |
|
DWB_AGRMNT_TERM |
HASH |
AGRMNT_KEY |
N/A |
TBS_BASE |
|
DWB_APNMNT_CLNDR |
RANGE |
DAY_KEY |
DAY |
TBS_BASE |
|
DWB_BLK_LST_HIST |
RANGE |
EFF_FROM_DT |
MONTH |
TBS_BASE |
|
DWB_BRDBND_USG_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_BSNS_INTRACN |
RANGE |
STRT_DT |
QUARTER |
TBS_BASE |
|
DWB_BSNS_INTRACN_HIST |
RANGE |
TRX_DT |
QUARTER |
TBS_BASE |
|
DWB_BSNS_UNIT_COST |
RANGE |
INCURR_DT |
MONTH |
TBS_BASE |
|
DWB_CELL_SITE_COST |
RANGE |
INCURR_DT |
MONTH |
TBS_BASE |
|
DWB_CHNL_COST |
RANGE |
INCURR_DT |
MONTH |
TBS_BASE |
|
DWB_CMPGN_COST |
RANGE |
INCURR_DT |
MONTH |
TBS_BASE |
|
DWB_CMPGN_MSG_CRTVE |
RANGE |
CRTN_DT |
MONTH |
TBS_BASE |
|
DWB_CNCT_LST_COST |
RANGE |
INCURR_DT |
MONTH |
TBS_BASE |
|
DWB_CNTNT_DLVRY_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_COST |
RANGE |
INCURR_DT |
MONTH |
TBS_BASE |
|
DWB_COST_CNTR_BDGT |
RANGE |
EFF_FROM_DT |
MONTH |
TBS_BASE |
|
DWB_COURIER_COST |
RANGE |
INCURR_DT |
MONTH |
TBS_BASE |
|
DWB_CRCUT_RNTL |
RANGE |
EFF_FROM_DT |
MONTH |
TBS_BASE |
|
DWB_CRCUT_TRFC |
RANGE |
EFF_STRT_DT |
MONTH |
TBS_BASE |
|
DWB_CRNCY_EXCHNG_RATE |
RANGE |
EXCHNG_RATE_DT |
MONTH |
TBS_BASE |
|
DWB_CUST_COST |
RANGE |
INCURR_DT |
MONTH |
TBS_BASE |
|
DWB_CUST_FLD_SRVC_ACTVTY |
RANGE |
FLD_ACTVTY_STRT_DT |
MONTH |
TBS_BASE |
|
DWB_CUST_FLD_SRVC_DTL |
RANGE |
ACTN_STRT_DT |
MONTH |
TBS_BASE |
|
DWB_CUST_ORDR |
RANGE |
ORGNL_ORDR_DT |
MONTH |
TBS_BASE |
|
DWB_CUST_ORDR_LN_ITEM |
RANGE |
ORGNL_ORDR_DT |
MONTH |
TBS_BASE |
|
DWB_CUST_ORDR_LN_ITEM_ST_ASGN |
RANGE |
ORDR_LN_ITEM_STATE_BEGIN_DT |
MONTH |
TBS_BASE |
|
DWB_CUST_ORDR_PYMT |
RANGE |
PYMT_DT |
MONTH |
TBS_BASE |
|
DWB_CUST_ORDR_STATE_ASGN |
RANGE |
ORDR_STATE_BEGIN_DT |
MONTH |
TBS_BASE |
|
DWB_DATA_SRVC_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_DISC_LI |
RANGE |
DAY_KEY |
MONTH |
TBS_BASE |
|
DWB_EMP_ACT_LBR_HRLY |
RANGE |
DAY_KEY |
DAY |
TBS_BASE |
|
DWB_EMP_ACT_LBR_SALARIED |
RANGE |
DAY_KEY |
DAY |
TBS_BASE |
|
DWB_EMP_COST |
RANGE |
INCURR_DT |
MONTH |
TBS_BASE |
|
DWB_EMP_EXP_RPT |
RANGE |
STRT_DT |
MONTH |
TBS_BASE |
|
DWB_EMP_TRNG_REC |
RANGE |
TRNG_STRT_DT |
MONTH |
TBS_BASE |
|
DWB_EQPMNT_CNTR_COST |
RANGE |
INCURR_DT |
MONTH |
TBS_BASE |
|
DWB_ERRD_MDTD_CALL_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_ERRD_RAW_WRLS_CALL_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_ERRD_RTD_WRLS_CALL_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_EVT |
RANGE |
STRT_DT |
DAY |
TBS_BASE |
|
DWB_EVT_ACCS_MTHD_ACTVTY |
RANGE |
STRT_DT |
DAY |
TBS_BASE |
|
DWB_EVT_ACCT |
RANGE |
STRT_DT |
MONTH |
TBS_BASE |
|
DWB_EVT_AGRMNT |
RANGE |
STRT_DT |
DAY |
TBS_BASE |
|
DWB_EVT_ASGN |
RANGE |
EFF_FROM_DT |
DAY |
TBS_BASE |
|
DWB_EVT_CMPST_PROD_SPEC |
RANGE |
STRT_DT |
MONTH |
TBS_BASE |
|
DWB_EVT_COST |
RANGE |
INCURR_DT |
MONTH |
TBS_BASE |
|
DWB_EVT_CRCUT_RNTL |
RANGE |
STRT_DT |
MONTH |
TBS_BASE |
|
DWB_EVT_EMP_PYRL |
RANGE |
STRT_DT |
MONTH |
TBS_BASE |
|
DWB_EVT_EQPMNT_INSTNC |
RANGE |
STRT_DT |
MONTH |
TBS_BASE |
|
DWB_EVT_FINCL |
RANGE |
STRT_DT |
MONTH |
TBS_BASE |
|
DWB_EVT_GEO |
RANGE |
STRT_DT |
MONTH |
TBS_BASE |
|
DWB_EVT_LYLTY_PROG |
RANGE |
TRX_DT |
MONTH |
TBS_BASE |
|
DWB_EVT_PROD_SBRP_WRLS |
RANGE |
STRT_DT |
MONTH |
TBS_BASE |
|
DWB_EVT_PRPD_MBL |
RANGE |
STRT_DT |
MONTH |
TBS_BASE |
|
DWB_EVT_PRTY_ASGN |
RANGE |
EFF_DT |
DAY |
TBS_BASE |
|
DWB_EVT_PRTY_INTRACN |
RANGE |
STRT_DT |
MONTH |
TBS_BASE |
|
DWB_EVT_PRTY_PRFL |
RANGE |
STRT_DT |
MONTH |
TBS_BASE |
|
DWB_EVT_SBRP_CHNG |
RANGE |
STRT_DT |
MONTH |
TBS_BASE |
|
DWB_EVT_SIM_CARD |
RANGE |
STRT_DT |
MONTH |
TBS_BASE |
|
DWB_EVT_STAT |
RANGE |
EFF_FROM_DT |
DAY |
TBS_BASE |
|
DWB_EXP_RPT_PRTY_ASGN |
RANGE |
EFF_DT |
DAY |
TBS_BASE |
|
DWB_FIXED_LN_CALL_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_GPRS_USG_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_IDD_CALL_EVT |
RANGE |
EVT_BEGIN_DT |
MONTH |
TBS_BASE |
|
DWB_INTRACN_QUES_RESPN |
RANGE |
RESPN_DT |
QUARTER |
TBS_BASE |
|
DWB_INTRNT_ACCS_EVT |
RANGE |
EVT_BEGIN_DT |
MONTH |
TBS_BASE |
|
DWB_INVC |
RANGE |
BLLG_DT |
MONTH |
TBS_BASE |
|
DWB_INVC_ADJ |
RANGE |
STRT_DT |
MONTH |
TBS_BASE |
|
DWB_INVC_DISC |
RANGE |
BLLG_DT |
MONTH |
TBS_BASE |
|
DWB_INVC_ITEM |
RANGE |
BLLG_DT |
MONTH |
TBS_BASE |
|
DWB_INVC_ITEM_DTL |
RANGE |
BLLG_DT |
MONTH |
TBS_BASE |
|
DWB_INVC_PYMT_ASGN |
RANGE |
EFF_FROM_DT |
MONTH |
TBS_BASE |
|
DWB_INVC_PYMT_TERM |
RANGE |
BLLG_DT |
MONTH |
TBS_BASE |
|
DWB_INVC_STAT_HIST |
RANGE |
EFF_FROM_DT |
MONTH |
TBS_BASE |
|
DWB_INV_ADJ_DOC_LI |
RANGE |
INV_ADJ_DOC_DT |
MONTH |
TBS_BASE |
|
DWB_INV_CNTRL_DOC |
RANGE |
INV_CNTRL_DOC_DT |
MONTH |
TBS_BASE |
|
DWB_INV_CNTRL_DOC_LI |
RANGE |
INV_CNTRL_DOC_DT |
MONTH |
TBS_BASE |
|
DWB_INV_ITEM_STATE |
RANGE |
EFF_FROM_DT |
DAY |
TBS_BASE |
|
DWB_ISP_USG_EVT |
RANGE |
EVT_BEGIN_DT |
MONTH |
TBS_BASE |
|
DWB_MDTD_CALL_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_MEDIA_OBJ_COST |
RANGE |
INCURR_DT |
MONTH |
TBS_BASE |
|
DWB_MMS_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_NP_RQST_HDR |
RANGE |
APLCTN_DT |
MONTH |
TBS_BASE |
|
DWB_NP_RQST_LN_ITEM |
RANGE |
NP_STEP_STRT_DT |
MONTH |
TBS_BASE |
|
DWB_NP_RQST_LN_ITEM_STATE_HIST |
RANGE |
EFF_FROM_DT |
MONTH |
TBS_BASE |
|
DWB_NP_RQST_STATE_HIST |
RANGE |
EFF_FROM_DT |
MONTH |
TBS_BASE |
|
DWB_PHY_CNT_DOC |
RANGE |
PHY_CNT_BEGIN_DT |
YEAR |
TBS_BASE |
|
DWB_PHY_CNT_DOC_LI |
RANGE |
PHY_CNT_BEGIN_DT |
YEAR |
TBS_BASE |
|
DWB_PRCS_COST |
RANGE |
INCURR_DT |
MONTH |
TBS_BASE |
|
DWB_PRICE_EVT |
RANGE |
STRT_DT |
DAY |
TBS_BASE |
|
DWB_PRMTN_CLSTR_USG |
RANGE |
USG_DT |
HALF YEAR |
TBS_BASE |
|
DWB_PRMTN_CNCT_LST_UTLZTN |
RANGE |
USG_DT |
HALF YEAR |
TBS_BASE |
|
DWB_PRMTN_COST |
RANGE |
INCURR_DT |
MONTH |
TBS_BASE |
|
DWB_PRMTN_MGMT_HIST |
RANGE |
EFF_FROM_DT |
MONTH |
TBS_BASE |
|
DWB_PRMTN_TERM_VAL |
RANGE |
TERM_PRD_STRT |
MONTH |
TBS_BASE |
|
DWB_PROD_OFR_COST |
RANGE |
INCURR_DT |
MONTH |
TBS_BASE |
|
DWB_PROD_OFR_MGMT |
RANGE |
MNG_ACTN_DT |
MONTH |
TBS_BASE |
|
DWB_PROD_SBRP_STAT_HIST |
RANGE |
EFF_FROM_DT |
MONTH |
TBS_BASE |
|
DWB_PROD_SPEC_COST |
RANGE |
INCURR_DT |
MONTH |
TBS_BASE |
|
DWB_PROD_SPEC_MGMT_HIST |
RANGE |
EFF_FROM_DT |
QUARTER |
TBS_BASE |
|
DWB_PROD_SPEC_STAT_HIST |
RANGE |
EFF_FROM_DT |
QUARTER |
TBS_BASE |
|
DWB_PRPD_RCHRG |
RANGE |
PYMT_DT |
MONTH |
TBS_BASE |
|
DWB_PRTNR_PYMT |
RANGE |
PYMT_DT |
MONTH |
TBS_BASE |
|
DWB_PRTY_AM_PROD_OFR_ASGN_HIST |
RANGE |
ASGN_BEGIN_DT |
MONTH |
TBS_BASE |
|
DWB_PRTY_AM_PROD_OFR_ASGN_STAT |
RANGE |
ASGN_BEGIN_DT |
MONTH |
TBS_BASE |
|
DWB_PRTY_COST_ASGN |
RANGE |
ASGN_DT |
MONTH |
TBS_BASE |
|
DWB_PRTY_ORDR_ASGN |
RANGE |
EFF_FROM_DT |
MONTH |
TBS_BASE |
|
DWB_PRTY_PRMTN_RESPN |
RANGE |
RESPN_DT |
MONTH |
TBS_BASE |
|
DWB_PRTY_STAT_HIST |
RANGE |
EFF_FROM_DT |
MONTH |
TBS_BASE |
|
DWB_PTV_FULL_CHNL_ACTVTN |
RANGE |
EVT_BEGIN_DT |
MONTH |
TBS_BASE |
|
DWB_PTV_QPI_SRVC_EVT |
RANGE |
EVT_BEGIN_DT |
MONTH |
TBS_BASE |
|
DWB_PTV_USG_EVT |
RANGE |
EVT_BEGIN_DT |
MONTH |
TBS_BASE |
|
DWB_RAW_MMS_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_RSCE_COST |
RANGE |
INCURR_DT |
MONTH |
TBS_BASE |
|
DWB_RSCE_HIST |
RANGE |
EFF_BEGIN_DT |
MONTH |
TBS_BASE |
|
DWB_RSCE_ORDR |
RANGE |
STRT_DT |
QUARTER |
TBS_BASE |
|
DWB_RTD_UDR_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_RTL_SL_RTRN_LI |
RANGE |
DAY_KEY |
MONTH |
TBS_BASE |
|
DWB_RTL_TNDR_LI |
RANGE |
DAY_KEY |
MONTH |
TBS_BASE |
|
DWB_RTL_TRX |
RANGE |
DAY_KEY |
MONTH |
TBS_BASE |
|
DWB_SBRP_TERM_VAL |
RANGE |
TERM_PRD_STRT_DT |
MONTH |
TBS_BASE |
|
DWB_SL_CMISN_DTL |
RANGE |
PYMT_DT |
MONTH |
TBS_BASE |
|
DWB_SL_CMISN_PYRL |
RANGE |
PAY_DT |
MONTH |
TBS_BASE |
|
DWB_SMS_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_SRVC_LVL_AGRMNT_VILTN |
RANGE |
INTRACN_THRD_STRT_DT |
MONTH |
TBS_BASE |
|
DWB_SRVC_ORDR |
RANGE |
STRT_DT |
QUARTER |
TBS_BASE |
|
DWB_SRVC_RQST |
RANGE |
INTRACN_THRD_STRT_DT |
MONTH |
TBS_BASE |
|
DWB_TAP_IN_WRLS_RMNG_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_TAP_OUT_WRLS_RMNG_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_TNDR_CNTRL_TRX |
RANGE |
DAY_KEY |
MONTH |
TBS_BASE |
|
DWB_TRBLE_TCKT |
RANGE |
STRT_DT |
QUARTER |
TBS_BASE |
|
DWB_UDR_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_UDR_EVT_ASGN |
RANGE |
FROM_EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_UMS_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_UNIT_ALWNCE |
RANGE |
BAL_DT |
MONTH |
TBS_BASE |
|
DWB_VNDR_APNMNT |
RANGE |
VNDR_APNMNT_DT |
MONTH |
TBS_BASE |
|
DWB_VOIP_CALL_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_WRLS_CALL_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWB_WRLS_CNTNT_DNLDG_EVT |
RANGE |
EVT_BEGIN_DT |
MONTH |
TBS_BASE |
|
DWB_WRLS_RMNG_EVT |
RANGE |
EVT_BEGIN_DT |
DAY |
TBS_BASE |
|
DWD_ACCT_BAL_MO |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_ACCT_DEBT_MO |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_ACCT_PYMT_DAY |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_ACCT_PYMT_MTHD_STAT_HIST |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_AGRMNT |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_AGRMNT_CHNG |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_AGRMNT_RVN_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_BER_FER_ERR_RATIO_DAY |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_CANBLZTN_DTL_DAY |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_CELL_STTSTC_DAY |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_CMISN |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_CMPGN_HIST_DAY |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_CNTCT_CNTR_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_CNT_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_COST_CNTR |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_CUST_COST |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_CUST_DNA |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_CUST_EQPMNT_INSTLTN_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_CUST_ORDR_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_CUST_ORDR_LN_ITEM_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_CUST_RFMP_SCR |
RANGE |
MO_KEY |
DAY |
TBS_DERIVED |
|
DWD_CUST_SKU_SL_RETRN_DAY |
RANGE |
DAY_KEY |
MONTH |
TBS_DERIVED |
|
DWD_DATA_USG_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_GIVE_AWAY_ITEM_DAY |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_INVC_AGNG_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_INVC_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_INV_ADJ_ITEM_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_INV_POSN_ITEM_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_INV_RCPT_ITEM_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_INV_UNAVL_ITEM_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_INV_VNDR_CMPLNC_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_INV_XFER_ITEM_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_IN_PLTFRM_DAY |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_LYLTY_MBR_PNT_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_MKT_SHARE |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_MSC_TRFC_DAY |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_NBR_PRT_DAY |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_NTWK_AVLBLTY_DAY |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_NTWK_TCHPNT |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_ORG_BSNS_UNT_HRS_DAY |
RANGE |
DAY_KEY |
MONTH |
TBS_DERIVED |
|
DWD_POS_TNDR_FLOW |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_PRCS_INVC_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_PRPD_ACCT_STTSTC_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_PRPD_ALWNCE_DAY |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_PRTNR_STLMNT |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_RF_NTWK_CPCTY_DAY |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_RTL_SL_RETRN_ITEM_DAY |
RANGE |
DAY_KEY |
MONTH |
TBS_DERIVED |
|
DWD_RVN_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_SL_RPRSTV_STTSTC |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_SPLMNTR_SRVC_USG |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_SRVC_PRBLM_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_STORE_EFFNCY_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_VAS_SBRP_QCK_SUMM |
RANGE |
MO_KEY |
MONTH |
TBS_DERIVED |
|
DWD_VAS_USG_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWD_VOI_CALL_DAY |
RANGE |
DAY_KEY |
DAY |
TBS_DERIVED |
|
DWR_ACCS_MTHD |
HASH |
ACCS_MTHD_KEY |
N/A |
TBS_REFERENCE |
|
DWR_ACCT |
HASH |
ACCT_KEY |
N/A |
TBS_REFERENCE |
|
DWR_AGRMNT |
HASH |
AGRMNT_KEY |
N/A |
TBS_REFERENCE |
|
DWR_CUST |
HASH |
CUST_KEY |
N/A |
TBS_REFERENCE |
|
DWR_ORG_BSNS_UNIT |
HASH |
ORG_BSNS_UNIT_KEY |
N/A |
TBS_REFERENCE |