HRS_JO_APP_P_VW

(SQL View)
 Index Back

Applicants for Job Opening

Applicants for Job Opening. Used in JO Print component

SELECT A.HRS_JOB_OPENING_ID ,A.STATUS_CODE ,A.HRS_PERSON_ID ,A.HRS_RCMNT_ID ,SEC.OPRID ,B.STATUS_PHASE ,NM.NAME_DISPLAY ,SEC.APP_PER_STATUS ,NM.LAST_NAME ,A.HRS_ROW_UPD_DTTM FROM PS_HRS_RCMNT_I A , PS_HRS_STS_REC_I B , PS_HRS_APP_SEC_VW SEC , PS_HRS_APP_NAME_I NM WHERE A.HRS_PERSON_ID = SEC.HRS_PERSON_ID AND A.HRS_PERSON_ID = NM.HRS_PERSON_ID AND A.STATUS_CODE = B.STATUS_CODE AND A.STATUS_CODE NOT IN ( SELECT X.STATUS_CODE FROM PS_HRS_STS_REC_I X WHERE X.STATUS_AREA = '3' AND X.HRS_DRFT_STS_IND = 'Y')

  • Related Language Record: HRS_JO_APP_P_LN

  • Parent record: HRS_JOB_OPENING

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    2 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

    Prompt Table: HRS_STS_REC_I

    3 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    4 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
    5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    6 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
    7 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    8 APP_PER_STATUS Character(1) VARCHAR2(1) NOT NULL Identifies the type of applicant - External Applicant, Employee or Non-Employee
    A=External Applicant
    E=Employee
    N=Non-Employee
    9 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    10 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime