Physical Data Model of Oracle Retail Data Model

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:

Data Mining component. The physical model of the data mining component is defined by the ordm_sys schema.
OLAP Component. The physical model of the OLAP component is defined by the ordm_sys schema.

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_EVT_TYP	EVENT 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_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_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_THEFT_TYP	THEFT TYPE
DWL_TILL_LMT_TYP	TILL LIMIT TYPE
DWL_TILL_MOVEMENT_DRCTN	TILL MOVEMENT DIRECTION
DWL_TNDR_CLASS	TENDER CLASS
DWL_TNDR_CNTRL_TRX_TYP	TENDER CONTROL TYPE
DWL_TNDR_RPSTRY_CLASS	TENDER REPOSITORY CLASS
DWL_TOT_TYP	TOTAL TYPE
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_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_HIST	RETAIL TENDER HISTORY
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_SL_RETRN_ITEM_DAY	RETAIL SALE RETURN ITEM DAY 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 AGGR INVENTORY 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.

3 Physical Data Model of Oracle Retail Data Model