| Oracle® Communications Data Model Reference Release 11.3.1 E28440-03 | 
 | 
| 
 | PDF · Mobi · ePub | 
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 | Partition Key Column | Partition Level | Default Tablespace Name | 
|---|---|---|---|
| DWA_ACCT_DEBT_MO | DT | Quarter | TBS_MV | 
| DWA_ACCT_PYMT_MO | DT | Quarter | TBS_MV | 
| DWA_ACCT_PYMT_MTHD_STAT_HIST | DT | Quarter | TBS_MV | 
| DWA_ACCT_RFND_MO | DT | Quarter | TBS_MV | 
| DWA_ACCT_STAT_TYP | DT | Quarter | TBS_MV | 
| DWA_ACCT_STTSTC_TYP | DT | Quarter | TBS_MV | 
| DWA_ARPU_BASE_CUST_TYP | DT | Quarter | TBS_MV | 
| DWA_BER_FER_ERR_RATIO_MO | DT | Quarter | TBS_MV | 
| DWA_CALL_CNTR_CALL_MO | DT | Quarter | TBS_MV | 
| DWA_CALL_CNTR_CASE_MO | DT | Quarter | TBS_MV | 
| DWA_CANBLZTN_DTL_MO | DT | Quarter | TBS_MV | 
| DWA_CELL_STTSTC_MO | DT | Quarter | TBS_MV | 
| DWA_CMISN_MO | DT | Quarter | TBS_MV | 
| DWA_CNCT_DSCNCT_MO | DT | Quarter | TBS_MV | 
| DWA_CNRT_MO | DT | Quarter | TBS_MV | 
| DWA_COST_CUST_MO | DT | Quarter | TBS_MV | 
| DWA_COST_ORG_MO | DT | Quarter | TBS_MV | 
| DWA_CRDT_CTGRY_MO | DT | Quarter | TBS_MV | 
| DWA_CUST_ACQSTN_SUMM_MO | DT | Quarter | TBS_MV | 
| DWA_CUST_DEBT_COLLCTN_MO | DT | Quarter | TBS_MV | 
| DWA_CUST_EQPMNT_INSTLTN_MO | DT | Quarter | TBS_MV | 
| DWA_DATA_USG_MO | DT | Quarter | TBS_MV | 
| DWA_EXTRNL_DEBT_COLLCTN_MO | DT | Quarter | TBS_MV | 
| DWA_GIVE_AWAY_ITEM_MO | DT | Quarter | TBS_MV | 
| DWA_GPRS_PCU_MO | DT | Quarter | TBS_MV | 
| DWA_GPRS_SRVCS_MO | DT | Quarter | TBS_MV | 
| DWA_HNDST_STCK_MO | DT | Quarter | TBS_MV | 
| DWA_HNDST_SUBSDY_MO | DT | Quarter | TBS_MV | 
| DWA_INTRNL_DEBT_COLLCTN_MO | DT | Quarter | TBS_MV | 
| DWA_INVC_ADJ_MO | DT | Quarter | TBS_MV | 
| DWA_INVC_CUST_TYP | DT | Quarter | TBS_MV | 
| DWA_IN_PLTFRM_MO | DT | Quarter | TBS_MV | 
| DWA_LN_ACTVTN_TMNT_MO | DT | Quarter | TBS_MV | 
| DWA_LYLTY_PROG_MO | DT | Quarter | TBS_MV | 
| DWA_MKT_SHARE | DT | Quarter | TBS_MV | 
| DWA_MSC_TRFC_MO | DT | Quarter | TBS_MV | 
| DWA_NBR_PRT_MO | DT | Quarter | TBS_MV | 
| DWA_NTWK_AVLBLTY_MO | DT | Quarter | TBS_MV | 
| DWA_NTWK_TCHPNT_MO | DT | Quarter | TBS_MV | 
| DWA_PRPD_ACCT_STTSTC_SGMNT | DT | Quarter | TBS_MV | 
| DWA_PRPD_ALWNCE_MO | DT | Quarter | TBS_MV | 
| DWA_PRPD_CALL_SUMM_MO | DT | Quarter | TBS_MV | 
| DWA_PRTNR_STLMNT_MO | DT | Quarter | TBS_MV | 
| DWA_PYMT_AGNG_MO | DT | Quarter | TBS_MV | 
| DWA_RDMPTN_MO | DT | Quarter | TBS_MV | 
| DWA_RF_NTWK_CPCTY_MO | DT | Quarter | TBS_MV | 
| DWA_SHARED_PKG_USG_STTSTC_MO | DT | Quarter | TBS_MV | 
| DWA_SHOP_EFFNCY_MO | DT | Quarter | TBS_MV | 
| DWA_SL_CMPGN_SUMM_MO | DT | Quarter | TBS_MV | 
| DWA_SL_MO | DT | Quarter | TBS_MV | 
| DWA_SPLMNTR_SRVC_USG_MO | DT | Quarter | TBS_MV | 
| DWA_SUBSDY_AMT_MO | DT | Quarter | TBS_MV | 
| DWA_VAS_SBRP_QCK_SUMM_MO | DT | Quarter | TBS_MV | 
| DWA_VAS_USG_MO | DT | Quarter | TBS_MV | 
| DWA_VOI_CALL_MO | DT | Quarter | TBS_MV | 
| DWB_ACCS_MTHD_PORT_HIST | ACT_CTVR_DT | MONTH | TBS_BASE | 
| DWB_ACCS_MTHD_STAT_HIST | EFF_FROM_DT | MONTH | TBS_BASE | 
| DWB_ACCT_BAL_HIST | BAL_DT | MONTH | TBS_BASE | 
| DWB_ACCT_COST | INCURR_DT | MONTH | TBS_BASE | 
| DWB_ACCT_CRDT_LMT | EFF_FROM_DT | MONTH | TBS_BASE | 
| DWB_ACCT_MNGMNT_HIST | ASGN_STRT_DT | MONTH | TBS_BASE | 
| DWB_ACCT_PMP_PRTCPTN_HIST | RLTN_STRT_DT | MONTH | TBS_BASE | 
| DWB_ACCT_PYMT | PYMT_DT | MONTH | TBS_BASE | 
| DWB_ACCT_PYMT_MTHD_STAT | EFF_FROM_DT | MONTH | TBS_BASE | 
| DWB_ACCT_RFND | PYMT_DT | MONTH | TBS_BASE | 
| DWB_ACCT_STAT_HIST | EFF_FROM_DT | MONTH | TBS_BASE | 
| DWB_APNMNT_CLNDR | DAY_KEY | DAY | TBS_BASE | 
| DWB_BLK_LST_HIST | EFF_FROM_DT | MONTH | TBS_BASE | 
| DWB_BRDBND_USG_EVT | EVT_BEGIN_DT | DAY | TBS_BASE | 
| DWB_BSNS_UNIT_COST | INCURR_DT | MONTH | TBS_BASE | 
| DWB_CELL_SITE_COST | INCURR_DT | MONTH | TBS_BASE | 
| DWB_CHNL_COST | INCURR_DT | MONTH | TBS_BASE | 
| DWB_CMPGN_COST | INCURR_DT | MONTH | TBS_BASE | 
| DWB_CMPGN_MSG_CRTVE | CRTN_DT | MONTH | TBS_BASE | 
| DWB_CNCT_LST_COST | INCURR_DT | MONTH | TBS_BASE | 
| DWB_CNRT_APRVL | CNRT_APRVL_DT | MONTH | TBS_BASE | 
| DWB_CNRT_STAT | EFF_FROM_DT | MONTH | TBS_BASE | 
| DWB_CNRT_TERM_VAL | TERM_PRD_STRT_DT | MONTH | TBS_BASE | 
| DWB_CNTNT_DLVRY_EVT | EVT_BEGIN_DT | DAY | TBS_BASE | 
| DWB_COST | INCURR_DT | MONTH | TBS_BASE | 
| DWB_COST_CNTR_BDGT | EFF_FROM_DT | MONTH | TBS_BASE | 
| DWB_CRCUT_RNTL | EFF_FROM_DT | MONTH | TBS_BASE | 
| DWB_CRCUT_TRFC | EFF_STRT_DT | MONTH | TBS_BASE | 
| DWB_CUST_COST | INCURR_DT | MONTH | TBS_BASE | 
| DWB_CUST_FLD_INSTLTN | FLD_ACTVTY_STRT_DT | MONTH | TBS_BASE | 
| DWB_CUST_FLD_SPPRT | FLD_ACTVTY_STRT_DT | MONTH | TBS_BASE | 
| DWB_CUST_FLD_SRVC_ACTVTY | FLD_ACTVTY_STRT_DT | MONTH | TBS_BASE | 
| DWB_CUST_FLD_SRVC_DTL | ACTN_DT | MONTH | TBS_BASE | 
| DWB_CUST_ORDR | ORGNL_ORDR_DT | MONTH | TBS_BASE | 
| DWB_CUST_ORDR_LN_ITEM | ORGNL_ORDR_DT | MONTH | TBS_BASE | 
| DWB_CUST_ORDR_LN_ITEM_ST_ASGN | ORDR_LN_ITEM_STATE_BEGIN_DT | MONTH | TBS_BASE | 
| DWB_CUST_ORDR_PYMT | PYMT_DT | MONTH | TBS_BASE | 
| DWB_CUST_ORDR_STATE_ASGN | ORDR_STATE_BEGIN_DT | MONTH | TBS_BASE | 
| DWB_DATA_SRVC_EVT | EVT_BEGIN_DT | DAY | TBS_BASE | 
| DWB_DEBT_COLLCTN | INTRACN_THRD_STRT_DT | MONTH | TBS_BASE | 
| DWB_DEBT_COLLCTN_ASGN | ASGN_DT | MONTH | TBS_BASE | 
| DWB_DEBT_COLLCTN_ASGN_BTCH | ASGN_DT | MONTH | TBS_BASE | 
| DWB_EMP_ACT_LBR_HRLY | DAY_KEY | DAY | TBS_BASE | 
| DWB_EMP_ACT_LBR_SALARIED | DAY_KEY | DAY | TBS_BASE | 
| DWB_EMP_COST | INCURR_DT | MONTH | TBS_BASE | 
| DWB_EMP_TRNG_REC | TRNG_STRT_DT | MONTH | TBS_BASE | 
| DWB_EQPMNT_CNTR_COST | INCURR_DT | MONTH | TBS_BASE | 
| DWB_EQPMNT_INSTNC_STAT_HIST | EFF_BEGIN_DT | MONTH | TBS_BASE | 
| DWB_EVT | STRT_DT | DAY | TBS_BASE | 
| DWB_EVT_ACCS_MTHD_ACTVTY | STRT_DT | DAY | TBS_BASE | 
| DWB_EVT_ACCT | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_ASGN | EFF_FROM_DT | DAY | TBS_BASE | 
| DWB_EVT_COST | INCURR_DT | MONTH | TBS_BASE | 
| DWB_EVT_CRCUT_RNTL | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_EMP_PYRL | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_EQPMNT_INSTNC | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_FINCL | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_GEO | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_GFT_RDMPTN | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_INVC_DLVRY | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_LYLTY_PROG | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_LYLTY_PROG_ACMLTN | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_LYLTY_PROG_RDMPTN | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_PROD_PKG | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_PRPD_MBL | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_PRTY_ASGN | EFF_DT | DAY | TBS_BASE | 
| DWB_EVT_PRTY_INTRACN | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_PRTY_INTRACN_CALL | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_PRTY_INTRACN_EML | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_PRTY_INTRACN_LTTR | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_PRTY_INTRACN_VST | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_PRTY_PRFL | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_SBRP | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_SBRP_CHNG | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_SIM_CARD | STRT_DT | MONTH | TBS_BASE | 
| DWB_EVT_STAT | EFF_FROM_DT | DAY | TBS_BASE | 
| DWB_EVT_WEB_RGSTRN | STRT_DT | MONTH | TBS_BASE | 
| DWB_FIXED_LN_CALL_EVT | EVT_BEGIN_DT | DAY | TBS_BASE | 
| DWB_IDD_CALL_EVT | EVT_BEGIN_DT | MONTH | TBS_BASE | 
| DWB_INTRNT_ACCS_EVT | EVT_BEGIN_DT | MONTH | TBS_BASE | 
| DWB_INVC | BLLG_DT | MONTH | TBS_BASE | 
| DWB_INVC_ADJ | STRT_DT | MONTH | TBS_BASE | 
| DWB_INVC_DISC | BLLG_DT | MONTH | TBS_BASE | 
| DWB_INVC_ITEM | BLLG_DT | MONTH | TBS_BASE | 
| DWB_INVC_ITEM_DTL | BLLG_DT | MONTH | TBS_BASE | 
| DWB_INVC_PYMT_ASGN | EFF_FROM_DT | MONTH | TBS_BASE | 
| DWB_ISP_USG_EVT | EVT_BEGIN_DT | MONTH | TBS_BASE | 
| DWB_LYLTY_PROG_PTS_BAL | EFF_FROM_DT | MONTH | TBS_BASE | 
| DWB_MDTD_CALL_EVT | EVT_BEGIN_DT | DAY | TBS_BASE | 
| DWB_MEDIA_OBJ_COST | INCURR_DT | MONTH | TBS_BASE | 
| DWB_MKT_PLN_MGMT | MNG_ACTN_DT | MONTH | TBS_BASE | 
| DWB_MMS_EVT | EVT_BEGIN_DT | DAY | TBS_BASE | 
| DWB_MNT_ALLWNC | BAL_DT | MONTH | TBS_BASE | 
| DWB_NP_RQST_HDR | APLCTN_DT | MONTH | TBS_BASE | 
| DWB_NP_RQST_LN_ITEM | NP_STEP_STRT_DT | MONTH | TBS_BASE | 
| DWB_NP_RQST_LN_ITEM_STATE_HIST | EFF_FROM_DT | MONTH | TBS_BASE | 
| DWB_NP_RQST_STATE_HIST | EFF_FROM_DT | MONTH | TBS_BASE | 
| DWB_NTWK_ELMNT_COST | INCURR_DT | MONTH | TBS_BASE | 
| DWB_NTWK_EVT | EVT_BEGIN_DT | DAY | TBS_BASE | 
| DWB_NTWK_FLT | OPEN_DT | MONTH | TBS_BASE | 
| DWB_PRMTN_COST | INCURR_DT | MONTH | TBS_BASE | 
| DWB_PRMTN_MGMT_HIST | EFF_FROM_DT | MONTH | TBS_BASE | 
| DWB_PRMTN_TERM_VAL | TERM_PRD_STRT | MONTH | TBS_BASE | 
| DWB_PROD_COST | INCURR_DT | MONTH | TBS_BASE | 
| DWB_PROD_MKT_PLN_COST | INCURR_DT | MONTH | TBS_BASE | 
| DWB_PRPD_RCHRG | PYMT_DT | MONTH | TBS_BASE | 
| DWB_PRTY_AM_PMP_ASGN_HIST | ASGN_BEGIN_DT | MONTH | TBS_BASE | 
| DWB_PRTY_AM_PMP_ASGN_STAT | ASGN_BEGIN_DT | MONTH | TBS_BASE | 
| DWB_PRTY_INTRACN_THRD | INTRACN_THRD_STRT_DT | MONTH | TBS_BASE | 
| DWB_PRTY_ORDR_ASGN | EFF_FROM_DT | MONTH | TBS_BASE | 
| DWB_PRTY_PRMTN_RESPN | RESPN_DT | MONTH | TBS_BASE | 
| DWB_PRTY_STAT_HIST | EFF_FROM_DT | MONTH | TBS_BASE | 
| DWB_PTV_FULL_CHNL_ACTVTN | EVT_BEGIN_DT | MONTH | TBS_BASE | 
| DWB_PTV_QPI_SRVC_EVT | EVT_BEGIN_DT | MONTH | TBS_BASE | 
| DWB_PTV_USG_EVT | EVT_BEGIN_DT | MONTH | TBS_BASE | 
| DWB_SBRP_STAT_HIST | EFF_FROM_DT | MONTH | TBS_BASE | 
| DWB_SBRP_TERM_VAL | TERM_PRD_STRT_DT | MONTH | TBS_BASE | 
| DWB_SL_CMISN_DTL | EFF_FROM_DT | MONTH | TBS_BASE | 
| DWB_SL_CMISN_PYRL | PAY_DT | MONTH | TBS_BASE | 
| DWB_SMS_EVT | EVT_BEGIN_DT | DAY | TBS_BASE | 
| DWB_SRVC_RQST | INTRACN_THRD_STRT_DT | MONTH | TBS_BASE | 
| DWB_UMS_EVT | EVT_BEGIN_DT | DAY | TBS_BASE | 
| DWB_VNDR_APNMNT | VNDR_APNMNT_DT | MONTH | TBS_BASE | 
| DWB_VOIP_CALL_EVT | EVT_BEGIN_DT | DAY | TBS_BASE | 
| DWB_WRLS_CALL_EVT | EVT_BEGIN_DT | DAY | TBS_BASE | 
| DWB_WRLS_CNTNT_DNLDG_EVT | EVT_BEGIN_DT | MONTH | TBS_BASE | 
| DWD_ACCT_DEBT_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_ACCT_PYMT_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_ACCT_PYMT_MTHD_STAT_HIST | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_ACCT_RFND_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_ACCT_STAT | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_ACCT_STTSTC | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_ARPU_BASE | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_BER_FER_ERR_RATIO_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_CALL_CNTR_CALL_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_CALL_CNTR_CASE_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_CANBLZTN_DTL_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_CELL_STTSTC_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_CHRN_PRDCT_SRC | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_CMISN_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_CNCT_DSCNCT_DAY | DAY_KEY | DAY | TBS_DERIVED | 
| DWD_CNRT | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_CNRT_CHNG | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_COST_CUST | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_COST_ORG | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_CRDT_CTGRY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_CUST_ACQSTN_SUMM_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_CUST_DEBT_COLLCTN | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_CUST_EQPMNT_INSTLTN_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_DATA_USG_DAY | DAY_KEY | DAY | TBS_DERIVED | 
| DWD_EXTRNL_DEBT_COLLCTN_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_GIVE_AWAY_ITEM_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_GPRS_PCU_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_GPRS_SRVCS_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_HNDST_STCK_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_HNDST_SUBSDY_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_INTRNL_DEBT_COLLCTN_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_INVC | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_INVC_ADJ | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_IN_PLTFRM_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_LN_ACTVTN_TMNT_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_LYLTY_PROG_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_MKT_OPRTR_PRTNG | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_MKT_SHARE | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_MSC_TRFC_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_NBR_PRT_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_NTWK_AVLBLTY_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_NTWK_TCHPNT | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_PRPD_ACCT_STTSTC | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_PRPD_ALWNCE_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_PRPD_CALL_SUMM_DAY | DAY_KEY | DAY | TBS_DERIVED | 
| DWD_PRTNR_STLMNT | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_PYMT_AGNG_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_RDMPTN_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_RF_NTWK_CPCTY_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_SBCRBR_CHRN_STTSTC | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_SHARED_PKG_USG_STTSTC_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_SHOP_EFFNCY_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_SL_CMPGN_SUMM_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_SL_DAY | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_SL_RPRSTV_STTSTC | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_SPLMNTR_SRVC_USG | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_SUBSDY_AMT | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_VAS_SBRP_QCK_SUMM | MO_KEY | MONTH | TBS_DERIVED | 
| DWD_VAS_USG_DAY | DAY_KEY | DAY | TBS_DERIVED | 
| DWD_VOI_CALL_DAY | DAY_KEY | DAY | TBS_DERIVED |