APPLIDAPP_DTJOB_REQ_NBRINTERVIEWERINTERVW_DTSEQ_NBRSTART_TIMEEND_TIMEUPG_INT_SCH_TAO(SQL Table) |
Index Back |
|---|---|
Interview Schedule TableUsed in Recruit Workforce for setting up inteview schedules at the Job Requisition Level |
| # | 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 NOT NULL | Date an application was submitted |
| 3 | JOB_REQ_NBR |
Character(6) | VARCHAR2(6) NOT NULL | Job requisition number |
| 4 | INTERVIEWER |
Character(11) | VARCHAR2(11) NOT NULL | Interviewer |
| 5 | INTERVW_DT |
Date(10) | DATE | Interview date |
| 6 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 7 | START_TIME |
Time(15) | TIMESTAMP | Interview Start Time |
| 8 | END_TIME |
Time(15) | TIMESTAMP | Interview End Time |
| 9 | INTVW_LOCATION | Character(254) | VARCHAR2(254) NOT NULL | Interview Location |
| 10 | RECRUITER_COMMENTS | Long Character | CLOB | Recruiter Comments |