3 Meter-Related Database Changes

This chapter provides lists of meter-related database changes in the 25.10 release of Oracle Utilities cloud services. This includes:

New Tables

Table Name Description
D1_ENTITY_GRP_REL* Entity Group Relationship Used to capture relationships between entity groups
D1_MSRMT_EXT_REQ Measurement Extract Request Used to capture requests for measurement data extracts
D1_MSRMT_EXT_REQ_K Measurement Extract Request Key Used to capture the relationship between a measurement extract request and an environment
D1_POSTAL_DFLT Postal Code Default MDM Used to capture details related to a default postal code
D1_POSTAL_DFLT_CHAR Postal Code Default Characteristic MDM Used to store characteristics associated with a default postal code
D1_SP_EVT_OUTCOME* Service Point Event Outcome Used to capture details regarding the outcome of an event associated with a service point
D1_SP_EVT_OUTCOME_CHAR* Service Point Event Outcome Characteristic Used to store characteristics associated with a service point event outcome
D1_SP_EVT_OUTCOME_LOG* Service Point Event Outcome Log Used to capture log details for a service point event outcome
D1_SP_EVT_OUTCOME_LOG_PARM* Service Point Event Outcome Log Parameter Used to capture log parameters for a service point event outcome
D1_SP_EVT_OUTCOME_QTY* Service Point Event Outcome Quantity Used to capture service quantities associated with a service point event outcome
D1_US_ENTITY_GRP_REL* Usage Subscription - Entity Group Used to capture relationships between an entity group and a usage subscription
D1_US_RS_HIST* Usage Subscription Rate Schedule History Used to capture relationships between a usage subscription and a rate schedule over time
D1_WEATHER_STN* Weather Station Used to capture details about a weather station
D1_WEATHER_STN_CHAR* Weather Station Characteristic Used to store characteristics associated with a weather station
D1_WEATHER_STN_L* Weather Station Language Language table for Weather Station

* Used by Digital Asset Cloud Service

New Columns

