Oracle Utilities Work and Asset Management V2.4.0.1.1 to V25.4
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
New Columns
Table_Name
Column_Name
Data Type
Data Length
W1_ACTIVITY
PERCENT_COMPLETE
NUMBER
22
W1_ACT_RECON_COST_CENTER
W1_AMOUNT
NUMBER
22
W1_ACT_RECON_PROP_UNIT
COST_CENTER_CD
VARCHAR2
120
W1_ACT_RECON_PROP_UNIT
CU_USAGE_CD
VARCHAR2
120
W1_ASSET
ADDITIONAL_COST
NUMBER
22
W1_ASSET
ERP_PRJ_NUM
VARCHAR2
240
W1_ASSET
ERP_SUB_PRJ_NUM
VARCHAR2
240
W1_ASSET
MEMBER_ASSET_FLG
CHAR
16
W1_ASSET_TYPE
ASSET_NO_CAL_PREFIX_FLG
CHAR
16
W1_ASSET_TYPE
ASSET_NO_GEN_FLG
CHAR
16
W1_ASSET_TYPE
ASSET_NO_PREFIX
CHAR
16
W1_ASSET_TYPE
ASSET_NO_SEQ_LEN
NUMBER
22
W1_ASSET_TYPE
BADGE_NO_CAL_PREFIX_FLG
CHAR
16
W1_ASSET_TYPE
BADGE_NO_GEN_FLG
CHAR
16
W1_ASSET_TYPE
BADGE_NO_PREFIX
CHAR
16
W1_ASSET_TYPE
BADGE_NO_SEQ_LEN
NUMBER
22
W1_ASSET_TYPE_ATTRIBUTE
ATT_SEQ_NUM
NUMBER
22
W1_ASSET_TYPE_SPEC_ATTRIBUTE
ASSET_TYPE_CD
VARCHAR2
120
W1_ASSET_TYPE_SPEC_ATTRIBUTE
ATT_SEQ_NUM
NUMBER
22
W1_ASSET_TYPE_SPEC_ATTRIBUTE
CHAR_TYPE_CD
CHAR
32
W1_ASSET_TYPE_SPEC_ATTRIBUTE
VERSION
NUMBER
22
W1_BC_LINE_NOTE
BC_LINE_ID
CHAR
56
W1_BC_LINE_NOTE
NOTE_DTTM
DATE
7
W1_BC_LINE_NOTE
NOTE_TYPE_FLG
CHAR
16
W1_BC_LINE_NOTE
NOTE_VALUE
VARCHAR2
16000
W1_BC_LINE_NOTE
SEQNO
NUMBER
22
W1_BC_LINE_NOTE
USER_ID
CHAR
32
W1_BC_LINE_NOTE
VERSION
NUMBER
22
W1_CMPL_EVT
CONSTR_LOC_ID
CHAR
56
W1_DESIGN_ELEMENT
ACT_DURATION
NUMBER
22
W1_DESIGN_ELEMENT
BACK_LOG_GRP_FLG
CHAR
16
W1_DESIGN_ELEMENT
UOT_FLG
CHAR
16
W1_DESIGN_ELEMENT_PLAN_SH_TYPE
DESIGN_ELEMENT_ID
CHAR
48
W1_DESIGN_ELEMENT_PLAN_SH_TYPE
SVC_HIST_TYPE_CD
VARCHAR2
120
W1_DESIGN_ELEMENT_PLAN_SH_TYPE
SVC_HIST_TYPE_REQ_FLG
CHAR
16
W1_DESIGN_ELEMENT_PLAN_SH_TYPE
VERSION
NUMBER
22
W1_NODE
DESCRLONG
VARCHAR2
16000
W1_NODE_ATTRIBUTE
ADHOC_CHAR_VAL
VARCHAR2
1016
W1_NODE_ATTRIBUTE
CHAR_TYPE_CD
CHAR
32
W1_NODE_ATTRIBUTE
CHAR_VAL
CHAR
64
W1_NODE_ATTRIBUTE
CHAR_VAL_FK1
VARCHAR2
200
W1_NODE_ATTRIBUTE
CHAR_VAL_FK2
VARCHAR2
200
W1_NODE_ATTRIBUTE
CHAR_VAL_FK3
VARCHAR2
200
W1_NODE_ATTRIBUTE
CHAR_VAL_FK4
VARCHAR2
200
W1_NODE_ATTRIBUTE
CHAR_VAL_FK5
VARCHAR2
200
W1_NODE_ATTRIBUTE
NODE_ID
CHAR
48
W1_NODE_ATTRIBUTE
SEQ_NUM
NUMBER
22
W1_NODE_ATTRIBUTE
SRCH_CHAR_VAL
VARCHAR2
200
W1_NODE_ATTRIBUTE
VERSION
NUMBER
22
W1_NODE_TYPE_ATTRIBUTE
CHAR_TYPE_CD
CHAR
32
W1_NODE_TYPE_ATTRIBUTE
NODE_TYPE_CD
VARCHAR2
120
W1_NODE_TYPE_ATTRIBUTE
VERSION
NUMBER
22
W1_SPECIFICATION_ATTRIBUTE
ADHOC_CHAR_VAL
VARCHAR2
1016
W1_SPECIFICATION_ATTRIBUTE
CHAR_TYPE_CD
CHAR
32
W1_SPECIFICATION_ATTRIBUTE
CHAR_VAL
CHAR
64
W1_SPECIFICATION_ATTRIBUTE
CHAR_VAL_FK1
VARCHAR2
200
W1_SPECIFICATION_ATTRIBUTE
CHAR_VAL_FK2
VARCHAR2
200
W1_SPECIFICATION_ATTRIBUTE
CHAR_VAL_FK3
VARCHAR2
200
W1_SPECIFICATION_ATTRIBUTE
CHAR_VAL_FK4
VARCHAR2
200
W1_SPECIFICATION_ATTRIBUTE
CHAR_VAL_FK5
VARCHAR2
200
W1_SPECIFICATION_ATTRIBUTE
SEQ_NUM
NUMBER
22
W1_SPECIFICATION_ATTRIBUTE
SPECIFICATION_CD
VARCHAR2
120
W1_SPECIFICATION_ATTRIBUTE
SRCH_CHAR_VAL
VARCHAR2
200
W1_SPECIFICATION_ATTRIBUTE
VERSION
NUMBER
22
W1_TIMEKEEPER
OWNING_ACCESS_GRP_CD
CHAR
48
New Indexes
Table_Name
Index_Name
Column_Name
W1_ACTIVITY
W1T244S21
SVC_HIST_ID
W1_ASSET_TYPE_SPEC_ATTRIBUTE
W1C972P0
ASSET_TYPE_CD
W1_ASSET_TYPE_SPEC_ATTRIBUTE
W1C972P0
CHAR_TYPE_CD
W1_BC_LINE_NOTE
W1T976P0
BC_LINE_ID
W1_BC_LINE_NOTE
W1T976P0
SEQNO
W1_CREW_SHIFT_ACT_SCHED
W1T311S1
ACT_RESRC_REQMT_ID
W1_CREW_SHIFT_ACT_SCHED
W1T311S1
CREW_SHIFT_ID
W1_DESIGN_ELEMENT_PLAN_SH_TYPE
W1T971P0
DESIGN_ELEMENT_ID
W1_DESIGN_ELEMENT_PLAN_SH_TYPE
W1T971P0
SVC_HIST_TYPE_CD
W1_DOCUMENT
W1M577S2
DOCUMENT_CLASS_FLG
W1_MAT_RET_LINE
W1T400S2
STOCK_ITEM_DTL_ID
W1_MEASUREMENT
W1T273S5
ASSET_ID
W1_NODE_ATTRIBUTE
W1M975P0
CHAR_TYPE_CD
W1_NODE_ATTRIBUTE
W1M975P0
NODE_ID
W1_NODE_ATTRIBUTE
W1M975P0
SEQ_NUM
W1_NODE_ATTRIBUTE
W1M975S1
SRCH_CHAR_VAL
W1_NODE_ATTRIBUTE
W1M975S2
CHAR_TYPE_CD
W1_NODE_ATTRIBUTE
W1M975S3
CHAR_TYPE_CD
W1_NODE_ATTRIBUTE
W1M975S3
CHAR_VAL
W1_NODE_ATTRIBUTE
W1M975S4
ADHOC_CHAR_VAL
W1_NODE_ATTRIBUTE
W1M975S4
CHAR_TYPE_CD
W1_NODE_TYPE_ATTRIBUTE
W1C974P0
CHAR_TYPE_CD
W1_NODE_TYPE_ATTRIBUTE
W1C974P0
NODE_TYPE_CD
W1_ODC_DTL
W1T340S3
ACT_RESRC_REQMT_ID
W1_PO_LINE
W1T418S9
ACT_RESRC_REQMT_ID
W1_RESRC_TYPE
W1M555S2
W1_RESRC_CLASS_FLG
W1_SPECIFICATION_ATTRIBUTE
W1C973P0
CHAR_TYPE_CD
W1_SPECIFICATION_ATTRIBUTE
W1C973P0
SEQ_NUM
W1_SPECIFICATION_ATTRIBUTE
W1C973P0
SPECIFICATION_CD
W1_SPECIFICATION_ATTRIBUTE
W1C973S1
SRCH_CHAR_VAL
W1_SPECIFICATION_ATTRIBUTE
W1C973S2
CHAR_TYPE_CD
W1_SPECIFICATION_ATTRIBUTE
W1C973S3
CHAR_TYPE_CD
W1_SPECIFICATION_ATTRIBUTE
W1C973S3
CHAR_VAL
W1_SPECIFICATION_ATTRIBUTE
W1C973S4
ADHOC_CHAR_VAL
W1_SPECIFICATION_ATTRIBUTE
W1C973S4
CHAR_TYPE_CD
W1_TIMESHEET_DETAIL
W1M595S4
ACT_RESRC_REQMT_ID