PT_EVENT_LOG

index back

PeopleSoft Field Name Field Type Column Type Description
MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
GUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
PT_EVENT_LONGPARM Long Character CLOB Event Long Parameter
PT_EVENT_PARAM1 Character(254) VARCHAR2(254) NOT NULL Event parameter
PT_EVENT_PARAM2 Character(254) VARCHAR2(254) NOT NULL Event parameter
PT_EVENT_PARAM3 Character(254) VARCHAR2(254) NOT NULL Event parameter
PT_EVENT_PARAM4 Character(254) VARCHAR2(254) NOT NULL Event parameter
PT_EVENT_PARAM5 Character(254) VARCHAR2(254) NOT NULL Event parameter
MSG_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
MSG_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
PT_MSG_PARAM1 Character(254) VARCHAR2(254) NOT NULL Event parameter
PT_MSG_PARAM2 Character(254) VARCHAR2(254) NOT NULL Event parameter
PT_MSG_PARAM3 Character(254) VARCHAR2(254) NOT NULL Event parameter
PT_MSG_PARAM4 Character(254) VARCHAR2(254) NOT NULL Event parameter
PT_MSG_PARAM5 Character(254) VARCHAR2(254) NOT NULL Event parameter
CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
PROCESSID Signed Number(11,0) DECIMAL(10) NOT NULL Process Identifier
HOSTNAME Character(254) VARCHAR2(254) NOT NULL Host
SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name
DOMAIN Character(50) VARCHAR2(50) NOT NULL Domain
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19