Meter Data Management Database Changes

This chapter provides lists of database changes in the 25.4 release of Oracle Utilities Meter Data Management included with the 25.4 release of Oracle Utilities Customer to Meter. It includes:

• New Tables

• New Columns

• Dropped Columns

• Modified Columns

• New Indexes

• Dropped Indexes

• Renamed Indexes

• Dropped Primary Keys

• New Views

• Other Database Changes

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
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.
D1_IMD_CTRL_STAGE	IMD Control Staging	Used to stage IMD control records
D1_IMD_CTRL_STAGE_K	IMD Control Staging Key	Used to store keys for staged IMD control records
D1_IMD_TYPE	Initial Measurement Data Type	Used to capture details about types of initial measurement data
D1_IMD_TYPE_ALG	Initial Measurement Data Type Algorithm	Used to capture algorithms related to types of initial measurement data
D1_IMD_TYPE_L	Initial Measurement Data Type Language	Language table for Initial Measurement Data Type
D1_MSRMT_AUDIT	Measurement Audit	Used to capture changes made to measurement data
D1_RULE_PARM*	Rule Parameters	Used to capture parameters used by Digital Asset program rules
D1_SPR_PROG*	Service Provider Program	Used to capture relationship between Digital Asset service providers and programs
D1_DVC_ENTITY_GRP*	Device Entity Group	Used to define the relationship between a device and an entity group
D1_ENTITY_GRP*	Entity Group	Used to capture groups of entities (such as service points or devices)
D1_ENTITY_GRP_CHAR*	Entity Group Characteristics	Used to store characteristics related to a group of entities
D1_ENTITY_GRP_CRIT*	Entity Group Criteria	Used to store criteria used to define a group of entities
D1_ENTITY_GRP_CRIT_VAL*	Entity Group Criteria Value	Used to store criteria values used to define a group of entities
D1_ENTITY_GRP_L*	Entity Group Language	Used to store labels for the Entity Group table
D1_SP_ENTITY_GRP*	Service Point Entity Group	Used to define the relationship between a service point and an entity group

