Meter-Related Database Changes
This chapter provides lists of meter-related database changes in the 23A release of Oracle Utilities cloud services. This includes:
New Indexes
 
Table_Name
Index_Name
D1_GTT4
D1T407P0
D1_GTT7
D1T554P0
D1_GTT8
D1T555P0
D1_EVT_PARTICIPATION
D1T652S1*
D1_EVT_PARTICIPATION
D1T639S2*
D1_EVT_PARTICIPATION
D1T639S3*
* Used by Digital Asset Cloud Service
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
D1_DYN_OPT_EVENT
DYN_OPT_EXT_ID_VALUE*
VARCHAR2
120
D1_DYN_OPT_TYPE
DYN_OPT_CATEGORY*
VARCHAR2
254
D1_DYN_OPT_TYPE
DEVICE_REQD_FLG*
CHAR
4
D1_EVT_PARTICIPATION
RESERVATION_START_DTTM*
DATE
26
D1_EVT_PARTICIPATION
RESERVATION_END_DTTM*
DATE
26
D1_EVT_PARTICIPATION
ILM_DT*
DATE
10
D1_EVT_PARTICIPATION
ILM_ARCH_SW*
CHAR
1
D1_SP
D1_INSTALL_DT*
DATE
10
* Used by Digital Asset Cloud Service
Dropped Columns
 
Table_Name
Column_Name
Data Type
Data Length
D1_EVT_PARTICIPATION
EFF_DTTM
DATE
 
Dropped Indexes
 
Table_Name
Index_Name
D1_GTT4
D1T407S0
D1_GTT7
D1T554S0
D1_GTT8
D1T555S0