PROCESS_INSTANCEAPPLIDAPP_DTJOB_REQ_NBRINTERVW_DTSEQ_NBRINTERVIEWER1=Low
2=Below Average
3=Average
4=Above Average
5=High
F=Hold on File
I=Interview Further
O=Make Offer
R=Reject
UPG_INT_EVL_TAO(SQL Table) |
Index Back |
|---|---|
Applicant InterviewUse INTERVIEW to track applicant interviews during the Recruitment process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | APPLID |
Character(11) | VARCHAR2(11) NOT NULL | External Job Applicant ID |
| 3 | APP_DT |
Date(10) | DATE | Date an application was submitted |
| 4 | JOB_REQ_NBR |
Character(6) | VARCHAR2(6) NOT NULL | Job requisition number |
| 5 | INTERVW_DT |
Date(10) | DATE NOT NULL | Interview date |
| 6 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 7 | INTERVIEWER |
Character(11) | VARCHAR2(11) NOT NULL | Interviewer |
| 8 | EVALUATION_DT | Date(10) | DATE | Evaluation Date |
| 9 | SUBMITTED | Character(1) | VARCHAR2(1) NOT NULL | Submitted |
| 10 | INTVW_RATING_OVER | Number(2,0) | SMALLINT NOT NULL |
Overall Rating
1=Low 2=Below Average 3=Average 4=Above Average 5=High |
| 11 | RECOMMENDATION | Character(3) | VARCHAR2(3) NOT NULL |
Recommendation
F=Hold on File I=Interview Further O=Make Offer R=Reject |
| 12 | INTVW_CMTS_OVER | Long Character | CLOB | Overall Comments |