HRS_RESATTURL_I

(SQL View)
Index Back

Applicant Resume Attachments

This view returns all applicant resume attachments.

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

  • Related Language Record: HRS_RESATTUR_IL
  • # 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 HRS_RESUME_TITLE Character(60) VARCHAR2(60) NOT NULL Profile ID
    5 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename