WM_WO_FAIL_IMPC(SQL Table) |
Index Back |
|---|---|
Work Order Failure ImpactsUsed to log/track failure impacts for each work order task failure event |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: WM_WO_FAILURE.BUSINESS_UNIT Prompt Table: SP_BU_WM_NONVW |
| 2 | WO_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Work Order Identification
Default Value: WM_WO_FAILURE.WO_ID Prompt Table: WM_FTRK_WOI_PVW |
| 3 | WO_TASK_ID |
Number(5,0) | INTEGER NOT NULL |
Task Number
Default Value: WM_WO_FAILURE.WO_TASK_ID Prompt Table: WM_FTRK_TSK_PVW |
| 4 | FAILURE_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Failure ID
Default Value: WM_WO_FAILURE.FAILURE_ID |
| 5 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1 |
| 6 | IMPACT_CD | Character(10) | VARCHAR2(10) NOT NULL |
Failure Impact
Prompt Table: WM_FAIL_IMPACT |
| 7 | NOTES | Long Character | CLOB | Notes |
| 8 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 9 | LAST_UPDATED_BY | Character(30) | VARCHAR2(30) NOT NULL | LastUpdatedUser |