Meter-Related Database Changes
This chapter provides lists of meter-related database changes in the 23C release of Oracle Utilities cloud services. This includes:
New Tables
 
Table
Name
Description
D1_CONTACT_COMM*
Contact Communication
Used to store customer communications, usually as part of an enrollment or unenrollment process
D1_CONTACT_COMM_CHAR*
Contact Communication Characteristics
Used to store characteristics associated with a customer communication
D1_CONTACT_COMM_K*
Contact Communication Key
Used to store primary keys associated with a customer communication
D1_CONTACT_COMM_LOG*
Contact Communication Log
Used to capture log details for a customer communication
D1_CONTACT_COMM_LOG_PARM*
Contact Communication Log Parameters
Used to capture log parameters for a customer communication
D1_CONTACT_COMM_REL_OBJ*
Contact Communication Related Object
Used to store related objects associated with a customer communication
* Used by Digital Asset Cloud Service
New Indexes
 
Table_Name
Index_Name
D1_CONTACT_COMM*
D1T653P0
D1_CONTACT_COMM*
D1T653S1
D1_CONTACT_COMM_CHAR*
D1T655P0
D1_CONTACT_COMM_CHAR*
D1T655S1
D1_CONTACT_COMM_K*
D1T654P0
D1_CONTACT_COMM_LOG*
D1T656P0
D1_CONTACT_COMM_LOG_PARM*
D1T657P0
D1_CONTACT_COMM_REL_OBJ*
D1T658P0
D1_DYN_OPT_EVENT*
D1T230S1
D1_DYN_OPT_EVENT*
D1T230S2
D1_DYN_OPT_EVENT*
D1T230S3
D1_GTT4
D1T407S0
D1_GTT7
D1T554S0
D1_GTT8
D1T555S0
* Used by Digital Asset Cloud Service
Deleted Indexes
 
Table_Name
Index_Name
D1_GTT4
D1T407P0
D1_GTT7
D1T554P0
D1_GTT8
D1T555P0
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
D1_DYN_OPT_QUESTION*
RESPONSE_REQ_FLG
CHAR
4
D1_DYN_OPT_QUESTION*
QUESTION_CATEGORY
VARCHAR2
254
D1_DYN_OPT_TYPE*
LOCATION_REQD_SOURCE_FLG
CHAR
4
D1_US*
PGM_ENRL_SRC_FLG
CHAR
4
D1_USAGE*
EXTRACT_FLG
CHAR
4
* Used by Digital Asset Cloud Service
Updated Columns
 
Table_Name
Column_Name
From
To
D1_DYN_OPT_QUESTION*
D1_ANSWER_CD
NOT NULL
NULLABLE
D1_GTT4
MAINT_OBJ_CD
NOT NULL
NULLABLE
D1_GTT4
D1_DEVICE_ID
NOT NULL
NULLABLE
D1_GTT4
D1_SP_ID
NOT NULL
NULLABLE
D1_GTT4
DEVICE_TYPE_CD
NOT NULL
NULLABLE
D1_GTT4
MSRMT_DTTM
NOT NULL
NULLABLE
D1_GTT7
D1_SP_ID
NOT NULL
NULLABLE
D1_GTT7
D1_SP_TYPE_CD
NOT NULL
NULLABLE
D1_GTT7
TIME_ZONE_CD
NOT NULL
NULLABLE
D1_GTT7
US_ID
NOT NULL
NULLABLE
D1_GTT7
US_TYPE_CD
NOT NULL
NULLABLE
D1_GTT8
D1_SP_ID
NOT NULL
NULLABLE
D1_GTT8
D1_QUANTITY1
NOT NULL
NULLABLE
D1_GTT8
D1_QUANTITY2
NOT NULL
NULLABLE
D1_GTT8
D1_QUANTITY3
NOT NULL
NULLABLE
D1_GTT8
D1_QUANTITY4
NOT NULL
NULLABLE
D1_GTT8
D1_QUANTITY5
NOT NULL
NULLABLE
D1_GTT8
US_ID
NOT NULL
NULLABLE
* Used by Digital Asset Cloud Service
Dropped Primary Keys
 
Table_Name
D1_GTT10
D1_GTT4
D1_GTT7
D1_GTT8
D1_GTT9