WM_TE_ADD_VW

(SQL View)
 Index Back

WO Time Entry Add Vw

Used to source Elapsed/Punch Time Entry rowset data in %Add mode, for selected WO tasks (level 2 view)

SELECT A.OPRID , A.BUSINESS_UNIT AS BUSINESS_UNIT_WO , A.WO_ID , A.WO_TASK_ID , A.BUSINESS_UNIT , 0 , '1' , B.STATUS_CD , B.INTERNAL_STATUS FROM PS_WM_WOE_TW_VW A , PS_WM_WO_TSK B WHERE A.CHECKED = 'Y' AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.WO_ID = A.WO_ID AND B.WO_TASK_ID = A.WO_TASK_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
3 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
4 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.
7 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material
8 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code
9 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