IN_WO_TECH_VW (SQL View)	Index Back
Current Eligible Resource Info This table is going to list current eligible Resource info in Resource Management. It is going to be updated by Resource Management through transactions and an Application Engine. SUJ--Included SYSTEM_SOURCE field to store the product type as the table will also list eligible resources under Work Order Mgmt .

IN_WO_TECH_VW

(SQL View)

Current Eligible Resource Info

This table is going to list current eligible Resource info in Resource Management. It is going to be updated by Resource Management through transactions and an Application Engine. SUJ--Included SYSTEM_SOURCE field to store the product type as the table will also list eligible resources under Work Order Mgmt .

SELECT emplid , NAME , business_unit , location FROM PS_RS_ELGBL_WRKR WHERE system_source = 'WM'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 NAME Character(50) VARCHAR2(50) NOT NULL Name

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code