OPRDEFN_SCRTY2

(SQL View)
Index Back

DEPT and GBL Access Security

View to choose which Operator Classes to set up for Department and Global Access. This view is used in case the Customer wants to change to use Operators instead of Operator Classes. If so , they can modify this view without having to modify the underlying panels. The Operator Class is mapped into the OPRID field and OPRID field is used throughout security. Real SQL will be SELECT CLASSID FROM PSCLASSDEFN for initial 8 build - use SELECT DISTINCT OPRCLASS FROM PSOPRCLS so that this can be done before the upgrade. Change it afterward.

SELECT CLASSID , CLASSDEFNDESC FROM PSCLASSDEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 CLASSDEFNDESC Character(30) VARCHAR2(30) NOT NULL Permission List Description