4 Oracle Utilities Data Model Physical Data Model

This chapter provides information about the physical data model of Oracle Utilities Data Model.

This chapter includes the following sections:

• Introduction to Oracle Utilities Data Model Physical Data Model
  
• Reference Tables
  
• Lookup Tables
  
• Base Tables
  
• Derived Tables
  
• Aggregate Tables
  
• Temporary and Other Tables
  Briefly describes the temporary and control tables in Oracle Utilities Data Model.
• Sequences in Oracle Utilities Data Model
  
• Compressed Tables
  
• Oracle Utilities Data Model OLAP Cube MV, Cube View
  

Introduction to Oracle Utilities Data Model Physical Data Model

The Physical Data Model of the Oracle Utilities Data Model is the physical manifestation of the logical data model into database tables and relationships (or foreign key constraints). Partitions, indexes, and Materialized Views have been added to aid performance.

Note:

Do not make changes to the schemas as such changes are not supported.

Oracle Utilities Data Model provides the following types of tables:

• Reference tables contain information that is usually used as dimensions. They usually do not change often (or at all). Typically, Reference tables are PARTY, CUSTOMER, ADDRESS LOCATION, ACCOUNT, SUBSCRIPTION, and so on

• Lookup tables in the foundation layer are added to save the definition of short codes used in other tables.

• Base tables store information about any type of transactions (Invoices, Payments, Business Interactions, and so on). They are usually transformed into facts.

• Derived Tables in the analytic layer are usually transition tables to STARs. They are also leveraged for the Mining models.

• Aggregate Tables, or materialized views, are the STAR schema themselves at a higher level of aggregation. They may be related to the OLAP cubes.

• Other table types, as show in Table 4-2.

For more information on Oracle Utilities Data Model table types, see "What is Oracle Utilities Data Model".

Table 4-1 shows the table name prefix conventions. When you examine the predefined physical model, keep in mind the naming conventions shown in Table 4-1 that use DW (Data Warehouse) prefixes to identify the types of tables and views.

Table 4-1 Table Name Prefix Conventions

Prefix	Description
DWA_	Aggregate table
DWB_	Base transaction table
DWD_	Derived table (Mining included)
DWL_	Lookup table
DWR_	Reference data table

Table 4-2 Other Table Name Prefix Conventions

Prefix	Description
DM$ and DR$	Created when the mining models are trained. Used to store trained model and logs.
CUBE	Created when OLAP cubes are built. Used to store logs and results.

Reference Tables

Table 4-3 briefly describes the Reference tables in Oracle Utilities Data Model.

Table 4-3 Reference Tables

