Meter-Related Database Changes

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

• New Tables

• New Columns

• New Indexes

New Tables

Table	Name	Description
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

* Used by Digital Asset Cloud Service

New Columns

Table_Name	Column_Name	Data Type	Data Length
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

* Used by Digital Asset Cloud Service

New Indexes

Table_Name	Index_Name
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

Renamed Indexes

Table_Name	Old_Index_Name	New_Index_Name
D1_DYN_OPT_TYPE_QTY_TYPE	D1660CP0	D1C660P0