Go to main content
1/33
Contents
List of Tables
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
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
PKG_DWD_ACCT_BAL_MO Package
PKG_DWD_ACCT_DEBT_MO Package
PKG_DWD_ACCT_FRST_ACTVTY Package
PKG_DWD_ACCT_LAST_ACTVTY Package
PKG_DWD_ACCT_PMT_MTD_STAT_HST Package
PKG_DWD_ACCT_PYMT_DAY Package
PKG_DWD_AGRMNT Package
PKG_DWD_AGRMNT_CHG Package
PKG_DWD_AGRMNT_RVN_DAY Package
PKG_DWD_CANBLZTN_DTL_DAY Package
PKG_DWD_CMPGN_HIST_DAY Package
PKG_DWD_CNT_DAY Package
PKG_DWD_CNTCT_CNTR_DAY Package
PKG_DWD_CUST_DNA Package
PKG_DWD_CUST_EQPMNT_INSTLTN_DAY Package
PKG_DWD_CUST_ORDR_DAY Package
PKG_DWD_CUST_ORDR_LN_ITEM_DAY Package
PKG_DWD_CUST_RFMP_SCR Package
PKG_DWD_CUST_SKU_SL_RETRN_DAY Package
PKG_DWD_DATA_USG_DAY Package
PKG_DWD_GIVE_AWAY_ITEM_DAY Package
PKG_DWD_INV_ADJ_ITEM_DAY Package
PKG_DWD_INV_POSN_ITEM_DAY Package
PKG_DWD_INV_RCPT_ITEM_DAY Package
PKG_DWD_INV_UNAVL_ITEM_DAY Package
PKG_DWD_INV_XFER_ITEM_DAY Package
PKG_DWD_INVC Package
PKG_DWD_INVC_AGNG_DAY Package
PKG_DWD_NBR_PRT_DAY Package
PKG_DWD_POS_TNDR_FLOW Package
PKG_DWD_PRCS_INVC_DAY Package
PKG_DWD_PRPD_ACCT_STTSTC_DAY Package
PKG_DWD_RTL_SL_RETRN_ITEM_DAY Package
PKG_DWD_RVN_DAY Package
PKG_DWD_SPLMNTR_SRVC_USG Package
PKG_DWD_SRVC_PRBLM_DAY Package
PKG_DWD_STORE_EFFNCY_DAY Package
PKG_DWD_VAS_SBRP_QCK_SUMM Package
PKG_DWD_VAS_USG_DAY Package
PKG_DWD_VOI_CALL_DAY 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
Communications Data Mining with Data Miner
Data Mining Miner Architecture
Data Model Mining Result Tables
Additional Data Model Mining Tables
Prepaid Churn Prediction with Oracle Data Miner
Postpaid Churn Prediction with Oracle Data Miner
Customer Profiling with Oracle Data Miner
Customer Lifetime Value
Customer Lifetime Survival Value
Customer Sentiment
Targeted Promotion
12
Oracle Communications Data Model Utility Scripts
Calendar Population
Calendar Population Scripts
How to Populate Calendar Data
Part III Sample Reports
13
Oracle Communications Data Model Reports
Customer Management Reports
Customer Acquisition
Customer Acquisition
Customer Acquisition Forecast
Customer Growth Rate
Customer Growth Rate
Customer Growth Trend Forecast
Customer Segmentation
Customer Segments
Customer Segmentation Details
Churn by Customer Segments
Churn Predict by Customer Segment
Customer Life Time Value
Customer Life Time Value
Customer by Life Time Value Band
Customer by Life Time Span Category
Customer Life Time Span Detail
Customer Churn Analysis
Customer Churn Rate
Customer Churn Statistics
Churn Reason Distribution
Churn Outlier by Site (Building)
Churn Outlier by Sales Agent
Complain Rate Outlier by Business Unit
Customer Churn Prediction
Retention Cumulative Gain
Retention Cumulative Gain & Lift Prepaid
Retention Cumulative Gain & Lift Postpaid
Model Performance Metrics Prepaid
Model Performance Metrics Postpaid
Prepaid Customer Churn Factor Rank
Postpaid Customer Churn Factor Rank
Predicted Churn Customer Report by Revenue Band
Churn Profile DT (Decision Tree) Rule
Churn Prediction by (SVM result)
Revenue Management Reports
Revenue Analysis and Forecast
Monthly Revenue
Revenue Forecast
Average Revenue per User (ARPU)
Average Revenue per Employee
Revenue Assurance
CDR Revenue Compared to Collected Revenue
Percent of Suspended xDRs
Uncollected Revenue Percentage
Revenue Assurance
Sales Analysis
Gross Sales
Net Sales
Debt Collection
Debt Aging
Recovered Revenue Value
External Debt Collection
Adjustment to Customer
Refund and Adjustment
Refund to Customer
Invoice Adjustment
Customer Agreements
Customer Sum of Future Plans
Monthly Future Plan Drop-Out
Monthly Contract Sum Loss
Product Management Reports
Product Management
Product Performance
Average Profit per Customer
Service Fulfillment Reports
Activations and Services
Activation and Service Orders
Customer Order Analysis
Order Volume by Order Status
Order Volume by Order Type
Order Volume by Product Specification
Order Change per Quarter
Order Volume by Product Specification Type
Order Volume per Month
Fall Out Rate by Product Specification Type
Network Management Reports
Network Analysis
Network Capacity
Minutes of Usage
Airtime per Subscription
Load During Busy Hours
Network Health Analysis
Traffic by Connection
Connections per Site
Dropped Call Rate
Call Failure Rate
Congestion
Connection by Geography
Connection by Voice Channel
Network Usage
Number of Emergency Calls
Number of Call by Call Service Type
Number of Calls by Roaming Type
Minutes of Usage by Call Type
Marketing Reports
Targeted Promotion Lift and List
Customer Promotion List
Response Cumulative Gain
Customer Market Share Analysis
Customer Market Share Report
Current Customer Base Analysis
Current Customer Base
Customer Base Organization Share
Customer Base Product Share
Finance Reports
Operational Finance Analysis
Operating Cost
Average Operating Cost per Customer
Average operating Cost per Employee
Investment Cost
Advertising Cost Report
Average Cost of Controlling Attrition per Employee
Profitability Analysis
Total Profit
Average Profit per Customer
Average Profit per Employee
Partner Management Reports
Roaming Partner Settlement
Roaming Partner Settlement Summary
Churn Outliner by Partner
Churn Outliner by Partner
Partner Content Sales
Partner Content Sales
Commissions
Track Dealer Commission and Performance
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 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 Business Interaction Item Tables
About Event Party 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
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
C
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
Index
Scripting on this page enhances content navigation, but does not change the content in any way.