* 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
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
D1_USAGE_PERIOD_SQ	D1_PRICE*	NUMBER	19
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
D1_CONTACT	ADDRESS1	VARCHAR2	1016
D1_CONTACT	ADDRESS1_UPPER	VARCHAR2	1016
D1_CONTACT	ADDRESS2	VARCHAR2	1016
D1_CONTACT	ADDRESS3	VARCHAR2	1016
D1_CONTACT	ADDRESS4	VARCHAR2	1016
D1_CONTACT	CITY	VARCHAR2	360
D1_CONTACT	CITY_UPPER	VARCHAR2	360
D1_CONTACT	COUNTRY	CHAR	12
D1_CONTACT	COUNTY	VARCHAR2	360
D1_CONTACT	GEO_CODE	CHAR	44
D1_CONTACT	HOUSE_TYPE	CHAR	8
D1_CONTACT	IN_CITY_LIMIT	CHAR	4
D1_CONTACT	NUM1	CHAR	24
D1_CONTACT	NUM2	CHAR	16
D1_CONTACT	POSTAL	CHAR	48
D1_CONTACT	STATE	CHAR	24
D1_CONTACT_TYPE	CONTACT_USE_FLG	CHAR	16
D1_DVC	DER_AGG_SPR_CD*	VARCHAR2	120
D1_IMD_CTRL_STAGE	ALG_CD	CHAR	48
D1_IMD_CTRL_STAGE	D1_FROM_DTTM	DATE	7
D1_IMD_CTRL_STAGE	D1_TO_DTTM	DATE	7
D1_IMD_CTRL_STAGE	IMD_CTRL_DC_ID	CHAR	48
D1_IMD_CTRL_STAGE	IMD_CTRL_MC_ID	CHAR	48
D1_IMD_CTRL_STAGE	IMD_CTRL_STAGE_ID	CHAR	56
D1_IMD_CTRL_STAGE	IMD_STAGE_PAYLOAD_XML	CLOB	4000
D1_IMD_CTRL_STAGE	IMD_STAGE_STATUS_FLG	CHAR	16
D1_IMD_CTRL_STAGE	IMD_TYPE_CD	VARCHAR2	120
D1_IMD_CTRL_STAGE_K	ENV_ID	NUMBER	22
D1_IMD_CTRL_STAGE_K	IMD_CTRL_STAGE_ID	CHAR	56
D1_IMD_TYPE	BO_DATA_AREA	CLOB	4000
D1_IMD_TYPE	BUS_OBJ_CD	CHAR	120
D1_IMD_TYPE	IMD_BUS_OBJ_CD	CHAR	120
D1_IMD_TYPE	IMD_SEEDER_FLG	CHAR	16
D1_IMD_TYPE	IMD_TYPE_CD	VARCHAR2	120
D1_IMD_TYPE	IMD_TYPE_STATUS_FLG	CHAR	16
D1_IMD_TYPE	OWNER_FLG	CHAR	16
D1_IMD_TYPE	VERSION	NUMBER	22
D1_IMD_TYPE_ALG	ALG_CD	CHAR	48
D1_IMD_TYPE_ALG	ERROR_BO_STATUS_CD	CHAR	48
D1_IMD_TYPE_ALG	IMD_TYPE_ALG_STATUS_FLG	CHAR	16
D1_IMD_TYPE_ALG	IMD_TYPE_CD	VARCHAR2	120
D1_IMD_TYPE_ALG	IMD_TYPE_SEVT_FLG	CHAR	16
D1_IMD_TYPE_ALG	OWNER_FLG	CHAR	16
D1_IMD_TYPE_ALG	SEQ_NUM	NUMBER	22
D1_IMD_TYPE_ALG	VERSION	NUMBER	22
D1_IMD_TYPE_L	DESCR100	VARCHAR2	400
D1_IMD_TYPE_L	DESCRLONG	VARCHAR2	16000
D1_IMD_TYPE_L	IMD_TYPE_CD	VARCHAR2	120
D1_IMD_TYPE_L	LANGUAGE_CD	CHAR	12
D1_IMD_TYPE_L	OWNER_FLG	CHAR	16
D1_IMD_TYPE_L	VERSION	NUMBER	22
D1_MSRMT_AUDIT	COMBINED_MULTIPLIER	NUMBER	22
D1_MSRMT_AUDIT	LOG_DTTM	DATE	7
D1_MSRMT_AUDIT	MEASR_COMP_ID	CHAR	48
D1_MSRMT_AUDIT	MSRMT_AUDIT_ENTRY_TYPE_FLG	CHAR	16
D1_MSRMT_AUDIT	MSRMT_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	MSRMT_DTTM	DATE	7
D1_MSRMT_AUDIT	MSRMT_USE_FLG	CHAR	16
D1_MSRMT_AUDIT	MSRMT_VAL	NUMBER	22
D1_MSRMT_AUDIT	PREVEE_MSRMT_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	PREVEE_MSRMT_VAL	NUMBER	22
D1_MSRMT_AUDIT	PREVEE_READING_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	PREVEE_READING_VAL	NUMBER	22
D1_MSRMT_AUDIT	PREV_MSRMT_DTTM	DATE	7
D1_MSRMT_AUDIT	READING_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	READING_VAL	NUMBER	22
D1_MSRMT_AUDIT	SEQNO	NUMBER	22
D1_MSRMT_AUDIT	USER_ID	CHAR	32
D1_NW_LOC	NETWORK_NODE_1	CHAR	56
D1_NW_LOC	NETWORK_NODE_2	CHAR	56
D1_RULE_PARM	CALC_FREQUENCY*	VARCHAR2	1016
D1_RULE_PARM	D1_SEASONAL_FLG*	CHAR	16
D1_RULE_PARM	ELIG_ALG_CD*	CHAR	48
D1_RULE_PARM	LINE_EXT_ID*	VARCHAR2	1016
D1_RULE_PARM	MIN_DAYS*	NUMBER	22
D1_RULE_PARM	PRORATE_OPTION_FLG*	CHAR	16
D1_RULE_PARM	RULE_CD*	VARCHAR2	120
D1_RULE_PARM	RULE_TYPE_CATEGORY*	VARCHAR2	1016
D1_RULE_PARM	SEASON_END*	CHAR	16
D1_RULE_PARM	SEASON_START*	CHAR	16
D1_RULE_PARM	SEQNO*	NUMBER	22
D1_RULE_PARM	SETT_FREQ_FLG*	CHAR	16
D1_RULE_PARM	USG_GRP_CD*	VARCHAR2	120
D1_RULE_PARM	VERSION*	NUMBER	22
D1_SPR	ACTIVE_INACTIVE_FLG*	CHAR	16
D1_SPR	CONTACT_ID*	CHAR	48
D1_SPR	END_DT*	DATE	7
D1_SPR	START_DT*	DATE	7
D1_SPR_PROG	D1_SPR_CD*	VARCHAR2	120
D1_SPR_PROG	DYN_OPT_ID*	CHAR	48
D1_SPR_PROG	END_DT*	DATE	7
D1_SPR_PROG	SPR_LFDI*	VARCHAR2	1016
D1_SPR_PROG	START_DT*	DATE	7
D1_USAGE	RULE_CD*	VARCHAR2	120
D1_USAGE	RULE_TYPE_CATEGORY*	VARCHAR2	1016
D1_DVC_ENTITY_GRP*	BO_DATA_AREA	CLOB	4000
D1_DVC_ENTITY_GRP*	D1_DEVICE_ID	CHAR	48
D1_DVC_ENTITY_GRP*	EFF_DTTM	DATE	7
D1_DVC_ENTITY_GRP*	ENTITY_GRP_CD	VARCHAR2	120
D1_DVC_ENTITY_GRP*	EXPIRATION_DTTM	DATE	7
D1_DVC_ENTITY_GRP*	VERSION	NUMBER	22
D1_ENTITY_GRP*	BO_DATA_AREA	CLOB	4000
D1_ENTITY_GRP*	BUS_OBJ_CD	CHAR	120
D1_ENTITY_GRP*	ENTITY_GRP_ASSGN_OPT_FLG	CHAR	16
D1_ENTITY_GRP*	ENTITY_GRP_CATEGORY	VARCHAR2	1016
D1_ENTITY_GRP*	ENTITY_GRP_CD	VARCHAR2	120
D1_ENTITY_GRP*	ENTITY_GRP_DEACT_OPT_FLG	CHAR	16
D1_ENTITY_GRP*	ENTITY_GRP_STAT_FLG	CHAR	16
D1_ENTITY_GRP*	VERSION	NUMBER	22
D1_ENTITY_GRP_CHAR*	ADHOC_CHAR_VAL	VARCHAR2	1016
D1_ENTITY_GRP_CHAR*	CHAR_TYPE_CD	CHAR	32
D1_ENTITY_GRP_CHAR*	CHAR_VAL	CHAR	64
D1_ENTITY_GRP_CHAR*	CHAR_VAL_FK1	VARCHAR2	200
D1_ENTITY_GRP_CHAR*	CHAR_VAL_FK2	VARCHAR2	200
D1_ENTITY_GRP_CHAR*	CHAR_VAL_FK3	VARCHAR2	200
D1_ENTITY_GRP_CHAR*	CHAR_VAL_FK4	VARCHAR2	200
D1_ENTITY_GRP_CHAR*	CHAR_VAL_FK5	VARCHAR2	200
D1_ENTITY_GRP_CHAR*	ENTITY_GRP_CD	VARCHAR2	120
D1_ENTITY_GRP_CHAR*	SEQ_NUM	NUMBER	22
D1_ENTITY_GRP_CHAR*	SRCH_CHAR_VAL	VARCHAR2	200
D1_ENTITY_GRP_CHAR*	VERSION	NUMBER	22
D1_ENTITY_GRP_CRIT*	CRITERIA_SEQ_NUM	NUMBER	22
D1_ENTITY_GRP_CRIT*	ENTITY_GRP_CD	VARCHAR2	120
D1_ENTITY_GRP_CRIT*	GRP_CRITERIA_SRC	VARCHAR2	1016
D1_ENTITY_GRP_CRIT*	VERSION	NUMBER	22
D1_ENTITY_GRP_CRIT_VAL*	BO_DATA_AREA	CLOB	4000
D1_ENTITY_GRP_CRIT_VAL*	CRITERIA_SEQ_NUM	NUMBER	22
D1_ENTITY_GRP_CRIT_VAL*	CRITERIA_VALUE	CHAR	200
D1_ENTITY_GRP_CRIT_VAL*	CRITERIA_VAL_SEQ_NUM	NUMBER	22
D1_ENTITY_GRP_CRIT_VAL*	ENTITY_GRP_CD	VARCHAR2	120
D1_ENTITY_GRP_CRIT_VAL*	GRP_CRITERIA_SRC	VARCHAR2	1016
D1_ENTITY_GRP_CRIT_VAL*	VERSION	NUMBER	22
D1_ENTITY_GRP_L*	DESCR100	VARCHAR2	400
D1_ENTITY_GRP_L*	DESCRLONG	VARCHAR2	16000
D1_ENTITY_GRP_L*	ENTITY_GRP_CD	VARCHAR2	120
D1_ENTITY_GRP_L*	LANGUAGE_CD	CHAR	12
D1_ENTITY_GRP_L*	VERSION	NUMBER	22
D1_MEASR_COMP_TYPE	IMD_HANDLING_FLG	CHAR	16
D1_MSRMT	PREVEE_MSRMT_COND_FLG	CHAR	24
D1_MSRMT	PREVEE_MSRMT_VAL	NUMBER	22
D1_MSRMT	PREVEE_READING_COND_FLG	CHAR	24
D1_MSRMT	PREVEE_READING_VAL	NUMBER	22
D1_MSRMT	USER_ID	CHAR	32
D1_MSRMT_AUDIT	AFTER_COMBINED_MULTIPLIER	NUMBER	22
D1_MSRMT_AUDIT	AFTER_MSRMT_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	AFTER_MSRMT_USE_FLG	CHAR	16
D1_MSRMT_AUDIT	AFTER_MSRMT_VAL	NUMBER	22
D1_MSRMT_AUDIT	AFTER_PREVEE_MSRMT_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	AFTER_PREVEE_MSRMT_VAL	NUMBER	22
D1_MSRMT_AUDIT	AFTER_PREVEE_READING_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	AFTER_PREVEE_READING_VAL	NUMBER	22
D1_MSRMT_AUDIT	AFTER_PREV_MSRMT_DTTM	DATE	7
D1_MSRMT_AUDIT	AFTER_READING_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	AFTER_READING_VAL	NUMBER	22
D1_MSRMT_AUDIT	BEFORE_COMBINED_MULTIPLIER	NUMBER	22
D1_MSRMT_AUDIT	BEFORE_MSRMT_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	BEFORE_MSRMT_USE_FLG	CHAR	16
D1_MSRMT_AUDIT	BEFORE_MSRMT_VAL	NUMBER	22
D1_MSRMT_AUDIT	BEFORE_PREVEE_MSRMT_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	BEFORE_PREVEE_MSRMT_VAL	NUMBER	22
D1_MSRMT_AUDIT	BEFORE_PREVEE_READING_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	BEFORE_PREVEE_READING_VAL	NUMBER	22
D1_MSRMT_AUDIT	BEFORE_PREV_MSRMT_DTTM	DATE	7
D1_MSRMT_AUDIT	BEFORE_READING_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	BEFORE_READING_VAL	NUMBER	22
D1_SPR_PROG	UTILITY_APPROVAL_REQD_FLG	CHAR	16
D1_SP_ENTITY_GRP*	BO_DATA_AREA	CLOB	4000
D1_SP_ENTITY_GRP*	D1_SP_ID	CHAR	48
D1_SP_ENTITY_GRP*	EFF_DTTM	DATE	7
D1_SP_ENTITY_GRP*	ENTITY_GRP_CD	VARCHAR2	120
D1_SP_ENTITY_GRP*	EXPIRATION_DTTM	DATE	7
D1_SP_ENTITY_GRP*	VERSION	NUMBER	22

