SCC_MSGVER_PT

(SQL View)
 Index Back

Entity Reg


SELECT %Substring (MSGNAME %Concat '.' %Concat APMSGVER,1,60) , MSGNAME , APMSGVER FROM PSMSGVER WHERE IB_MSGTYPE=4

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_ENTITY_MSG Character(60) VARCHAR2(60) NOT NULL Related IB Message
2 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
3 APMSGVER Character(30) VARCHAR2(30) NOT NULL Message Version