HCR_EM_HNDL_HST (SQL Table)	Index Back
Archive: Event Mgr Handler Log HCR Event Manager - Archive record for HCR_EM_HNDL_LOG (Event Handler Log).

HCR_EM_HNDL_HST

(SQL Table)

Archive: Event Mgr Handler Log

HCR Event Manager - Archive record for HCR_EM_HNDL_LOG (Event Handler Log).

# 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 HCR_EM_DTTM DateTime(26) TIMESTAMP HCR Event Manager - Date Time Stamp.

7 HCR_EM_EXEC_STATUS Character(1) VARCHAR2(1) NOT NULL HCR Event Manager - Registered Code Execution Status
F=FAIL
S=Success

#	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	HCR_EM_DTTM	DateTime(26)	TIMESTAMP	HCR Event Manager - Date Time Stamp.
7	HCR_EM_EXEC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	HCR Event Manager - Registered Code Execution Status F=FAIL S=Success