Oracle Utilities Extractors and Schema for Customer Care and Billing Data Mapping Guide
Overview
Terminologies
<Table Name>
Data Maps for Oracle Utilities Customer Care and Billing
Dimension Tables
Account
Address
Adjustment Type
Bill Cancel Reason
Bill Cycle Schedule
Bill Segment Status
Billing Day in Window
Campaign
Case Condition
Case Type Status
Collectible Process Status
Collectible Process Template
Collection Event Type
Customer Contact Type
Date
Days of Unbilled Usage
Days Since Last Frozen BS
Days to Window Closure
Fiscal Period
Financial Transaction Type
General Ledger
Installments Count
Measurement Type
Order Cancel Reason
Order Status
Package
Pay Method
Pay Plan Status
Pay Plan Type
Payment Arrangement Status
Payment Cancel Reason
Rate
Recurring Charge Amounts
Service Agreement Status
Service Quantity Identifier
Tender Source
Tender Status
Tender Type
Time
Time of Use
Uncollectible Event Type
Uncollectible Process Status
Uncollectible Process Template
Unit of Measure
Message
Person
Premise
Service Agreement
To Do
To Do Priority
To Do Role
To Do Skill
To Do Status
To Do Type
User
Fact Tables
Billed Usage
Case
Case Log
Collectible Event
Collectible Process
Customer Contact
Financial
Financial General Ledger
Order
Pay Plan Accumulation
Pay Plan Snapshot
Payment Arrangement Accumulation
Payment Arrangement Snapshot
Payment Tender
Service Agreement Arrears Snapshot
Service Agreement Billing
Service Agreement
Uncollectible Event
Uncollectible Process
Recent To Do Entry
To Do Entry
Oracle Utilities Extractors and Schema for Customer Care and Billing Data Mapping Guide
Oracle Utilities Extractors and Schema for Oracle Utilities Customer Care and Billing Release 2.8.0.1.0 Data Mapping Guide