SJT_OPR_CLS5_VW (SQL View)	Index Back
SJT table for Operator Classes Secuirty Join Table containing all CLASSIDs for an OPRID. These can be their ROWSECCLASS from PSOPRDEFN - or CLASSIDs that are in SJT_CLASS and are in a Role that the User has.

SJT_OPR_CLS5_VW

(SQL View)

SJT table for Operator Classes

Secuirty Join Table containing all CLASSIDs for an OPRID. These can be their ROWSECCLASS from PSOPRDEFN - or CLASSIDs that are in SJT_CLASS and are in a Role that the User has.

SELECT A.OPRID ,A.CLASSID ,A.SEC_RSC_FLG FROM PS_SJT_OPR_CLS A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

3 SEC_RSC_FLG Character(1) VARCHAR2(1) NOT NULL Flag to indicate that this CLASSID is used for an Operator as their ROWSECCLASS.
1=RowSecclass
2=Role Class
3=Both Rowsecclass and Role
Default Value: 2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	CLASSID	Character(30)	VARCHAR2(30) NOT NULL	The name of the class (see PSCLASSDEFN).
3	SEC_RSC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate that this CLASSID is used for an Operator as their ROWSECCLASS. 1=RowSecclass 2=Role Class 3=Both Rowsecclass and Role Default Value: 2