HCR_EM_SUMRY_VW (SQL View)	Index Back
Event Manager - Event Summary HCM Event Manager - This view provides a summary of all Logged Event Instances

HCR_EM_SUMRY_VW

(SQL View)

Event Manager - Event Summary

HCM Event Manager - This view provides a summary of all Logged Event Instances

SELECT HCR_EM_EVENT_NAME , MSGNODENAME , COUNT(*) FROM PS_HCR_EM_EVNT_LOG GROUP BY HCR_EM_EVENT_NAME , MSGNODENAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HCR_EM_EVENT_NAME Character(30) VARCHAR2(30) NOT NULL HCM Event Manager - Event Name (corresponds to Event Handler app class names in HCR_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 HCR_EM_EVENT_COUNT Number(8,0) INTEGER NOT NULL HCM Event Manager - count of logged event instances for the Summary page.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HCR_EM_EVENT_NAME	Character(30)	VARCHAR2(30) NOT NULL	HCM Event Manager - Event Name (corresponds to Event Handler app class names in HCR_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	HCR_EM_EVENT_COUNT	Number(8,0)	INTEGER NOT NULL	HCM Event Manager - count of logged event instances for the Summary page.