APPLIDAPP_DTINTERVW_DTSTART_TIMEBRK=Breakfast
EVL=Evaluation Session
INT=Interview
LUN=Lunch
STU=Start Up
WRU=Wrap Up
APP_IV_SCHED(SQL Table) |
Index Back |
|---|---|
Applicant Interview TimesINTERVW_TIMES is one of several records dealing with the scheduling of interviews in the Recruitment module. Use this record in tandem with INTERVW_SCHED to specify the dates (INTERVW_SCHED) and times (INTERVW_TIMES) when an applicant is scheduled to be interviewed. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | APPLID |
Character(11) | VARCHAR2(11) NOT NULL | External Job Applicant ID |
| 2 | APP_DT |
Date(10) | DATE | Date an application was submitted |
| 3 | JOB_REQ_NBR | Character(6) | VARCHAR2(6) NOT NULL | Job requisition number |
| 4 | INTERVW_DT |
Date(10) | DATE NOT NULL | Interview date |
| 5 | SLOT_NBR | Number(3,0) | SMALLINT NOT NULL | Sequence number |
| 6 | START_TIME |
Time(15) | TIMESTAMP NOT NULL | Interview Start Time |
| 7 | END_TIME | Time(15) | TIMESTAMP | Interview End Time |
| 8 | 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 |
| 9 | INTERVIEWER | Character(11) | VARCHAR2(11) NOT NULL | Interviewer |