Table Name	More Information
DWR_AC_LN_SGMNT	AC Line Segment
DWR_AC_LN_SGMNT_PHS	AC Line Segment Phase
DWR_ACCMLTR_LMT	Accumulator Limit
DWR_ACCMLTR_LMT_SET	Accumulator Limit Set
DWR_ACCMLTR_LMT_SET_ASGN	Accumulator Limit Set Assignment
DWR_ACCT	Account
DWR_ACCT_AGRMNT_RLTN	Account Agreement Relationship
DWR_ACCT_ASGN	Account Assignment
DWR_ACCT_BAL_GRP	Account Balance Group
DWR_ACCT_BLLG_CYCL_HIST	Account Billing Cycle History
DWR_ACCT_BLLG_FREQNCY_HIST	Account Billing Frequency History
DWR_ACCT_BLLG_PRD_HIST	Account Billing Period History
DWR_ACCT_BSNS_INTRACN_RL	Account Business Interaction Role
DWR_ACCT_CYCL	Accounting Cycle
DWR_ACCT_PREF_INVC_DLVRY	Account Preferred Invoice Delivery
DWR_ACCT_PREF_PYMT_MTHD	Account Preferred Payment Method
DWR_ACCT_PRFL	Account Profile
DWR_ACCT_SGMNT	Account Segment
DWR_ACCT_SGMNT_ASGN_HIST	Account Segment Assignment History
DWR_ACCT_SGMNT_MDL	Account Segmentation Model
DWR_ACPT_TEST	Acceptance Test
DWR_ACTV_POWR_LMT	Active Power Limit
DWR_ADDR_LOC	Address Location
DWR_AGRMNT	Agreement
DWR_AGRMNT_DOC	Agreement Document
DWR_AGRMNT_ITEM	Agreement Item
DWR_AGRMNT_ITEM_PRCNG_STRUCT_ASGN	Agree Item Pricing Struct Assignment
DWR_AGRMNT_USG_PNT_ASGN	Agreement Usage Point Assignment
DWR_AIR_CMPRSR	Air Compressor
DWR_ANLG_LMT	Analog Limit
DWR_ANLG_LMT_SET	Analog Limit Set
DWR_ANLG_LMT_SET_ASGN	Analog Limit Set Assignment
DWR_ANZSC_CLSFCTN	ANZSIC Classification
DWR_APRNT_POWR_LMT	Apparent Power Limit
DWR_ASST	Asset
DWR_ASST_ACTVTY_REC_ASGN	Asset Activity Record Assignment
DWR_ASST_FNCTN	Asset Function
DWR_ASST_INFO	Asset Info
DWR_ASST_LOC	Asset Location
DWR_ASST_MDL	Asset Model
DWR_ASST_MDL_CTLG	Asset Model Catalog
DWR_ASST_MDL_CTLG_ITEM	Asset Model Catalog Item
DWR_ASST_ORG_RL	Asset Organization Role
DWR_ASST_ORG_RL_ASGN	Asset Organization Role Assignment
DWR_ASST_OWNR	Asset Owner
DWR_ASST_PSR_ASGN	Asset PSR Assignment
DWR_ASST_STAT	Asset Status
DWR_ASST_USER	Asset User
DWR_BASE_VLTG	Base Voltage
DWR_BLLG_CYCL	Billing Cycle
DWR_BLLG_FREQNCY	Billing Frequency
DWR_BNK	Bank
DWR_BNK_DRCT_DEBT_CHNL	Bank Direct Debit Channel
DWR_BRKR	Breaker
DWR_BSBR_SECTN	Busbar Section
DWR_BSBR_SECTN_INFO	Busbar Section
DWR_BSHNG	Bushing
DWR_BSNS_CASE	Business Case
DWR_BSNS_HLF_MO	Business Half Month
DWR_BSNS_HLF_YR	Business Half Year
DWR_BSNS_INTRACN_ASGN	Business Interaction Assignment
DWR_BSNS_INTRACN_LOC_ASGN	Business Interaction Location Assignment
DWR_BSNS_INTRACN_VRSN	Business Interaction Version
DWR_BSNS_MO	Business Month
DWR_BSNS_QTR	Business Quarter
DWR_BSNS_UNIT_JB_RL	Business Unit Job Role
DWR_BSNS_WK	Business Week
DWR_BSNS_YR	Business Year
DWR_CAES_PLNT	CAES Plant
DWR_CALL_CNTR	Call Center
DWR_CALL_CNTR_AGNT	Call Center Agent
DWR_CALL_CNTR_SRVC_CAPBLTY	Call Center Service Capability
DWR_CGNRTN_PLNT	Cogeneration Plant
DWR_CHNL	Channel
DWR_CLMP	Clamp
DWR_CLNDR_HLF_MO	Calendar Half Month
DWR_CLNDR_HLF_YR	Calendar Half Year
DWR_CLNDR_MO	Calendar Month
DWR_CLNDR_QTR	Calendar Quarter
DWR_CLNDR_WK	Calendar Week
DWR_CLNDR_YR	Calendar Year
DWR_CLRNCE_ACTN	Clearance Action
DWR_CLRNCE_DOC	Clearance Document
DWR_CMBND_CYCL_PLNT	Combined Cycle Plant
DWR_CMPGN	Campaign
DWR_CMPGN_CHNL	Campaign Channel
DWR_CMPGN_CHNL_ASGN	Campaign Channel Assignment
DWR_CMPGN_CHTRSTC	Campaign Characteristic
DWR_CMPGN_CHTRSTC_VAL	Campaign Characteristic Value
DWR_CMPGN_DOC	Campaign Document
DWR_CMPGN_MGMT_HIST	Campaign Management History
DWR_CMPGN_MSG	Campaign Message
DWR_CMPGN_MSG_DPCT	Campaign Message Depiction
DWR_CMPGN_RLTN	Campaign Relationship
DWR_CMPGN_TERM_VAL	Campaign Term Value
DWR_CMPST_SWTCH_INFO	Composite Switch Info
DWR_CMPTBL_UNIT	Compatible Unit
DWR_CMPTBL_UNIT_PROC_ASGN	Compatible Unit Procedure Assignment
DWR_CNCT_LST	Contact List
DWR_CNCTR	Connector
DWR_CNDCTR	Conductor
DWR_CNDTNG_EQP_PRTCTN_EQP_ASGN	Conducting Eqp Protection Eqp Assignment
DWR_CNFRM_LD	Conform Load
DWR_CNFRM_LD_GRP	Conform Load Group
DWR_CNFRM_LD_SCHL	Conform Load Schedule
DWR_CNSMPTN_TIER	Consumption Tier
DWR_CNSMPTN_TRF_INTRVL	Consumption Tariff Interval
DWR_COLLCTN_AGNCY	Collection Agency
DWR_COMUNICTN_FNCTN	Com Function
DWR_COMUNICTN_LNK	Communication Link
DWR_COMUNICTN_MEDIA	Com Media
DWR_COMUNICTN_MODULE	Com Module
DWR_CONCT_DSCNCT_FNCTN	Connect Disconnect Function
DWR_CONCTVT_ND	Connectivity Node
DWR_CONCTVT_ND_CONTNR	Connectivity Node Container
DWR_COST_CNTR	Cost Center
DWR_CRDT_CTGRY	Credit Category
DWR_CRDT_SCR_PRVDR	Credit Score Provider
DWR_CREW	Crew
DWR_CREW_MBR	Crew Member
DWR_CREW_TYP	Crew Type
DWR_CREW_WRK_TASK_ASGN	Crew Work Task Assignment
DWR_CRNCY_GEO_ENT_ASGN	Currency Geography Entity Assignment
DWR_CRTCL_PK_PRD	Critical Peak Period
DWR_CRVE	Curve
DWR_CURR_LMT	Current Limit
DWR_CURR_RLY	Current Relay
DWR_CURR_TRNSFRMR_INFO	Current Transformer Info
DWR_CUST	Customer
DWR_CUST_ACCT_ASGN	Customer Account Assignment
DWR_CUST_DOC	Customer Document
DWR_CUST_FCNG_SRVC	Customer Facing Service
DWR_CUST_GRP_ASGN	Customer Group Assignment
DWR_CUST_INDVL	Customer Individual
DWR_CUST_OCCSN	Customer Occasion
DWR_CUST_ORDR_DOC	Customer Order Document
DWR_CUST_ORG	Customer Organization
DWR_CUST_OUTG_NOTFCTN_ASGN	Customer Outage Notification Assignment
DWR_CUST_RSTRCT_INFO	Customer Restricted Info
DWR_CUST_RVN_BND_ASGN	Customer Revenue Band Assignment
DWR_CUST_SCR	Customer Score
DWR_CUST_SGMNT	Customer Segment
DWR_CUST_SGMNT_MDL	Customer Segmentation Model
DWR_CUST_SIC_ASGN	Customer SIC Assignment
DWR_CUST_SRC	Customer Source
DWR_CUST_WRK_ASGN	Customer Work Assignment
DWR_CUT	Cut
DWR_CUT_ACTN	Cut Action
DWR_DAY	Day
DWR_DC_CNDCTNG_EQPMNT	DC Conducting Equipment
DWR_DC_LN_SGMNT	DC Line Segment
DWR_DEMAND_RESPN_PROG	Demand Response Program
DWR_DEMAND_TRF_INTRVL	Demand Tariff Interval
DWR_DEMOG_ATRIB	Demography Attribute
DWR_DEMOG_CHTRSTC	Demographic Characteristic
DWR_DEMOG_GRP	Demography Group
DWR_DOC_TYP_GRP_ASGN	Document Type Group Assignment
DWR_DR_PROG_AGRMNT_ASGN	DR Program Agreement Assignment
DWR_DR_PROG_END_DVC_GRP_ASGN	DR Prog End Device Grp Assignment
DWR_DRVD_VAL	Derived Value
DWR_DSCNCTR	Disconnector
DWR_ELCTRCTY_SRVC	Electricity Service
DWR_EMP	Employee
DWR_EMP_JB_RL_ASGN	Employee Job Role Assignment
DWR_EMP_LANG_CAPBLTY	Employee Language Capability
DWR_EMP_RSTRCT_INFO	Employee Restricted Info
DWR_EMP_SCHL	Employee Schedule
DWR_END_DVC	End Device
DWR_END_DVC_CAPBLTY	End Device Capability
DWR_END_DVC_CNTRL_TYP	End Device Control Type
DWR_END_DVC_END_DVC_CTRL_ASGN	End Device End Device Ctrl Assignment
DWR_END_DVC_END_DVC_GRP_ASGN	End Device End Device Grp Assignment
DWR_END_DVC_EVT_DTL	End Device Event Detail
DWR_END_DVC_FNCTN	End Device Function
DWR_END_DVC_GP_END_DVC_CTL_ASN	End Device Grp End Device Ctrl Assignment
DWR_END_DVC_GRP	End Device Group
DWR_END_DVC_INFO	End Device Info
DWR_ENRGY_AREA	Energy Area
DWR_ENRGY_CONSMR	Energy Consumer
DWR_ENRGY_CONSMR_PHS	Energy Consumer Phase
DWR_EQPMNT_CONTNR	Equipment Container
DWR_EXTRNL_CRDT_PRFL	External Credit Profile
DWR_EXTRNL_CRDT_PRFL_ASGN	External Credit Profile Assignment
DWR_EXTRNL_INFO_SRC	External Information Source
DWR_FCT_DVC	FACTS Device
DWR_FEDR	Feeder
DWR_FEDR_SBSTN_ASGN	Feeder Substation Assignment
DWR_FINCL_INFO	Financial Info
DWR_FLT	Fault
DWR_FLT_IND_INFO	Fault Indicator Info
DWR_FREQNCY_CONVRTR	Frequency Converter
DWR_FSCL_QTR	Fiscal Quarter
DWR_FSCL_YR	Fiscal Year
DWR_FUSE	Fuse
DWR_FXBLE_CHTRSTC	Flexible Characteristic
DWR_GATE_INPUT_PIN	Gate Input Pin
DWR_GEN_UNIT_OP_COST_CRVE	Gen Unit Op Cost Curve
DWR_GEN_UNIT_OP_SCHL	Gen Unit Op Schedule
DWR_GEO_BLDG	Geography Building
DWR_GEO_CITY	Geography City
DWR_GEO_CMPLX	Geography Complex
DWR_GEO_CNTRY	Geography Country
DWR_GEO_CNTY	Geography County
DWR_GEO_DEMOG_ATRIB	Geography Demography Attribute
DWR_GEO_DEMOG_GRP	Geography Demographic Group
DWR_GEO_DEMOG_VAL	Geography Demography Value
DWR_GEO_ENT	Geography Entity
DWR_GEO_ENT_ASGN	Geography Entity Assignment
DWR_GEO_ENT_HRCHY_LVL_ASGN	Geography Entity Hier Level Assignment
DWR_GEO_HRCHY	Geography Hierarchy
DWR_GEO_HRCHY_LVL	Geography Hierarchy Level
DWR_GEO_HRCHY_LVL_ASGN	Geography Hierarchy Level Assignment
DWR_GEO_LVL	Geography Level
DWR_GEO_LVL_ATRIB	Geography Level Attribute
DWR_GEO_LVL_ATRIB_VAL	Geography Level Attribute Value
DWR_GEO_RGN	Geography Region
DWR_GEO_SB_RGN	Geography Sub Region
DWR_GEO_STATE	Geography State
DWR_GEO_STREET	Geography Street
DWR_GEO_WORLD	Geography World
DWR_GL_ACCT	GL Account
DWR_GL_ACCT_ASGN	GL Account Assignment
DWR_GL_ACCT_SGMNT	GL Account Segment
DWR_GL_COST_CNTR_SGMNT	GL Cost Center Segment
DWR_GL_LDGR	GL Ledger
DWR_GL_LDGR_ACCT_ASGN	GL Ledger Account Assignment
DWR_GL_ORG_BSNS_UNIT_SGMNT	GL Org Bsns Unit Segment
DWR_GL_PRD	GL Period
DWR_GL_PROD_SPECFTN_SGMNT	GL Product Specification Segment
DWR_GL_PROJ_SGMNT	GL Project Segment
DWR_GL_SBLDGR	GL Subledger
DWR_GL_SGMNT	GL Segment
DWR_GNRC_ACTN	Generic Action
DWR_GNRTNG_UNIT	Generating Unit
DWR_GNRTNG_UNIT_ROTTNG_MC_ASGN	Generating Unit Rotating Machine Assignment
DWR_GRND_DSCNCTR	Ground Disconnector
DWR_GRND_SWTCH	Ground Switch
DWR_GRS_TO_NET_ACTV_POWR_CRVE	Gross To Net Active Power Curve
DWR_HEAD_END_SYS	Head End System
DWR_HH	Household
DWR_HR	Hour
DWR_HR_TIME_OF_USE_ASGN	Hour Time of Use Assignment
DWR_HYDRO_GNRTNG_UNIT	Hydro Generating Unit
DWR_INCDNT_WRK_ASGN	Incident Work Assignment
DWR_INDVL_DEMOG_VAL	Individual Demography Value
DWR_INSTLMNT_AGRMNT	Installment Agreement
DWR_INTRACN_CHNL	Interaction Channel
DWR_INTRACN_NAVGTN_ITEM	Interaction Navigation Item
DWR_INVC_ADJ_QTA	Invoice Adjustment Quota
DWR_IRGLR_INTRVL_SCHL	Irregular Interval Schedule
DWR_IRGLR_TIME_PNT	Irregular Time Point
DWR_JB	Job
DWR_JB_RL	Job Role
DWR_JMPR	Jumper
DWR_JMPR_ACTN	Jumper Action
DWR_JNT	Joint
DWR_LD_AREA	Load Area
DWR_LD_BRK_SWTCH	Load Break Switch
DWR_LD_GRP	Load Group
DWR_LD_RESPN_CHTRSTC	Load Response Characteristic
DWR_LIFE_CYCL_DT	Lifecycle Date
DWR_LMT	Limit
DWR_LMT_SET	Limit Set
DWR_LN	Line
DWR_LOC	Location
DWR_LYLTY_PROG	Loyalty Program
DWR_MEDIA_OBJ	Media Object
DWR_MEDIA_OBJ_ASGN	Media Object Assignment
DWR_MKT_AREA	Market Area
DWR_MKT_AREA_LVL	Market Area Level
DWR_MKT_PLN_DOC_REQRMNT	Market Plan Document Requirement
DWR_MKT_RL	Market Role
DWR_MKT_SGMNT	Market Segment
DWR_MKT_SGMNT_INCLSN	Market Segment Inclusion
DWR_MNFCTR	Manufacturer
DWR_MNTNR	Maintainer
DWR_MSRMNT_LOC	Measurement Location
DWR_MSRMNT_VAL_QLTY	Measurement Value Quality
DWR_MSRMNT_VAL_SRC	Measurement Value Source
DWR_MTR	Meter
DWR_MTR_IDNT	Meter Identifier
DWR_MTR_RGSTER_ASGN	Meter Register Assignment
DWR_MTR_SRVC_WRK	Meter Service Work
DWR_NAICS_CLSFCTN	NAICS Classification
DWR_NON_CNFRM_LD	Non Conform Load
DWR_NON_CNFRM_LD_GRP	Non Conform Load Group
DWR_NON_CNFRM_LD_SCHL	Non Conform Load Schedule
DWR_NUCLR_GNRTNG_UNIT	Nuclear Generating Unit
DWR_OPERTNG_PRTCPNT	Operating Participant
DWR_OPERTNG_SHR	Operating Share
DWR_OPRN_TAG	Operation Tag
DWR_OPRTNL_LMT	Operational Limit
DWR_OPRTNL_LMT_SET	Operational Limit Set
DWR_OPRTNL_RSTRCT	Operational Restriction
DWR_ORCL_GMTRY	Oracle Geometry
DWR_ORG_AREA	Organization Area
DWR_ORG_BNR	Organization Banner
DWR_ORG_BSNS_ENT	Organization Business Entity
DWR_ORG_BSNS_UNIT	Organization Business Unit
DWR_ORG_CHAIN	Organization Chain
DWR_ORG_CMPNY	Organization Company
DWR_ORG_CRPRT	Organization Corporate
DWR_ORG_DEMOG_VAL	Organizational Demography Value
DWR_ORG_DSTRCT	Organization District
DWR_ORG_HRCHY	Organization Hierarchy
DWR_ORG_HRCHY_LVL	Organization Hierarchy Level
DWR_ORG_HRCHY_LVL_ASGN	Organization Hierarchy Level Assignment
DWR_ORG_HRCHY_VRSN	Organization Hierarchy Version
DWR_ORG_LVL	Organization Level
DWR_ORG_LVL_ATRIB_VAL	Organization Level Attribute Value
DWR_ORG_LVL_ATTR	Organization Level Attributes
DWR_ORG_MKT_DATA	Organization Market Data
DWR_ORG_RGN	Organization Region
DWR_ORG_RL	Organization Role
DWR_ORG_SRVC_WBSITE	Organization Service Website
DWR_ORG_WRHS	Organization Warehouse
DWR_OTHR_INDVL	Other Individual
DWR_OUTG_CD	Outage Code
DWR_OUTG_NOTFCTN	Outage Notification
DWR_OUTG_PLN	Outage Plan
DWR_OUTG_REC_CD_ASGN	Outage Record Code Assignment
DWR_OUTG_RPT	Outage Report
DWR_OUTG_SCHL	Outage Schedule
DWR_OUTG_STEP	Outage Step
DWR_OUTG_STEP_CD_ASGN	Outage Step Code Assignment
DWR_OUTG_USG_PNT_ASGN	Outage Usage Point Assignment
DWR_PBLCTN	Publication
DWR_PER_LGTH_IMPNDNC	Per Length Impedance
DWR_PER_LGTH_PHS_IMPNDNC	Per Length Phase Impedance
DWR_PER_LGTH_SEQ_IMPNDNC	Per Length Sequence Impedance
DWR_PHS_CNCTD_FLT	Phase Connected Fault
DWR_PHS_IMPNDNC_DATA	Phase Impedance Data
DWR_PHS_TAP_CHNG	Phase Tap Changer
DWR_PHS_TAP_CHNG_ASYMTRCL	Phase Tap Changer Asymmetrical
DWR_PHS_TAP_CHNG_LNR	Phase Tap Changer Linear
DWR_PHS_TAP_CHNG_NON_LNR	Phase Tap Changer Non Linear
DWR_PHS_TAP_CHNG_SYMTRCL	Phase Tap Changer Symmetrical
DWR_PHS_TAP_CHNG_TBLR	Phase Tap Changer Tabular
DWR_PHS_TAP_CHNG_TBLR_PNT	Phase Tap Changer Tabular Point
DWR_PIN_VLTG	Pin Voltage
DWR_PLND_OUTG	Planned Outage
DWR_POLE	Pole
DWR_POSTCD	Postcode
DWR_POWR_CUT_ZN	Power Cut Zone
DWR_POWR_SYS_RESRE_LOC	Power System Resource Location
DWR_POWR_TRNSFRMR	Power Transformer
DWR_POWR_TRNSFRMR_END	Power Transformer End
DWR_POWR_TRNSFRMR_INFO	Power Transformer Info
DWR_PRCNG_STRCTR_TRF_ASGN	Pricing Structure Tariff Assignment
DWR_PRCNG_STRUCTR	Pricing Structure
DWR_PRIORITY	Priority
DWR_PRMTN	Promotion
DWR_PRMTN_MSG_RNDRNG	Promotion Message Rendering
DWR_PRMTN_PROD_OFRNG_ASGN	Promotion Product Offering Assignment
DWR_PRMTN_RLTN	Promotion Relationship
DWR_PRMTN_SL_CHNL_ASGN	Promotion Sales Channel Assignment
DWR_PROC	Procedure
DWR_PROC_ASST_ASGN	Procedure Asset Assignment
DWR_PROD_ASST_MDL	Product Asset Model
DWR_PROD_ASST_MDL_FNCTN_ASGN	Product Asset Model Function Assignment
DWR_PROD_OFRNG	Product Offering
DWR_PROD_SBRP	Product Subscription
DWR_PROJ	Project
DWR_PROJ_ELMNT	Project Element
DWR_PROTCTN_EQPMNT	Protection Equipment
DWR_PROTCTN_EQPMNT_INFO	Protection Equipment Info
DWR_PRPSL	Proposal
DWR_PRPSL_RLTN	Proposal Relationship
DWR_PRSPCT	Prospect
DWR_PRSPCT_QLTY_SCR_VAL	Prospect Quality Score Value
DWR_PRTCTD_SWTCH	Protected Switch
DWR_PRTNR_PRMTN_PROG	Partner Promotion Program
DWR_PRTY	Party
DWR_PRTY_ACCT_ASGN	Party Account Assignment
DWR_PRTY_ADDR_LOC_ASGN	Party Address Location Assignment
DWR_PRTY_AGRMNT_RLTN	Party Agreement Relationship
DWR_PRTY_ASGN	Party Assignment
DWR_PRTY_BSNS_INTRACN_RL	Party Business Interaction Role
DWR_PRTY_CNCT_INFO	Party Contact Information
DWR_PRTY_GEO_ENT_ASGN	Party Geography Entity Assignment
DWR_PRTY_MKT_SGMNT_ASGN	Party Market Segment Assignment
DWR_PRTY_PROJ_PRTCPTN	Party Project Participation
DWR_PRTY_RL_ASGN	Party Role Assignment
DWR_PRTY_RL_STAT	Party Role Status
DWR_PTNTL_TRNSFRMR_INFO	Potential Transformer Info
DWR_PYMT_CHNL	Payment Channel
DWR_RATE	Rate
DWR_RATIO_TAP_CHNG	Ratio Tap Changer
DWR_RATIO_TAP_CHNG_TBLR	Ratio Tap Changer Tabular
DWR_RATIO_TAP_CHNG_TBLR_PNT	Ratio Tap Changer Tabular Point
DWR_RCLSR	Recloser
DWR_RDNG_CHNL	Reading Channel
DWR_RDNG_CHNL_IDNT	Reading Channel Identifier
DWR_RDNG_TYP	Reading Type
DWR_REGULTN_SCHL	Regulation Schedule
DWR_RGLR_INTRVL_SCHL	Regular Interval Schedule
DWR_RGLR_TIME_PNT	Regular Time Point
DWR_RGLTNG_CNTRL	Regulating Control
DWR_RGLTNG_COND_EQ	Regulating Cond Eq
DWR_RGSTER	Register
DWR_RMT_CNTRL	Remote Control
DWR_RMT_CONCT_DSCNCT_INFO	Remote Connect Disconnect Info
DWR_RMT_PNT	Remote Point
DWR_RMT_SRC	Remote Source
DWR_RMT_UNIT	Remote Unit
DWR_RMT_UNIT_COMUNCTN_LNK_ASGN	Remote Unit Communication Link Assignment
DWR_ROTTNG_MC	Rotating Machine
DWR_RTNL_NBR	Rational Number
DWR_SB_GEOCL_RGN	Sub Geographical Region
DWR_SB_LD_AREA	Sub Load Area
DWR_SBSTN	Substation
DWR_SCHL_EVT_ASST_ASGN	Scheduled Event Asset Assignment
DWR_SCRPT	Script
DWR_SCRPT_QUES	Script Question
DWR_SEAL	Seal
DWR_SEASON_DAY_TYP_SCHL	Season Day Type Schedule
DWR_SECTNR	Sectionaliser
DWR_SERIES_CMPNSTR	Series Compensator
DWR_SFTY_DOC	Safety Document
DWR_SGMNT_CRTRA	Segment Criteria
DWR_SHNT_CMPNSTR	Shunt Compensator
DWR_SHNT_CMPNSTR_INFO	Shunt Compensator Info
DWR_SHNT_CMPNSTR_PHS	Shunt Compensator Phase
DWR_SIC_ASGN	SIC Assignment
DWR_SL_CHNL	Sales Channel
DWR_SMPL_END_DVC_FNCTN	Simple End Device Function
DWR_SOC_JB	SOC Job
DWR_SOC_JB_CTGRY	SOC Job Category
DWR_SOC_JB_GRP	SOC Job Group
DWR_SRC_SYS	Source System
DWR_SRC_SYS_KEY_MAP	Source System Key Mapping
DWR_SRG_ARSTR_INFO	Surge Arrester Info
DWR_SRVC	Service
DWR_SRVC_COVRG_AREA	Service Coverage Area
DWR_SRVC_COVRG_GEO_DTL	Service Coverage Geo Detail
DWR_SRVC_LOC	Service Location
DWR_SRVC_LOC_IDNT	Service Location Identifier
DWR_SRVC_QTY	Service Quantity
DWR_SRVC_SPPLR	Service Supplier
DWR_STAT	Status
DWR_STATIC_VAR_CMPNSTR	Static Var Compensator
DWR_STEAM_SNDOUT_SCHL	Steam Sendout Schedule
DWR_STN_SPPLY	Station Supply
DWR_STRCTR	Structure
DWR_STRCTR_SPPRT	Structure Support
DWR_STREETLGHT	Streetlight
DWR_SURVEY	Survey
DWR_SWTCH	Switch
DWR_SWTCH_ACTN	Switch Action
DWR_SWTCH_ACTVTY_SFTY_DOC_ASGN	Switching Activity Safety Doc Assignment
DWR_SWTCH_CNCT_DSCNCT_FNC_ASGN	Switch Connect Disconnect Func Assignment
DWR_SWTCH_INFO	Switch Info
DWR_SWTCH_PHS	Switch Phase
DWR_SWTCH_SCHL	Switch Schedule
DWR_SWTCH_SWTCHNG_OPRN_ASGN	Switch Switching Operation Assignment
DWR_SWTCHNG_ACTVTY	Switching Activity
DWR_SWTCHNG_OPRN	Switching Operation
DWR_SWTCHNG_PLN	Switching Plan
DWR_SWTCHNG_STEP	Switching Step
DWR_SWTCHNG_STEP_GRP	Switching Step Group
DWR_SYNCHRCHCK_RLY	Synchrocheck Relay
DWR_SYNCHRNS_MC	Synchronous Machine
DWR_TAG_ACTN	Tag Action
DWR_TAP_CHNG	Tap Changer
DWR_TAP_CHNG_CNTRL	Tap Changer Control
DWR_TAP_CHNG_INFO	Tap Changer Info
DWR_TAP_SCHL	Tap Schedule
DWR_TASK	Task
DWR_THRML_GNRTNG_UNIT	Thermal Generating Unit
DWR_TIME_SCHL	Time Schedule
DWR_TIME_SLT	Time Slot
DWR_TIME_TRF_INTRVL	Time Tariff Interval
DWR_TOOL	Tool
DWR_TPLGCL_ND	Topological Node
DWR_TRBL_TCKT	Trouble Ticket
DWR_TRF	Tariff
DWR_TRF_PRFL	Tariff Profile
DWR_TRF_TRF_PRFL_ASGN	Tariff Tariff Profile Assignment
DWR_TRGT_ACCT	Target Account
DWR_TRGT_AGRMNT	Target Agreement
DWR_TRGT_GEO_AREA	Target Geography Area
DWR_TRGT_MKT_SGMNT	Target Market Segment
DWR_TRML	Terminal
DWR_TRNSFRMR_CORE_ADMTTNC	Transformer Core Admittance
DWR_TRNSFRMR_END	Transformer End
DWR_TRNSFRMR_END_INFO	Transformer End Info
DWR_TRNSFRMR_FEDR_ASGN	Transformer Feeder Assignment
DWR_TRNSFRMR_MESH_IMPNDNC	Transformer Mesh Impedance
DWR_TRNSFRMR_STAR_IMPNDNC	Transformer Star Impedance
DWR_TRNSFRMR_TANK	Transformer Tank
DWR_TRNSFRMR_TANK_END	Transformer Tank End
DWR_TRNSFRMR_TANK_INFO	Transformer Tank Info
DWR_TWR	Tower
DWR_UNDRGRND_STRCTR	Underground Structure
DWR_USG_PNT	Usage Point
DWR_USG_PNT_END_DVC_CTRL_ASGN	Usage Point End Device Ctrl Assignment
DWR_USG_PNT_EQPMNT_ASGN	Usage Point Equipment Assignment
DWR_USG_PNT_GRP	Usage Point Group
DWR_USG_PNT_GRP_ASGN	Usage Point Group Assignment
DWR_USG_PNT_GRP_DR_PROG_ASGN	Usage Point Group DR Program Assignment
DWR_USG_PNT_LOC	Usage Point Location
DWR_USG_PNT_TRNSFRMR_ASGN	Usage Point Transformer Assignment
DWR_USG_PT_GP_END_DVC_CTL_ASGN	Usage Point Transformer Assignment
DWR_USG_READ_CYCL	Usage Read Cycle
DWR_VAL_ALS_SET	Value Alias Set
DWR_VAL_TO_ALS	Value To Alias
DWR_VHCL	Vehicle
DWR_VLTG_CNTRL_ZN	Voltage Control Zone
DWR_VLTG_LMT	Voltage Limit
DWR_VNDR	Vendor
DWR_VNDR_ITEM	Vendor Item
DWR_VRTL_TEAM	Virtual Team
DWR_WEB_PG	Web Page
DWR_WND_GNRTNG_UNIT	Wind Generating Unit
DWR_WR_INFO	Wire Info
DWR_WR_SPCNG_INFO	Wire Spacing Info
DWR_WRK_ASST	Work Asset
DWR_WRK_BLLG_INFO	Work Billing Info
DWR_WRK_COST_DTL	Work Cost Detail
DWR_WRK_FLOW_STEP	Work Flow Step
DWR_WRK_LOC	Work Location
DWR_WRK_ORDR	Work Order
DWR_WRK_STAT_ENTRY	Work Status Entry
DWR_WRK_TASK	Work Task
DWR_WRK_TASK_AS_SET_ASGN	Work Task Asset Assignment
DWR_WRK_TIME_SCHL	Work Time Schedule
DWR_ZN	Zone

