AMM_CHNL_SECVW

index back

Msg Monitor Channel Sec View

Security view that lists all channels that an operator has read or write access for in the Message Monitor.
SELECT DISTINCT A.OPRID , B.CHNLNAME , C.CHNLSTATUS FROM PSOPRCLS A , PSAUTHCHNLMON B , PSCHNLDEFN C WHERE A.OPRCLASS = B.CLASSID AND B.CHNLNAME = C.CHNLNAME

PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
CHNLNAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSCHNLDEFN).
CHNLSTATUS Number(1,0) SMALLINT NOT NULL Channel Status
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19