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

8 Oracle Retail Data Model OLAP Dimensions

This chapter describes the data flow between fact tables and dimension tables of Oracle Retail Data Model relational tables to target materialized views and cubes to support the OLAP module in Oracle Retail Data Model.

For more information, see Chapter 9, "Oracle Retail Data Model OLAP Cubes".

OLAP Dimensions Overview

Table 8-1 lists the OLAP dimensions and each dimension description includes the following information:

The dimensional data model is an integral part of On-Line Analytical Processing (OLAP). A dimensional data model is as much a logical model as a physical model. Conceptually, a dimensional data model is composed of cubes, measures, dimensions, hierarchies, levels, and attributes.

For a more complete introduction to the OLAP dimensional models, see Oracle OLAP User's Guide.

Tip:

In general, it is not recommended to modify the dimensions/cubes provided by Oracle Retail Data Model.

There are certain changes to existing dimensions, such as defining new attributes, creating additional hierarchies, defining additional dimensions, additional cubes or additional measures in existing cubes which are possible and do not break the existing OLAP model.

You can make these changes; However these changes are not supported in that any issues arising out of the modified model will not be supported or treated as bugs.

At the same time, certain other changes are also possible, such as introducing a new level within an existing hierarchy, modifying the mapping for existing attributes, level definitions, descriptions, and so on. These changes are more disruptive in nature and greater care needs to be exercised while making these changes.

Note that most of these changes would typically impact other modules in Oracle Retail Data Model such as Reporting (corresponding modifications would be needed to the Reporting rpd, Reports, and so on).

Activity Request Type: ACTRQSTTYP

This dimension stores the Activity Request Types used in Oracle Retail Data Model.

Default Hierarchy: HACTRQSTTYP

Table 8-2 Activity Request Type Hierarchy (HACTRQSTTYP)

Level Description Activity Request Type Hierarchy (HACTRQSTTYP)

TACTRQSTTYP

Total Activity Request Type

TACTRQSTTYP

ACTRQSTTYP

Activity Request Type

ACTRQSTTYP


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-3 Activity Request Type Long Description Attribute Mapping

Level Mapping (Physical Column)

TACTRQSTTYP

'Total Activity Request Type'

ACTRQSTTYP

DWL_ACTVTY_RQST_TYP.ACTVTY_RQST_TYP_NAME


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-4 Activity Request Type Short Description Attribute Mapping

Level Mapping (Physical Column)

TACTRQSTTYP

'Total Activity Request Type'

ACTRQSTTYP

DWL_ACTVTY_RQST_TYP.ACTVTY_RQST_TYP_CD


Assets Type: ASSTTYPE

This dimension stores the Assets Types used in Oracle Retail Data Model.

Default Hierarchy: HASSTTYPE

Table 8-5 Assets Type Hierarchy (HASSTTYPE)

Level Description Assets Type Hierarchy (HASSTTYPE)

TASSTTYPE

Total Assets Type

TASSTTYPE

ASSTTYPE

Assets Type

ASSTTYPE


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-6 Assets Type Long Description Attribute Mapping

Level Mapping (Physical Column)

TASSTTYPE

'Total Assets Type'

ASSTTYPE

DWL_ASSTS_TYP.ASSTS_TYP_NAME


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-7 Assets Type Short Description Attribute Mapping

Level Mapping (Physical Column)

TASSTTYPE

'Total Assets Type'

ASSTTYPE

DWL_ASSTS_TYP.ASSTS_TYP_CD


Business Unit Shift: BUSHIFT

This dimension stores the Business Unit Shifts used in Oracle Retail Data Model.

Default Hierarchy: HBUSHIFT

Table 8-8 Business Unit Shift Hierarchy (HBUSHIFT)

Level Description Business Unit Shift Hierarchy (HBUSHIFT)

TBUSHIFT

Total Business Unit Shift

TBUSHIFT

SHIFTTYPE

Shift Type

SHIFTTYPE

BUSHIFT

Business Unit Shift

BUSHIFT


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-9 Business Unit Shift Long Description Attribute Mapping

Level Mapping (Physical Column)

TBUSHIFT

'Total Business Unit Shift'

SHIFTTYPE

DWL_SHFT_TYP.SHFT_TYP_NAME

BUSHIFT

DWR_BSNS_UNIT_SHFT.NAME


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-10 Business Unit Shift Short Description Attribute Mapping

Level Mapping (Physical Column)

TBUSHIFT

'Total Business Unit Shift'

SHIFTTYPE

DWL_SHFT_TYP.SHFT_TYP_CD

BUSHIFT

DWR_BSNS_UNIT_SHFT.BSNS_UNIT_SHFT_CD


Carrier: CARRIER

This dimension stores the Carriers used in Oracle Retail Data Model.

Default Hierarchy: HCARRIER

Table 8-11 Carrier Hierarchy (HCARRIER)

Level Description Carrier Hierarchy (HCARRIER)

TCARRIER

Total Carrier

TCARRIER

CARRIER

Carrier

CARRIER


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-12 Carrier Long Description Attribute Mapping

Level Mapping (Physical Column)

TCARRIER

'Total Carrier'

CARRIER

DWR_CARRIER.CARRIER_DESC


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-13 Carrier Short Description Attribute Mapping

Level Mapping (Physical Column)

TCARRIER

'Total Carrier'

CARRIER

DWR_CARRIER.CARRIER_NAME


Campaign Media: CMPGNMEDIA

This dimension stores the data relating to the Campaigns, Media used in Oracle Retail Data Model.

Default Hierarchy: HMEDIA

Table 8-14 Media and Campaign Hierarchy (HCMPGN)

Level Description Media Hierarchy (HMEDIA) Campaign Hierarchy (HCMPGN)

TCM

Total Campaign Media

TCM

TCM

MEDIA

Media

MEDIA

 

CMPGN

Campaign

CMPGN

 

CMPGNMEDIA

Campaign Media

CMPGNMEDIA

CMPGNMEDIA


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-15 Campaign Media Long Description Attribute Mapping

Level Mapping (Physical Column)

TCM

'Total Campaign Media'

MEDIA

DWR_MEDIA.MEDIA_NAME

CMPGN

DWR_CMPGN.CMPGN_NAME

CMPGNMEDIA

DWR_CMPGN_MEDIA.LNG_DESC


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-16 Campaign Media Short Description Attribute Mapping

Level Mapping (Physical Column)

TCM

'Total Campaign Media'

MEDIA

DWR_MEDIA.MEDIA_CD

CMPGN

DWR_CMPGN.CMPGN_CD

CMPGNMEDIA

DWR_CMPGN_MEDIA.SHORT_DESC


Customer: CUSTOMER

This dimension stores the Customers used in Oracle Retail Data Model.

Default Hierarchy: HCUSTTYP

Table 8-17 Customer Type and Customer Cluster Hierarchy

Level Description Customer Type Hierarchy (HCUSTTYP) Customer Cluster Hierarchy (HCUSTCLSTR)

TCUST

Total Customer

TCUST

TCUST

CUSTTYP

Customer Type

CUSTTYP

 

CLSTR

Cluster

 

CLSTR

CUST

Customer

CUST

CUST


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-18 Customer Long Description Attribute Mapping

Level Mapping (Physical Column)

TCUST

'Total Customer'

CUSTTYP

DWL_CUST_TYP.CUST_TYP_DESC

CLSTR

DWR_CUST_CLSTR.CUST_CLSTR_DESC

CUST

DWR_CUST.FIRST_NAME || ' ' || DWR_CUST.LAST_NAME


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-19 Customer Short Description Attribute Mapping

Level Mapping (Physical Column)

TCUST

'Total Customer'

CUSTTYP

DWL_CUST_TYP.CUST_TYP_NAME

CLSTR

DWR_CUST_CLSTR.CUST_CLSTR_CD

CUST

DWR_CUST.CUST_NBR


Attribute Name: Frequent Shopper Indicator (FS_IND)

Table 8-20 Customer Frequent Shopper Indicator Attribute Mapping

Level Mapping (Physical Column)

TCUST

 

CUSTTYP

 

CLSTR

 

CUST

DWR_CUST.FREQ_SHOPR_IND


Attribute Name: Frequent Shopper Number (FS_NBR)

Table 8-21 Customer Frequent Shopper Number Attribute Mapping

Level Mapping (Physical Column)

TCUST

 

CUSTTYP

 

CLSTR

 

CUST

DWR_CUST.FREQ_SHOPR_NBR


Attribute Name: Customer Type (CUST_TYP)

Table 8-22 Customer Customer Type Attribute Mapping

Level Mapping (Physical Column)

TCUST

 

CUSTTYP

 

CLSTR

 

CUST

DWR_CUST.CUST_TYP


Attribute Name: Customer Number (CUST_NBR)

Table 8-23 Customer Number Attribute Mapping

