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. |