AMM_CHNL_WRITE - Msg Monitor Channel Write View

AMM_CHNL_WRITE	index back
Msg Monitor Channel Write View

Security view that lists all channels that an operator has write access for in the Message Monitor.

SELECT DISTINCT A.OPRID , B.CHNLNAME FROM PSOPRCLS A , PSAUTHCHNLMON B WHERE A.OPRCLASS = B.CLASSID AND B.DISPLAYONLY = 0

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

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20

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