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

3 Physical Data Model of Oracle Retail Data Model

This chapter provides information about the physical model of Oracle Retail Data Model. It contains the following topics:

Introduction to the Oracle Retail Data Model Physical Model

The physical data model of the Oracle Retail Data Model is the physical manifestation of the logical data model into database tables and relationships (or foreign key constraints). Partitions, indexes, and relational materialized views have been added to aid performance. The core physical data model for Oracle Retail Data Model is defined in the ordm_sys schema.

Additionally, Oracle Retail Data Model provides the following components:

Important:

Do not make changes to existing objects in the schema. Redefining or modifying the existing objects is not supported.

When examining the predefined physical model, keep in mind the naming convention using DW (Data Warehouse) prefixes and suffixes to identify the types of tables and views:

Suffix or Prefix Description
_VIEW Suffix specifies relational views of OLAP cubes, dimensions, or hierarchies.
CB$ Materialized view used to support/deliver required functionality for an Oracle OLAP cube. This is an internal object built and maintained automatically by the Oracle OLAP server in the database.

Note: Do not report or query against this object. Instead access the corresponding _VIEW object.

DWA_ Aggregate table or relational materialized view. This prefix is generalized for aggregate tables. Aggregate tables are implemented using either Materialized Views or tables.
DWB_ Base transaction data (3NF) tables
DWC_ Control and configuration tables
DWD_ Derived tables (including data mining result tables)
DWL_ Lookup table
DWR_ Reference data tables

Reference Tables

The Reference tables are briefly described in Table 3-1.

Table 3-1 Reference Tables

Table Name Description

DWR_ADDR_LOC

ADDRESS LOCATION

DWR_ADDR_PHONE

ADDRESS TELEPHONE

DWR_ADDR_RLTD

ADDRESS RELATED

DWR_ADVR_PERIOD

ADVERTISING PERIOD

DWR_ADVR_QTR

ADVERTISING QUARTER

DWR_ADVR_WK

ADVERTISING WEEK

DWR_ADVR_YR

ADVERTISING YEAR

DWR_AGE_RSTRCT_RULE

AGE RESTRICTION RULE

DWR_AGNT

AGENT

DWR_ALTVE_ITEM

ALTERNATIVE ITEM

DWR_ANLYS_DRTN

ANALYSIS DURATION

DWR_APPT_CALNDR

APPOINTMENT CALENDAR

DWR_BASE_DAY

BASE DAY

DWR_BNK

BANK

DWR_BRND

BRAND

DWR_BSNS_ENT_SLNG_RULE

BUSINESS ENTITY SELLING RULE

DWR_BSNS_ENT_TNDR_RSTRCT_RULE

BUSINESS ENTITY TENDER RESTRICTION RULE

DWR_BSNS_HLF_MO

BUSINESS HALF MONTH

DWR_BSNS_HLF_YR

BUSINESS HALF YEAR

DWR_BSNS_MO

BUSINESS MONTH

DWR_BSNS_QTR

BUSINESS QUARTER

DWR_BSNS_UNIT_CLNDR

BUSINESS UNIT CALENDAR

DWR_BSNS_UNIT_JB_RL

BUSINESS UNIT JOB ROLE

DWR_BSNS_UNIT_SHFT

BUSINESS UNIT SHIFT

DWR_BSNS_WK

BUSINESS WEEK

DWR_BSNS_YR

BUSINESS YEAR

DWR_CALL_CNTR

CALL CENTER

DWR_CALL_CNTR_AGNT

CALL CENTER AGENT

DWR_CALL_CNTR_CASE_TTL

CALL CENTER CASE TITLE

DWR_CARRIER

CARRIER

DWR_CLNDR

CALENDAR

DWR_CLNDR_HLF_MO

CALENDAR HALF MONTH

DWR_CLNDR_HLF_YR

CALENDAR HALF YEAR

DWR_CLNDR_MO

CALENDAR MONTH

DWR_CLNDR_QTR

CALENDAR QUARTER

DWR_CLNDR_WK

CALENDAR WEEK

DWR_CLNDR_YR

CALENDAR YEAR

DWR_CLNT

CLIENT

DWR_CLNT_HOST

CLIENT HOST

DWR_CLNT_VRSN

CLIENT VERSION

DWR_CMPGN

CAMPAIGN

DWR_CMPGN_CUST_ASGN

CAMPAIGN CUSTOMER ASSIGNMENT

DWR_CMPGN_EXEC_MSG

CAMPAIGN EXECUTION MESSAGE

DWR_CMPGN_MEDIA

CAMPAIGN MEDIA

DWR_CMPGN_MEDIA_LAUNCH

CAMPAIGN MEDIA LAUNCH

DWR_CMPGN_MEDIA_SLNG_ITEM

CAMPAIGN MEDIA SELLING ITEM

DWR_CMPGN_MSG_DPCT

CAMPAIGN MESSAGE DEPICTION

DWR_CMPGN_MSG_RNDRNG

CAMPAIGN MESSAGE RENDERING

DWR_CMPTR

COMPETITOR

DWR_CMPTR_LOC

COMPETITOR LOCATION

DWR_CMPTR_LOC_ASGN

COMPETITOR LOCATION ASSIGNMENT

DWR_CMPTR_MNFCTR_SKU_ITEM

COMPETITOR MANUFACTURER SKU ITEM

DWR_CMPTR_RTL_ITEM

COMPETITOR RETAIL ITEM

DWR_CNRT_STAT

CONTRACT STATUS

DWR_CNRT_TERM_VAL

CONTRACT TERM VALUE

DWR_COST_CNTR

COST CENTER

DWR_CRTFCT

CERTIFICATE

DWR_CRTFCT_AGE_BND

CERTIFICATE AGE BAND

DWR_CRTV

CREATIVES

DWR_CUST

CUSTOMER

DWR_CUST_ACCT

CUSTOMER ACCOUNT

DWR_CUST_ACCT_CARD

CUSTOMER ACCOUNT CARD

DWR_CUST_ACCT_CARD_ASGN

CUSTOMER ACCOUNT CARD ASSIGNMENT

DWR_CUST_ADDR

CUSTOMER ADDRESS

DWR_CUST_AFFLTN

CUSTOMER AFFILIATION

DWR_CUST_ATHNCTN_GRP

CUSTOMER AUTHENTICATION GROUP

DWR_CUST_CLSTR

CUSTOMER CLUSTER

DWR_CUST_CLSTR_ITEM_ASGN

CUSTOMER CLUSTER ITEM ASSIGNMENT

DWR_CUST_CLSTR_TYP

CUSTOMER CLUSTER TYPE

DWR_CUST_CNRT

CUSTOMER CONTRACT

DWR_CUST_GRP

CUSTOMER GROUP

DWR_CUST_GRP_ITEM

CUSTOMER GROUP ITEM

DWR_CUST_OCCSN

CUSTOMER OCCASION

DWR_CUST_PREF

CUSTOMER PREFERENCE

DWR_CUST_RLTNSHP

CUSTOMER RELATIONSHIP

DWR_CUST_RSTRCT_INFO

CUSTOMER RESTRICTED INFO

DWR_CUST_SGMNT

Mining table, see Table 10-2 for more information.

DWR_CUST_SGMNT_DTL

Mining table, see Table 10-2 for more information.

DWR_DAY

DAY

DWR_DAY_ACT_CNDTN

DAY ACTUAL CONDITION

DWR_DAY_TODATE_TRANS

DAY TODATE TRANSFORMATION

DWR_DAY_TRANS

DAY TRANSFORMATION

DWR_DEAL

DEAL

DWR_DEMOG_ATTR

DEMOGRAPHY ATTRIBUTE

DWR_DEMOG_GRP

DEMOGRAPHY GROUP

DWR_DOMAIN

DOMAIN

DWR_DPST_RULE

DEPOSIT RULE

DWR_DRVD_VAL

DERIVED VALUE

DWR_DSCRPNCY_TOLRNC_RULE

DISCREPANCY TOLERANCE RULE

DWR_EML_ADDR

EMAIL ADDRESS

DWR_EMP

EMPLOYEE

DWR_EMP_ADDR

EMPLOYEE ADDRESS

DWR_EMP_AVLBLTY

EMPLOYEE AVAILABILITY

DWR_EMP_CLASS

EMPLOYEE CLASS

DWR_EMP_CLASS_ASGN

EMPLOYEE CLASS ASSIGNMENT

DWR_EMP_CMISN_PLN

EMPLOYEE COMMISSION PLAN

DWR_EMP_CRTFCT

EMPLOYEE CERTIFICATE

DWR_EMP_CRTFCTN_ISSUING_BODY

EMPLOYEE CERTIFICATION ISSUING BODY

DWR_EMP_DESIG

EMPLOYEE DESIGNATION

DWR_EMP_DISC_GRP

EMPLOYEE DISCOUNT GROUP

DWR_EMP_DISC_GRP_ASGN

EMPLOYEE DISCOUNT GROUP ASSIGNMENT

DWR_EMP_RSTRCT_INFO

EMPLOYEE RESTRICTED INFORMATION

DWR_EMP_SCHL

EMPLOYEE SCHEDULE

DWR_EQPMNT

EQUIPMENT

DWR_EQPMNT_ASGN

EQUIPMENT ASSIGNMENT

DWR_EQPMNT_CLASS

EQUIPMENT CLASS

DWR_EXT_DEPOS

EXTERNAL DEPOSITORY

DWR_FCTR_CMPNY

FACTOR COMPANY

DWR_FOOD_SRVC_TBL

FOOD SERVICE TABLE

DWR_FRANCHISEE

FRANCHISEE

DWR_FSCL_HLF_MO

FISCAL HALF MONTH

DWR_FSCL_HLF_YR

FISCAL HALF YEAR

DWR_FSCL_MO

FISCAL MONTH

DWR_FSCL_QTR

FISCAL QUARTER

DWR_FSCL_WK

FISCAL WEEK

DWR_FSCL_YR

FISCAL YEAR

DWR_GEO_CITY

GEOGRAPHY CITY

DWR_GEO_CNTRY

GEOGRAPHY COUNTRY

DWR_GEO_CNTY

GEOGRAPHY COUNTY

DWR_GEO_DEMOG_ATTR

GEOGRAPHY DEMOGRAPHY ATTRIBUTES

DWR_GEO_DEMOG_GRP

GEOGRAPHY DEMOGRAPHIC GROUP

DWR_GEO_DEMOG_VAL

GEOGRAPHY DEMOGRAPHY VALUE

DWR_GEO_ENT

GEOGRAPHY ENTITY

DWR_GEO_HRCHY

GEOGRAPHY HIERARCHY

DWR_GEO_HRCHY_LVL

GEOGRAPHY HIERARCHY LEVEL

DWR_GEO_HRCHY_LVL_ASGN

GEOGRAPHY HIERARCHY LEVEL ASSIGNMENT

DWR_GEO_HRCHY_VRSN

GEOGRAPHY HIERARCHY VERSION

DWR_GEO_LVL

GEOGRAPHY LEVEL

DWR_GEO_LVL_ATTR

GEOGRAPHY LEVEL ATTRIBUTES

DWR_GEO_LVL_ATTR_VAL

GEOGRAPHY LEVEL ATTRIBUTE VALUE

DWR_GEO_RGN

GEOGRAPHY REGION

DWR_GEO_SB_RGN

GEOGRAPHY SUB REGION

DWR_GEO_STATE

GEOGRAPHY STATE

DWR_GEO_WORLD

GEOGRAPHY WORLD

DWR_GFT_CRTFCT_CLASS

GIFT CERTIFICATE CLASS

DWR_GL_ACCT

GL ACCOUNT

DWR_GL_ACCT_ASGN

GL ACCOUNT ASSIGNMENT

