PSIBSECURITY_VW

index back

IB Queue Security View

Used to control access to the Asynchronous Monitor data.
SELECT DISTINCT A.OPRID , B.QUEUENAME , B.CLASSID , B.DISPLAYONLY , C.QUEUESTATUS FROM PSOPRCLS A , PSAUTHQUEUEMON B , PSQUEUEDEFN C WHERE A.OPRCLASS = B.CLASSID AND B.QUEUENAME = C.QUEUENAME

PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
QUEUENAMECharacter(30)VARCHAR2(30) NOT NULLChannel Name (see PSQUEUEDEFN).
CLASSIDCharacter(30)VARCHAR2(30) NOT NULLThe name of the class (see PSCLASSDEFN).
DISPLAYONLYNumber(1,0)SMALLINT NOT NULLDisplay Only
QUEUESTATUSNumber(1,0)SMALLINT NOT NULLQueue Status
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19