HRS_INTSCH_HST

(SQL Table)
 Index Back

Interview Schedule Table

Used in Recruit Workforce for setting up inteview schedules at the Job Requisition Level

  • Parent record: HRS_RCM_INT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id

    Prompt Table: HRS_APPLICANT_I

    4 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID

    Prompt Table: HRS_RCMNT

    5 HRS_RCM_INT_ID Number(15,0) DECIMAL(15) NOT NULL Recruitment Interview ID

    Prompt Table: HRS_RCM_INT

    6 HRS_INT_ID Number(15,0) DECIMAL(15) NOT NULL Interview ID

    Default Value: 999999999999999

    7 HRS_INTERVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Interviewer

    Prompt Table: HRS_PERSON_NM_I

    8 HRS_INT_DT Date(10) DATE Interview date
    9 HRS_START_TM Time(15) TIMESTAMP Recruiting Solutions Start Time
    10 HRS_END_TM Time(15) TIMESTAMP Recruiting Solutions End Time field
    11 HRS_INTVW_LEVEL Character(1) VARCHAR2(1) NOT NULL Interview Level

    Prompt Table: HRS_INT_LVL_TBL

    12 INTVW_LOCATION Character(50) VARCHAR2(50) NOT NULL Location
    13 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    14 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    15 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    16 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
    17 RECRUITER_COMMENTS Long Character CLOB Recruiter Comments