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:
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.
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 |
---|---|
DWR_AC_LN_SGMNT |
|
DWR_AC_LN_SGMNT_PHS |
|
DWR_ACPT_TEST |
|
DWR_ACCT |
|
DWB_ACCT_ACCT_CYCL_HIST |
|
DWL_ACCT_ADJ_RSN |
|
DWR_ACCT_AGRMNT_RLTN |
|
DWD_ACCT_ARRER_MO |
|
DWR_ACCT_ASGN |
|
DWL_ACCT_ASGN_RSN |
|
DWL_ACCT_ASGN_TYP |
|
DWB_ACCT_BAL_ADJ |
|
DWL_ACCT_BAL_ADJ_TYP |
|
DWB_ACCT_BAL_BKT |
|
DWR_ACCT_BAL_GRP |
|
DWB_ACCT_BAL_HIST |
|
DWB_ACCT_BAL_IMPT |
|
DWD_ACCT_BAL_MO |
|
DWL_ACCT_BAL_TYP |
|
DWR_ACCT_BLLG_CYCL_HIST |
|
DWR_ACCT_BLLG_FREQNCY_HIST |
|
DWB_ACCT_BLLG_OCCRNCE |
|
DWR_ACCT_BLLG_PRD_HIST |
|
DWR_ACCT_BSNS_INTRACN_RL |
|
DWB_ACCT_CRDT_LMT |
|
DWB_ACCT_DEBT |
|
DWD_ACCT_DEBT_DAY |
|
DWL_ACCT_EVT_TYP |
|
DWB_ACCT_MGMT_HIST |
|
DWB_ACCT_PYMT |
|
DWB_ACCT_PYMT_BAL_IMPT |
|
DWD_ACCT_PYMT_DAY |
|
DWB_ACCT_PYMT_MTHD_STAT |
|
DWD_ACCT_PYMT_MTHD_STAT_HIST |
|
DWL_ACCT_PYMT_MTHD_STAT_RSN |
|
DWL_ACCT_PYMT_MTHD_STAT_TYP |
|
DWR_ACCT_PREF_INVC_DLVRY |
|
DWR_ACCT_PREF_PYMT_MTHD |
|
DWR_ACCT_PRFL |
|
DWB_ACCT_RCHRG |
|
DWB_ACCT_RFND |
|
DWL_ACCT_RFND_RSN |
|
DWL_ACCT_RL_TYP |
|
DWR_ACCT_SGMNT |
|
DWR_ACCT_SGMNT_ASGN_HIST |
|
DWR_ACCT_SGMNT_MDL |
|
DWB_ACCT_STAT_HIST |
|
DWD_ACCT_STAT_MO |
|
DWL_ACCT_STAT_RSN |
|
DWL_ACCT_STAT_TYP |
|
DWL_ACCT_TYP |
|
DWR_ACCT_CYCL |
|
DWL_ACCT_ITEM_CTGRY |
|
DWB_ACCMLTR |
|
DWR_ACCMLTR_LMT |
|
DWR_ACCMLTR_LMT_SET |
|
DWR_ACCMLTR_LMT_SET_ASGN |
|
DWB_ACCMLTR_VAL |
|
Not physicalized |
|
DWR_ACTV_POWR_LMT |
|
DWB_ACTVTY_REC |
|
DWR_ADDR_LOC |
|
DWR_AGRMNT_ITEM_PRCNG_STRUCT_ASGN |
|
DWR_AGRMNT |
|
DWB_AGRMNT_APRVL |
|
DWB_AGRMNT_ASGN |
|
DWL_AGRMNT_ASGN_RSN |
|
DWL_AGRMNT_ASGN_TYP |
|
DWR_AGRMNT_DOC |
|
DWR_AGRMNT_ITEM |
|
DWB_AGRMNT_STAT |
|
DWL_AGRMNT_STAT_TYP |
|
DWL_AGRMNT_TYP |
|
DWR_AGRMNT_USG_PNT_ASGN |
|
DWR_AIR_CMPRSR |
|
DWL_AMI_BLLG_RDY_KIND_ENUM |
|
DWB_ANLG |
|
DWR_ANLG_LMT |
|
DWR_ANLG_LMT_SET |
|
DWR_ANLG_LMT_SET_ASGN |
|
DWB_ANLG_VAL |
|
DWL_ANCHOR_KIND_ENUM |
|
DWR_ANZSC_CLSFCTN |
|
DWR_APRNT_POWR_LMT |
|
DWB_APNMNT |
|
DWL_APNMNT_TYP |
|
DWR_ASST |
|
DWR_ASST_ACTVTY_REC_ASGN |
|
DWB_ASST_APPRSL_HIST |
|
DWB_ASST_CNDTN_HIST |
|
Not physicalized |
|
DWR_ASST_FNCTN |
|
DWR_ASST_INFO |
|
DWR_ASST_LOC |
|
DWR_ASST_MDL |
|
DWR_ASST_MDL_CTLG |
|
DWR_ASST_MDL_CTLG_ITEM |
|
DWL_ASST_MDL_USG_KIND_ENUM |
|
DWR_ASST_ORG_RL |
|
DWR_ASST_ORG_RL_ASGN |
|
DWR_ASST_OWNR |
|
DWR_ASST_PSR_ASGN |
|
DWR_ASST_STAT |
|
DWL_ASST_TYP |
|
DWR_ASST_USER |
|
Not physicalized |
|
DWB_ATMSPHRC_PRSSR |
|
DWR_BNK |
|
DWR_BNK_DRCT_DEBT_CHNL |
|
DWL_BARNG_RSN |
|
Not physicalized |
|
DWR_BASE_VLTG |
|
Not physicalized |
|
Not physicalized |
|
DWR_BLLG_CYCL |
|
DWR_BLLG_FREQNCY |
|
DWL_BLLG_OCCRNCE_TYP |
|
DWL_BLLG_PRD |
|
DWB_BLK_LST_HIST |
|
DWR_BRKR |
|
DWR_BSBR_SECTN |
|
DWR_BSBR_SECTN_INFO |
|
DWR_BSHNG |
|
DWL_BSHNG_INSLTN_KIND_ENUM |
|
DWR_BSNS_CASE |
|
DWR_BSNS_HLF_MO |
|
DWR_BSNS_HLF_YR |
|
DWB_BSNS_INTRACN |
|
DWR_BSNS_INTRACN_ASGN |
|
DWL_BSNS_INTRACN_ASGN_TYP |
|
DWB_BSNS_INTRACN_ITEM |
|
DWB_BSNS_INTRACN_ITEM_PRICE |
|
DWR_BSNS_INTRACN_LOC_ASGN |
|
DWB_BSNS_INTRACN_RL |
|
DWB_BSNS_INTRACN_STAT_HIST |
|
DWL_BSNS_INTRACN_STAT_RSN |
|
DWL_BSNS_INTRACN_STAT_TYP |
|
DWL_BSNS_INTRACN_TYP |
|
DWR_BSNS_INTRACN_VRSN |
|
DWL_BSNS_LEGAL_STAT |
|
DWR_BSNS_MO |
|
DWR_BSNS_QTR |
|
DWR_BSNS_UNIT_JB_RL |
|
DWR_BSNS_WK |
|
DWR_BSNS_YR |
|
DWR_CAES_PLNT |
|
DWR_CLNDR_HLF_MO |
|
DWR_CLNDR_HLF_YR |
|
DWR_CLNDR_MO |
|
DWR_CLNDR_QTR |
|
DWR_CLNDR_WK |
|
DWR_CLNDR_YR |
|
DWR_CALL_CNTR |
|
DWR_CALL_CNTR_AGNT |
|
DWL_CALL_CNTR_CASE_SB_TYP |
|
DWL_CALL_CNTR_CASE_TTL |
|
DWR_CALL_CNTR_SRVC_CAPBLTY |
|
DWR_CMPGN |
|
DWR_CMPGN_CHNL |
|
DWR_CMPGN_CHNL_ASGN |
|
DWL_CMPGN_CHNL_TYP |
|
DWR_CMPGN_CHTRSTC |
|
DWR_CMPGN_CHTRSTC_VAL |
|
DWR_CMPGN_DOC |
|
DWR_CMPGN_MGMT_HIST |
|
DWR_CMPGN_MSG |
|
DWB_CMPGN_MSG_CRTVE |
|
DWR_CMPGN_MSG_DPCT |
|
DWR_CMPGN_RLTN |
|
DWL_CMPGN_STAT |
|
DWR_CMPGN_TERM_VAL |
|
DWL_CMPGN_TYP |
|
DWR_CHNL |
|
DWL_CHNL_TYP |
|
DWL_CHRG_KIND_ENUM |
|
DWR_CLMP |
|
DWR_CLRNCE_ACTN |
|
DWL_CLRNCE_ACTN_KIND_ENUM |
|
DWR_CLRNCE_DOC |
|
DWB_CLOUD_INFO |
|
DWR_CGNRTN_PLNT |
|
DWR_COLLCTN_AGNCY |
|
DWL_COMUNICTN_DRCTN_KIND_ENUM |
|
DWR_COMUNICTN_FNCTN |
|
DWR_COMUNICTN_MEDIA |
|
DWR_COMUNICTN_MODULE |
|
DWL_COMUNICTN_TCHNLGY_KIND_ENUM |
|
DWR_CMBND_CYCL_PLNT |
|
DWB_CMND |
|
DWR_COMUNICTN_LNK |
|
DWR_CMPTBL_UNIT |
|
DWR_CMPTBL_UNIT_PROC_ASGN |
|
DWR_CMPST_SWTCH_INFO |
|
DWL_CMPST_SWTCH_KIND_ENUM |
|
DWR_CNDTNG_EQP_PRTCTN_EQP_ASGN |
|
Not physicalized |
|
DWR_CNDCTR |
|
DWB_CNFGRTN_EVT |
|
DWR_CNFRM_LD |
|
DWR_CNFRM_LD_GRP |
|
DWR_CNFRM_LD_SCHL |
|
DWR_CONCT_DSCNCT_FNCTN |
|
DWR_CONCTVT_ND |
|
DWR_CONCTVT_ND_CONTNR |
|
DWR_CNCTR |
|
DWR_CNSMPTN_TRF_INTRVL |
|
DWR_CNSMPTN_TIER |
|
DWR_CNCT_LST |
|
DWL_CNCT_LST_CHNG_RSN |
|
DWL_CNCT_LST_RCRNC_TYP |
|
DWL_CNCT_RLS |
|
DWB_CNTRL |
|
DWL_CNTRL_TYP |
|
DWL_COLNT_TYP_ENUM |
|
DWL_CRPRT_STNDRD_KIND_ENUM |
|
DWB_COST |
|
DWR_COST_CNTR |
|
DWL_COST_RSN |
|
DWL_COST_SB_TYP |
|
DWL_COST_TYP |
|
DWR_CRDT_CTGRY |
|
DWR_CRDT_SCR_PRVDR |
|
DWR_CREW |
|
DWR_CREW_MBR |
|
DWR_CREW_TYP |
|
DWR_CREW_WRK_TASK_ASGN |
|
DWR_CRTCL_PK_PRD |
|
DWL_CRNCY |
|
DWL_CRNCY_ENUM |
|
DWB_CRNCY_EXCHNG_RATE |
|
DWR_CRNCY_GEO_ENT_ASGN |
|
DWR_CURR_LMT |
|
DWR_CURR_RLY |
|
DWR_CURR_TRNSFRMR_INFO |
|
DWR_CRVE |
|
DWB_CRVE_DATA |
|
DWL_CRVE_STYLE_ENUM |
|
DWR_CUST |
|
DWR_CUST_ACCT_ASGN |
|
DWR_CUST_DOC |
|
DWR_CUST_FCNG_SRVC |
|
DWL_CUST_GRP |
|
DWR_CUST_GRP_ASGN |
|
DWR_CUST_INDVL |
|
DWL_CUST_KIND_ENUM |
|
DWD_CUST_MNNG |
|
DWR_CUST_OCCSN |
|
DWL_CUST_OCCSN_TYP |
|
DWB_CUST_ORDR |
|
DWR_CUST_ORDR_DOC |
|
DWB_CUST_ORDR_LI |
|
DWR_CUST_ORG |
|
DWR_CUST_OUTG_NOTFCTN_ASGN |
|
DWR_CUST_RSTRCT_INFO |
|
DWL_CUST_RVN_BND |
|
DWR_CUST_RVN_BND_ASGN |
|
DWR_CUST_SCR |
|
DWR_CUST_SGMNT |
|
DWR_CUST_SGMNT_MDL |
|
DWR_CUST_SIC_ASGN |
|
DWR_CUST_SRC |
|
DWL_CUST_TYP |
|
DWR_CUST_WRK_ASGN |
|
DWR_CUT |
|
DWR_CUT_ACTN |
|
DWL_CUT_JMPR_ACTN_KIND_ENUM |
|
DWR_DAY |
|
DWL_DAY_TYP |
|
DWR_DC_CNDCTNG_EQPMNT |
|
DWR_DC_LN_SGMNT |
|
DWL_DEBT_AGNG_BND |
|
DWB_DEBT_COLLCTN |
|
DWB_DEBT_COLLCTN_ASGN |
|
DWB_DEBT_COLLCTN_ASGN_BTCH |
|
DWR_DEMAND_RESPN_PROG |
|
DWR_DEMAND_TRF_INTRVL |
|
DWR_DEMOG_CHTRSTC |
|
DWR_DEMOG_ATRIB |
|
DWR_DEMOG_GRP |
|
DWR_DRVD_VAL |
|
DWL_DRCT_DEBT_STAT_RSN |
|
DWR_DSCNCTR |
|
DWB_DSCRT |
|
DWB_DSCRT_VAL |
|
Not physicalized |
|
DWB_DOC_STAT |
|
DWL_DOC_TYP |
|
DWL_DOC_TYP_GRP |
|
DWR_DOC_TYP_GRP_ASGN |
|
DWR_DR_PROG_END_DVC_GRP_ASGN |
|
DWR_DR_PROG_AGRMNT_ASGN |
|
DWD_DR_PROG_LD_RDCTN_RGN_DAY |
|
DWL_CALL_CNTR_CASE_TYP |
|
DWL_EDU |
|
DWR_ELCTRCTY_SRVC |
|
DWR_EMP |
|
DWB_EMP_ACT_LBR_HRLY |
|
DWB_EMP_COST |
|
DWL_EMP_DESIG |
|
DWR_EMP_JB_RL_ASGN |
|
DWL_EMP_JB_RL_TYP |
|
DWR_EMP_LANG_CAPBLTY |
|
DWR_EMP_RSTRCT_INFO |
|
DWR_EMP_SCHL |
|
DWB_EMP_TRNG_REC |
|
DWL_EMP_TYP |
|
DWR_END_DVC |
|
DWR_END_DVC_CAPBLTY |
|
DWB_END_DVC_CNTRL |
|
DWR_END_DVC_CNTRL_TYP |
|
DWB_END_DVC_CNTRL_PRMRY_DVC_TMNG |
|
DWB_END_DVC_CNTRL_SCNDRY_DVC_TMNG |
|
DWL_END_DVC_DOMAIN |
|
DWR_END_DVC_END_DVC_CTRL_ASGN |
|
DWR_END_DVC_END_DVC_GRP_ASGN |
|
DWB_END_DVC_EVT |
|
DWD_END_DVC_EVT_CUST_DAY |
|
DWA_END_DVC_EVT_CUST_MO |
|
DWD_END_DVC_EVT_DVC_DAY |
|
DWA_END_DVC_EVT_DVC_MO |
|
DWR_END_DVC_EVT_DTL |
|
DWL_END_DVC_EVT_OR_ACTN |
|
DWL_END_DVC_EVT_TYP |
|
DWR_END_DVC_FNCTN |
|
DWL_END_DVC_FNCTN_KIND_ENUM |
|
DWR_END_DVC_GRP |
|
DWR_END_DVC_GP_END_DVC_CTL_ASN |
|
DWR_END_DVC_INFO |
|
DWL_END_DVC_SB_DOMAIN |
|
DWL_END_DVC_TYP |
|
DWR_ENRGY_AREA |
|
DWR_ENRGY_CONSMR |
|
DWR_ENRGY_CONSMR_PHS |
|
DWL_ENRGY_FLOW_DRCTN |
|
Not physicalized |
|
DWR_EQPMNT_CONTNR |
|
DWB_EVT |
|
DWB_EVT_ACCT |
|
DWB_EVT_ASGN |
|
DWL_EVT_ASGN_RSN |
|
DWL_EVT_ASGN_TYP |
|
DWL_EVT_CTGRY |
|
DWB_EVT_CHAT |
|
DWB_EVT_CHAT_DTL |
|
DWL_EVT_CLASS |
|
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_ITEM |
|
DWB_EVT_PRTY_INTRACN_LTTR |
|
DWB_EVT_PRTY_INTRACN_PRTCPTN |
|
DWB_EVT_PRTY_INTRACN_VST |
|
DWB_EVT_PRTY_PRFL |
|
DWL_EVT_PRTY_RL |
|
DWL_EVT_RSN |
|
DWL_EVT_RSN_CTGRY |
|
DWL_EVT_RSLTN |
|
DWL_EVT_RESPN_RSN |
|
DWL_EVT_RSLT |
|
DWB_EVT_STAT |
|
DWL_EVT_STAT_RSN |
|
DWL_EVT_STAT_TYP |
|
DWL_EVT_TYP |
|
DWB_EVT_WEB_RGSTRTN |
|
DWB_EVT_WEB_VST |
|
DWR_EXTRNL_CRDT_PRFL |
|
DWR_EXTRNL_CRDT_PRFL_ASGN |
|
DWR_EXTRNL_INFO_SRC |
|
DWL_EXTRNL_ORG_TYP |
|
DWR_FCT_DVC |
|
DWL_FCT_DVC_KIND_ENUM |
|
DWR_FLT |
|
DWR_FLT_IND_INFO |
|
DWL_FLT_IND_RESET_KIND_ENUM |
|
DWR_FEDR |
|
DWR_FEDR_SBSTN_ASGN |
|
DWB_FNL_RDNG |
|
DWR_FINCL_INFO |
|
DWR_FSCL_QTR |
|
DWR_FSCL_YR |
|
DWR_FXBLE_CHTRSTC |
|
Not physicalized |
|
DWB_FLOD_INFO |
|
DWR_FREQNCY_CONVRTR |
|
DWR_FUSE |
|
DWR_GATE_INPUT_PIN |
|
DWR_GEN_UNIT_OP_COST_CRVE |
|
DWR_GEN_UNIT_OP_SCHL |
|
DWL_GNDR |
|
DWR_GNRTNG_UNIT |
|
DWR_GNRTNG_UNIT_ROTTNG_MC_ASGN |
|
DWL_GNRTR_CNTRL_MD_ENUM |
|
DWL_GNRTR_CNTRL_SRC_ENUM |
|
DWL_GNRTR_OPERTNG_MD_ENUM |
|
DWR_GNRC_ACTN |
|
DWR_GEO_BLDG |
|
DWR_GEO_CITY |
|
DWR_GEO_CMPLX |
|
DWR_GEO_CNTRY |
|
DWR_GEO_CNTY |
|
DWR_GEO_DEMOG_GRP |
|
DWR_GEO_DEMOG_ATRIB |
|
DWR_GEO_DEMOG_VAL |
|
DWR_GEO_ENT |
|
DWR_GEO_ENT_ASGN |
|
DWR_GEO_ENT_HRCHY_LVL_ASGN |
|
DWR_GEO_HRCHY |
|
DWR_GEO_HRCHY_LVL |
|
DWR_GEO_HRCHY_LVL_ASGN |
|
DWR_GEO_LVL |
|
DWR_GEO_LVL_ATRIB |
|
DWR_GEO_LVL_ATRIB_VAL |
|
DWR_GEO_RGN |
|
DWR_GEO_STATE |
|
DWR_GEO_STREET |
|
DWR_GEO_SB_RGN |
|
DWR_GEO_WORLD |
|
DWR_GL_ACCT |
|
DWR_GL_ACCT_ASGN |
|
DWR_GL_ACCT_SGMNT |
|
DWL_GL_ACCT_TYP |
|
DWB_GL_BAL |
|
DWR_GL_COST_CNTR_SGMNT |
|
DWB_GL_JE_LN_SBLDGR_ASGN |
|
DWB_GL_JE |
|
DWB_GL_JE_BTCH |
|
DWL_GL_JE_CTGRY |
|
DWB_GL_JE_LN |
|
DWR_GL_LDGR |
|
DWR_GL_LDGR_ACCT_ASGN |
|
DWR_GL_ORG_BSNS_UNIT_SGMNT |
|
DWR_GL_PRD |
|
DWR_GL_PROD_SPECFTN_SGMNT |
|
DWR_GL_PROJ_SGMNT |
|
DWR_GL_SGMNT |
|
DWL_GL_SGMNT_TYP |
|
DWR_GL_SBLDGR |
|
DWB_GL_SBLDGR_JE |
|
DWB_GL_SBLDGR_JE_LN |
|
DWR_GRS_TO_NET_ACTV_POWR_CRVE |
|
DWR_GRND_DSCNCTR |
|
DWR_GRND_SWTCH |
|
DWR_HEAD_END_SYS |
|
DWR_HR |
|
DWR_HR_TIME_OF_USE_ASGN |
|
DWR_HH |
|
DWL_HYDR_ENRG_CNVRSN_KIND_ENUM |
|
DWR_HYDRO_GNRTNG_UNIT |
|
Not physicalized |
|
DWB_INCDNT |
|
DWR_INCDNT_WRK_ASGN |
|
DWR_INDVL_DEMOG_VAL |
|
DWB_INITIAL_RDNG |
|
DWL_INTTV_RSLT_TYP |
|
DWL_INTTV_TYP |
|
DWR_INSTLMNT_AGRMNT |
|
DWB_INTRACN_ANSWR_CHOICE |
|
DWR_INTRACN_CHNL |
|
DWL_INTRACN_DRCTN |
|
DWB_INTRACN_NAVGTN_HIST |
|
DWR_INTRACN_NAVGTN_ITEM |
|
DWL_INTRACN_PRIORITY_TYP |
|
DWB_INTRACN_QUES_RESPN |
|
DWL_INTRACN_RSN |
|
DWL_INTRACN_RSLT_TYP |
|
DWL_INTRACN_STAT |
|
DWB_INTRACN_TRNSFR_HIST |
|
DWL_INTRACN_TRNSFR_RSN |
|
DWL_INTRACN_TYP |
|
DWL_INTRHRMNCS |
|
DWB_INVC |
|
DWB_INVC_ADJ |
|
DWR_INVC_ADJ_QTA |
|
DWL_INVC_DLVRY_FRMT |
|
DWL_INVC_DLVRY_TYP |
|
DWB_INVC_DISC |
|
DWL_INVC_DISC_RSN |
|
DWL_INVC_DISC_TYP |
|
DWB_INVC_ITEM |
|
DWB_INVC_ITEM_DTL |
|
DWL_INVC_ITEM_DTL_TYP |
|
DWB_INVC_ITEM_RLTN |
|
DWL_INVC_ITEM_TYP |
|
DWB_INVC_PYMT_ASGN |
|
DWB_INVC_PYMT_TERM |
|
DWL_INVC_PYMT_TERM_TYP |
|
DWB_INVC_STAT_HIST |
|
DWL_INVC_STAT_TYP |
|
DWB_INVC_TAX_ITEM |
|
DWL_INVC_TYP |
|
DWR_IRGLR_INTRVL_SCHL |
|
DWR_IRGLR_TIME_PNT |
|
DWL_IVR_MENU_ITEM |
|
DWR_JB |
|
DWR_JB_RL |
|
DWR_JNT |
|
DWL_JNT_CNFGRTN_KIND_ENUM |
|
DWL_JNT_FILL_KIND_ENUM |
|
DWB_JE_LN_INVC_ITEM_ASGN |
|
DWR_JMPR |
|
DWR_JMPR_ACTN |
|
DWL_LANG |
|
DWL_LTTR_TYP |
|
DWR_LIFE_CYCL_DT |
|
DWR_LMT |
|
DWR_LMT_SET |
|
DWR_LN |
|
DWR_LD_AREA |
|
DWR_LD_BRK_SWTCH |
|
DWR_LD_GRP |
|
DWR_LD_RESPN_CHTRSTC |
|
DWR_LOC |
|
DWR_LYLTY_PROG |
|
DWL_LYLTY_PROG_EVT_TYP |
|
DWR_MNTNR |
|
DWR_MNFCTR |
|
DWL_MRTL_STAT |
|
DWR_MKT_AREA |
|
DWR_MKT_AREA_LVL |
|
DWR_MKT_PLN_DOC_REQRMNT |
|
DWR_MKT_RL |
|
DWR_MKT_SGMNT |
|
DWR_MKT_SGMNT_INCLSN |
|
DWB_MSRMNT |
|
DWL_MSRMNT_KIND |
|
DWR_MSRMNT_LOC |
|
DWB_MSRMNT_VAL |
|
DWR_MSRMNT_VAL_QLTY |
|
DWR_MSRMNT_VAL_SRC |
|
DWR_MEDIA_OBJ |
|
DWR_MEDIA_OBJ_ASGN |
|
DWL_MEDIA_OBJ_TYP |
|
DWR_MTR |
|
DWR_MTR_IDNT |
|
DWB_MTR_RDNG |
|
DWD_MTR_RDNG_DAY |
|
DWD_MTR_RDNG_HR |
|
DWA_MTR_RDNG_MO |
|
DWA_MTR_RDNG_TOU_MO |
|
DWR_MTR_RGSTER_ASGN |
|
DWR_MTR_SRVC_WRK |
|
DWL_MTR_STAT |
Table 5-2 Entity Mapping Table: Logical to Physical Mapping: N to Z
Entity | Table or View |
---|---|
DWR_NAICS_CLSFCTN |
|
DWL_NTNLTY |
|
DWR_NON_CNFRM_LD |
|
DWR_NON_CNFRM_LD_GRP |
|
DWR_NON_CNFRM_LD_SCHL |
|
DWR_NUCLR_GNRTNG_UNIT |
|
DWR_OPERTNG_PRTCPNT |
|
DWR_OPERTNG_SHR |
|
DWR_OPRN_TAG |
|
DWR_OPRTNL_LMT |
|
DWR_OPRTNL_LMT_SET |
|
DWR_OPRTNL_RSTRCT |
|
DWR_ORCL_GMTRY |
|
DWR_ORG_AREA |
|
DWR_ORG_BNR |
|
DWR_ORG_BSNS_ENT |
|
DWR_ORG_BSNS_UNIT |
|
DWL_ORG_BSNS_UNIT_TYP |
|
DWR_ORG_CHAIN |
|
DWR_ORG_CMPNY |
|
DWR_ORG_CRPRT |
|
DWR_ORG_DSTRCT |
|
DWR_ORG_HRCHY |
|
DWR_ORG_HRCHY_LVL |
|
DWR_ORG_HRCHY_LVL_ASGN |
|
DWR_ORG_HRCHY_VRSN |
|
DWR_ORG_LVL |
|
DWR_ORG_LVL_ATRIB_VAL |
|
DWR_ORG_LVL_ATTR |
|
DWR_ORG_MKT_DATA |
|
DWR_ORG_RGN |
|
DWR_ORG_RL |
|
DWR_ORG_SRVC_WBSITE |
|
DWR_ORG_WRHS |
|
DWR_ORG_DEMOG_VAL |
|
DWR_OTHR_INDVL |
|
DWB_OUTG |
|
DWD_OUTG_DAY |
|
DWA_OUTG_MO |
|
DWD_OUTG_USG_PNT |
|
DWR_OUTG_CD |
|
DWR_OUTG_NOTFCTN |
|
DWR_OUTG_PLN |
|
DWB_OUTG_REC |
|
DWR_OUTG_REC_CD_ASGN |
|
DWR_OUTG_RPT |
|
DWR_OUTG_SCHL |
|
DWR_OUTG_STEP |
|
DWR_OUTG_STEP_CD_ASGN |
|
DWR_OUTG_USG_PNT_ASGN |
|
DWR_PRTNR_PRMTN_PROG |
|
DWR_PRTY |
|
DWR_PRTY_ACCT_ASGN |
|
DWL_PRTY_ACCT_ASGN_TYP |
|
DWR_PRTY_ADDR_LOC_ASGN |
|
DWR_PRTY_AGRMNT_RLTN |
|
DWR_PRTY_ASGN |
|
DWL_PRTY_ASGN_RSN |
|
DWL_PRTY_ASGN_TYP |
|
DWR_PRTY_BSNS_INTRACN_RL |
|
DWR_PRTY_CNCT_INFO |
|
DWL_PRTY_CNCT_INFO_TYP |
|
DWL_PRTY_CNCT_LST_PRTCPTN |
|
DWL_PRTY_CNCT_LST_RL |
|
DWB_PRTY_COST_ASGN |
|
Not physicalized |
|
DWL_PRTY_EVT_TYP |
|
DWR_PRTY_GEO_ENT_ASGN |
|
DWB_PRTY_INTRACN_THRD |
|
DWB_PRTY_INTRCN_THRD_SBRP_ASGN |
|
DWL_PRTY_INTRACN_THRD_TYP |
|
Not physicalized |
|
DWL_PRTY_LOC_RSN |
|
DWL_PRTY_LOC_TYP |
|
DWL_PRTY_MGMT_RL |
|
DWR_PRTY_MKT_SGMNT_ASGN |
|
DWR_PRTY_PROJ_PRTCPTN |
|
DWB_PRTY_PRMTN_RESPN |
|
DWL_PRTY_RL |
|
DWR_PRTY_RL_ASGN |
|
DWR_PRTY_RL_STAT |
|
DWL_PRTY_STAT_CTGRY |
|
DWL_PRTY_STAT_CHNG_RSN |
|
DWB_PRTY_STAT_HIST |
|
DWL_PRTY_STAT_TYP |
|
DWL_PRTY_TYP |
|
DWL_PYMT_AGNG_CLASS |
|
DWR_PYMT_CHNL |
|
DWL_PYMT_MTHD_TYP |
|
DWL_PYMT_TRX_TYP |
|
DWR_PER_LGTH_IMPNDNC |
|
DWR_PER_LGTH_PHS_IMPNDNC |
|
DWR_PER_LGTH_SEQ_IMPNDNC |
|
DWL_PHS |
|
DWL_PHS_CD_ENUM |
|
DWR_PHS_CNCTD_FLT |
|
DWL_PHS_CNCTD_FLT_KIND_ENUM |
|
DWR_PHS_IMPNDNC_DATA |
|
DWL_PHS_SHNT_CNCTN_KIND_ENUM |
|
DWR_PHS_TAP_CHNG |
|
DWR_PHS_TAP_CHNG_ASYMTRCL |
|
DWR_PHS_TAP_CHNG_LNR |
|
DWR_PHS_TAP_CHNG_NON_LNR |
|
DWR_PHS_TAP_CHNG_SYMTRCL |
|
DWR_PHS_TAP_CHNG_TBLR |
|
DWR_PHS_TAP_CHNG_TBLR_PNT |
|
DWR_PIN_VLTG |
|
DWR_PLND_OUTG |
|
DWL_PLND_OUTG_KIND_ENUM |
|
DWR_POLE |
|
DWL_POLE_BASE_KIND_ENUM |
|
DWL_POLE_PRSRVTV_KIND_ENUM |
|
DWL_POLE_TRTMNT_KIND_ENUM |
|
DWL_POSTL_SRVC_TYP |
|
DWR_POSTCD |
|
DWR_PTNTL_TRNSFRMR_INFO |
|
DWR_POWR_CUT_ZN |
|
Not physicalized |
|
DWR_POWR_SYS_RESRE_LOC |
|
DWR_POWR_TRNSFRMR |
|
DWR_POWR_TRNSFRMR_END |
|
DWR_POWR_TRNSFRMR_INFO |
|
DWB_PPTN |
|
DWB_PRICE_EVT |
|
DWL_PRICE_TYP |
|
DWR_PRCNG_STRUCTR |
|
DWR_PRCNG_STRCTR_TRF_ASGN |
|
DWR_PRIORITY |
|
DWR_PROC |
|
DWR_PROC_ASST_ASGN |
|
DWL_PROC_KIND_ENUM |
|
DWR_PROD_ASST_MDL |
|
DWR_PROD_ASST_MDL_FNCTN_ASGN |
|
DWR_PROD_OFRNG |
|
DWR_PROD_SBRP |
|
DWR_PROJ |
|
DWR_PROJ_ELMNT |
|
DWR_PRMTN |
|
DWB_PRMTN_CLSTR_USG |
|
DWB_PRMTN_CNCT_LST_UTLZTN |
|
DWB_PRMTN_MGMT_HIST |
|
DWR_PRMTN_MSG_RNDRNG |
|
DWR_PRMTN_PROD_OFRNG_ASGN |
|
DWR_PRMTN_RLTN |
|
DWL_PRMTN_RSLT_TYP |
|
DWR_PRMTN_SL_CHNL_ASGN |
|
DWL_PRMTN_TERM_TYP |
|
DWL_PRMTN_TERM_VAL |
|
DWL_PRMTN_TYP |
|
DWR_PRPSL |
|
DWR_PRPSL_RLTN |
|
DWR_PRSPCT |
|
DWL_PRSPCT_PRIORITY_TYP |
|
DWL_PRSPCT_QLTY_SCR_TYP |
|
DWR_PRSPCT_QLTY_SCR_VAL |
|
DWL_PRSPCT_REJECT_RSN |
|
DWR_PRTCTD_SWTCH |
|
DWR_PROTCTN_EQPMNT |
|
DWR_PROTCTN_EQPMNT_INFO |
|
DWL_PSR_TYP |
|
DWR_PBLCTN |
|
DWL_PBLCTN_TYP |
|
DWB_PCHSE_ORDR |
|
DWB_PCHSE_ORDR_LI |
|
Not physicalized |
|
DWR_RATE |
|
DWR_RATIO_TAP_CHNG |
|
DWR_RATIO_TAP_CHNG_TBLR |
|
DWR_RATIO_TAP_CHNG_TBLR_PNT |
|
DWR_RTNL_NBR |
|
DWL_RDNG_ACMLTN_BHVR |
|
DWR_RDNG_CHNL |
|
DWR_RDNG_CHNL_IDNT |
|
DWL_RDNG_DATA_QLFR |
|
DWB_RDNG_QLTY |
|
DWL_RDNG_QLTY_TYP |
|
DWL_RDNG_QLTY_TYP_CTGRY |
|
DWL_RDNG_QLTY_TYP_ORIGIN |
|
DWL_RDNG_QLTY_TYP_SB_CTGRY |
|
DWL_RDNG_RSN_KIND_ENUM |
|
DWL_RDNG_TIME_ATRIB |
|
DWL_RDNG_TIME_PRD |
|
DWR_RDNG_TYP |
|
DWR_RCLSR |
|
DWR_RGSTER |
|
DWR_RGLR_INTRVL_SCHL |
|
DWR_RGLR_TIME_PNT |
|
DWR_RGLTNG_COND_EQ |
|
DWR_RGLTNG_CNTRL |
|
DWL_RGLTNG_CNTRL_MD_KIND_ENUM |
|
DWR_REGULTN_SCHL |
|
DWD_RLBLTY_IND_CITY_MO |
|
DWD_RLBLTY_IND_FEDR_MO |
|
DWR_RMT_CONCT_DSCNCT_INFO |
|
DWR_RMT_CNTRL |
|
DWR_RMT_PNT |
|
DWR_RMT_SRC |
|
DWR_RMT_UNIT |
|
DWR_RMT_UNIT_COMUNCTN_LNK_ASGN |
|
DWL_RMT_UNIT_TYP_ENUM |
|
DWB_RESRE_ORDR |
|
DWB_RESRE_ORDR_ITEM |
|
DWL_RVN_KIND_ENUM |
|
DWR_ROTTNG_MC |
|
DWR_SFTY_DOC |
|
DWR_SL_CHNL |
|
Not physicalized |
|
DWB_SCHL_EVT |
|
DWR_SCHL_EVT_ASST_ASGN |
|
DWR_SCRPT |
|
DWR_SCRPT_QUES |
|
DWB_SEA_CNDTN |
|
DWR_SEAL |
|
DWL_SEAL_CNDTN_KIND_ENUM |
|
DWL_SEAL_KIND_ENUM |
|
DWL_SEASON |
|
DWR_SEASON_DAY_TYP_SCHL |
|
DWR_SECTNR |
|
DWR_SGMNT_CRTRA |
|
DWL_SGMNT_TYP |
|
DWR_SERIES_CMPNSTR |
|
DWR_SRVC |
|
DWL_SRVC_CTGRY |
|
DWR_SRVC_COVRG_AREA |
|
DWR_SRVC_COVRG_GEO_DTL |
|
DWR_SRVC_LOC |
|
DWR_SRVC_LOC_IDNT |
|
DWB_SRVC_ORDR |
|
DWB_SRVC_ORDR_LI |
|
DWR_SRVC_QTY |
|
DWR_SRVC_SPPLR |
|
DWL_SRVC_TYP |
|
DWB_SET_PNT |
|
DWL_SHORT_CRCUT_RTR_KIND_ENUM |
|
DWR_SHNT_CMPNSTR |
|
DWR_SHNT_CMPNSTR_INFO |
|
DWR_SHNT_CMPNSTR_PHS |
|
DWR_SIC_ASGN |
|
DWL_SIC_ASGN_RSN |
|
DWL_SIC_CLSFCTN |
|
DWR_SMPL_END_DVC_FNCTN |
|
DWL_SNGL_PHS_KIND_ENUM |
|
DWR_SOC_JB |
|
DWR_SOC_JB_CTGRY |
|
DWR_SOC_JB_GRP |
|
DWL_SRC_ENUM |
|
DWR_SRC_SYS |
|
DWR_SRC_SYS_KEY_MAP |
|
DWL_SRC_SYS_TYP |
|
DWB_SPOT_TEMP |
|
DWR_STATIC_VAR_CMPNSTR |
|
DWR_STN_SPPLY |
|
DWR_STAT |
|
DWR_STEAM_SNDOUT_SCHL |
|
DWR_STREETLGHT |
|
DWL_STREETLGHT_LAMP_KIND_ENUM |
|
DWB_STRNG_MSRMNT |
|
DWB_STRNG_MSRMNT_VAL |
|
DWR_STRCTR |
|
DWL_STRCTR_MTRL_KIND_ENUM |
|
DWR_STRCTR_SPPRT |
|
DWL_STRCTR_SPPRT_KIND_ENUM |
|
DWR_SB_GEOCL_RGN |
|
DWR_SB_LD_AREA |
|
DWR_SBSTN |
|
DWR_SRG_ARSTR_INFO |
|
DWR_SURVEY |
|
DWL_SVC_CNTRL_MD_ENUM |
|
DWR_SWTCH |
|
DWR_SWTCH_ACTN |
|
DWL_SWTCH_ACTN_KIND_ENUM |
|
DWR_SWTCH_CNCT_DSCNCT_FNC_ASGN |
|
DWR_SWTCH_INFO |
|
DWR_SWTCH_PHS |
|
DWR_SWTCH_SCHL |
|
DWL_SWTCH_STATE_ENUM |
|
DWR_SWTCH_SWTCHNG_OPRN_ASGN |
|
DWR_SWTCHNG_ACTVTY |
|
DWR_SWTCH_ACTVTY_SFTY_DOC_ASGN |
|
DWR_SWTCHNG_OPRN |
|
DWR_SWTCHNG_PLN |
|
DWR_SWTCHNG_STEP |
|
DWR_SWTCHNG_STEP_GRP |
|
DWR_SYNCHRCHCK_RLY |
|
DWR_SYNCHRNS_MC |
|
DWL_SYNCHRNS_MC_KIND_ENUM |
|
DWL_SNCHRNS_MC_OPERTNG_MD_ENUM |
|
DWR_TAG_ACTN |
|
DWL_TAG_ACTN_KIND_ENUM |
|
DWR_TAP_CHNG |
|
DWR_TAP_CHNG_CNTRL |
|
DWR_TAP_CHNG_INFO |
|
DWR_TAP_SCHL |
|
DWR_TRGT_ACCT |
|
DWR_TRGT_AGRMNT |
|
DWR_TRGT_GEO_AREA |
|
DWR_TRGT_MKT_SGMNT |
|
DWL_TRGT_TYP |
|
DWR_TRF |
|
DWR_TRF_PRFL |
|
DWR_TRF_TRF_PRFL_ASGN |
|
DWR_TASK |
|
DWL_TAX_AUTH |
|
DWL_TAX_CTGRY |
|
DWR_TRML |
|
DWR_THRML_GNRTNG_UNIT |
|
DWL_TIME_OF_USE |
|
DWR_TIME_SCHL |
|
DWR_TIME_SLT |
|
DWR_TIME_TRF_INTRVL |
|
DWR_TOOL |
|
DWR_TPLGCL_ND |
|
DWR_TWR |
|
DWL_TWR_CONSTRCTN_KIND_ENUM |
|
DWL_TRNSFRMR_CNTRL_MD_ENUM |
|
DWR_TRNSFRMR_CORE_ADMTTNC |
|
DWR_TRNSFRMR_END |
|
DWR_TRNSFRMR_END_INFO |
|
DWR_TRNSFRMR_FEDR_ASGN |
|
DWR_TRNSFRMR_MESH_IMPNDNC |
|
DWR_TRNSFRMR_STAR_IMPNDNC |
|
DWR_TRNSFRMR_TANK |
|
DWR_TRNSFRMR_TANK_END |
|
DWR_TRNSFRMR_TANK_INFO |
|
DWL_TRBL_RPT_KIND_ENUM |
|
DWR_TRBL_TCKT |
|
DWR_UNDRGRND_STRCTR |
|
DWL_UNDRGRND_STRCTR_KIND_ENUM |
|
DWL_UNIT_MLTPLR |
|
DWL_UNIT_MLTPLR_ENUM |
|
DWL_UOM |
|
DWL_UNIT_SYMBL_ENUM |
|
DWR_USG_PNT |
|
DWL_USG_PNT_CNCTD_KIND_ENUM |
|
DWR_USG_PNT_END_DVC_CTRL_ASGN |
|
DWR_USG_PNT_EQPMNT_ASGN |
|
DWR_USG_PNT_GRP |
|
DWR_USG_PNT_GRP_ASGN |
|
DWR_USG_PNT_GRP_DR_PROG_ASGN |
|
DWR_USG_PNT_LOC |
|
DWR_USG_PNT_TRNSFRMR_ASGN |
|
DWR_USG_PT_GP_END_DVC_CTL_ASGN |
|
DWR_USG_READ_CYCL |
|
DWL_UTLTY_CMDTY |
|
DWL_VLDTY_ENUM |
|
DWR_VAL_ALS_SET |
|
DWR_VAL_TO_ALS |
|
DWL_VAL_TYP |
|
DWB_VEE_EXPTN |
|
DWL_VEE_EXPTN_TYP |
|
DWL_VEE_GRP |
|
DWL_VEE_RULE |
|
DWR_VHCL |
|
DWR_VNDR |
|
DWR_VNDR_ITEM |
|
DWR_VRTL_TEAM |
|
DWR_VLTG_CNTRL_ZN |
|
DWR_VLTG_LMT |
|
DWL_WEATHR_ALRT |
|
DWL_WEATHR_FRCST |
|
DWL_WEATHR_INFO |
|
DWL_WEATHR_LOC |
|
DWR_WEB_PG |
|
DWL_WND_GEN_UNIT_KIND_ENUM |
|
DWR_WND_GNRTNG_UNIT |
|
DWB_WND_INFO |
|
DWL_WNDNG_CNCTN_ENUM |
|
DWR_WR_INFO |
|
DWL_WR_INSLTN_KIND_ENUM |
|
DWL_WR_MTRL_KIND_ENUM |
|
DWR_WR_SPCNG_INFO |
|
DWL_WR_USG_KIND_ENUM |
|
DWR_WRK_ASST |
|
DWR_WRK_BLLG_INFO |
|
DWR_WRK_COST_DTL |
|
DWB_WRK_COST_SUMM |
|
Not physicalized |
|
DWR_WRK_FLOW_STEP |
|
Not physicalized |
|
DWL_WRK_KIND_ENUM |
|
DWR_WRK_LOC |
|
DWR_WRK_ORDR |
|
DWR_WRK_STAT_ENTRY |
|
DWL_WRK_STAT_KIND_ENUM |
|
DWR_WRK_TASK |
|
DWR_WRK_TASK_AS_SET_ASGN |
|
DWL_WRK_TASK_KIND_ENUM |
|
DWR_WRK_TIME_SCHL |
|
DWL_WRK_TIME_SCHL_KIND_ENUM |
|
DWR_ZN |
|
DWL_ZN_KIND_ENUM |