5 Oracle Utilities Data Model Logical to Physical Mapping

This chapter provides a table listing the Oracle Utilities Data Model entities in the logical data model, and the physical database tables or views to which the logical entities have been implemented or "physicalized".

This chapter includes the following section:

• Overview of Mapping and Inheritance in Oracle Utilities Data Model
  
• Logical to Physical Mappings for Oracle Utilities Data Model
  

Overview of Mapping and Inheritance in Oracle Utilities Data Model

The physical manifestation of the logical data model into database tables and relationships is not necessarily a pure 1:1 mapping from logical entities to physical tables. Physically, Oracle Utilities Data Model is setup for best performance, and minimal data disk storage, leveraging the database options and consulting best practices wherever possible. The foundation layer follows the Third normal Form rule ("the key, only the key and nothing but the key") while the analytics layer is setup for optimal reporting performance. Partitions, Indexes, primary and foreign keys, constraints, and Materialized Views are used to map the logical model in the best possible way by default.

The complete Oracle Utilities Data Model model is installed into the database schema:

• OUDM_SYS: Schema includes the Oracle Utilities Data Model tables from the foundation and analytics layers, including the OLAP cubes. This also includes the mining model and related objects like source tables, model building database packages, target tables and the specific views.

Inheritance with Subtypes and SuperEntities

Some logical entities are sub-types of super-entities. Physically, there are different ways to realize this. The decision on how to materialize the logical entity is based on consulting experience.

Logical to Physical Mappings for Oracle Utilities Data Model

Table 5-1 and Table 5-2 list the Oracle Utilities Data Model entities in the logical data model, and the physical database tables or views to which the logical entities have been implemented or "physicalized".

Table 5-1 Entity Mapping Table: Logical to Physical Mapping A to M

