IV_AVAIL_DT_VW (SQL View)	Index Back
Interviewer Availability Dates Used by Recruit Workforce to hold dates when an Interviewer is available.

IV_AVAIL_DT_VW

(SQL View)

Interviewer Availability Dates

Used by Recruit Workforce to hold dates when an Interviewer is available.

SELECT a.INTERVIEWER ,b.name ,a.intervw_dt ,a.slot_nbr FROM ps_iv_avail_dates a , PS_PERSON_NAME b WHERE a.INTERVIEWER = b.emplid

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INTERVIEWER Character(11) VARCHAR2(11) NOT NULL Interviewer

2 NAME Character(50) VARCHAR2(50) NOT NULL Name

3 INTERVW_DT Date(10) DATE Interview date

4 SLOT_NBR Number(3,0) SMALLINT NOT NULL Sequence number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INTERVIEWER	Character(11)	VARCHAR2(11) NOT NULL	Interviewer
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
3	INTERVW_DT	Date(10)	DATE	Interview date
4	SLOT_NBR	Number(3,0)	SMALLINT NOT NULL	Sequence number