New Columns
 
Table_Name
Column_Name
Data Type
Data Length
W1_ACTIVITY_MEASUREMENT_TYPE
ACT_ID
CHAR
14
W1_ACTIVITY_MEASUREMENT_TYPE
MEASUREMENT_TYPE_CD
VARCHAR2
30
W1_ACTIVITY_MEASUREMENT_TYPE
VERSION
NUMBER
22
W1_BI_ASSETCOST_VW
TOTAL_CM_MAINT_COST
NUMBER
22
W1_BI_ASSETCOST_VW
TOTAL_PM_MAINT_COST
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
EQUIP_COST_NEXT_10_YRS
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
EQUIP_COST_NEXT_2_YRS
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
EQUIP_COST_NEXT_5_YRS
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
EQUIP_COST_NEXT_YR
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
EQUIP_COST_REMAIN_LIFE
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
LABOR_COST_NEXT_10_YRS
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
LABOR_COST_NEXT_2_YRS
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
LABOR_COST_NEXT_5_YRS
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
LABOR_COST_NEXT_YR
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
LABOR_COST_REMAIN_LIFE
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
MATL_COST_NEXT_10_YRS
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
MATL_COST_NEXT_2_YRS
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
MATL_COST_NEXT_5_YRS
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
MATL_COST_NEXT_YR
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
MATL_COST_REMAIN_LIFE
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
MISC_COST_NEXT_10_YRS
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
MISC_COST_NEXT_2_YRS
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
MISC_COST_NEXT_5_YRS
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
MISC_COST_NEXT_YR
NUMBER
22
W1_BI_FORECASTEDASSETPMCOST_VW
MISC_COST_REMAIN_LIFE
NUMBER
22
W1_BI_FORECASTEDASSETPMHRS_VW
LABOR_HRS_REMAIN_LIFE
NUMBER
22
W1_BI_FORECASTEDASSETPMHRS_VW
REMAIN_LIFE_YRS
NUMBER
22
W1_EMPLOYEE_TRAINING
EFFECTIVE_DT
DATE
7
W1_EMPLOYEE_TRAINING
EMPLOYEE_NOTIFIED
CHAR
1
W1_EMPLOYEE_TRAINING
SUPERVISOR_NOTIFIED
CHAR
1
W1_EMPLOYEE_TRAINING
W1EXPIRATION_DT
DATE
7
W1_EU
AUTO_TS_CREATION
CHAR
1
W1_EU
AUTO_TS_CREATION_FLG
CHAR
4
W1_EU_TIMESHEET
EU_DT
DATE
7
W1_EU_TIMESHEET
EU_ID
CHAR
12
W1_EU_TIMESHEET
HOURS
NUMBER
22
W1_EU_TIMESHEET
VERSION
NUMBER
22
W1_MAINT_TRIGGER
AUTO_SCHEDULE_FLG
CHAR
4
W1_MAINT_TRIGGER
W1_CREW_ID
CHAR
12
W1_PO_HEADER_DOCUMENT
PRINT_FLG
CHAR
4
W1_PO_LINE
RR_ID
CHAR
14
W1_PO_LINE_DOCUMENT
PRINT_FLG
CHAR
4
W1_PROJECT_CATEGORY
BO_STATUS_CD
CHAR
12
W1_PROJECT_CATEGORY
BO_STATUS_REASON_CD
VARCHAR2
30
W1_PROJECT_CATEGORY_LOG
ADHOC_CHAR_VAL
VARCHAR2
254
W1_PROJECT_CATEGORY_LOG
BO_STATUS_CD
CHAR
12
W1_PROJECT_CATEGORY_LOG
BO_STATUS_REASON_CD
VARCHAR2
30
W1_PROJECT_CATEGORY_LOG
CHAR_TYPE_CD
CHAR
8
W1_PROJECT_CATEGORY_LOG
CHAR_VAL
CHAR
16
W1_PROJECT_CATEGORY_LOG
CHAR_VAL_FK1
VARCHAR2
50
W1_PROJECT_CATEGORY_LOG
CHAR_VAL_FK2
VARCHAR2
50
W1_PROJECT_CATEGORY_LOG
CHAR_VAL_FK3
VARCHAR2
50
W1_PROJECT_CATEGORY_LOG
CHAR_VAL_FK4
VARCHAR2
50
W1_PROJECT_CATEGORY_LOG
CHAR_VAL_FK5
VARCHAR2
50
W1_PROJECT_CATEGORY_LOG
DESCRLONG
VARCHAR2
4000
W1_PROJECT_CATEGORY_LOG
LOG_DTTM
DATE
7
W1_PROJECT_CATEGORY_LOG
LOG_ENTRY_TYPE_FLG
CHAR
4
W1_PROJECT_CATEGORY_LOG
MESSAGE_CAT_NBR
NUMBER
22
W1_PROJECT_CATEGORY_LOG
MESSAGE_NBR
NUMBER
22
W1_PROJECT_CATEGORY_LOG
PRJ_CAT_CD
VARCHAR2
30
W1_PROJECT_CATEGORY_LOG
SEQNO
NUMBER
22
W1_PROJECT_CATEGORY_LOG
USER_ID
CHAR
8
W1_PROJECT_CATEGORY_LOG
VERSION
NUMBER
22
W1_PROJECT_CATEGORY_LOG_PARM
F1_MSG_PARM_VLONG
VARCHAR2
2000
W1_PROJECT_CATEGORY_LOG_PARM
MSG_PARM_TYP_FLG
CHAR
4
W1_PROJECT_CATEGORY_LOG_PARM
PARM_SEQ
NUMBER
22
W1_PROJECT_CATEGORY_LOG_PARM
PRJ_CAT_CD
VARCHAR2
30
W1_PROJECT_CATEGORY_LOG_PARM
SEQNO
NUMBER
22
W1_PROJECT_CATEGORY_LOG_PARM
VERSION
NUMBER
22
W1_RR
BC_LINE_ID
CHAR
14
W1_TIMESHEET_DETAIL
EU_ID
CHAR
12
W1_VENDOR_LOC_PAYTO_LOC
PAY_TO_LOC
CHAR
12
W1_VENDOR_LOC_PAYTO_LOC
VENDOR_LOC_ID
CHAR
12
W1_VENDOR_LOC_PAYTO_LOC
VERSION
NUMBER
22