Entity	Table or View
AC Line Segment	DWR_AC_LN_SGMNT
AC Line Segment Phase	DWR_AC_LN_SGMNT_PHS
Acceptance Test	DWR_ACPT_TEST
Account	DWR_ACCT
Account Accounting Cycle History	DWB_ACCT_ACCT_CYCL_HIST
Account Adjustment Reason	DWL_ACCT_ADJ_RSN
Account Agreement Relationship	DWR_ACCT_AGRMNT_RLTN
Account Arrears Month Drvd	DWD_ACCT_ARRER_MO
Account Assignment	DWR_ACCT_ASGN
Account Assignment Reason	DWL_ACCT_ASGN_RSN
Account Assignment Type	DWL_ACCT_ASGN_TYP
Account Balance Adjustment	DWB_ACCT_BAL_ADJ
Account Balance Adjustment Type	DWL_ACCT_BAL_ADJ_TYP
Account Balance Bucket	DWB_ACCT_BAL_BKT
Account Balance Group	DWR_ACCT_BAL_GRP
Account Balance History	DWB_ACCT_BAL_HIST
Account Balance Impact	DWB_ACCT_BAL_IMPT
Account Balance Month Drvd	DWD_ACCT_BAL_MO
Account Balance Type	DWL_ACCT_BAL_TYP
Account Billing Cycle History	DWR_ACCT_BLLG_CYCL_HIST
Account Billing Frequency History	DWR_ACCT_BLLG_FREQNCY_HIST
Account Billing Occurrence	DWB_ACCT_BLLG_OCCRNCE
Account Billing Period History	DWR_ACCT_BLLG_PRD_HIST
Account Business Interaction Role	DWR_ACCT_BSNS_INTRACN_RL
Account Credit Limit	DWB_ACCT_CRDT_LMT
Account Debt	DWB_ACCT_DEBT
Account Debt Day Drvd	DWD_ACCT_DEBT_DAY
Account Event Type	DWL_ACCT_EVT_TYP
Account Management History	DWB_ACCT_MGMT_HIST
Account Payment	DWB_ACCT_PYMT
Account Payment Balance Impact	DWB_ACCT_PYMT_BAL_IMPT
Account Payment Day Drvd	DWD_ACCT_PYMT_DAY
Account Payment Method Status	DWB_ACCT_PYMT_MTHD_STAT
Account Payment Method Status Hist Drvd	DWD_ACCT_PYMT_MTHD_STAT_HIST
Account Payment Method Status Reason	DWL_ACCT_PYMT_MTHD_STAT_RSN
Account Payment Method Status Type	DWL_ACCT_PYMT_MTHD_STAT_TYP
Account Preferred Invoice Delivery	DWR_ACCT_PREF_INVC_DLVRY
Account Preferred Payment Method	DWR_ACCT_PREF_PYMT_MTHD
Account Profile	DWR_ACCT_PRFL
Account Recharge	DWB_ACCT_RCHRG
Account Refund	DWB_ACCT_RFND
Account Refund Reason	DWL_ACCT_RFND_RSN
Account Role Type	DWL_ACCT_RL_TYP
Account Segment	DWR_ACCT_SGMNT
Account Segment Assignment History	DWR_ACCT_SGMNT_ASGN_HIST
Account Segmentation Model	DWR_ACCT_SGMNT_MDL
Account Status History	DWB_ACCT_STAT_HIST
Account Status Month Drvd	DWD_ACCT_STAT_MO
Account Status Reason	DWL_ACCT_STAT_RSN
Account Status Type	DWL_ACCT_STAT_TYP
Account Type	DWL_ACCT_TYP
Accounting Cycle	DWR_ACCT_CYCL
Accounting Item Category	DWL_ACCT_ITEM_CTGRY
Accumulator	DWB_ACCMLTR
Accumulator Limit	DWR_ACCMLTR_LMT
Accumulator Limit Set	DWR_ACCMLTR_LMT_SET
Accumulator Limit Set Assignment	DWR_ACCMLTR_LMT_SET_ASGN
Accumulator Value	DWB_ACCMLTR_VAL
ACDC Terminal	Not physicalized
Active Power Limit	DWR_ACTV_POWR_LMT
Activity Record	DWB_ACTVTY_REC
Address Location	DWR_ADDR_LOC
Agree Item Pricing Struct Assignment	DWR_AGRMNT_ITEM_PRCNG_STRUCT_ASGN
Agreement	DWR_AGRMNT
Agreement Approval	DWB_AGRMNT_APRVL
Agreement Assignment	DWB_AGRMNT_ASGN
Agreement Assignment Reason	DWL_AGRMNT_ASGN_RSN
Agreement Assignment Type	DWL_AGRMNT_ASGN_TYP
Agreement Document	DWR_AGRMNT_DOC
Agreement Item	DWR_AGRMNT_ITEM
Agreement Status	DWB_AGRMNT_STAT
Agreement Status Type	DWL_AGRMNT_STAT_TYP
Agreement Type	DWL_AGRMNT_TYP
Agreement Usage Point Assignment	DWR_AGRMNT_USG_PNT_ASGN
Air Compressor	DWR_AIR_CMPRSR
AMI Billing Ready Kind ENUM	DWL_AMI_BLLG_RDY_KIND_ENUM
Analog	DWB_ANLG
Analog Limit	DWR_ANLG_LMT
Analog Limit Set	DWR_ANLG_LMT_SET
Analog Limit Set Assignment	DWR_ANLG_LMT_SET_ASGN
Analog Value	DWB_ANLG_VAL
Anchor Kind ENUM	DWL_ANCHOR_KIND_ENUM
ANZSIC Classification	DWR_ANZSC_CLSFCTN
Apparent Power Limit	DWR_APRNT_POWR_LMT
Appointment	DWB_APNMNT
Appointment Type	DWL_APNMNT_TYP
Asset	DWR_ASST
Asset Activity Record Assignment	DWR_ASST_ACTVTY_REC_ASGN
Asset Appraisal History	DWB_ASST_APPRSL_HIST
Asset Condition History	DWB_ASST_CNDTN_HIST
Asset Container	Not physicalized
Asset Function	DWR_ASST_FNCTN
Asset Info	DWR_ASST_INFO
Asset Location	DWR_ASST_LOC
Asset Model	DWR_ASST_MDL
Asset Model Catalog	DWR_ASST_MDL_CTLG
Asset Model Catalog Item	DWR_ASST_MDL_CTLG_ITEM
Asset Model Usage Kind ENUM	DWL_ASST_MDL_USG_KIND_ENUM
Asset Organization Role	DWR_ASST_ORG_RL
Asset Organization Role Assignment	DWR_ASST_ORG_RL_ASGN
Asset Owner	DWR_ASST_OWNR
Asset PSR Assignment	DWR_ASST_PSR_ASGN
Asset Status	DWR_ASST_STAT
Asset Type	DWL_ASST_TYP
Asset User	DWR_ASST_USER
Assignment	Not physicalized
Atmospheric Pressure	DWB_ATMSPHRC_PRSSR
Bank	DWR_BNK
Bank Direct Debit Channel	DWR_BNK_DRCT_DEBT_CHNL
Baring Reason	DWL_BARNG_RSN
Base Reading	Not physicalized
Base Voltage	DWR_BASE_VLTG
Base Work	Not physicalized
Basic Interval Schedule	Not physicalized
Billing Cycle	DWR_BLLG_CYCL
Billing Frequency	DWR_BLLG_FREQNCY
Billing Occurrence Type	DWL_BLLG_OCCRNCE_TYP
Billing Period	DWL_BLLG_PRD
Black List History	DWB_BLK_LST_HIST
Breaker	DWR_BRKR
Busbar Section	DWR_BSBR_SECTN
Busbar Section	DWR_BSBR_SECTN_INFO
Bushing	DWR_BSHNG
Bushing Insulation Kind ENUM	DWL_BSHNG_INSLTN_KIND_ENUM
Business Case	DWR_BSNS_CASE
Business Half Month	DWR_BSNS_HLF_MO
Business Half Year	DWR_BSNS_HLF_YR
Business Interaction	DWB_BSNS_INTRACN
Business Interaction Assignment	DWR_BSNS_INTRACN_ASGN
Business Interaction Assignment Type	DWL_BSNS_INTRACN_ASGN_TYP
Business Interaction Item	DWB_BSNS_INTRACN_ITEM
Business Interaction Item Price	DWB_BSNS_INTRACN_ITEM_PRICE
Business Interaction Location Assignment	DWR_BSNS_INTRACN_LOC_ASGN
Business Interaction Role	DWB_BSNS_INTRACN_RL
Business Interaction Status History	DWB_BSNS_INTRACN_STAT_HIST
Business Interaction Status Reason	DWL_BSNS_INTRACN_STAT_RSN
Business Interaction Status Type	DWL_BSNS_INTRACN_STAT_TYP
Business Interaction Type	DWL_BSNS_INTRACN_TYP
Business Interaction Version	DWR_BSNS_INTRACN_VRSN
Business Legal Status	DWL_BSNS_LEGAL_STAT
Business Month	DWR_BSNS_MO
Business Quarter	DWR_BSNS_QTR
Business Unit Job Role	DWR_BSNS_UNIT_JB_RL
Business Week	DWR_BSNS_WK
Business Year	DWR_BSNS_YR
CAES Plant	DWR_CAES_PLNT
Calendar Half Month	DWR_CLNDR_HLF_MO
Calendar Half Year	DWR_CLNDR_HLF_YR
Calendar Month	DWR_CLNDR_MO
Calendar Quarter	DWR_CLNDR_QTR
Calendar Week	DWR_CLNDR_WK
Calendar Year	DWR_CLNDR_YR
Call Center	DWR_CALL_CNTR
Call Center Agent	DWR_CALL_CNTR_AGNT
Call Center Case Sub Type	DWL_CALL_CNTR_CASE_SB_TYP
Call Center Case Title	DWL_CALL_CNTR_CASE_TTL
Call Center Service Capability	DWR_CALL_CNTR_SRVC_CAPBLTY
Campaign	DWR_CMPGN
Campaign Channel	DWR_CMPGN_CHNL
Campaign Channel Assignment	DWR_CMPGN_CHNL_ASGN
Campaign Channel Type	DWL_CMPGN_CHNL_TYP
Campaign Characteristic	DWR_CMPGN_CHTRSTC
Campaign Characteristic Value	DWR_CMPGN_CHTRSTC_VAL
Campaign Document	DWR_CMPGN_DOC
Campaign Management History	DWR_CMPGN_MGMT_HIST
Campaign Message	DWR_CMPGN_MSG
Campaign Message Creative	DWB_CMPGN_MSG_CRTVE
Campaign Message Depiction	DWR_CMPGN_MSG_DPCT
Campaign Relationship	DWR_CMPGN_RLTN
Campaign Status	DWL_CMPGN_STAT
Campaign Term Value	DWR_CMPGN_TERM_VAL
Campaign Type	DWL_CMPGN_TYP
Channel	DWR_CHNL
Channel Type	DWL_CHNL_TYP
Charge Kind ENUM	DWL_CHRG_KIND_ENUM
Clamp	DWR_CLMP
Clearance Action	DWR_CLRNCE_ACTN
Clearance Action Kind ENUM	DWL_CLRNCE_ACTN_KIND_ENUM
Clearance Document	DWR_CLRNCE_DOC
Cloud Information	DWB_CLOUD_INFO
Cogeneration Plant	DWR_CGNRTN_PLNT
Collection Agency	DWR_COLLCTN_AGNCY
Com Direction Kind ENUM	DWL_COMUNICTN_DRCTN_KIND_ENUM
Com Function	DWR_COMUNICTN_FNCTN
Com Media	DWR_COMUNICTN_MEDIA
Com Module	DWR_COMUNICTN_MODULE
Com Technology Kind ENUM	DWL_COMUNICTN_TCHNLGY_KIND_ENUM
Combined Cycle Plant	DWR_CMBND_CYCL_PLNT
Command	DWB_CMND
Communication Link	DWR_COMUNICTN_LNK
Compatible Unit	DWR_CMPTBL_UNIT
Compatible Unit Procedure Assignment	DWR_CMPTBL_UNIT_PROC_ASGN
Composite Switch Info	DWR_CMPST_SWTCH_INFO
Composite Switch Kind ENUM	DWL_CMPST_SWTCH_KIND_ENUM
Conducting Eqp Protection Eqp Assignment	DWR_CNDTNG_EQP_PRTCTN_EQP_ASGN
Conducting Equipment	Not physicalized
Conductor	DWR_CNDCTR
Configuration Event	DWB_CNFGRTN_EVT
Conform Load	DWR_CNFRM_LD
Conform Load Group	DWR_CNFRM_LD_GRP
Conform Load Schedule	DWR_CNFRM_LD_SCHL
Connect Disconnect Function	DWR_CONCT_DSCNCT_FNCTN
Connectivity Node	DWR_CONCTVT_ND
Connectivity Node Container	DWR_CONCTVT_ND_CONTNR
Connector	DWR_CNCTR
Consumption Tariff Interval	DWR_CNSMPTN_TRF_INTRVL
Consumption Tier	DWR_CNSMPTN_TIER
Contact List	DWR_CNCT_LST
Contact List Change Reason	DWL_CNCT_LST_CHNG_RSN
Contact List Recurrence Type	DWL_CNCT_LST_RCRNC_TYP
Contact Roles	DWL_CNCT_RLS
Control	DWB_CNTRL
Control Type	DWL_CNTRL_TYP
Coolant Type ENUM	DWL_COLNT_TYP_ENUM
Corporate Standard Kind ENUM	DWL_CRPRT_STNDRD_KIND_ENUM
Cost	DWB_COST
Cost Center	DWR_COST_CNTR
Cost Reason	DWL_COST_RSN
Cost Subtype	DWL_COST_SB_TYP
Cost Type	DWL_COST_TYP
Credit Category	DWR_CRDT_CTGRY
Credit Score Provider	DWR_CRDT_SCR_PRVDR
Crew	DWR_CREW
Crew Member	DWR_CREW_MBR
Crew Type	DWR_CREW_TYP
Crew Work Task Assignment	DWR_CREW_WRK_TASK_ASGN
Critical Peak Period	DWR_CRTCL_PK_PRD
Currency	DWL_CRNCY
Currency ENUM	DWL_CRNCY_ENUM
Currency Exchange Rate	DWB_CRNCY_EXCHNG_RATE
Currency Geography Entity Assignment	DWR_CRNCY_GEO_ENT_ASGN
Current Limit	DWR_CURR_LMT
Current Relay	DWR_CURR_RLY
Current Transformer Info	DWR_CURR_TRNSFRMR_INFO
Curve	DWR_CRVE
Curve Data	DWB_CRVE_DATA
Curve Style ENUM	DWL_CRVE_STYLE_ENUM
Customer	DWR_CUST
Customer Account Assignment	DWR_CUST_ACCT_ASGN
Customer Document	DWR_CUST_DOC
Customer Facing Service	DWR_CUST_FCNG_SRVC
Customer Group	DWL_CUST_GRP
Customer Group Assignment	DWR_CUST_GRP_ASGN
Customer Individual	DWR_CUST_INDVL
Customer Kind ENUM	DWL_CUST_KIND_ENUM
Customer Mining	DWD_CUST_MNNG
Customer Occasion	DWR_CUST_OCCSN
Customer Occasion Type	DWL_CUST_OCCSN_TYP
Customer Order	DWB_CUST_ORDR
Customer Order Document	DWR_CUST_ORDR_DOC
Customer Order Line Item	DWB_CUST_ORDR_LI
Customer Organization	DWR_CUST_ORG
Customer Outage Notification Assignment	DWR_CUST_OUTG_NOTFCTN_ASGN
Customer Restricted Info	DWR_CUST_RSTRCT_INFO
Customer Revenue Band	DWL_CUST_RVN_BND
Customer Revenue Band Assignment	DWR_CUST_RVN_BND_ASGN
Customer Score	DWR_CUST_SCR
Customer Segment	DWR_CUST_SGMNT
Customer Segmentation Model	DWR_CUST_SGMNT_MDL
Customer SIC Assignment	DWR_CUST_SIC_ASGN
Customer Source	DWR_CUST_SRC
Customer Type	DWL_CUST_TYP
Customer Work Assignment	DWR_CUST_WRK_ASGN
Cut	DWR_CUT
Cut Action	DWR_CUT_ACTN
Cut Jumper Action Kind ENUM	DWL_CUT_JMPR_ACTN_KIND_ENUM
Day	DWR_DAY
Day Type	DWL_DAY_TYP
DC Conducting Equipment	DWR_DC_CNDCTNG_EQPMNT
DC Line Segment	DWR_DC_LN_SGMNT
Debt Aging Band	DWL_DEBT_AGNG_BND
Debt Collection	DWB_DEBT_COLLCTN
Debt Collection Assignment	DWB_DEBT_COLLCTN_ASGN
Debt Collection Assignment Batch	DWB_DEBT_COLLCTN_ASGN_BTCH
Demand Response Program	DWR_DEMAND_RESPN_PROG
Demand Tariff Interval	DWR_DEMAND_TRF_INTRVL
Demographic Characteristic	DWR_DEMOG_CHTRSTC
Demography Attribute	DWR_DEMOG_ATRIB
Demography Group	DWR_DEMOG_GRP
Derived Value	DWR_DRVD_VAL
Direct Debit Status Reason	DWL_DRCT_DEBT_STAT_RSN
Disconnector	DWR_DSCNCTR
Discrete	DWB_DSCRT
Discrete Value	DWB_DSCRT_VAL
Document	Not physicalized
Document Status	DWB_DOC_STAT
Document Type	DWL_DOC_TYP
Document Type Group	DWL_DOC_TYP_GRP
Document Type Group Assignment	DWR_DOC_TYP_GRP_ASGN
DR Prog End Device Grp Assignment	DWR_DR_PROG_END_DVC_GRP_ASGN
DR Program Agreement Assignment	DWR_DR_PROG_AGRMNT_ASGN
DR Program Load Reduction By Region Day Drvd	DWD_DR_PROG_LD_RDCTN_RGN_DAY
Call Center Case Type	DWL_CALL_CNTR_CASE_TYP
Education	DWL_EDU
Electricity Service	DWR_ELCTRCTY_SRVC
Employee	DWR_EMP
Employee Actual Labor Hourly	DWB_EMP_ACT_LBR_HRLY
Employee Cost	DWB_EMP_COST
Employee Designation	DWL_EMP_DESIG
Employee Job Role Assignment	DWR_EMP_JB_RL_ASGN
Employee Job Role Type	DWL_EMP_JB_RL_TYP
Employee Language Capability	DWR_EMP_LANG_CAPBLTY
Employee Restricted Info	DWR_EMP_RSTRCT_INFO
Employee Schedule	DWR_EMP_SCHL
Employee Training Record	DWB_EMP_TRNG_REC
Employee Type	DWL_EMP_TYP
End Device	DWR_END_DVC
End Device Capability	DWR_END_DVC_CAPBLTY
End Device Control	DWB_END_DVC_CNTRL
End Device Control Type	DWR_END_DVC_CNTRL_TYP
End Device Ctrl Primary Device Timing	DWB_END_DVC_CNTRL_PRMRY_DVC_TMNG
End Device Ctrl Secondary Device Timing	DWB_END_DVC_CNTRL_SCNDRY_DVC_TMNG
End Device Domain	DWL_END_DVC_DOMAIN
End Device End Device Ctrl Assignment	DWR_END_DVC_END_DVC_CTRL_ASGN
End Device End Device Grp Assignment	DWR_END_DVC_END_DVC_GRP_ASGN
End Device Event	DWB_END_DVC_EVT
End Device Event By Customer Day Drvd	DWD_END_DVC_EVT_CUST_DAY
End Device Event by Customer Month Aggr	DWA_END_DVC_EVT_CUST_MO
End Device Event By Device Day Drvd	DWD_END_DVC_EVT_DVC_DAY
End Device Event By Device Month Aggr	DWA_END_DVC_EVT_DVC_MO
End Device Event Detail	DWR_END_DVC_EVT_DTL
End Device Event Or Action	DWL_END_DVC_EVT_OR_ACTN
End Device Event Type	DWL_END_DVC_EVT_TYP
End Device Function	DWR_END_DVC_FNCTN
End Device Function Kind ENUM	DWL_END_DVC_FNCTN_KIND_ENUM
End Device Group	DWR_END_DVC_GRP
End Device Grp End Device Ctrl Assignment	DWR_END_DVC_GP_END_DVC_CTL_ASN
End Device Info	DWR_END_DVC_INFO
End Device Sub Domain	DWL_END_DVC_SB_DOMAIN
End Device Type	DWL_END_DVC_TYP
Energy Area	DWR_ENRGY_AREA
Energy Consumer	DWR_ENRGY_CONSMR
Energy Consumer Phase	DWR_ENRGY_CONSMR_PHS
Energy Flow Direction	DWL_ENRGY_FLOW_DRCTN
Equipment	Not physicalized
Equipment Container	DWR_EQPMNT_CONTNR
Event	DWB_EVT
Event Account	DWB_EVT_ACCT
Event Assignment	DWB_EVT_ASGN
Event Assignment Reason	DWL_EVT_ASGN_RSN
Event Assignment Type	DWL_EVT_ASGN_TYP
Event Category	DWL_EVT_CTGRY
Event Chat	DWB_EVT_CHAT
Event Chat Detail	DWB_EVT_CHAT_DTL
Event Class	DWL_EVT_CLASS
Event Employee Payroll	DWB_EVT_EMP_PYRL
Event Equipment Instance	DWB_EVT_EQPMNT_INSTNC
Event Geography	DWB_EVT_GEO
Event Invoice Delivery	DWB_EVT_INVC_DLVRY
Event Loyalty Program	DWB_EVT_LYLTY_PROG
Event Party Assignment	DWB_EVT_PRTY_ASGN
Event Party Interaction	DWB_EVT_PRTY_INTRACN
Event Party Interaction Call	DWB_EVT_PRTY_INTRACN_CALL
Event Party Interaction Email	DWB_EVT_PRTY_INTRACN_EML
Event Party Interaction Item	DWB_EVT_PRTY_INTRACN_ITEM
Event Party Interaction Letter	DWB_EVT_PRTY_INTRACN_LTTR
Event Party Interaction Participation	DWB_EVT_PRTY_INTRACN_PRTCPTN
Event Party Interaction Visit	DWB_EVT_PRTY_INTRACN_VST
Event Party Profile	DWB_EVT_PRTY_PRFL
Event Party Role	DWL_EVT_PRTY_RL
Event Reason	DWL_EVT_RSN
Event Reason Category	DWL_EVT_RSN_CTGRY
Event Resolution	DWL_EVT_RSLTN
Event Response Reason	DWL_EVT_RESPN_RSN
Event Result	DWL_EVT_RSLT
Event Status	DWB_EVT_STAT
Event Status Reason	DWL_EVT_STAT_RSN
Event Status Type	DWL_EVT_STAT_TYP
Event Type	DWL_EVT_TYP
Event Web Registration	DWB_EVT_WEB_RGSTRTN
Event Web Visit	DWB_EVT_WEB_VST
External Credit Profile	DWR_EXTRNL_CRDT_PRFL
External Credit Profile Assignment	DWR_EXTRNL_CRDT_PRFL_ASGN
External Information Source	DWR_EXTRNL_INFO_SRC
External Organization Type	DWL_EXTRNL_ORG_TYP
FACTS Device	DWR_FCT_DVC
FACTS Device Kind ENUM	DWL_FCT_DVC_KIND_ENUM
Fault	DWR_FLT
Fault Indicator Info	DWR_FLT_IND_INFO
Fault Indicator Reset Kind ENUM	DWL_FLT_IND_RESET_KIND_ENUM
Feeder	DWR_FEDR
Feeder Substation Assignment	DWR_FEDR_SBSTN_ASGN
Final Reading	DWB_FNL_RDNG
Financial Info	DWR_FINCL_INFO
Fiscal Quarter	DWR_FSCL_QTR
Fiscal Year	DWR_FSCL_YR
Flexible Characteristic	DWR_FXBLE_CHTRSTC
Flexible Characteristic Value	Not physicalized
Flood Information	DWB_FLOD_INFO
Frequency Converter	DWR_FREQNCY_CONVRTR
Fuse	DWR_FUSE
Gate Input Pin	DWR_GATE_INPUT_PIN
Gen Unit Op Cost Curve	DWR_GEN_UNIT_OP_COST_CRVE
Gen Unit Op Schedule	DWR_GEN_UNIT_OP_SCHL
Gender	DWL_GNDR
Generating Unit	DWR_GNRTNG_UNIT
Generating Unit Rotating Machine Assignment	DWR_GNRTNG_UNIT_ROTTNG_MC_ASGN
Generator Control Mode ENUM	DWL_GNRTR_CNTRL_MD_ENUM
Generator Control Source ENUM	DWL_GNRTR_CNTRL_SRC_ENUM
Generator Operating Mode ENUM	DWL_GNRTR_OPERTNG_MD_ENUM
Generic Action	DWR_GNRC_ACTN
Geography Building	DWR_GEO_BLDG
Geography City	DWR_GEO_CITY
Geography Complex	DWR_GEO_CMPLX
Geography Country	DWR_GEO_CNTRY
Geography County	DWR_GEO_CNTY
Geography Demographic Group	DWR_GEO_DEMOG_GRP
Geography Demography Attribute	DWR_GEO_DEMOG_ATRIB
Geography Demography Value	DWR_GEO_DEMOG_VAL
Geography Entity	DWR_GEO_ENT
Geography Entity Assignment	DWR_GEO_ENT_ASGN
Geography Entity Hier Level Assignment	DWR_GEO_ENT_HRCHY_LVL_ASGN
Geography Hierarchy	DWR_GEO_HRCHY
Geography Hierarchy Level	DWR_GEO_HRCHY_LVL
Geography Hierarchy Level Assignment	DWR_GEO_HRCHY_LVL_ASGN
Geography Level	DWR_GEO_LVL
Geography Level Attribute	DWR_GEO_LVL_ATRIB
Geography Level Attribute Value	DWR_GEO_LVL_ATRIB_VAL
Geography Region	DWR_GEO_RGN
Geography State	DWR_GEO_STATE
Geography Street	DWR_GEO_STREET
Geography Sub Region	DWR_GEO_SB_RGN
Geography World	DWR_GEO_WORLD
GL Account	DWR_GL_ACCT
GL Account Assignment	DWR_GL_ACCT_ASGN
GL Account Segment	DWR_GL_ACCT_SGMNT
GL Account Type	DWL_GL_ACCT_TYP
GL Balance	DWB_GL_BAL
GL Cost Center Segment	DWR_GL_COST_CNTR_SGMNT
GL JE Line Subledger Assignment	DWB_GL_JE_LN_SBLDGR_ASGN
GL Journal Entry	DWB_GL_JE
GL Journal Entry Batch	DWB_GL_JE_BTCH
GL Journal Entry Category	DWL_GL_JE_CTGRY
GL Journal Entry Line	DWB_GL_JE_LN
GL Ledger	DWR_GL_LDGR
GL Ledger Account Assignment	DWR_GL_LDGR_ACCT_ASGN
GL Org Bsns Unit Segment	DWR_GL_ORG_BSNS_UNIT_SGMNT
GL Period	DWR_GL_PRD
GL Product Specification Segment	DWR_GL_PROD_SPECFTN_SGMNT
GL Project Segment	DWR_GL_PROJ_SGMNT
GL Segment	DWR_GL_SGMNT
GL Segment Type	DWL_GL_SGMNT_TYP
GL Subledger	DWR_GL_SBLDGR
GL Subledger Journal Entry	DWB_GL_SBLDGR_JE
GL Subledger Journal Entry Line	DWB_GL_SBLDGR_JE_LN
Gross To Net Active Power Curve	DWR_GRS_TO_NET_ACTV_POWR_CRVE
Ground Disconnector	DWR_GRND_DSCNCTR
Ground Switch	DWR_GRND_SWTCH
Head End System	DWR_HEAD_END_SYS
Hour	DWR_HR
Hour Time of Use Assignment	DWR_HR_TIME_OF_USE_ASGN
Household	DWR_HH
Hydro Energy Conversion Kind ENUM	DWL_HYDR_ENRG_CNVRSN_KIND_ENUM
Hydro Generating Unit	DWR_HYDRO_GNRTNG_UNIT
Identified Object	Not physicalized
Incident	DWB_INCDNT
Incident Work Assignment	DWR_INCDNT_WRK_ASGN
Individual Demography Value	DWR_INDVL_DEMOG_VAL
Initial Reading	DWB_INITIAL_RDNG
Initiative Result Type	DWL_INTTV_RSLT_TYP
Initiative Type	DWL_INTTV_TYP
Installment Agreement	DWR_INSTLMNT_AGRMNT
Interaction Answer Choice	DWB_INTRACN_ANSWR_CHOICE
Interaction Channel	DWR_INTRACN_CHNL
Interaction Direction	DWL_INTRACN_DRCTN
Interaction Navigation History	DWB_INTRACN_NAVGTN_HIST
Interaction Navigation Item	DWR_INTRACN_NAVGTN_ITEM
Interaction Priority Type	DWL_INTRACN_PRIORITY_TYP
Interaction Question Response	DWB_INTRACN_QUES_RESPN
Interaction Reason	DWL_INTRACN_RSN
Interaction Result Type	DWL_INTRACN_RSLT_TYP
Interaction Status	DWL_INTRACN_STAT
Interaction Transfer History	DWB_INTRACN_TRNSFR_HIST
Interaction Transfer Reason	DWL_INTRACN_TRNSFR_RSN
Interaction Type	DWL_INTRACN_TYP
Interharmonics	DWL_INTRHRMNCS
Invoice	DWB_INVC
Invoice Adjustment	DWB_INVC_ADJ
Invoice Adjustment Quota	DWR_INVC_ADJ_QTA
Invoice Delivery Format	DWL_INVC_DLVRY_FRMT
Invoice Delivery Type	DWL_INVC_DLVRY_TYP
Invoice Discount	DWB_INVC_DISC
Invoice Discount Reason	DWL_INVC_DISC_RSN
Invoice Discount Type	DWL_INVC_DISC_TYP
Invoice Item	DWB_INVC_ITEM
Invoice Item Detail	DWB_INVC_ITEM_DTL
Invoice Item Detail Type	DWL_INVC_ITEM_DTL_TYP
Invoice Item Relationship	DWB_INVC_ITEM_RLTN
Invoice Item Type	DWL_INVC_ITEM_TYP
Invoice Payment Assignment	DWB_INVC_PYMT_ASGN
Invoice Payment Term	DWB_INVC_PYMT_TERM
Invoice Payment Term Type	DWL_INVC_PYMT_TERM_TYP
Invoice Status History	DWB_INVC_STAT_HIST
Invoice Status Type	DWL_INVC_STAT_TYP
Invoice Tax Item	DWB_INVC_TAX_ITEM
Invoice Type	DWL_INVC_TYP
Irregular Interval Schedule	DWR_IRGLR_INTRVL_SCHL
Irregular Time Point	DWR_IRGLR_TIME_PNT
IVR Menu Item	DWL_IVR_MENU_ITEM
Job	DWR_JB
Job Role	DWR_JB_RL
Joint	DWR_JNT
Joint Configuration Kind ENUM	DWL_JNT_CNFGRTN_KIND_ENUM
Joint Fill Kind ENUM	DWL_JNT_FILL_KIND_ENUM
Journal Entry Line Invoice Item Assignment	DWB_JE_LN_INVC_ITEM_ASGN
Jumper	DWR_JMPR
Jumper Action	DWR_JMPR_ACTN
Language	DWL_LANG
Letter Type	DWL_LTTR_TYP
Lifecycle Date	DWR_LIFE_CYCL_DT
Limit	DWR_LMT
Limit Set	DWR_LMT_SET
Line	DWR_LN
Load Area	DWR_LD_AREA
Load Break Switch	DWR_LD_BRK_SWTCH
Load Group	DWR_LD_GRP
Load Response Characteristic	DWR_LD_RESPN_CHTRSTC
Location	DWR_LOC
Loyalty Program	DWR_LYLTY_PROG
Loyalty Program Event Type	DWL_LYLTY_PROG_EVT_TYP
Maintainer	DWR_MNTNR
Manufacturer	DWR_MNFCTR
Marital Status	DWL_MRTL_STAT
Market Area	DWR_MKT_AREA
Market Area Level	DWR_MKT_AREA_LVL
Market Plan Document Requirement	DWR_MKT_PLN_DOC_REQRMNT
Market Role	DWR_MKT_RL
Market Segment	DWR_MKT_SGMNT
Market Segment Inclusion	DWR_MKT_SGMNT_INCLSN
Measurement	DWB_MSRMNT
Measurement Kind	DWL_MSRMNT_KIND
Measurement Location	DWR_MSRMNT_LOC
Measurement Value	DWB_MSRMNT_VAL
Measurement Value Quality	DWR_MSRMNT_VAL_QLTY
Measurement Value Source	DWR_MSRMNT_VAL_SRC
Media Object	DWR_MEDIA_OBJ
Media Object Assignment	DWR_MEDIA_OBJ_ASGN
Media Object Type	DWL_MEDIA_OBJ_TYP
Meter	DWR_MTR
Meter Identifier	DWR_MTR_IDNT
Meter Reading	DWB_MTR_RDNG
Meter Reading Day Drvd	DWD_MTR_RDNG_DAY
Meter Reading Hour Drvd	DWD_MTR_RDNG_HR
Meter Reading Month Aggr	DWA_MTR_RDNG_MO
Meter Reading TOU Month Aggr	DWA_MTR_RDNG_TOU_MO
Meter Register Assignment	DWR_MTR_RGSTER_ASGN
Meter Service Work	DWR_MTR_SRVC_WRK
Meter Status	DWL_MTR_STAT

