EOEN_HNDLR_VW

(SQL View)
 Index Back

Event Manager - Handler View

EOEN Event Manager - This is a view of the Handler Log, that joins Event Instance log information

SELECT A.MSGNODENAME , A.EOEN_EVENT_ID , A.EOEN_DTTM , B.EOEN_APP_CLASS , B.EOEN_EXEC_STATUS , A.EOEN_EVENT_NAME , A.OPRID , A.EOEN_KEY_DATA FROM PS_EOEN_EVNT_LOG A , PS_EOEN_HNDL_LOG B WHERE A.MSGNODENAME = B.MSGNODENAME AND A.EOEN_EVENT_ID = B.EOEN_EVENT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
2 EOEN_EVENT_ID Number(10,0) DECIMAL(10) NOT NULL EOEN Event Manager - Raw Binary serial number identifying a particular Event that has been raised in the framework
3 EOEN_DTTM DateTime(26) TIMESTAMP EOEN Event Manager - Date Time Stamp
4 EOEN_APP_CLASS Character(100) VARCHAR2(100) NOT NULL Implementation App Class
5 EOEN_EXEC_STATUS Character(1) VARCHAR2(1) NOT NULL EOEN Event Manager - Registered Code Execution Statu
F=FAIL
S=Success
6 EOEN_EVENT_NAME Character(30) VARCHAR2(30) NOT NULL EOEN Event Manager - Event Name (corresponds to Event Handler app class names in EOEN_EVENT_MANAGER:Events
7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
8 EOEN_KEY_DATA Long Character CLOB EOEN Event Manager - Contains the Event Keys, coded as XML