HRS_CRSPARES_IL

(SQL View)
Index Back

Resume text Interface

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

SELECT 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_CRSPAPRES_I
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    2 HRS_RESUME_TITLE Character(60) VARCHAR2(60) NOT NULL Profile ID