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
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
W1_ACT_RECON_PROP_UNIT
CU_ID
CHAR
48
W1_ASSET
FIXED_ASSET_NUM
VARCHAR2
240
W1_CU
FIXED_ASSET_NUM
VARCHAR2
240
W1_PROJECT
ERP_CAPITAL_PRJ_FLG
CHAR
16
W1_TMPL_WO_DOCUMENT
ATTACHMENT_ID
CHAR
56
W1_TMPL_WO_DOCUMENT
CRE_DTTM
DATE
7
W1_TMPL_WO_DOCUMENT
DOCUMENT_ID
CHAR
48
W1_TMPL_WO_DOCUMENT
TMPL_WO_ID
CHAR
48
W1_TMPL_WO_DOCUMENT
USER_ID
CHAR
32
W1_TMPL_WO_DOCUMENT
VERSION
NUMBER
22
W1_WORK_LOC
CITY
VARCHAR2
360
W1_WORK_LOC
W1_CITY_UPR
VARCHAR2
360
W1_WORK_REQ
CITY
VARCHAR2
360
W1_WORK_REQ
W1_CITY_UPR
VARCHAR2
360
W1_WO_DOCUMENT
ATTACHMENT_ID
CHAR
56
W1_WO_DOCUMENT
CRE_DTTM
DATE
7
W1_WO_DOCUMENT
DOCUMENT_ID
CHAR
48
W1_WO_DOCUMENT
USER_ID
CHAR
32
W1_WO_DOCUMENT
VERSION
NUMBER
22
W1_WO_DOCUMENT
WO_ID
CHAR
56
* Used by Digital Asset Cloud Service