HCR_EM_EXCEPT (SQL Table)	Index Back
Event Manager Exceptions HCR Event Manager - Detailed Event Handler Exeptions

HCR_EM_EXCEPT

(SQL Table)

Event Manager Exceptions

HCR Event Manager - Detailed Event Handler Exeptions

# 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_APP_CLASS Character(100) VARCHAR2(100) NOT NULL Implementation App Class

4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

5 HCR_EM_EXCEPT_TYPE Character(1) VARCHAR2(1) NOT NULL HCM Event Manager - Indicator on the Handler Exceptions table that tells us what type of entry this is (Exception, Keys or Trace)
E=Exception
K=Event Keys
T=Trace
Default Value: E

6 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

7 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

8 MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity
C=Cancel
E=Error
M=Message
W=Warning

9 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

10 DESCRLONG Long Character CLOB Long Description

#	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_APP_CLASS	Character(100)	VARCHAR2(100) NOT NULL	Implementation App Class
4	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
5	HCR_EM_EXCEPT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	HCM Event Manager - Indicator on the Handler Exceptions table that tells us what type of entry this is (Exception, Keys or Trace) E=Exception K=Event Keys T=Trace Default Value: E
6	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
7	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
8	MSG_SEVERITY	Character(1)	VARCHAR2(1) NOT NULL	Message Severity C=Cancel E=Error M=Message W=Warning
9	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
10	DESCRLONG	Long Character	CLOB	Long Description