Work and Asset-Related Database Changes
This chapter provides lists of work and asset-related database changes in the 22C release of Oracle Utilities cloud services. This includes:
New Tables
 
Table
Name
Description
W1_CU_CU_USAGE
Compatible Unit CU Usage
Used to store configuration data related to compatible units usage
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
W1_ACTIVITY
ACT_DURATION
NUMBER
22
W1_ACTIVITY
UOT_FLG
CHAR
4
W1_ACTIVITY_TYPE
ACT_DURATION
NUMBER
22
W1_ACTIVITY_TYPE
UOT_FLG
CHAR
4
W1_ASSET
ASSET_AVAILABILITY_FLG*
CHAR
1
W1_AST_DERMS_EVTCTL_CSTHIST
ASSET_AVAILABILITY_FLG*
CHAR
1
W1_CU_CU_USAGE
CU_ID
CHAR
12
W1_CU_CU_USAGE
CU_USAGE_CD
VARCHAR2
30
W1_CU_CU_USAGE
VERSION
NUMBER
22
W1_OVERHEAD
ADJUSTMENT_TYPE_CD
VARCHAR2
30
W1_OVERHEAD_RESRC
ADJUSTMENT_TYPE_CD
VARCHAR2
30
W1_TMPL_ACT
ACT_DURATION
NUMBER
22
W1_TMPL_ACT
UOT_FLG
CHAR
4
* Used by Digital Asset Cloud Service
Modified Columns
 
Table_Name
Column_Name
New Data Type
Old Precision
New Precision
W1_BC_LINE
PI_RATIO
NUMBER
3
8
New Indexes
 
Table_Name
Index_Name
Column_Name
W1_COMPLIANCE_TYPE_CHAR
W1C845S1
SRCH_CHAR_VAL
W1_CU
W1M746S3
ASSET_TYPE_CD
W1_CU_CU_USAGE
W1M968P0
CU_ID
W1_CU_CU_USAGE
W1M968P0
CU_USAGE_CD
W1_CU_SET
W1C757S1
CU_SET_CD
W1_CU_SET
W1C757S1
EQUIP_GROUP_CD
W1_DESIGN_ELEMENT_CHAR
W1M799S1
SRCH_CHAR_VAL
W1_DESIGN_ELEMENT_LOG
W1M801S1
CHAR_TYPE_CD
W1_DESIGN_ELEMENT_LOG
W1M801S1
CHAR_VAL_FK1
W1_DESIGN_ELEMENT_LOG
W1M801S2
CHAR_TYPE_CD
W1_DESIGN_ELEMENT_LOG
W1M801S2
CHAR_VAL
W1_EQUIP_GROUP
W1C768S1
CU_CATEGORY_CD
W1_FT
W1T312S1
ACT_ID
W1_PR_HDR
W1T434S6
BUYER_CD
W1_WORK_DESIGN_CHAR
W1M790S1
SRCH_CHAR_VAL
W1_WORK_DESIGN_LOG
W1M792S1
CHAR_TYPE_CD
W1_WORK_DESIGN_LOG
W1M792S1
CHAR_VAL_FK1
W1_WORK_DESIGN_LOG
W1M792S2
CHAR_TYPE_CD
W1_WORK_DESIGN_LOG
W1M792S2
CHAR_VAL