Lookup Tables

Table 4-4 briefly describes the Lookup tables in Oracle Utilities Data Model.

Table 4-4 Lookup Tables

Table Name	More Information
DWL_ACCT_ADJ_RSN	Account Adjustment Reason
DWL_ACCT_ASGN_RSN	Account Assignment Reason
DWL_ACCT_ASGN_TYP	Account Assignment Type
DWL_ACCT_BAL_ADJ_TYP	Account Balance Adjustment Type
DWL_ACCT_BAL_TYP	Account Balance Type
DWL_ACCT_EVT_TYP	Account Event Type
DWL_ACCT_ITEM_CTGRY	Accounting Item Category
DWL_ACCT_PYMT_MTHD_STAT_RSN	Account Payment Method Status Reason
DWL_ACCT_PYMT_MTHD_STAT_TYP	Account Payment Method Status Type
DWL_ACCT_RFND_RSN	Account Refund Reason
DWL_ACCT_RL_TYP	Account Role Type
DWL_ACCT_STAT_RSN	Account Status Reason
DWL_ACCT_STAT_TYP	Account Status Type
DWL_ACCT_TYP	Account Type
DWL_AGRMNT_ASGN_RSN	Agreement Assignment Reason
DWL_AGRMNT_ASGN_TYP	Agreement Assignment Type
DWL_AGRMNT_STAT_TYP	Agreement Status Type
DWL_AGRMNT_TYP	Agreement Type
DWL_AMI_BLLG_RDY_KIND_ENUM	AMI Billing Ready Kind ENUM
DWL_ANCHOR_KIND_ENUM	Anchor Kind ENUM
DWL_APNMNT_TYP	Appointment Type
DWL_ASST_MDL_USG_KIND_ENUM	Asset Model Usage Kind ENUM
DWL_ASST_TYP	Asset Type
DWL_BARNG_RSN	Baring Reason
DWL_BLLG_OCCRNCE_TYP	Billing Occurrence Type
DWL_BLLG_PRD	Billing Period
DWL_BSHNG_INSLTN_KIND_ENUM	Bushing Insulation Kind ENUM
DWL_BSNS_INTRACN_ASGN_TYP	Business Interaction Assignment Type
DWL_BSNS_INTRACN_STAT_RSN	Business Interaction Status Reason
DWL_BSNS_INTRACN_STAT_TYP	Business Interaction Status Type
DWL_BSNS_INTRACN_TYP	Business Interaction Type
DWL_BSNS_LEGAL_STAT	Business Legal Status
DWL_CALL_CNTR_CASE_SB_TYP	Call Center Case Sub Type
DWL_CALL_CNTR_CASE_TTL	Call Center Case Title
DWL_CALL_CNTR_CASE_TYP	Call Center Case Type
DWL_CHNL_TYP	Channel Type
DWL_CHRG_KIND_ENUM	Charge Kind ENUM
DWL_CLRNCE_ACTN_KIND_ENUM	Clearance Action Kind ENUM
DWL_CMPGN_CHNL_TYP	Campaign Channel Type
DWL_CMPGN_STAT	Campaign Status
DWL_CMPGN_TYP	Campaign Type
DWL_CMPST_SWTCH_KIND_ENUM	Composite Switch Kind ENUM
DWL_CNCT_LST_CHNG_RSN	Contact List Change Reason
DWL_CNCT_LST_RCRNC_TYP	Contact List Recurrence Type
DWL_CNCT_RLS	Contact Roles
DWL_CNTRL_TYP	Control Type
DWL_COLNT_TYP_ENUM	Coolant Type ENUM
DWL_COMUNICTN_DRCTN_KIND_ENUM	Com Direction Kind ENUM
DWL_COMUNICTN_TCHNLGY_KIND_ENUM	Com Technology Kind ENUM
DWL_COST_RSN	Cost Reason
DWL_COST_SB_TYP	Cost Subtype
DWL_COST_TYP	Cost Type
DWL_CRNCY	Currency
DWL_CRNCY_ENUM	Currency ENUM
DWL_CRPRT_STNDRD_KIND_ENUM	Corporate Standard Kind ENUM
DWL_CRVE_STYLE_ENUM	Curve Style ENUM
DWL_CUST_GRP	Customer Group
DWL_CUST_KIND_ENUM	Customer Kind ENUM
DWL_CUST_OCCSN_TYP	Customer Occasion Type
DWL_CUST_RVN_BND	Customer Revenue Band
DWL_CUST_TYP	Customer Type
DWL_CUT_JMPR_ACTN_KIND_ENUM	Cut Jumper Action Kind ENUM
DWL_DAY_TYP	Day Type
DWL_DEBT_AGNG_BND	Debt Aging Band
DWL_DOC_TYP	Document Type
DWL_DOC_TYP_GRP	Document Type Group
DWL_DRCT_DEBT_STAT_RSN	Direct Debit Status Reason
DWL_EDU	Education
DWL_EMP_DESIG	Employee Designation
DWL_EMP_JB_RL_TYP	Employee Job Role Type
DWL_EMP_TYP	Employee Type
DWL_END_DVC_DOMAIN	End Device Domain
DWL_END_DVC_EVT_OR_ACTN	End Device Event Or Action
DWL_END_DVC_EVT_TYP	End Device Event Type
DWL_END_DVC_FNCTN_KIND_ENUM	End Device Function Kind ENUM
DWL_END_DVC_SB_DOMAIN	End Device Sub Domain
DWL_END_DVC_TYP	End Device Type
DWL_ENRGY_FLOW_DRCTN	Energy Flow Direction
DWL_EVT_ASGN_RSN	Event Assignment Reason
DWL_EVT_ASGN_TYP	Event Assignment Type
DWL_EVT_CLASS	Event Class
DWL_EVT_CTGRY	Event Category
DWL_EVT_PRTY_RL	Event Party Role
DWL_EVT_RESPN_RSN	Event Response Reason
DWL_EVT_RSLT	Event Result
DWL_EVT_RSLTN	Event Resolution
DWL_EVT_RSN	Event Reason
DWL_EVT_RSN_CTGRY	Event Reason Category
DWL_EVT_STAT_RSN	Event Status Reason
DWL_EVT_STAT_TYP	Event Status Type
DWL_EVT_TYP	Event Type
DWL_EXTRNL_ORG_TYP	External Organization Type
DWL_FCT_DVC_KIND_ENUM	FACTS Device Kind ENUM
DWL_FLT_IND_RESET_KIND_ENUM	Fault Indicator Reset Kind ENUM
DWL_GL_ACCT_TYP	GL Account Type
DWL_GL_JE_CTGRY	GL Journal Entry Category
DWL_GL_SGMNT_TYP	GL Segment Type
DWL_GNDR	Gender
DWL_GNRTR_CNTRL_MD_ENUM	Generator Control Mode ENUM
DWL_GNRTR_CNTRL_SRC_ENUM	Generator Control Source ENUM
DWL_GNRTR_OPERTNG_MD_ENUM	Generator Operating Mode ENUM
DWL_HYDR_ENRG_CNVRSN_KIND_ENUM	Hydro Energy Conversion Kind ENUM
DWL_INTRACN_DRCTN	Interaction Direction
DWL_INTRACN_PRIORITY_TYP	Interaction Priority Type
DWL_INTRACN_RSLT_TYP	Interaction Result Type
DWL_INTRACN_RSN	Interaction Reason
DWL_INTRACN_STAT	Interaction Status
DWL_INTRACN_TRNSFR_RSN	Interaction Transfer Reason
DWL_INTRACN_TYP	Interaction Type
DWL_INTRHRMNCS	Interharmonics
DWL_INTTV_RSLT_TYP	Initiative Result Type
DWL_INTTV_TYP	Initiative Type
DWL_INVC_DISC_RSN	Invoice Discount Reason
DWL_INVC_DISC_TYP	Invoice Discount Type
DWL_INVC_DLVRY_FRMT	Invoice Delivery Format
DWL_INVC_DLVRY_TYP	Invoice Delivery Type
DWL_INVC_ITEM_DTL_TYP	Invoice Item Detail Type
DWL_INVC_ITEM_TYP	Invoice Item Type
DWL_INVC_PYMT_TERM_TYP	Invoice Payment Term Type
DWL_INVC_STAT_TYP	Invoice Status Type
DWL_INVC_TYP	Invoice Type
DWL_IVR_MENU_ITEM	IVR Menu Item
DWL_JNT_CNFGRTN_KIND_ENUM	Joint Configuration Kind ENUM
DWL_JNT_FILL_KIND_ENUM	Joint Fill Kind ENUM
DWL_LANG	Language
DWL_LTTR_TYP	Letter Type
DWL_LYLTY_PROG_EVT_TYP	Loyalty Program Event Type
DWL_MEDIA_OBJ_TYP	Media Object Type
DWL_MRTL_STAT	Marital Status
DWL_MSRMNT_KIND	Measurement Kind
DWL_MTR_STAT	Meter Status
DWL_NTNLTY	Nationality
DWL_ORG_BSNS_UNIT_TYP	Organization Business Unit Type
DWL_PBLCTN_TYP	Publication Type
DWL_PHS	Phase
DWL_PHS_CD_ENUM	Phase Code ENUM
DWL_PHS_CNCTD_FLT_KIND_ENUM	Phase Connected Fault Kind ENUM
DWL_PHS_SHNT_CNCTN_KIND_ENUM	Phase Shunt Connection Kind ENUM
DWL_PLND_OUTG_KIND_ENUM	Planned Outage Kind ENUM
DWL_POLE_BASE_KIND_ENUM	Pole Base Kind ENUM
DWL_POLE_PRSRVTV_KIND_ENUM	Pole Preservative Kind ENUM
DWL_POLE_TRTMNT_KIND_ENUM	Pole Treatment Kind ENUM
DWL_POSTL_SRVC_TYP	Postal Service Type
DWL_PRICE_TYP	Price Type
DWL_PRMTN_RSLT_TYP	Promotion Result Type
DWL_PRMTN_TERM_TYP	Promotion Term Type
DWL_PRMTN_TERM_VAL	Promotion Term Value
DWL_PRMTN_TYP	Promotion Type
DWL_PROC_KIND_ENUM	Procedure Kind ENUM
DWL_PRSPCT_PRIORITY_TYP	Prospect Priority Type
DWL_PRSPCT_QLTY_SCR_TYP	Prospect Quality Score Type
DWL_PRSPCT_REJECT_RSN	Prospect Reject Reason
DWL_PRTY_ACCT_ASGN_TYP	Party Account Assignment Type
DWL_PRTY_ASGN_RSN	Party Assignment Reason
DWL_PRTY_ASGN_TYP	Party Assignment Type
DWL_PRTY_CNCT_INFO_TYP	Party Contact Information Type
DWL_PRTY_CNCT_LST_PRTCPTN	Party Contact List Participation
DWL_PRTY_CNCT_LST_RL	Party Contact List Role
DWL_PRTY_EVT_TYP	Party Event Type
DWL_PRTY_INTRACN_THRD_TYP	Party Interaction Thread Type
DWL_PRTY_LOC_RSN	Party Location Reason
DWL_PRTY_LOC_TYP	Party Location Type
DWL_PRTY_MGMT_RL	Party Management Role
DWL_PRTY_RL	Party Role
DWL_PRTY_STAT_CHNG_RSN	Party Status Change Reason
DWL_PRTY_STAT_CTGRY	Party Status Category
DWL_PRTY_STAT_TYP	Party Status Type
DWL_PRTY_TYP	Party Type
DWL_PSR_TYP	PSR Type
DWL_PYMT_AGNG_CLASS	Payment Aging Class
DWL_PYMT_MTHD_TYP	Payment Method Type
DWL_PYMT_TRX_TYP	Payment Transaction Type
DWL_RDNG_ACMLTN_BHVR	Reading Accumulation Behavior
DWL_RDNG_DATA_QLFR	Reading Data Qualifier
DWL_RDNG_QLTY_TYP	Reading Quality Type
DWL_RDNG_QLTY_TYP_CTGRY	Reading Quality Type Category
DWL_RDNG_QLTY_TYP_ORIGIN	Reading Quality Type Origin
DWL_RDNG_QLTY_TYP_SB_CTGRY	Reading Quality Type Sub Category
DWL_RDNG_RSN_KIND_ENUM	Reading Reason Kind ENUM
DWL_RDNG_TIME_ATRIB	Reading Time Attribute
DWL_RDNG_TIME_PRD	Reading Time Period
DWL_RGLTNG_CNTRL_MD_KIND_ENUM	Regulating Control Mode Kind ENUM
DWL_RMT_UNIT_TYP_ENUM	Remote Unit Type ENUM
DWL_RVN_KIND_ENUM	Revenue Kind ENUM
DWL_SEAL_CNDTN_KIND_ENUM	Seal Condition Kind ENUM
DWL_SEAL_KIND_ENUM	Seal Kind ENUM
DWL_SEASON	Season
DWL_SGMNT_TYP	Segment Type
DWL_SHORT_CRCUT_RTR_KIND_ENUM	Short Circuit Rotor Kind ENUM
DWL_SIC_ASGN_RSN	SIC Assignment Reason
DWL_SIC_CLSFCTN	SIC Classification
DWL_SNCHRNS_MC_OPERTNG_MD_ENUM	Synchronous Machine Operating Mode ENUM
DWL_SNGL_PHS_KIND_ENUM	Single Phase Kind ENUM
DWL_SRC_ENUM	Source ENUM
DWL_SRC_SYS_TYP	Source System Type
DWL_SRVC_CTGRY	Service Category
DWL_SRVC_TYP	Service Type
DWL_STRCTR_MTRL_KIND_ENUM	Structure Material Kind ENUM
DWL_STRCTR_SPPRT_KIND_ENUM	Structure Support Kind ENUM
DWL_STREETLGHT_LAMP_KIND_ENUM	Streetlight Lamp Kind ENUM
DWL_SVC_CNTRL_MD_ENUM	SVC Control Mode ENUM
DWL_SWTCH_ACTN_KIND_ENUM	Switch Action Kind ENUM
DWL_SWTCH_STATE_ENUM	Switch State ENUM
DWL_SYNCHRNS_MC_KIND_ENUM	Synchronous Machine Kind ENUM
DWL_TAG_ACTN_KIND_ENUM	Tag Action Kind ENUM
DWL_TAX_AUTH	Tax Authority
DWL_TAX_CTGRY	Tax Category
DWL_TIME_OF_USE	Time Of Use
DWL_TRBL_RPT_KIND_ENUM	Trouble Reporting Kind ENUM
DWL_TRGT_TYP	Target Type
DWL_TRNSFRMR_CNTRL_MD_ENUM	Transformer Control Mode ENUM
DWL_TWR_CONSTRCTN_KIND_ENUM	Tower Construction Kind ENUM
DWL_UNDRGRND_STRCTR_KIND_ENUM	Underground Structure Kind ENUM
DWL_UNIT_MLTPLR	Unit Multiplier
DWL_UNIT_MLTPLR_ENUM	Unit Multiplier ENUM
DWL_UNIT_SYMBL_ENUM	Unit Symbol ENUM
DWL_UOM	Unit Of Measure
DWL_USG_PNT_CNCTD_KIND_ENUM	Usage Point Connected Kind ENUM
DWL_UTLTY_CMDTY	Utility Commodity
DWL_VAL_TYP	Value Type
DWL_VEE_EXPTN_TYP	VEE Exception Type
DWL_VEE_GRP	VEE Group
DWL_VEE_RULE	VEE Rule
DWL_VLDTY_ENUM	Validity ENUM
DWL_WEATHR_ALRT	Weather Alert
DWL_WEATHR_FRCST	Weather Forecast
DWL_WEATHR_INFO	Weather Information
DWL_WEATHR_LOC	Weather Location
DWL_WND_GEN_UNIT_KIND_ENUM	Wind Gen Unit Kind ENUM
DWL_WNDNG_CNCTN_ENUM	Winding Connection ENUM
DWL_WR_INSLTN_KIND_ENUM	Wire Insulation Kind ENUM
DWL_WR_MTRL_KIND_ENUM	Wire Material Kind ENUM
DWL_WR_USG_KIND_ENUM	Wire Usage Kind ENUM
DWL_WRK_KIND_ENUM	Work Kind ENUM
DWL_WRK_STAT_KIND_ENUM	Work Status Kind ENUM
DWL_WRK_TASK_KIND_ENUM	Work Task Kind ENUM
DWL_WRK_TIME_SCHL_KIND_ENUM	Work Time Schedule Kind ENUM
DWL_ZN_KIND_ENUM	Zone Kind ENUM

