WM_PACTUAL_TM2

(SQL View)
 Index Back

Actual hours per Work Order


SELECT MAX(A.TIME_SHEET_ID ) , MAX(A.VERSION_NUM ) , MAX(A.LINE_NBR ) , MAX(B.DATE_UNDER_RPT ) , MAX(A.BUSINESS_UNIT_WO ) , MAX(A.WO_ID ) , MAX(A.WO_TASK_ID ) , MAX(A.RSRC_TYPE ) , MAX(A.RES_LN_NBR ) , SUM(B.TOTAL_HOURS) , MIN(B.START_TIME) , MAX(B.END_TIME) FROM PS_EX_TIME_DTL A , PS_EX_TIME_DTL_HRS B WHERE B.TIME_SHEET_ID = A.TIME_SHEET_ID AND B.VERSION_NUM = A.VERSION_NUM AND B.LINE_NBR = A.LINE_NBR AND A.VERSION_NUM = ( SELECT MAX(C.VERSION_NUM) FROM PS_EX_TIME_DTL C WHERE C.TIME_SHEET_ID = A.TIME_SHEET_ID) GROUP BY A.TIME_SHEET_ID , A.VERSION_NUM , A.BUSINESS_UNIT_WO , A.WO_ID , A.WO_TASK_ID , A.RSRC_TYPE , A.RES_LN_NBR, B.DATE_UNDER_RPT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
2 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number

Default Value: 1

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

Default Value: 1

4 DATE_UNDER_RPT Date(10) DATE NOT NULL Date Under Report
5 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order

Prompt Table: SP_BU_WM_NONVW

6 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

Prompt Table: %EDIT_WO_ID

7 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

Prompt Table: %EDIT_WO_TASK

8 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material
9 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.

Prompt Table: %EDIT_RES_LINE

10 TOTAL_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Total Hours
11 START_TIME Time(15) TIMESTAMP Start of Shift
12 END_TIME Time(15) TIMESTAMP End of Shift