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

This chapter includes the following section:

Table 5-1 shows the partitioning strategy for the Oracle Retail Data Model physical base, derived, and aggregate tables.

Table 5-1 Physical Data Model Partitioning

Physical Table Name | Partition Type | Partition Key Column | Partition Level | Default Tablespace Name |
---|---|---|---|---|

DWA_ACCT_PAYBL_MO |
INTERVAL |
MO_KEY |
MONTH |
DW_AGGREGATE_TBS |

DWA_ACCT_RCVBL_MO |
INTERVAL |
MO_KEY |
MONTH |
DW_AGGREGATE_TBS |

DWA_ACTVTY_RQST_MO |
INTERVAL |
MO_KEY |
MONTH |
DW_AGGREGATE_TBS |

DWA_ASSTS_MO |
INTERVAL |
MO_KEY |
MONTH |
DW_AGGREGATE_TBS |

DWA_CARRIER_CMPLNC_WK |
INTERVAL |
WK_KEY |
WEEK |
DW_AGGREGATE_TBS |

DWA_COST_MO |
INTERVAL |
MO_KEY |
MONTH |
DW_AGGREGATE_TBS |

DWA_CRTFCT_ACTVTY_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_AGGREGATE_TBS |

DWA_CUST_EMP_RLTNSHP_MO |
INTERVAL |
MO_KEY |
MONTH |
DW_AGGREGATE_TBS |

DWA_CUST_EMP_SL_RETRN_MO |
INTERVAL |
MO_KEY |
MONTH |
DW_AGGREGATE_TBS |

DWA_CUST_TYP_ORDR_DEPT_MO |
INTERVAL |
MO_KEY |
MONTH |
DW_AGGREGATE_TBS |

DWA_CUST_TYP_ORDR_SBC_WK |
INTERVAL |
WK_KEY |
WEEK |
DW_AGGREGATE_TBS |

DWA_INV_POSN_DEPT_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_AGGREGATE_TBS |

DWA_INV_POSN_SBC_MO |
INTERVAL |
MO_KEY |
MONTH |
DW_AGGREGATE_TBS |

DWA_INV_RCPT_SBC_WK |
INTERVAL |
WK_KEY |
WEEK |
DW_AGGREGATE_TBS |

DWA_LIAB_MO |
INTERVAL |
MO_KEY |
MONTH |
DW_AGGREGATE_TBS |

DWA_PCHSE_ORDR_DEPT_MO |
INTERVAL |
MO_KEY |
MONTH |
DW_AGGREGATE_TBS |

DWA_PCHSE_ORDR_LI_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_AGGREGATE_TBS |

DWA_PCHSE_ORDR_LI_MO |
INTERVAL |
MO_KEY |
MONTH |
DW_AGGREGATE_TBS |

DWA_PCHSE_ORDR_SBC_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_AGGREGATE_TBS |

DWA_POS_RTL_EMP_MO |
INTERVAL |
MO_KEY |
MONTH |
DW_AGGREGATE_TBS |

DWA_RTL_SL_RETRN_DEPT_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_AGGREGATE_TBS |

DWA_RTL_SL_RETRN_SBC_MO |
INTERVAL |
MO_KEY |
MONTH |
DW_AGGREGATE_TBS |

DWA_RTV_DEPT_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_AGGREGATE_TBS |

DWA_RTV_SBC_MO |
INTERVAL |
MO_KEY |
MONTH |
DW_AGGREGATE_TBS |

DWA_ACCT_PAYBL_MO |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_AGGREGATE_TBS |

DWA_ACCT_RCVBL_MO |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_AGGREGATE_TBS |

DWA_ASSTS_MO |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_AGGREGATE_TBS |

DWA_CARRIER_CMPLNC_WK |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_AGGREGATE_TBS |

DWA_CRTFCT_ACTVTY_DAY |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_AGGREGATE_TBS |

DWA_CUST_EMP_RLTNSHP_MO |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_AGGREGATE_TBS |

DWA_CUST_EMP_SL_RETRN_MO |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_AGGREGATE_TBS |

