HRS_INT_TAO

(SQL Table)
 Index Back

Applicant Interview

Use INTERVIEW to track applicant interviews during the Recruitment process.

  • Parent record: HRS_RCMNT

    • # 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 Date an application was submitted
    3 JOB_REQ_NBR Character(6) VARCHAR2(6) NOT NULL Job requisition number

    Prompt Table: HRS_JOB_OPENING

    4 RATING Character(1) VARCHAR2(1) NOT NULL Interview Rating
    1=Not Qualified
    2=Average
    3=Excellent
    5 RECOMMENDATION Character(3) VARCHAR2(3) NOT NULL Recommendation
    F=Hold on File
    I=Interview Further
    O=Make Offer
    R=Reject
    6 FINAL_RECOMMENDATN Character(1) VARCHAR2(1) NOT NULL Final Recommendation
    7 INTERVIEWER Character(11) VARCHAR2(11) NOT NULL Interviewer
    8 INTERVW_DT Date(10) DATE Interview date
    9 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

    Prompt Table: HRS_STS_INT_I

    10 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.

    Prompt Table: HRS_RSN_INT_I

    11 STATUS_DT Date(10) DATE Status Date

    Default Value: %date

    12 HRS_REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL The Fusion Publisher Report Definition ID used by Recruiting
    13 HRS_REPORT_TMPL_ID Character(30) VARCHAR2(30) NOT NULL The Fusion publisher Report template ID used by RS.
    14 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
    15 COMMENTS Long Character CLOB Comment