Level Mapping (Physical Column)

TCUST

 

CUSTTYP

 

CLSTR

 

CUST

DWR_CUST.CUST_NBR


Attribute Name: City (CITY)

Table 8-24 Customer City Attribute Mapping

Level Mapping (Physical Column)

TCUST

 

CUSTTYP

 

CLSTR

 

CUST

DWR_CUST.CITY


Attribute Name: State (STATE)

Table 8-25 Customer State Attribute Mapping

Level Mapping (Physical Column)

TCUST

 

CUSTTYP

 

CLSTR

 

CUST

DWR_CUST.STATE


Attribute Name: Country (COUNTRY)

Table 8-26 Customer Country Attribute Mapping

Level Mapping (Physical Column)

TCUST

 

CUSTTYP

 

CLSTR

 

CUST

DWR_CUST.CNTRY


Employee: EMPLOYEE

This dimension stores the Employees used in Oracle Retail Data Model.

Default Hierarchy: HEMPLOYEE

Table 8-27 Employee Hierarchy (HEMPLOYEE)

Level Description Employee Hierarchy (HEMPLOYEE)

TEMPLOYEE

Total Employee

TEMPLOYEE

EMPLOYEETYPE

Employee Type

EMPLOYEETYPE

EMPLOYEE

Employee

EMPLOYEE


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-28 Employee Long Description Attribute Mapping

Level Mapping (Physical Column)

TEMPLOYEE

'Total Employee'

EMPLOYEETYPE

DWL_EMP_TYP.EMP_TYP_NAME

EMPLOYEE

DWR_EMP.FULL_NAME


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-29 Employee Short Description Attribute Mapping

Level Mapping (Physical Column)

TEMPLOYEE

'Total Employee'

EMPLOYEETYPE

DWL_EMP_TYP.EMP_TYP_CD

EMPLOYEE

DWR_EMP.EMP_NBR


Environment Type: ENVTYPE

This dimension stores the Environment Types used in Oracle Retail Data Model.

Default Hierarchy: HENVTYPE

Table 8-30 Environment Type Hierarchy (HENVTYPE)

Level Description Environment Type Hierarchy (HENVTYPE)

TENVTYPE

Total Environment Type

TENVTYPE

ENVTYPE

Environment Type

ENVTYPE


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-31 Environment Type Long Description Attribute Mapping

Level Mapping (Physical Column)

TENVTYPE

'Total Environment Type'

ENVTYPE

DWL_ENV_TYP.ENV_TYP_NAME


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-32 Environment Type Short Description Attribute Mapping

Level Mapping (Physical Column)

TENVTYPE

'Total Environment Type'

ENVTYPE

DWL_ENV_TYP.ENV_TYP_CD


Interaction Reason: INTRACNRSN

This dimension stores the Interaction Reasons used in Oracle Retail Data Model.

Default Hierarchy: HINTRACNRSN

Table 8-33 Interaction Reason Hierarchy (HINTRACNRSN)

Level Description Interaction Reason Hierarchy (HINTRACNRSN)

TINTRACNRSN

Total Interaction Reason

TINTRACNRSN

INTRACNRSN

Interaction Reason

INTRACNRSN


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-34 Interaction Reason Long Description Attribute Mapping

Level Mapping (Physical Column)

TINTRACNRSN

'Total Interaction Reason'

INTRACNRSN

DWL_INTRACN_RSN.INTRACN_RSN_NAME


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-35 Interaction Reason Short Description Attribute Mapping

Level Mapping (Physical Column)

TINTRACNRSN

'Total Interaction Reason'

INTRACNRSN

DWL_INTRACN_RSN.INTRACN_RSN_CD


Interaction Status: INTRACNSTAT

This dimension stores the Interaction Statuses used in Oracle Retail Data Model.

Default Hierarchy: HINTRACNSTAT

Table 8-36 Interaction Status Hierarchy (HINTRACNSTAT)

Level Description Interaction Status Hierarchy (HINTRACNSTAT)

TINTRACNSTAT

Total Interaction Status

TINTRACNSTAT

INTRACNSTAT

Interaction Status

INTRACNSTAT


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-37 Interaction Status Long Description Attribute Mapping

Level Mapping (Physical Column)

TINTRACNSTAT

'Total Interaction Status'

INTRACNSTAT

DWL_INTRACN_STAT.INTRACN_STAT_NAME


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-38 Interaction Status Short Description Attribute Mapping

Level Mapping (Physical Column)

TINTRACNSTAT

'Total Interaction Status'

INTRACNSTAT

DWL_INTRACN_STAT.INTRACN_STAT_CD


Interaction Type: INTRACNTYP

This dimension stores the Interaction Types used in Oracle Retail Data Model.

Default Hierarchy: HINTRACNTYP

Table 8-39 Interaction Type Hierarchy (HINTRACNTYP)

Level Description Interaction Type Hierarchy (HINTRACNTYP)

TINTRACNTYP

Total Interaction Type

TINTRACNTYP

INTRACNTYP

Interaction Type

INTRACNTYP


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-40 Interaction Type Long Description Attribute Mapping

Level Mapping (Physical Column)

TINTRACNTYP

'Total Interaction Type'

INTRACNTYP

DWL_INTRACN_TYP.INTRACN_TYP_NAME


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-41 Interaction Type Short Description Attribute Mapping

Level Mapping (Physical Column)

TINTRACNTYP

'Total Interaction Type'

INTRACNTYP

DWL_INTRACN_TYP.INTRACN_TYP_CD


Inventory Location: INVLOC

This dimension stores the Inventory Locations used in Oracle Retail Data Model.

Default Hierarchy: HINVLOC

Table 8-42 Inventory Location Hierarchy (HINVLOC)

Level Description Inventory Location Hierarchy (HINVLOC)

TINVLOC

Total Inventory Location

TINVLOC

INVLOCTYP

Inventory Location Type

INVLOCTYP

INVLOC

Inventory Location

INVLOC


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-43 Inventory Location Long Description Attribute Mapping

Level Mapping (Physical Column)

TINVLOC

'Total Inventory Location'

INVLOCTYP

DWL_INV_LOC_TYP.INV_LOC_TYP_NAME

INVLOC

DWR_INV_LOC.LOC_NAME


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-44 Inventory Location Short Description Attribute Mapping

Level Mapping (Physical Column)

TINVLOC

'Total Inventory Location'

INVLOCTYP

DWL_INV_LOC_TYP.INV_LOC_TYP_CD

INVLOC

DWR_INV_LOC.INV_LOC_CD


Liability Type: LIABTYP

This dimension stores the Liability Types used in Oracle Retail Data Model.

Default Hierarchy: HLIABTYP

Table 8-45 Liability Type Hierarchy (HLIABTYP)

Level Description Liability Type Hierarchy (HLIABTYP)

TLIABTYP

Total Liability Type

TLIABTYP

LIABTYP

Liability Type

LIABTYP


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-46 Liability Type Long Description Attribute Mapping

Level Mapping (Physical Column)

TLIABTYP

'Total Liability Type'

LIABTYP

DWL_LIAB_TYP.LIAB_TYP_NAME


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-47 Liability Type Short Description Attribute Mapping

Level Mapping (Physical Column)

TLIABTYP

'Total Liability Type'

LIABTYP

DWL_LIAB_TYP.LIAB_TYP_CD


Order Type: ORDRTYP

This dimension stores the Order Types used in Oracle Retail Data Model.

Default Hierarchy: HORDRTYP

Table 8-48 Order Type (HORDRTYP)

Level Description Order Type Hierarchy (HORDRTYP)

TORDRTYP

Total Lia Order Type

TORDRTYP

ORDRTYP

Order Type

ORDRTYP


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-49 Order Type Long Description Attribute Mapping

Level Mapping (Physical Column)

TORDRTYP

'Total Order Type'

ORDRTYP

DWL_ORDR_TYP.ORDR_TYP_NAME


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-50 Order Type Short Description Attribute Mapping

Level Mapping (Physical Column)

TORDRTYP

'Total Order Type'

ORDRTYP

DWL_ORDR_TYP.ORDR_TYP_CD


Organization: ORGANIZATION

This dimension stores the Organizational data used in Oracle Retail Data Model.

Default Hierarchy: HORG

Table 8-51 Organization Levels and Hierarchy

Level Description Organization Hierarchy (HORG) Organization Division Hierarchy (HDIVISION) Organization Banner Hierarchy (HBANNER)

TORG

Total Organization

TORG

TORG

TORG

BANNER

Banner

 

BANNER

 

DIVISION

Division

DIVISION

   

COMPANY

Company

COMPANY

   

CHAIN

Chain

CHAIN

   

AREA

Area

AREA

   

REGION

Region

REGION

   

DISTRICT

District

DISTRICT

   

STORE

Store

STORE

STORE

