PGM_MRES_SEARCH

(SQL View)
 Index Back

Multiple Resource Search

This record is used to display the search results in the Multiple Resource Selection page.

SELECT A.FIRST_NAME , A.LAST_NAME , %TrimSubstr(A.FIRST_NAME,1,30) %Concat ' ' %Concat A.LAST_NAME , A.EMPLID , A.COUNTRY %Concat '-' %Concat A.CITY , B.DESCR , A.PER_STATUS FROM %Table(PERSONAL_DATA) A , %Table(DEPT_TBL) B , %Table(JOB) C WHERE C.EMPLID=A.EMPLID AND B.DEPTID=C.DEPTID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
2 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
3 DESCR80 Character(80) VARCHAR2(80) NOT NULL Resource Name
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 MRS_LOCATION Character(35) VARCHAR2(35) NOT NULL Location indicating the Country and the city in the search result for the resources.
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status
E=Employee
N=Non-Employee