HRS_RES_PROF_VW

(SQL View)
 Index Back

Resume

View of Applicant Resume. The HRS_PERSON_ID field is moved to the key in the view for the page processor to automatically display the resumes.

SELECT A.HRS_PERSON_ID , B.HRS_PROFILE_SEQ , A.HRS_RESUME_ID , A.HRS_RESUME_TITLE , A.LANG_CD , A.RESUME_TExT , A.ATTACHSYSFILENAME , A.ATTACHUSERFILE , %subrec(HRS_AUDIT_SBR,A) FROM PS_HRS_APP_RES A , PS_HRS_APP_PROFILE B WHERE A.HRS_RESUME_ID=B.HRS_RESUME_ID

  • Related Language Record: HRS_RES_PRF_VWL

    • # 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 LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    CFR=Canadian French
    DAN=Danish
    DUT=Dutch
    ENG=English
    ESP=Spanish
    FRA=French
    GER=German
    GRK=Greek
    INE=International English
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    POR=Portuguese
    SVE=Swedish
    THA=Thai
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese

    Prompt Table: HRS_LNG_CD_VW

    6 RESUME_TEXT Long Character CLOB Resume text
    7 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    8 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    9 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    10 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    11 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    12 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id