WM_INSP_EWK3_VW

(SQL View)
 Index Back

WO Inspect Eligible Worker Vw3

This view is intended for use as the Employee ID (EMPLID) prompt table for an (instantiated) Inspection Activity with no Craft ID specified.

SELECT A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , D.EMPLID , D.NAME , D.SHOP_ID , D.SHIFT_ID , E.SUPERVISOR_ID , E2.NAME AS SUPERVISOR_NAME FROM PS_WM_TSK_INSPECT A , PS_WM_WO_TSK B , PS_WM_WO_HDR C , PS_WM_SHOP_RES_VW D , PS_WM_ELGBL_WRKR E LEFT OUTER JOIN PS_WM_ELGBL_WRKR E2 ON E2.EMPLID = E.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.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.WO_ID = B.WO_ID AND D.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.SHOP_ID = C.SHOP_ID AND D.EFFDT = ( SELECT MAX(D2.EFFDT) FROM PS_WM_SHOP_RES_VW D2 WHERE D2.BUSINESS_UNIT = D.BUSINESS_UNIT AND D2.SHOP_ID = D.SHOP_ID AND D2.EMPLID = D.EMPLID AND D2.EFFDT <= B.SCHED_START_DT AND D2.EFF_STATUS = 'A') AND E.EMPLID = D.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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: WM_ELGBL_WRKR

5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
7 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID
8 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
9 SUPERVISOR_NAME Character(50) VARCHAR2(50) NOT NULL Supervisor Name