DWA_CUST_TYP_ORDR_DEPT_MO |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_AGGREGATE_TBS |

DWA_CUST_TYP_ORDR_SBC_WK |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_AGGREGATE_TBS |

DWA_INV_POSN_DEPT_DAY |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_AGGREGATE_TBS |

DWA_INV_POSN_SBC_MO |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_AGGREGATE_TBS |

DWA_INV_RCPT_SBC_WK |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_AGGREGATE_TBS |

DWA_RTL_SL_RETRN_DEPT_DAY |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_AGGREGATE_TBS |

DWA_RTL_SL_RETRN_SBC_MO |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_AGGREGATE_TBS |

DWA_RTV_DEPT_DAY |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_AGGREGATE_TBS |

DWA_RTV_SBC_MO |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_AGGREGATE_TBS |

DWB_BUMP_BR_EQPMNT_STSTCS_RDNG |
INTERVAL |
BEGIN_TIME |
HALF YEAR |
DW_BASE_TBS |

DWB_CNTRL_TRX |
INTERVAL |
BEGIN_DT |
MONTH |
DW_BASE_TBS |

DWB_COST |
INTERVAL |
STRT_DT |
MONTH |
DW_BASE_TBS |

DWB_COST_VALTN_LDGR_ACCT_HIST |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_CRTFCT_ESCHTD_DAY |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_CRTFCT_LI |
INTERVAL |
BEGIN_TIME |
MONTH |
DW_BASE_TBS |

DWB_CS_DRWR_EQPMNT_STSTCS_RDNG |
INTERVAL |
BEGIN_TIME |
HALF YEAR |
DW_BASE_TBS |

DWB_CUST_INFO_LI |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_CUST_INVC |
INTERVAL |
ISUD_DT |
MONTH |
DW_BASE_TBS |

DWB_CUST_INVC_ITEM |
INTERVAL |
ISUD_DT |
MONTH |
DW_BASE_TBS |

DWB_CUST_ORDR |
INTERVAL |
ORGNL_ORDR_DT |
MONTH |
DW_BASE_TBS |

DWB_CUST_ORDR_CNTRL_TRX |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_CUST_ORDR_CNTRL_TRX_LI |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_CUST_ORDR_LI |
INTERVAL |
ORGNL_ORDR_DT |
MONTH |
DW_BASE_TBS |

DWB_CUST_ORDR_LI_STATE |
INTERVAL |
ORDR_LI_STATE_BEGIN_DT |
MONTH |
DW_BASE_TBS |

DWB_CUST_ORDR_STATE |
INTERVAL |
ORDR_STATE_BEGIN_DT |
MONTH |
DW_BASE_TBS |

DWB_CUST_PYMT |
INTERVAL |
PYMT_DT |
MONTH |
DW_BASE_TBS |

DWB_CUST_RNTL_ACCT_HIST |
INTERVAL |
BEGIN_DT |
MONTH |
DW_BASE_TBS |

DWB_DEAL_VNDR_ITEM_ASGN |
HASH |
SKU_ITEM_KEY |
SKU ITEM KEY |
DW_BASE_TBS |

DWB_DEAL_VNDR_ITEM_COST_BRK |
HASH |
SKU_ITEM_KEY |
SKU ITEM KEY |
DW_BASE_TBS |

DWB_DISC_LI |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_DPST_RDMPTN_LI |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_DVC_EVT |
INTERVAL |
ACT_STRT_DT |
MONTH |
DW_BASE_TBS |

DWB_EMP_ACT_LBR_HRLY |
INTERVAL |
ACT_BEGIN_DT |
MONTH |
DW_BASE_TBS |

DWB_EMP_ACT_LBR_SAL |
INTERVAL |
ACT_BEGIN_DT |
MONTH |
DW_BASE_TBS |

DWB_EMP_DISC_SL_HIST |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_EMP_TIME_ACCRUAL_HIST |
INTERVAL |
BEGIN_DT_TIME |
MONTH |
DW_BASE_TBS |

DWB_EMP_TIME_PUNCH_ENTRY |
INTERVAL |
TIME_PUNCH_TIME |
MONTH |
DW_BASE_TBS |

