Meter-Related Database Changes
This chapter provides lists of meter-related database changes in the 24B release of Oracle Utilities cloud services. This includes:
New Tables
 
Table
Name
Description
D1_DYN_OPT_QTY*
Dynamic Option Quantity
Used to store quantities related to dynamic options.
D1_DYN_OPT_TYPE_QTY_TYPE*
Dynamic Option Type Quantity Type
Used to define type of quantities stored for dynamic option types.
* Used by Digital Asset Cloud Service
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
D1_DYN_OPT_QTY
DYN_OPT_ID*
CHAR
12
D1_DYN_OPT_QTY
DYN_OPT_QTY*
NUMBER
16,6
D1_DYN_OPT_QTY
DYN_OPT_QTY_TYPE*
VARCHAR2
254
D1_DYN_OPT_QTY
END_DTTM*
DATE
 
D1_DYN_OPT_QTY
START_DTTM*
DATE
 
D1_DYN_OPT_QTY
VERSION*
NUMBER
5
D1_DYN_OPT_TYPE_QTY_TYPE
DYN_OPT_TYPE_CD*
VARCHAR2
30
D1_DYN_OPT_TYPE_QTY_TYPE
DYN_OPT_TYPE_QTY_TYPE*
VARCHAR2
254
D1_DYN_OPT_TYPE_QTY_TYPE
VERSION*
NUMBER
5
D1_MEASR_COMP_SET
DISTRIBUTE_LOAD_FLG
CHAR
4
D1_MEASR_COMP_SET
LOAD_DISTRIBUTION_FORMULA
VARCHAR2
254
D1_MEASR_COMP_SET
LOAD_DIST_MANAGED_BY_FLG
CHAR
4
D1_MEASR_COMP_SET
NBR_OF_DIGITS_TO_USE
NUMBER
1
D1_MEASR_COMP_TYPE
ANCHR_TIME
DATE
 
D1_US_TYPE
PROC_TIMETABLE_TYPE_CD
VARCHAR2
30
* Used by Digital Asset Cloud Service
New Indexes
 
Table_Name
Index_Name
D1_DYN_OPT_QTY
D1M659P0
D1_DYN_OPT_TYPE_QTY_TYPE
D1C660P0