PTPPB_IBMSG_VW

 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.MSGNAME , A.CHNLNAME , A.DEFAULTVER , A.MSGSTATUS , A.DESCR , A.OBJECTOWNERID FROM PSMSGDEFN A , PSNODETRX B WHERE A.MSGNAME = B.RQSTMSGNAME AND B.TRXTYPE = 'OS' AND MSGSTATUS = 1

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).
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 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20