Work and Asset-Related Database Changes
This chapter provides lists of work and asset-related database changes in the 24B release of Oracle Utilities cloud services. This includes:
New Tables
 
Table
Name
Description
W1_ASSET_TYPE_SPEC_ATTRIBUTE
Asset Type Specification Attribute
Used to capture attributes for asset type specifications.
W1_NODE_ATTRIBUTE
Location Attribute
Used to capture attributes for locations.
W1_NODE_TYPE_ATTRIBUTE
Location Type Attributes
Used to capture attributes for location types.
W1_SPECIFICATION_ATTRIBUTE
Specification Attribute
Used to capture attributes for specifications.
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
W1_ACTIVITY
PERCENT_COMPLETE
NUMBER
22
W1_ASSET
ADDITIONAL_COST
NUMBER
22
W1_ASSET
ERP_PRJ_NUM
VARCHAR2
60
W1_ASSET
ERP_SUB_PRJ_NUM
VARCHAR2
60
W1_ASSET
MEMBER_ASSET_FLG
CHAR
4
W1_ASSET_TYPE_SPEC_ATTRIBUTE
ASSET_TYPE_CD
VARCHAR2
30
W1_ASSET_TYPE_SPEC_ATTRIBUTE
CHAR_TYPE_CD
CHAR
8
W1_ASSET_TYPE_SPEC_ATTRIBUTE
VERSION
NUMBER
22
W1_NODE_ATTRIBUTE
ADHOC_CHAR_VAL
VARCHAR2
254
W1_NODE_ATTRIBUTE
CHAR_TYPE_CD
CHAR
8
W1_NODE_ATTRIBUTE
CHAR_VAL
CHAR
16
W1_NODE_ATTRIBUTE
CHAR_VAL_FK1
VARCHAR2
50
W1_NODE_ATTRIBUTE
CHAR_VAL_FK2
VARCHAR2
50
W1_NODE_ATTRIBUTE
CHAR_VAL_FK3
VARCHAR2
50
W1_NODE_ATTRIBUTE
CHAR_VAL_FK4
VARCHAR2
50
W1_NODE_ATTRIBUTE
CHAR_VAL_FK5
VARCHAR2
50
W1_NODE_ATTRIBUTE
NODE_ID
CHAR
12
W1_NODE_ATTRIBUTE
SEQ_NUM
NUMBER
22
W1_NODE_ATTRIBUTE
SRCH_CHAR_VAL
VARCHAR2
50
W1_NODE_ATTRIBUTE
VERSION
NUMBER
22
W1_NODE_TYPE_ATTRIBUTE
CHAR_TYPE_CD
CHAR
8
W1_NODE_TYPE_ATTRIBUTE
NODE_TYPE_CD
VARCHAR2
30
W1_NODE_TYPE_ATTRIBUTE
VERSION
NUMBER
22
W1_SPECIFICATION_ATTRIBUTE
ADHOC_CHAR_VAL
VARCHAR2
254
W1_SPECIFICATION_ATTRIBUTE
CHAR_TYPE_CD
CHAR
8
W1_SPECIFICATION_ATTRIBUTE
CHAR_VAL
CHAR
16
W1_SPECIFICATION_ATTRIBUTE
CHAR_VAL_FK1
VARCHAR2
50
W1_SPECIFICATION_ATTRIBUTE
CHAR_VAL_FK2
VARCHAR2
50
W1_SPECIFICATION_ATTRIBUTE
CHAR_VAL_FK3
VARCHAR2
50
W1_SPECIFICATION_ATTRIBUTE
CHAR_VAL_FK4
VARCHAR2
50
W1_SPECIFICATION_ATTRIBUTE
CHAR_VAL_FK5
VARCHAR2
50
W1_SPECIFICATION_ATTRIBUTE
SEQ_NUM
NUMBER
22
W1_SPECIFICATION_ATTRIBUTE
SPECIFICATION_CD
VARCHAR2
30
W1_SPECIFICATION_ATTRIBUTE
SRCH_CHAR_VAL
VARCHAR2
50
W1_SPECIFICATION_ATTRIBUTE
VERSION
NUMBER
22
New Indexes
 
Table_Name
Index_Name
W1_ASSET_TYPE_SPEC_ATTRIBUTE
W1C972P0
W1_ASSET_TYPE_SPEC_ATTRIBUTE
W1C972P0
W1_CREW_SHIFT_ACT_SCHED
W1T311S1
W1_CREW_SHIFT_ACT_SCHED
W1T311S1
W1_NODE_ATTRIBUTE
W1M975P0
W1_NODE_ATTRIBUTE
W1M975P0
W1_NODE_ATTRIBUTE
W1M975P0
W1_NODE_ATTRIBUTE
W1M975S1
W1_NODE_ATTRIBUTE
W1M975S2
W1_NODE_ATTRIBUTE
W1M975S3
W1_NODE_ATTRIBUTE
W1M975S3
W1_NODE_ATTRIBUTE
W1M975S4
W1_NODE_ATTRIBUTE
W1M975S4
W1_NODE_TYPE_ATTRIBUTE
W1C974P0
W1_NODE_TYPE_ATTRIBUTE
W1C974P0
W1_RESRC_TYPE
W1M555S2
W1_SPECIFICATION_ATTRIBUTE
W1C973P0
W1_SPECIFICATION_ATTRIBUTE
W1C973P0
W1_SPECIFICATION_ATTRIBUTE
W1C973P0
W1_SPECIFICATION_ATTRIBUTE
W1C973S1
W1_SPECIFICATION_ATTRIBUTE
W1C973S2
W1_SPECIFICATION_ATTRIBUTE
W1C973S3
W1_SPECIFICATION_ATTRIBUTE
W1C973S3
W1_SPECIFICATION_ATTRIBUTE
W1C973S4
W1_SPECIFICATION_ATTRIBUTE
W1C973S4