HRS_FIND_OP_I

(SQL View)
 Index Back

Find Applicants Non-JO View

Find Applicants not tied to a Job-Opening View

SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , ' ' , E.HRS_SUBMITTED_DTTM , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , B.NAME_DISPLAY , C.APP_PER_STATUS , A.HRS_PROFILE_SEQ , A.HRS_JOB_OPENING_ID , A.STATUS_CODE , C.STATUS_CODE , D.DESCR , A.STATUS_REASON , A.HRS_STATUS_DT , A.ENTRY_SOURCE , A.ENTRY_DATE , %subrec(HRS_AUDIT_SBR,A) FROM PS_HRS_RCMNT A , PS_HRS_APP_NAME_I B , PS_HRS_APPLICANT_I C , PS_HRS_STS_REC_I D , PS_HRS_APP_PROF_I E WHERE A.HRS_PROFILE_SEQ = E.HRS_PROFILE_SEQ AND A.HRS_PERSON_ID = E.HRS_PERSON_ID AND A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PERSON_ID = C.HRS_PERSON_ID AND D.STATUS_CODE = A.STATUS_CODE AND A.HRS_JOB_OPENING_ID = 0

  • Related Language Record: HRS_FIND_O_LN_I

    • # 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    4 HRS_SUBMITTED_DTTM DateTime(26) TIMESTAMP Submitted Date Time
    5 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    6 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    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 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    10 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    11 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

    Prompt Table: HRS_STS_REC_I

    12 HRS_STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Applicant Status
    13 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    14 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.

    Prompt Table: HRS_RSN_REC_I

    15 HRS_STATUS_DT Date(10) DATE Recruiting Solutions Status Date field
    16 ENTRY_SOURCE Character(1) VARCHAR2(1) NOT NULL Entry Source
    A=Application
    O=Organization

    Default Value: A

    17 ENTRY_DATE Date(10) DATE Date Entered

    Default Value: %date

    18 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    19 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    20 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    21 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id