PSIBVWMSGVW1

index back

Message Definition View

Prompt View for PeopleTools Message Definition objects. A message is a group of records that is sent between systems. Messages are created and editied using the Application Designer
SELECT DISTINCT A.MSGNODENAME ,A.TRXTYPE , B.MSGNAME , B.CHNLNAME , B.DEFAULTVER , B.MSGSTATUS , B.DESCR , B.OBJECTOWNERID FROM PSNODETRX A , PSMSGDEFN B WHERE A.RQSTMSGNAME = B.MSGNAME

PeopleSoft Field Name Field Type Column Type Description
PT_IBNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition.
PT_IBTRXTYPE0 Character(4) VARCHAR2(4) NOT NULL Transaction Type
MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
CHNLNAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSCHNLDEFN).
DEFAULTVER Character(30) VARCHAR2(30) NOT NULL Default Application Message Version
MSGSTATUS Number(1,0) SMALLINT NOT NULL Message Status
DESCR Character(30) VARCHAR2(30) NOT NULL Description
OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19