WM_WO_FAILURE(SQL Table) |
Index Back |
|---|---|
Work Order Failure EventUsed to log/track asset failures per associated work order task. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT Prompt Table: SP_BU_WM_NONVW |
| 2 | WO_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Work Order Identification
Default Value: WM_WO_TSK.WO_ID Prompt Table: WM_FTRK_WOI_PVW |
| 3 | WO_TASK_ID |
Number(5,0) | INTEGER NOT NULL |
Task Number
Default Value: WM_WO_TSK.WO_TASK_ID Prompt Table: WM_FTRK_TSK_PVW |
| 4 | FAILURE_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Failure ID
Default Value: NEXT |
| 5 | SEVERITY_CD | Character(5) | VARCHAR2(5) NOT NULL |
Failure Severity
Prompt Table: WM_FAIL_SEVRTY |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 7 | FAILURE_START_DT | Date(10) | DATE NOT NULL | Failure Start Date |
| 8 | FAILURE_START_TIME | Time(15) | TIMESTAMP | Failure Start Time |
| 9 | FAILURE_END_DT | Date(10) | DATE | Failure End Date |
| 10 | FAILURE_END_TIME | Time(15) | TIMESTAMP | Failure End Time |
| 11 | TOTAL_REPAIR_HRS | Number(16,3) | DECIMAL(15,3) NOT NULL | Time to Repair |
| 12 | REPAIR_COST_LBR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Labor Repair Cost |
| 13 | REPAIR_COST_MAT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Material Repair Cost |
| 14 | REPAIR_COST_PO | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Procurement Repair Cost |
| 15 | REPAIR_COST_TLS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tools Repair Cost |