HRS_ER_RES_OPT

(SQL View)

SELECT FIELDVALUE , XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'HRS_RES_SEC_NAME' AND A.FIELDVALUE IN ('RFA','RFB','REC') AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE A.FIELDNAME = B.FIELDNAME AND A.FIELDVALUE = B.FIELDVALUE AND B.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description