HCR_EM_HNDLR_VW

(SQL View)
 Index Back

Event Manager - Handler View

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

SELECT A.MSGNODENAME , A.HCR_EM_EVENT_ID , A.HCR_EM_DTTM , B.HCR_EM_APP_CLASS , B.HCR_EM_EXEC_STATUS , A.HCR_EM_EVENT_NAME , A.CHNLNAME , A.OPRID , A.HCR_EM_KEY_DATA FROM PS_HCR_EM_EVNT_LOG A , PS_HCR_EM_HNDL_LOG B WHERE A.MSGNODENAME = B.MSGNODENAME AND A.HCR_EM_EVENT_ID = B.HCR_EM_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 HCR_EM_EVENT_ID Number(10,0) DECIMAL(10) NOT NULL HCR Event Manager - Raw Binary serial number identifying a particular Event that has been raised in the framework.
3 HCR_EM_DTTM DateTime(26) TIMESTAMP HCR Event Manager - Date Time Stamp.
4 HCR_EM_APP_CLASS Character(100) VARCHAR2(100) NOT NULL Implementation App Class
5 HCR_EM_EXEC_STATUS Character(1) VARCHAR2(1) NOT NULL HCR Event Manager - Registered Code Execution Status
F=FAIL
S=Success
6 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).
7 CHNLNAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSCHNLDEFN).
8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
9 HCR_EM_KEY_DATA Long Character CLOB HCR Event Manager - Contains the Event Keys, coded as XML.