HRS_APP_RES_I

(SQL View)
Index Back

Resume text Interface

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

SELECT HRS_RESUME_ID ,HRS_PERSON_ID ,HRS_RESUME_TITLE ,LANG_CD ,RESUME_TEXT ,ATTACHSYSFILENAME ,ATTACHUSERFILE FROM PS_HRS_APP_RES

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_RESUME_ID Number(15,0) DECIMAL(15) NOT NULL Resume id
2 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
3 HRS_RESUME_TITLE Character(60) VARCHAR2(60) NOT NULL Profile ID
4 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

5 RESUME_TEXT Long Character CLOB Resume text
6 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
7 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File