SPF_INTRVW_WOS (SQL View)	Index Back
Interview Req Ids lookup view This view is used as the prompt for REQ_ID field for Scheduled Interviews.

SPF_INTRVW_WOS

(SQL View)

Interview Req Ids lookup view

This view is used as the prompt for REQ_ID field for Scheduled Interviews.

SELECT DISTINCT INTERVIEWER ,BUSINESS_UNIT , WORK_ORDER_ID FROM PS_SPF_INTERVIEW WHERE WORK_ORDER_ID <> ' '

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID

#	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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	WORK_ORDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Order ID