DWR_GL_JRNL_ENTRY_CTGRY

GL JOURNAL ENTRY CATEGORY

DWR_GL_LDGR

GL LEDGER

DWR_GL_LDGR_ACCT_ASGN

GL LEDGER ACCOUNT ASSIGNMENT

DWR_GL_PRD

GL PERIOD

DWR_GL_SBLDGR

GL SUBLEDGER

DWR_GL_SGMNT

GL SEGMENT

DWR_HH

HOUSEHOLD

DWR_HLF_HR

HALF HOUR

DWR_HLF_MO_TODATE_TRANS

HALF MONTH TODATE TRANSFORMATION

DWR_HLF_MO_TRANS

HALF MONTH TRANSFORMATION

DWR_HLF_YR_TODATE_TRANS

HALF YEAR TODATE TRANSFORMATION

DWR_HLF_YR_TRANS

HALF YEAR TRANSFORMATION

DWR_HR

HOUR

DWR_INDVL_DEMOG_VAL

INDIVIDUAL DEMOGRAPHY VALUE

DWR_INGREDIENT

INGREDIENT

DWR_INGREDIENT_OPTION

INGREDIENT OPTION

DWR_INV_LOC

INVENTORY LOCATION

DWR_ITEM

ITEM

DWR_ITEM_CLASS

ITEM CLASS

DWR_ITEM_CLSTR

ITEM CLUSTER

DWR_ITEM_CLSTR_CUST_ASGN

ITEM CLUSTER CUSTOMER ASSIGNMENT

DWR_ITEM_CMPNY

ITEM COMPANY

DWR_ITEM_DEPT

ITEM DEPARTMENT

DWR_ITEM_DIV

ITEM DIVISION

DWR_ITEM_GRP

ITEM GROUP

DWR_ITEM_HRCHY

ITEM HIERARCHY

DWR_ITEM_HRCHY_LVL

ITEM HIERARCHY LEVEL

DWR_ITEM_HRCHY_LVL_ASGN

ITEM HIERARCHY LEVEL ASSIGNMENT

DWR_ITEM_HRCHY_VRSN

ITEM HIERARCHY VERSION

DWR_ITEM_LBL

ITEM LABEL

DWR_ITEM_LVL

ITEM LEVEL

DWR_ITEM_LVL_ATTR

ITEM LEVEL ATTRIBUTE

DWR_ITEM_LVL_ATTR_VAL

ITEM LEVEL ATTRIBUTE VALUE

DWR_ITEM_MKT_DATA

ITEM MARKET DATA

DWR_ITEM_PRICE_DRVTN_RULE

ITEM PRICE DERIVATION RULE

DWR_ITEM_SBC

ITEM SUBCLASS

DWR_ITEM_SBDEPT

ITEM SUBDEPARTMENT

DWR_ITEM_SEASON

ITEM SEASON

DWR_ITEM_SLNG_RULE

ITEM SELLING RULE

DWR_ITEM_SPIFF_RULE

ITEM SPIFF RULE

DWR_ITEM_TNDR_RSTRCT_GRP

ITEM TENDER RESTRICTION GROUP

DWR_ITEM_TNDR_RSTRCT_RULE

ITEM TENDER RESTRICTION RULE

DWR_JB_TASK_SET

JOB TASK SET

DWR_LCL_TAX_AUTH

LOCAL TAX AUTHORITY

DWR_LICNS_SLS_RSTRCT

LICENSE SALES RESTRICTION

DWR_LYLTY_AWRD

LOYALTY AWARD

DWR_LYLTY_PROG

LOYALTY PROGRAM

DWR_MBRSHIP_ACCT

MEMBERSHIP ACCOUNT

DWR_MEDIA

MEDIA

DWR_MEDIA_DPCT_ITEM_ASGN

MEDIA DEPICTION ITEM ASSIGNMENT

DWR_MIX_N_MTCH_PRC_DRVTN_ITEM

MIX AND MATCH PRICE DERIVATION ITEM

DWR_MIX_N_MTCH_PRC_DRVTN_RULE

MIX AND MATCH PRICE DERIVATION RULE

DWR_MKT_AREA

MARKET AREA

DWR_MKT_AREA_LVL

MARKET AREA LEVEL

DWR_MKT_ITEM_DEPT

MARKET ITEM DEPARTMENT

DWR_MKT_ITEM_DEPT_ASGN

MARKET ITEM DEPARTMENT ASSIGNMENT

DWR_MNFCTR

MANUFACTURER

DWR_MNFCTR_BRND

MANUFACTURER BRAND

DWR_MNFCTR_CPN_FMLY

MANUFACTURER COUPON FAMILY

DWR_MNFCTR_ITEM_CLASS

MANUFACTURER ITEM CLASS

DWR_MNFCTR_ITEM_CMPNY

MANUFACTURER ITEM COMPANY

DWR_MNFCTR_ITEM_DIV

MANUFACTURER ITEM DIVISION

DWR_MNFCTR_ITEM_GRP

MANUFACTURER ITEM GROUP

DWR_MNFCTR_ITEM_RTLR_ASGN

MANUFACTURER ITEM RETAILER ASSIGNMENT

DWR_MNFCTR_ITEM_SBC

MANUFACTURER ITEM SUBCLASS

DWR_MNFCTR_ORG_CMPTR_ASGN

MANUFACTURER ORGANIZATION COMPETITOR ASSIGNMENT

DWR_MNFCTR_RTLR_ITEM_ASGN

MANUFACTURER RETAILER ITEM ASSIGNMENT

DWR_MNFCTR_SKU_BSNS_UNIT_ASGN

MANUFACTURER SKU ITEM BUSINESS UNIT ASSIGNMENT

DWR_MNFCTR_SKU_ITEM

MANUFACTURER SKU ITEM

DWR_MNFCTR_SKU_ITEM_COLLCTN

MANUFACTURER SKU ITEM COLLECTION

DWR_MNFCTR_SKU_ITEM_SHLF_ATTR

MANUFACTURER SKU ITEM SHELF ATTRIBUTES

DWR_MNFCTR_SKU_ITEM_SLNG_PRICE

MANUFACTURER SKU ITEM SELLING PRICE

DWR_MNFCTR_SKU_ITEM_VRTY_ASGN

MANUFACTURER SKU ITEM VARIETY ASSIGNMENT

DWR_MNFCTR_STCK

MANUFACTURER STOCK

DWR_MNFCTR_VRTY

MANUFACTURER VARIETY

DWR_MNT

MINUTE

DWR_MO_TODATE_TRANS

MONTH TODATE TRANSFORMATION

DWR_MO_TRANS

MONTH TRANSFORMATION

DWR_OPERTNG_SYS

OPERATING SYSTEM

DWR_ORG

ORGANIZATION

DWR_ORG_AREA

ORGANIZATION AREA

DWR_ORG_BNR

ORGANIZATION BANNER

DWR_ORG_BSNS_ENT

ORGANIZATION BUSINESS ENTITY

DWR_ORG_BSNS_UNIT

ORGANIZATION BUSINESS UNIT

DWR_ORG_BSNS_UNIT_HOLIDY

ORGANIZATION BUSINESS UNIT HOLIDAY

DWR_ORG_BSNS_UNIT_SB_RGN_ASGN

ORG BSNS UNIT SUB REGION ASSIGNMENT

DWR_ORG_CHAIN

ORGANIZATION CHAIN

DWR_ORG_CMPNY

ORGANIZATION COMPANY

DWR_ORG_DEMOG_VAL

ORGANIZATION DEMOGRAPHY VALUE

DWR_ORG_DEPT

ORGANIZATION DEPARTMENT

DWR_ORG_DIV

ORGANIZATION DIVISION

DWR_ORG_DSTRCT

ORGANIZATION DISTRICT

DWR_ORG_HRCHY

ORGANIZATION HIERARCHY

DWR_ORG_HRCHY_LVL

ORGANIZATION HIERARCHY LEVEL

DWR_ORG_HRCHY_VRSN

ORGANIZATION HIERARCHY VERSION

DWR_ORG_LVL

ORGANIZATION LEVEL

DWR_ORG_LVL_ATTR

ORGANIZATION LEVEL ATTRIBUTES

DWR_ORG_LVL_ATTR_VAL

ORGANIZATION LEVEL ATTRIBUTE VALUE

DWR_ORG_MKT_DATA

ORGANIZATION MARKET DATA

DWR_ORG_RECIPE_ASGN

ORGANIZATION RECIPE ASSIGNMENT

DWR_ORG_RGN

ORGANIZATION REGION

DWR_OTHR_INDVL

OTHER INDIVIDUAL

DWR_PERIOD_TODATE_TRANS

PERIOD TODATE TRANSFORMATION

DWR_PERIOD_TRANS

PERIOD TRANSFORMATION

DWR_PG

PAGE

DWR_PG_CTGRY

PAGE CATEGORY

DWR_PG_CTGRY_LVL

PAGE CATEGORY LEVEL

DWR_PHS

PHASE

DWR_PLNG_PERIOD

PLANNING PERIOD

DWR_PLNG_QTR

PLANNING QUARTER

DWR_PLNG_SEASON

PLANNING SEASON

DWR_PLNG_SEASON_WK_ASGN

PLANNING SEASON WEEK ASSIGNMENT

DWR_PLNG_WK

PLANNING WEEK

DWR_PLNG_YR

PLANNING YEAR

DWR_PLTFRM

PLATFORM

DWR_POS_DEPT

POS DEPARTMENT

DWR_POS_IDNT

POS IDENTITY

DWR_POSN

POSITION

DWR_POSN_HRCHY

POSITION HIERARCHY

DWR_POSN_WRK_SCHL

POSITION WORK SCHEDULE

DWR_POSTCD

POST CODE

DWR_PRFL_SRC

PROFILE SOURCE

DWR_PRICE_DRVTN_RULE

PRICE DERIVATION RULE

DWR_PRICE_DRVTN_RULE_ELGBL

PRICE DERIVATION RULE ELIGIBILITY

DWR_PRMTN

PROMOTION

DWR_PRMTN_ITEM

PROMOTION ITEM

DWR_PRMTN_PLN

PROMOTION PLAN

DWR_PRMTN_PRICE_DRVTN

PROMOTION PRICE DERIVATION

DWR_PRMTN_PRMTN_TYP

PROMOTION PROMOTION TYPE

DWR_PRMTN_SLNG_ITEM

PROMOTION SELLING ITEM

DWR_PROD

PRODUCT

DWR_PROD_ENT

PRODUCT ENTITY

DWR_PROJ

PROJECT

DWR_PRSPCT

PROSPECT

DWR_PRSPCT_RSTRCT_INFO

PROSPECT RESTRICTED INFO

DWR_PRTY

PARTY

DWR_PRTY_ASGN

PARTY ASSIGNMENT

DWR_PRTY_CNCT_INFO

PARTY CONTACT INFORMATION

DWR_PRTY_DEMOG_ATTR

PARTY DEMOGRAPHY ATTRIBUTE

DWR_PRTY_DEMOG_GRP

PARTY DEMOGRAPHIC GROUP

DWR_PRTY_DEMOG_VAL

PARTY DEMOGRAPHY VALUE

DWR_QTR_HR

QUARTER HOUR

DWR_QTR_TODATE_TRANS

QUARTER TODATE TRANSFORMATION

DWR_QTR_TRANS

QUARTER TRANSFORMATION

DWR_RECIPE

RECIPE

DWR_RECIPE_INGREDIENT_ASGN

RECIPE INGREDIENT ASSIGNMENT

DWR_REFERRING_CTGRY

REFERRING CATEGORY

DWR_REFERRING_CTGRY_LVL

REFERRING CATEGORY LEVEL

DWR_REFERRING_SITE

REFERRING SITE

DWR_REFERRING_URL

