PSMSGVER2_VW

index back

IB Messages and Versions

View of unstructured messages.
SELECT A.MSGNAME , A.APMSGVER , A.IB_PARTS FROM PSMSGVER A WHERE NOT EXISTS ( SELECT 'X' FROM PSMSGREC B WHERE B.MSGNAME = A.MSGNAME AND B.APMSGVER = A.APMSGVER)

PeopleSoft Field Name Field Type Column Type Description
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_PARTS Number(1,0) SMALLINT NOT NULL Message Parts
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20