HRS_RES_COLL_V2

(SQL View)
 Index Back

Resume Sections

Resume sections that are a part of the resume template.

SELECT DISTINCT RT.HRS_RES_TMPL_ID , RT.HRS_NO_RES_FLG , RTR.RESUME_SECTION_SEQ , CASE RTR.HRS_RES_SEC_NAME12 WHEN 'REC' THEN 'REC' WHEN 'REA' THEN 'RFA' WHEN 'REN' THEN 'RFB' END FROM PS_HRS_RES_TMPL RT , PS_HRS_RES_RESUME RTR WHERE RT.HRS_RES_TMPL_ID = RTR.HRS_RES_TMPL_ID AND RTR.HRS_RES_SEC_NAME12 <> 'REE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_RES_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Resume Template ID
2 HRS_NO_RES_FLG Character(1) VARCHAR2(1) NOT NULL Apply without a resume
3 RESUME_SECTION_SEQ Number(3,0) SMALLINT NOT NULL Sequence
4 HRS_RES_SEC_NAME Character(3) VARCHAR2(3) NOT NULL Resume Section Name
ATT=Attachments
CNA=Contact Address
CNE=Contact Email
CNN=Contact Name
CNP=Contact Phone
CNT=Contact Details
EDU=Education History
EMP=Employment Questions
FPR=Federal Preferences
MRS=Military Rank and Service
PER=Personal Information
PRF=Preferences
PRI=Federal Priority Placement
QUE=Questionnaire
REA=Attach Resume
REC=Copy & Paste Resume
REE=Use Existing Resume
REF=Referrals
REN=Apply without a resume
RES=Resume
RFA=Attach Friend's Resume
RFB=Refer friend without a resume
RFR=References
SUB=Submit Resume
TRA=Job Training
WRK=Work Experience