HRS_APPL_RES_VW

(SQL View)
 Index Back

Applicant Resume View


SELECT RCM.HRS_PERSON_ID , RCM.HRS_RCMNT_ID , RCM.HRS_PROFILE_SEQ ,1 , RES.HRS_RESUME_TITLE , RES.LANG_CD , RES.ATTACHSYSFILENAME , RES.ATTACHUSERFILE , RES.RESUME_TEXT ,RES.HRS_RESUME_TITLE ,RCM.HRS_JOB_OPENING_ID ,ATT.ATTACH_TYPE_CD ,0 ,' ' FROM PS_HRS_RCMNT RCM ,PS_HRS_APP_PROFILE PRF ,PS_HRS_APP_RES RES , PS_HRS_ATT_TYP_TBL ATT WHERE RCM.HRS_PERSON_ID=PRF.HRS_PERSON_ID AND RCM.HRS_PROFILE_SEQ=PRF.HRS_PROFILE_SEQ AND PRF.HRS_PERSON_ID=RES.HRS_PERSON_ID AND PRF.HRS_RESUME_ID=RES.HRS_RESUME_ID AND ATT.ATTACH_PROCESS_TYP='RES'

  • Related Language Record: HRS_APPLRES_LVW

    • # 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_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
    3 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    4 ATTACH_SEQ_NBR Number(3,0) SMALLINT NOT NULL Attachment Sequence Number
    5 HRS_RESUME_TITLE Character(60) VARCHAR2(60) NOT NULL Profile ID
    6 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
    7 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    8 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    9 RESUME_TEXT Long Character CLOB Resume text
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    12 ATTACH_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Attachment Type Code
    13 HRS_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
    14 HRS_ATTACHFILENAME Character(128) VARCHAR2(128) NOT NULL New File Name