List of Tables

1-1 Oracle Development Tools Used with Oracle Retail Data Model
2-1 Logical Data Model Business Area to Subject Area Mapping
2-2 Logical Data Model Subject Areas and Subject Area Components
2-3 Account Subject Area Entities
2-4 Address Location Subject Area Entities
2-5 Business Unit Subject Area Entities
2-6 Calendar Subject Area Entities
2-7 Call Center Subject Area Entities
2-8 Call Center Agent Subject Area Entities
2-9 Catalog Subject Area Entities
2-10 Certificate Voucher Subject Area Entities
2-11 Channels Subject Area Entities
2-12 Clickstream Subject Area Entities
2-13 Competitor Subject Area Entities
2-14 Contract Subject Area Entities
2-15 Control Transaction Subject Area Entities
2-16 Cost Subject Area Entities
2-17 Customer Subject Area Entities
2-18 Customer Contract Subject Area Entities
2-19 Customer Order Subject Area Entities
2-20 Customer Service Request Subject Area Entities
2-21 Deal Subject Area Entities
2-22 Event Subject Area Entities
2-23 Food Service Subject Area Entities
2-24 Fueling Business Service Subject Area Entities
2-25 Financial Ledger Subject Area Entities
2-26 Geography Subject Area Entities
2-27 Inventory Subject Area Entities
2-28 Inventory Control Subject Area Entities
2-29 Invoice Subject Area Entities
2-30 Item Subject Area Entities
2-31 Loyalty Subject Area Entities
2-32 Manufacturer Organization Subject Area Entities
2-33 Manufacturer SKU Item Subject Area Entities
2-34 Order Fulfillment Subject Area Entities
2-35 Organization Business Unit Subject Area Entities
2-36 Party Subject Area Entities
2-37 Party Interaction Subject Area Entities
2-38 Planogram Subject Area Entities
2-39 Point of Service Subject Area Entities
2-40 Promotion and Campaign Subject Area Entities
2-41 SKU Item Recipe Subject Area Entities
2-42 Retail Sales Subject Area Entities
2-43 Retail Transaction Subject Area Entities
2-44 Revenue Center Subject Area Entities
2-45 Sales Audit Subject Area Entities
2-46 SKU Item Subject Area Entities
2-47 Subscription Subject Area Entities
2-48 Supply Chain Subject Area Entities
2-49 Tender Control Subject Area Entities
2-50 Tender Repository Subject Area Entities
2-51 Time Subject Area Entities
2-52 Touchpoint Subject Area Entities
2-53 Vendor Subject Area Entities
2-54 Vendor Item Subject Area Entities
2-55 Workforce Management Subject Area Entities
2-56 Workstation and Till Subject Area Entities
2-57 A-F Entity Descriptions
2-58 G-N Entity Descriptions
2-59 O-S Entity Descriptions
2-60 T-Z Entity Descriptions
3-1 Reference Tables
3-2 Lookup Tables
3-3 Base Tables
3-4 Derived Tables
3-5 Aggregate Tables
3-6 Control and Configuration Tables
3-7 Metadata Tables
3-8 Database Sequences
3-9 OLAP Cube Materialized View in ordm_sys Schema
3-10 OLAP Views in ordm_sys Schema
3-11 Oracle Retail Data Model Relational MVs
3-12 Relational Views in ordm_sys Schema
3-13 Data Mining MVs in ordm_sys Schema
4-1 Entity Mapping Logical to Physical: A to M Entities
4-2 Entity Mapping Logical to Physical: N to Z Entities
5-1 Physical Data Model Partitioning
6-1 Intra-ETL Scripts for Database Packages
6-2 Relational Materialized Views
7-1 Relational Source Objects for Loading OLAP Dimensions
7-2 Relational Source Objects for Loading OLAP Cubes
7-3 PKG_OLAP_ETL_AW_LOAD Package Subprograms
7-4 OLAP_ETL_AW_BUILD Function Parameters
7-5 OLAP_ETL_NF_CUBE_BUILD Function Parameters
7-6 OLAP_ETL_FCST_BUILD Function Parameters
8-1 List of OLAP Dimensions
8-2 Activity Request Type Hierarchy (HACTRQSTTYP)
8-3 Activity Request Type Long Description Attribute Mapping
8-4 Activity Request Type Short Description Attribute Mapping
8-5 Assets Type Hierarchy (HASSTTYPE)
8-6 Assets Type Long Description Attribute Mapping
8-7 Assets Type Short Description Attribute Mapping
8-8 Business Unit Shift Hierarchy (HBUSHIFT)
8-9 Business Unit Shift Long Description Attribute Mapping
8-10 Business Unit Shift Short Description Attribute Mapping
8-11 Carrier Hierarchy (HCARRIER)
8-12 Carrier Long Description Attribute Mapping
8-13 Carrier Short Description Attribute Mapping
8-14 Media and Campaign Hierarchy (HCMPGN)
8-15 Campaign Media Long Description Attribute Mapping
8-16 Campaign Media Short Description Attribute Mapping
8-17 Customer Type and Customer Cluster Hierarchy
8-18 Customer Long Description Attribute Mapping
8-19 Customer Short Description Attribute Mapping
8-20 Customer Frequent Shopper Indicator Attribute Mapping
8-21 Customer Frequent Shopper Number Attribute Mapping
8-22 Customer Customer Type Attribute Mapping
8-23 Customer City Attribute Mapping
8-24 Customer State Attribute Mapping
8-25 Customer Country Attribute Mapping
8-26 Employee Hierarchy (HEMPLOYEE)
8-27 Employee Long Description Attribute Mapping
8-28 Employee Short Description Attribute Mapping
8-29 Environment Type Hierarchy (HENVTYPE)
8-30 Environment Type Long Description Attribute Mapping
8-31 Environment Type Short Description Attribute Mapping
8-32 Interaction Reason Hierarchy (HINTRACNRSN)
8-33 Interaction Reason Long Description Attribute Mapping
8-34 Interaction Reason Short Description Attribute Mapping
8-35 Interaction Status Hierarchy (HINTRACNSTAT)
8-36 Interaction Status Long Description Attribute Mapping
8-37 Interaction Status Short Description Attribute Mapping
8-38 Interaction Type Hierarchy (HINTRACNTYP)
8-39 Interaction Type Long Description Attribute Mapping
8-40 Interaction Type Short Description Attribute Mapping
8-41 Inventory Location Hierarchy (HINVLOC)
8-42 Inventory Location Long Description Attribute Mapping
8-43 Inventory Location Short Description Attribute Mapping
8-44 Liability Type Hierarchy (HLIABTYP)
8-45 Liability Type Long Description Attribute Mapping
8-46 Liability Type Short Description Attribute Mapping
8-47 Order Type (HORDRTYP)
8-48 Order Type Long Description Attribute Mapping
8-49 Order Type Short Description Attribute Mapping
8-50 Organization Levels and Hierarchy
8-51 Organization Long Description Attribute Mapping
8-52 Organization Short Description Attribute Mapping
8-53 Organization Business Unit Code Attribute Mapping
8-54 Organization Business Unit Type Code Attribute Mapping
8-55 Organization Store Close Date Attribute Mapping
8-56 Organization Store Description Attribute Mapping
8-57 Organization Store Manager Attribute Mapping
8-58 Organization Store Name Attribute Mapping
8-59 Organization Store Open Date Attribute Mapping
8-60 Organization Store Price Index Attribute Mapping
8-61 Organization Store Receiving Code Attribute Mapping
8-62 Organization Store Type Attribute Mapping
8-63 Organization Hierarchy (HORG)
8-64 Organization QR Dimension Long Description Attribute Mapping
8-65 Organization Short Description Attribute Mapping
8-66 Organization QR Dimension Business Unit Code Attribute Mapping
8-67 Organization QR Dimension Business Unit Type Code Attribute Mapping
8-68 Organization QR Dimension Store Close Date Attribute Mapping
8-69 Organization QR Dimension Store Description Attribute Mapping
8-70 Organization QR Dimension Store Manager Attribute Mapping
8-71 Organization QR Dimension Store Name Attribute Mapping
8-72 Organization QR Dimension Store Open Date Attribute Mapping
8-73 Organization QR Dimension Store Price Index Attribute Mapping
8-74 Organization QR Dimension Store Receiving Code Attribute Mapping
8-75 Organization QR Dimension Store Type Attribute Mapping
8-76 Pay Type Hierarchy (HPAYTYPE)
8-77 Pay Type Long Description Attribute Mapping
8-78 Pay Type Short Description Attribute Mapping
8-79 Post Code Hierarchy (HPOSTCD)
8-80 Post Code Long Description Attribute Mapping
8-81 Post Code Short Description Attribute Mapping
8-82 Product Hierarchy (HPROD)
8-83 Product QR Dimension Long Description Attribute Mapping
8-84 Product QR Dimension Short Description Attribute Mapping
8-85 Product QR Dimension Buyer Code Attribute Mapping
8-86 Product QR Dimension Buyer Name Attribute Mapping
8-87 Product QR Dimension Item Conv Type Code Attribute Mapping
8-88 Product QR Dimension Item Discount Indicator Attribute Mapping
8-89 Product QR Dimension Item Display Unit Type Code Attribute Mapping
8-90 Product QR Dimension Item Number Attribute Mapping
8-91 Product QR Dimension Merchandiser Code Attribute Mapping
8-92 Product QR Dimension Merchandiser Name Attribute Mapping
8-93 Product QR Dimension SKU Item Number Attribute Mapping
8-94 Product Hierarchy and Cluster Hierarchy
8-95 Product Long Description Attribute Mapping
8-96 Product Short Description Attribute Mapping
8-97 Product Buyer Code Attribute Mapping
8-98 Product Buyer Name Attribute Mapping
8-99 Product Item Conv Type Code Attribute Mapping
8-100 Product Item Discount Indicator Attribute Mapping
8-101 Product Item Display Unit Type Code Attribute Mapping
8-102 Product Item Number Attribute Mapping
8-103 Product Merchandiser Code Attribute Mapping
8-104 Product Merchandiser Name Attribute Mapping
8-105 Product SKU Item Number Attribute Mapping
8-106 Reason Hierarchy (HREASON)
8-107 Reason Long Description Attribute Mapping
8-108 Reason Short Description Attribute Mapping
8-109 RFMP Hierarchy (HRFMP)
8-110 RFMP Long Description Attribute Mapping
8-111 RFMP Short Description Attribute Mapping
8-112 RFMP Frequency Segment Method Code Attribute Mapping
8-113 RFMP Monetary Segment Method Code Attribute Mapping
8-114 RFMP Profitability Segment Method Code Attribute Mapping
8-115 RFMP Recency Segment Method Code Attribute Mapping
8-116 RFMP RFMP Method Code Attribute Mapping
8-117 RFMP RFMP Order Attribute Mapping
8-118 RFMP RFMP Score Attribute Mapping
8-119 RFMP RFMP Score Description Attribute Mapping
8-120 RFMP RFMP Value Attribute Mapping
8-121 Request Origin Hierarchy (HRQSTORIGIN)
8-122 Request Origin Long Description Attribute Mapping
8-123 Request Origin Short Description Attribute Mapping
8-124 Time Levels and Hierarchies
8-125 Time Long Description Attribute Mapping
8-126 Time Short Description Attribute Mapping
8-127 Time End Date Attribute Mapping
8-128 Time Time Span Attribute Mapping
8-129 Time Business Holiday Indicator Attribute Mapping
8-130 Time Business Weekend Indicator Attribute Mapping
8-131 Time Business Working Day Indicator Attribute Mapping
8-132 Time Number Attribute Mapping
8-133 Time Calendar Holiday Indicator Attribute Mapping
8-134 Time Calendar Weekend Indicator Attribute Mapping
8-135 Time Calendar Working Day Indicator Attribute Mapping
8-136 Time Identifier Attribute Mapping
8-137 Time Start Date Attribute Mapping
8-138 Time Business Hierarchy (HTBSNS)
8-139 Time QR Dimension Long Description Attribute Mapping
8-140 Time QR Dimension Short Description Attribute Mapping
8-141 Time QR Dimension End Date Attribute Mapping
8-142 Time QR Dimension Time Span Attribute Mapping
8-143 Time QR Dimension Business Holiday Indicator Attribute Mapping
8-144 Time QR Dimension Business Weekend Indicator Attribute Mapping
8-145 Time QR Dimension Business Working Day Indicator Attribute Mapping
8-146 Time QR Dimension Number Attribute Mapping
8-147 Time QR Dimension Identifier Attribute Mapping
8-148 Time QR Dimension Start Date Attribute Mapping
8-149 Touchpoint Hierarchy (HTOUCHPOINT)
8-150 Touchpoint Long Description Attribute Mapping
8-151 Touchpoint Short Description Attribute Mapping
8-152 Unit of Measure Hierarchy (HUOM)
8-153 Unit of Measure Long Description Attribute Mapping
8-154 Unit of Measure Short Description Attribute Mapping
8-155 Vendor Hierarchy (HVENDOR)
8-156 Vendor Long Description Attribute Mapping
8-157 Vendor Short Description Attribute Mapping
8-158 Vendor Item Hierarchy (HVNDRITEM)
8-159 Vendor Item Long Description Attribute Mappin
8-160 Vendor Item Short Description Attribute Mapping
8-161 Vendor Site Hierarchy (HVNDRSITE)
8-162 Vendor Site Long Description Attribute Mapping
8-163 Vendor Site Short Description Attribute Mapping
9-1 OLAP Cubes
10-1 Oracle Retail Data Model Mining Algorithm Types Used by Model
10-2 Oracle Retail Data Model Data Mining Target Tables
10-3 Employee Basket Analysis Source Attributes
10-4 Employee Basket Analysis Attribute Ranking with SVM Factors
10-5 Employee Basket Analysis Employee KPIs Prediction using DT Sample 1
10-6 Employee Basket Analysis Employee KPIs Prediction using DT Sample 2
10-7 Employee Basket Analysis Employee KPIs Prediction using SVM Sample 1
10-8 Employee Basket Analysis Employee KPIs Prediction using SVM Sample 2
10-9 Employee Sales Analysis Source Table
10-10 Employee Sales Analysis Attribute Ranking with SVM Factors
10-11 Employee Sales Analysis Employee KPIs Prediction using DT Sample 1
10-12 Employee Sales Analysis Employee KPIs Prediction using DT Sample 2
10-13 Employee Sales Analysis Employee KPIs Prediction using SVM Sample 1
10-14 Employee Sales Analysis Employee KPIs Prediction using SVM Sample 2
10-15 Customer Loyalty Analysis Source Table
10-16 Customer Loyalty Analysis Attribute Ranking with SVM Factors
10-17 Customer Loyalty Analysis Customer Loyalty Prediction (By SVM & DT)
10-18 Store Loss Analysis Source Table
10-19 Store Loss Analysis Attribute Ranking with SVM Factor
10-20 Store Loss Analysis Store KPIs Prediction using DT Sample 1
10-21 Store Loss Analysis Store KPIs Prediction using DT Sample 2
10-22 Store Loss Analysis Store KPIs Prediction Using SVM
10-23 Store Loss Analysis Store KPIs Prediction Using SVM
10-24 Item POS Loss Analysis Source Table
10-25 Item POS Loss Analysis Attribute Ranking with SVM Factor
10-26 Item POS Loss Analysis Item KPIs Prediction using DT Sample 1
10-27 Item POS Loss Analysis Item KPIs Prediction using DT Sample 2
10-28 Item POS Loss Analysis Item KPIs Prediction using SVM Sample 1
10-29 Item POS Loss Analysis Item KPIs Prediction using SVM Sample 2
10-30 Product Category Mix Analysis Source Table
10-31 Product Price Elasticity Analysis Source Table
10-32 Product Price Elasticity Analysis Attribute Ranking with SVM Factor
10-33 Employee Combination Analysis Source Table
10-34 Employee Combination Analysis Attribute Ranking with SVM Factor
10-35 Employee Combination Analysis Employee Combination Performance Prediction (By DT & SVM)
10-36 Customer Segmentation Analysis Source Table
10-37 Customer Life Time Value Analysis Source Table
10-38 Customer Life Time Value Analysis Attribute Ranking with SVM Factor
10-39 Customer LTV Code Prediction (Using DT) - Classification
10-40 Customer LTV Prediction (Using SVM)- Regression
10-41 Customer LT Survival Value Code Prediction (Using) - Classification
10-42 Customer LT Survival Value Prediction (Using SVM)- Regression
10-43 Customer Churn Analysis Source Table
10-44 Customer Churn Analysis Attribute Ranking with SVM Factor
10-45 Customer Churn Prediction (By DT & SVM)
10-46 Customer Sentiment Analysis Source Table
A-1 DWC_ETL_PARAMETER Table
A-2 ETL Parameters in DWC_OLAP_ETL_PARAMETER
A-3 DWC_INTRA_ETL_PROCESS Columns
A-4 DWC_INTRA_ETL_ACTIVITY Columns