REFERRING URL

DWR_RGN

REGION

DWR_RL_HRCHY

ROLES HIERARCHY

DWR_RLTD_ITEM_ASSOCTN

RELATED ITEM ASSOCIATION

DWR_RNTL_SRVC

RENTAL SERVICE

DWR_RNTL_UNIT

RENTAL UNIT

DWR_RSTRCT_VALID_QUES

RESTRICTION VALIDATION QUESTION

DWR_RTL_TRX_DLVRY_PREF

RETAIL TRANSACTION DELIVERY PREFERENCE

DWR_RTL_TRX_DLVRY_PREF_ITEM

RETAIL TRANSACTION DELIVERY PREFERENCE ITEM

DWR_RTLR

RETAILER

DWR_RTLR_ASGN

RETAILER ASSIGNMENT

DWR_RTLR_BRND

RETAILER BRAND

DWR_RTLR_CLSTR

RETAILER CLUSTER

DWR_RTLR_CLSTR_ITEM_ASGN

RETAILER CLUSTER ITEM ASSIGNMENT

DWR_RTLR_CLSTR_RTLR_ASGN

RETAILER CLUSTER RETAILER ASSIGNMENT

DWR_RVN_CNTR

REVENUE CENTER

DWR_SB_BRND

SUB BRAND

DWR_SB_RGN

SUB REGION

DWR_SBRP

SUBSCRIPTION

DWR_SCND

SECOND

DWR_SEARCH

SEARCH

DWR_SEARCH_CTGRY

SEARCH CATEGORY

DWR_SEARCH_CTGRY_LVL

SEARCH CATEGORY LEVEL

DWR_SEASON

SEASON

DWR_SERVER

SERVER

DWR_SERVER_FARM

SERVER FARM

DWR_SHFT_DFFRNTL

SHIFT DIFFERENTIAL

DWR_SITE

SITE

DWR_SKU_ITEM

SKU ITEM

DWR_SKU_ITEM_BU_INV_RULE

SKU ITEM BUSINESS UNIT INVENTORY RULES

DWR_SKU_ITEM_CHOICE

SKU ITEM CHOICE

DWR_SKU_ITEM_COLLCTN

SKU ITEM COLLECTION

DWR_SKU_ITEM_CONSTRCTN

SKU ITEM CONSTRUCTION

DWR_SKU_ITEM_RECIPE_ASGN

SKU ITEM RECIPE ASSIGNMENT

DWR_SKU_ITEM_SBSTTN

SKU ITEM SUBSTITUTION

DWR_SKU_ITEM_SHLF_ATTR

SKU ITEM SHELF ATTRIBUTES

DWR_SKU_ITEM_VRTY_ASGN

SKU ITEM VARIETY ASSIGNMENT

DWR_SKU_ITEM_WT

SKU ITEM WEIGHT

DWR_SLNG_LOC

SELLING LOCATION

DWR_SLS_RSTRCT

SALES RESTRICTION

DWR_SOC_JB

SOC JOB

DWR_SOC_JB_CTGRY

SOC JOB CATEGORY

DWR_SOC_JB_GRP

SOC JOB GROUP

DWR_SOC_JB_MJR_GRP

SOC JOB MAJOR GROUP

DWR_SRLZD_ITEM

SERIALIZED ITEM

DWR_SRLZD_UNIT

SERIALIZED UNIT

DWR_SRVC_ITEM_PRVDR

SERVICE ITEM PROVIDER

DWR_SRVC_TERM

SERVICE TERM

DWR_STCK_ITEM_CONSMR_PROD_LBL

STOCK ITEM CONSUMER PRODUCT LABEL

DWR_STORE_FIN_LEDG_ACCT

STORE FINANCIAL LEDGER ACCOUNT

DWR_STORE_SAFE

STORE SAFE

DWR_SURVEY

SURVEY

DWR_SURVEY_QUES

SURVEY QUESTION

DWR_SURVEY_QUES_OPTION

SURVEY QUESTION OPTION

DWR_TARE

TARE

DWR_TASK

TASK

DWR_TASK_PREREQUISITE

TASK PREREQUISITE

DWR_TASK_SET

TASK SET

DWR_TAX_AUTH

TAX AUTHORITY

DWR_TAX_EXMPTN

TAX EXEMPTION

DWR_TAX_GRP_RULE

TAX GROUP RULE

DWR_TAX_RATE_RULE

TAX RATE RULE

DWR_TAXBL_GRP

TAXABLE GROUP

DWR_TCHPNT

TOUCHPOINT

DWR_TERM_CD

TERM CODE

DWR_TILL_LMT_RULE

TILL LIMIT RULE

DWR_TILL_TNDR_LMT_RULE_ASGN

TILL TENDER LIMIT RULE ASSIGNMENT

DWR_TILL_WRKSTN_ASGN

TILL WORKSTATION ASSIGNMENT

DWR_TIME_PLNG_SEASON_TD_BY_WK

TIME PLANNING SEASON TODATE BY WEEK

DWR_TIME_STNDRD_BY_DAY

TIME STANDARD BY DAY

DWR_TIME_STNDRD_BY_WK

TIME STANDARD BY WEEK

DWR_TIME_ZN

TIME ZONE

DWR_TNDR

TENDER

DWR_TNDR_ACCT_APRVL_REF

TENDER ACCOUNT APPROVAL REFERENCE

DWR_TNDR_ATHRZN_TRML_SFTWR_VSN

TENDER AUTHORIZATION TERMINAL SOFTWARE VERSION

DWR_TNDR_ATHRZTN_TRML

TENDER AUTHORIZATION TERMINAL

DWR_TNDR_RPSTRY

TENDER REPOSITORY

DWR_TNDR_RPSTRY_TNDR_ACCT

TENDER REPOSITORY TENDER ACCOUNT

DWR_TOT_TIME

TOTAL TIME

DWR_TRD_AREA

TRADE AREA

DWR_TRD_AREA_COVRG

TRADE AREA COVERAGE

DWR_UOM_CONVRSN

UNIT OF MEASURE CONVERSION

DWR_USER

USER

DWR_VAL_MSR

VALUE MEASURE

DWR_VALID_QUES_ASGN

VALIDATION QUESTION ASSIGNMENT

DWR_VISITOR

VISITOR

DWR_VNDR

VENDOR

DWR_VNDR_APNMNT

VENDOR APPOINTMENT

DWR_VNDR_CARRIER_ASGN

VENDOR CARRIER ASSIGNMENT

DWR_VNDR_CNRT

VENDOR CONTRACT

DWR_VNDR_FCTR_CMPNY_ASGN

VENDOR FACTOR COMPANY ASSIGNMENT

DWR_VNDR_ITEM

VENDOR ITEM

DWR_VNDR_ITEM_BSNS_UNIT_ASGN

VENDOR ITEM BUSINESS UNIT ASSIGNMENT

DWR_VNDR_ITEM_SKU_ASGN

VENDOR ITEM SKU ASSIGNMENT

DWR_VNDR_MNFCTR_BRND

VENDOR MANUFACTURER BRAND

DWR_VNDR_SITE

VENDOR SITE

DWR_VNDR_SITE_ADDR

VENDOR SITE ADDRESS

DWR_VNDR_SITE_CARRIER_ASGN

VENDOR SITE CARRIER ASSIGNMENT

DWR_VNDR_SKU_BSNS_UNIT_ASGN

VENDOR SKU BUSINESS UNIT ASSIGNMENT

DWR_VRTY

VARIETY

DWR_WBSITE_RESRE

WEBSITE RESOURCE

DWR_WBSITE_USER

WEBSITE USER

DWR_WKDAY

WEEKDAY

DWR_WK_TODATE_TRANS

WEEK TODATE TRANSFORMATION

DWR_WK_TRANS

WEEK TRANSFORMATION

DWR_WRK_LOC

WORK LOCATION

DWR_WRKSTN_DISP

WORKSTATION DISPLAY

DWR_WRKSTN_GRP

WORKSTATION GROUP

DWR_WRKSTN_LOC_ASGN

WORKSTATION LOCATION ASSIGNMENT

DWR_YR_TRANS

YEAR TRANSFORMATION


Lookup Tables

The Lookup tables are listed in Table 3-2.

Table 3-2 Lookup Tables

Table Name Description

DWL_ACCT_TYP

ACCOUNT TYPE

DWL_ACTVTY_RQST_TYP

ACTIVITY REQUEST TYPE

DWL_ADDR_LOC_TYP

ADDRESS LOCATION TYPE

DWL_ADDR_TYP

ADDRESS TYPE

DWL_ADDR_VRFY_TYP

ADDRESS VERIFICATION TYPE

DWL_ADJ_TYP

ADJUSTMENT TYPE

DWL_AGE_GRP

AGE GROUP

DWL_APNMNT_MTNG_TYP

APPOINTMENT MEETING TYPE

DWL_APNMNT_TYP

APPOINTMENT TYPE

DWL_ASSTS_TYP

ASSETS TYPE

DWL_ATHRZTN_MTHD

AUTHORIZATION METHOD

DWL_BSNS_LEGAL_STAT

BUSINESS LEGAL STATUS

DWL_BSNS_UNIT_TYP

BUSINESS UNIT TYPE

DWL_BSNS_UNIT_USG_TYP

BUSINESS UNIT USAGE TYPE

DWL_CALL_CNTR_AGNT_TYP

CALL CENTER AGENT TYPE

DWL_CALL_CNTR_CASE_SB_TYP

CALL CENTER CASE SUB TYPE

DWL_CALL_CNTR_CASE_TYP

CALL CENTER CASE TYPE

DWL_CARD_HLDR_VRFY_TYP

CARD HOLDER VERIFICATION TYPE

DWL_CARD_TYP

CARD TYPE

DWL_CHNL_TYP

CHANNEL TYPE

DWL_CLASS

CLASS

DWL_CLNDR_TYP

CALENDAR TYPE

DWL_CLNT_TYP

CLIENT TYPE

DWL_CNRT_STAT_RSN

CONTRACT STATUS REASON

DWL_CNRT_STAT_TYP

CONTRACT STATUS TYPE

DWL_CNRT_TERM_TYP

CONTRACT TERM TYPE

DWL_CNRT_TYP

CONTRACT TYPE

DWL_CNTRL_TRX_TYP

CONTROL TRANSACTION TYPE

DWL_COATING

COATING

DWL_COLOR

COLOR

DWL_COLOR_LST_AGNCY

COLOR LIST AGENCY

DWL_COLOR_PALETTE

COLOR PALETTE

DWL_COMUNICTN_TYP

COMMUNICATION TYPE

DWL_COST_PER_UNIT_TYP

COST PER UNIT TYPE

DWL_COST_RSN

COST REASON

DWL_COST_SUBTYP

COST SUBTYPE

DWL_COST_TYP

COST TYPE

DWL_CPN_SCAN

COUPON SCAN

DWL_CPN_TYP

COUPON TYPE

DWL_CRNCY

CURRENCY

DWL_CRTFCT_TYP

CERTIFICATE TYPE

DWL_CUST_OCCSN_TYP

CUSTOMER OCCASION TYPE

DWL_CUST_PCKUP_TYP

CUSTOMER PICKUP TYPE

DWL_CUST_RLTN_TYP

CUSTOMER RELATIONSHIP TYPE

DWL_CUST_TYP

CUSTOMER TYPE

DWL_DENMTN

DENOMINATION

DWL_DISBRSMNT_FND_RCPT_RSN

DISBURSEMENT FUNDS RECEIPT REASON

DWL_DISC_TYP

DISCOUNT TYPE

DWL_DISC_TYP_GRP

DISCOUNT TYPE GROUP

DWL_DOMAIN_TYP

DOMAIN TYPE

DWL_DPST_RDMPTN_TYP

