HR_CP_PERS_SRCH (SQL View)	Index Back
SS Personal Data Search HR_CP_PERS_SRCH view is used as a search view for self service applications for an employee's data. It is use in Career Planning Self Service product.

HR_CP_PERS_SRCH

(SQL View)

SS Personal Data Search

HR_CP_PERS_SRCH view is used as a search view for self service applications for an employee's data. It is use in Career Planning Self Service product.

SELECT A.EMPLID FROM PS_HR_CP_JOB_VW A ,PSOPRDEFN 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