HRS_JO_RSEC_VW (SQL View)	Index Back
RS JO Verity Security View This view is used by Recruiting Solutions to implement row level security for the Job Openings Verity Index. This view determines what Job Openings a user has access to based on the configuration present.

HRS_JO_RSEC_VW

(SQL View)

RS JO Verity Security View

This view is used by Recruiting Solutions to implement row level security for the Job Openings Verity Index. This view determines what Job Openings a user has access to based on the configuration present.

SELECT DISTINCT JO.HRS_JOB_OPENING_ID ,CLS.CLASSID FROM PS_HRS_SJT_JO JO , PS_SJT_CLASS_ALL CLS WHERE ((CLS.SCRTY_SET_CD = 'RSOPN' AND CLS.SCRTY_TYPE_CD = JO.SCRTY_TYPE_CD) OR (CLS.SCRTY_SET_CD = 'PPLJOB' AND CLS.SCRTY_TYPE_CD = '001' AND JO.SCRTY_TYPE_CD = '012')) AND CLS.SCRTY_KEY1 = JO.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = JO.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = JO.SCRTY_KEY3

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone

2 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_JOB_OPENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone
2	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security