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 NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
CHNLNAMECharacter(30)VARCHAR2(30) NOT NULLChannel Name (see PSCHNLDEFN).
CHNLSTATUSNumber(1,0)SMALLINT NOT NULLChannel Status
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19