PSOPERATIONACVW

(SQL View)
 Index Back

IB Service App. Class


SELECT H.IB_OPERATIONNAME , H.HANDLERNAME , H.HANDLERID , H.HANDLERTYPE , A.PACKAGEID , A.PACKAGEROOT , A.QUALIFYPATH , A.APPCLASSID FROM PSOPRHDLR H , PSOPERATIONAC A WHERE H.IB_OPERATIONNAME = A.IB_OPERATIONNAME AND H.HANDLERNAME = A.HANDLERNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
2 HANDLERNAME Character(30) VARCHAR2(30) NOT NULL Handler Name
3 HANDLERID Character(4) VARCHAR2(4) NOT NULL Handler Type
NOTF=On Notify
PRNF=On Pre Notify
PTNF=On Post Notify
RECV=On Receive
RESP=On Response
ROUT=On Route
RQST=On Request
SEND=On Send
4 HANDLERTYPE Character(30) VARCHAR2(30) NOT NULL Implementation
5 PACKAGEID Character(30) VARCHAR2(30) NOT NULL Package Name (see PSDIAGREG).
6 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

Prompt Table: PSPACKAGROOT_VW

7 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path

Prompt Table: PSPACKAGPATH_VW

8 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID