JPM_ROWSEC_VW (SQL View)	Index Back
JPM Search Row Level Security Selects all CLASSID's having access to each Emplid.

JPM_ROWSEC_VW

(SQL View)

JPM Search Row Level Security

Selects all CLASSID's having access to each Emplid.

SELECT PERS.EMPLID ,CLS.CLASSID FROM PS_SJT_PERSON PERS , PS_SJT_CLASS_ALL CLS WHERE CLS.SCRTY_SET_CD IN ( 'PPLJOB','PPLPOI' ) AND CLS.SCRTY_TYPE_CD = PERS.SCRTY_TYPE_CD AND CLS.SCRTY_KEY1 = PERS.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = PERS.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = PERS.SCRTY_KEY3

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CLASSID	Character(30)	VARCHAR2(30) NOT NULL	The name of the class (see PSCLASSDEFN).