HRS_RESATTUR_IL

(SQL View)
 Index Back

Applicant Resume Attachments

This view lists all the applicant resume attachments for the applicants defined in HRS_APPI_ALL_VW.

SELECT A.HRS_PERSON_ID , B.HRS_PROFILE_SEQ , A.HRS_RESUME_ID , C.LANGUAGE_CD , C.HRS_RESUME_TITLE FROM PS_HRS_APP_RES A , PS_HRS_APP_PROFILE B , PS_HRS_APP_RES_LNG C WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_RESUME_ID = B.HRS_RESUME_ID AND A.ATTACHSYSFILENAME <> ' ' AND A.HRS_PERSON_ID = C.HRS_PERSON_ID AND A.HRS_RESUME_ID = C.HRS_RESUME_ID

  • Related Language Record for HRS_RESATTURL_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_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    3 HRS_RESUME_ID Number(15,0) DECIMAL(15) NOT NULL Resume id
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 HRS_RESUME_TITLE Character(60) VARCHAR2(60) NOT NULL Profile ID