Oracle® Communications Data Model Reference Release 11.3.1 Part Number 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 |