HRS_APP_RSEC_VW (SQL View)	Index Back
RS App Verity Security View This view is used by Recruiting Solutions to implement row level security for accessing applicants via the Verity Index. This view filters what applicants a user may access based on the configuration present.

HRS_APP_RSEC_VW

(SQL View)

RS App Verity Security View

This view is used by Recruiting Solutions to implement row level security for accessing applicants via the Verity Index. This view filters what applicants a user may access based on the configuration present.

SELECT APP.HRS_PERSON_ID ,SEC.ROWSECCLASS FROM PS_HRS_APPLICANT APP ,PS_HRS_RCMNT REC ,PS_HRS_JO_RSEC_VW SEC WHERE REC.HRS_JOB_OPENING_ID = SEC.HRS_JOB_OPENING_ID AND REC.HRS_PERSON_ID = APP.HRS_PERSON_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id

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_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
2	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security