STORE


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-52 Organization Long Description Attribute Mapping

Level Mapping (Physical Column)

TORG

'Total Organization'

BANNER

DWR_ORG_BNR.BNR_NAME

DIVISION

DWR_ORG_DIV.DIV_NAME

COMPANY

DWR_ORG_CMPNY.CMPNY_NAME

CHAIN

DWR_ORG_CHAIN.CHAIN_NAME

AREA

DWR_ORG_AREA.AREA_NAME

REGION

DWR_ORG_RGN.RGN_NAME

DISTRICT

DWR_ORG_DSTRCT.DSTRCT_NAME

STORE

DWR_ORG_BSNS_UNIT.LNG_DESC


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-53 Organization Short Description Attribute Mapping

Level Mapping (Physical Column)

TORG

'Total Organization'

BANNER

DWR_ORG_BNR.BNR_CD

DIVISION

DWR_ORG_DIV.DIV_CD

COMPANY

DWR_ORG_CMPNY.CMPNY_CD

CHAIN

DWR_ORG_CHAIN.CHAIN_CD

AREA

DWR_ORG_AREA.AREA_CD

REGION

DWR_ORG_RGN.RGN_CD

DISTRICT

DWR_ORG_DSTRCT.DSTRCT_CD

STORE

DWR_ORG_BSNS_UNIT.SHORT_DESC


Attribute Name: Business Unit Code (BSNS_UNIT_CD)

Table 8-54 Organization Business Unit Code Attribute Mapping

Level Mapping (Physical Column)

TORG

 

BANNER

 

DIVISION

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.BSNS_UNIT_CD


Attribute Name: Business Unit Type Code (BSNS_UNIT_TYP_CD)

Table 8-55 Organization Business Unit Type Code Attribute Mapping

Level Mapping (Physical Column)

TORG

 

BANNER

 

DIVISION

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.BSNS_UNIT_TYP_CD


Attribute Name: Store Close Date (STORE_CLOSE_DT)

Table 8-56 Organization Store Close Date Attribute Mapping

Level Mapping (Physical Column)

TORG

 

BANNER

 

DIVISION

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.STORE_CLS_DT


Attribute Name: Store Description (STORE_DESC)

Table 8-57 Organization Store Description Attribute Mapping

Level Mapping (Physical Column)

TORG

 

BANNER

 

DIVISION

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.STORE_NAME


Attribute Name: Store Manager (STORE_MANAGER)

Table 8-58 Organization Store Manager Attribute Mapping

Level Mapping (Physical Column)

TORG

 

BANNER

 

DIVISION

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.STORE_MGR


Attribute Name: Store Name (STORE_NAME)

Table 8-59 Organization Store Name Attribute Mapping

Level Mapping (Physical Column)

TORG

 

BANNER

 

DIVISION

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.STORE_NAME


Attribute Name: Store Open Date (STORE_OPEN_DT)

Table 8-60 Organization Store Open Date Attribute Mapping

Level Mapping (Physical Column)

TORG

 

BANNER

 

DIVISION

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.STORE_OPEN_DT


Attribute Name: Store Price Index (STORE_PRICE_INDEX)

Table 8-61 Organization Store Price Index Attribute Mapping

Level Mapping (Physical Column)

TORG

 

BANNER

 

DIVISION

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.STORE_PRICE_INDX


Attribute Name: Store Receiving Code (STORE_RCV_CD)

Table 8-62 Organization Store Receiving Code Attribute Mapping

Level Mapping (Physical Column)

TORG

 

BANNER

 

DIVISION

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.STORE_RCVNG_CD


Attribute Name: Store Type (STORE_TYPE)

Table 8-63 Organization Store Type Attribute Mapping

Level Mapping (Physical Column)

TORG

 

BANNER

 

DIVISION

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.STORE_TYP


Organization QR Dimension: ORGQR

This dimension stores the Organizational data along Organization Hierarchy used in Oracle Retail Data Model.

Default Hierarchy: HORG

Table 8-64 Organization Hierarchy (HORG)

Level Description Organization Hierarchy (HORG)

TORG

Total Organization

TORG

COMPANY

Company

COMPANY

CHAIN

Chain

CHAIN

AREA

Area

AREA

REGION

Region

REGION

DISTRICT

District

DISTRICT

STORE

Store

STORE


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-65 Organization QR Dimension Long Description Attribute Mapping

Level Mapping (Physical Column)

TORG

'Total Organization'

COMPANY

DWR_ORG_CMPNY.CMPNY_NAME

CHAIN

DWR_ORG_CHAIN.CHAIN_NAME

AREA

DWR_ORG_AREA.AREA_NAME

REGION

DWR_ORG_RGN.RGN_NAME

DISTRICT

DWR_ORG_DSTRCT.DSTRCT_NAME

STORE

DWR_ORG_BSNS_UNIT.LNG_DESC


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-66 Organization Short Description Attribute Mapping

Level Mapping (Physical Column)

TORG

'Total Organization'

COMPANY

DWR_ORG_CMPNY.CMPNY_CD

CHAIN

DWR_ORG_CHAIN.CHAIN_CD

AREA

DWR_ORG_AREA.AREA_CD

REGION

DWR_ORG_RGN.RGN_CD

DISTRICT

DWR_ORG_DSTRCT.DSTRCT_CD

STORE

DWR_ORG_BSNS_UNIT.SHORT_DESC


Attribute Name: Business Unit Code (BSNS_UNIT_CD)

Table 8-67 Organization QR Dimension Business Unit Code Attribute Mapping

Level Mapping (Physical Column)

TORG

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.BSNS_UNIT_CD


Attribute Name: Business Unit Type Code (BSNS_UNIT_TYP_CD)

Table 8-68 Organization QR Dimension Business Unit Type Code Attribute Mapping

Level Mapping (Physical Column)

TORG

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.BSNS_UNIT_TYP_CD


Attribute Name: Store Close Date (STORE_CLOSE_DT)

Table 8-69 Organization QR Dimension Store Close Date Attribute Mapping

Level Mapping (Physical Column)

TORG

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.STORE_CLS_DT


Attribute Name: Store Description (STORE_DESC)

Table 8-70 Organization QR Dimension Store Description Attribute Mapping

Level Mapping (Physical Column)

TORG

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.STORE_NAME


Attribute Name: Store Manager (STORE_MANAGER)

Table 8-71 Organization QR Dimension Store Manager Attribute Mapping

Level Mapping (Physical Column)

TORG

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.STORE_MGR


Attribute Name: Store Name (STORE_NAME)

Table 8-72 Organization QR Dimension Store Name Attribute Mapping

Level Mapping (Physical Column)

TORG

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.STORE_NAME


Attribute Name: Store Open Date (STORE_OPEN_DT)

Table 8-73 Organization QR Dimension Store Open Date Attribute Mapping

Level Mapping (Physical Column)

TORG

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.STORE_OPEN_DT


Attribute Name: Store Price Index (STORE_PRICE_INDEX)

Table 8-74 Organization QR Dimension Store Price Index Attribute Mapping

Level Mapping (Physical Column)

TORG

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.STORE_PRICE_INDX


Attribute Name: Store Receiving Code (STORE_RCV_CD)

Table 8-75 Organization QR Dimension Store Receiving Code Attribute Mapping

Level Mapping (Physical Column)

TORG

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.STORE_RCVNG_CD


Attribute Name: Store Type (STORE_TYPE)

Table 8-76 Organization QR Dimension Store Type Attribute Mapping

Level Mapping (Physical Column)

TORG

 

COMPANY

 

CHAIN

 

AREA

 

REGION

 

DISTRICT

 

STORE

DWR_ORG_BSNS_UNIT.STORE_TYP


Pay Type: PAYTYPE

This dimension stores the Pay Types used in Oracle Retail Data Model.

Default Hierarchy: HPAYTYPE

Table 8-77 Pay Type Hierarchy (HPAYTYPE)

Level Description Pay Type Hierarchy (HPAYTYPE)

TPAYTYPE

Total Pay Type

TPAYTYPE

PAYTYPE

Pay Type

PAYTYPE


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-78 Pay Type Long Description Attribute Mapping

Level Mapping (Physical Column)

TPAYTYPE

'Total Pay Type'

PAYTYPE

DWL_PAY_TYP.PAY_TYP_NAME


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-79 Pay Type Short Description Attribute Mapping

Level Mapping (Physical Column)

TPAYTYPE

'Total Pay Type'

PAYTYPE

DWL_PAY_TYP.PAY_TYP_CD


Post Code: POSTCD

This dimension stores the Post Codes used in Oracle Retail Data Model.

Default Hierarchy: HPOSTCD

Table 8-80 Post Code Hierarchy (HPOSTCD)

Level Description Post Code Hierarchy (HPOSTCD)

TPOSTCD

Total Post Code

