HRS_OPRDN_STY_I

(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 ROWSECCLASS , CLASSDEFNDESC FROM PS_OPRDEFN_SCRTY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
2 CLASSDEFNDESC Character(30) VARCHAR2(30) NOT NULL Permission List Description