HRS_JO_TSEC_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_TSEC_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 JO.HRS_JOB_OPENING_ID ,ALS.OPRID FROM PS_HRS_JOB_OPENING JO ,PSOPRDEFN OPR ,PSOPRALIAS ALS ,PS_HRS_JO_TEAM_I TM WHERE ALS.OPRALIASTYPE = 'EMP' AND ALS.OPRID = OPR.OPRID AND TM.EMPLID = ALS.EMPLID AND TM.HRS_JOB_OPENING_ID = JO.HRS_JOB_OPENING_ID

# 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

#	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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).