SCH_MNG_EMP_VW

(SQL View)
Index Back

SELECT A.EMPLID FROM PS_PERSON A WHERE EXISTS ( SELECT B.EMPLID FROM PS_TL_ADM_SRCH_VW B WHERE A.EMPLID = B.EMPLID )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID