HRS_FIND_RSL_I2

(SQL View)
 Index Back

Find Applicant Results View

Find Applicant Search Results 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 , B.NAME_AC , 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 , E.PREV_EMPL_BY_COMPY , H.EMAIL_ADDR , %subrec(PHONE_SBR, G) , %subrec(HRS_AUDIT_SBR,A) FROM PS_HRS_APPLICANT C LEFT OUTER JOIN PS_HRS_APP_EMAIL H ON (H.HRS_PERSON_ID = C.HRS_PERSON_ID AND H.PREF_EMAIL_FLAG = 'Y') LEFT OUTER JOIN PS_HRS_APP_PHONE G ON (G.HRS_PERSON_ID = C.HRS_PERSON_ID AND G.PREF_PHONE_FLAG = 'Y') ,PS_HRS_APP_NAMES B ,PS_HRS_APP_PROFILE E ,PS_HRS_RCMNT A ,PS_HRS_STS_TBL D WHERE B.HRS_PERSON_ID = C.HRS_PERSON_ID AND E.HRS_PERSON_ID = C.HRS_PERSON_ID AND A.HRS_PERSON_ID = E.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = E.HRS_PROFILE_SEQ AND D.STATUS_CODE = A.STATUS_CODE AND D.STATUS_AREA = '3' AND A.HRS_LOGICAL_DELETE = 'N'

  • Related Language Record: HRS_FIND_R_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 HRS_NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    9 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
    10 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    11 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    12 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

    Prompt Table: HRS_STS_REC_I

    13 HRS_STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Applicant Status

    Prompt Table: HRS_STS_APP_I

    14 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    15 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.

    Prompt Table: HRS_RSN_REC_I

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

    Default Value: A

    18 ENTRY_DATE Date(10) DATE Date Entered

    Default Value: %date

    19 PREV_EMPL_BY_COMPY Character(1) VARCHAR2(1) NOT NULL Previously Employed by Company
    N=No
    Y=Yes
    20 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    21 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    22 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    23 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    24 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    25 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    26 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id