HRS_APPRS_LNG_I

(SQL View)
 Index Back

Resume text Interface

Capture Applicants Resume in ascii text format or as an attached file

SELECT A.HRS_RESUME_ID ,B.LANGUAGE_CD ,B.HRS_RESUME_TITLE FROM PS_HRS_APP_RES A , PS_HRS_APP_RES_LNG B WHERE B.HRS_RESUME_ID = A.HRS_RESUME_ID AND B.HRS_PERSON_ID = A.HRS_PERSON_ID

  • Related Language Record for HRS_APP_RES_I

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_RESUME_ID Number(15,0) DECIMAL(15) NOT NULL Resume id
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 HRS_RESUME_TITLE Character(60) VARCHAR2(60) NOT NULL Profile ID