Skip Headers
Oracle® Retail Data Model Reference
Release 11.3.2

Part Number E20361-02
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

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