SP_INTRVW_NONVW

(SQL View)
 Index Back

Interviewer Prompt table

This table is used on the Interview Schedule page as the prompt table for the Interviewer. This view selects all sPro users with 'SP_APPROVER' and 'SP_REQUESTER' authorizations

SELECT DISTINCT A.ROLEUSER , B.OPRDEFNDESC FROM PSROLEUSER A , PSOPRDEFN B WHERE A.ROLEUSER = B.OPRID AND (ROLENAME IN ( SELECT C.ROLENAME FROM PS_PV_ROLE_ACTION C WHERE C.PV_ACTION = 'SP_REQUESTER' AND PV_ACT_CONTROL = 'A') OR ROLENAME IN ( SELECT D.ROLENAME FROM PS_SPB_USRSTP_ROLE D WHERE D.SP_USER_TYPE = 'RA'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INTERVIEWER Character(30) VARCHAR2(30) NOT NULL The sPro user that is scheduled to interview a submitted candidate
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description