INTERVW_SCH_TBL (SQL Table)	Index Back
Interview Schedule Slots INTERVW_SCH_TBL is one of several records dealing with the scheduling of interviews in the Recruitment module. Use this record to set up interview time slots for a particular interview schedule. The schedule ID must be set up on the INTERVW_ID_TBL before you can enter data on INTERVW_SCH_TBL.

INTERVW_SCH_TBL

(SQL Table)

Interview Schedule Slots

INTERVW_SCH_TBL is one of several records dealing with the scheduling of interviews in the Recruitment module. Use this record to set up interview time slots for a particular interview schedule. The schedule ID must be set up on the INTERVW_ID_TBL before you can enter data on INTERVW_SCH_TBL.

Parent record: INTERVW_ID_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INTERVIEW_SCHED_ID Character(5) VARCHAR2(5) NOT NULL Schedule ID

2 START_TIME Time(15) TIMESTAMP NOT NULL Interview Start Time

3 END_TIME Time(15) TIMESTAMP Interview End Time

4 INTERVIEW_TYPE Character(3) VARCHAR2(3) NOT NULL Interview Type
BRK=Breakfast
EVL=Evaluation Session
INT=Interview
LUN=Lunch
STU=Start Up
WRU=Wrap Up

5 INTERVIEWER Character(11) VARCHAR2(11) NOT NULL Interviewer
Prompt Table: PERSON

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INTERVIEW_SCHED_ID	Character(5)	VARCHAR2(5) NOT NULL	Schedule ID
2	START_TIME	Time(15)	TIMESTAMP NOT NULL	Interview Start Time
3	END_TIME	Time(15)	TIMESTAMP	Interview End Time
4	INTERVIEW_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Interview Type BRK=Breakfast EVL=Evaluation Session INT=Interview LUN=Lunch STU=Start Up WRU=Wrap Up
5	INTERVIEWER	Character(11)	VARCHAR2(11) NOT NULL	Interviewer Prompt Table: PERSON