TR_EVENT_LOG

(SQL Table)
 Index Back

Events for related objects

Contains the events that have occurred for corresponding objects. The objects must have the EVENT_TRACKING_ID stored and use the ID to find the events for it.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EVENT_TRACKING_ID Number(10,0) DECIMAL(10) NOT NULL The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.
2 EVENT_CODE Character(15) VARCHAR2(15) NOT NULL Event code that corresponds to a specific type of event. Can be used for finer filtering of events.

Prompt Table: TR_EVENT_CD_TBL
Set Control Field: EVENT_CODE

3 EVENT_SEQUENCE Character(40) VARCHAR2(40) NOT NULL Event Sequence Number
4 EVENT_DATE DateTime(26) TIMESTAMP NOT NULL Date and time that the event occurred.
5 EVENT_SEVERITY Character(1) VARCHAR2(1) NOT NULL Severity level of a given event.
D=Debug
E=Error
I=Information
N=Note
W=Warning
6 EVENT_PROCESSED Character(1) VARCHAR2(1) NOT NULL States whether an event was processed or not.
N=No
Y=Yes

Default Value: N

7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
8 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
9 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
10 EVENT_MSG_BIND1 Character(254) VARCHAR2(254) NOT NULL Stores bind variable to be used for message retrieval.
11 EVENT_MSG_BIND2 Character(254) VARCHAR2(254) NOT NULL Stores bind variable to be used for message retrieval.
12 EVENT_MSG_BIND3 Character(254) VARCHAR2(254) NOT NULL Stores bind variable to be used for message retrieval.
13 EVENT_CHANGED_SW Character(1) VARCHAR2(1) NOT NULL Switch to determine if there is any detail as to what has changed on the page.
N=No
Y=Yes