Go to main content
2/23
List of Tables
1-1 Oracle Development Tools Used with Oracle Utilities Data Model
1-2 Oracle Utilities Data Model Foundation Layer Components
1-3 Oracle Utilities Data Model Analytic Layer Components
1-4 Business Areas
2-1 Utilities Data Model Entities A-H
2-2 Utilities Data Model Entities I-P
2-3 Utilities Data Model Entities Q-Z
3-1 Account Total
3-2 Account Detail
3-3 Customer Total
3-4 Customer Detail
3-5 Feeder Total
3-6 Feeder Detail
3-7 Geography Zone All States
3-8 Geography Zone: State
3-9 Geography Zone: City
3-10 Geography Zone Usage Point
3-11 Hour Total
3-12 Hour Detail
3-13 Household Total
3-14 Household Detail
3-15 Manufacturer Total
3-16 Manufacturer Detail
3-17 Meter Total
3-18 Meter Detail
3-19 Operational Total
3-20 Operational Substation
3-21 Operational Feeder
3-22 Operational Transformer Tank
3-23 Operational Usage Point
3-24 Organization Total
3-25 Organization Business Unit Detail
3-26 Outage Record Total
3-27 Outage Record Detail
3-28 Postcode Total
3-29 Postcode Detail
3-30 Product Asset Model Total
3-31 Product Asset Model Detail
3-32 Region All Regions
3-33 Region Region
3-34 Region Sub Region
3-35 Region Usage Point
3-36 Service Location Total
3-37 Service Location Detail
3-38 Substation Total
3-39 Substation Detail
3-40 Time TTime
3-41 Time Year
3-42 Time Quarter
3-43 Time Month
3-44 Time Day
3-45 Time Month Hour Time
3-46 Time Month Hour Year
3-47 Time Month Hour Month
3-48 Time Month Hour Day
3-49 Time Month Total Time
3-50 Time Month TM Year
3-51 Time Month TM-Month
3-52 Time Month Hour Total Time Hour
3-53 Time Month Hour TMH-Year
3-54 Time Month Hour TMH-Month
3-55 Time Of Use Total Time
3-56 Time Of Use
3-57 TOU Time Total
3-58 TOU Time TOU-Year
3-59 TOU Time TOU-Quarter
3-60 TOU Time TOU-Month
3-61 TOU Time TOU-Day
3-62 Time Season Month Total
3-63 Time Season Month TSM-Year
3-64 Time Season Month TSM-Quarter
3-65 Time Season Month TSM-Month
3-66 Time Season Month Hour TSMH
3-67 Time Season Month Hour TSMH-Year
3-68 Time Season Month Hour TSMH-Quarter
3-69 Time Season Month Hour TSMH-TSMH-Month
3-70 Time Season Month Hour TSMH-Day
3-71 Transformer Total
3-72 Transformer Detail
3-73 Usage Point Total
3-74 Usage Point Detail
3-75 Usage Point Location Total
3-76 Usage Point Location Detail
3-77 Address Location Total
3-78 Address Location Detail
3-79 Asset InfoTotal
3-80 Asset Info Detail
3-81 Demand Response Program Total
3-82 Demand Response Program Detail
3-83 Outage Report Total
3-84 Outage Report Detail
3-85 Product Offering Total
3-86 Product Offering Detail
3-87 Reading Type Total
3-88 Reading Type Detail
3-89 Usage Point Group Total
3-90 Usage Point Location Detail
3-91 Zone Total
3-92 Zone Detail
4-1 Table Name Prefix Conventions
4-2 Other Table Name Prefix Conventions
4-3 Reference Tables
4-4 Lookup Tables
4-5 Base Tables
4-6 Oracle Utilities Data Model Derived Tables
4-7 Aggregate Tables
4-8 Temporary Oracle Utilities Data Model Tables
4-9 Control Tables
4-10 Sequence Name for Oracle Utilities Data Model
4-11 OLAP Cube Materialized Views in oudm_sys Schema
4-12 OLAP Cube Views in oudm_sys schema
5-1 Entity Mapping Table: Logical to Physical Mapping A to M
5-2 Entity Mapping Table: Logical to Physical Mapping: N to Z
6-1 Physical Data Model Partitioning
7-1 DWD_ACCT_ARRER_MO Package Business Rules
7-2 DWD_ACCT_BAL_MO Lookup Values
7-3 DWD_ACCT_DEBT_DAY Package Business Rules
7-4 DWD_ACCT_DEBT_DAY Lookup Values
7-5 DWD_ACCT_PMT_DAY Business Rules
7-6 PKG_DWD_ACCT_STAT_MO Business Rules
7-7 PKG_DR_PROG_LD_RDCTN_RGN_DAY Business Rules
7-8 PKG_DWD_END_DVC_EVT_CUST_DAY Package Business Rules
7-9 PKG_DWD_END_DVC_EVT_DVC_DAY Business Rules
7-10 DWD_END_DVC_EVT_DVC_DAY Lookup Values
7-11 PKG_DWD_MTR_RDNG_DAY Business Rules
7-12 PKG_DWD_MTR_RDNG_DAY Lookup Values
7-13 DWD_MTR_RDNG_HR Business Rules
7-14 DWD_MTR_RDNG_HR Lookup Values
7-15 PKG_DWD_OUTG_DAY Package Business Rules
7-16 DWD_END_DVC_EVT_DVC_DAY Business Rules
7-17 DWD_RLBLTY_IND_CITY_MO Business Rules
7-18 DWD_RLBLTY_IND_CITY_MO Business Rules
8-1 Account (ACCT) Levels and Hierarchies
8-2 Account Long Description Attribute Mapping
8-3 Account Short Description Attribute Mapping
8-4 Customer (CUST) Levels and Hierarchies
8-5 Customer Long Description Attribute Mapping
8-6 Customer Short Description Attribute Mapping
8-7 Geography Usage Point (GEOUP) Levels and Attributes
8-8 Geography Usage Point Long Description Attribute Mapping
8-9 Geography Usage Point Short Description Attribute Mapping
8-10 Manufacturer (MNFCTR) Levels and Hierarchies
8-11 Manufacturer Long Description Attribute Mapping
8-12 Manufacturer Short Description Attribute Mapping
8-13 Meter (MTR) levels and Hierarchies
8-14 Meter Long Description Attribute Mapping
8-15 Meter Short Description Attribute Mapping
8-16 Operational Usage Point (OPTUP) Levels and Hierarchies
8-17 Operational Usage Point Long Description Attribute Mapping
8-18 Operational Usage Point Short Description Attribute Mapping
8-19 Regional Usage Point (RGUP) Levels and Hierarchies
8-20 Regional Usage Point Long Description Attribute Mapping
8-21 Regional Usage Point Short Description Attribute Mapping
8-22 Time (TIME) Levels and Hierarchies
8-23 Time Long Description Attribute Mapping
8-24 Time Short Description Attribute Mapping
8-25 Time Time Number Attribute Mapping
8-26 Time Time Span Attribute Mapping
8-27 Time Start Date Attribute Mapping
8-28 Time End Date Attribute Mapping
8-29 Usage Point (USGPNT) Levels and Hierarchies
8-30 Usage Point Long Description Attribute Mapping
8-31 Usage Point Short Description Attribute Mapping
9-1 Meter Reading Account Cube Dimensions and Load Level
9-2 Meter Reading Account Cube Aggregation and Order
9-3 Meter Reading Account Cube Descriptions and Physical Columns
9-4 End Device Event Customer Cube Dimensions and Load Level
9-5 End Device Event Customer Cube Aggregation and Order
9-6 End Device Event Customer Cube Description and Physical Columns
9-7 End Device Event by Device Cube Dimensions and Load Level
9-8 End Device Event by Device Cube Aggregation and Order
9-9 End Device Event by Device Cube Description and Physical Columns
9-10 Meter Reading Geo Usage Point Cube Dimensions and Load Level
9-11 Meter Reading Geo Usage Point Cube Aggregation and Order
9-12 Meter Reading Geo Usage Point Cube Description and Physical Columns
9-13 Meter Reading Operational Usage Point Cube Dimensions and Load Level
9-14 Meter Reading Operational Usage Point Cube Aggregation and Order
9-15 Meter Reading Operational Usage Point Cube Description and Physical Columns
9-16 Meter Reading Regional Usage Point Cube Dimensions and Load Level
9-17 Meter Reading Regional Usage Point Cube Aggregation and Order
9-18 Meter Reading Regional Usage Point Cube Description and Physical Columns
9-19 Meter Reading Customer Cube Dimensions and Load Level
9-20 Meter Reading Customer Cube Aggregation and Order
9-21 Meter Reading Regional Usage Point Cube Description and Physical Columns
10-1 Oracle Utilities Data Model Algorithm Used
10-2 DWR_CUST_SGMNT Data Mining Model Details Table
10-3 DWR_CUST_SGMNT_DTL Data Mining Model Details Table
10-4 DWD_CUST_DR_PROG_PROFILE
10-5 Setting Values for STEP1 Segmentation
10-6 Data Mining Setting Table
12-1 Reliability Selections for Reports
13-1 Fields in Console Page to Create Data Model Users
A-1 DWC_ETL_PARAMETER Table
A-2 ETL Parameters in the DWC_OLAP_ETL_PARAMETER Table
A-3 DWC_INTRA_ETL_PROCESS Columns
A-4 DWC_INTRA_ETL_ACTIVITY Columns
Scripting on this page enhances content navigation, but does not change the content in any way.