* Used by Digital Asset Cloud Service

Dropped Columns

Table_Name	Column_Name	Data Type	Data Length
D1_EVT_PARTICIPATION	EFF_DTTM	DATE
D1_MSRMT_AUDIT	COMBINED_MULTIPLIER	NUMBER	22
D1_MSRMT_AUDIT	MSRMT_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	MSRMT_USE_FLG	CHAR	16
D1_MSRMT_AUDIT	MSRMT_VAL	NUMBER	22
D1_MSRMT_AUDIT	PREVEE_MSRMT_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	PREVEE_MSRMT_VAL	NUMBER	22
D1_MSRMT_AUDIT	PREVEE_READING_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	PREVEE_READING_VAL	NUMBER	22
D1_MSRMT_AUDIT	PREV_MSRMT_DTTM	DATE	7
D1_MSRMT_AUDIT	READING_COND_FLG	CHAR	24
D1_MSRMT_AUDIT	READING_VAL	NUMBER	22

Modified Columns

Table_Name	Column_Name	Old Length	New Length
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
D1_USAGE_SCALAR_DTL	USE_PERCENT	Number (9,6)	Number (5,2)
D1_US_SP	USE_PERCENT	Number (9,6)	Number (5,2)

* Used by Digital Asset Cloud Service

New Indexes

