Oracle Utilities Extractors and Schema for Meter Data Management Data Mapping Guide
Overview
Terminologies
<Table Name>
Data Maps for Oracle Utilities Meter Data Management
Dimensions
Consumption Snapshot Type Dimension
Contact Dimension
Days Since Last Normal Measurement Dimension
Days Since Last Usage Transaction Type Dimension
Meter Device Dimension
Device Event BO Status Dimension
Device Activity Type Dimension
Device Activity BO Status Dimension
Device Event Type Dimension
Exception Severity Dimension
Exception Type Dimension
IMD Type Dimension
Installation Event BO Status Dimension
Measurement Condition Code Dimension
Measuring Component Dimension
Service Point BO Status Dimension
Service Point Dimension
Service Provider Dimension
Unreported Usage Analysis Snapshot Type Dimension
UOM/ TOU Dimension
UOM/ TOU/ SQI Dimension
Usage Calculation Group Dimension
Usage Subscription Dimension
VEE Rule Dimension
Shared Dimensions
Account Dimension
Address Dimension
Person Dimension
Premise Dimension
Service Agreement Dimension
Facts
Device Activity Fact
Device Event Fact
Installation Event Fact
Service Point Accumulation Fact
Service Point Snapshot Fact
Unreported Usage Analysis Snapshot Fact
Usage Snapshot Fact
VEE Exception Snapshot Fact
MDM Objects Referenced in Oracle Utilities Extractors and Schema
Measured Quantity Dimension Views
Quality Count Dimension View
Timeliness Count Dimension View
Timeliness Quantity Dimension View
Measuring Component Dimension View
Time of Use Map Dimension Table
Time of Use Language Dimension Table
Time of Use Map Language Dimension Table
Measured Quantity Fact View
Quality Count Fact View
Timeliness Count Fact View
Timeliness Quantity Fact View
Oracle Utilities Extractors and Schema for Meter Data Management Data Mapping Guide
Oracle Utilities Extractors and Schema for Oracle Utilities Meter Data Management Release 2.9.0.0.0 Data Mapping Guide