Base Tables

Table 4-5 briefly describes the Base tables in Oracle Utilities Data Model.

Table 4-5 Base Tables

Table Name	More Information
DWB_ACCMLTR	Accumulator
DWB_ACCMLTR_VAL	Accumulator Value
DWB_ACCT_ACCT_CYCL_HIST	Account Accounting Cycle History
DWB_ACCT_BAL_ADJ	Account Balance Adjustment
DWB_ACCT_BAL_BKT	Account Balance Bucket
DWB_ACCT_BAL_HIST	Account Balance History
DWB_ACCT_BAL_IMPT	Account Balance Impact
DWB_ACCT_BLLG_OCCRNCE	Account Billing Occurrence
DWB_ACCT_CRDT_LMT	Account Credit Limit
DWB_ACCT_DEBT	Account Debt
DWB_ACCT_MGMT_HIST	Account Management History
DWB_ACCT_PYMT	Account Payment
DWB_ACCT_PYMT_BAL_IMPT	Account Payment Balance Impact
DWB_ACCT_PYMT_MTHD_STAT	Account Payment Method Status
DWB_ACCT_RCHRG	Account Recharge
DWB_ACCT_RFND	Account Refund
DWB_ACCT_STAT_HIST	Account Status History
DWB_ACTVTY_REC	Activity Record
DWB_AGRMNT_APRVL	Agreement Approval
DWB_AGRMNT_ASGN	Agreement Assignment
DWB_AGRMNT_STAT	Agreement Status
DWB_ANLG	Analog
DWB_ANLG_VAL	Analog Value
DWB_APNMNT	Appointment
DWB_ASST_APPRSL_HIST	Asset Appraisal History
DWB_ASST_CNDTN_HIST	Asset Condition History
DWB_ATMSPHRC_PRSSR	Atmospheric Pressure
DWB_BLK_LST_HIST	Black List History
DWB_BSNS_INTRACN	Business Interaction
DWB_BSNS_INTRACN_ITEM	Business Interaction Item
DWB_BSNS_INTRACN_ITEM_PRICE	Business Interaction Item Price
DWB_BSNS_INTRACN_RL	Business Interaction Role
DWB_BSNS_INTRACN_STAT_HIST	Business Interaction Status History
DWB_CLOUD_INFO	Cloud Information
DWB_CMND	Command
DWB_CMPGN_MSG_CRTVE	Campaign Message Creative
DWB_CNFGRTN_EVT	Configuration Event
DWB_CNTRL	Control
DWB_COST	Cost
DWB_CRNCY_EXCHNG_RATE	Currency Exchange Rate
DWB_CRVE_DATA	Curve Data
DWB_CUST_ORDR	Customer Order
DWB_CUST_ORDR_LI	Customer Order Line Item
DWB_DEBT_COLLCTN	Debt Collection
DWB_DEBT_COLLCTN_ASGN	Debt Collection Assignment
DWB_DEBT_COLLCTN_ASGN_BTCH	Debt Collection Assignment Batch
DWB_DOC_STAT	Document Status
DWB_DSCRT	Discrete
DWB_DSCRT_VAL	Discrete Value
DWB_EMP_ACT_LBR_HRLY	Employee Actual Labor Hourly
DWB_EMP_COST	Employee Cost
DWB_EMP_TRNG_REC	Employee Training Record
DWB_END_DVC_CNTRL	End Device Control
DWB_END_DVC_CNTRL_PRMRY_DVC_TMNG	End Device Ctrl Primary Device Timing
DWB_END_DVC_CNTRL_SCNDRY_DVC_TMNG	End Device Ctrl Secondary Device Timing
DWB_END_DVC_EVT	End Device Event
DWB_EVT	Event
DWB_EVT_ACCT	Event Account
DWB_EVT_ASGN	Event Assignment
DWB_EVT_CHAT	Event Chat
DWB_EVT_CHAT_DTL	Event Chat Detail
DWB_EVT_EMP_PYRL	Event Employee Payroll
DWB_EVT_EQPMNT_INSTNC	Event Equipment Instance
DWB_EVT_GEO	Event Geography
DWB_EVT_INVC_DLVRY	Event Invoice Delivery
DWB_EVT_LYLTY_PROG	Event Loyalty Program
DWB_EVT_PRTY_ASGN	Event Party Assignment
DWB_EVT_PRTY_INTRACN	Event Party Interaction
DWB_EVT_PRTY_INTRACN_CALL	Event Party Interaction Call
DWB_EVT_PRTY_INTRACN_EML	Event Party Interaction Email
DWB_EVT_PRTY_INTRACN_ITEM	Event Party Interaction Item
DWB_EVT_PRTY_INTRACN_LTTR	Event Party Interaction Letter
DWB_EVT_PRTY_INTRACN_PRTCPTN	Event Party Interaction Participation
DWB_EVT_PRTY_INTRACN_VST	Event Party Interaction Visit
DWB_EVT_PRTY_PRFL	Event Party Profile
DWB_EVT_STAT	Event Status
DWB_EVT_WEB_RGSTRTN	Event Web Registration
DWB_EVT_WEB_VST	Event Web Visit
DWB_FLOD_INFO	Flood Information
DWB_FNL_RDNG	Final Reading
DWB_GL_BAL	GL Balance
DWB_GL_JE	GL Journal Entry
DWB_GL_JE_BTCH	GL Journal Entry Batch
DWB_GL_JE_LN	GL Journal Entry Line
DWB_GL_JE_LN_SBLDGR_ASGN	GL JE Line Subledger Assignment
DWB_GL_SBLDGR_JE	GL Subledger Journal Entry
DWB_GL_SBLDGR_JE_LN	GL Subledger Journal Entry Line
DWB_INCDNT	Incident
DWB_INITIAL_RDNG	Initial Reading
DWB_INTRACN_ANSWR_CHOICE	Interaction Answer Choice
DWB_INTRACN_NAVGTN_HIST	Interaction Navigation History
DWB_INTRACN_QUES_RESPN	Interaction Question Response
DWB_INTRACN_TRNSFR_HIST	Interaction Transfer History
DWB_INVC	Invoice
DWB_INVC_ADJ	Invoice Adjustment
DWB_INVC_DISC	Invoice Discount
DWB_INVC_ITEM	Invoice Item
DWB_INVC_ITEM_DTL	Invoice Item Detail
DWB_INVC_ITEM_RLTN	Invoice Item Relationship
DWB_INVC_PYMT_ASGN	Invoice Payment Assignment
DWB_INVC_PYMT_TERM	Invoice Payment Term
DWB_INVC_STAT_HIST	Invoice Status History
DWB_INVC_TAX_ITEM	Invoice Tax Item
DWB_JE_LN_INVC_ITEM_ASGN	Journal Entry Line Invoice Item Assignment
DWB_MSRMNT	Measurement
DWB_MSRMNT_VAL	Measurement Value
DWB_MTR_RDNG	Meter Reading
DWB_OUTG	Outage
DWB_OUTG_REC	Outage Record
DWB_PCHSE_ORDR	Purchase Order
DWB_PCHSE_ORDR_LI	Purchase Order Line Item
DWB_PPTN	Precipitation
DWB_PRICE_EVT	Price Event
DWB_PRMTN_CLSTR_USG	Promotion Cluster Usage
DWB_PRMTN_CNCT_LST_UTLZTN	Promotion Contact List Utilization
DWB_PRMTN_MGMT_HIST	Promotion Management History
DWB_PRTY_COST_ASGN	Party Cost Assignment
DWB_PRTY_INTRACN_THRD	Party Interaction Thread
DWB_PRTY_INTRCN_THRD_SBRP_ASGN	Party Interaction Thread Subscription Assignment
DWB_PRTY_PRMTN_RESPN	Party Promotion Response
DWB_PRTY_STAT_HIST	Party Status History
DWB_RDNG_QLTY	Reading Quality
DWB_RESRE_ORDR	Resource Order
DWB_RESRE_ORDR_ITEM	Resource Order Item
DWB_SCHL_EVT	Scheduled Event
DWB_SEA_CNDTN	Sea Condition
DWB_SET_PNT	Set Point
DWB_SPOT_TEMP	Spot Temperature
DWB_SRVC_ORDR	Service Order
DWB_SRVC_ORDR_LI	Service Order Line Item
DWB_STRNG_MSRMNT	String Measurement
DWB_STRNG_MSRMNT_VAL	String Measurement Value
DWB_VEE_EXPTN	VEE Exception
DWB_WND_INFO	Wind Information
DWB_WRK_COST_SUMM	Work Cost Summary
Not physicalized	Base Reading

