EOEN_SUMRY_VW (SQL View)	Index Back
Event Manager - Event Summary EOEN Event Manager - This view provides a summary of all Logged Event Instance

EOEN_SUMRY_VW

(SQL View)

Event Manager - Event Summary

EOEN Event Manager - This view provides a summary of all Logged Event Instance

SELECT EOEN_EVENT_NAME , MSGNODENAME , COUNT(*) FROM PS_EOEN_EVNT_LOG GROUP BY EOEN_EVENT_NAME , MSGNODENAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).

3 EOEN_EVENT_COUNT Number(8,0) INTEGER NOT NULL EOEN Event Manager - count of logged event instances for the Summary page

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	MSGNODENAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
3	EOEN_EVENT_COUNT	Number(8,0)	INTEGER NOT NULL	EOEN Event Manager - count of logged event instances for the Summary page