HCR_EM_EXCP_HST (SQL Table)	Index Back
Archive: Event Mgr Exceptions HCR Event Manager - Archive Record for HCR_EM_EXCEPT (Detailed Event Handler Exeptions)

HCR_EM_EXCP_HST

(SQL Table)

Archive: Event Mgr Exceptions

HCR Event Manager - Archive Record for HCR_EM_EXCEPT (Detailed Event Handler Exeptions)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

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

4 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.

5 HCR_EM_APP_CLASS Character(100) VARCHAR2(100) NOT NULL Implementation App Class

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

7 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

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

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

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

11 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.

12 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	MSGNODENAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
4	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.
5	HCR_EM_APP_CLASS	Character(100)	VARCHAR2(100) NOT NULL	Implementation App Class
6	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
7	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
8	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
9	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
10	MSG_SEVERITY	Character(1)	VARCHAR2(1) NOT NULL	Message Severity C=Cancel E=Error M=Message W=Warning
11	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.
12	DESCRLONG	Long Character	CLOB	Long Description