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 NameField TypeColumn TypeDescription
PT_IBNODENAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition.
PT_IBTRXTYPE0Character(4)VARCHAR2(4) NOT NULLTransaction Type
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