DWB_EVT |
INTERVAL |
ACT_STRT_DT |
MONTH |
DW_BASE_TBS |

DWB_EVT_PRTY_INTRACN_PRTCPTN |
INTERVAL |
PRTCPTN_STRT_DT |
MONTH |
DW_BASE_TBS |

DWB_FCL_PTR_EQPMNT_STSTCS_RDNG |
INTERVAL |
BEGIN_TIME |
MONTH |
DW_BASE_TBS |

DWB_FLEET_MGMT |
INTERVAL |
EFF_FROM_DT |
MONTH |
DW_BASE_TBS |

DWB_FLFLMNT_ACKNLGMNT_LI |
INTERVAL |
BEGIN_TIME |
MONTH |
DW_BASE_TBS |

DWB_FOOD_SRVC_TRX |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_FORECOURT_TRX |
INTERVAL |
BEGIN_TIME |
DAY |
DW_BASE_TBS |

DWB_FRCST_ITEM_ORG_HRCHY_WK |
INTERVAL |
WK_KEY |
100 WEEKS |
DW_BASE_TBS |

DWB_FRGHT_DOC |
INTERVAL |
STORE_RCPT_TIME |
HALF YEAR |
DW_BASE_TBS |

DWB_FUELING_TRX |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_GL_JRNL_ENTRY |
INTERVAL |
ACCT_DT |
MONTH |
DW_BASE_TBS |

DWB_GL_JRNL_ENTRY_BTCH |
INTERVAL |
ACCT_DT |
HALF YEAR |
DW_BASE_TBS |

DWB_GL_JRNL_ENTRY_LN |
INTERVAL |
ACCT_DT |
MONTH |
DW_BASE_TBS |

DWB_GL_SBLDGR_JRNL_ENTRY |
INTERVAL |
ACCT_DT |
MONTH |
DW_BASE_TBS |

DWB_GL_SBLDGR_JRNL_ENTRY_LN |
INTERVAL |
ACCT_DT |
MONTH |
DW_BASE_TBS |

DWB_ICD_LI_ASGN |
INTERVAL |
EFF_FROM_DT |
MONTH |
DW_BASE_TBS |

DWB_INTRACN_TRNSFR_HIST |
INTERVAL |
TRNSFR_DT |
MONTH |
DW_BASE_TBS |

DWB_INV_ADJ_DOC |
INTERVAL |
INV_ADJ_DOC_DT |
MONTH |
DW_BASE_TBS |

DWB_INV_ADJ_DOC_LI |
INTERVAL |
INV_ADJ_DOC_DT |
MONTH |
DW_BASE_TBS |

DWB_INV_CNTRL_DOC |
INTERVAL |
INV_CNTRL_DOC_DT |
MONTH |
DW_BASE_TBS |

DWB_INV_CNTRL_DOC_ASGN |
INTERVAL |
EFF_FROM_DT |
MONTH |
DW_BASE_TBS |

DWB_INV_CNTRL_DOC_LI |
INTERVAL |
INV_CNTRL_DOC_DT |
MONTH |
DW_BASE_TBS |

DWB_INV_ITEM_STATE |
INTERVAL |
EFF_FROM_DT |
DAY |
DW_BASE_TBS |

DWB_INV_SPACE_ALCTN |
INTERVAL |
ALCTN_DT |
HALF YEAR |
DW_BASE_TBS |

DWB_ITEM_INV_JRNL_ENTRY |
INTERVAL |
EFF_FROM_DT |
MONTH |
DW_BASE_TBS |

DWB_KEY_LCK_EQPMNT_STSTCS_RDNG |
INTERVAL |
BEGIN_TIME |
MONTH |
DW_BASE_TBS |

DWB_LN_DSPL_EQPMNT_STSTCS_RDNG |
INTERVAL |
BEGIN_TIME |
MONTH |
DW_BASE_TBS |

DWB_LYLTY_RWRD_LI |
INTERVAL |
BEGIN_TIME |
MONTH |
DW_BASE_TBS |