DEPOSIT REDEMPTION TYPE

DWL_DSPSTN_TYP

DISPOSITION TYPE

DWL_DSTN_TYP

DESTINATION TYPE

DWL_DYE

DYE

DWL_EDU_LVL

EDUCATION

DWL_EMP_CRTFCTN_TYP

EMPLOYEE CERTIFICATION TYPE

DWL_EMP_TIME_ACCRUAL_TYP

EMPLOYEE TIME ACCRUAL TYPE

DWL_EMP_TYP

EMPLOYEE TYPE

DWL_ENTRY_MTHD

ENTRY METHOD

DWL_ENV_TYP

ENVIRONMENT TYPE

DWL_EQPMNT_TYP

EQUIPMENT TYPE

DWL_EXP_TYP

EXPENSE TYPE

DWL_FABRIC

FABRIC

DWL_FIBER

FIBER

DWL_FNCTN_CD

FUNCTION CODE

DWL_FUEL_SL_STAT

FUEL SALE STATUS

DWL_GFT_CRTFCT_TYP

GIFT CERTIFICATE TYPE

DWL_GL_ACCT_ASGN_TYP

GL ACCOUNT ASSIGNMENT TYPE

DWL_GL_ACCT_TYP

GL ACCOUNT TYPE

DWL_GL_SGMNT_TYP

GL SEGMENT TYPE

DWL_GNDR

GENDER

DWL_HRS_TYP

HOURS TYPE

DWL_HZRDS_MTRL_TYP

HAZARDOUS MATERIAL TYPE

DWL_ICD_ASGN_RSN

ICD ASSIGNMENT REASON

DWL_ICD_ASGN_TYP

ICD ASSIGNMENT TYPE

DWL_IMPRESSION_EVT_TYP

IMPRESSION EVENT TYPE

DWL_INTRACN_CHNL

INTERACTION CHANNEL

DWL_INTRACN_CHNL_TYP

INTERACTION CHANNEL TYPE

DWL_INTRACN_DRCTN

INTERACTION DIRECTION

DWL_INTRACN_RSLT_TYP

INTERACTION RESULT TYPE

DWL_INTRACN_RSN

INTERACTION REASON

DWL_INTRACN_STAT

INTERACTION STATUS

DWL_INTRACN_THRD_STAT

INTERACTION THREAD STATUS

DWL_INTRACN_TYP

INTERACTION TYPE

DWL_INV_ACCT_MTHD

INVENTORY ACCOUNTING METHOD

DWL_INV_CNDTN

INVENTORY CONDITION

DWL_INV_DOC_LI_TYP

INVENTORY CONTROL DOCUMENT LINE ITEM TYPE

DWL_INV_DOC_TYP

INVENTORY DOCUMENT TYPE

DWL_INV_LOC_TYP

INVENTORY LOCATION TYPE

DWL_INV_STAT

INVENTORY STATUS

DWL_INV_STATE

INVENTORY STATE

DWL_INV_TYP

INVENTORY TYPE

DWL_ISSUE_TYP

ISSUE TYPE

DWL_ITEM_CLSTR_TYP

ITEM CLUSTER TYPE

DWL_ITEM_LKUP_MTHD

ITEM LOOKUP METHOD

DWL_ITEM_STATE

ITEM STATE

DWL_JB_RL

JOB ROLES

DWL_KNWN_SRC_TYP

KNOWN SOURCE TYPE

DWL_LANG

LANGUAGE

DWL_LBL_TYP

LABEL TYPE

DWL_LCL_AUTH_TYP

LOCAL AUTHORITY TYPE

DWL_LFCCL_TYP

LIFECYCLE TYPE

DWL_LIAB_TYP

LIABILITY TYPE

DWL_LOC_TYP

LOCATION TYPE

DWL_LTTR_TYP

LETTER TYPE

DWL_MBRSHIP_TYP

MEMBERSHIP TYPE

DWL_MEDIA_TYP

MEDIA TYPE

DWL_MISCLNS_LI_TYP

MISCELLANEOUS LINE ITEM TYPE

DWL_MLTPL_TNDR_CLASS

MULTIPLE TENDER CLASS

DWL_MNFCTR_TYP

MANUFACTURER TYPE

DWL_MRTL_STAT

MARITAL STATUS

DWL_NTNLTY

NATIONALITY

DWL_ORDR_CTGRY_TYP

ORDER CATEGORY TYPE

DWL_ORDR_LI_STATE_TYP

ORDER LINE ITEM STATE TYPE

DWL_ORDR_LI_TYP

ORDER LINE ITEM TYPE

DWL_ORDR_SRC

ORDER SOURCE TYPE

DWL_ORDR_STAT

ORDER STATUS

DWL_ORDR_STAT_TYP

ORDER STATUS TYPE

DWL_ORDR_STATE

ORDER STATE

DWL_ORDR_TYP

ORDER TYPE

DWL_ORG_LVL_TYP

ORGANIZATION LEVEL TYPE

DWL_ORG_TYP

ORGANIZATION TYPE

DWL_PAY_CTGRY

PAY CATEGORY

DWL_PAY_TYP

PAY TYPE

DWL_PLAN_TYP

PLAN TYPE

DWL_PNLTY_MTHD

PENALTY METHOD

DWL_POS_IDNT_TYP

POS IDENTITY TYPE

DWL_POSTL_SRVC_TYP

POSTAL SERVICE TYPE

DWL_PRD_TYP

PERIOD TYPE

DWL_PREF_TYP

PREFERENCE TYPE

DWL_PRICE_LST

PRICE LIST

DWL_PRICE_TYP

PRICE TYPE

DWL_PRMTN_PROD_TYP

PROMOTION PRODUCT TYPE

DWL_PRMTN_TYP

PROMOTION TYPE

DWL_PRODTN_ITEM_CONVBL_TYP

PRODUCTION ITEM CONVEYABLE TYPE

DWL_PRSNL_ID_REQD_TYP

PERSONAL ID REQUIRED TYPE

DWL_PRTY_ASGN_RSN

PARTY ASSIGNMENT REASON

DWL_PRTY_ASGN_TYP

PARTY ASSIGNMENT TYPE

DWL_PRTY_CNCT_INFO_TYP

PARTY CONTACT INFORMATION TYPE

DWL_PRTY_INTRACN_THRD_TYP

PARTY INTERACTION THREAD TYPE

DWL_PRTY_STAT_CD

PARTY STATUS CODE

DWL_PRTY_STAT_CTGRY

PARTY STATUS CATEGORY

DWL_PRTY_STAT_TYP

PARTY STATUS TYPE

DWL_PRTY_TYP

PARTY TYPE

DWL_RELIGIOUS_AFFLTN

RELIGIOUS AFFILIATION

DWL_RETRN_TYP

RETURN TYPE

DWL_RFMP_MTHD

RFMP METHOD

DWL_RLTD_ITEM_ASSOCTN_TYP

RELATED ITEM ASSOCIATION TYPE

DWL_RQST_ORIGIN

REQUEST ORIGIN TYPE

DWL_RSN

REASON

DWL_RSN_CTGRY

REASON CATEGORY

DWL_RTL_TRX_LI_ASGN_TYP

RETAIL TRANSACTION LINE ITEM ASSIGNMENT TYPE

DWL_RTL_TRX_LI_GRP_TYP

RETAIL TRANSACTION LINE ITEM GROUP TYPE

DWL_RTL_TRX_LI_TYP

RETAIL TRANSACTION LINE ITEM TYPE

DWL_RTL_TYP

RETAIL TYPE

DWL_SCRTY_CLASS

SECURITY CLASS

DWL_SCRTY_REQD_TYP

SECURITY REQUIRED TYPE

DWL_SRLZD_UNIT_TYP

SERIALIZED UNIT TYPE

DWL_SERVER_STAT

SERVER STATUS

DWL_SESSION_TYP

SESSION TYPE

DWL_SHFT_TYP

SHIFT TYPE

DWL_SHPMNT_MTHD

SHIPMENT METHOD

DWL_SHPMNT_PRIORITY

SHIPMENT PRIORITY

DWL_SKU_ITEM_STYLE

SKU ITEM STYLE

DWL_SKU_ITEM_TYP

SKU ITEM TYPE

DWL_SL_ASSOCT_ACTN

SALES ASSOCIATE ACTION

DWL_SL_OR_RETRN_ACTN

SALE OR RETURN ACTION

DWL_SL_WT_OR_UNIT_CNT

SALE WEIGHT OR UNIT COUNT

DWL_SLNG_LOC_TYP

SELLING LOCATION TYPE

DWL_SLNG_STAT

SELLING STATUS

DWL_SRVC_TYP

SERVICE TYPE

DWL_STAT

STATUS

DWL_STAT_RSN

STATUS REASON

DWL_STAT_TYP

STATUS TYPE

DWL_STCK_ITEM_TYP

STOCK ITEM TYPE

DWL_SZ

SIZE

DWL_SZ_TYP

SIZE TYPE

DWL_TAX_LVL_TYP

TAX LEVEL TYPE

DWL_TAX_RATE_CLASS

TAX RATE CLASS

DWL_TAX_RSLT_TYP

TAX RESULT TYPE

DWL_TAX_THRSHLD_TYP

TAX THRESHOLD TYPE

DWL_TAX_TYP

TAX TYPE

DWL_TILL_LMT_TYP

TILL LIMIT TYPE

DWL_TILL_MOVEMENT_DRCTN

TILL MOVEMENT DIRECTION

DWL_TNDR_CLASS

TENDER CLASS

DWL_TNDR_RPSTRY_CLASS

TENDER REPOSITORY CLASS

DWL_TRNSFR_TYP

TRANSFER TYPE

DWL_TRX_ASGN_TYP

TRANSACTION ASSIGNMENT TYPE

DWL_TRX_CTGRY

TRANSACTION CATEGORY

DWL_TRX_TYP

TRANSACTION TYPE

DWL_UOM

UNIT OF MEASURE

DWL_UOM_TYP

UNIT OF MEASURE TYPE

DWL_VAL_TYP

VALUE TYPE

DWL_VISITOR_TYP

VISITOR TYPE

DWL_VNDR_CLASS

VENDOR CLASS

DWL_VNDR_ITEM_CPU_TYP

VENDOR ITEM COST PER UNIT TYPE

DWL_VNDR_RTNG_TYP

VENDOR RATING TYPE

DWL_VRTY_TYP

VARIETY TYPE

DWL_WBSITE_RESRE_TYP

WEBSITE RESOURCE TYPE

DWL_WEAVE

WEAVE

DWL_WF_CUST_TYP

WF CUSTOMER TYPE

DWL_WRK_HR_TYP

WORK HOUR TYPE

DWL_WRKSTN_LOC_TYP

WORKSTATION LOCATION TYPE

DWL_WRNTY_TYP

WARRANTY TYPE


Base Tables

The Base tables are listed in Table 3-3.

Table 3-3 Base Tables

Table Name Description

DWB_ADDR_LOC_STAT_HIST

ADDRESS LOCATION STATUS HISTORY

DWB_BUMP_BR_EQPMNT_STSTCS_RDNG

BUMP BAR EQUIPMENT STATISTICS READING

DWB_CRTFCT_ESCHTD_DAY

CERTIFICATE ESCHEATED DAY

DWB_CNTRL_TRX

CONTROL TRANSACTION

DWB_COST

COST

DWB_COST_CNTR_BDGT

COST CENTER BUDGET

DWB_COST_VALTN_LDGR_ACCT_HIST

COST VALUATION LEDGER ACCOUNT HISTORY

DWB_CRTFCT_LI

CERTIFICATE LINE ITEM

DWB_CS_DRWR_EQPMNT_STSTCS_RDNG

CASH DRAWER EQUIPMENT STATISTICS READING

DWB_CUST_INFO_LI

