PSIBMSGSERV_VW (SQL View)	Index Back
Messages for a Service. Shows IB Messages that are tied to IB Services.

PSIBMSGSERV_VW

(SQL View)

Messages for a Service.

Shows IB Messages that are tied to IB Services.

SELECT DISTINCT S.IB_SERVICENAME , S.IB_PSOFTSERVICE , P.MSGNAME , P.IB_MSGVERSION , P.QUEUENAME FROM PSSERVICE S , PSSERVICEOPR B , PSOPERATION O , PSOPRVERDFNPARM P WHERE S.IB_SERVICENAME = B.IB_SERVICENAME AND B.IB_OPERATIONNAME = O.IB_OPERATIONNAME AND O.IB_OPERATIONNAME = P.IB_OPERATIONNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).

2 IB_PSOFTSERVICE Character(1) VARCHAR2(1) NOT NULL Restricted Service

3 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).

4 IB_MSGVERSION Character(30) VARCHAR2(30) NOT NULL Message Version

5 QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	IB_SERVICENAME	Character(30)	VARCHAR2(30) NOT NULL	Service (see PSSERVICE).
2	IB_PSOFTSERVICE	Character(1)	VARCHAR2(1) NOT NULL	Restricted Service
3	MSGNAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
4	IB_MSGVERSION	Character(30)	VARCHAR2(30) NOT NULL	Message Version
5	QUEUENAME	Character(30)	VARCHAR2(30) NOT NULL	Channel Name (see PSQUEUEDEFN).