UPG_EVL_CTG_TAO

(SQL Table)
Index Back

Applicant Interview

Use INTERVIEW to track applicant interviews during the Recruitment process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
2 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
3 HRS_RCM_INT_ID Number(15,0) DECIMAL(15) NOT NULL Recruitment Interview ID
4 HRS_EVAL_ID Number(15,0) DECIMAL(15) NOT NULL Evaluation ID
5 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID
6 APP_DT Date(10) DATE Date an application was submitted
7 JOB_REQ_NBR Character(6) VARCHAR2(6) NOT NULL Job requisition number
8 HRS_INT_DT Date(10) DATE Interview date