PSIBSCHEMAS2_VW

index back

SELECT V.IB_OPERATIONNAME , V.VERSIONNAME , V.MSGNAME , V.IB_MSGVERSION , M.IB_MSGSCHEMA FROM PSOPRVERDFNPARM V , PSMSGVER M WHERE V.MSGNAME = M.MSGNAME AND V.IB_MSGVERSION = M.APMSGVER

PeopleSoft Field Name Field Type Column Type Description
IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
APMSGVER Character(30) VARCHAR2(30) NOT NULL Message Version
IB_MSGSCHEMA Number(1,0) SMALLINT NOT NULL Int Broker Message Schema
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20