INTERVIEWERINTERVW_DTJOB_REQ_NBRSLOT_NBRSTART_TIMEIV_SCHED_TIMES(SQL Table) |
Index Back |
|---|---|
Interviewer Availability TimesUsed by Recruit Workforce to hold Start and End times that an Interviewer is available on a specific Interview date. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INTERVIEWER |
Character(11) | VARCHAR2(11) NOT NULL | Interviewer |
| 2 | INTERVW_DT |
Date(10) | DATE | Interview date |
| 3 | JOB_REQ_NBR |
Character(6) | VARCHAR2(6) NOT NULL | Job requisition number |
| 4 | SLOT_NBR |
Number(3,0) | SMALLINT NOT NULL | Sequence number |
| 5 | START_TIME |
Time(15) | TIMESTAMP | Interview Start Time |
| 6 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 7 | END_TIME | Time(15) | TIMESTAMP | Interview End Time |
| 8 | APPLID | Character(11) | VARCHAR2(11) NOT NULL | External Job Applicant ID |
| 9 | APP_DT | Date(10) | DATE | Date an application was submitted |