CUSTOMER INFORMATION LINE ITEM

DWB_CUST_INVC

CUSTOMER INVOICE

DWB_CUST_INVC_ITEM

CUSTOMER INVOICE ITEM

DWB_CUST_ORDR

CUSTOMER ORDER

DWB_CUST_ORDR_CNTRL_TRX

CUSTOMER ORDER CONTROL TRANSACTION

DWB_CUST_ORDR_CNTRL_TRX_LI

CUSTOMER ORDER CONTROL TRANSACTION LINE ITEM

DWB_CUST_ORDR_LI

CUSTOMER ORDER LINE ITEM

DWB_CUST_ORDR_LI_STATE

CUSTOMER ORDER LINE ITEM STATE

DWB_CUST_ORDR_STATE

CUSTOMER ORDER STATE

DWB_CUST_ORDR_TAX_EXMPTN_MDFR

CUSTOMER ORDER TAX EXEMPTION MODIFIER

DWB_CUST_ORDR_TAX_OVRRD_MDFR

CUSTOMER ORDER TAX OVERRIDE MODIFIER

DWB_CUST_PYMT

CUSTOMER PAYMENT

DWB_CUST_RNTL_ACCT_HIST

CUSTOMER RENTAL ACCOUNT HISTORY

DWB_CUST_STAT

CUSTOMER STATUS

DWB_DEAL_VNDR_ITEM_ASGN

DEAL VENDOR ITEM ASSIGNMENT

DWB_DEAL_VNDR_ITEM_COST_BRK

DEAL VENDOR ITEM COST BREAK

DWB_DISC_LI

DISCOUNT LINE ITEM

DWB_DPST_RDMPTN_LI

DEPOSIT REDEMPTION LINE ITEM

DWB_DVC_EVT

DEVICE EVENT

DWB_EMP_ACT_LBR_HRLY

EMPLOYEE ACTUAL LABOR HOURLY

DWB_EMP_ACT_LBR_SAL

EMPLOYEE ACTUAL LABOR SALARIED

DWB_EMP_DISC_SL_HIST

EMPLOYEE DISCOUNTED SALES HISTORY

DWB_EMP_JB_RL_ASGN

EMPLOYEE JOB ROLE ASSIGNMENT

DWB_EMP_POSN_ASGN

EMPLOYEE POSITION ASSIGNMENT

DWB_EMP_PUNCH

EMPLOYEE PUNCH

DWB_EMP_SERVER_ASGN

EMPLOYEE SERVER ASSIGNMENT

DWB_EMP_TIME_ACCRUAL_HIST

EMPLOYEE TIME ACCRUAL HISTORY

DWB_EMP_TIME_PUNCH_ENTRY

EMPLOYEE TIME PUNCH ENTRY

DWB_EMP_TRNG_REC

EMPLOYEE TRAINING RECORD

DWB_EVT

EVENT

DWB_EVT_PRTY_INTRACN_PRTCPTN

EVENT PARTY INTERACTION PARTICIPATION

DWB_EXCHNG_RATE_CRNCY_DAY

EXCHANGE RATE CURRENCY DAY

DWB_EXTRNL_DEPOS_TNDR_HIST

EXTERNAL DEPOSITORY TENDER HISTORY

DWB_FCL_PTR_EQPMNT_STSTCS_RDNG

FISCAL PRINTER EQUIPMENT STATISTICS READING

DWB_FLEET_MGMT

FLEET MANAGEMENT

DWB_FLFLMNT_ACKNLGMNT_LI

FULFILLMENT ACKNOWLEDGMENT LINE ITEM

DWB_FOOD_SRVC_TRX

FOOD SERVICE TRANSACTION

DWB_FORECOURT_TRX

FORECOURT TRANSACTION

DWB_FRCST_ITEM_ORG_HRCHY_WK

SALES FORECAST ITEM ORG HIERARCHY WEEK

DWB_FRGHT_DOC

FREIGHT DOCUMENT

DWB_FUELING_TRX

FUELING TRANSACTION

DWB_GL_BAL

GL BALANCE

DWB_GL_JE_LN_SBLDGR_ASGN

GL JE LINE SUBLEDGER ASSIGNMENT

DWB_GL_JRNL_ENTRY

GL JOURNAL ENTRY

DWB_GL_JRNL_ENTRY_BTCH

GL JOURNAL ENTRY BATCH

DWB_GL_JRNL_ENTRY_LN

GL JOURNAL ENTRY LINE

DWB_GL_SBLDGR_JRNL_ENTRY

GL SUBLEDGER JOURNAL ENTRY

DWB_GL_SBLDGR_JRNL_ENTRY_LN

GL SUBLEDGER JOURNAL ENTRY LINE

DWB_ICD_LI_ASGN

ICD LINE ITEM ASSIGNMENT

DWB_ICD_MRCHNDS_LI_MDFR

ICD MERCHANDISE LINE ITEM MODIFIER

DWB_ICD_MRCHNDS_TAX_LI

ICD MERCHANDISE TAX LINE ITEM

DWB_ICD_TAX_EXMPTN_MDFR

ICD TAX EXEMPTION MODIFIER

DWB_IMPRESSION

IMPRESSION

DWB_INV_ADJ_DOC

INVENTORY ADJUSTMENT DOCUMENT

DWB_INV_ADJ_DOC_LI

INVENTORY ADJUSTMENT DOCUMENT LINE ITEM

DWB_INV_CNTRL_DOC

INVENTORY CONTROL DOCUMENT

DWB_INV_CNTRL_DOC_ASGN

INVENTORY CONTROL DOCUMENT ASSIGNMENT

DWB_INV_CNTRL_DOC_LI

INVENTORY CONTROL DOCUMENT LINE ITEM

DWB_INV_ITEM_STATE

INVENTORY ITEM STATE

DWB_INV_SPACE_ALCTN

INVENTORY SPACE ALLOCATION

DWB_ITEM_INV_JRNL_ENTRY

ITEM INVENTORY JOURNAL ENTRY

DWB_JB_ALCTN

JOB ALLOCATION

DWB_KEY_LCK_EQPMNT_STSTCS_RDNG

KEY LOCK EQUIPMENT STATISTICS READING

DWB_LN_DSPL_EQPMNT_STSTCS_RDNG

LINE DISPLAY EQUIPMENT STATISTICS READING

DWB_LYLTY_RWRD_LI

LOYALTY REWARD LINE ITEM

DWB_MICR_EQPMNT_STTSTCS_RDNG

MICR EQUIPMENT STATISTICS READING

DWB_MISCLNS_FEE_LI

MISCELLANEOUS FEE LINE ITEM

DWB_MISS_SCHL

MISSED SCHEDULE

DWB_MKT_SLS_ITEM_LVL_WK

MARKET SALES ITEM WEEK

DWB_MNFCTR_INV_ITEM_STATE

MANUFACTURER INVENTORY ITEM STATE

DWB_MNFCTR_SKU_IM_SLNG_PRC_HST

MANUFACTURER SKU ITEM SELLING PRICE HISTORY

DWB_MTN_SNSR_EQPMT_STSTCS_RDNG

MOTION SENSOR EQUIPMENT STATISTICS READING

DWB_NOZZLE_HIST

NOZZLE HISTORY

DWB_ORDR

ORDER

DWB_ORDR_LI

ORDER LINE ITEM

DWB_ORDR_LI_STATE

ORDER LINE ITEM STATE

DWB_ORG_BSNS_UNIT_TRFC

ORGANIZATION BUSINESS UNIT TRAFFIC

DWB_PAY_DTL

PAY DETAIL

DWB_PAYBL_INVC

PAYABLE INVOICE

DWB_PAYBL_INVC_ITEM

PAYABLE INVOICE ITEM

DWB_PCHSE_ORDR

PURCHASE ORDER

DWB_PCHSE_ORDR_LI

PURCHASE ORDER LINE ITEM

DWB_PCHSE_ORDR_LI_STATE

PURCHASE ORDER LINE ITEM STATE

DWB_PCHSE_ORDR_STATE

PURCHASE ORDER STATE

DWB_PHY_CNT_DOC

PHYSICAL COUNT DOCUMENT

DWB_PHY_CNT_DOC_LI

PHYSICAL COUNT DOCUMENT LINE ITEM

DWB_PINPAD_EQPMNT_STTSTCS_RDNG

PINPAD EQUIPMENT STATISTICS READING

DWB_POS_KEYBD_EQPMT_STSTS_RDNG

POS KEYBOARD EQUIPMENT STATISTICS READING

DWB_POS_PRNTR_EQPMT_STSTS_RDNG

POS PRINTER EQUIPMENT STATISTICS READING

DWB_PRICE_LN

PRICE LINE

DWB_PRICE_MODIFICATION_LI

PRICE MODIFICATION LINE ITEM

DWB_PRMTN_HIST

PROMOTION HISTORY

DWB_PRMTN_MEDIA_COST

PROMOTION MEDIA COST

DWB_PRTY_INTRACN_CALL_EVT

PARTY INTERACTION CALL EVENT

DWB_PRTY_INTRACN_EML_EVT

PARTY INTERACTION EMAIL EVENT

DWB_PRTY_INTRACN_LTTR_EVT

PARTY INTERACTION LETTER EVENT

DWB_PRTY_INTRACN_THRD

PARTY INTERACTION THREAD

DWB_PRTY_INTRACN_THRD_EVT_ASGN

PARTY INTERACTION THREAD EVENT ASSIGNMENT

DWB_PRTY_INTRCN_THRD_STAT_HIST

PARTY INTERACTION THREAD STATUS HISTORY

DWB_PRTY_INTRACN_VST_EVT

PARTY INTERACTION VISIT EVENT

DWB_PRTY_STAT_HIST

PARTY STATUS HISTORY

DWB_PYMT_ON_ACCT_LI

PAYMENT ON ACCOUNT LINE ITEM

DWB_RESERVATION

RESERVATION

DWB_RNDNG_LI

ROUNDING LINE ITEM

DWB_RTL_SL_LI_AUDIT

RETAIL SALE LINE ITEM AUDIT

DWB_RTL_SL_RTRN_LI

RETAIL SALE RETURN LINE ITEM

DWB_RTL_TNDR_LI

RETAIL TENDER LINE ITEM

DWB_RTL_TNDR_LI_AUDIT

RETAIL TENDER LINE ITEM AUDIT

DWB_RTL_TRX

RETAIL TRANSACTION

DWB_RTL_TRX_ASSOCT_ASGN

RETAIL TRANSACTION ASSOCIATE ASSIGNMENT

DWB_RTL_TRX_DISC_LI_AUDIT

RETAIL TRANSACTION DISCOUNT LINE ITEM AUDIT

DWB_RTL_TRX_LI

RETAIL TRANSACTION LINE ITEM

DWB_RTL_TRX_LI_ASGN

RETAIL TRANSACTION LINE ITEM ASSIGNMENT

DWB_RTL_TRX_LI_GRP

RETAIL TRANSACTION LINE ITEM GROUP

DWB_RTL_TRX_MISC_LI

RETAIL TRANSACTION MISC LINE ITEM

DWB_RTL_TRX_SHPMNT

RETAIL TRANSACTION SHIPMENT

DWB_RTL_TRX_SHPMNT_ITEM

RETAIL TRANSACTION SHIPMENT ITEM

DWB_RTL_VALTN_LDGR_ACCT_HIST

RETAIL VALUATION LEDGER ACCOUNT HISTORY

DWB_RTLR_PYMT

RETAILER PAYMENT

DWB_RTLR_VNDR_ASGND_STAT

RETAILER VENDOR ASSIGNED STATUS

DWB_SCHL_EVT

SCHEDULE EVENT

DWB_SCL_EQPMNT_STTSTCS_RDNG

