HRS_ALL_APPL_VW

(SQL View)
 Index Back

All Applicants

View of all applicants

SELECT A.HRS_PERSON_ID , A.APP_PER_STATUS , A.STATUS_CODE , B.DESCR , C.NAME_DISPLAY , A.HRS_APP_PREF_CONT , D.HRS_RCMNT_ID , D.HRS_JOB_OPENING_ID , %Substring(%Cast(%DateTimeOut(D.HRS_ROW_ADD_DTTM), DateTime, Character, 10),1, 4) , %Substring(%Cast(%DateTimeOut(D.HRS_ROW_ADD_DTTM), DateTime, Character, 10),6, 2) , A.HRS_ROW_ADD_DTTM , A.HRS_ROW_ADD_OPRID , CASE WHEN D.HRS_ROW_UPD_DTTM > A.HRS_ROW_UPD_DTTM AND D.HRS_ROW_UPD_DTTM > C.HRS_ROW_UPD_DTTM THEN D.HRS_ROW_UPD_DTTM WHEN C.HRS_ROW_UPD_DTTM > A.HRS_ROW_UPD_DTTM AND C.HRS_ROW_UPD_DTTM > D.HRS_ROW_UPD_DTTM THEN C.HRS_ROW_UPD_DTTM ELSE A.HRS_ROW_UPD_DTTM END , A.HRS_ROW_UPD_OPRID FROM PS_HRS_APPLICANT A , PS_HRS_STS_APP_I B , PS_HRS_APP_NAMES C , PS_HRS_RCMNT D WHERE A.STATUS_CODE = B.STATUS_CODE AND A.HRS_PERSON_ID = C.HRS_PERSON_ID AND A.HRS_PERSON_ID = D.HRS_PERSON_ID AND D.HRS_RCMNT_ID = ( SELECT MAX(D2.HRS_RCMNT_ID) FROM PS_HRS_RCMNT D2 WHERE D2.HRS_PERSON_ID = D.HRS_PERSON_ID) AND D.HRS_LOGICAL_DELETE = 'N'

  • Related Language Record: HRS_ALL_APPL_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 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
    3 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    6 HRS_APP_PREF_CONT Character(1) VARCHAR2(1) NOT NULL Preferred Method of Contact
    E=Email
    M=Mail
    N=Not Specified
    P=Phone
    7 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
    8 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    9 HRS_YEAR Character(4) VARCHAR2(4) NOT NULL Year - data type character
    10 HRS_MONTH Character(2) VARCHAR2(2) NOT NULL 2 digit month (character)
    11 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    12 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    13 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    14 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id