Table_Name Column_Name Data Type Length
D1_DVC_EVT DVC_EVT_REASON_FLG* VARCHAR2 1016
D1_DYN_OPT_TYPE ELIG_FOR_OPTOUT_FLG* CHAR 16
D1_DYN_OPT_TYPE OPTOUT_THRESHOLD_MINUTES* NUMBER 22
D1_DYN_OPT_USG_GRP PGM_SETT_MTHD_FLG* CHAR 16
D1_ENTITY_GRP_REL ENTITY_GRP_CD* VARCHAR2 120
D1_ENTITY_GRP_REL ENTITY_GRP_REL_TYPE_FLG* CHAR 16
D1_ENTITY_GRP_REL REL_ENTITY_GRP_CD* VARCHAR2 120
D1_ENTITY_GRP_REL SEQNO* NUMBER 22
D1_ENTITY_GRP_REL VERSION* NUMBER 22
D1_MSRMT_EXT_REQ BATCH_CD CHAR 32
D1_MSRMT_EXT_REQ BATCH_NBR NUMBER 22
D1_MSRMT_EXT_REQ CRE_DTTM DATE 7
D1_MSRMT_EXT_REQ END_DTTM DATE 7
D1_MSRMT_EXT_REQ ILM_ARCH_SW CHAR 4
D1_MSRMT_EXT_REQ ILM_DT DATE 7
D1_MSRMT_EXT_REQ INIT_MSRMT_DATA_ID CHAR 56
D1_MSRMT_EXT_REQ MAINT_OBJ_CD CHAR 48
D1_MSRMT_EXT_REQ MEASR_COMP_ID CHAR 48
D1_MSRMT_EXT_REQ MSRMT_EXT_REQ_ID CHAR 56
D1_MSRMT_EXT_REQ PK_VALUE1 VARCHAR2 1016
D1_MSRMT_EXT_REQ PK_VALUE2 VARCHAR2 1016
D1_MSRMT_EXT_REQ PK_VALUE3 VARCHAR2 1016
D1_MSRMT_EXT_REQ PK_VALUE4 VARCHAR2 1016
D1_MSRMT_EXT_REQ PK_VALUE5 VARCHAR2 1016
D1_MSRMT_EXT_REQ START_DTTM DATE 7
D1_MSRMT_EXT_REQ VERSION NUMBER 22
D1_MSRMT_EXT_REQ_K ENV_ID NUMBER 22
D1_MSRMT_EXT_REQ_K MSRMT_EXT_REQ_ID CHAR 56
D1_NW_LOC WEATHER_STN* VARCHAR2 120
D1_POSTAL_DFLT BO_DATA_AREA CLOB 4000
D1_POSTAL_DFLT BUS_OBJ_CD CHAR 120
D1_POSTAL_DFLT CITY VARCHAR2 360
D1_POSTAL_DFLT COUNTRY CHAR 12
D1_POSTAL_DFLT COUNTY VARCHAR2 120
D1_POSTAL_DFLT D1_POSTAL_CD_FROM VARCHAR2 120
D1_POSTAL_DFLT D1_POSTAL_CD_TO VARCHAR2 120
D1_POSTAL_DFLT STATE CHAR 24
D1_POSTAL_DFLT TIME_ZONE_CD CHAR 40
D1_POSTAL_DFLT VERSION NUMBER 22
D1_POSTAL_DFLT WEATHER_STN VARCHAR2 120
D1_POSTAL_DFLT_CHAR ADHOC_CHAR_VAL VARCHAR2 1016
D1_POSTAL_DFLT_CHAR CHAR_TYPE_CD CHAR 32
D1_POSTAL_DFLT_CHAR CHAR_VAL CHAR 64
D1_POSTAL_DFLT_CHAR CHAR_VAL_FK1 VARCHAR2 200
D1_POSTAL_DFLT_CHAR CHAR_VAL_FK2 VARCHAR2 200
D1_POSTAL_DFLT_CHAR CHAR_VAL_FK3 VARCHAR2 200
D1_POSTAL_DFLT_CHAR CHAR_VAL_FK4 VARCHAR2 200
D1_POSTAL_DFLT_CHAR CHAR_VAL_FK5 VARCHAR2 200
D1_POSTAL_DFLT_CHAR COUNTRY CHAR 12
D1_POSTAL_DFLT_CHAR D1_POSTAL_CD_FROM VARCHAR2 120
D1_POSTAL_DFLT_CHAR SEQ_NUM NUMBER 22
D1_POSTAL_DFLT_CHAR SRCH_CHAR_VAL VARCHAR2 200
D1_POSTAL_DFLT_CHAR VERSION NUMBER 22
D1_SP WEATHER_STN* VARCHAR2 120
D1_SP_EVT_OUTCOME BO_DATA_AREA* CLOB 4000
D1_SP_EVT_OUTCOME BO_STATUS_CD* CHAR 48
D1_SP_EVT_OUTCOME BO_STATUS_REASON_CD* VARCHAR2 120
D1_SP_EVT_OUTCOME BUS_OBJ_CD* CHAR 120
D1_SP_EVT_OUTCOME CONTROL_GRP_CD* VARCHAR2 120
D1_SP_EVT_OUTCOME CRE_DTTM* DATE 7
D1_SP_EVT_OUTCOME D1_SP_ID* CHAR 48
D1_SP_EVT_OUTCOME DEVICE_COUNT* NUMBER 22
D1_SP_EVT_OUTCOME DYN_OPT_EVENT_ID* CHAR 56
D1_SP_EVT_OUTCOME ENTITY_GRP_CD* VARCHAR2 120
D1_SP_EVT_OUTCOME ILM_ARCH_SW* CHAR 4
D1_SP_EVT_OUTCOME ILM_DT* DATE 7
D1_SP_EVT_OUTCOME MULTI_ENT_GRP_FLG* CHAR 16
D1_SP_EVT_OUTCOME MULTI_PROG_EVT_FLG* CHAR 16
D1_SP_EVT_OUTCOME PARENT_FLG* CHAR 16
D1_SP_EVT_OUTCOME SP_EVT_OUTCOME_ID* CHAR 56
D1_SP_EVT_OUTCOME SP_OUTCOME_FLG* CHAR 16
D1_SP_EVT_OUTCOME STATUS_UPD_DTTM* DATE 7
D1_SP_EVT_OUTCOME US_ID* CHAR 48
D1_SP_EVT_OUTCOME VERSION* NUMBER 22
D1_SP_EVT_OUTCOME_CHAR ADHOC_CHAR_VAL* VARCHAR2 1016
D1_SP_EVT_OUTCOME_CHAR CHAR_TYPE_CD* CHAR 32
D1_SP_EVT_OUTCOME_CHAR CHAR_VAL* CHAR 64
D1_SP_EVT_OUTCOME_CHAR CHAR_VAL_FK1* VARCHAR2 200
D1_SP_EVT_OUTCOME_CHAR CHAR_VAL_FK2* VARCHAR2 200
D1_SP_EVT_OUTCOME_CHAR CHAR_VAL_FK3* VARCHAR2 200
D1_SP_EVT_OUTCOME_CHAR CHAR_VAL_FK4* VARCHAR2 200
D1_SP_EVT_OUTCOME_CHAR CHAR_VAL_FK5* VARCHAR2 200
D1_SP_EVT_OUTCOME_CHAR SEQ_NUM* NUMBER 22
D1_SP_EVT_OUTCOME_CHAR SP_EVT_OUTCOME_ID* CHAR 56
D1_SP_EVT_OUTCOME_CHAR SRCH_CHAR_VAL* VARCHAR2 200
D1_SP_EVT_OUTCOME_CHAR VERSION* NUMBER 22
D1_SP_EVT_OUTCOME_LOG ADHOC_CHAR_VAL* VARCHAR2 1016
D1_SP_EVT_OUTCOME_LOG BO_STATUS_CD* CHAR 48
D1_SP_EVT_OUTCOME_LOG BO_STATUS_REASON_CD* VARCHAR2 120
D1_SP_EVT_OUTCOME_LOG CHAR_TYPE_CD* CHAR 32
D1_SP_EVT_OUTCOME_LOG CHAR_VAL* CHAR 64
D1_SP_EVT_OUTCOME_LOG CHAR_VAL_FK1* VARCHAR2 200
D1_SP_EVT_OUTCOME_LOG CHAR_VAL_FK2* VARCHAR2 200
D1_SP_EVT_OUTCOME_LOG CHAR_VAL_FK3* VARCHAR2 200
D1_SP_EVT_OUTCOME_LOG CHAR_VAL_FK4* VARCHAR2 200
D1_SP_EVT_OUTCOME_LOG CHAR_VAL_FK5* VARCHAR2 200
D1_SP_EVT_OUTCOME_LOG DESCRLONG* VARCHAR2 16000
D1_SP_EVT_OUTCOME_LOG LOG_DTTM* DATE 7
D1_SP_EVT_OUTCOME_LOG LOG_ENTRY_TYPE_FLG* CHAR 16
D1_SP_EVT_OUTCOME_LOG MESSAGE_CAT_NBR* NUMBER 22
D1_SP_EVT_OUTCOME_LOG MESSAGE_NBR* NUMBER 22
D1_SP_EVT_OUTCOME_LOG SEQNO* NUMBER 22
D1_SP_EVT_OUTCOME_LOG SP_EVT_OUTCOME_ID* CHAR 56
D1_SP_EVT_OUTCOME_LOG USER_ID* CHAR 32
D1_SP_EVT_OUTCOME_LOG VERSION* NUMBER 22
D1_SP_EVT_OUTCOME_LOG_PARM MSG_PARM_TYP_FLG* CHAR 16
D1_SP_EVT_OUTCOME_LOG_PARM MSG_PARM_VAL* VARCHAR2 8000
D1_SP_EVT_OUTCOME_LOG_PARM PARM_SEQ* NUMBER 22
D1_SP_EVT_OUTCOME_LOG_PARM SEQNO* NUMBER 22
D1_SP_EVT_OUTCOME_LOG_PARM SP_EVT_OUTCOME_ID* CHAR 56
D1_SP_EVT_OUTCOME_LOG_PARM VERSION* NUMBER 22
D1_SP_EVT_OUTCOME_QTY D1_SQI_CD* VARCHAR2 120
D1_SP_EVT_OUTCOME_QTY D1_UOM_CD* VARCHAR2 120
D1_SP_EVT_OUTCOME_QTY OUTCOME_DTTM* DATE 7
D1_SP_EVT_OUTCOME_QTY QUANTITY* NUMBER 22
D1_SP_EVT_OUTCOME_QTY SEQNO* NUMBER 22
D1_SP_EVT_OUTCOME_QTY SP_EVT_OUTCOME_ID* CHAR 56
D1_SP_EVT_OUTCOME_QTY VERSION* NUMBER 22
D1_USAGE PGM_SETT_MTHD_FLG* CHAR 16
D1_US_ENTITY_GRP_REL ENTITY_GRP_CD* VARCHAR2 120
D1_US_ENTITY_GRP_REL SEQNO* NUMBER 22
D1_US_ENTITY_GRP_REL US_ENTITY_GRP_REL_TYPE_FLG* CHAR 16
D1_US_ENTITY_GRP_REL US_ID* CHAR 48
D1_US_ENTITY_GRP_REL VERSION* NUMBER 22
D1_US_RS_HIST D1_RS_CD* VARCHAR2 1016
D1_US_RS_HIST EFF_DT* DATE 7
D1_US_RS_HIST US_ID* CHAR 48
D1_US_RS_HIST VERSION* NUMBER 22
D1_WEATHER_STN ACTIVE_INACTIVE_FLG* CHAR 16
D1_WEATHER_STN BO_DATA_AREA* CLOB 4000
D1_WEATHER_STN BUS_OBJ_CD* CHAR 120
D1_WEATHER_STN D1_GEO_LAT* NUMBER 22
D1_WEATHER_STN D1_GEO_LONG* NUMBER 22
D1_WEATHER_STN DVC_ID_TYPE_FLG* CHAR 16
D1_WEATHER_STN ID_VALUE* CHAR 48
D1_WEATHER_STN VERSION* NUMBER 22
D1_WEATHER_STN WEATHER_STATION_EXT_ID* VARCHAR2 240
D1_WEATHER_STN WEATHER_STN* VARCHAR2 120
D1_WEATHER_STN_CHAR ADHOC_CHAR_VAL* VARCHAR2 1016
D1_WEATHER_STN_CHAR CHAR_TYPE_CD* CHAR 32
D1_WEATHER_STN_CHAR CHAR_VAL* CHAR 64
D1_WEATHER_STN_CHAR CHAR_VAL_FK1* VARCHAR2 200
D1_WEATHER_STN_CHAR CHAR_VAL_FK2* VARCHAR2 200
D1_WEATHER_STN_CHAR CHAR_VAL_FK3* VARCHAR2 200
D1_WEATHER_STN_CHAR CHAR_VAL_FK4* VARCHAR2 200
D1_WEATHER_STN_CHAR CHAR_VAL_FK5* VARCHAR2 200
D1_WEATHER_STN_CHAR SEQ_NUM* NUMBER 22
D1_WEATHER_STN_CHAR SRCH_CHAR_VAL* VARCHAR2 200
D1_WEATHER_STN_CHAR VERSION* NUMBER 22
D1_WEATHER_STN_CHAR WEATHER_STN* VARCHAR2 120
D1_WEATHER_STN_L DESCR100* VARCHAR2 400
D1_WEATHER_STN_L DESCRLONG* VARCHAR2 16000
D1_WEATHER_STN_L LANGUAGE_CD* CHAR 12
D1_WEATHER_STN_L VERSION* NUMBER 22
D1_WEATHER_STN_L WEATHER_STN* VARCHAR2 120

* Used by Digital Asset Cloud Service

New Indexes

Table_Name Index_Name
D1_ENTITY_GRP_REL D1C678P0
D1_MSRMT_EXT_REQ D1T676P0
D1_MSRMT_EXT_REQ D1T676S0
D1_MSRMT_EXT_REQ D1T676S1
D1_MSRMT_EXT_REQ_K D1T677P0
D1_POSTAL_DFLT D1C683P0
D1_POSTAL_DFLT_CHAR D1C684P0
D1_SP_EVT_OUTCOME D1M689P0
D1_SP_EVT_OUTCOME_CHAR D1M687P0
D1_SP_EVT_OUTCOME_LOG D1M690P0
D1_SP_EVT_OUTCOME_LOG_PARM D1M691P0
D1_SP_EVT_OUTCOME_QTY D1M686P0
D1_US_ENTITY_GRP_REL D1M679P0
D1_US_RS_HIST D1M688P0
D1_WEATHER_STN D1C680P0
D1_WEATHER_STN_CHAR D1C681P0
D1_WEATHER_STN_L D1C682P0