Meter-Related Database Changes
This chapter provides lists of meter-related database changes in the 22C release of Oracle Utilities cloud services. This includes:
New Indexes
 
Table_Name
Index_Name
D1_EVT_PARTICIPATION
D1T652S1*
* 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
D1_EVT_PARTICIPATION
RESERVATION_END_DTTM*
DATE
D1_EVT_PARTICIPATION
ILM_DT*
DATE
D1_EVT_PARTICIPATION
ILM_ARCH_SW*
CHAR
1
* Used by Digital Asset Cloud Service
Dropped Columns
 
Table_Name
Column_Name
Data Type
Data Length
D1_EVT_PARTICIPATION
EFF_DTTM
DATE
 
Modified Columns
 
Table_Name
Column_Name
Data Type
Data Length
Change
D1_EVT_PARTICIPATION
US_ID*
CHAR
12
Not Null to Nullable
D1_EVT_PARTICIPATION
DYN_OPT_ID*
CHAR
12
Not Null to Nullable
D1_EVT_PARTICIPATION
DYN_OPT_EVENT_ID*
CHAR
14
Not Null to Nullable
* Used by Digital Asset Cloud Service