../E20361-03.epub /> ../E20361-03.mobi />

5 Oracle Retail Data Model Partitioning

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

This chapter includes the following section:

Partitioning Strategy for Oracle Retail Data Model

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