HCM_ADD_PRXY_VW

(SQL View)
 Index Back

HCDL User Prompt

Prompt view to override the OPRID prompt view provided for Add proxy page.

SELECT DISTINCT B.OPRID ,A.LAST_NAME_SRCH ,A.FIRST_NAME_SRCH , A.EMPLID FROM PS_PERSON_NAME A , PSOPRDEFN B WHERE A.EMPLID=B.EMPLID AND B.ACCTLOCK = 0 AND (A.EMPLID IN ( SELECT A1.EMPLID FROM PS_HCDL_CURR_JOB A1 ,PS_HCDL_INSTALL B1 WHERE 1= (CASE WHEN A1.PER_ORG='EMP' THEN 1 WHEN B1.HR_PSS_CWR_SW='Y' AND A1.PER_ORG='CWR' THEN 1 WHEN B1.HR_PSS_POI_SW='Y' AND A1.PER_ORG='POI' THEN 1 ELSE 0 END)) OR A.EMPLID IN ( SELECT EMPLID FROM PS_HCDL_poi_vw A2, PS_HCDL_INSTALL B2 WHERE B2.HR_PSS_POI_SW='Y'))

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

Prompt Table: HCDL_LNAM_VW

3 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name

Prompt Table: HCDL_FNAM_VW

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