Derived Tables

Table 4-6 Oracle Utilities Data Model Derived Tables

Table Name	More Information
DWD_ACCT_ARRER_MO	Account Arrears Month Drvd
DWD_ACCT_BAL_MO	Account Balance Month Drvd
DWD_ACCT_DEBT_DAY	Account Debt Day Drvd
DWD_ACCT_PYMT_DAY	Account Payment Day Drvd
DWD_ACCT_PYMT_MTHD_STAT_HIST	Account Payment Method Status Hist Drvd
DWD_ACCT_STAT_MO	Account Status Month Drvd
DWD_CUST_MNNG	Customer Mining
DWD_DR_PROG_LD_RDCTN_RGN_DAY	DR Program Load Reduction By Region Day Drvd
DWD_END_DVC_EVT_CUST_DAY	End Device Event By Customer Day Drvd
DWD_END_DVC_EVT_DVC_DAY	End Device Event By Device Day Drvd
DWD_MTR_RDNG_DAY	Meter Reading Day Drvd
DWD_MTR_RDNG_HR	Meter Reading Hour Drvd
DWD_OUTG_DAY	Outage By Day Drvd
DWD_OUTG_USG_PNT	Outage By Usage Point Drvd
DWD_RLBLTY_IND_CITY_MO	Reliability Indices By City Month Drvd
DWD_RLBLTY_IND_FEDR_MO	Reliability Indices By Feeder Month Drvd

