HRS_INT_SRCH3

(SQL View)
 Index Back

Interview Team Schedule

Interview Team Schedule

SELECT DISTINCT A.HRS_PERSON_ID ,A.HRS_RCMNT_ID , A.HRS_INT_ID , A.HRS_INTERVIEWER_ID , A.HRS_RCM_INT_ID , B.HRS_JOB_OPENING_ID , '3' , B.STATUS_CODE , C.STATUS_PHASE , C.DESCR , D.HRS_INT_DT , D.HRS_START_TM , D.HRS_END_TM , D.TIMEZONE FROM PS_HRS_INT_SCHED A , PS_HRS_RCMNT_I B , PS_HRS_STS_REC_I C , PS_HRS_RCM_INT D WHERE A.HRS_RCMNT_ID = B.HRS_RCMNT_ID AND C.STATUS_CODE = B.STATUS_CODE AND B.HRS_JOB_OPENING_ID=0 AND A.HRS_PERSON_ID = D.HRS_PERSON_ID AND A.HRS_RCMNT_ID = D.HRS_RCMNT_ID AND A.HRS_RCM_INT_ID = D.HRS_RCM_INT_ID AND D.HRS_INTVW_STATUS <> 'X'

  • Related Language Record: HRS_INTSRCH3_LN

    • # 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_INT_ID Number(15,0) DECIMAL(15) NOT NULL Interview ID
    4 HRS_INTERVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Interviewer
    5 HRS_RCM_INT_ID Number(15,0) DECIMAL(15) NOT NULL Recruitment Interview ID
    6 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    7 STATUS_AREA Character(1) VARCHAR2(1) NOT NULL Defines an area in the system that track statuses.
    1=1-Job Opening
    2=2-Applicant
    3=3-Recruitment Summary
    4=4-Route
    5=5-Interview
    6=6-Offer
    8 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
    9 STATUS_PHASE Character(1) VARCHAR2(1) NOT NULL Identifies a phase within a status area.
    1=1-Applied
    2=2-Reviewed
    3=3-Screen
    4=4-Route
    5=5-Interview
    6=6-Offer
    7=7-Hire
    8=8-Hold
    9=9-Reject
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 HRS_INT_DT Date(10) DATE Interview date
    12 HRS_START_TM Time(15) TIMESTAMP Recruiting Solutions Start Time
    13 HRS_END_TM Time(15) TIMESTAMP Recruiting Solutions End Time field
    14 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone