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 HRS_RES_TMPL_ID , HRS_RES_SEC_NAME FROM PS_HRS_RES_SECTION WHERE HRS_RES_SEC_NAME IN ('REA','REC', 'REE', 'REN')

# 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

#	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