AMM_CHNL_SECVW (SQL View)	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.

AMM_CHNL_SECVW

(SQL View)

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 PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 CHNLNAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSCHNLDEFN).

3 CHNLSTATUS Number(1,0) SMALLINT NOT NULL Channel Status

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	CHNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Channel Name (see PSCHNLDEFN).
3	CHNLSTATUS	Number(1,0)	SMALLINT NOT NULL	Channel Status