Go to main content
1/24
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Part I Logical and Physical Data Model
1
Introducing Oracle Communications Data Model
Overview of Oracle Communications Data Model
What Are the Benefits of Using Oracle Communications Data Model?
What Are the Components of Oracle Communications Data Model?
What Oracle Technologies are in Oracle Communications Data Model
What is Oracle Communications Data Model
About Business Areas and Subject Areas in Oracle Communications Data Model
About the Logical Data Model and Physical Data Model
About Entity Relationships in Oracle Communications Data Model
Understanding Named and Flexible Hierarchies
About TM Forum Information Framework (SID) Alignment
Business Areas in Oracle Communications Data Model
2
Logical Data Model Foundation
Major Subject Areas and Related Entities
Subject Area: Account
Subject Area: Agreement
Subject Area: Billing
Subject Area: Business Interaction
Subject Area: Click Stream
Subject Area: Cost
Subject Area: Customer
Subject Area: Customer Field
Subject Area: Employee
Subject Area: Event
Subject Area: Financial GL Cost and Asset
Subject Area: Flexible Characteristics
Subject Area: Loyalty Program
Subject Area: Number Porting
Subject Area: Party
Subject Area: Party Partners Vendor Roaming Content
Subject Area: Payment
Subject Area: Prepaid-Balance and Voucher
Subject Area: Problem
Subject Area: Process
Subject Area: Product Offering and Product Subscription
Subject Area: Product Subscription
Subject Area: Product and Product Specification
Subject Area: Promotion and Campaign
Subject Area: QoS
Subject Area: Resource
Subject Area: Service and Service Specification
Subject Area: UDR Event
Logical Entities for Business Areas
Business Area: Cost
Business Area: Customer Management
Business Area: Marketing
Business Area: Network
Business Area: Partner Management
Business Area: Product Management
Business Area: Provisioning and Service
Business Area: Revenue
Logical Data Model Entity Dictionary
3
Logical Data Model Dimensions
Logical Data Model Dimensions
Access Method
Account
Account Payment Method Status Type
Account Refund Reason
Address Location
Age Band
Age Group
Age On Net Band
ARPU Band
Agreement Change Initiator Type
Agreement Type
Bank Direct Debit Channel
Ber Fer Type
Billing Cycle
Billing Status Type
Business Time
Calendar Time
Call Category
Call Center Agent
Call Center Case Title
Call Center
Call Direction
Call Other Type
Call Routing Type
Call Service Type
Call Source Destination
Call Success Fail Type
Call Type
Campaign
Campaign Channel
Campaign Media
Cell Outage Reason
Cell Site
Change Proposed By Type
Channel
Collection Agency
Commission Type
Competitor
Contact List
Content
Content Type
Contract Change Initiator Type
Contract Assignment Reason
Cost Center
Credit Category
Currency
Customer
Customer Cluster
Customer Revenue Band
Customer Segment
Dealer
Debt Aging Band
Direct Debit Status Reason
Divert Retrieve Type
Employee
Environment Type
Event Category
Event Result
Event Type
External Operator
Fraud Profile Class
Geography
Give Away Type
GPRS Services
Handset Model
IN Platform
Initiative Type
Interaction Channel
Interaction Direction
Interaction Type
Invoice Adjustment Reason
Invoice Adjustment Type
Invoice Status
ISP
Item Subclass
Legal Process Status Type
Lifecycle Type
Loyalty Program Channel
Loyalty Tier
Market Area
Media Object Type
Network
Network Touchpoint
Network Touchpoint Class
Network Touchpoint Status
Network Touchpoint Type
Network Type
Notification Type
NP Request Type
On Off Net Type
Order Line Item State
Order State
Order Type
Organization
Packet Control Unit Outage Reason
Partner Settlement Reason
Party
Payment Channel
Payment Method Type
Payment Transaction Type
PCU Outage Reason
Peak Offpeak Time
PPA Category
Product
Product Specification Type
Product Subscription Status
Product Subscription Type
Promotion
Promotion Result Type
Quarter Hour
Reason
Recharge Revenue Slab
Redemption Type
Retail Type
RF Carrier
Roaming Type
Sales Channel
Sales Channel Representative
Script
Service Coverage Area
SKU Item
SPNM Other Party Number
Subsidy Type
Switch
Technology Type
Tender
Time Slot
UMS Access Type
Value Added Services (VAS)
4
Oracle Communications Data Model Physical Data Model
Introduction to Oracle Communications Data Model Physical Data Model
Reference Tables
Lookup Tables
Base Tables
Derived Tables
Aggregate Tables
Temporary and Other Tables
Sequences in Oracle Communications Data Model
Compressed Tables
Oracle Communications Data Model OLAP Cube MV, Cube View
5
Oracle Communications Data Model Logical to Physical Mapping
Overview of Mapping and Inheritance in Oracle Communications Data Model
Logical to Physical Mappings for Oracle Communications Data Model
6
Oracle Communications Data Model Partitioning
About Oracle Communications Data Model Partitioning, Compression, and Parallelism
Partitioning Strategy for Oracle Communications Data Model
Part II Intra-ETL, OLAP, Data Mining, and Utility Scripts
7
Oracle Communications Data Model Intra-ETL
About Oracle Communications Data Model Intra-ETL
Intra-ETL PL/SQL Packages Business Rules and Source Tables
DWD_ACCT_BAL_MO_PKG Package
DWD_ACCT_DEBT_MO_PKG Package
DWD_ACCT_FRST_ACTVTY_PKG Package
DWD_ACCT_LAST_ACTVTY_PKG Package
DWD_ACCT_PMT_MTD_STAT_HST_PKG Package
DWD_ACCT_PYMT_DAY_PKG Package
DWD_AGRMNT_PKG Package
DWD_AGRMNT_CHG_PKG Package
DWD_AGRMNT_RVN_DAY Package
DWD_BER_FER_ERR_RATIO_DAY_PKG Package
DWD_CANBLZTN_DTL_DAY_PKG Package
DWD_CELL_STTSTC_DAY_PKG Package
DWD_CMPGN_HIST_DAY_PKG Package
DWD_CNT_DAY_PKG Package
DWD_CNTCT_CNTR_DAY_PKG Package
DWD_CUST_DNA_PKG Package
DWD_CUST_EQPMNT_INSTLTN_DAY_PKG Package
DWD_CUST_ORDR_DAY_PKG Package
DWD_CUST_ORDR_LN_ITEM_DAY_PKG Package
DWD_CUST_SKU_SL_RETRN_DAY_PKG Package
DWD_DATA_USG_DAY_PKG Package
DWD_GIVE_AWAY_ITEM_DAY_PKG Package
DWD_INV_ADJ_ITEM_DAY_PKG Package
DWD_INV_POSN_ITEM_DAY_PKG Package
DWD_INV_RCPT_ITEM_DAY_PKG Package
DWD_INV_UNAVL_ITEM_DAY_PKG Package
DWD_INV_XFER_ITEM_DAY_PKG Package
DWD_INVC_PKG Package
DWD_INVC_AGNG_DAY_PKG Package
DWD_NBR_PRT_DAY_PKG Package
DWD_POS_TNDR_FLOW_PKG Package
DWD_PRCS_INVC_DAY_PKG Package
DWD_PRPD_ACCT_STTSTC_DAY_PKG Package
DWD_RTL_SL_RETRN_ITEM_DAY_PKG Package
DWD_RVN_DAY_PKG Package
DWD_SPLMNTR_SRVC_USG_PKG Package
DWD_SRVC_PRBLM_DAY_PKG Package
DWD_STORE_EFFNCY_DAY_PKG Package
DWD_VAS_SBRP_QCK_SUMM_PKG Package
DWD_VAS_USG_DAY_PKG Package
DWD_VOI_CALL_DAY_PKG Package
8
Oracle Communications Data Model OLAP Model Dimensions
Introduction to OLAP Architecture
General Process to Populate the OLAP Module in Oracle Communications Data Model
Query Rewrite to Cube Organized Materialized Views
Oracle Communications Data Model OLAP Dimensions
Account Refund Reason: ARRSN
Bank Direct Debit Channel: MOBJTYP
Billing Cycle: BCYCL
Churn Reason: CRNRSN
Collection Agency: CAGNCY
Commission Type: CMTYP
Cost Center: CCK
Currency: CRNCY
Customer: CUST
Customer Segment: CSGMNT
Customer Type: CUSTYP
Debt Aging Band: DAB
Geography: GEO
Handset Model: HSMDL
Invoice Adjustment Reason: IARSN
Invoice Adjustment Type: IATYP
Organization: ORG
Payment Channel: PCK
Payment Method Type: PMTYP
Payment Transaction Type: PTTYP
Peak Offpeak Time: POPT
Product: PROD
Product Offer: POFR
Promotion: PRMTN
Resource: RSCEK
Sales Channel: SLCHNL
Sales Channel Representative: SLR
SKU Item: SKUITEM
Time: TIME
Time Day: TIME_DAY
Time Slot: TSLT
9
Oracle Communications Data Model OLAP Model Cubes
Oracle Communications Data Model OLAP Cubes
Account Debt Cube: ADM
Account Payment Cube: APM
Agreement Cube: AGRMNT
Cell Statistic Cube: CSM
Commission Cube: CMSN
Cost Organizational Cube: COM
Cost Product Offering Cube: CCM
Customer Acquisition Cube: ACM
Inventory Cube: INV
Inventory Forecast Cube: INV_FCST
Inventory Forecast Statistic Cube: INV_FCST_STTSTC
Invoice Adjustment Cube: IAM
Invoice Customer Type Cube: INVCM
Revenue Cube: RVN
Subscriber Churn Statistic Cube: CHRN
Customer Acquisition Forecast Cube: ACM_FCST
Customer Acquisition Forecast Statistic Cube: ACM_FCST_STTSTC
Cell Statistic Forecast Cube: CSM_FCST
Revenue Forecast Cube: RVN_FCST
Sales Cube: SLS
Sales Forecast Cube: SLS_FCST
Sales Forecast Statistic Cube: SLS_FCST_STTSTC
10
Oracle Communications Data Model Data Mining Models
About Data Mining in Oracle Communications Data Model
Understanding the Mining Model Architecture
Refreshing the Oracle Communications Data Model Mining Model
Oracle Communications Data Model Mining Result Tables
Model 1: Prepaid Churn Prediction
Prepaid Churner Definition
Prepaid Churn Source
Prepaid Churn Output Target Attribute: CHRN_IND
Prepaid Churn Algorithm
Prepaid Churn Algorithm Setting Tables
Model 2: Postpaid Churn Prediction
Postpaid Churner Definition
Postpaid Churner Source
Postpaid Churn Output Target Attribute: CHRN_IND
Postpaid Churner Algorithm
Postpaid Churner Algorithm Setting Tables
Model 3: Customer Profiling
Customer Profiling Source
Customer Profile Output
Customer Profile Algorithm
Customer Profile Algorithm Setting Tables
Model 4: Targeted Promotion
Targeted Promotion Source
Targeted Promotion Output
Targeted Promotion Algorithm
Targeted Promotion Algorithm Setting Tables
Model 5: Customer Life Time Value
Customer Life Time Value Source
Customer Life Time Value Output Target Attribute: TOT_PYMT_RVN_LAST_MO
Customer Life Time Value Algorithms
Customer Life Time Value Algorithm Setting Tables
Model 6: Customer Life Time Survival Value
Customer Life Time Value (LTV) Survival Source
Customer Life Time Value Survival Output Target Attribute: AGE_ON_NET_NBR
Customer Life Time Value Survival Algorithms
Customer Life Time Value Survival Algorithm Setting Tables
Model 7: Customer Sentiment
Customer Sentiment Source
Customer Sentiment Output
Customer Sentiment Algorithm
Customer Sentiment Algorithm Setting Tables
Oracle Communications Data Model Mining Setting Tables
Oracle Communications Data Model Data Mining Related Tables
Data Mining Package Customer Life Time Value Computation
Prepaid Customer Life Time Value Computation
Postpaid Customer Life Time Value Computation
11
Oracle Communications Data Model Utility Scripts
Calendar Population
Calendar Population Scripts
How to Populate Calendar Data
Part III Sample Reports
12
Oracle Communications Data Model Reports
Customer Management Reports
Customer Acquisition
Customer Growth Rate
Customer Segmentation
Customer Life Time Value
Customer Churn Analysis
Customer Churn Prediction
Revenue Reports
Revenue Analysis and Forecast
Revenue Assurance
Sales Analysis
Debt Collection
Refund and Adjustment
Customer Agreements
Product Specification Management Reports
Product Management
Average Profit per Customer
Provisioning and Activation Reports
Activations and Services
Customer Order Analysis
Network Reports
Network Analysis
Network Health Analysis
Network Usage
Marketing Reports
Targeted Promotion Lift and List
Customer Market Share Analysis
Current Customer Base Analysis
Cost and Contribution Reports
Operational Finance Analysis
Profitability Analysis
Partner Management Reports
Roaming Partner Settlement
Churn Outliner by Partner
Partner Content Sales
Commissions
Part IV Appendices
A
Control Tables
Intra-ETL Load Parameters Control Table
Intra-ETL OLAP Mapping Control Table
Intra-ETL Monitoring Process Control Tables
B
Oracle Communications Data Model Business Use Case
Sample Use Case: Introduction
Sample Use Case 1: Setting Up the Business Unit Organization
Sample Use Case 2: Acquiring a New Customer (with Family Plan)
Sample Use Case 3: Service Implementation
Sample Use Case 4: Storing Customer Call Data
Sample Use Case 5: Customer Billing
Sample Use Case 6: Changing Plan and Billing Address
Sample Use Case 7: Targeted Promotion for Video-on-Demand Services
Sample Use Case 8: Retention of Terminating Agreement
Sample Use Case 9: Dealer and Employee Sales Commission
Sample Use Case 10: Handling a Service Problem
Sample Use Case 11: Implementing a Business Area
C
Oracle Communications Data Model Assumptions
Understanding General Entities
Understanding Product Offering and Specification Entities
Understanding Party, Party Subtypes, and Party Role
Understanding Events and Usage Entities
About Business Interactions
About Agreements
About BSS/OSS Interaction Events
About Usage Events (UDR Events)
About Process Events
Understanding Account and Agreement Entities
Data Model and Entity Notes
D
Physical Table and Logical Data Model Changes for Release 11.3.2
Oracle Communications Data Model PDM Release 11.3.1 to Release 11.3.2
Oracle Communications Data Model LDM Release 11.3.1 to Release 11.3.2
Index
Scripting on this page enhances content navigation, but does not change the content in any way.