TPOSTCD

POSTCD

Post Code

POSTCD


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-81 Post Code Long Description Attribute Mapping

Level Mapping (Physical Column)

TPOSTCD

'Total Postcode'

POSTCD

DWR_POSTCD.POSTCD_DESC


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-82 Post Code Short Description Attribute Mapping

Level Mapping (Physical Column)

TPOSTCD

'Total Postcode'

POSTCD

DWR_POSTCD.POSTCD_CD


Product QR Dimension: PRODQR

This dimension stores the Products along Product Hierarchy used in Oracle Retail Data Model.

Default Hierarchy: HPROD

Table 8-83 Product Hierarchy (HPROD)

Level Description Product Hierarchy (HPROD)

TPROD

Total Product

TPROD

COMPANY

Company

COMPANY

DIVISION

Division

DIVISION

GROUPFoot 1 

Group

GROUP

DEPT

Department

DEPT

CLASS

Class

CLASS

SUBCLASS

Sub Class

SUBCLASS

ITEM

Item

ITEM

SKU

SKU Item

SKU


Footnote 1 For Oracle Retail Data Model for OLAP 11g, this level is named GROUP. However, since GROUP is a restricted keyword for Oracle OLAP 11g metadata, in Oracle Retail Data Model for OLAP 11g, this level has been renamed to GROUP1. The Level Description continues to be Group in both versions

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-84 Product QR Dimension Long Description Attribute Mapping

Level Mapping (Physical Column)

TPROD

'Total Product'

COMPANY

DWR_ITEM_CMPNY.ITEM_CMPNY_NAME

DIVISION

DWR_ITEM_DIV.ITEM_DIV_NAME

GROUP

DWR_ITEM_GRP.ITEM_GRP_NAME

DEPT

DWR_ITEM_DEPT.ITEM_DEPT_NAME

CLASS

DWR_ITEM_CLASS.ITEM_CLASS_NAME

SUBCLASS

DWR_ITEM_SBC.SBC_NAME

ITEM

DWR_ITEM.ITEM_DESC

SKU

DWR_SKU_ITEM.SKU_ITEM_DESC


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-85 Product QR Dimension Short Description Attribute Mapping

Level Mapping (Physical Column)

TPROD

'Total Product'

COMPANY

DWR_ITEM_CMPNY.ITEM_CMPNY_CD

DIVISION

DWR_ITEM_DIV.ITEM_DIV_CD

GROUP

DWR_ITEM_GRP.ITEM_GRP_CD

DEPT

DWR_ITEM_DEPT.ITEM_DEPT_CD

CLASS

DWR_ITEM_CLASS.ITEM_CLASS_CD

SUBCLASS

DWR_ITEM_SBC.SBC_CD

ITEM

DWR_ITEM.ITEM_NAME

SKU

DWR_SKU_ITEM.SKU_ITEM_NAME


Attribute Name: Buyer Code (BUYER_CODE)

Table 8-86 Product QR Dimension Buyer Code Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

COMPANY

 

DIVISION

DWR_ITEM_DIV.ITEM_DIV_BYR_CD

GROUP

DWR_ITEM_GRP.ITEM_GRP_BYR_CD

DEPT

DWR_ITEM_DEPT.ITEM_DEPT_BYR_CD

CLASS

DWR_ITEM_CLASS.ITEM_CLASS_BYR_CD

SUBCLASS

DWR_ITEM_SBC.SBC_BYR_CD

ITEM

 

SKU

 

Attribute Name: Buyer Name (BUYER_NAME)

Table 8-87 Product QR Dimension Buyer Name Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

COMPANY

 

DIVISION

DWR_ITEM_DIV.ITEM_DIV_BYR_NAME

GROUP

DWR_ITEM_GRP.ITEM_GRP_BYR_NAME

DEPT

DWR_ITEM_DEPT.ITEM_DEPT_BYR_NAME

CLASS

DWR_ITEM_CLASS.ITEM_CLASS_BYR_NAME

SUBCLASS

DWR_ITEM_SBC.SBC_BYR_NAME

ITEM

 

SKU

 

Attribute Name: Item Conv Type Code (ITEM_CONV_TYPE_CD)

Table 8-88 Product QR Dimension Item Conv Type Code Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

COMPANY

 

DIVISION

 

GROUP

 

DEPT

 

CLASS

 

SUBCLASS

 

ITEM

DWR_ITEM.CONVBL_TYP_CD

SKU

 

Attribute Name: Item Discount Indicator (ITEM_DISC_IND)

Table 8-89 Product QR Dimension Item Discount Indicator Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

COMPANY

 

DIVISION

 

GROUP

 

DEPT

 

CLASS

 

SUBCLASS

 

ITEM

DWR_ITEM.DISC_IND

SKU

 

Attribute Name: Item Display Unit Type Code (ITEM_DISP_UNIT_TYP_CD)

Table 8-90 Product QR Dimension Item Display Unit Type Code Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

COMPANY

 

DIVISION

 

GROUP

 

DEPT

 

CLASS

 

SUBCLASS

 

ITEM

DWR_ITEM.DSPLY_UNIT_TYP_CD

SKU

 

Attribute Name: Item Number (ITEM_NBR)

Table 8-91 Product QR Dimension Item Number Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

COMPANY

 

DIVISION

 

GROUP

 

DEPT

 

CLASS

 

SUBCLASS

 

ITEM

DWR_ITEM.ITEM_NBR

SKU

 

Attribute Name: Merchandiser Code (MERC_CODE)

Table 8-92 Product QR Dimension Merchandiser Code Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

COMPANY

 

DIVISION

DWR_ITEM_DIV.ITEM_DIV_MRCHNDSR_CD

GROUP

DWR_ITEM_GRP.ITEM_GRP_MRCHNDSR_CD

DEPT

DWR_ITEM_DEPT.DEPT_MRCHNDSR_CD

CLASS

DWR_ITEM_CLASS.ITEM_CLASS_MRCHNDSR_CD

SUBCLASS

DWR_ITEM_SBC.SBC_MRCHNDSR_CD

ITEM

 

SKU

 

Attribute Name: Merchandiser Name (MERC_NAME)

Table 8-93 Product QR Dimension Merchandiser Name Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

COMPANY

 

DIVISION

DWR_ITEM_DIV.ITEM_DIV_MRCHNDSR_NAME

GROUP

DWR_ITEM_GRP.ITEM_GRP_MRCHNDSR_NAME

DEPT

DWR_ITEM_DEPT.DEPT_MRCHNDSR_NAME

CLASS

DWR_ITEM_CLASS.ITEM_CLASS_MRCHNDSR_NAME

SUBCLASS

DWR_ITEM_SBC.SBC_MRCHNDSR_NAME

ITEM

 

SKU

 

Attribute Name: SKU Item Number (SKU_ITEM_NBR)

Table 8-94 Product QR Dimension SKU Item Number Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

COMPANY

 

DIVISION

 

GROUP

 

DEPT

 

CLASS

 

SUBCLASS

 

ITEM

 

SKU

DWR_SKU_ITEM.SKU_ITEM_NBR


Product: PRODUCT

This dimension stores the Products used in Oracle Retail Data Model.

Default Hierarchy: HPROD

Table 8-95 Product Hierarchy and Cluster Hierarchy

Level Description Product Hierarchy (HPROD) Product Cluster Hierarchy (HPCLUSTER)

TPROD

Total Product

TPROD

TPROD

PCLUSTER

Product Cluster

 

PCLUSTER

COMPANY

Company

COMPANY

 

DIVISION

Division

DIVISION

 

GROUPFoot 1 

Group

GROUP

 

DEPT

Department

DEPT

 

CLASS

Class

CLASS

 

SUBCLASS

Sub Class

SUBCLASS

 

ITEM

Item

ITEM

ITEM

SKU

SKU Item

SKU

SKU


Footnote 1 For Oracle Retail Data Model for OLAP 11g, this level is named GROUP. However, since GROUP is a restricted keyword for Oracle OLAP 11g metadata, in Oracle Retail Data Model for OLAP 11g, this level has been renamed to GROUP1. The Level Description continues to be Group in both versions.

Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-96 Product Long Description Attribute Mapping

Level Mapping (Physical Column)

TPROD

'Total Product'

PCLUSTER

DWR_ITEM_CLSTR.ITEM_CLSTR_DESC

COMPANY

DWR_ITEM_CMPNY.ITEM_CMPNY_NAME

DIVISION

DWR_ITEM_DIV.ITEM_DIV_NAME

GROUP

DWR_ITEM_GRP.ITEM_GRP_NAME

DEPT

DWR_ITEM_DEPT.ITEM_DEPT_NAME

CLASS

DWR_ITEM_CLASS.ITEM_CLASS_NAME

SUBCLASS

DWR_ITEM_SBC.SBC_NAME

ITEM