Aggregate Tables

Table 4-7 briefly describes the Aggregate tables in Oracle Utilities Data Model.

Table 4-7 Aggregate Tables

Table Name	More Information
DWA_END_DVC_EVT_CUST_MO	End Device Event by Customer Month Aggr
DWA_END_DVC_EVT_DVC_MO	End Device Event By Device Month Aggr
DWA_MTR_RDNG_MO	Meter Reading Month Aggr
DWA_MTR_RDNG_TOU_MO	Meter Reading TOU Month Aggr
DWA_OUTG_MO	Outage By Month Aggr

Temporary and Other Tables

Briefly describes the temporary and control tables in Oracle Utilities Data Model.

Table 4-8 and Table 4-9 briefly describes the temporary and control tables in Oracle Utilities Data Model.

Table 4-8 Temporary Oracle Utilities Data Model Tables

Table Name	Description
DWA_CUST_GROSS_ORDRS_QTR	This entity gives order measures, number of orders and total order amount, in same quarters of consecutive years.
DWA_CUST_NET_ORDRS_QTR	This entity gives order measures, number of orders and total order amount, in consecutive quarters.
DWA_CUST_ORDR_MO	This entity summarizes orders placed by customers at month level aggregation. Using this entity, order measures, number of orders and total order amount, across order status, order type, product, product type dimensions can be computed.
TMP_DWD_CUST_RFMP_SCR_1	No value
TMP_DWD_CUST_RFMP_SCR_2	No value

