3 Meter-Related Database Changes

This chapter provides lists of meter-related database changes in the 26.4 release of Oracle Utilities cloud services. This includes:

New Tables

Table Name Description
D1_GTT11* Entity Group Constituents Temporary Table Used to store measuring components for aggregation for entity groups, such as Device Population groups and Control groups used with Customer Program Management Event Impact Measurement and Verification.
D1_SP_EVT_OUTCOME_K* Service Point Event Outcome Key Used to store keys used with service point outcome snapshot records.

* Used by Customer Program Management Cloud Service

New Columns

Table_Name Column_Name Data Type Length
D1_GTT11 DEVICE_CONFIG_ID* CHAR 48
D1_GTT11 END_DTTM* DATE 7
D1_GTT11 ENTITY_GRP_CD* VARCHAR2 120
D1_GTT11 INSTALL_EVT_ID* CHAR 48
D1_GTT11 MEASR_COMP_ID* CHAR 48
D1_GTT11 START_DTTM* DATE 7
D1_GTT11 TIME_ZONE_CD* CHAR 40
D1_GTT11 TREATMENT_IND* NUMBER 22
D1_GTT11 US_ID* CHAR 48
D1_ML_MEASR_COMP_VW D1_SP_ID CHAR 48
D1_ML_MEASR_COMP_VW D1_UOM_CD VARCHAR2 120
D1_ML_MEASR_COMP_VW DEVICE_CONFIG_ID CHAR 48
D1_ML_MEASR_COMP_VW EFFECTIVE_END_DTTM DATE 7
D1_ML_MEASR_COMP_VW EFFECTIVE_START_DTTM DATE 7
D1_ML_MEASR_COMP_VW INSTALL_EVT_ID CHAR 48
D1_ML_MEASR_COMP_VW INTERVAL_SCALAR_FLG CHAR 16
D1_ML_MEASR_COMP_VW MEASR_COMP_ID CHAR 48
D1_ML_MEASR_COMP_VW MEASR_COMP_TYPE_CD VARCHAR2 120
D1_ML_MEASR_COMP_VW POSTAL CHAR 48
D1_ML_MEASR_COMP_VW SEC_PER_INTRVL NUMBER 22
D1_ML_MEASR_COMP_VW TIME_ZONE_CD CHAR 40
D1_SP_ENTITY_GRP_VW CONST_LEGAL_END_DTTM DATE 7
D1_SP_ENTITY_GRP_VW CONST_LEGAL_START_DTTM DATE 7
D1_SP_ENTITY_GRP_VW D1_DEVICE_ID CHAR 48
D1_SP_ENTITY_GRP_VW D1_SP_ID CHAR 48
D1_SP_ENTITY_GRP_VW D1_SQI_CD VARCHAR2 120
D1_SP_ENTITY_GRP_VW D1_TOU_CD VARCHAR2 120
D1_SP_ENTITY_GRP_VW D1_UOM_CD VARCHAR2 120
D1_SP_ENTITY_GRP_VW DEVICE_CONFIG_ID CHAR 48
D1_SP_ENTITY_GRP_VW ENTITY_GRP_CD VARCHAR2 120
D1_SP_ENTITY_GRP_VW F1_TIMEZONE_NAME VARCHAR2 200
D1_SP_ENTITY_GRP_VW INSTALL_EVT_ID CHAR 48
D1_SP_ENTITY_GRP_VW INTERVAL_SCALAR_FLG CHAR 16
D1_SP_ENTITY_GRP_VW MEASR_COMP_ID CHAR 48
D1_SP_ENTITY_GRP_VW MEASR_COMP_TYPE_CD VARCHAR2 120
D1_SP_ENTITY_GRP_VW MEASR_COMP_USAGE_FLG CHAR 16
D1_SP_ENTITY_GRP_VW MOST_RECENT_MSRMT_DTTM DATE 7
D1_SP_ENTITY_GRP_VW MSR_PEAK_QTY_FLG CHAR 16
D1_SP_ENTITY_GRP_VW NAME_VALUE VARCHAR2 1016
D1_SP_ENTITY_GRP_VW POSTAL CHAR 48
D1_SP_ENTITY_GRP_VW SEC_PER_INTRVL NUMBER 22
D1_SP_ENTITY_GRP_VW SP_ADDRESS VARCHAR2 4064
D1_SP_ENTITY_GRP_VW TIME_ZONE_CD CHAR 40
D1_SP_ENTITY_GRP_VW US_ID CHAR 48
D1_SP_ENTITY_GRP_VW VALUE_ID_TYPE_FLG CHAR 16
D1_SP_EVT_OUTCOME_K ENV_ID* NUMBER 22
D1_SP_EVT_OUTCOME_K SP_EVT_OUTCOME_ID* CHAR 56

* Used by Customer Program Management Cloud Service

Updated Columns

Table_Name Column_Name Old New
D1_USAGE_PERIOD PERIOD_SEQ_NUM NUMBER 3 NUMBER 5

New Indexes

Table_Name Index_Name
D1_GTT11 D1T692P0
D1_SP_EVT_OUTCOME D1T689P0
D1_SP_EVT_OUTCOME D1T689S1
D1_SP_EVT_OUTCOME D1T689S2
D1_SP_EVT_OUTCOME_CHAR D1T687P0
D1_SP_EVT_OUTCOME_CHAR D1T687S1
D1_SP_EVT_OUTCOME_K D1T693P0
D1_SP_EVT_OUTCOME_LOG D1T690P0
D1_SP_EVT_OUTCOME_LOG_PARM D1T691P0
D1_SP_EVT_OUTCOME_QTY D1T686P0

Dropped Indexes

Table_Name Index_Name
D1_SP_EVT_OUTCOME D1M689P0
D1_SP_EVT_OUTCOME_CHAR D1M687P0
D1_SP_EVT_OUTCOME_LOG D1M690P0
D1_SP_EVT_OUTCOME_LOG_PARM D1M691P0
D1_SP_EVT_OUTCOME_QTY D1M686P0

New Views

View_Name Description Notes
D1_ML_MEASR_COMP_VW ML Measuring Component View  
D1_SP_ENTITY_GRP_VW SP Entity Group View