Oracle Utilities Extractors and Schema for Network Management System Data Mapping Guide
Overview
Terminologies
<Table Name>
Data Maps for Oracle Utilities Network Management System
Dimensions
Account Type
Alarm Log
Call Info
City
Control Zone
Control Zone Secondary
Crew
Crew Type
Customers Out
Damage Assessment
Damage Assessment Status
Damage Part
Damage Type
Device Dimension
Estimated Restoration Duration
Event
Event Status
Exclusion Detail
Feeder
Major Event Snapshot Type
Meter
Network Premise
Outage Duration
Outage Duration Deviation
Phase
Storm
Storm Outage Type
Supply Node Lookup
Switch Plan
Switch Plan Jobs Relation
Switch Plan State
Shared Dimensions
Account
Address
Person
Premise
User
User Defined Dimensions
Abnormal Device Log UDD1
Abnormal Device Log UDD2
Call UDD1
Call UDD2
City Outage UDD1
City Outage UDD2
Control Zone Outage UDD1
Control Zone Outage UDD2
Crew UDD1
Crew UDD2
Crew Activity UDD1
Crew Activity UDD2
Customer Outage UDD1
Customer Outage UDD2
Customer Recent Outage UDD1
Customer Recent Outage UDD2
Damage Assessment UDD1
Damage Assessment UDD2
Damage Assessment Detail UDD1
Damage Assessment Detail UDD2
Job UDD1
Job UDD2
Outage UDD1
Outage UDD2
Recent Call UDD1
Recent Call UDD2
Recent Crew UDD1
Recent Crew UDD2
Recent Job UDD1
Recent Job UDD2
Storm UDD1
Storm UDD2
Switch Plan UDD1
Switch Plan UDD2
Switch Plan Segmentation UDD1
Switch Plan Segmentation UDD2
Switch Plan State UDD1
Switch Plan State UDD2
Facts
Abnormal Device Log
Call
City Outage
Control Zone Outage
Crew
Crew Activity
Customer Outage
Damage Assessment
Damage Assessment Detail
Feeder Delivered Load
Job
Outage
Recent Call
Recent Crew
Recent Customer Outage
Recent Job
Storm
Switch Plan
Switch Plan Segmentation
Switch Plan State
Views
Job Notes
Estimated Restoration Time Change Log
Crew Vehicles
Crew Vehicle Mapping
Crew Vehicle Types
Switchman Audit Log
Switchman Implementation Supply Nodes
Switchman Safety Documents
Switchman Steps
Switchman Sheet
Switchman Sheet CLS
Switchman Sheet Documents
Oracle Utilities Extractors and Schema for Network Management System Data Mapping Guide
Oracle Utilities Extractors and Schema for Oracle Utilities Network Management System Release 2.8.0.0 Data Mapping Guide