Upgrading from Oracle Utilities Meter Data Management V2.5.0.1.1 to V25.4

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 Indexes

Table_Name	Index_Name
D1_GTT4	D1T407P0
D1_GTT7	D1T554P0
D1_GTT8	D1T555P0
D1_EVT_PARTICIPATION	D1T652S1*
D1_EVT_PARTICIPATION	D1T639S2*
D1_EVT_PARTICIPATION	D1T639S3*
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
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

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

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

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

Dropped Indexes

Table_Name	Index_Name
D1_GTT4	D1T407S0
D1_GTT7	D1T554S0
D1_GTT8	D1T555S0
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