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

PSMSGVERCON3_VW

(SQL View)

IB Messages and Versions

Shows concatenated messages and corresponding versions.

SELECT %TrimSubstr(MSGNAME,1,30) %Concat '.' %Concat %TrimSubstr(APMSGVER,1,30) FROM PSMSGVER WHERE IB_MSGTYPE = 2 OR IB_MSGTYPE = 5 OR IB_MSGTYPE = 6

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 IB_XFRMMESSAGE3 Character(61) VARCHAR2(61) NOT NULL Default Message.Version