RS_WRK_CUST_VW (SQL View)	Index Back
Active Worker Search This defines the list of ACTIVE workers in Resource Management. It is joined against the JOB, DEPT_TBL, and LOCATION_TBL tables to get the most current information about the worker and his/her job. It is used by the Customer eResume as the search record.

RS_WRK_CUST_VW

(SQL View)

Active Worker Search

This defines the list of ACTIVE workers in Resource Management. It is joined against the JOB, DEPT_TBL, and LOCATION_TBL tables to get the most current information about the worker and his/her job. It is used by the Customer eResume as the search record.

SELECT A.EMPLID FROM PS_RS_WORKER_TBL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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