Work and Asset Management Database Changes
This chapter provides lists of database changes in the 25.4 release of Oracle Utilities Work and Asset Management included in the 25.4 release of Oracle Utilities Customer to Meter. It includes:
Note: The new tables, new indexes, new columns, modified columns, and dropped columns described in this chapter, as well as the Application Framework Database Changes, also apply to Oracle Utilities Operational Device Management.
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
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.
W1_BC_LINE_NOTE
Blanket Contract Line Note
Used to capture notes for blanket contract lines
*Used by Digital Asset Cloud Service
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
W1_ACT_RECON_COST_CENTER
W1_AMOUNT
NUMBER
18,7
W1_ACT_RECON_PROP_UNIT
COST_CENTER_CD
VARCHAR2
30
W1_ACT_RECON_PROP_UNIT
CU_USAGE_CD
VARCHAR2
30
W1_ASSET_TYPE
ASSET_NO_CAL_PREFIX_FLG
CHAR
4
W1_ASSET_TYPE
ASSET_NO_GEN_FLG
CHAR
4
W1_ASSET_TYPE
ASSET_NO_PREFIX
CHAR
4
W1_ASSET_TYPE
ASSET_NO_SEQ_LEN
NUMBER
2
W1_ASSET_TYPE
BADGE_NO_CAL_PREFIX_FLG
CHAR
4
W1_ASSET_TYPE
BADGE_NO_GEN_FLG
CHAR
4
W1_ASSET_TYPE
BADGE_NO_PREFIX
CHAR
4
W1_ASSET_TYPE
BADGE_NO_SEQ_LEN
NUMBER
2
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
W1_CMPL_EVT
CONSTR_LOC_ID
CHAR
14
W1_DESIGN_ELEMENT
BACK_LOG_GRP_FLG
CHAR
4
W1_WORK_LOC
SERVICE_AREA_CD
VARCHAR2
30
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
W1_BC_LINE_NOTE
BC_LINE_ID
CHAR
14
W1_BC_LINE_NOTE
NOTE_DTTM
DATE
7
W1_BC_LINE_NOTE
NOTE_TYPE_FLG
CHAR
4
W1_BC_LINE_NOTE
NOTE_VALUE
VARCHAR2
4000
W1_BC_LINE_NOTE
SEQNO
NUMBER
22
W1_BC_LINE_NOTE
USER_ID
CHAR
8
W1_BC_LINE_NOTE
VERSION
NUMBER
22
W1_TIMEKEEPER
OWNING_ACCESS_GRP_CD
CHAR
12
W1_ASSET_TYPE_ATTRIBUTE
ATT_SEQ_NUM
NUMBER
22
W1_ASSET_TYPE_SPEC_ATTRIBUTE
ATT_SEQ_NUM
NUMBER
22
W1_NODE
DESCRLONG
VARCHAR2
4000
* Used by Digital Asset Cloud Service
New Indexes
 
Table_Name
Index_Name
Column_Name
W1_ODC_DTL
W1T340S3
ACT_RESRC_REQMT_ID
W1_PO_LINE
W1T418S9
ACT_RESRC_REQMT_ID
W1_TIMESHEET_DETAIL
W1M595S4
ACT_RESRC_REQMT_ID
W1_DESIGN_ELEMENT_PLAN_SH_TYPE
W1T971P0
DESIGN_ELEMENT_ID
W1_DESIGN_ELEMENT_PLAN_SH_TYPE
W1T971P0
SVC_HIST_TYPE_CD
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
 
W1_ACTIVITY
W1T244S21
 
W1_BC_LINE_NOTE
W1T976P0
 
W1_BC_LINE_NOTE
W1T976P0
 
W1_DOCUMENT
W1M577S2
 
W1_MAT_RET_LINE
W1T400S2
 
* Used by Digital Asset Cloud Service
Other Database Changes
This release of Oracle Utilities Customer to Meter also includes the following database changes: