Meter-Related Database Changes
This chapter provides lists of meter-related database changes in the 25.4 release of Oracle Utilities cloud services. This includes:
New Tables
 
Table
Name
Description
D1_DVC_ENTITY_GRP*
Device Entity Group
Used to define the relationship between a device and an entity group
D1_ENTITY_GRP*
Entity Group
Used to capture groups of entities (such as service points or devices)
D1_ENTITY_GRP_CHAR*
Entity Group Characteristics
Used to store characteristics related to a group of entities
D1_ENTITY_GRP_CRIT*
Entity Group Criteria
Used to store criteria used to define a group of entities
D1_ENTITY_GRP_CRIT_VAL*
Entity Group Criteria Value
Used to store criteria values used to define a group of entities
D1_ENTITY_GRP_L*
Entity Group Language
Used to store labels for the Entity Group table
D1_SP_ENTITY_GRP*
Service Point Entity Group
Used to define the relationship between a service point and an entity group
* Used by Digital Asset Cloud Service
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
D1_DVC_ENTITY_GRP*
BO_DATA_AREA
CLOB
4000
D1_DVC_ENTITY_GRP*
D1_DEVICE_ID
CHAR
48
D1_DVC_ENTITY_GRP*
EFF_DTTM
DATE
7
D1_DVC_ENTITY_GRP*
ENTITY_GRP_CD
VARCHAR2
120
D1_DVC_ENTITY_GRP*
EXPIRATION_DTTM
DATE
7
D1_DVC_ENTITY_GRP*
VERSION
NUMBER
22
D1_ENTITY_GRP*
BO_DATA_AREA
CLOB
4000
D1_ENTITY_GRP*
BUS_OBJ_CD
CHAR
120
D1_ENTITY_GRP*
ENTITY_GRP_ASSGN_OPT_FLG
CHAR
16
D1_ENTITY_GRP*
ENTITY_GRP_CATEGORY
VARCHAR2
1016
D1_ENTITY_GRP*
ENTITY_GRP_CD
VARCHAR2
120
D1_ENTITY_GRP*
ENTITY_GRP_DEACT_OPT_FLG
CHAR
16
D1_ENTITY_GRP*
ENTITY_GRP_STAT_FLG
CHAR
16
D1_ENTITY_GRP*
VERSION
NUMBER
22
D1_ENTITY_GRP_CHAR*
ADHOC_CHAR_VAL
VARCHAR2
1016
D1_ENTITY_GRP_CHAR*
CHAR_TYPE_CD
CHAR
32
D1_ENTITY_GRP_CHAR*
CHAR_VAL
CHAR
64
D1_ENTITY_GRP_CHAR*
CHAR_VAL_FK1
VARCHAR2
200
D1_ENTITY_GRP_CHAR*
CHAR_VAL_FK2
VARCHAR2
200
D1_ENTITY_GRP_CHAR*
CHAR_VAL_FK3
VARCHAR2
200
D1_ENTITY_GRP_CHAR*
CHAR_VAL_FK4
VARCHAR2
200
D1_ENTITY_GRP_CHAR*
CHAR_VAL_FK5
VARCHAR2
200
D1_ENTITY_GRP_CHAR*
ENTITY_GRP_CD
VARCHAR2
120
D1_ENTITY_GRP_CHAR*
SEQ_NUM
NUMBER
22
D1_ENTITY_GRP_CHAR*
SRCH_CHAR_VAL
VARCHAR2
200
D1_ENTITY_GRP_CHAR*
VERSION
NUMBER
22
D1_ENTITY_GRP_CRIT*
CRITERIA_SEQ_NUM
NUMBER
22
D1_ENTITY_GRP_CRIT*
ENTITY_GRP_CD
VARCHAR2
120
D1_ENTITY_GRP_CRIT*
GRP_CRITERIA_SRC
VARCHAR2
1016
D1_ENTITY_GRP_CRIT*
VERSION
NUMBER
22
D1_ENTITY_GRP_CRIT_VAL*
BO_DATA_AREA
CLOB
4000
D1_ENTITY_GRP_CRIT_VAL*
CRITERIA_SEQ_NUM
NUMBER
22
D1_ENTITY_GRP_CRIT_VAL*
CRITERIA_VALUE
CHAR
200
D1_ENTITY_GRP_CRIT_VAL*
CRITERIA_VAL_SEQ_NUM
NUMBER
22
D1_ENTITY_GRP_CRIT_VAL*
ENTITY_GRP_CD
VARCHAR2
120
D1_ENTITY_GRP_CRIT_VAL*
GRP_CRITERIA_SRC
VARCHAR2
1016
D1_ENTITY_GRP_CRIT_VAL*
VERSION
NUMBER
22
D1_ENTITY_GRP_L*
DESCR100
VARCHAR2
400
D1_ENTITY_GRP_L*
DESCRLONG
VARCHAR2
16000
D1_ENTITY_GRP_L*
ENTITY_GRP_CD
VARCHAR2
120
D1_ENTITY_GRP_L*
LANGUAGE_CD
CHAR
12
D1_ENTITY_GRP_L*
VERSION
NUMBER
22
D1_MEASR_COMP_TYPE
IMD_HANDLING_FLG
CHAR
16
D1_MSRMT
PREVEE_MSRMT_COND_FLG
CHAR
24
D1_MSRMT
PREVEE_MSRMT_VAL
NUMBER
22
D1_MSRMT
PREVEE_READING_COND_FLG
CHAR
24
D1_MSRMT
PREVEE_READING_VAL
NUMBER
22
D1_MSRMT
USER_ID
CHAR
32
D1_MSRMT_AUDIT
AFTER_COMBINED_MULTIPLIER
NUMBER
22
D1_MSRMT_AUDIT
AFTER_MSRMT_COND_FLG
CHAR
24
D1_MSRMT_AUDIT
AFTER_MSRMT_USE_FLG
CHAR
16
D1_MSRMT_AUDIT
AFTER_MSRMT_VAL
NUMBER
22
D1_MSRMT_AUDIT
AFTER_PREVEE_MSRMT_COND_FLG
CHAR
24
D1_MSRMT_AUDIT
AFTER_PREVEE_MSRMT_VAL
NUMBER
22
D1_MSRMT_AUDIT
AFTER_PREVEE_READING_COND_FLG
CHAR
24
D1_MSRMT_AUDIT
AFTER_PREVEE_READING_VAL
NUMBER
22
D1_MSRMT_AUDIT
AFTER_PREV_MSRMT_DTTM
DATE
7
D1_MSRMT_AUDIT
AFTER_READING_COND_FLG
CHAR
24
D1_MSRMT_AUDIT
AFTER_READING_VAL
NUMBER
22
D1_MSRMT_AUDIT
BEFORE_COMBINED_MULTIPLIER
NUMBER
22
D1_MSRMT_AUDIT
BEFORE_MSRMT_COND_FLG
CHAR
24
D1_MSRMT_AUDIT
BEFORE_MSRMT_USE_FLG
CHAR
16
D1_MSRMT_AUDIT
BEFORE_MSRMT_VAL
NUMBER
22
D1_MSRMT_AUDIT
BEFORE_PREVEE_MSRMT_COND_FLG
CHAR
24
D1_MSRMT_AUDIT
BEFORE_PREVEE_MSRMT_VAL
NUMBER
22
D1_MSRMT_AUDIT
BEFORE_PREVEE_READING_COND_FLG
CHAR
24
D1_MSRMT_AUDIT
BEFORE_PREVEE_READING_VAL
NUMBER
22
D1_MSRMT_AUDIT
BEFORE_PREV_MSRMT_DTTM
DATE
7
D1_MSRMT_AUDIT
BEFORE_READING_COND_FLG
CHAR
24
D1_MSRMT_AUDIT
BEFORE_READING_VAL
NUMBER
22
D1_SPR_PROG
UTILITY_APPROVAL_REQD_FLG
CHAR
16
D1_SP_ENTITY_GRP*
BO_DATA_AREA
CLOB
4000
D1_SP_ENTITY_GRP*
D1_SP_ID
CHAR
48
D1_SP_ENTITY_GRP*
EFF_DTTM
DATE
7
D1_SP_ENTITY_GRP*
ENTITY_GRP_CD
VARCHAR2
120
D1_SP_ENTITY_GRP*
EXPIRATION_DTTM
DATE
7
D1_SP_ENTITY_GRP*
VERSION
NUMBER
22
* Used by Digital Asset Cloud Service
New Indexes
 
