Customer-Related Database Changes

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

New Tables

Table	Name	Description
C1_OUTAGE_EVT	Outage Event	Used to capture outage events
C1_OUTAGE_EVT_CHAR	Outage Event Characteristics	Used to store characteristic values related to outage events

New Columns

Table_Name	Column_Name	Data Type	Data Length
C1_OUTAGE_EVT	BO_STATUS_CD	CHAR	12
C1_OUTAGE_EVT	BO_XML_DATA_AREA	XML	1073741824
C1_OUTAGE_EVT	BUS_OBJ_CD	CHAR	30
C1_OUTAGE_EVT	EXT_EVENT_ID	VARC	254
C1_OUTAGE_EVT	ILM_ARCH_SW	CHAR	1
C1_OUTAGE_EVT	ILM_DT	DATE	10
C1_OUTAGE_EVT	IMP_CUST_NBR	NUMB	9,0
C1_OUTAGE_EVT	MESSAGE_REF	VARC	254
C1_OUTAGE_EVT	NT_XID_CD	CHAR	30
C1_OUTAGE_EVT	OTG_END_DTTM	DTTM	26
C1_OUTAGE_EVT	OTG_ERT_DTTM	DTTM	26
C1_OUTAGE_EVT	OTG_EVENT_ID	CHAR	14
C1_OUTAGE_EVT	OTG_START_DTTM	DTTM	26
C1_OUTAGE_EVT	OTG_TYPE_FLG	CHAR	4
C1_OUTAGE_EVT	UPD_DTTM	DTTM	26
C1_OUTAGE_EVT	VERSION	NUMB	5,0
C1_OUTAGE_EVT_CHAR	ADHOC_CHAR_VAL	VARC	254
C1_OUTAGE_EVT_CHAR	CHAR_TYPE_CD	CHAR	8
C1_OUTAGE_EVT_CHAR	CHAR_VAL	CHAR	16
C1_OUTAGE_EVT_CHAR	CHAR_VAL_FK1	VARC	50
C1_OUTAGE_EVT_CHAR	CHAR_VAL_FK2	VARC	50
C1_OUTAGE_EVT_CHAR	CHAR_VAL_FK3	VARC	50
C1_OUTAGE_EVT_CHAR	CHAR_VAL_FK4	VARC	50
C1_OUTAGE_EVT_CHAR	CHAR_VAL_FK5	VARC	50
C1_OUTAGE_EVT_CHAR	OTG_EVENT_ID	CHAR	14
C1_OUTAGE_EVT_CHAR	SEQ_NUM	NUMB	3,0
C1_OUTAGE_EVT_CHAR	SRCH_CHAR_VAL	VARC	50
C1_OUTAGE_EVT_CHAR	VERSION	NUMB	5,0
CI_CC	CC_SRC_FLG	CHAR	4
CI_CC	CC_SUMMARY	VARC	4000

New Indexes