Oracle Utilities Extractors and Schema for Work and Asset Management Data Mapping Guide
Overview
Terminologies
<Table Name>
Data Maps for Oracle Utilities Work and Asset Management
Dimensions
Asset Age Bucket
Asset Disposition
Asset Install Age Bucket
Number of Cycles Overdue Bucket
Owning Organization
Planner
Resource Type
Service History
Work Order
Work Order Activity
Work Order Activity BO Status
Work Order BO Status
Shared Dimensions
Address
Asset
Asset Inspection Status
Crew Dimension
Fiscal Calendar
Location
Service History Type
User Defined Dimensions
Activity UDD1 Dimension
Activity UDD2 Dimension
Asset FT UDD1 Dimension
Asset FT UDD2 Dimension
Asset Snapshot UDD1 Dimension
Asset Snapshot UDD2 Dimension
Location Snapshot UDD1 Dimension
Location Snapshot UDD2 Dimension
Work Order UDD1 Dimension
Work Order UDD2 Dimension
Facts
Activity
Asset FT
Asset Snapshot
Location Snapshot
Service History
Work Order
Oracle Utilities Extractors and Schema for Work and Asset Management Data Mapping Guide
Oracle Utilities Extractors and Schema for Oracle Utilities Work and Asset Management Release 2.8.0.1.0 Data Mapping Guide