Table_Name	Index_Name
D1_GTT4	D1T407S0
D1_GTT7	D1T554S0
D1_GTT8	D1T555S0
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_DYN_OPT_QTY	D1M659P0
D1_DYN_OPT_TYPE_QTY_TYPE	D1C660P0
D1_CONTACT	D1M180S0
D1_IMD_CTRL_STAGE	D1T661P0
D1_IMD_CTRL_STAGE	D1T661S0
D1_IMD_CTRL_STAGE	D1T661S1
D1_IMD_CTRL_STAGE_K	D1T663P0
D1_IMD_TYPE	D1C664P0
D1_IMD_TYPE_ALG	D1C666P0
D1_IMD_TYPE_L	D1C665P0
D1_MSRMT_AUDIT	D1T662P0
D1_RULE_PARM	D1C667P0
D1_SPR_PROG	D1C668P0
D1_DVC_ENTITY_GRP	D1M674P0
D1_DVC_ENTITY_GRP	D1M674S0
D1_ENTITY_GRP	D1C675P0
D1_ENTITY_GRP_CHAR	D1C670P0
D1_ENTITY_GRP_CRIT	D1C671P0
D1_ENTITY_GRP_CRIT_VAL	D1C672P0
D1_ENTITY_GRP_L	D1C669P0
D1_SP_ENTITY_GRP	D1M673P0
D1_SP_ENTITY_GRP	D1M673S0

* Used by Digital Asset Cloud Service

Dropped Indexes

Table_Name	Index_Name
D1_GTT4	D1T407P0
D1_GTT7	D1T554P0
D1_GTT8	D1T555P0

Renamed Indexes

Table_Name	Old_Index_Name	New_Index_Name
D1_DYN_OPT_TYPE_QTY_TYPE	D1660CP0	D1C660P0

Dropped Primary Keys

Table_Name

D1_GTT10

D1_GTT4

D1_GTT7

D1_GTT8

D1_GTT9

New Views

View_Name

D1_MC_TYPE_PER_EST_EVAL_VW

Other Database Changes

This release of Oracle Utilities Customer to Meter also includes the following database changes:

• Customer Care and Billing Database Changes

• Work and Asset Management Database Changes

• Application Framework Database Changes