Table_Name
Index_Name
D1_DVC_ENTITY_GRP
D1M674P0
D1_DVC_ENTITY_GRP
D1M674S0
D1_ENTITY_GRP
D1C675P0
D1_ENTITY_GRP_CHAR
D1C670P0
D1_ENTITY_GRP_CRIT
D1C671P0
D1_ENTITY_GRP_CRIT_VAL
D1C672P0
D1_ENTITY_GRP_L
D1C669P0
D1_SP_ENTITY_GRP
D1M673P0
D1_SP_ENTITY_GRP
D1M673S0
Dropped Columns
 
Table_Name
Column_Name
Data Type
Data Length
D1_MSRMT_AUDIT
COMBINED_MULTIPLIER
NUMBER
22
D1_MSRMT_AUDIT
MSRMT_COND_FLG
CHAR
24
D1_MSRMT_AUDIT
MSRMT_USE_FLG
CHAR
16
D1_MSRMT_AUDIT
MSRMT_VAL
NUMBER
22
D1_MSRMT_AUDIT
PREVEE_MSRMT_COND_FLG
CHAR
24
D1_MSRMT_AUDIT
PREVEE_MSRMT_VAL
NUMBER
22
D1_MSRMT_AUDIT
PREVEE_READING_COND_FLG
CHAR
24
D1_MSRMT_AUDIT
PREVEE_READING_VAL
NUMBER
22
D1_MSRMT_AUDIT
PREV_MSRMT_DTTM
DATE
7
D1_MSRMT_AUDIT
READING_COND_FLG
CHAR
24
D1_MSRMT_AUDIT
READING_VAL
NUMBER
22