HRS_RESCNTCT_VW (SQL View)	Index Back
Contact Details Sections Contact Details Sections

HRS_RESCNTCT_VW

(SQL View)

Contact Details Sections

SELECT DISTINCT HRS_RES_TMPL_ID , HRS_RES_SEC_NAME12 FROM PS_HRS_RES_SECTION WHERE HRS_RES_SEC_NAME12 IN ('CNN','CNP', 'CNA', 'CNE')

# 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_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_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