Table 4-9 Control Tables

Table Name	Description
DWC_ETL_PARAMETER	Store ETL parameters such as etl start date and etl end date. For more information, see "Intra-ETL Load Parameters Control Table".
DWC_INTRA_ETL_ACTIVITY	Reports errors at the individual program level. For more information, see "Intra-ETL Monitoring Process Control Tables".
DWC_INTRA_ETL_PROCESS	Reports errors at the whole batch load level. For more information, see "Intra-ETL Monitoring Process Control Tables".
DWC_MESSAGE	"Intra-ETL Monitoring Process Control Tables"
DWC_OLAP_ETL_PARAMETER	Reports OLAP ETL parameter. For more information, see "Intra-ETL OLAP Mapping Control Table".

Sequences in Oracle Utilities Data Model

Table 4-10 lists the sequence names in Oracle Utilities Data Model.

Table 4-10 Sequence Name for Oracle Utilities Data Model

Table Name	Sequence Name
DWC_INTRA_ETL_ACTIVITY	INTRA_ETL_ACTIVITY_SEQ
DWC_INTRA_ETL_PROCESS	INTRA_ETL_PROCESS_SEQ
DWR_CUST_SGMNT	CUST_SGMNT_SEQ

Compressed Tables

This section lists the Compressed Tables in Oracle Utilities Data Model. Oracle Utilities Data Model uses Database Compression on these tables to save space and load times.

