SP_INTRVW_CLSVW (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

SP_INTRVW_CLSVW

(SQL View)

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 S.BUSINESS_UNIT , A.ROLEUSER , B.OPRDEFNDESC FROM PSROLEUSER A , PSOPRDEFN B , PS_SEC_BU_CLS S WHERE A.ROLEUSER = B.OPRID AND B.ROWSECCLASS = S.OPRCLASS 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 INTERVIEWER Character(30) VARCHAR2(30) NOT NULL The sPro user that is scheduled to interview a submitted candidate

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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