SCALE EQUIPMENT STATISTICS READING

DWB_SCNR_EQPMNT_STTSTCS_RDNG

SCANNER EQUIPMENT STATISTICS READING

DWB_SERVER_STAT_HIST

SERVER STATUS HISTORY

DWB_SESSION

SESSION

DWB_SGNTR_EQMT_CPTR_STSTS_RDNG

SIGNATURE EQUIPMENT CAPTURE STATISTICS READING

DWB_SKU_ITEM_BU_SLNG_PRC

SKU ITEM BUSINESS UNIT SELLING PRICE

DWB_SKU_ITEM_SLNG_PRICE

SKU ITEM SELLING PRICE

DWB_SKU_ITEM_SLNG_PRICE_HIST

SKU ITEM SELLING PRICE HISTORY

DWB_SL_METER_RDNG

SALES METER READING

DWB_SL_PLAN_ITEM_ORG_HRCHY_WK

SALES PLAN ITEM ORG HIERARCHY WEEK

DWB_SL_RETRN_TAX_OVRRD_MDFR

SALE RETURN TAX OVERRIDE MODIFIER

DWB_SRLZD_UNIT_MDFR

SERIALIZED UNIT MODIFIER

DWB_STCK_LDGR_ACCT_HIST

STOCK LEDGER ACCOUNT HISTORY

DWB_STCK_LDGR_JRNL_ENTRY

STOCK LEDGER JOURNAL ENTRY

DWB_STCK_METER_RDNG

STOCK METER READING

DWB_SURVEY_RESPN_DTL

SURVEY RESPONSE DETAIL

DWB_SURVEY_RESPN_HDR

SURVEY RESPONSE HEADER

DWB_TANK_RDNG

TANK READING

DWB_TANK_TEMP_RDNG

TANK TEMPERATURE READING

DWB_TAX_LI

TAX LINE ITEM

DWB_TAX_LI_AUDIT

TAX LINE ITEM AUDIT

DWB_TILL_HIST

TILL HISTORY

DWB_TILL_TAX_HIST

TILL TAX HISTORY

DWB_TILL_TNDR_HIST

TILL TENDER HISTORY

DWB_TIME_PUNCH_APRVL

TIME PUNCH APPROVAL

DWB_TIME_PUNCH_CORRECTION

TIME PUNCH CORRECTION

DWB_TNDR_ATHRZTN

TENDER AUTHORIZATION

DWB_TNDR_ATHRZTN_REVERSAL

TENDER AUTHORIZATION REVERSAL

DWB_TNDR_CNTRL_TRX

TENDER CONTROL TRANSACTION

DWB_TNDR_CNTRL_TRX_TNDR_LI

TENDER CONTROL TRANSACTION TENDER LINE ITEM

DWB_TNDR_LI_DENMTN

TENDER LINE ITEM DENOMINATION

DWB_TONE_IND_EQPMT_STSTCS_RDNG

TONE INDICATOR EQUIPMENT STATISTICS READING

DWB_TRMS_MASTER

TERMS MASTER

DWB_TRX_ASGN

TRANSACTION ASSIGNMENT

DWB_VDR_ITM_CTLG_BASE_COST_BRK

VENDOR ITEM CATALOG BASE COST BREAK

DWB_VNDR_ITEM_CTLG_BASE_COST

VENDOR ITEM CATALOG BASE COST

DWB_VNDR_RTNG

VENDOR RATING

DWB_VNDR_SKU_COST_DAY

VENDOR SKU COST PROFIT DAY

DWB_VNDR_STAT

VENDOR STATUS

DWB_VOID_LI

VOIDS LINE ITEM


Derived Tables

Table 3-4 lists the derived tables. The source and target tables and the scripts that populate the derived tables are described in "Intra-ETL Packages for Populating Derived Tables".

Table 3-4 Derived Tables

Table Name Description

DWD_ACCT_PAYBL_DAY

ACCOUNT PAYABLE DAY DERIVED

DWD_ACCT_RCVBL_DAY

ACCOUNT RECEIVABLE DAY DERIVED

DWD_ACTVTY_RQST_DAY

ACTIVITY REQUEST DAY DERIVED

DWD_ASSTS_DAY

ASSETS DAY DERIVED

DWD_CARRIER_CMPLNC_DAY

CARRIER COMPLIANCE DAY DERIVED

DWD_COST_DAY

COST DAY DERIVED

DWD_CRTFCT_ACTVTY_TRX

CERTIFICATE ACTIVITY TRANSACTION DERIVED

DWD_CUST_EMP_RLTNSHP_DAY

CUSTOMER EMPLOYEE RELATIONSHIP DAY DERIVED

DWD_CUST_ORDR_LI_STATE

CUSTOMER ORDER LINE ITEM STATE DERIVED

DWD_CUST_RFMP_SCR

CUSTOMER RFMP SCORE

DWD_CUST_SKU_SL_RETRN_DAY

CUSTOMER SKU SALE RETURN DAY DERIVED

DWD_CUST_TYP_ORDR_ITEM_DAY

CUSTOMER TYPE ORDER ITEM DAY DERIVED

DWD_EMP_LBR

EMPLOYEE LABOR DERIVED

DWD_EMP_WG_PYMT_DAY

EMPLOYEE WAGE PAYMENT DAY DERIVED

DWD_INV_ADJ_ITEM_DAY

INVENTORY ADJUSTMENT ITEM DAY DERIVED

DWD_INV_POSN_ITEM_DAY

INVENTORY POSITION ITEM DAY DERIVED

DWD_INV_RCPT_ITEM_DAY

INVENTORY RECEIPT ITEM DAY DERIVED

DWD_INV_UNAVL_ITEM_DAY

INVENTORY UNAVAILABLE ITEM DAY DERIVED

DWD_INV_VNDR_CMPLNC_DAY

INVENTORY VENDOR COMPLIANCE DAY DERIVED

DWD_INV_XFER_ITEM_DAY

INVENTORY TRANSFER ITEM DAY DERIVED

DWD_LIAB_DAY

LIABILITY DAY DERIVED

DWD_ORG_BSNS_UNT_HRS_DAY

ORGANIZATION BUSINESS UNIT HOURS DAY DERIVED

DWD_ORG_BSNS_UNT_TRFC_DAY

ORGANIZATION BUSINESS UNIT TRAFFIC DAY DERIVED

DWD_PCHSE_ORDR_LI_STATE

PURCHASE ORDER LINE ITEM STATE DERIVED

DWD_PCHSE_ORDR_STATE

PURCHASE ORDER STATE DERIVED

DWD_POS_CNTRL

POS CONTROL

DWD_POS_RTL

POS RETAIL

DWD_POS_STORE_FINCL

POS STORE FINANCIAL

DWD_POS_TNDR_FLOW

POS TENDER FLOW

DWD_RTL_MRKDN_ITEM_DAY

RETAIL MARKDOWN ITEM DAY DERIVED

DWD_RTL_SL_RETRN_ITEM_DAY

RETAIL SALE RETURN ITEM DAY DERIVED

DWD_RTL_TNDR_HIST

RETAIL TENDER HISTORY DERIVED

DWD_RTL_TRX_EMP_WRKSTN_DAY

RETAIL TRANSACTION EMP WORKSTATION DAY DERIVED

DWD_RTV_ITEM_DAY

RETURN TO VENDOR ITEM DAY DERIVED

DWD_SPACE_UTLZTN_ITEM_DAY

SPACE UTILIZATION ITEM DAY DERIVED

DWD_TILL

TILL DERIVED

DWD_VNDR_CMPLNC_ITEM_DAY

VENDOR COMPLIANCE ITEM DAY DERIVED


Aggregate Tables

Table 3-5 describes the Aggregate tables in Oracle Retail Data Model.

Table 3-5 Aggregate Tables

Table Name Description

DWA_ACCT_PAYBL_MO

ACCOUNT PAYABLE MONTH AGGR

DWA_ACCT_RCVBL_MO

ACCOUNT RECEIVABLE MONTH AGGR

DWA_ACTVTY_RQST_MO

ACTIVITY REQUEST MONTH AGGR

DWA_ASSTS_MO

ASSETS MONTH AGGR

DWA_CARRIER_CMPLNC_WK

CARRIER COMPLIANCE WEEK AGGR

DWA_COST_MO

COST MONTH AGGR

DWA_CRTFCT_ACTVTY_DAY

CERTIFICATE ACTIVITY DAY AGGR

DWA_CUST_EMP_RLTNSHP_MO

CUSTOMER EMPLOYEE RELATIONSHIP MONTH AGGR

DWA_CUST_EMP_SL_RETRN_MO

CUSTOMER EMPLOYEE SALE RETURN MONTH AGGR

DWA_CUST_TYP_ORDR_DEPT_MO

CUSTOMER TYPE ORDER DEPARTMENT MONTH AGGR

DWA_CUST_TYP_ORDR_SBC_WK

CUSTOMER TYPE ORDER SUBCLASS WEEK AGGR

DWA_INV_POSN_DEPT_DAY

INVENTORY POSITION DEPT DAY AGGRINVENTORY POSITION DEPT DAY AGGR

DWA_INV_POSN_SBC_MO

INVENTORY POSITION SUBCLASS MONTH AGGR

DWA_INV_RCPT_SBC_WK

INVENTORY RECEIPT SUBCLASS WEEK AGGR

DWA_LIAB_MO

LIABILITY MONTH AGGR

DWA_PCHSE_ORDR_DEPT_MO

PURCHASE ORDER DEPARTMENT MONTH AGGR

DWA_PCHSE_ORDR_LI_DAY

PURCHASE ORDER LINE ITEM DAY AGGR

DWA_PCHSE_ORDR_LI_MO

PURCHASE ORDER LINE ITEM MONTH AGGR

DWA_PCHSE_ORDR_SBC_DAY

PURCHASE ORDER SUBCLASS DAY AGGR

DWA_POS_RTL_EMP_MO

POS RETAIL EMPLOYEE MONTH AGGR

DWA_RTL_SL_RETRN_DEPT_DAY

RETAIL SALE RETURN DEPARTMENT DAY AGGR

DWA_RTL_SL_RETRN_SBC_MO

RETAIL SALE RETURN SUBCLASS MONTH AGGR

DWA_RTV_DEPT_DAY

RETURN TO VENDOR DEPARTMENT DAY AGGR

DWA_RTV_SBC_MO

RETURN TO VENDOR SUBCLASS MONTH AGGR

DWA_SPACE_UTLZTN_DEPT_DAY

SPACE UTILIZATION DEPARTMENT DAY AGGR


Control and Configuration Tables

Table 3-6 describes the Control and Configuration tables in Oracle Retail Data Model.

Table 3-6 Control and Configuration Tables

Table Name Description

DWC_CRNCY_CONF

CURRENCY CONFIGURATION

DWC_ETL_PARAMETER

For more information, see "Intra-ETL Load Parameters Control Table".

DWC_INTRA_ETL_ACTIVITY

For more information, see "Intra-ETL Monitoring Process Control Tables".

DWC_INTRA_ETL_PROCESS

For more information, see "Intra-ETL Monitoring Process Control Tables".

DWC_MESSAGE

 

DWC_OLAP_ETL_PARAMETER

For more information, see "Intra-ETL OLAP Mapping Control Table".

DWC_UOM_CONF

UNIT OF MEASURE CONFIGURATION


Metadata Tables and Views

Metadata tables for Oracle Retail Data Model are listed in Table 3-7.

For more information, see Oracle Retail Data Model Implementation and Operations Guide.

Table 3-7 Metadata Tables

Table Name Description

MD_DRVD_KPI

This table separates derived KPI from RPD. In MD_KPI and MD_REF_ENTY_KPI table Measures are mixed with dimension data; this view only contains derived measures created for the RPD.

MD_ENTY