DWR_ITEM.ITEM_DESC

SKU

DWR_SKU_ITEM.SKU_ITEM_DESC


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-97 Product Short Description Attribute Mapping

Level Mapping (Physical Column)

TPROD

'Total Product'

PCLUSTER

DWR_ITEM_CLSTR.ITEM_CLSTR_CD

COMPANY

DWR_ITEM_CMPNY.ITEM_CMPNY_CD

DIVISION

DWR_ITEM_DIV.ITEM_DIV_CD

GROUP

DWR_ITEM_GRP.ITEM_GRP_CD

DEPT

DWR_ITEM_DEPT.ITEM_DEPT_CD

CLASS

DWR_ITEM_CLASS.ITEM_CLASS_CD

SUBCLASS

DWR_ITEM_SBC.SBC_CD

ITEM

DWR_ITEM.ITEM_NAME

SKU

DWR_SKU_ITEM.SKU_ITEM_NAME


Attribute Name: Buyer Code (BUYER_CODE)

Table 8-98 Product Buyer Code Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PCLUSTER

 

COMPANY

 

DIVISION

DWR_ITEM_DIV.ITEM_DIV_BYR_CD

GROUP

DWR_ITEM_GRP.ITEM_GRP_BYR_CD

DEPT

DWR_ITEM_DEPT.ITEM_DEPT_BYR_CD

CLASS

DWR_ITEM_CLASS.ITEM_CLASS_BYR_CD

SUBCLASS

DWR_ITEM_SBC.SBC_BYR_CD

ITEM

 

SKU

 

Attribute Name: Buyer Name (BUYER_NAME)

Table 8-99 Product Buyer Name Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PCLUSTER

 

COMPANY

 

DIVISION

DWR_ITEM_DIV.ITEM_DIV_BYR_NAME

GROUP

DWR_ITEM_GRP.ITEM_GRP_BYR_NAME

DEPT

DWR_ITEM_DEPT.ITEM_DEPT_BYR_NAME

CLASS

DWR_ITEM_CLASS.ITEM_CLASS_BYR_NAME

SUBCLASS

DWR_ITEM_SBC.SBC_BYR_NAME

ITEM

 

SKU

 

Attribute Name: Item Conv Type Code (ITEM_CONV_TYPE_CD)

Table 8-100 Product Item Conv Type Code Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PCLUSTER

 

COMPANY

 

DIVISION

 

GROUP

 

DEPT

 

CLASS

 

SUBCLASS

 

ITEM

DWR_ITEM.CONVBL_TYP_CD

SKU

 

Attribute Name: Item Discount Indicator (ITEM_DISC_IND)

Table 8-101 Product Item Discount Indicator Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PCLUSTER

 

COMPANY

 

DIVISION

 

GROUP

 

DEPT

 

CLASS

 

SUBCLASS

 

ITEM

DWR_ITEM.DISC_IND

SKU

 

Attribute Name: Item Display Unit Type Code (ITEM_DISP_UNIT_TYP_CD)

Table 8-102 Product Item Display Unit Type Code Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PCLUSTER

 

COMPANY

 

DIVISION

 

GROUP

 

DEPT

 

CLASS

 

SUBCLASS

 

ITEM

DWR_ITEM.DSPLY_UNIT_TYP_CD

SKU

 

Attribute Name: Item Number (ITEM_NBR)

Table 8-103 Product Item Number Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PCLUSTER

 

COMPANY

 

DIVISION

 

GROUP

 

DEPT

 

CLASS

 

SUBCLASS

 

ITEM

DWR_ITEM.ITEM_NBR

SKU

 

Attribute Name: Merchandiser Code (MERC_CODE)

Table 8-104 Product Merchandiser Code Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PCLUSTER

 

COMPANY

 

DIVISION

DWR_ITEM_DIV.ITEM_DIV_MRCHNDSR_CD

GROUP

DWR_ITEM_GRP.ITEM_GRP_MRCHNDSR_CD

DEPT

DWR_ITEM_DEPT.DEPT_MRCHNDSR_CD

CLASS

DWR_ITEM_CLASS.ITEM_CLASS_MRCHNDSR_CD

SUBCLASS

DWR_ITEM_SBC.SBC_MRCHNDSR_CD

ITEM

 

SKU

 

Attribute Name: Merchandiser Name (MERC_NAME)

Table 8-105 Product Merchandiser Name Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PCLUSTER

 

COMPANY

 

DIVISION

DWR_ITEM_DIV.ITEM_DIV_MRCHNDSR_NAME

GROUP

DWR_ITEM_GRP.ITEM_GRP_MRCHNDSR_NAME

DEPT

DWR_ITEM_DEPT.DEPT_MRCHNDSR_NAME

CLASS

DWR_ITEM_CLASS.ITEM_CLASS_MRCHNDSR_NAME

SUBCLASS

DWR_ITEM_SBC.SBC_MRCHNDSR_NAME

ITEM

 

SKU

 

Attribute Name: SKU Item Number (SKU_ITEM_NBR)

Table 8-106 Product SKU Item Number Attribute Mapping

Level Mapping (Physical Column)

TPROD

 

PCLUSTER

 

COMPANY

 

DIVISION

 

GROUP

 

DEPT

 

CLASS

 

SUBCLASS

 

ITEM

 

SKU

DWR_SKU_ITEM.SKU_ITEM_NBR


Reason: REASON

This dimension stores the Reason Codes used in Oracle Retail Data Model.

Default Hierarchy: HREASON

Table 8-107 Reason Hierarchy (HREASON)

Level Description Reason Hierarchy (HREASON)

TREASON

Total Reason

TREASON

REASON

Reason

REASON


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-108 Reason Long Description Attribute Mapping

Level Mapping (Physical Column)

TREASON

'Total Reason'

REASON

DWL_RSN.RSN_NAME


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-109 Reason Short Description Attribute Mapping

Level Mapping (Physical Column)

TREASON

'Total Reason'

REASON

DWL_RSN.RSN_CD


RFMP: RFMP

This dimension stores the Recency, Frequency, Monetary and Profitability (RFMP) Codes used in Oracle Retail Data Model.

Default Hierarchy: HRFMP

Table 8-110 RFMP Hierarchy (HRFMP)

Level Description RFMP Hierarchy (HRFMP)

TRFMP

Total RFMP

TRFMP

RFMPGRP

RFMP Group

RFMPGRP

DRFMP

RFMP Detail

DRFMP


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-111 RFMP Long Description Attribute Mapping

Level Mapping (Physical Column)

TRFMP

'Total RFMP'

RFMPGRP

DWL_RFMP_MTHD.RFMP_GRP_DESC

DRFMP

DWL_RFMP_MTHD.RFMP_MTHD_DESC


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-112 RFMP Short Description Attribute Mapping

Level Mapping (Physical Column)

TRFMP

'Total RFMP'

RFMPGRP

DWL_RFMP_MTHD.RFMP_GRP

DRFMP

DWL_RFMP_MTHD.RFMP_MTHD_CD


Attribute Name: Frequency Segment Method Code (FSM_CD)

Table 8-113 RFMP Frequency Segment Method Code Attribute Mapping

Level Mapping (Physical Column)

TRFMP

 

RFMPGRP

 

DRFMP

DWL_RFMP_MTHD.FREQNCY_SGMNT_MTHD_CD


Attribute Name: Monetary Segment Method Code (MSM_CD)

Table 8-114 RFMP Monetary Segment Method Code Attribute Mapping

Level Mapping (Physical Column)

TRFMP

 

RFMPGRP

 

DRFMP

DWL_RFMP_MTHD.MNTRY_SGMNT_MTHD_CD


Attribute Name: Profitability Segment Method Code (PSM_CD)

Table 8-115 RFMP Profitability Segment Method Code Attribute Mapping

Level Mapping (Physical Column)

TRFMP

 

DRFMP

DWL_RFMP_MTHD.PROFBLTY_SGMNT_MTHD_CD

RFMPGRP

 

Attribute Name: Recency Segment Method Code (RSM_CD)

Table 8-116 RFMP Recency Segment Method Code Attribute Mapping

Level Mapping (Physical Column)

TRFMP

 

RFMPGRP

 

DRFMP

DWL_RFMP_MTHD.RECENCY_SGMNT_MTHD_CD


Attribute Name: RFMP Method Code (RFMP_MTHD_CD)

Table 8-117 RFMP RFMP Method Code Attribute Mapping

Level Mapping (Physical Column)

TRFMP

 

RFMPGRP

 

DRFMP

DWL_RFMP_MTHD.RFMP_MTHD_CD


Attribute Name: RFMP Order (RFMP_ORDR)

Table 8-118 RFMP RFMP Order Attribute Mapping

Level Mapping (Physical Column)

TRFMP

 

RFMPGRP

 

DRFMP

DWL_RFMP_MTHD.RFMP_ORDR


