Work and Asset-Related Database Changes
This chapter provides lists of work and asset-related database changes in the 22B release of Oracle Utilities cloud services. This includes:
New Tables
 
Table
Name
Description
W1_AST_DERMS_EVTCTL_CSTHIST*
Asset DERMS Event Control History
Used to store the control score history for an asset.
W1_DESIGN_ELEMENT_CHKLST_TYP
Design Element Checklist Type
Used to store General and Permit Required Checklist Types against the Design Element to be created when a Template Construction Work Order creates a Construction Activity.
W1_DESIGN_ELEMENT_DEP
Design Element Dependency
Used to store Construction Activity Dependencies against the Design Element to be created when a Template Construction Work Order creates a Construction Activity. The Dependencies would need to be within the Template Construction Activities of the same Template Construction Work Order.
*Used by Digital Asset Cloud Service
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
W1_ASSET
CST_SCORE*
NUMBER
22
W1_ASSET
CST_SCR_DTTM*
DATE
7
W1_AST_DERMS_EVTCTL_CSTHIST
ASSET_ID*
CHAR
48
W1_AST_DERMS_EVTCTL_CSTHIST
CST_SCORE*
NUMBER
22
W1_AST_DERMS_EVTCTL_CSTHIST
VERSION*
NUMBER
22
W1_AST_DERMS_EVTCTL_CSTHIST
W1_DYN_OPT_EVENT_ID*
CHAR
56
W1_DESIGN_ELEMENT
ACT_TYPE_CD
VARCHAR2
120
W1_DESIGN_ELEMENT
PLANNER_CD
VARCHAR2
120
W1_DESIGN_ELEMENT
SERVICE_CLASS_CD
VARCHAR2
120
W1_DESIGN_ELEMENT
W1_CREW_ID
CHAR
48
W1_DESIGN_ELEMENT
WORK_CATEGORY_CD
VARCHAR2
120
W1_DESIGN_ELEMENT
WORK_CLASS_CD
VARCHAR2
120
W1_DESIGN_ELEMENT
WORK_PRIORITY_FLG
CHAR
16
W1_DESIGN_ELEMENT_CHKLST_TYP
CHECKLIST_TYPE_CD
VARCHAR2
120
W1_DESIGN_ELEMENT_CHKLST_TYP
DESIGN_ELEMENT_ID
CHAR
48
W1_DESIGN_ELEMENT_CHKLST_TYP
VERSION
NUMBER
22
W1_DESIGN_ELEMENT_DEP
DESIGN_ELEMENT_ID
CHAR
48
W1_DESIGN_ELEMENT_DEP
PRED_DESIGN_ELEMENT_ID
CHAR
48
W1_DESIGN_ELEMENT_DEP
RESOURCE_OPTION_FLG
CHAR
16
W1_DESIGN_ELEMENT_DEP
TIMING_OPTION_FLG
CHAR
16
W1_DESIGN_ELEMENT_DEP
VERSION
NUMBER
22
W1_DESIGN_ELEMENT_DEP
W1_MAX_OFFSET
NUMBER
22
W1_DESIGN_ELEMENT_DEP
W1_MIN_OFFSET
NUMBER
22
W1_STOCK_ITEM_DTL
ORDER_ON_DEMAND_FLG
CHAR
16
W1_SVC_HIST
W1_DYN_OPT_EVENT_ID*
CHAR
56
W1_WORK_DESIGN
W1_CREW_ID
CHAR
48
W1_WORK_DESIGN
WD_SUBCLASS_FLG
CHAR
16
W1_WORK_DESIGN
WORK_CATEGORY_CD
VARCHAR2
120
W1_WORK_DESIGN
WORK_CLASS_CD
VARCHAR2
120
W1_WORK_DESIGN
WORK_PRIORITY_FLG
CHAR
16
W1_WORK_DESIGN
WO_BUS_OBJ_CD
VARCHAR2
120
* Used by Digital Asset Cloud Service
New Indexes
 
Table_Name
Index_Name
Column_Name
W1_ACT_CONSTR_LOC
W1T780S1
ACT_ID
W1_APPROVAL_PROF
W1C556S1
BUS_OBJ_CD
W1_APPROVAL_PROF
W1C556S1
MAINT_OBJ_CD
W1_AST_DERMS_EVTCTL_CSTHIST
W1M967P0*
ASSET_ID
W1_AST_DERMS_EVTCTL_CSTHIST
W1M967P0*
W1_DYN_OPT_EVENT_ID
W1_DESIGN_ELEMENT_CHKLST_TYP
W1T966P0
CHECKLIST_TYPE_CD
W1_DESIGN_ELEMENT_CHKLST_TYP
W1T966P0
DESIGN_ELEMENT_ID
W1_DESIGN_ELEMENT_DEP
W1T965P0
DESIGN_ELEMENT_ID
W1_DESIGN_ELEMENT_DEP
W1T965P0
PRED_DESIGN_ELEMENT_ID
W1_EMPLOYEE
W1M500S5
EMPLOYEE_USER_ID
W1_EMPLOYEE
W1M500S6
SUPERVISOR_ID
W1_RR
W1T405S2
STOCK_ITEM_DTL_ID
W1_TIMEKEEPER
W1C948S1
USER_ID
* Used by Digital Asset Cloud Service