Stores data about logical data model entities, their descriptions, and physical table names.

MD_ENTY_VIEW

This view is created to contain similar content as MD_ENTY. This view provides a drill down option in the reports.

MD_KPI

Contains distinct presentation columns, dashboard folder name as subject area, and computation logic for the KPI and subject area used in the RPD.

MD_PRG

Store all the information of the programs. Programs may be packages used to store the data in Derived tables, Mining tables, Reports, Cubes, or MVs, and so on.

MD_PRG_VIEW

This view is created to contain similar content as MD_PRG. This view provides a drill down option in the reports.

MD_REF_ENTY_KPI

Contains physical table and columns that are used for the particular KPI along with other columns.


Note:

The metadata related scripts are located in the folder: $ORACLE_HOME/ordm/utilities/meta_data

Database Sequences

Database sequences for Oracle Retail Data Model are listed in Table 3-8.

Table 3-8 Database Sequences

Sequence Name Generates the Physical Key for This Table

CUST_SGMNT_SEQ

DWR_CUST_SGMNT

CUST_SGMNT_SEQ

DWC_INTRA_ETL_ACTIVITY

DAY_TODATE_TRANS_SEQ

DWR_DAY_TODATE_TRANS

DAY_TRANS_SEQ

DWR_DAY_TRANS

HLF_MO_TODATE_TRANS_SEQ

DWR_HLF_MO_TODATE_TRANS

HLF_YR_TODATE_TRANS_SEQ

DWR_HLF_YR_TODATE_TRANS

INTRA_ETL_PROCESS_SEQ

DWC_INTRA_ETL_PROCESS

MO_TRANS_SEQ

DWR_MO_TRANS

QTR_TODATE_TRANS_SEQ

DWR_QTR_TODATE_TRANS

QTR_TRANS_SEQ

DWR_QTR_TRANS

WK_TODATE_TRANS_SEQ

DWR_WK_TODATE_TRANS

WK_TRANS_SEQ

DWR_WK_TRANS

YR_TRANS_SEQ

DWR_YR_TRANS


Oracle Retail Data Model OLAP Cube MVs, OLAP Views

Oracle Retail Data Model data warehouse includes OLAP multidimensional cubes that support OLAP analysis and forecasting. The physical model of the Oracle Retail Data Model OLAP component is defined by the ordm_sys schema.

Table 3-9 shows the OLAP Cube Materialized Views in ordm_sys schema.

Table 3-9 OLAP Cube Materialized View in ordm_sys Schema

Cube Materialized View Name OLAP Object Name OLAP Object Type More Information

CB$INV

INV

Cube

Inventory Cube: INV

CB$ORGANIZATION_HBANNER

ORGANIZATION_HBANNER

Dimension_Hierarchy

Organization: ORGANIZATION

CB$ORGANIZATION_HDIVISION

ORGANIZATION_HDIVISION

Dimension_Hierarchy

Organization: ORGANIZATION

CB$ORGANIZATION_HORG

ORGANIZATION_HORG

Dimension_Hierarchy

Organization: ORGANIZATION

CB$ORGQR_HORG

ORGQR_HORG

Dimension_Hierarchy

Organization QR Dimension: ORGQR

CB$PRODQR_HPROD

PRODQR_HPROD

Dimension_Hierarchy

Product QR Dimension: PRODQR

CB$PRODUCT_HPCLUSTER

PRODUCT_HPCLUSTER

Dimension_Hierarchy

Product: PRODUCT

CB$PRODUCT_HPROD

PRODUCT_HPROD

Dimension_Hierarchy

Product: PRODUCT

CB$SLS

SLS

Cube

Sales Cube: SLS

CB$SLSQR

SLSQR

Cube

Sales Cube - Cube based QR enabled: SLSQR

CB$TIME_HCLNDR

TIME_HCLNDR

Dimension_Hierarchy

Time:TIME

CB$TIME_HCLNDRWK

TIME_HCLNDRWK

Dimension_Hierarchy

Time:TIME

CB$TIME_HTBSNS

TIME_HTBSNS

Dimension_Hierarchy

Time:TIME

CB$TIMEQR_HTBSNS

TIMEQR_HTBSNS

Dimension_Hierarchy

Time QR Dimension:TIMEQR


Table 3-10 shows OLAP Views in ordm_sys schema.

Table 3-10 OLAP Views in ordm_sys Schema

View Name OLAP Object Name OLAP Object Type More Information

ACTRQSTTYP_HACTRQSTTYP_VIEW

ACTRQSTTYP_HACTRQSTTYP

Dimension_Hierarchy

Activity Request Type Hierarchy (HACTRQSTTYP): ACTRQSTTYP

ACTRQSTTYP_VIEW

ACTRQSTTYP

Dimension

Activity Request Type: ACTRQSTTYP

ASSTTYPE_HASSTTYPE_VIEW

ASSTTYPE_HASSTTYPE

Dimension_Hierarchy

Assets Type Hierarchy (HASSTTYPE): ASSTTYPE

ASSTTYPE_VIEW

ASSTTYPE

Dimension

Assets Type: ASSTTYPE

BUSHIFT_HBUSHIFT_VIEW

BUSHIFT_HBUSHIFT

Dimension_Hierarchy

Business Unit Shift Hierarchy (HBUSHIFT): BUSHIFT

BUSHIFT_VIEW

BUSHIFT

Dimension

Business Unit Shift: BUSHIFT

CARRIER_HCARRIER_VIEW

CARRIER_HCARRIER

Dimension_Hierarchy

Carrier Hierarchy (HCARRIER): CARRIER

CARRIER_VIEW

CARRIER

Dimension

Carrier: CARRIER

CMPGNMEDIA_HCMPGN_VIEW

CMPGNMEDIA_HCMPGN

Dimension_Hierarchy

Campaign Hierarchy (HCMPGN): CMPGNMEDIA

CMPGNMEDIA_HMEDIA_VIEW

CMPGNMEDIA_HMEDIA

Dimension_Hierarchy

Media Hierarchy (HMEDIA): CMPGNMEDIA

CMPGNMEDIA_VIEW

CMPGNMEDIA

Dimension

Campaign Media: CMPGNMEDIA

CUSTOMER_HCUSTCLSTR_VIEW

CUSTOMER_HCUSTCLSTR

Dimension_Hierarchy

Customer Cluster Hierarchy (HCUSTCLSTR): CUSTOMER

CUSTOMER_HCUSTTYP_VIEW

CUSTOMER_HCUSTTYP

Dimension_Hierarchy

Customer Type Hierarchy (HCUSTTYP): CUSTOMER

CUSTOMER_VIEW

CUSTOMER

Dimension

Customer: CUSTOMER

EMPLOYEE_HEMPLOYEE_VIEW

EMPLOYEE_HEMPLOYEE

Dimension_Hierarchy

Employee Hierarchy (HEMPLOYEE): EMPLOYEE

EMPLOYEE_VIEW

EMPLOYEE

Dimension

Employee: EMPLOYEE

ENVTYPE_HENVTYPE_VIEW

ENVTYPE_HENVTYPE

Dimension_Hierarchy

Environment Type Hierarchy (HENVTYPE): ENVTYPE

ENVTYPE_VIEW

ENVTYPE

Dimension

Environment Type: ENVTYPE

INTRACNRSN_HINTRACNRSN_VIEW

INTRACNRSN_HINTRACNRSN

Dimension_Hierarchy

Interaction Reason Hierarchy (HINTRACNRSN): INTRACNRSN

INTRACNRSN_VIEW

INTRACNRSN

Dimension

Interaction Reason: INTRACNRSN

INTRACNSTAT_HINTRACNSTAT_VIEW

INTRACNSTAT_HINTRACNSTAT

Dimension_Hierarchy

Interaction Status Hierarchy (HINTRACNSTAT): INTRACNSTAT

INTRACNSTAT_VIEW

INTRACNSTAT

Dimension

Interaction Status: INTRACNSTAT

INTRACNTYP_HINTRACNTYP_VIEW

INTRACNTYP_HINTRACNTYP

Dimension_Hierarchy

Interaction Type Hierarchy (HINTRACNTYP): INTRACNTYP

INTRACNTYP_VIEW

INTRACNTYP

Dimension

Interaction Type: INTRACNTYP

INVLOC_HINVLOC_VIEW

INVLOC_HINVLOC

Dimension_Hierarchy

Inventory Location Hierarchy (HINVLOC): INVLOC

INVLOC_VIEW

INVLOC

Dimension

Inventory Location: INVLOC

LIABTYP_HLIABTYP_VIEW

LIABTYP_HLIABTYP

Dimension_Hierarchy

Liability Type Hierarchy (HLIABTYP): LIABTYP

LIABTYP_VIEW

LIABTYP

Dimension

Liability Type: LIABTYP

ORDRTYP_HORDRTYP_VIEW

ORDRTYP_HORDRTYP

Dimension_Hierarchy

Order Type Hierarchy (HORDRTYP): ORDRTYP

ORDRTYP_VIEW

ORDRTYP

Dimension

Order Type: ORDRTYP

ORGANIZATION_VIEW

ORGANIZATION

Dimension

Organization: ORGANIZATION

ORGQR_HORG_VIEW

ORGQR_HORG

Dimension_Hierarchy

Organization Hierarchy (HORG): ORGQR

ORGQR_VIEW

ORGQR

Dimension

Organization QR Dimension: ORGQR

ORG_HBANNER_VIEW

ORGANIZATION_HBANNER

Dimension_Hierarchy

Organization Banner Hierarchy (HBANNER): ORGANIZATION

ORG_HDIVISION_VIEW

ORGANIZATION_HDIVISION

Dimension_Hierarchy

Organization Division Hierarchy (HDIVISION): ORGANIZATION

ORG_HORG_VIEW

ORGANIZATION_HORG

Dimension_Hierarchy

Organization Hierarchy (HORG): ORGANIZATION

PAYTYPE_HPAYTYPE_VIEW

PAYTYPE_HPAYTYPE

Dimension_Hierarchy

Pay Type Hierarchy (HPAYTYPE): PAYTYPE

PAYTYPE_VIEW

PAYTYPE

Dimension

Pay Type: PAYTYPE

POSTCD_HPOSTCD_VIEW

POSTCD_HPOSTCD

Dimension_Hierarchy

Postcode Hierarchy (HPOSTCD): POSTCD

POSTCD_VIEW

POSTCD

Dimension

Post Code: POSTCD

PRODQR_HPROD_VIEW

PRODQR_HPROD

Dimension_Hierarchy

Product Hierarchy (HPROD): PRODQR

PRODQR_VIEW

PRODQR

Dimension

Product QR Dimension: PRODQR

PRODUCT_VIEW

PRODUCT

Dimension

Product: PRODUCT

PROD_HPCLUSTER_VIEW

PRODUCT_HPCLUSTER

Dimension_Hierarchy

Product Cluster Hierarchy (HPCLUSTER): PRODUCT

PROD_HPROD_VIEW

PRODUCT_HPROD

Dimension_Hierarchy

Product Hierarchy (HPROD): PRODUCT

REASON_HREASON_VIEW

REASON_HREASON

Dimension_Hierarchy

Reason Hierarchy (HREASON): REASON

REASON_VIEW

REASON

Dimension

Reason: REASON

RFMP_HRFMP_VIEW

RFMP_HRFMP

Dimension_Hierarchy

RFMP Hierarchy (HRFMP): RFMP

RFMP_VIEW

RFMP

Dimension

RFMP: RFMP

RQSTORIGIN_HRQSTORIGIN_VIEW

RQSTORIGIN_HRQSTORIGIN

Dimension_Hierarchy

Request Origin Hierarchy (HRQSTORIGIN): RQSTORIGIN

RQSTORIGIN_VIEW

