W3EB_EMPL_SRCH5 (SQL View)	Index Back
Employment/Job Search for Web This Search view is used to allow the user to select a specific Job (if multiple-job capability is turned on) by its Job Code or Job title, and thereby avoid the use of Empl_Rcd#. This view is mainly used by Web Self Service applications.

W3EB_EMPL_SRCH5

(SQL View)

Employment/Job Search for Web

This Search view is used to allow the user to select a specific Job (if multiple-job capability is turned on) by its Job Code or Job title, and thereby avoid the use of Empl_Rcd#. This view is mainly used by Web Self Service applications.

SELECT A.EMPLID , O.OPRID FROM PS_PERSON A , PSOPRDEFN O WHERE A.EMPLID = O.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).