DWB_MICR_EQPMNT_STTSTCS_RDNG |
INTERVAL |
BEGIN_TIME |
MONTH |
DW_BASE_TBS |

DWB_MISCLNS_FEE_LI |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_MISS_SCHL |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_MKT_SLS_ITEM_LVL_WK |
INTERVAL |
WK_KEY |
100 WEEKS |
DW_BASE_TBS |

DWB_MNFCTR_INV_ITEM_STATE |
INTERVAL |
INV_STATE_DT |
MONTH |
DW_BASE_TBS |

DWB_MNFCTR_SKU_IM_SLNG_PRC_HST |
INTERVAL |
CURR_SL_URP_EFF_DT |
HALF YEAR |
DW_BASE_TBS |

DWB_MTN_SNSR_EQPMT_STSTCS_RDNG |
INTERVAL |
BEGIN_TIME |
MONTH |
DW_BASE_TBS |

DWB_NOZZLE_HIST |
INTERVAL |
STRT_TIME |
MONTH |
DW_BASE_TBS |

DWB_ORDR |
INTERVAL |
ORGNL_ORDR_DT |
MONTH |
DW_BASE_TBS |

DWB_ORDR_LI |
INTERVAL |
ORGNL_ORDR_DT |
MONTH |
DW_BASE_TBS |

DWB_ORDR_LI_STATE |
INTERVAL |
ORDR_LI_STATE_BEGIN_DT |
HALF YEAR |
DW_BASE_TBS |

DWB_ORG_BSNS_UNIT_TRFC |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_ORG_BSNS_UNIT_TRFC |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_BASE_TBS |

DWB_PAYBL_INVC |
INTERVAL |
ISUD_DT |
MONTH |
DW_BASE_TBS |

DWB_PAYBL_INVC_ITEM |
INTERVAL |
ISUD_DT |
MONTH |
DW_BASE_TBS |

DWB_PAY_DTL |
INTERVAL |
PYMT_DT |
HALF YEAR |
DW_BASE_TBS |

DWB_PCHSE_ORDR |
INTERVAL |
ORGNL_ORDR_DT |
MONTH |
DW_BASE_TBS |

DWB_PCHSE_ORDR_LI |
INTERVAL |
ORGNL_ORDR_DT |
MONTH |
DW_BASE_TBS |

DWB_PCHSE_ORDR_LI_STATE |
INTERVAL |
ORGNL_ORDR_DT |
MONTH |
DW_BASE_TBS |

DWB_PCHSE_ORDR_STATE |
INTERVAL |
ORGNL_ORDR_DT |
MONTH |
DW_BASE_TBS |

DWB_PHY_CNT_DOC |
INTERVAL |
PHY_CNT_BEGIN_DT |
YEAR |
DW_BASE_TBS |

DWB_PHY_CNT_DOC_LI |
INTERVAL |
PHY_CNT_BEGIN_DT |
YEAR |
DW_BASE_TBS |

DWB_PINPAD_EQPMNT_STTSTCS_RDNG |
INTERVAL |
BEGIN_TIME |
MONTH |
DW_BASE_TBS |

DWB_POS_KEYBD_EQPMT_STSTS_RDNG |
INTERVAL |
BEGIN_TIME |
MONTH |
DW_BASE_TBS |

DWB_POS_PRNTR_EQPMT_STSTS_RDNG |
INTERVAL |
BEGIN_TIME |
MONTH |
DW_BASE_TBS |

DWB_PRICE_LN |
INTERVAL |
BEGIN_DT |
YEAR |
DW_BASE_TBS |

DWB_PRICE_MODIFICATION_LI |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_PRMTN_HIST |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_PRMTN_MEDIA_COST |
INTERVAL |
WK_KEY |
100 WEEKS |
DW_BASE_TBS |

DWB_PRTY_INTRACN_CALL_EVT |
INTERVAL |
INTRACN_STRT_DT |
MONTH |
DW_BASE_TBS |

DWB_PRTY_INTRACN_EML_EVT |
INTERVAL |
INTRACN_STRT_DT |
MONTH |
DW_BASE_TBS |

