| # |
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_INSPC_HDR.BUSINESS_UNIT
Prompt Table:
SP_BU_WM_NONVW
|
| 2 |
WO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Order Identification
Default Value: WM_WO_INSPC_HDR.WO_ID
Prompt Table:
WM_FTRK_WOI_PVW
|
| 3 |
WO_TASK_ID |
Number(5,0) |
INTEGER NOT NULL |
Task Number
Default Value: WM_WO_INSPC_HDR.WO_TASK_ID
Prompt Table:
WM_FTRK_TSK_PVW
|
| 4 |
INSPECTION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Inspection ID
Default Value: WM_WO_INSPC_HDR.INSPECTION_ID
|
| 5 |
INSP_ACTIVITY_NBR |
Number(5,0) |
INTEGER NOT NULL |
Activity Number
Default Value: 1
|
| 6 |
DEPEND_ACTV_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Parent Activity No.
|
| 7 |
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
|
| 8 |
INSP_ACTV_SRC_CODE |
Character(25) |
VARCHAR2(25) NOT NULL |
Inspection Activity Source
Prompt Table:
%EDITTABLE
|
| 9 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 10 |
WO_INSPECT_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Activity Status
01=Created
02=Assigned
03=In Progress
09=Completed
99=Terminated
Default Value: 01
|
| 11 |
STATUS_DTTM |
DateTime(26) |
TIMESTAMP |
05/13/02 EGS (CN#PL900-1): Added
|
| 12 |
WO_DURATION |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Estimated Work Order Duration
|
| 13 |
WO_DURATION2 |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Actual (Calc) Duration
|
| 14 |
INSPECT_START_DTTM |
DateTime(26) |
TIMESTAMP |
Activity Start DateTime
|
| 15 |
INSPECT_END_DTTM |
DateTime(26) |
TIMESTAMP |
Activity End DateTime
|
| 16 |
CRAFT_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Craft Identification
Prompt Table:
RS_CRAFT_DETAIL
|
| 17 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
%EDITTABLE2
|