Table 5-2 Entity Mapping Table: Logical to Physical Mapping: N to Z

Entity	Table or View
NAICS Classification	DWR_NAICS_CLSFCTN
Nationality	DWL_NTNLTY
Non Conform Load	DWR_NON_CNFRM_LD
Non Conform Load Group	DWR_NON_CNFRM_LD_GRP
Non Conform Load Schedule	DWR_NON_CNFRM_LD_SCHL
Nuclear Generating Unit	DWR_NUCLR_GNRTNG_UNIT
Operating Participant	DWR_OPERTNG_PRTCPNT
Operating Share	DWR_OPERTNG_SHR
Operation Tag	DWR_OPRN_TAG
Operational Limit	DWR_OPRTNL_LMT
Operational Limit Set	DWR_OPRTNL_LMT_SET
Operational Restriction	DWR_OPRTNL_RSTRCT
Oracle Geometry	DWR_ORCL_GMTRY
Organization Area	DWR_ORG_AREA
Organization Banner	DWR_ORG_BNR
Organization Business Entity	DWR_ORG_BSNS_ENT
Organization Business Unit	DWR_ORG_BSNS_UNIT
Organization Business Unit Type	DWL_ORG_BSNS_UNIT_TYP
Organization Chain	DWR_ORG_CHAIN
Organization Company	DWR_ORG_CMPNY
Organization Corporate	DWR_ORG_CRPRT
Organization District	DWR_ORG_DSTRCT
Organization Hierarchy	DWR_ORG_HRCHY
Organization Hierarchy Level	DWR_ORG_HRCHY_LVL
Organization Hierarchy Level Assignment	DWR_ORG_HRCHY_LVL_ASGN
Organization Hierarchy Version	DWR_ORG_HRCHY_VRSN
Organization Level	DWR_ORG_LVL
Organization Level Attribute Value	DWR_ORG_LVL_ATRIB_VAL
Organization Level Attributes	DWR_ORG_LVL_ATTR
Organization Market Data	DWR_ORG_MKT_DATA
Organization Region	DWR_ORG_RGN
Organization Role	DWR_ORG_RL
Organization Service Website	DWR_ORG_SRVC_WBSITE
Organization Warehouse	DWR_ORG_WRHS
Organizational Demography Value	DWR_ORG_DEMOG_VAL
Other Individual	DWR_OTHR_INDVL
Outage	DWB_OUTG
Outage By Day Drvd	DWD_OUTG_DAY
Outage By Month Aggr	DWA_OUTG_MO
Outage By Usage Point Drvd	DWD_OUTG_USG_PNT
Outage Code	DWR_OUTG_CD
Outage Notification	DWR_OUTG_NOTFCTN
Outage Plan	DWR_OUTG_PLN
Outage Record	DWB_OUTG_REC
Outage Record Code Assignment	DWR_OUTG_REC_CD_ASGN
Outage Report	DWR_OUTG_RPT
Outage Schedule	DWR_OUTG_SCHL
Outage Step	DWR_OUTG_STEP
Outage Step Code Assignment	DWR_OUTG_STEP_CD_ASGN
Outage Usage Point Assignment	DWR_OUTG_USG_PNT_ASGN
Partner Promotion Program	DWR_PRTNR_PRMTN_PROG
Party	DWR_PRTY
Party Account Assignment	DWR_PRTY_ACCT_ASGN
Party Account Assignment Type	DWL_PRTY_ACCT_ASGN_TYP
Party Address Location Assignment	DWR_PRTY_ADDR_LOC_ASGN
Party Agreement Relationship	DWR_PRTY_AGRMNT_RLTN
Party Assignment	DWR_PRTY_ASGN
Party Assignment Reason	DWL_PRTY_ASGN_RSN
Party Assignment Type	DWL_PRTY_ASGN_TYP
Party Business Interaction Role	DWR_PRTY_BSNS_INTRACN_RL
Party Contact Information	DWR_PRTY_CNCT_INFO
Party Contact Information Type	DWL_PRTY_CNCT_INFO_TYP
Party Contact List Participation	DWL_PRTY_CNCT_LST_PRTCPTN
Party Contact List Role	DWL_PRTY_CNCT_LST_RL
Party Cost Assignment	DWB_PRTY_COST_ASGN
Party Demography Value	Not physicalized
Party Event Type	DWL_PRTY_EVT_TYP
Party Geography Entity Assignment	DWR_PRTY_GEO_ENT_ASGN
Party Interaction Thread	DWB_PRTY_INTRACN_THRD
Party Interaction Thread Subscription Assignment	DWB_PRTY_INTRCN_THRD_SBRP_ASGN
Party Interaction Thread Type	DWL_PRTY_INTRACN_THRD_TYP
Party Language Capability	Not physicalized
Party Location Reason	DWL_PRTY_LOC_RSN
Party Location Type	DWL_PRTY_LOC_TYP
Party Management Role	DWL_PRTY_MGMT_RL
Party Market Segment Assignment	DWR_PRTY_MKT_SGMNT_ASGN
Party Project Participation	DWR_PRTY_PROJ_PRTCPTN
Party Promotion Response	DWB_PRTY_PRMTN_RESPN
Party Role	DWL_PRTY_RL
Party Role Assignment	DWR_PRTY_RL_ASGN
Party Role Status	DWR_PRTY_RL_STAT
Party Status Category	DWL_PRTY_STAT_CTGRY
Party Status Change Reason	DWL_PRTY_STAT_CHNG_RSN
Party Status History	DWB_PRTY_STAT_HIST
Party Status Type	DWL_PRTY_STAT_TYP
Party Type	DWL_PRTY_TYP
Payment Aging Class	DWL_PYMT_AGNG_CLASS
Payment Channel	DWR_PYMT_CHNL
Payment Method Type	DWL_PYMT_MTHD_TYP
Payment Transaction Type	DWL_PYMT_TRX_TYP
Per Length Impedance	DWR_PER_LGTH_IMPNDNC
Per Length Phase Impedance	DWR_PER_LGTH_PHS_IMPNDNC
Per Length Sequence Impedance	DWR_PER_LGTH_SEQ_IMPNDNC
Phase	DWL_PHS
Phase Code ENUM	DWL_PHS_CD_ENUM
Phase Connected Fault	DWR_PHS_CNCTD_FLT
Phase Connected Fault Kind ENUM	DWL_PHS_CNCTD_FLT_KIND_ENUM
Phase Impedance Data	DWR_PHS_IMPNDNC_DATA
Phase Shunt Connection Kind ENUM	DWL_PHS_SHNT_CNCTN_KIND_ENUM
Phase Tap Changer	DWR_PHS_TAP_CHNG
Phase Tap Changer Asymmetrical	DWR_PHS_TAP_CHNG_ASYMTRCL
Phase Tap Changer Linear	DWR_PHS_TAP_CHNG_LNR
Phase Tap Changer Non Linear	DWR_PHS_TAP_CHNG_NON_LNR
Phase Tap Changer Symmetrical	DWR_PHS_TAP_CHNG_SYMTRCL
Phase Tap Changer Tabular	DWR_PHS_TAP_CHNG_TBLR
Phase Tap Changer Tabular Point	DWR_PHS_TAP_CHNG_TBLR_PNT
Pin Voltage	DWR_PIN_VLTG
Planned Outage	DWR_PLND_OUTG
Planned Outage Kind ENUM	DWL_PLND_OUTG_KIND_ENUM
Pole	DWR_POLE
Pole Base Kind ENUM	DWL_POLE_BASE_KIND_ENUM
Pole Preservative Kind ENUM	DWL_POLE_PRSRVTV_KIND_ENUM
Pole Treatment Kind ENUM	DWL_POLE_TRTMNT_KIND_ENUM
Postal Service Type	DWL_POSTL_SRVC_TYP
Postcode	DWR_POSTCD
Potential Transformer Info	DWR_PTNTL_TRNSFRMR_INFO
Power Cut Zone	DWR_POWR_CUT_ZN
Power System Resource	Not physicalized
Power System Resource Location	DWR_POWR_SYS_RESRE_LOC
Power Transformer	DWR_POWR_TRNSFRMR
Power Transformer End	DWR_POWR_TRNSFRMR_END
Power Transformer Info	DWR_POWR_TRNSFRMR_INFO
Precipitation	DWB_PPTN
Price Event	DWB_PRICE_EVT
Price Type	DWL_PRICE_TYP
Pricing Structure	DWR_PRCNG_STRUCTR
Pricing Structure Tariff Assignment	DWR_PRCNG_STRCTR_TRF_ASGN
Priority	DWR_PRIORITY
Procedure	DWR_PROC
Procedure Asset Assignment	DWR_PROC_ASST_ASGN
Procedure Kind ENUM	DWL_PROC_KIND_ENUM
Product Asset Model	DWR_PROD_ASST_MDL
Product Asset Model Function Assignment	DWR_PROD_ASST_MDL_FNCTN_ASGN
Product Offering	DWR_PROD_OFRNG
Product Subscription	DWR_PROD_SBRP
Project	DWR_PROJ
Project Element	DWR_PROJ_ELMNT
Promotion	DWR_PRMTN
Promotion Cluster Usage	DWB_PRMTN_CLSTR_USG
Promotion Contact List Utilization	DWB_PRMTN_CNCT_LST_UTLZTN
Promotion Management History	DWB_PRMTN_MGMT_HIST
Promotion Message Rendering	DWR_PRMTN_MSG_RNDRNG
Promotion Product Offering Assignment	DWR_PRMTN_PROD_OFRNG_ASGN
Promotion Relationship	DWR_PRMTN_RLTN
Promotion Result Type	DWL_PRMTN_RSLT_TYP
Promotion Sales Channel Assignment	DWR_PRMTN_SL_CHNL_ASGN
Promotion Term Type	DWL_PRMTN_TERM_TYP
Promotion Term Value	DWL_PRMTN_TERM_VAL
Promotion Type	DWL_PRMTN_TYP
Proposal	DWR_PRPSL
Proposal Relationship	DWR_PRPSL_RLTN
Prospect	DWR_PRSPCT
Prospect Priority Type	DWL_PRSPCT_PRIORITY_TYP
Prospect Quality Score Type	DWL_PRSPCT_QLTY_SCR_TYP
Prospect Quality Score Value	DWR_PRSPCT_QLTY_SCR_VAL
Prospect Reject Reason	DWL_PRSPCT_REJECT_RSN
Protected Switch	DWR_PRTCTD_SWTCH
Protection Equipment	DWR_PROTCTN_EQPMNT
Protection Equipment Info	DWR_PROTCTN_EQPMNT_INFO
PSR Type	DWL_PSR_TYP
Publication	DWR_PBLCTN
Publication Type	DWL_PBLCTN_TYP
Purchase Order	DWB_PCHSE_ORDR
Purchase Order Line Item	DWB_PCHSE_ORDR_LI
Quality61850	Not physicalized
Rate	DWR_RATE
Ratio Tap Changer	DWR_RATIO_TAP_CHNG
Ratio Tap Changer Tabular	DWR_RATIO_TAP_CHNG_TBLR
Ratio Tap Changer Tabular Point	DWR_RATIO_TAP_CHNG_TBLR_PNT
Rational Number	DWR_RTNL_NBR
Reading Accumulation Behavior	DWL_RDNG_ACMLTN_BHVR
Reading Channel	DWR_RDNG_CHNL
Reading Channel Identifier	DWR_RDNG_CHNL_IDNT
Reading Data Qualifier	DWL_RDNG_DATA_QLFR
Reading Quality	DWB_RDNG_QLTY
Reading Quality Type	DWL_RDNG_QLTY_TYP
Reading Quality Type Category	DWL_RDNG_QLTY_TYP_CTGRY
Reading Quality Type Origin	DWL_RDNG_QLTY_TYP_ORIGIN
Reading Quality Type Sub Category	DWL_RDNG_QLTY_TYP_SB_CTGRY
Reading Reason Kind ENUM	DWL_RDNG_RSN_KIND_ENUM
Reading Time Attribute	DWL_RDNG_TIME_ATRIB
Reading Time Period	DWL_RDNG_TIME_PRD
Reading Type	DWR_RDNG_TYP
Recloser	DWR_RCLSR
Register	DWR_RGSTER
Regular Interval Schedule	DWR_RGLR_INTRVL_SCHL
Regular Time Point	DWR_RGLR_TIME_PNT
Regulating Cond Eq	DWR_RGLTNG_COND_EQ
Regulating Control	DWR_RGLTNG_CNTRL
Regulating Control Mode Kind ENUM	DWL_RGLTNG_CNTRL_MD_KIND_ENUM
Regulation Schedule	DWR_REGULTN_SCHL
Reliability Indices By City Month Drvd	DWD_RLBLTY_IND_CITY_MO
Reliability Indices By Feeder Month Drvd	DWD_RLBLTY_IND_FEDR_MO
Remote Connect Disconnect Info	DWR_RMT_CONCT_DSCNCT_INFO
Remote Control	DWR_RMT_CNTRL
Remote Point	DWR_RMT_PNT
Remote Source	DWR_RMT_SRC
Remote Unit	DWR_RMT_UNIT
Remote Unit Communication Link Assignment	DWR_RMT_UNIT_COMUNCTN_LNK_ASGN
Remote Unit Type ENUM	DWL_RMT_UNIT_TYP_ENUM
Resource Order	DWB_RESRE_ORDR
Resource Order Item	DWB_RESRE_ORDR_ITEM
Revenue Kind ENUM	DWL_RVN_KIND_ENUM
Rotating Machine	DWR_ROTTNG_MC
Safety Document	DWR_SFTY_DOC
Sales Channel	DWR_SL_CHNL
SCD2	Not physicalized
Scheduled Event	DWB_SCHL_EVT
Scheduled Event Asset Assignment	DWR_SCHL_EVT_ASST_ASGN
Script	DWR_SCRPT
Script Question	DWR_SCRPT_QUES
Sea Condition	DWB_SEA_CNDTN
Seal	DWR_SEAL
Seal Condition Kind ENUM	DWL_SEAL_CNDTN_KIND_ENUM
Seal Kind ENUM	DWL_SEAL_KIND_ENUM
Season	DWL_SEASON
Season Day Type Schedule	DWR_SEASON_DAY_TYP_SCHL
Sectionaliser	DWR_SECTNR
Segment Criteria	DWR_SGMNT_CRTRA
Segment Type	DWL_SGMNT_TYP
Series Compensator	DWR_SERIES_CMPNSTR
Service	DWR_SRVC
Service Category	DWL_SRVC_CTGRY
Service Coverage Area	DWR_SRVC_COVRG_AREA
Service Coverage Geo Detail	DWR_SRVC_COVRG_GEO_DTL
Service Location	DWR_SRVC_LOC
Service Location Identifier	DWR_SRVC_LOC_IDNT
Service Order	DWB_SRVC_ORDR
Service Order Line Item	DWB_SRVC_ORDR_LI
Service Quantity	DWR_SRVC_QTY
Service Supplier	DWR_SRVC_SPPLR
Service Type	DWL_SRVC_TYP
Set Point	DWB_SET_PNT
Short Circuit Rotor Kind ENUM	DWL_SHORT_CRCUT_RTR_KIND_ENUM
Shunt Compensator	DWR_SHNT_CMPNSTR
Shunt Compensator Info	DWR_SHNT_CMPNSTR_INFO
Shunt Compensator Phase	DWR_SHNT_CMPNSTR_PHS
SIC Assignment	DWR_SIC_ASGN
SIC Assignment Reason	DWL_SIC_ASGN_RSN
SIC Classification	DWL_SIC_CLSFCTN
Simple End Device Function	DWR_SMPL_END_DVC_FNCTN
Single Phase Kind ENUM	DWL_SNGL_PHS_KIND_ENUM
SOC Job	DWR_SOC_JB
SOC Job Category	DWR_SOC_JB_CTGRY
SOC Job Group	DWR_SOC_JB_GRP
Source ENUM	DWL_SRC_ENUM
Source System	DWR_SRC_SYS
Source System Key Mapping	DWR_SRC_SYS_KEY_MAP
Source System Type	DWL_SRC_SYS_TYP
Spot Temperature	DWB_SPOT_TEMP
Static Var Compensator	DWR_STATIC_VAR_CMPNSTR
Station Supply	DWR_STN_SPPLY
Status	DWR_STAT
Steam Sendout Schedule	DWR_STEAM_SNDOUT_SCHL
Streetlight	DWR_STREETLGHT
Streetlight Lamp Kind ENUM	DWL_STREETLGHT_LAMP_KIND_ENUM
String Measurement	DWB_STRNG_MSRMNT
String Measurement Value	DWB_STRNG_MSRMNT_VAL
Structure	DWR_STRCTR
Structure Material Kind ENUM	DWL_STRCTR_MTRL_KIND_ENUM
Structure Support	DWR_STRCTR_SPPRT
Structure Support Kind ENUM	DWL_STRCTR_SPPRT_KIND_ENUM
Sub Geographical Region	DWR_SB_GEOCL_RGN
Sub Load Area	DWR_SB_LD_AREA
Substation	DWR_SBSTN
Surge Arrester Info	DWR_SRG_ARSTR_INFO
Survey	DWR_SURVEY
SVC Control Mode ENUM	DWL_SVC_CNTRL_MD_ENUM
Switch	DWR_SWTCH
Switch Action	DWR_SWTCH_ACTN
Switch Action Kind ENUM	DWL_SWTCH_ACTN_KIND_ENUM
Switch Connect Disconnect Func Assignment	DWR_SWTCH_CNCT_DSCNCT_FNC_ASGN
Switch Info	DWR_SWTCH_INFO
Switch Phase	DWR_SWTCH_PHS
Switch Schedule	DWR_SWTCH_SCHL
Switch State ENUM	DWL_SWTCH_STATE_ENUM
Switch Switching Operation Assignment	DWR_SWTCH_SWTCHNG_OPRN_ASGN
Switching Activity	DWR_SWTCHNG_ACTVTY
Switching Activity Safety Doc Assignment	DWR_SWTCH_ACTVTY_SFTY_DOC_ASGN
Switching Operation	DWR_SWTCHNG_OPRN
Switching Plan	DWR_SWTCHNG_PLN
Switching Step	DWR_SWTCHNG_STEP
Switching Step Group	DWR_SWTCHNG_STEP_GRP
Synchrocheck Relay	DWR_SYNCHRCHCK_RLY
Synchronous Machine	DWR_SYNCHRNS_MC
Synchronous Machine Kind ENUM	DWL_SYNCHRNS_MC_KIND_ENUM
Synchronous Machine Operating Mode ENUM	DWL_SNCHRNS_MC_OPERTNG_MD_ENUM
Tag Action	DWR_TAG_ACTN
Tag Action Kind ENUM	DWL_TAG_ACTN_KIND_ENUM
Tap Changer	DWR_TAP_CHNG
Tap Changer Control	DWR_TAP_CHNG_CNTRL
Tap Changer Info	DWR_TAP_CHNG_INFO
Tap Schedule	DWR_TAP_SCHL
Target Account	DWR_TRGT_ACCT
Target Agreement	DWR_TRGT_AGRMNT
Target Geography Area	DWR_TRGT_GEO_AREA
Target Market Segment	DWR_TRGT_MKT_SGMNT
Target Type	DWL_TRGT_TYP
Tariff	DWR_TRF
Tariff Profile	DWR_TRF_PRFL
Tariff Tariff Profile Assignment	DWR_TRF_TRF_PRFL_ASGN
Task	DWR_TASK
Tax Authority	DWL_TAX_AUTH
Tax Category	DWL_TAX_CTGRY
Terminal	DWR_TRML
Thermal Generating Unit	DWR_THRML_GNRTNG_UNIT
Time Of Use	DWL_TIME_OF_USE
Time Schedule	DWR_TIME_SCHL
Time Slot	DWR_TIME_SLT
Time Tariff Interval	DWR_TIME_TRF_INTRVL
Tool	DWR_TOOL
Topological Node	DWR_TPLGCL_ND
Tower	DWR_TWR
Tower Construction Kind ENUM	DWL_TWR_CONSTRCTN_KIND_ENUM
Transformer Control Mode ENUM	DWL_TRNSFRMR_CNTRL_MD_ENUM
Transformer Core Admittance	DWR_TRNSFRMR_CORE_ADMTTNC
Transformer End	DWR_TRNSFRMR_END
Transformer End Info	DWR_TRNSFRMR_END_INFO
Transformer Feeder Assignment	DWR_TRNSFRMR_FEDR_ASGN
Transformer Mesh Impedance	DWR_TRNSFRMR_MESH_IMPNDNC
Transformer Star Impedance	DWR_TRNSFRMR_STAR_IMPNDNC
Transformer Tank	DWR_TRNSFRMR_TANK
Transformer Tank End	DWR_TRNSFRMR_TANK_END
Transformer Tank Info	DWR_TRNSFRMR_TANK_INFO
Trouble Reporting Kind ENUM	DWL_TRBL_RPT_KIND_ENUM
Trouble Ticket	DWR_TRBL_TCKT
Underground Structure	DWR_UNDRGRND_STRCTR
Underground Structure Kind ENUM	DWL_UNDRGRND_STRCTR_KIND_ENUM
Unit Multiplier	DWL_UNIT_MLTPLR
Unit Multiplier ENUM	DWL_UNIT_MLTPLR_ENUM
Unit Of Measure	DWL_UOM
Unit Symbol ENUM	DWL_UNIT_SYMBL_ENUM
Usage Point	DWR_USG_PNT
Usage Point Connected Kind ENUM	DWL_USG_PNT_CNCTD_KIND_ENUM
Usage Point End Device Ctrl Assignment	DWR_USG_PNT_END_DVC_CTRL_ASGN
Usage Point Equipment Assignment	DWR_USG_PNT_EQPMNT_ASGN
Usage Point Group	DWR_USG_PNT_GRP
Usage Point Group Assignment	DWR_USG_PNT_GRP_ASGN
Usage Point Group DR Program Assignment	DWR_USG_PNT_GRP_DR_PROG_ASGN
Usage Point Location	DWR_USG_PNT_LOC
Usage Point Transformer Assignment	DWR_USG_PNT_TRNSFRMR_ASGN
Usage Point Transformer Assignment	DWR_USG_PT_GP_END_DVC_CTL_ASGN
Usage Read Cycle	DWR_USG_READ_CYCL
Utility Commodity	DWL_UTLTY_CMDTY
Validity ENUM	DWL_VLDTY_ENUM
Value Alias Set	DWR_VAL_ALS_SET
Value To Alias	DWR_VAL_TO_ALS
Value Type	DWL_VAL_TYP
VEE Exception	DWB_VEE_EXPTN
VEE Exception Type	DWL_VEE_EXPTN_TYP
VEE Group	DWL_VEE_GRP
VEE Rule	DWL_VEE_RULE
Vehicle	DWR_VHCL
Vendor	DWR_VNDR
Vendor Item	DWR_VNDR_ITEM
Virtual Team	DWR_VRTL_TEAM
Voltage Control Zone	DWR_VLTG_CNTRL_ZN
Voltage Limit	DWR_VLTG_LMT
Weather Alert	DWL_WEATHR_ALRT
Weather Forecast	DWL_WEATHR_FRCST
Weather Information	DWL_WEATHR_INFO
Weather Location	DWL_WEATHR_LOC
Web Page	DWR_WEB_PG
Wind Gen Unit Kind ENUM	DWL_WND_GEN_UNIT_KIND_ENUM
Wind Generating Unit	DWR_WND_GNRTNG_UNIT
Wind Information	DWB_WND_INFO
Winding Connection ENUM	DWL_WNDNG_CNCTN_ENUM
Wire Info	DWR_WR_INFO
Wire Insulation Kind ENUM	DWL_WR_INSLTN_KIND_ENUM
Wire Material Kind ENUM	DWL_WR_MTRL_KIND_ENUM
Wire Spacing Info	DWR_WR_SPCNG_INFO
Wire Usage Kind ENUM	DWL_WR_USG_KIND_ENUM
Work Asset	DWR_WRK_ASST
Work Billing Info	DWR_WRK_BLLG_INFO
Work Cost Detail	DWR_WRK_COST_DTL
Work Cost Summary	DWB_WRK_COST_SUMM
Work Document	Not physicalized
Work Flow Step	DWR_WRK_FLOW_STEP
Work Identified Object	Not physicalized
Work Kind ENUM	DWL_WRK_KIND_ENUM
Work Location	DWR_WRK_LOC
Work Order	DWR_WRK_ORDR
Work Status Entry	DWR_WRK_STAT_ENTRY
Work Status Kind ENUM	DWL_WRK_STAT_KIND_ENUM
Work Task	DWR_WRK_TASK
Work Task Asset Assignment	DWR_WRK_TASK_AS_SET_ASGN
Work Task Kind ENUM	DWL_WRK_TASK_KIND_ENUM
Work Time Schedule	DWR_WRK_TIME_SCHL
Work Time Schedule Kind ENUM	DWL_WRK_TIME_SCHL_KIND_ENUM
Zone	DWR_ZN
Zone Kind ENUM	DWL_ZN_KIND_ENUM