WM_TE_SCHLBR_VW

(SQL View)
Index Back

WO Time Entry Sched Lbr Src Vw

Used to source WO Sched Lbr data for Time Entry in %Update mode (level 1 view) 06/02/2022 - modified for Bug 34201324.

SELECT A.BUSINESS_UNIT , A.WO_ID , B.WO_TASK_ID , C.RES_LN_NBR , B.STATUS_CD , B.INTERNAL_STATUS , C.CRAFT_ID , C.EMPLID , C.LABOR_COST_RATE , C.LABOR_BILL_RATE , C.CURRENCY_CD , C.ASSIGNMENT_ID , C.SHOP_ID , C.SHIFT_ID , C.ACTL_SOURCE_CD , C.TIME_SHEET_ID FROM PS_WM_WO_HDR A , PS_WM_WO_TSK B , PS_WM_WO_SCHED_LBR C WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.WO_ID = A.WO_ID AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.WO_ID = B.WO_ID AND C.WO_TASK_ID = B.WO_TASK_ID

# 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 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.
5 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code
6 INTERNAL_STATUS Character(2) VARCHAR2(2) NOT NULL Internal Status
01=Open
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
05=Complete
06=Closed
07=Canceled
08=On Hold
09=Work Order Created
7 CRAFT_ID Character(16) VARCHAR2(16) NOT NULL Craft Identification

Prompt Table: RS_CRAFT_DETAIL

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

Prompt Table: WM_ELGBL_WRKR

9 LABOR_COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Cost Rate
10 LABOR_BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Billing Rate
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
13 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
14 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID
15 ACTL_SOURCE_CD Character(2) VARCHAR2(2) NOT NULL Actuals Source Code
2=Multiple Sources
A=Actual Hours
I=Mobile Inspection
M=My Tasks
T=Elapsed Time Entry
W=Work Order Completion
16 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)