HRS_FIND_MY_I2

(SQL View)
 Index Back

Find My Applicant Results View

Find My Applicant Results View

SELECT DISTINCT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , OPR.OPRID , 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_RCMNT A , PS_HRS_APP_NAMES B , 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_STS_TBL D , PS_HRS_APP_PROFILE E , PS_HRS_JOB_OPENING F , PSOPRDEFN OPR , PS_HRS_JO_TEAM TM WHERE E.HRS_PROFILE_SEQ = A.HRS_PROFILE_SEQ AND E.HRS_PERSON_ID = A.HRS_PERSON_ID AND B.HRS_PERSON_ID = A.HRS_PERSON_ID AND C.HRS_PERSON_ID = A.HRS_PERSON_ID AND D.STATUS_CODE = A.STATUS_CODE AND F.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID AND TM.HRS_JOB_OPENING_ID = F.HRS_JOB_OPENING_ID AND TM.EMPLID = OPR.EMPLID AND D.STATUS_AREA = '3'

  • Related Language Record: HRS_FIND_M_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
    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