INTERVIEWERINTERVW_DTJOB_REQ_NBRSLOT_NBRSTART_TIMEIV_SCHED_TIM_VW(SQL View) |
Index Back |
|---|---|
Interviewer Availability TimesUsed by Recruit Workforce to hold Start and End times that an Interviewer is available on a specific Interview date. |
| SELECT INTERVIEWER ,INTERVW_DT ,JOB_REQ_NBR ,SLOT_NBR ,SEQ_NBR ,START_TIME ,END_TIME ,APPLID ,APP_DT FROM PS_IV_SCHED_TIMES |
| # | 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 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 6 | START_TIME |
Time(15) | TIMESTAMP | Interview Start Time |
| 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 |