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 NameField TypeColumn TypeDescription
MSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
CHNLNAMECharacter(30)VARCHAR2(30) NOT NULLChannel Name (see PSCHNLDEFN).
DEFAULTVERCharacter(30)VARCHAR2(30) NOT NULLDefault Application Message Version
MSGSTATUSNumber(1,0)SMALLINT NOT NULLMessage Status
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19