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 Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
DISPLAYONLY Number(1,0) SMALLINT NOT NULL Display Only
QUEUESTATUS Number(1,0) SMALLINT NOT NULL Queue Status
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19