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 |