HRS_RES_COLL_VW (SQL View)	Index Back
Resume Sections Resume sections that are a part of the resume template.

HRS_RES_COLL_VW

(SQL View)

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 , RTR.HRS_RES_SEC_NAME12 FROM PS_HRS_RES_TMPL RT , PS_HRS_RES_RESUME RTR WHERE RT.HRS_RES_TMPL_ID = RTR.HRS_RES_TMPL_ID

# 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

#	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