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 NameField TypeColumn TypeDescription
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
MSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
APMSGVERCharacter(30)VARCHAR2(30) NOT NULLMessage Version
IB_MSGSCHEMANumber(1,0)SMALLINT NOT NULLInt Broker Message Schema
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19