Attribute Name: RFMP Score (RFMP_SCR)

Table 8-119 RFMP RFMP Score Attribute Mapping

Level Mapping (Physical Column)

TRFMP

 

RFMPGRP

 

DRFMP

DWL_RFMP_MTHD.RFMP_SCR


Attribute Name: RFMP Score Description (RFMP_SCR_DESC)

Table 8-120 RFMP RFMP Score Description Attribute Mapping

Level Mapping (Physical Column)

TRFMP

 

RFMPGRP

 

DRFMP

DWL_RFMP_MTHD.RFMP_SCR_DESC


Attribute Name: RFMP Value (RFMP_VAL)

Table 8-121 RFMP RFMP Value Attribute Mapping

Level Mapping (Physical Column)

TRFMP

 

RFMPGRP

 

DRFMP

DWL_RFMP_MTHD.RFMP_VAL


Request Origin: RQSTORIGIN

This dimension stores the Request Origin Codes used in Oracle Retail Data Model.

Default Hierarchy: HRQSTORIGIN

Table 8-122 Request Origin Hierarchy (HRQSTORIGIN)

Level Description Request Origin Hierarchy (HRQSTORIGIN)

TRQSTORIGIN

Total Request Origin

TRQSTORIGIN

RQSTORIGIN

Request Origin

RQSTORIGIN


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-123 Request Origin Long Description Attribute Mapping

Level Mapping (Physical Column)

TRQSTORIGIN

'Total Request Origin '

RQSTORIGIN

DWL_RQST_ORIGIN.RQST_ORIGIN_NAME


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-124 Request Origin Short Description Attribute Mapping

Level Mapping (Physical Column)

TRQSTORIGIN

'Total Request Origin'

RQSTORIGIN

DWL_RQST_ORIGIN.RQST_ORIGIN_CD


Time: TIME

This dimension stores Time related data used in Oracle Retail Data Model.

Default Hierarchy: HTBSNS

Table 8-125 Time Levels and Hierarchies

Level Description Time Business Hierarchy (HTBSNS) Time Calendar Hierarchy (HTCLNDR) Time Calendar Week Hierarchy (HTCLNDRWK)

TTIME

Total Time

TTIME

TTIME

TTIME

CLNDR_YR

Calendar Year

 

CLNDR_YR

 

CLNDR_HLF_YR

Calendar Half Year

 

CLNDR_HLF_YR

 

CLNDR_QTR

Calendar Quarter

 

CLNDR_QTR

 

CLNDR_MO

Calendar Month

 

CLNDR_MO

 

CLNDR_HLF_MO

Calendar Half Month

 

CLNDR_HLF_MO

 

CLNDR_WK

Calendar Week

 

CLNDR_WK

CLNDR_WK

BSNS_YR

Business Year

BSNS_YR

   

BSNS_HLF_YR

Business Half Year

BSNS_HLF_YR

   

BSNS_QTR

Business Quarter

BSNS_QTR

   

BSNS_MO

Business Month

BSNS_MO

   

BSNS_HLF_MO

Business Half Month

BSNS_HLF_MO

   

BSNS_WK

Business Week

BSNS_WK

   

DAY

Day

DAY

DAY

DAY


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-126 Time Long Description Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TOT_TIME.TOT_DESC

CLNDR_YR

DWR_CLNDR_YR.YR_DESC

CLNDR_HLF_YR

DWR_CLNDR_HLF_YR.HLF_YR_DESC

CLNDR_QTR

DWR_CLNDR_QTR.QTR_DESC

CLNDR_MO

DWR_CLNDR_MO.MO_DESC

CLNDR_HLF_MO

DWR_CLNDR_HLF_MO.HLF_MO_DESC

CLNDR_WK

DWR_CLNDR_WK.WK_DESC

BSNS_YR

DWR_BSNS_YR.YR_DESC

BSNS_HLF_YR

DWR_BSNS_HLF_YR.HLF_YR_DESC

BSNS_QTR

DWR_BSNS_QTR.QTR_DESC

BSNS_MO

DWR_BSNS_MO.MO_DESC

BSNS_HLF_MO

DWR_BSNS_HLF_MO.HLF_MO_DESC

BSNS_WK

DWR_BSNS_WK.WK_DESC

DAY

DWR_DAY.BSNS_DT_DESC


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-127 Time Short Description Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TOT_TIME.TOT_CD

CLNDR_YR

DWR_CLNDR_YR.YR_CD

CLNDR_HLF_YR

DWR_CLNDR_HLF_YR.HLF_YR_CD

CLNDR_QTR

DWR_CLNDR_QTR.QTR_CD

CLNDR_MO

DWR_CLNDR_MO.MO_CD

CLNDR_HLF_MO

DWR_CLNDR_HLF_MO.HLF_MO_CD

CLNDR_WK

DWR_CLNDR_WK.WK_CD

BSNS_YR

DWR_BSNS_YR.YR_CD

BSNS_HLF_YR

DWR_BSNS_HLF_YR.HLF_YR_CD

BSNS_QTR

DWR_BSNS_QTR.QTR_CD

BSNS_MO

DWR_BSNS_MO.MO_CD

BSNS_HLF_MO

DWR_BSNS_HLF_MO.HLF_MO_CD

BSNS_WK

DWR_BSNS_WK.WK_CD

DAY

DWR_DAY.BSNS_DT_DESC


Attribute Name: End Date (END_DATE)

Table 8-128 Time End Date Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TOT_TIME.END_DATE

CLNDR_YR

DWR_CLNDR_YR.YR_END_DT

CLNDR_HLF_YR

DWR_CLNDR_HLF_YR.HLF_YR_END_DT

CLNDR_QTR

DWR_CLNDR_QTR.QTR_END_DT

CLNDR_MO

DWR_CLNDR_MO.MO_END_DT

CLNDR_HLF_MO

DWR_CLNDR_HLF_MO.HLF_MO_END_DT

CLNDR_WK

DWR_CLNDR_WK.WK_END_DT

BSNS_YR

DWR_BSNS_YR.YR_END_DT

BSNS_HLF_YR

DWR_BSNS_HLF_YR.HLF_YR_END_DT

BSNS_QTR

DWR_BSNS_QTR.QTR_END_DT

BSNS_MO

DWR_BSNS_MO.MO_END_DT

BSNS_HLF_MO

DWR_BSNS_HLF_MO.HLF_MO_END_DT

BSNS_WK

DWR_BSNS_WK.WK_END_DT

DAY

DWR_DAY.BSNS_END_DT


Attribute Name: Time Span (TIME_SPAN)

Table 8-129 Time Time Span Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TOT_TIME.TOT_TIME_SPAN

CLNDR_YR

DWR_CLNDR_YR.YR_TIMESPN

CLNDR_HLF_YR

DWR_CLNDR_HLF_YR.HLF_YR_TIMESPN

CLNDR_QTR

DWR_CLNDR_QTR.QTR_TIMESPN

CLNDR_MO

DWR_CLNDR_MO.MO_TIMESPN

CLNDR_HLF_MO

DWR_CLNDR_HLF_MO.HLF_MO_TIMESPN

CLNDR_WK

DWR_CLNDR_WK.WK_TIMESPN

BSNS_YR

DWR_BSNS_YR.YR_TIMESPN

BSNS_HLF_YR

DWR_BSNS_HLF_YR.HLF_YR_TIMESPN

BSNS_QTR

DWR_BSNS_QTR.QTR_TIMESPN

BSNS_MO

DWR_BSNS_MO.MO_TIMESPN

BSNS_HLF_MO

DWR_BSNS_HLF_MO.HLF_MO_TIMESPN

BSNS_WK

DWR_BSNS_WK.WK_TIMESPN

DAY

DWR_DAY.BSNS_DAY_TIMESPAN


Attribute Name: Business Holiday Indicator (BSNS_HLDY_IND)

Table 8-130 Time Business Holiday Indicator Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

CLNDR_YR

 

CLNDR_HLF_YR

 

CLNDR_QTR

 

CLNDR_MO

 

CLNDR_HLF_MO

 

CLNDR_WK

 

BSNS_YR

 

BSNS_HLF_YR

 

BSNS_QTR

 

BSNS_MO

 

BSNS_HLF_MO

 

BSNS_WK

 

DAY

DWR_DAY.BSNS_HOLIDY_IND


Attribute Name: Business Weekend Indicator (BSNS_WEND_IND)

Table 8-131 Time Business Weekend Indicator Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

CLNDR_YR

 

CLNDR_HLF_YR

 

CLNDR_QTR

 

CLNDR_MO

 

CLNDR_HLF_MO

 

CLNDR_WK

 

BSNS_YR

 

BSNS_HLF_YR

 

BSNS_QTR

 

BSNS_MO

 

BSNS_HLF_MO

 

BSNS_WK

 

DAY