DWB_PRTY_INTRACN_LTTR_EVT |
INTERVAL |
INTRACN_STRT_DT |
MONTH |
DW_BASE_TBS |

DWB_PRTY_INTRACN_THRD |
INTERVAL |
INTRACN_THRD_STRT_DT |
MONTH |
DW_BASE_TBS |

DWB_PRTY_INTRACN_THRD_EVT_ASGN |
INTERVAL |
EFF_FROM_DT |
MONTH |
DW_BASE_TBS |

DWB_PRTY_INTRACN_VST_EVT |
INTERVAL |
INTRACN_STRT_DT |
MONTH |
DW_BASE_TBS |

DWB_PRTY_INTRCN_THRD_STAT_HIST |
INTERVAL |
EFF_FROM_DT |
MONTH |
DW_BASE_TBS |

DWB_PRTY_STAT_HIST |
INTERVAL |
EFF_FROM_DT |
HALF YEAR |
DW_BASE_TBS |

DWB_PYMT_ON_ACCT_LI |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_RESERVATION |
INTERVAL |
RESERVATION_TIME |
MONTH |
DW_BASE_TBS |

DWB_RNDNG_LI |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_RTLR_PYMT |
INTERVAL |
PYMT_DT |
MONTH |
DW_BASE_TBS |

DWB_RTL_SL_RTRN_LI |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_RTL_SL_RTRN_LI |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_BASE_TBS |

DWB_RTL_TNDR_LI |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_RTL_TRX |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_RTL_TRX |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_BASE_TBS |

DWB_RTL_TRX_ASSOCT_ASGN |
INTERVAL |
EFF_FROM_DT |
DAY |
DW_BASE_TBS |

DWB_RTL_TRX_LI |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_RTL_TRX_LI |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_BASE_TBS |

DWB_RTL_TRX_LI_ASGN |
INTERVAL |
EFF_FROM_DT |
MONTH |
DW_BASE_TBS |

DWB_RTL_TRX_LI_GRP |
INTERVAL |
EFF_FROM_DT |
DAY |
DW_BASE_TBS |

DWB_RTL_TRX_MISC_LI |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_RTL_TRX_SHPMNT |
INTERVAL |
ACT_SHIP_DT |
MONTH |
DW_BASE_TBS |

DWB_RTL_TRX_SHPMNT_ITEM |
INTERVAL |
ACT_SHIP_DT |
MONTH |
DW_BASE_TBS |

DWB_RTL_VALTN_LDGR_ACCT_HIST |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_SCHL_EVT |
INTERVAL |
ACT_STRT_DT |
MONTH |
DW_BASE_TBS |

DWB_SCL_EQPMNT_STTSTCS_RDNG |
INTERVAL |
BEGIN_TIME |
MONTH |
DW_BASE_TBS |

DWB_SCNR_EQPMNT_STTSTCS_RDNG |
INTERVAL |
BEGIN_TIME |
MONTH |
DW_BASE_TBS |

DWB_SERVER_STAT_HIST |
INTERVAL |
EFF_FROM_DT |
QUARTER |
DW_BASE_TBS |

DWB_SGNTR_EQMT_CPTR_STSTS_RDNG |
INTERVAL |
BEGIN_TIME |
MONTH |
DW_BASE_TBS |

DWB_SKU_ITEM_BU_SLNG_PRC |
INTERVAL |
EFF_DT |
MONTH |
DW_BASE_TBS |

DWB_SKU_ITEM_SLNG_PRICE |
INTERVAL |
CURR_SL_URP_EFF_DT |
MONTH |
DW_BASE_TBS |

DWB_SKU_ITEM_SLNG_PRICE_HIST |
INTERVAL |
CURR_SL_URP_EFF_DT |
MONTH |
DW_BASE_TBS |

DWB_SL_METER_RDNG |
INTERVAL |
BEGIN_DT |
MONTH |
DW_BASE_TBS |

DWB_SL_PLAN_ITEM_ORG_HRCHY_WK |
INTERVAL |
WK_KEY |
100 WEEKS |
DW_BASE_TBS |

