HRS_ALL_APPL_V1

(SQL View)
 Index Back

All Applicants

View of all applicants - Used in APPLICANT INDEX

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 , TM.HRS_ROW_UPD_DTTM , A.HRS_ROW_UPD_OPRID FROM PS_HRS_APPL_IDX_TM TM , PS_HRS_APPLICANT A , PS_HRS_STS_TBL B , PS_HRS_APP_NAMES C , PS_HRS_RCMNT D WHERE TM.HRS_PERSON_ID = A.HRS_PERSON_ID AND 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 B.STATUS_AREA = '2' 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