PSMSGVERCON5_VW (SQL View)	Index Back
IB Messages and Versions Shows concatenated messages and corresponding versions.

PSMSGVERCON5_VW

(SQL View)

IB Messages and Versions

Shows concatenated messages and corresponding versions.

SELECT DISTINCT %TrimSubstr(V.MSGNAME,1,30) %Concat '.' %Concat %TrimSubstr(V.APMSGVER,1,30) FROM PSMSGVER V , PSMSGREC R WHERE V.MSGNAME = R.MSGNAME AND V.APMSGVER = R.APMSGVER AND V.IB_PARTS = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 IB_XFRMMESSAGE2 Character(61) VARCHAR2(61) NOT NULL Message.Ver out of Transforms