DWB_SL_RETRN_TAX_OVRRD_MDFR |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_SL_RETRN_TAX_OVRRD_MDFR |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_BASE_TBS |

DWB_STCK_LDGR_ACCT_HIST |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_STCK_LDGR_JRNL_ENTRY |
INTERVAL |
EFF_FROM_DT |
MONTH |
DW_BASE_TBS |

DWB_STCK_METER_RDNG |
INTERVAL |
BEGIN_DT |
MONTH |
DW_BASE_TBS |

DWB_SURVEY_RESPN_DTL |
INTERVAL |
SURVEY_DT |
HALF YEAR |
DW_BASE_TBS |

DWB_SURVEY_RESPN_HDR |
INTERVAL |
SURVEY_DT |
HALF YEAR |
DW_BASE_TBS |

DWB_TANK_RDNG |
INTERVAL |
BEGIN_DT |
MONTH |
DW_BASE_TBS |

DWB_TANK_TEMP_RDNG |
INTERVAL |
BEGIN_DT |
MONTH |
DW_BASE_TBS |

DWB_TAX_LI |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_TILL_HIST |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_TILL_TAX_HIST |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_TILL_TNDR_HIST |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_TNDR_ATHRZTN |
INTERVAL |
ATHRZTN_DT |
MONTH |
DW_BASE_TBS |

DWB_TNDR_ATHRZTN_REVERSAL |
INTERVAL |
REVERSAL_DT |
MONTH |
DW_BASE_TBS |

DWB_TNDR_CNTRL_TRX |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_TNDR_CNTRL_TRX_TNDR_LI |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_TNDR_LI_DENMTN |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_TONE_IND_EQPMT_STSTCS_RDNG |
INTERVAL |
BEGIN_TIME |
MONTH |
DW_BASE_TBS |

DWB_TRX_ASGN |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_TRX_ASGN |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_BASE_TBS |

DWB_VNDR_SKU_COST_DAY |
INTERVAL |
DAY_KEY |
100 DAYS |
DW_BASE_TBS |

DWB_VNDR_STAT |
INTERVAL |
EFF_FROM_DT |
MONTH |
DW_BASE_TBS |

DWB_VOID_LI |
INTERVAL |
BEGIN_DT |
MONTH |
DW_BASE_TBS |

DWD_ACCT_PAYBL_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_ACCT_RCVBL_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_ACTVTY_RQST_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_ASSTS_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_CARRIER_CMPLNC_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_COST_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_CRTFCT_ACTVTY_TRX |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_CUST_EMP_RLTNSHP_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_CUST_RFMP_SCR |
INTERVAL |
MO_KEY |
100 MONTHS |
DW_DERIVED_TBS |

DWD_CUST_SKU_SL_RETRN_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_CUST_TYP_ORDR_ITEM_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_EMP_WG_PYMT_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_INV_ADJ_ITEM_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_INV_POSN_ITEM_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_INV_RCPT_ITEM_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_INV_UNAVL_ITEM_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_INV_VNDR_CMPLNC_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_INV_XFER_ITEM_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_LIAB_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_ORG_BSNS_UNT_HRS_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_ORG_BSNS_UNT_TRFC_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_PCHSE_ORDR_LI_STATE |
INTERVAL |
ORGNL_ORDR_DT |
MONTH |
DW_DERIVED_TBS |

DWD_PCHSE_ORDR_STATE |
INTERVAL |
ORGNL_ORDR_DT |
MONTH |
DW_DERIVED_TBS |

DWD_POS_CNTRL |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_POS_RTL |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_POS_STORE_FINCL |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_POS_TNDR_FLOW |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_RTL_SL_RETRN_ITEM_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_RTL_TRX_EMP_WRKSTN_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_RTV_ITEM_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_SPACE_UTLZTN_ITEM_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_TILL |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |

DWD_TILL |
HASH |
ORG_BSNS_UNIT_KEY |
BUSINESS UNIT KEY |
DW_DERIVED_TBS |

DWD_VNDR_CMPLNC_ITEM_DAY |
INTERVAL |
DAY_KEY |
DAY |
DW_DERIVED_TBS |