This chapter provides information about the physical data model of Oracle Utilities Data Model.
This chapter includes the following sections:
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.
The Physical data model includes the following:
Important:
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-3 briefly describes the Reference tables in Oracle Utilities Data Model.
Table Name | More Information |
---|---|
DWR_AC_LN_SGMNT |
|
DWR_AC_LN_SGMNT_PHS |
|
DWR_ACCMLTR_LMT |
|
DWR_ACCMLTR_LMT_SET |
|
DWR_ACCMLTR_LMT_SET_ASGN |
|
DWR_ACCT |
|
DWR_ACCT_AGRMNT_RLTN |
|
DWR_ACCT_ASGN |
|
DWR_ACCT_BAL_GRP |
|
DWR_ACCT_BLLG_CYCL_HIST |
|
DWR_ACCT_BLLG_FREQNCY_HIST |
|
DWR_ACCT_BLLG_PRD_HIST |
|
DWR_ACCT_BSNS_INTRACN_RL |
|
DWR_ACCT_CYCL |
|
DWR_ACCT_PREF_INVC_DLVRY |
|
DWR_ACCT_PREF_PYMT_MTHD |
|
DWR_ACCT_PRFL |
|
DWR_ACCT_SGMNT |
|
DWR_ACCT_SGMNT_ASGN_HIST |
|
DWR_ACCT_SGMNT_MDL |
|
DWR_ACPT_TEST |
|
DWR_ACTV_POWR_LMT |
|
DWR_ADDR_LOC |
|
DWR_AGRMNT |
|
DWR_AGRMNT_DOC |
|
DWR_AGRMNT_ITEM |
|
DWR_AGRMNT_ITEM_PRCNG_STRUCT_ASGN |
|
DWR_AGRMNT_USG_PNT_ASGN |
|
DWR_AIR_CMPRSR |
|
DWR_ANLG_LMT |
|
DWR_ANLG_LMT_SET |
|
DWR_ANLG_LMT_SET_ASGN |
|
DWR_ANZSC_CLSFCTN |
|
DWR_APRNT_POWR_LMT |
|
DWR_ASST |
|
DWR_ASST_ACTVTY_REC_ASGN |
|
DWR_ASST_FNCTN |
|
DWR_ASST_INFO |
|
DWR_ASST_LOC |
|
DWR_ASST_MDL |
|
DWR_ASST_MDL_CTLG |
|
DWR_ASST_MDL_CTLG_ITEM |
|
DWR_ASST_ORG_RL |
|
DWR_ASST_ORG_RL_ASGN |
|
DWR_ASST_OWNR |
|
DWR_ASST_PSR_ASGN |
|
DWR_ASST_STAT |
|
DWR_ASST_USER |
|
DWR_BASE_VLTG |
|
DWR_BLLG_CYCL |
|
DWR_BLLG_FREQNCY |
|
DWR_BNK |
|
DWR_BNK_DRCT_DEBT_CHNL |
|
DWR_BRKR |
|
DWR_BSBR_SECTN |
|
DWR_BSBR_SECTN_INFO |
|
DWR_BSHNG |
|
DWR_BSNS_CASE |
|
DWR_BSNS_HLF_MO |
|
DWR_BSNS_HLF_YR |
|
DWR_BSNS_INTRACN_ASGN |
|
DWR_BSNS_INTRACN_LOC_ASGN |
|
DWR_BSNS_INTRACN_VRSN |
|
DWR_BSNS_MO |
|
DWR_BSNS_QTR |
|
DWR_BSNS_UNIT_JB_RL |
|
DWR_BSNS_WK |
|
DWR_BSNS_YR |
|
DWR_CAES_PLNT |
|
DWR_CALL_CNTR |
|
DWR_CALL_CNTR_AGNT |
|
DWR_CALL_CNTR_SRVC_CAPBLTY |
|
DWR_CGNRTN_PLNT |
|
DWR_CHNL |
|
DWR_CLMP |
|
DWR_CLNDR_HLF_MO |
|
DWR_CLNDR_HLF_YR |
|
DWR_CLNDR_MO |
|
DWR_CLNDR_QTR |
|
DWR_CLNDR_WK |
|
DWR_CLNDR_YR |
|
DWR_CLRNCE_ACTN |
|
DWR_CLRNCE_DOC |
|
DWR_CMBND_CYCL_PLNT |
|
DWR_CMPGN |
|
DWR_CMPGN_CHNL |
|
DWR_CMPGN_CHNL_ASGN |
|
DWR_CMPGN_CHTRSTC |
|
DWR_CMPGN_CHTRSTC_VAL |
|
DWR_CMPGN_DOC |
|
DWR_CMPGN_MGMT_HIST |
|
DWR_CMPGN_MSG |
|
DWR_CMPGN_MSG_DPCT |
|
DWR_CMPGN_RLTN |
|
DWR_CMPGN_TERM_VAL |
|
DWR_CMPST_SWTCH_INFO |
|
DWR_CMPTBL_UNIT |
|
DWR_CMPTBL_UNIT_PROC_ASGN |
|
DWR_CNCT_LST |
|
DWR_CNCTR |
|
DWR_CNDCTR |
|
DWR_CNDTNG_EQP_PRTCTN_EQP_ASGN |
|
DWR_CNFRM_LD |
|
DWR_CNFRM_LD_GRP |
|
DWR_CNFRM_LD_SCHL |
|
DWR_CNSMPTN_TIER |
|
DWR_CNSMPTN_TRF_INTRVL |
|
DWR_COLLCTN_AGNCY |
|
DWR_COMUNICTN_FNCTN |
|
DWR_COMUNICTN_LNK |
|
DWR_COMUNICTN_MEDIA |
|
DWR_COMUNICTN_MODULE |
|
DWR_CONCT_DSCNCT_FNCTN |
|
DWR_CONCTVT_ND |
|
DWR_CONCTVT_ND_CONTNR |
|
DWR_COST_CNTR |
|
DWR_CRDT_CTGRY |
|
DWR_CRDT_SCR_PRVDR |
|
DWR_CREW |
|
DWR_CREW_MBR |
|
DWR_CREW_TYP |
|
DWR_CREW_WRK_TASK_ASGN |
|
DWR_CRNCY_GEO_ENT_ASGN |
|
DWR_CRTCL_PK_PRD |
|
DWR_CRVE |
|
DWR_CURR_LMT |
|
DWR_CURR_RLY |
|
DWR_CURR_TRNSFRMR_INFO |
|
DWR_CUST |
|
DWR_CUST_ACCT_ASGN |
|
DWR_CUST_DOC |
|
DWR_CUST_FCNG_SRVC |
|
DWR_CUST_GRP_ASGN |
|
DWR_CUST_INDVL |
|
DWR_CUST_OCCSN |
|
DWR_CUST_ORDR_DOC |
|
DWR_CUST_ORG |
|
DWR_CUST_OUTG_NOTFCTN_ASGN |
|
DWR_CUST_RSTRCT_INFO |
|
DWR_CUST_RVN_BND_ASGN |
|
DWR_CUST_SCR |
|
DWR_CUST_SGMNT |
|
DWR_CUST_SGMNT_MDL |
|
DWR_CUST_SIC_ASGN |
|
DWR_CUST_SRC |
|
DWR_CUST_WRK_ASGN |
|
DWR_CUT |
|
DWR_CUT_ACTN |
|
DWR_DAY |
|
DWR_DC_CNDCTNG_EQPMNT |
|
DWR_DC_LN_SGMNT |
|
DWR_DEMAND_RESPN_PROG |
|
DWR_DEMAND_TRF_INTRVL |
|
DWR_DEMOG_ATRIB |
|
DWR_DEMOG_CHTRSTC |
|
DWR_DEMOG_GRP |
|
DWR_DOC_TYP_GRP_ASGN |
|
DWR_DR_PROG_AGRMNT_ASGN |
|
DWR_DR_PROG_END_DVC_GRP_ASGN |
|
DWR_DRVD_VAL |
|
DWR_DSCNCTR |
|
DWR_ELCTRCTY_SRVC |
|
DWR_EMP |
|
DWR_EMP_JB_RL_ASGN |
|
DWR_EMP_LANG_CAPBLTY |
|
DWR_EMP_RSTRCT_INFO |
|
DWR_EMP_SCHL |
|
DWR_END_DVC |
|
DWR_END_DVC_CAPBLTY |
|
DWR_END_DVC_CNTRL_TYP |
|
DWR_END_DVC_END_DVC_CTRL_ASGN |
|
DWR_END_DVC_END_DVC_GRP_ASGN |
|
DWR_END_DVC_EVT_DTL |
|
DWR_END_DVC_FNCTN |
|
DWR_END_DVC_GP_END_DVC_CTL_ASN |
|
DWR_END_DVC_GRP |
|
DWR_END_DVC_INFO |
|
DWR_ENRGY_AREA |
|
DWR_ENRGY_CONSMR |
|
DWR_ENRGY_CONSMR_PHS |
|
DWR_EQPMNT_CONTNR |
|
DWR_EXTRNL_CRDT_PRFL |
|
DWR_EXTRNL_CRDT_PRFL_ASGN |
|
DWR_EXTRNL_INFO_SRC |
|
DWR_FCT_DVC |
|
DWR_FEDR |
|
DWR_FEDR_SBSTN_ASGN |
|
DWR_FINCL_INFO |
|
DWR_FLT |
|
DWR_FLT_IND_INFO |
|
DWR_FREQNCY_CONVRTR |
|
DWR_FSCL_QTR |
|
DWR_FSCL_YR |
|
DWR_FUSE |
|
DWR_FXBLE_CHTRSTC |
|
DWR_GATE_INPUT_PIN |
|
DWR_GEN_UNIT_OP_COST_CRVE |
|
DWR_GEN_UNIT_OP_SCHL |
|
DWR_GEO_BLDG |
|
DWR_GEO_CITY |
|
DWR_GEO_CMPLX |
|
DWR_GEO_CNTRY |
|
DWR_GEO_CNTY |
|
DWR_GEO_DEMOG_ATRIB |
|
DWR_GEO_DEMOG_GRP |
|
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_SB_RGN |
|
DWR_GEO_STATE |
|
DWR_GEO_STREET |
|
DWR_GEO_WORLD |
|
DWR_GL_ACCT |
|
DWR_GL_ACCT_ASGN |
|
DWR_GL_ACCT_SGMNT |
|
DWR_GL_COST_CNTR_SGMNT |
|
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_SBLDGR |
|
DWR_GL_SGMNT |
|
DWR_GNRC_ACTN |
|
DWR_GNRTNG_UNIT |
|
DWR_GNRTNG_UNIT_ROTTNG_MC_ASGN |
|
DWR_GRND_DSCNCTR |
|
DWR_GRND_SWTCH |
|
DWR_GRS_TO_NET_ACTV_POWR_CRVE |
|
DWR_HEAD_END_SYS |
|
DWR_HH |
|
DWR_HR |
|
DWR_HR_TIME_OF_USE_ASGN |
|
DWR_HYDRO_GNRTNG_UNIT |
|
DWR_INCDNT_WRK_ASGN |
|
DWR_INDVL_DEMOG_VAL |
|
DWR_INSTLMNT_AGRMNT |
|
DWR_INTRACN_CHNL |
|
DWR_INTRACN_NAVGTN_ITEM |
|
DWR_INVC_ADJ_QTA |
|
DWR_IRGLR_INTRVL_SCHL |
|
DWR_IRGLR_TIME_PNT |
|
DWR_JB |
|
DWR_JB_RL |
|
DWR_JMPR |
|
DWR_JMPR_ACTN |
|
DWR_JNT |
|
DWR_LD_AREA |
|
DWR_LD_BRK_SWTCH |
|
DWR_LD_GRP |
|
DWR_LD_RESPN_CHTRSTC |
|
DWR_LIFE_CYCL_DT |
|
DWR_LMT |
|
DWR_LMT_SET |
|
DWR_LN |
|
DWR_LOC |
|
DWR_LYLTY_PROG |
|
DWR_MEDIA_OBJ |
|
DWR_MEDIA_OBJ_ASGN |
|
DWR_MKT_AREA |
|
DWR_MKT_AREA_LVL |
|
DWR_MKT_PLN_DOC_REQRMNT |
|
DWR_MKT_RL |
|
DWR_MKT_SGMNT |
|
DWR_MKT_SGMNT_INCLSN |
|
DWR_MNFCTR |
|
DWR_MNTNR |
|
DWR_MSRMNT_LOC |
|
DWR_MSRMNT_VAL_QLTY |
|
DWR_MSRMNT_VAL_SRC |
|
DWR_MTR |
|
DWR_MTR_IDNT |
|
DWR_MTR_RGSTER_ASGN |
|
DWR_MTR_SRVC_WRK |
|
DWR_NAICS_CLSFCTN |
|
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 |
|
DWR_ORG_CHAIN |
|
DWR_ORG_CMPNY |
|
DWR_ORG_CRPRT |
|
DWR_ORG_DEMOG_VAL |
|
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_OTHR_INDVL |
|
DWR_OUTG_CD |
|
DWR_OUTG_NOTFCTN |
|
DWR_OUTG_PLN |
|
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_PBLCTN |
|
DWR_PER_LGTH_IMPNDNC |
|
DWR_PER_LGTH_PHS_IMPNDNC |
|
DWR_PER_LGTH_SEQ_IMPNDNC |
|
DWR_PHS_CNCTD_FLT |
|
DWR_PHS_IMPNDNC_DATA |
|
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 |
|
DWR_POLE |
|
DWR_POSTCD |
|
DWR_POWR_CUT_ZN |
|
DWR_POWR_SYS_RESRE_LOC |
|
DWR_POWR_TRNSFRMR |
|
DWR_POWR_TRNSFRMR_END |
|
DWR_POWR_TRNSFRMR_INFO |
|
DWR_PRCNG_STRCTR_TRF_ASGN |
|
DWR_PRCNG_STRUCTR |
|
DWR_PRIORITY |
|
DWR_PRMTN |
|
DWR_PRMTN_MSG_RNDRNG |
|
DWR_PRMTN_PROD_OFRNG_ASGN |
|
DWR_PRMTN_RLTN |
|
DWR_PRMTN_SL_CHNL_ASGN |
|
DWR_PROC |
|
DWR_PROC_ASST_ASGN |
|
DWR_PROD_ASST_MDL |
|
DWR_PROD_ASST_MDL_FNCTN_ASGN |
|
DWR_PROD_OFRNG |
|
DWR_PROD_SBRP |
|
DWR_PROJ |
|
DWR_PROJ_ELMNT |
|
DWR_PROTCTN_EQPMNT |
|
DWR_PROTCTN_EQPMNT_INFO |
|
DWR_PRPSL |
|
DWR_PRPSL_RLTN |
|
DWR_PRSPCT |
|
DWR_PRSPCT_QLTY_SCR_VAL |
|
DWR_PRTCTD_SWTCH |
|
DWR_PRTNR_PRMTN_PROG |
|
DWR_PRTY |
|
DWR_PRTY_ACCT_ASGN |
|
DWR_PRTY_ADDR_LOC_ASGN |
|
DWR_PRTY_AGRMNT_RLTN |
|
DWR_PRTY_ASGN |
|
DWR_PRTY_BSNS_INTRACN_RL |
|
DWR_PRTY_CNCT_INFO |
|
DWR_PRTY_GEO_ENT_ASGN |
|
DWR_PRTY_MKT_SGMNT_ASGN |
|
DWR_PRTY_PROJ_PRTCPTN |
|
DWR_PRTY_RL_ASGN |
|
DWR_PRTY_RL_STAT |
|
DWR_PTNTL_TRNSFRMR_INFO |
|
DWR_PYMT_CHNL |
|
DWR_RATE |
|
DWR_RATIO_TAP_CHNG |
|
DWR_RATIO_TAP_CHNG_TBLR |
|
DWR_RATIO_TAP_CHNG_TBLR_PNT |
|
DWR_RCLSR |
|
DWR_RDNG_CHNL |
|
DWR_RDNG_CHNL_IDNT |
|
DWR_RDNG_TYP |
|
DWR_REGULTN_SCHL |
|
DWR_RGLR_INTRVL_SCHL |
|
DWR_RGLR_TIME_PNT |
|
DWR_RGLTNG_CNTRL |
|
DWR_RGLTNG_COND_EQ |
|
DWR_RGSTER |
|
DWR_RMT_CNTRL |
|
DWR_RMT_CONCT_DSCNCT_INFO |
|
DWR_RMT_PNT |
|
DWR_RMT_SRC |
|
DWR_RMT_UNIT |
|
DWR_RMT_UNIT_COMUNCTN_LNK_ASGN |
|
DWR_ROTTNG_MC |
|
DWR_RTNL_NBR |
|
DWR_SB_GEOCL_RGN |
|
DWR_SB_LD_AREA |
|
DWR_SBSTN |
|
DWR_SCHL_EVT_ASST_ASGN |
|
DWR_SCRPT |
|
DWR_SCRPT_QUES |
|
DWR_SEAL |
|
DWR_SEASON_DAY_TYP_SCHL |
|
DWR_SECTNR |
|
DWR_SERIES_CMPNSTR |
|
DWR_SFTY_DOC |
|
DWR_SGMNT_CRTRA |
|
DWR_SHNT_CMPNSTR |
|
DWR_SHNT_CMPNSTR_INFO |
|
DWR_SHNT_CMPNSTR_PHS |
|
DWR_SIC_ASGN |
|
DWR_SL_CHNL |
|
DWR_SMPL_END_DVC_FNCTN |
|
DWR_SOC_JB |
|
DWR_SOC_JB_CTGRY |
|
DWR_SOC_JB_GRP |
|
DWR_SRC_SYS |
|
DWR_SRC_SYS_KEY_MAP |
|
DWR_SRG_ARSTR_INFO |
|
DWR_SRVC |
|
DWR_SRVC_COVRG_AREA |
|
DWR_SRVC_COVRG_GEO_DTL |
|
DWR_SRVC_LOC |
|
DWR_SRVC_LOC_IDNT |
|
DWR_SRVC_QTY |
|
DWR_SRVC_SPPLR |
|
DWR_STAT |
|
DWR_STATIC_VAR_CMPNSTR |
|
DWR_STEAM_SNDOUT_SCHL |
|
DWR_STN_SPPLY |
|
DWR_STRCTR |
|
DWR_STRCTR_SPPRT |
|
DWR_STREETLGHT |
|
DWR_SURVEY |
|
DWR_SWTCH |
|
DWR_SWTCH_ACTN |
|
DWR_SWTCH_ACTVTY_SFTY_DOC_ASGN |
|
DWR_SWTCH_CNCT_DSCNCT_FNC_ASGN |
|
DWR_SWTCH_INFO |
|
DWR_SWTCH_PHS |
|
DWR_SWTCH_SCHL |
|
DWR_SWTCH_SWTCHNG_OPRN_ASGN |
|
DWR_SWTCHNG_ACTVTY |
|
DWR_SWTCHNG_OPRN |
|
DWR_SWTCHNG_PLN |
|
DWR_SWTCHNG_STEP |
|
DWR_SWTCHNG_STEP_GRP |
|
DWR_SYNCHRCHCK_RLY |
|
DWR_SYNCHRNS_MC |
|
DWR_TAG_ACTN |
|
DWR_TAP_CHNG |
|
DWR_TAP_CHNG_CNTRL |
|
DWR_TAP_CHNG_INFO |
|
DWR_TAP_SCHL |
|
DWR_TASK |
|
DWR_THRML_GNRTNG_UNIT |
|
DWR_TIME_SCHL |
|
DWR_TIME_SLT |
|
DWR_TIME_TRF_INTRVL |
|
DWR_TOOL |
|
DWR_TPLGCL_ND |
|
DWR_TRBL_TCKT |
|
DWR_TRF |
|
DWR_TRF_PRFL |
|
DWR_TRF_TRF_PRFL_ASGN |
|
DWR_TRGT_ACCT |
|
DWR_TRGT_AGRMNT |
|
DWR_TRGT_GEO_AREA |
|
DWR_TRGT_MKT_SGMNT |
|
DWR_TRML |
|
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 |
|
DWR_TWR |
|
DWR_UNDRGRND_STRCTR |
|
DWR_USG_PNT |
|
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 |
|
DWR_VAL_ALS_SET |
|
DWR_VAL_TO_ALS |
|
DWR_VHCL |
|
DWR_VLTG_CNTRL_ZN |
|
DWR_VLTG_LMT |
|
DWR_VNDR |
|
DWR_VNDR_ITEM |
|
DWR_VRTL_TEAM |
|
DWR_WEB_PG |
|
DWR_WND_GNRTNG_UNIT |
|
DWR_WR_INFO |
|
DWR_WR_SPCNG_INFO |
|
DWR_WRK_ASST |
|
DWR_WRK_BLLG_INFO |
|
DWR_WRK_COST_DTL |
|
DWR_WRK_FLOW_STEP |
|
DWR_WRK_LOC |
|
DWR_WRK_ORDR |
|
DWR_WRK_STAT_ENTRY |
|
DWR_WRK_TASK |
|
DWR_WRK_TASK_AS_SET_ASGN |
|
DWR_WRK_TIME_SCHL |
|
DWR_ZN |
Table 4-4 briefly describes the Lookup tables in Oracle Utilities Data Model.
Table Name | More Information |
---|---|
DWL_ACCT_ADJ_RSN |
|
DWL_ACCT_ASGN_RSN |
|
DWL_ACCT_ASGN_TYP |
|
DWL_ACCT_BAL_ADJ_TYP |
|
DWL_ACCT_BAL_TYP |
|
DWL_ACCT_EVT_TYP |
|
DWL_ACCT_ITEM_CTGRY |
|
DWL_ACCT_PYMT_MTHD_STAT_RSN |
|
DWL_ACCT_PYMT_MTHD_STAT_TYP |
|
DWL_ACCT_RFND_RSN |
|
DWL_ACCT_RL_TYP |
|
DWL_ACCT_STAT_RSN |
|
DWL_ACCT_STAT_TYP |
|
DWL_ACCT_TYP |
|
DWL_AGRMNT_ASGN_RSN |
|
DWL_AGRMNT_ASGN_TYP |
|
DWL_AGRMNT_STAT_TYP |
|
DWL_AGRMNT_TYP |
|
DWL_AMI_BLLG_RDY_KIND_ENUM |
|
DWL_ANCHOR_KIND_ENUM |
|
DWL_APNMNT_TYP |
|
DWL_ASST_MDL_USG_KIND_ENUM |
|
DWL_ASST_TYP |
|
DWL_BARNG_RSN |
|
DWL_BLLG_OCCRNCE_TYP |
|
DWL_BLLG_PRD |
|
DWL_BSHNG_INSLTN_KIND_ENUM |
|
DWL_BSNS_INTRACN_ASGN_TYP |
|
DWL_BSNS_INTRACN_STAT_RSN |
|
DWL_BSNS_INTRACN_STAT_TYP |
|
DWL_BSNS_INTRACN_TYP |
|
DWL_BSNS_LEGAL_STAT |
|
DWL_CALL_CNTR_CASE_SB_TYP |
|
DWL_CALL_CNTR_CASE_TTL |
|
DWL_CALL_CNTR_CASE_TYP |
|
DWL_CHNL_TYP |
|
DWL_CHRG_KIND_ENUM |
|
DWL_CLRNCE_ACTN_KIND_ENUM |
|
DWL_CMPGN_CHNL_TYP |
|
DWL_CMPGN_STAT |
|
DWL_CMPGN_TYP |
|
DWL_CMPST_SWTCH_KIND_ENUM |
|
DWL_CNCT_LST_CHNG_RSN |
|
DWL_CNCT_LST_RCRNC_TYP |
|
DWL_CNCT_RLS |
|
DWL_CNTRL_TYP |
|
DWL_COLNT_TYP_ENUM |
|
DWL_COMUNICTN_DRCTN_KIND_ENUM |
|
DWL_COMUNICTN_TCHNLGY_KIND_ENUM |
|
DWL_COST_RSN |
|
DWL_COST_SB_TYP |
|
DWL_COST_TYP |
|
DWL_CRNCY |
|
DWL_CRNCY_ENUM |
|
DWL_CRPRT_STNDRD_KIND_ENUM |
|
DWL_CRVE_STYLE_ENUM |
|
DWL_CUST_GRP |
|
DWL_CUST_KIND_ENUM |
|
DWL_CUST_OCCSN_TYP |
|
DWL_CUST_RVN_BND |
|
DWL_CUST_TYP |
|
DWL_CUT_JMPR_ACTN_KIND_ENUM |
|
DWL_DAY_TYP |
|
DWL_DEBT_AGNG_BND |
|
DWL_DOC_TYP |
|
DWL_DOC_TYP_GRP |
|
DWL_DRCT_DEBT_STAT_RSN |
|
DWL_EDU |
|
DWL_EMP_DESIG |
|
DWL_EMP_JB_RL_TYP |
|
DWL_EMP_TYP |
|
DWL_END_DVC_DOMAIN |
|
DWL_END_DVC_EVT_OR_ACTN |
|
DWL_END_DVC_EVT_TYP |
|
DWL_END_DVC_FNCTN_KIND_ENUM |
|
DWL_END_DVC_SB_DOMAIN |
|
DWL_END_DVC_TYP |
|
DWL_ENRGY_FLOW_DRCTN |
|
DWL_EVT_ASGN_RSN |
|
DWL_EVT_ASGN_TYP |
|
DWL_EVT_CLASS |
|
DWL_EVT_CTGRY |
|
DWL_EVT_PRTY_RL |
|
DWL_EVT_RESPN_RSN |
|
DWL_EVT_RSLT |
|
DWL_EVT_RSLTN |
|
DWL_EVT_RSN |
|
DWL_EVT_RSN_CTGRY |
|
DWL_EVT_STAT_RSN |
|
DWL_EVT_STAT_TYP |
|
DWL_EVT_TYP |
|
DWL_EXTRNL_ORG_TYP |
|
DWL_FCT_DVC_KIND_ENUM |
|
DWL_FLT_IND_RESET_KIND_ENUM |
|
DWL_GL_ACCT_TYP |
|
DWL_GL_JE_CTGRY |
|
DWL_GL_SGMNT_TYP |
|
DWL_GNDR |
|
DWL_GNRTR_CNTRL_MD_ENUM |
|
DWL_GNRTR_CNTRL_SRC_ENUM |
|
DWL_GNRTR_OPERTNG_MD_ENUM |
|
DWL_HYDR_ENRG_CNVRSN_KIND_ENUM |
|
DWL_INTRACN_DRCTN |
|
DWL_INTRACN_PRIORITY_TYP |
|
DWL_INTRACN_RSLT_TYP |
|
DWL_INTRACN_RSN |
|
DWL_INTRACN_STAT |
|
DWL_INTRACN_TRNSFR_RSN |
|
DWL_INTRACN_TYP |
|
DWL_INTRHRMNCS |
|
DWL_INTTV_RSLT_TYP |
|
DWL_INTTV_TYP |
|
DWL_INVC_DISC_RSN |
|
DWL_INVC_DISC_TYP |
|
DWL_INVC_DLVRY_FRMT |
|
DWL_INVC_DLVRY_TYP |
|
DWL_INVC_ITEM_DTL_TYP |
|
DWL_INVC_ITEM_TYP |
|
DWL_INVC_PYMT_TERM_TYP |
|
DWL_INVC_STAT_TYP |
|
DWL_INVC_TYP |
|
DWL_IVR_MENU_ITEM |
|
DWL_JNT_CNFGRTN_KIND_ENUM |
|
DWL_JNT_FILL_KIND_ENUM |
|
DWL_LANG |
|
DWL_LTTR_TYP |
|
DWL_LYLTY_PROG_EVT_TYP |
|
DWL_MEDIA_OBJ_TYP |
|
DWL_MRTL_STAT |
|
DWL_MSRMNT_KIND |
|
DWL_MTR_STAT |
|
DWL_NTNLTY |
|
DWL_ORG_BSNS_UNIT_TYP |
|
DWL_PBLCTN_TYP |
|
DWL_PHS |
|
DWL_PHS_CD_ENUM |
|
DWL_PHS_CNCTD_FLT_KIND_ENUM |
|
DWL_PHS_SHNT_CNCTN_KIND_ENUM |
|
DWL_PLND_OUTG_KIND_ENUM |
|
DWL_POLE_BASE_KIND_ENUM |
|
DWL_POLE_PRSRVTV_KIND_ENUM |
|
DWL_POLE_TRTMNT_KIND_ENUM |
|
DWL_POSTL_SRVC_TYP |
|
DWL_PRICE_TYP |
|
DWL_PRMTN_RSLT_TYP |
|
DWL_PRMTN_TERM_TYP |
|
DWL_PRMTN_TERM_VAL |
|
DWL_PRMTN_TYP |
|
DWL_PROC_KIND_ENUM |
|
DWL_PRSPCT_PRIORITY_TYP |
|
DWL_PRSPCT_QLTY_SCR_TYP |
|
DWL_PRSPCT_REJECT_RSN |
|
DWL_PRTY_ACCT_ASGN_TYP |
|
DWL_PRTY_ASGN_RSN |
|
DWL_PRTY_ASGN_TYP |
|
DWL_PRTY_CNCT_INFO_TYP |
|
DWL_PRTY_CNCT_LST_PRTCPTN |
|
DWL_PRTY_CNCT_LST_RL |
|
DWL_PRTY_EVT_TYP |
|
DWL_PRTY_INTRACN_THRD_TYP |
|
DWL_PRTY_LOC_RSN |
|
DWL_PRTY_LOC_TYP |
|
DWL_PRTY_MGMT_RL |
|
DWL_PRTY_RL |
|
DWL_PRTY_STAT_CHNG_RSN |
|
DWL_PRTY_STAT_CTGRY |
|
DWL_PRTY_STAT_TYP |
|
DWL_PRTY_TYP |
|
DWL_PSR_TYP |
|
DWL_PYMT_AGNG_CLASS |
|
DWL_PYMT_MTHD_TYP |
|
DWL_PYMT_TRX_TYP |
|
DWL_RDNG_ACMLTN_BHVR |
|
DWL_RDNG_DATA_QLFR |
|
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 |
|
DWL_RGLTNG_CNTRL_MD_KIND_ENUM |
|
DWL_RMT_UNIT_TYP_ENUM |
|
DWL_RVN_KIND_ENUM |
|
DWL_SEAL_CNDTN_KIND_ENUM |
|
DWL_SEAL_KIND_ENUM |
|
DWL_SEASON |
|
DWL_SGMNT_TYP |
|
DWL_SHORT_CRCUT_RTR_KIND_ENUM |
|
DWL_SIC_ASGN_RSN |
|
DWL_SIC_CLSFCTN |
|
DWL_SNCHRNS_MC_OPERTNG_MD_ENUM |
|
DWL_SNGL_PHS_KIND_ENUM |
|
DWL_SRC_ENUM |
|
DWL_SRC_SYS_TYP |
|
DWL_SRVC_CTGRY |
|
DWL_SRVC_TYP |
|
DWL_STRCTR_MTRL_KIND_ENUM |
|
DWL_STRCTR_SPPRT_KIND_ENUM |
|
DWL_STREETLGHT_LAMP_KIND_ENUM |
|
DWL_SVC_CNTRL_MD_ENUM |
|
DWL_SWTCH_ACTN_KIND_ENUM |
|
DWL_SWTCH_STATE_ENUM |
|
DWL_SYNCHRNS_MC_KIND_ENUM |
|
DWL_TAG_ACTN_KIND_ENUM |
|
DWL_TAX_AUTH |
|
DWL_TAX_CTGRY |
|
DWL_TIME_OF_USE |
|
DWL_TRBL_RPT_KIND_ENUM |
|
DWL_TRGT_TYP |
|
DWL_TRNSFRMR_CNTRL_MD_ENUM |
|
DWL_TWR_CONSTRCTN_KIND_ENUM |
|
DWL_UNDRGRND_STRCTR_KIND_ENUM |
|
DWL_UNIT_MLTPLR |
|
DWL_UNIT_MLTPLR_ENUM |
|
DWL_UNIT_SYMBL_ENUM |
|
DWL_UOM |
|
DWL_USG_PNT_CNCTD_KIND_ENUM |
|
DWL_UTLTY_CMDTY |
|
DWL_VAL_TYP |
|
DWL_VEE_EXPTN_TYP |
|
DWL_VEE_GRP |
|
DWL_VEE_RULE |
|
DWL_VLDTY_ENUM |
|
DWL_WEATHR_ALRT |
|
DWL_WEATHR_FRCST |
|
DWL_WEATHR_INFO |
|
DWL_WEATHR_LOC |
|
DWL_WND_GEN_UNIT_KIND_ENUM |
|
DWL_WNDNG_CNCTN_ENUM |
|
DWL_WR_INSLTN_KIND_ENUM |
|
DWL_WR_MTRL_KIND_ENUM |
|
DWL_WR_USG_KIND_ENUM |
|
DWL_WRK_KIND_ENUM |
|
DWL_WRK_STAT_KIND_ENUM |
|
DWL_WRK_TASK_KIND_ENUM |
|
DWL_WRK_TIME_SCHL_KIND_ENUM |
|
DWL_ZN_KIND_ENUM |
Table 4-5 briefly describes the Base tables in Oracle Utilities Data Model.
Table Name | More Information |
---|---|
DWB_ACCMLTR |
|
DWB_ACCMLTR_VAL |
|
DWB_ACCT_ACCT_CYCL_HIST |
|
DWB_ACCT_BAL_ADJ |
|
DWB_ACCT_BAL_BKT |
|
DWB_ACCT_BAL_HIST |
|
DWB_ACCT_BAL_IMPT |
|
DWB_ACCT_BLLG_OCCRNCE |
|
DWB_ACCT_CRDT_LMT |
|
DWB_ACCT_DEBT |
|
DWB_ACCT_MGMT_HIST |
|
DWB_ACCT_PYMT |
|
DWB_ACCT_PYMT_BAL_IMPT |
|
DWB_ACCT_PYMT_MTHD_STAT |
|
DWB_ACCT_RCHRG |
|
DWB_ACCT_RFND |
|
DWB_ACCT_STAT_HIST |
|
DWB_ACTVTY_REC |
|
DWB_AGRMNT_APRVL |
|
DWB_AGRMNT_ASGN |
|
DWB_AGRMNT_STAT |
|
DWB_ANLG |
|
DWB_ANLG_VAL |
|
DWB_APNMNT |
|
DWB_ASST_APPRSL_HIST |
|
DWB_ASST_CNDTN_HIST |
|
DWB_ATMSPHRC_PRSSR |
|
DWB_BLK_LST_HIST |
|
DWB_BSNS_INTRACN |
|
DWB_BSNS_INTRACN_ITEM |
|
DWB_BSNS_INTRACN_ITEM_PRICE |
|
DWB_BSNS_INTRACN_RL |
|
DWB_BSNS_INTRACN_STAT_HIST |
|
DWB_CLOUD_INFO |
|
DWB_CMND |
|
DWB_CMPGN_MSG_CRTVE |
|
DWB_CNFGRTN_EVT |
|
DWB_CNTRL |
|
DWB_COST |
|
DWB_CRNCY_EXCHNG_RATE |
|
DWB_CRVE_DATA |
|
DWB_CUST_ORDR |
|
DWB_CUST_ORDR_LI |
|
DWB_DEBT_COLLCTN |
|
DWB_DEBT_COLLCTN_ASGN |
|
DWB_DEBT_COLLCTN_ASGN_BTCH |
|
DWB_DOC_STAT |
|
DWB_DSCRT |
|
DWB_DSCRT_VAL |
|
DWB_EMP_ACT_LBR_HRLY |
|
DWB_EMP_COST |
|
DWB_EMP_TRNG_REC |
|
DWB_END_DVC_CNTRL |
|
DWB_END_DVC_CNTRL_PRMRY_DVC_TMNG |
|
DWB_END_DVC_CNTRL_SCNDRY_DVC_TMNG |
|
DWB_END_DVC_EVT |
|
DWB_EVT |
|
DWB_EVT_ACCT |
|
DWB_EVT_ASGN |
|
DWB_EVT_CHAT |
|
DWB_EVT_CHAT_DTL |
|
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 |
|
DWB_EVT_STAT |
|
DWB_EVT_WEB_RGSTRTN |
|
DWB_EVT_WEB_VST |
|
DWB_FLOD_INFO |
|
DWB_FNL_RDNG |
|
DWB_GL_BAL |
|
DWB_GL_JE |
|
DWB_GL_JE_BTCH |
|
DWB_GL_JE_LN |
|
DWB_GL_JE_LN_SBLDGR_ASGN |
|
DWB_GL_SBLDGR_JE |
|
DWB_GL_SBLDGR_JE_LN |
|
DWB_INCDNT |
|
DWB_INITIAL_RDNG |
|
DWB_INTRACN_ANSWR_CHOICE |
|
DWB_INTRACN_NAVGTN_HIST |
|
DWB_INTRACN_QUES_RESPN |
|
DWB_INTRACN_TRNSFR_HIST |
|
DWB_INVC |
|
DWB_INVC_ADJ |
|
DWB_INVC_DISC |
|
DWB_INVC_ITEM |
|
DWB_INVC_ITEM_DTL |
|
DWB_INVC_ITEM_RLTN |
|
DWB_INVC_PYMT_ASGN |
|
DWB_INVC_PYMT_TERM |
|
DWB_INVC_STAT_HIST |
|
DWB_INVC_TAX_ITEM |
|
DWB_JE_LN_INVC_ITEM_ASGN |
|
DWB_MSRMNT |
|
DWB_MSRMNT_VAL |
|
DWB_MTR_RDNG |
|
DWB_OUTG |
|
DWB_OUTG_REC |
|
DWB_PCHSE_ORDR |
|
DWB_PCHSE_ORDR_LI |
|
DWB_PPTN |
|
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_INTRCN_THRD_SBRP_ASGN |
|
DWB_PRTY_PRMTN_RESPN |
|
DWB_PRTY_STAT_HIST |
|
DWB_RDNG_QLTY |
|
DWB_RESRE_ORDR |
|
DWB_RESRE_ORDR_ITEM |
|
DWB_SCHL_EVT |
|
DWB_SEA_CNDTN |
|
DWB_SET_PNT |
|
DWB_SPOT_TEMP |
|
DWB_SRVC_ORDR |
|
DWB_SRVC_ORDR_LI |
|
DWB_STRNG_MSRMNT |
|
DWB_STRNG_MSRMNT_VAL |
|
DWB_VEE_EXPTN |
|
DWB_WND_INFO |
|
DWB_WRK_COST_SUMM |
|
Not physicalized |
Table 4-6 Oracle Utilities Data Model Derived Tables
Table Name | More Information |
---|---|
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_MNNG |
|
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 |
Table 4-7 briefly describes the Aggregate tables in Oracle Utilities Data Model.
Table Name | More Information |
---|---|
DWA_END_DVC_EVT_CUST_MO |
|
DWA_END_DVC_EVT_DVC_MO |
|
DWA_MTR_RDNG_MO |
|
DWA_MTR_RDNG_TOU_MO |
|
DWA_OUTG_MO |
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 |
---|---|
|
This entity gives order measures, number of orders and total order amount, in same quarters of consecutive years. |
|
This entity gives order measures, number of orders and total order amount, in consecutive quarters. |
|
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 |
|
TMP_DWD_CUST_RFMP_SCR_2 |
Table Name | Description |
---|---|
|
Store ETL parameters such as etl start date and etl end date. For more information, see "Intra-ETL Load Parameters Control Table". |
|
Reports errors at the individual program level. For more information, see "Intra-ETL Monitoring Process Control Tables". |
|
Reports errors at the whole batch load level. For more information, see "Intra-ETL Monitoring Process Control Tables". |
|
|
|
Reports OLAP ETL parameter. For more information, see "Intra-ETL OLAP Mapping Control Table". |
Table 4-10 lists the sequence names in Oracle Utilities Data Model.
Table 4-11 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.
Table Name |
---|
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 |
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-12 shows the cube materialized views in oudm_sys
schema.
Table 4-12 OLAP Cube Materialized Views in oudm_sys Schema
Cube Materialized View Name | OLAP Object Name | OLAP Object Type | More Information |
---|---|---|---|
|
|
Cube |
Table 4-13 shows the OLAP cube views in oudm_sys
schema.