WM_WO_INSPC_HDR(SQL Table) |
Index Back |
|---|---|
Work Order Inspection HeaderWO Inspection Header: used to log/track asset inspections 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_WO_HDR |
| 3 | WO_TASK_ID |
Number(5,0) | INTEGER NOT NULL |
Task Number
Default Value: WM_WO_TSK.WO_TASK_ID Prompt Table: WM_WO_TSK |
| 4 | INSPECTION_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Inspection ID
Default Value: NEXT |
| 5 | WO_INSPL_TMPLT_ID | Character(25) | VARCHAR2(25) NOT NULL |
Inspection Plan
Prompt Table: WM_WO_IPSRCH_VW |
| 6 | WO_INSPL_EFFDT | Date(10) | DATE | Inspection Plan Effective Date |
| 7 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 8 | WO_INSPECT_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Inspection Status
01=Created 02=Assigned 03=In Progress 09=Completed 99=Terminated Default Value: 01 |
| 9 | STATUS_DTTM | DateTime(26) | TIMESTAMP | 05/13/02 EGS (CN#PL900-1): Added |
| 10 | INSP_RSLT_STAT_CD | Character(20) | VARCHAR2(20) NOT NULL | Result Status Code |
| 11 | INSP_RSLT_STAT_VAL | Character(10) | VARCHAR2(10) NOT NULL |
Result Status Value
Prompt Table: WM_WO_IPRSVL_VW |
| 12 | WO_INSP_QUIT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Inspection Quit Option
1=Halt In Place 2=Reject All |
| 13 | WO_DURATION | Number(8,2) | DECIMAL(7,2) NOT NULL | Estimated Work Order Duration |
| 14 | WO_DURATION2 | Number(8,2) | DECIMAL(7,2) NOT NULL | Actual (Calc) Duration |
| 15 | INSPECT_START_DTTM | DateTime(26) | TIMESTAMP | Inspection Start DateTime |
| 16 | INSPECT_END_DTTM | DateTime(26) | TIMESTAMP | Inspection End DateTime |
| 17 | COMMENTS | Long Character | CLOB | Comment |