Skip Headers
Oracle® Communications Data Model Reference
Release 11.3.2

E28440-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

6 Oracle Communications Data Model Partitioning

This chapter provides the partitioning strategy for the Oracle Communications Data Model physical base, derived, and aggregate tables.

This chapter includes the following section:

About Oracle Communications Data Model Partitioning, Compression, and Parallelism

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.

Partitioning Strategy for Oracle Communications Data Model

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