DWA_END_DVC_EVT_CUST_MO
DWA_END_DVC_EVT_DVC_MO
DWA_MTR_RDNG_MO
DWA_MTR_RDNG_MO_ACCT
DWA_MTR_RDNG_MO_CUST
DWA_MTR_RDNG_MO_UP
DWA_MTR_RDNG_TOU_MO
DWA_OUTG_MO
DWB_ACCT_BAL_ADJ
DWB_ACCT_BAL_HIST
DWB_ACCT_BLLG_OCCRNCE
DWB_ACCT_CRDT_LMT
DWB_ACCT_PYMT
DWB_ACCT_PYMT_BAL_IMPT
DWB_ACCT_PYMT_MTHD_STAT
DWB_ACCT_RFND
DWB_ACCT_STAT_HIST
DWB_AGRMNT_APRVL
DWB_AGRMNT_STAT
DWB_BLK_LST_HIST
DWB_BSNS_INTRACN
DWB_CMPGN_MSG_CRTVE
DWB_COST
DWB_CRNCY_EXCHNG_RATE
DWB_CUST_ORDR
DWB_CUST_ORDR_LI
DWB_DEBT_COLLCTN
DWB_DEBT_COLLCTN_ASGN
DWB_DEBT_COLLCTN_ASGN_BTCH
DWB_EMP_ACT_LBR_HRLY
DWB_EMP_COST
DWB_EMP_TRNG_REC
DWB_END_DVC_EVT
DWB_EVT
DWB_EVT_ACCT
DWB_EVT_ASGN
DWB_EVT_EMP_PYRL
DWB_EVT_EQPMNT_INSTNC
DWB_EVT_GEO
DWB_EVT_INVC_DLVRY
DWB_EVT_LYLTY_PROG
DWB_EVT_PRTY_ASGN
DWB_EVT_PRTY_INTRACN
DWB_EVT_PRTY_INTRACN_CALL
DWB_EVT_PRTY_INTRACN_EML
DWB_EVT_PRTY_INTRACN_LTTR
DWB_EVT_PRTY_INTRACN_VST
DWB_EVT_PRTY_PRFL
DWB_EVT_STAT
DWB_EVT_WEB_RGSTRTN
DWB_EVT_WEB_VST
DWB_FNL_RDNG
DWB_INCDNT
DWB_INITIAL_RDNG
DWB_INTRACN_QUES_RESPN
DWB_INVC
DWB_INVC_ADJ
DWB_INVC_DISC
DWB_INVC_ITEM
DWB_INVC_ITEM_DTL
DWB_INVC_PYMT_ASGN
DWB_INVC_STAT_HIST
DWB_MTR_RDNG
DWB_OUTG
DWB_OUTG_REC
DWB_PRICE_EVT
DWB_PRMTN_CLSTR_USG
DWB_PRMTN_CNCT_LST_UTLZTN
DWB_PRMTN_MGMT_HIST
DWB_PRTY_COST_ASGN
DWB_PRTY_INTRACN_THRD
DWB_PRTY_PRMTN_RESPN
DWB_PRTY_STAT_HIST
DWB_RESRE_ORDR
DWB_SRVC_ORDR
DWD_ACCT_ARRER_MO
DWD_ACCT_BAL_MO
DWD_ACCT_DEBT_DAY
DWD_ACCT_PYMT_DAY
DWD_ACCT_PYMT_MTHD_STAT_HIST
DWD_ACCT_STAT_MO
DWD_CUST_DR_PROG_PROFILE
DWD_DR_PROG_LD_RDCTN_RGN_DAY
DWD_END_DVC_EVT_CUST_DAY
DWD_END_DVC_EVT_DVC_DAY
DWD_MTR_RDNG_DAY
DWD_MTR_RDNG_HR
DWD_OUTG_DAY
DWD_OUTG_USG_PNT
DWD_RLBLTY_IND_CITY_MO
DWD_RLBLTY_IND_FEDR_MO
DWR_SRVC_QTY

Oracle Utilities Data Model OLAP Cube MV, Cube View

This section includes information on the following:

• Oracle OLAP Cube Views: Oracle OLAP cube views provide organizations with the ability to both improve the performance and analytic content of SQL-based business intelligence applications. OLAP cube views are relational views of OLAP cubes, dimensions, and hierarchies that reveal the full content of cubes and dimensions.

• Cube MV (Materialized Cube Views): Cube-organized materialized views, introduced, in Oracle Database 11g, play the same role as table-based materialized views. That is, a summary management solution that is transparent to the querying application. Like table-based materialized views, the application queries the detail tables and the database automatically rewrites the query to access summary data in the materialized view. In the case of cube-organized materialized views, the data is managed in the cube rather than a table.

Table 4-11 shows the cube materialized views in oudm_sys schema.

Table 4-11 OLAP Cube Materialized Views in oudm_sys Schema

Cube Materialized View Name	OLAP Object Name	OLAP Object Type
CB$ACM	ACM	Cube

Table 4-12 shows the OLAP cube views in oudm_sys schema.

Table 4-12 OLAP Cube Views in oudm_sys schema

Cube View Name	OLAP Object Name	OLAP Object Type
ORG_VIEW	ORG	Dimension
PMTYP_HPMTYP_VIEW	PMTYP_HPMTYP	Hierarchy