RQSTORIGIN

Dimension

Request Origin: RQSTORIGIN

TIMEQR_HTBSNS_VIEW

TIMEQR_HTBSNS

Dimension_Hierarchy

Time Business Hierarchy (HTBSNS): TIMEQR

TIMEQR_VIEW

TIMEQR

Dimension

Time QR Dimension: TIMEQR

TIME_HCLNDRWK_VIEW

TIME_HCLNDRWK

Dimension_Hierarchy

Time Calendar Week Hierarchy (HCLNDRWK): TIME

TIME_HCLNDR_VIEW

TIME_HCLNDR

Dimension_Hierarchy

Time Calendar Hierarchy (HCLNDR): TIME

TIME_HTBSNS_VIEW

TIME_HTBSNS

Dimension_Hierarchy

Time Business Hierarchy (HTBSNS): TIME

TIME_VIEW

TIME

Dimension

Time: TIME

TOUCHPOINT_HTOUCHPOINT_VIEW

TOUCHPOINT_HTOUCHPOINT

Dimension_Hierarchy

Touchpoint Hierarchy (HTOUCHPOINT): TOUCHPOINT

TOUCHPOINT_VIEW

TOUCHPOINT

Dimension

Touchpoint: TOUCHPOINT

UOMTYPE_HUOMTYPE_VIEW

UOM_HUOM

Dimension_Hierarchy

UOM Hierarchy (HUOM): UOM

UOMTYPE_VIEW

UOM

Dimension

Unit Of Measure: UOM

VENDORITEM_HVENDORITEM_VIEW

VENDORITEM_HVENDORITEM

Dimension_Hierarchy

Vendor Item Hierarchy (HVENDORITEM): VENDORITEM

VENDORITEM_VIEW

VENDORITEM

Dimension

Vendor Item: VENDORITEM

VENDOR_HVENDOR_VIEW

VENDOR_HVENDOR

Dimension_Hierarchy

Vendor Hierarchy (HVENDOR): VENDOR

VENDOR_VIEW

VENDOR

Dimension

Vendor: VENDOR

VNDRSITE_HVNDRSITE_VIEW

VNDRSITE_HVNDRSITE

Dimension_Hierarchy

Vendor Site Hierarchy (HVNDRSITE): VNDRSITE

VNDRSITE_VIEW

VNDRSITE

Dimension

Vendor Site: VNDRSITE

AR_VIEW

AR

Cube

Activity Request Cube

ASSET_VIEW

ASSET

Cube

Asset Cube

CC_VIEW

CC

Cube

Carrier Compliance Cube

CO_VIEW

CO

Cube

Customer Order Cube

CRFMPDC_VIEW

CRFMPDC

Cube

Customer RFMP DC Cube

CRFMP_VIEW

CRFMP

Cube

Customer RFMP Cube

CSSR_VIEW

CSSR

Cube

Customer SKU Sale Return Cube

EL_VIEW

EL

Cube

Employee Labor Cube

EWGP_VIEW

EWGP

Cube

Employee Wage Payment Cube

IA_VIEW

IA

Cube

Inventory Adjustment Cube

INV_FCST_STTSTC_VIEW

INV_FCST_STTSTC

Cube

Inventory Forecast Statistic Cube

INV_FCST_VIEW

INV_FCST

Cube

Inventory Forecast Cube

INV_VIEW

INV

Cube

Inventory Cube

IR_VIEW

IR

Cube

Inventory Receipt Cube

IU_VIEW

IU

Cube

Inventory Unavailable Cube

LIABILITY_VIEW

LIABILITY

Cube

Liability Cube

OBUH_VIEW

OBUH

Cube

Store Hours Cube

OBUT_VIEW

OBUT

Cube

Store Traffic Cube

POLIS_VIEW

POLIS

Cube

Purchase Order Line Item State Cube

POS_VIEW

POS

Cube

Purchase Order State Cube

RTEW_VIEW

RTEW

Cube

Retail Transaction Employee Workstation Cube

SLPLN_VIEW

SLPLN

Cube

Sales Plan Item Organization Hierarchy Cube

SLSQR_VIEW

SLSQR

Cube

Sales Cube - Cube based QR enabled

SLS_FCST_STTSTC_VIEW

SLS_FCST_STTSTC

Cube

Sales Cube Forecast Statistic

SLS_FCST_VIEW

SLS_FCST

Cube

Sales Cube Forecast

SLS_VIEW

SLS

Cube

Sales Cube

SU_VIEW

SU

Cube

Space Utilization Cube

VC_VIEW

VC

Cube

Vendor Compliance Cube


Oracle Retail Data Model Relational MVs

Oracle Retail Data Model data warehouse includes Relational MVs. Table 3-11 shows the relational MVs in ordm_sys schema.

Table 3-11 Oracle Retail Data Model Relational MVs

Name Description

DWA_ACCT_PAYBL_MO

Account Payable Month level MV

DWA_ACCT_RCVBL_MO

Account Receivable Month level MV

DWA_ACTVTY_RQST_MO

Activity Request Month level MV

DWA_ASSTS_MO

Assets Month level MV

DWA_CARRIER_CMPLNC_WK

Carrier Compliance Week level MV

DWA_COST_MO

Cost Month level MV

DWA_CRTFCT_ACTVTY_DAY

Certificate Activity Day level MV

DWA_CUST_EMP_RLTNSHP_MO

Customer Employee Relationship Month level MV

DWA_CUST_EMP_SL_RETRN_MO

Customer Employee Sale Return Month level MV

DWA_CUST_TYP_ORDR_DEPT_MO

Orders at Customer Type, Department, Month level MV

DWA_CUST_TYP_ORDR_SBC_WK

Orders at Customer Type, Subclass, Week level MV

DWA_INV_POSN_DEPT_DAY

Inventory Position by Department Day level MV

DWA_INV_POSN_SBC_MO

Inventory Position By Subclass by Month level MV

DWA_INV_RCPT_SBC_WK

Inventory Receipt by SubClass Week level MV

DWA_LIAB_MO

Liabilities Month level MV

DWA_PCHSE_ORDR_DEPT_MO

Purchase Order at Department, Month level MV

DWA_PCHSE_ORDR_LI_DAY

Purchase Order Lineitem Day level MV

DWA_PCHSE_ORDR_LI_MO

Purchase Order Lineitem Month level MV

DWA_PCHSE_ORDR_SBC_DAY

Purchase Order at Subclass, Day level MV

DWA_POS_RTL_EMP_MO

POS Retail Employee Month level MV

DWA_RTL_SL_RETRN_DEPT_DAY

Retail Sale Return Department Day level MV

DWA_RTL_SL_RETRN_SBC_MO

Retail Sale Return Subclass Month level MV

DWA_RTV_DEPT_DAY

Return to Vendor Department Day level MV

DWA_RTV_SBC_MO

Return to Vendor Subclass Month level MV

DWA_SPACE_UTLZTN_DEPT_DAY

Space Allocation Department Day level MV


Oracle Retail Data Model Relational Views

Oracle Retail Data Model data warehouse includes Relational Views. Table 3-12 shows the relational views in ordm_sys schema.

Table 3-12 Relational Views in ordm_sys Schema

Name Description

DWV_CUST_RFMP_SCR_VIEW

View defined over derived table DWD_CUST_RFMP_SCR and RFMP Dimension table. This is used to load the Customer RFMP Cubes in ORDM OLAP.

DWA_INV_POSN_SBC_MO_VIEW

View defined over Day level Derived table DWD_INV_POSN_ITEM_DAY and Product, Time Dimension tables. This View is used to get the last value of Inventory Position at Subclass and Month level. This view is utilized by Relational Materialized View DWA_INV_POSN_SBC_MO in its definition.

DWV_TIME_BSNS_QTR

View defined at Business Quarter level containing data and attributes of BSNS_QTR level and also those of higher levels (BSNS_HLF_YR, BSNS_YR) as additional columns. Used for Time Series Intelligence implementation in relational reports.

DWV_TIME_BSNS_WK

View defined at Business Quarter level containing data and attributes of BSNS_QTR level and also those of higher levels (BSNS_HLF_YR, BSNS_YR) as additional columns. Used for Time Series Intelligence implementation in relational reports.

DWV_TIME_BSNS_MO

View defined at Business Month level containing data and attributes of BSNS_MO level and also those of higher levels (BSNS_QTR, BSNS_HLF_YR, BSNS_YR) as additional columns. Used for Time Series Intelligence implementation in relational reports.

DWV_TIME_BSNS_HLF_YR

View defined at Business Half Year level containing data and attributes of BSNS_HLF_YR level and also those of higher levels (BSNS_YR) as additional columns. Used for Time Series Intelligence implementation in relational reports.

DWV_TIME_BSNS_YR

View defined at Business Year level containing data and attributes of BSNS_YR level.Used for Time Series Intelligence implementation in relational reports.

DWV_TIME_BSNS_HLF_MO

View defined at Business Half Month level containing data and attributes of BSNS_HLF_MO level and also those of higher levels (BSNS_MO, BSNS_QTR, BSNS_HLF_YR, BSNS_YR) as additional columns. Used for Time Series Intelligence implementation in relational reports.

CUBE_BUILD_LATEST

View defined over CUBE_BUILD_LOG. View contains only the rows for the last build.

CUBE_BUILD_REPORT

View defined over CUBE_BUILD_LOG table. Used to package the log data into a more readable format (collapses all rows for a single command into one summary row). Contains summary reports relating to all OLAP loads/builds in the schema.

CUBE_BUILD_REPORT_LATEST

View defined over view CUBE_BUILD_REPORT. Contains a summary report of the latest load/build in the schema.

SLS_VIEW_OLAPC

View used by ORDM OLAP. This is an OLAP view utilizing OLAP_TABLE function and includes the OLAPC generic runtime computational Measure in the OLAP view.

SLS_VIEW_FIN

View used by ORDM OLAP. This view provides an addition for the specific case of reports involving the OLAP_CALC measure. The view SLS_VIEW_FIN is expected to be used for SQL based Reporting of Sales Cube involving the OLAP_CALC Measure in ORDM OLAP. ORDM OLAP Reporting for Sales Cube uses the default SLS_VIEW view in addition to SLS_VIEW_FIN.


Oracle Retail Data Model Data Mining MVs

Oracle Retail Data Model data warehouse includes data mining MVs.

Table 3-13 shows the data mining MVs in ordm_sys schema.

Table 3-13 Data Mining MVs in ordm_sys Schema

Name Description

DMV_CUST_ACCT_SRC

Data source for customer mining models. Captures customer demographic information and purchase behavior.

DMV_CUST_INTRACN_CMNT

Data source for customer sentiment mining model. Captures customer comments from different media.

DMV_CUST_LTY_SRC

Data source for customer loyalty mining model. Captures customer demographic information and purchase behavior.

DMV_EMP_BAS_SRC

Data source for employee basket analysis mining model. Captures employee demographic information and baskets information.

DMV_EMP_SHFT_DAY

Data source for employee combination mining model. Captures employee demographic information and sales information.

DMV_EMP_SLS_SRC

Data source for employee sales analysis mining model. Captures employee demographic information and sales information.

DMV_ITM_POS_LOSS_SRC

Data source for item point of sales loss mining model. Captures item characteristics and item sales, shrink, and theft information.

DMV_PROD_DEPT_MIX_SRC

Data source for product department association rules mining model. Captures transactional data at product department level.

DMV_PROD_PRMTNL_SLS_SRC

Data source for product price elasticity mining model. Captures SKU item promotional sales information.

DMV_STR_DEPT_DTLS_SRC

Data source for product department association rules mining model. Captures Sales of product departments at store level.

DMV_STR_LOSS_SRC

Data source for store loss mining model. Captures store characteristics and store sales, shrink, and theft information.