WM_INSP_EWK1_VW

(SQL View)
 Index Back

WO Inspect Eligible Worker Vw1

This view is intended for use as the Employee ID (EMPLID) prompt table for an (instantiated) Inspection Activity with: (a) Craft ID specified; and (b) corresponding parent WO Task having Sched Labor record(s) with same Craft ID specified and with an Employee ID currently assigned.

SELECT A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , B.CRAFT_ID , B.EMPLID , C.NAME , CASE WHEN B2.PRIMARY_CRAFT IS NULL THEN 'N' ELSE B2.PRIMARY_CRAFT END , B.SHOP_ID , B.SHIFT_ID , B.SCHED_START_DT , B.SCHED_START_TIME , C.SUPERVISOR_ID , C2.NAME AS SUPERVISOR_NAME FROM PS_WM_TSK_INSPECT A , PS_WM_WO_SCHED_LBR B LEFT OUTER JOIN PS_RS_RES_CRAFT B2 ON B2.EMPLID = B.EMPLID AND B2.CRAFT_ID = B.CRAFT_ID , PS_WM_ELGBL_WRKR C LEFT OUTER JOIN PS_WM_ELGBL_WRKR C2 ON C2.EMPLID = C.SUPERVISOR_ID WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.WO_ID = A.WO_ID AND B.WO_TASK_ID = A.WO_TASK_ID AND C.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
3 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
4 CRAFT_ID Character(16) VARCHAR2(16) NOT NULL Craft Identification

Prompt Table: RS_CRAFT_DETAIL

5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: WM_ELGBL_WRKR

6 NAME Character(50) VARCHAR2(50) NOT NULL Name
7 PRIMARY_CRAFT Character(1) VARCHAR2(1) NOT NULL SANT--This field is used in the Change profile to identify the Primary Craft

Y/N Table Edit

Default Value: N

8 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
9 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID
10 SCHED_START_DT Date(10) DATE Scheduled Start Date
11 SCHED_START_TIME Time(15) TIMESTAMP Schedule Start Time
12 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
13 SUPERVISOR_NAME Character(50) VARCHAR2(50) NOT NULL Supervisor Name