WM_WO_INSPL_ACT(SQL Table) |
Index Back |
|---|---|
Inspection Plan Activities |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: WM_WO_INSPL_EFF.SETID Prompt Table: SP_SETID_NONVW |
| 2 | WO_TEMPLATE_ID |
Character(25) | VARCHAR2(25) NOT NULL |
Work Order Task/Job Template ID
Default Value: WM_WO_INSPL_EFF.WO_TEMPLATE_ID |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: WM_WO_INSPL_EFF.EFFDT |
| 4 | INSP_ACTIVITY_NBR |
Number(5,0) | INTEGER NOT NULL |
Activity Number
Default Value: 1 |
| 5 | SEQ_NBR_5 | Number(5,0) | INTEGER NOT NULL | Sequence number five digits long |
| 6 | DEPEND_ACTV_NBR | Number(3,0) | SMALLINT NOT NULL | Parent Activity No. |
| 7 | OVERLAP_PERCENT | Number(6,2) | DECIMAL(5,2) NOT NULL | Overlap Percentage |
| 8 | INSP_ACTIVITY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Inspection Activity Type
1=Asset Verification 2=Tool Calibration 3=Data Collection 4=Trigger Evaluation 8=Sub-Plan 9=Other Logistics |
| 9 | INSP_ACTV_SRC_CODE | Character(25) | VARCHAR2(25) NOT NULL |
Inspection Activity Source
Prompt Table: %EDITTABLE |
| 10 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 11 | WO_DURATION | Number(8,2) | DECIMAL(7,2) NOT NULL | Estimated Work Order Duration |
| 12 | CRAFT_ID | Character(16) | VARCHAR2(16) NOT NULL |
Craft Identification
Prompt Table: RS_CRAFT_DETAIL |