DWR_DAY.BSNS_WEEKEND_IND


Attribute Name: Business Working Day Indicator (BSNS_WRK_IND)

Table 8-132 Time Business Working Day Indicator Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

CLNDR_YR

 

CLNDR_HLF_YR

 

CLNDR_QTR

 

CLNDR_MO

 

CLNDR_HLF_MO

 

CLNDR_WK

 

BSNS_YR

 

BSNS_HLF_YR

 

BSNS_QTR

 

BSNS_MO

 

BSNS_HLF_MO

 

BSNS_WK

 

DAY

DWR_DAY.BSNS_WRKING_DAY_IND


Attribute Name: Number (NBR)

Table 8-133 Time Number Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

CLNDR_YR

TO_NUMBER(DWR_CLNDR_YR.YR_NBR)

CLNDR_HLF_YR

TO_NUMBER(DWR_CLNDR_HLF_YR.HLF_YR_NBR)

CLNDR_QTR

TO_NUMBER(DWR_CLNDR_QTR.QTR_NBR)

CLNDR_MO

TO_NUMBER(DWR_CLNDR_MO.MO_NBR)

CLNDR_HLF_MO

TO_NUMBER(DWR_CLNDR_HLF_MO.HLF_MO_NBR)

CLNDR_WK

TO_NUMBER(DWR_CLNDR_WK.WK_NBR)

BSNS_YR

TO_NUMBER(DWR_BSNS_YR.YR_NBR)

BSNS_HLF_YR

TO_NUMBER(DWR_BSNS_HLF_YR.HLF_YR_NBR)

BSNS_QTR

TO_NUMBER(DWR_BSNS_QTR.QTR_NBR)

BSNS_MO

TO_NUMBER(DWR_BSNS_MO.MO_NBR)

BSNS_HLF_MO

TO_NUMBER(DWR_BSNS_HLF_MO.HLF_MO_NBR)

BSNS_WK

TO_NUMBER(DWR_BSNS_WK.WK_NBR)

DAY

TO_NUMBER(DWR_DAY.BSNS_DAY_OF_YR)


Attribute Name: Calendar Holiday Indicator (CLNDR_HLDY_IND)

Table 8-134 Time Calendar Holiday Indicator Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

CLNDR_YR

 

CLNDR_HLF_YR

 

CLNDR_QTR

 

CLNDR_MO

 

CLNDR_HLF_MO

 

CLNDR_WK

 

BSNS_YR

 

BSNS_HLF_YR

 

BSNS_QTR

 

BSNS_MO

 

BSNS_HLF_MO

 

BSNS_WK

 

DAY

DWR_DAY.CLNDR_HOLIDY_IND


Attribute Name: Calendar Weekend Indicator (CLNDR_WEND_IND)

Table 8-135 Time Calendar Weekend Indicator Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

CLNDR_YR

 

CLNDR_HLF_YR

 

CLNDR_QTR

 

CLNDR_MO

 

CLNDR_HLF_MO

 

CLNDR_WK

 

BSNS_YR

 

BSNS_HLF_YR

 

BSNS_QTR

 

BSNS_MO

 

BSNS_HLF_MO

 

BSNS_WK

 

DAY

DWR_DAY.CLNDR_WEEKEND_IND


Attribute Name: Calendar Working Day Indicator (CLNDR_WRK_IND)

Table 8-136 Time Calendar Working Day Indicator Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

CLNDR_YR

 

CLNDR_HLF_YR

 

CLNDR_QTR

 

CLNDR_MO

 

CLNDR_HLF_MO

 

CLNDR_WK

 

BSNS_YR

 

BSNS_HLF_YR

 

BSNS_QTR

 

BSNS_MO

 

BSNS_HLF_MO

 

BSNS_WK

 

DAY

DWR_DAY.CLNDR_WRKING_DAY_IND


Attribute Name: Identifier (ID)

Table 8-137 Time Identifier Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TOT_TIME.TOT_KEY

CLNDR_YR

DWR_CLNDR_YR.CLNDR_YR_KEY

CLNDR_HLF_YR

DWR_CLNDR_HLF_YR.CLNDR_HLF_YR_KEY

CLNDR_QTR

DWR_CLNDR_QTR.CLNDR_QTR_KEY

CLNDR_MO

DWR_CLNDR_MO.CLNDR_MO_KEY

CLNDR_HLF_MO

DWR_CLNDR_HLF_MO.CLNDR_HLF_MO_KEY

CLNDR_WK

DWR_CLNDR_WK.CLNDR_WK_KEY

BSNS_YR

DWR_BSNS_YR.BSNS_YR_KEY

BSNS_HLF_YR

DWR_BSNS_HLF_YR.HLF_YR_KEY

BSNS_QTR

DWR_BSNS_QTR.QTR_KEY

BSNS_MO

DWR_BSNS_MO.MO_KEY

BSNS_HLF_MO

DWR_BSNS_HLF_MO.HLF_MO_KEY

BSNS_WK

DWR_BSNS_WK.WK_KEY

DAY

DWR_DAY.DAY_KEY


Attribute Name: Start Date (START_DATE)

Table 8-138 Time Start Date Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

CLNDR_YR

DWR_CLNDR_YR.YR_STRT_DT

CLNDR_HLF_YR

DWR_CLNDR_HLF_YR.HLF_YR_STRT_DT

CLNDR_QTR

DWR_CLNDR_QTR.QTR_STRT_DT

CLNDR_MO

DWR_CLNDR_MO.MO_STRT_DT

CLNDR_HLF_MO

DWR_CLNDR_HLF_MO.HLF_MO_STRT_DT

CLNDR_WK

DWR_CLNDR_WK.WK_STRT_DT

BSNS_YR

DWR_BSNS_YR.YR_STRT_DT

BSNS_HLF_YR

DWR_BSNS_HLF_YR.HLF_YR_STRT_DT

BSNS_QTR

DWR_BSNS_QTR.QTR_STRT_DT

BSNS_MO

DWR_BSNS_MO.MO_STRT_DT

BSNS_HLF_MO

DWR_BSNS_HLF_MO.HLF_MO_STRT_DT

BSNS_WK

DWR_BSNS_WK.WK_STRT_DT

DAY

DWR_DAY.BSNS_STRT_DT


Time QR Dimension: TIMEQR

This dimension stores the Time Business Hierarchy related data used in Oracle Retail Data Model.

Default Hierarchy: HTBSNS

Table 8-139 Time Business Hierarchy (HTBSNS)

Level Description Time Business Hierarchy (HTBSNS)

TTIME

Total Time

TTIME

BSNS_YR

Business Year

BSNS_YR

BSNS_HLF_YR

Business Half Year

BSNS_HLF_YR

BSNS_QTR

Business Quarter

BSNS_QTR

BSNS_MO

Business Month

BSNS_MO

BSNS_HLF_MO

Business Half Month

BSNS_HLF_MO

BSNS_WK

Business Week

BSNS_WK

DAY

Day

DAY


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-140 Time QR Dimension Long Description Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TOT_TIME.TOT_DESC

BSNS_YR

DWR_BSNS_YR.YR_DESC

BSNS_HLF_YR

DWR_BSNS_HLF_YR.HLF_YR_DESC

BSNS_QTR

DWR_BSNS_QTR.QTR_DESC

BSNS_MO

DWR_BSNS_MO.MO_DESC

BSNS_HLF_MO

DWR_BSNS_HLF_MO.HLF_MO_DESC

BSNS_WK

DWR_BSNS_WK.WK_DESC

DAY

DWR_DAY.BSNS_DT_DESC


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-141 Time QR Dimension Short Description Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TOT_TIME.TOT_CD

BSNS_YR

DWR_BSNS_YR.YR_CD

BSNS_HLF_YR

DWR_BSNS_HLF_YR.HLF_YR_CD

BSNS_QTR

DWR_BSNS_QTR.QTR_CD

BSNS_MO

DWR_BSNS_MO.MO_CD

BSNS_HLF_MO

DWR_BSNS_HLF_MO.HLF_MO_CD

BSNS_WK

DWR_BSNS_WK.WK_CD

DAY

DWR_DAY.BSNS_DT_DESC


Attribute Name: End Date (END_DATE)

Table 8-142 Time QR Dimension End Date Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TOT_TIME.END_DATE

BSNS_YR

DWR_BSNS_YR.YR_END_DT

BSNS_HLF_YR

DWR_BSNS_HLF_YR.HLF_YR_END_DT

BSNS_QTR

DWR_BSNS_QTR.QTR_END_DT

BSNS_MO

DWR_BSNS_MO.MO_END_DT

BSNS_HLF_MO

DWR_BSNS_HLF_MO.HLF_MO_END_DT

BSNS_WK

DWR_BSNS_WK.WK_END_DT

DAY

DWR_DAY.BSNS_END_DT


