Work and Asset-Related Database Changes
This chapter provides lists of work and asset-related database changes in the 23C release of Oracle Utilities cloud services. This includes:
New Tables
 
Table
Name
Description
W1_DESIGN_ELEMENT_PLAN_SH_TYPE
Design Element Planned Service History
Used to capture planned service histories for template construction work activities
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
W1_DESIGN_ELEMENT
ACT_DURATION
NUMBER
22
W1_DESIGN_ELEMENT
UOT_FLG
CHAR
4
W1_DESIGN_ELEMENT_PLAN_SH_TYPE
DESIGN_ELEMENT_ID
CHAR
12
W1_DESIGN_ELEMENT_PLAN_SH_TYPE
SVC_HIST_TYPE_CD
VARCHAR2
30
W1_DESIGN_ELEMENT_PLAN_SH_TYPE
SVC_HIST_TYPE_REQ_FLG
CHAR
4
W1_DESIGN_ELEMENT_PLAN_SH_TYPE
VERSION
NUMBER
22
 
New Indexes
 
Table_Name
Index_Name
Column_Name
W1_DESIGN_ELEMENT_PLAN_SH_TYPE
W1T971P0
DESIGN_ELEMENT_ID
W1_DESIGN_ELEMENT_PLAN_SH_TYPE
W1T971P0
SVC_HIST_TYPE_CD