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 |