Attribute Name: Time Span (TIME_SPAN)

Table 8-143 Time QR Dimension Time Span Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TOT_TIME.TOT_TIME_SPAN

BSNS_YR

DWR_BSNS_YR.YR_TIMESPN

BSNS_HLF_YR

DWR_BSNS_HLF_YR.HLF_YR_TIMESPN

BSNS_QTR

DWR_BSNS_QTR.QTR_TIMESPN

BSNS_MO

DWR_BSNS_MO.MO_TIMESPN

BSNS_HLF_MO

DWR_BSNS_HLF_MO.HLF_MO_TIMESPN

BSNS_WK

DWR_BSNS_WK.WK_TIMESPN

DAY

DWR_DAY.BSNS_DAY_TIMESPAN


Attribute Name: Business Holiday Indicator (BSNS_HLDY_IND)

Table 8-144 Time QR Dimension Business Holiday Indicator Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

BSNS_YR

 

BSNS_HLF_YR

 

BSNS_QTR

 

BSNS_MO

 

BSNS_HLF_MO

 

BSNS_WK

 

DAY

DWR_DAY.BSNS_HOLIDY_IND


Attribute Name: Business Weekend Indicator (BSNS_WEND_IND)

Table 8-145 Time QR Dimension Business Weekend Indicator Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

BSNS_YR

 

BSNS_HLF_YR

 

BSNS_QTR

 

BSNS_MO

 

BSNS_HLF_MO

 

BSNS_WK

 

DAY

DWR_DAY.BSNS_WEEKEND_IND


Attribute Name: Business Working Day Indicator (BSNS_WRK_IND)

Table 8-146 Time QR Dimension Business Working Day Indicator Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

BSNS_YR

 

BSNS_HLF_YR

 

BSNS_QTR

 

BSNS_MO

 

BSNS_HLF_MO

 

BSNS_WK

 

DAY

DWR_DAY.BSNS_WRKING_DAY_IND


Attribute Name: Number (NBR)

Table 8-147 Time QR Dimension Number Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

BSNS_YR

TO_NUMBER(DWR_BSNS_YR.YR_NBR)

BSNS_HLF_YR

TO_NUMBER(DWR_BSNS_HLF_YR.HLF_YR_NBR)

BSNS_QTR

TO_NUMBER(DWR_BSNS_QTR.QTR_NBR)

BSNS_MO

TO_NUMBER(DWR_BSNS_MO.MO_NBR)

BSNS_HLF_MO

TO_NUMBER(DWR_BSNS_HLF_MO.HLF_MO_NBR)

BSNS_WK

TO_NUMBER(DWR_BSNS_WK.WK_NBR)

DAY

TO_NUMBER(DWR_DAY.BSNS_DAY_OF_YR)


Attribute Name: Identifier (ID)

Table 8-148 Time QR Dimension Identifier Attribute Mapping

Level Mapping (Physical Column)

TTIME

DWR_TOT_TIME.TOT_KEY

BSNS_YR

DWR_BSNS_YR.BSNS_YR_KEY

BSNS_HLF_YR

DWR_BSNS_HLF_YR.HLF_YR_KEY

BSNS_QTR

DWR_BSNS_QTR.QTR_KEY

BSNS_MO

DWR_BSNS_MO.MO_KEY

BSNS_HLF_MO

DWR_BSNS_HLF_MO.HLF_MO_KEY

BSNS_WK

DWR_BSNS_WK.WK_KEY

DAY

DWR_DAY.DAY_KEY


Attribute Name: Start Date (START_DATE)

Table 8-149 Time QR Dimension Start Date Attribute Mapping

Level Mapping (Physical Column)

TTIME

 

BSNS_YR

DWR_BSNS_YR.YR_STRT_DT

BSNS_HLF_YR

DWR_BSNS_HLF_YR.HLF_YR_STRT_DT

BSNS_QTR

DWR_BSNS_QTR.QTR_STRT_DT

BSNS_MO

DWR_BSNS_MO.MO_STRT_DT

BSNS_HLF_MO

DWR_BSNS_HLF_MO.HLF_MO_STRT_DT

BSNS_WK

DWR_BSNS_WK.WK_STRT_DT

DAY

DWR_DAY.BSNS_STRT_DT


Touchpoint: TOUCHPOINT

This dimension stores the Touchpoint Codes used in Oracle Retail Data Model.

Default Hierarchy: HTOUCHPOINT

Table 8-150 Touchpoint Hierarchy (HTOUCHPOINT)

Level Description Touchpoint Hierarchy (HTOUCHPOINT)

TTOUCHPOINT

TotalTouchpoint

TTOUCHPOINT

TOUCHPOINT

Touchpoint

TOUCHPOINT


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-151 Touchpoint Long Description Attribute Mapping

Level Mapping (Physical Column)

TTOUCHPOINT

'Total Touchpoint'

TOUCHPOINT

DWR_TCHPNT.TCHPNT_CD


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-152 Touchpoint Short Description Attribute Mapping

Level Mapping (Physical Column)

TTOUCHPOINT

'TotalTouchpoint'

TOUCHPOINT

DWR_TCHPNT.TCHPNT_CD


UOM: UOM

This dimension stores the Unit of Measure (UOM) Codes used in Oracle Retail Data Model.

Default Hierarchy: HUOM

Table 8-153 Unit of Measure Hierarchy (HUOM)

Level Description Unit of Measure Hierarchy (HUOM)

TUOM

Total Employee

TUOM

UOMTYPE

Employee Type

UOMTYPE

UOM

Employee

UOM


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-154 Unit of Measure Long Description Attribute Mapping

Level Mapping (Physical Column)

TUOM

'Total UOM'

UOMTYPE

DWL_UOM_TYP.UOM_TYP_NAME

UOM

DWL_UOM.UOM_NAME


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-155 Unit of Measure Short Description Attribute Mapping

Level Mapping (Physical Column)

TUOM

'Total UOM'

UOMTYPE

DWL_UOM_TYP.UOM_TYP_CD

UOM

DWL_UOM.UOM_CD


Vendor: VENDOR

This dimension stores the Vendors used in Oracle Retail Data Model.

Default Hierarchy: HVENDOR

Table 8-156 Vendor Hierarchy (HVENDOR)

Level Description Vendor Hierarchy (HVENDOR)

TVENDOR

Total Employee

TVENDOR

VENDORCLASS

Employee Type

VENDORCLASS

VNDR

Employee

VNDR


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-157 Vendor Long Description Attribute Mapping

Level Mapping (Physical Column)

TVENDOR

'Total Vendor'

VENDORCLASS

DWL_VNDR_CLASS.VNDR_CLASS_NAME

VNDR

DWR_VNDR.PRTY_DESC


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-158 Vendor Short Description Attribute Mapping

Level Mapping (Physical Column)

TVENDOR

'Total Vendor'

VENDORCLASS

DWL_VNDR_CLASS.VNDR_CLASS_CD

VNDR

DWR_VNDR.PRTY_NAME


Vendor Item: VNDRITEM

This dimension stores the Vendor Items used in Oracle Retail Data Model.

Default Hierarchy: HVNDRITEM

Table 8-159 Vendor Item Hierarchy (HVNDRITEM)

Level Description Vendor Item Hierarchy (HVNDRITEM)

TVNDRITEM

Total Vendor Item

TVNDRITEM

VNDRITEM

Vendor Item

VNDRITEM


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-160 Vendor Item Long Description Attribute Mappin

Level Mapping (Physical Column)

TVNDRITEM

'Total Vendor Item'

VNDRITEM

DWR_VNDR_ITEM.VNDR_ITEM_DESC


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-161 Vendor Item Short Description Attribute Mapping

Level Mapping (Physical Column)

TVNDRITEM

'Total Vendor Item'

VNDRITEM

DWR_VNDR_ITEM.VNDR_ITEM_NBR


Vendor Site: VNDRSITE

This dimension stores the Vendor Sites used in Oracle Retail Data Model.

Default Hierarchy: HVNDRSITE

Table 8-162 Vendor Site Hierarchy (HVNDRSITE)

Level Description Vendor Site Hierarchy (HVNDRSITE)

TVNDRSITE

Total Vendor Site

TVNDRSITE

VNDRSITE

Vendor Site

VNDRSITE


Attribute Name: Long Description (LONG_DESCRIPTION)

Table 8-163 Vendor Site Long Description Attribute Mapping

Level Mapping (Physical Column)

TVNDRSITE

'Total Vendor Site'

VNDRSITE

DWR_VNDR_SITE.VNDR_SITE_NAME


Attribute Name: Short Description (SHORT_DESCRIPTION)

Table 8-164 Vendor Site Short Description Attribute Mapping

Level Mapping (Physical Column)

TVNDRSITE

'Total Vendor Site'

VNDRSITE

DWR_VNDR_SITE.VNDR_SITE_CD