WM_TIME_DTL_VW

(SQL View)
 Index Back

WO Time Detail Lines View


SELECT A.EMPLID , %DateAdd(A.ACTL_END_DT, 7 - %Sql(WM_WEEK_DAY, A.ACTL_END_DT)) , A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , ' ' , A.RES_LN_NBR , A.CRAFT_ID , B.DESCR254 , B.BUSINESS_UNIT_PC , B.PROJECT_ID , B.ACTIVITY_ID , A.ACTL_SOURCE_CD , B.INTERNAL_STATUS , B.STATUS_CD , A.TIME_SHEET_ID , %Sql(WM_DAILY_HRS2_SEL, A.TIME1, 1) , %Sql(WM_DAILY_HRS2_SEL, A.TIME2, 2) , %Sql(WM_DAILY_HRS2_SEL, A.TIME3, 3) , %Sql(WM_DAILY_HRS2_SEL, A.TIME4, 4) , %Sql(WM_DAILY_HRS2_SEL, A.TIME5, 5) , %Sql(WM_DAILY_HRS2_SEL, A.TIME6, 6) , %Sql(WM_DAILY_HRS2_SEL, A.TIME7, 7) , %Sql(WM_WEEKLY_HRS_SEL) , A.COMMENT1 , A.LAST_UPDATED_BY , A.LAST_UPDATE_DTTM FROM PS_WM_WO_SCHED_LBR A , PS_WM_WO_TSK B WHERE %Join(COMMON_KEYS, WM_WO_SCHED_LBR A, WM_WO_TSK B) AND A.ACTL_END_DT IS NOT NULL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 PERIOD_END_DT Date(10) DATE Represents the date termination point for a given time set utilized in cash worksheet processing.
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_WM_NONVW

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

Prompt Table: %EDIT_WO_ID

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

Prompt Table: %EDIT_WO_TASK

6 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code

Prompt Table: TL_TRC_TBL

7 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.

Prompt Table: WM_RSL_DV

8 CRAFT_ID Character(16) VARCHAR2(16) NOT NULL Craft Identification

Prompt Table: RS_CRAFT_DETAIL

9 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
10 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
11 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PROJID_BUGL_VW

12 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: PROJ_ACT_FS

13 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

Default Value: M

14 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
15 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code
16 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
17 TIME1 Signed Number(6,2) DECIMAL(4,2) NOT NULL TIME1
18 TIME2 Signed Number(6,2) DECIMAL(4,2) NOT NULL TIME2
19 TIME3 Signed Number(6,2) DECIMAL(4,2) NOT NULL TIME3
20 TIME4 Signed Number(6,2) DECIMAL(4,2) NOT NULL TIME4
21 TIME5 Signed Number(6,2) DECIMAL(4,2) NOT NULL TIME5
22 TIME6 Signed Number(6,2) DECIMAL(4,2) NOT NULL TIME6
23 TIME7 Signed Number(6,2) DECIMAL(4,2) NOT NULL TIME7
24 TOTAL Signed Number(7,2) DECIMAL(5,2) NOT NULL Row Total
25 COMMENT1 Character(254) VARCHAR2(254) NOT NULL Comments
26 LAST_UPDATED_BY Character(30) VARCHAR2(30) NOT NULL LastUpdatedUser
27 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

Default Value: %Datetime