PSPMEVENTARCH

(SQL Table)
Index Back

Event history (archive)

Performance monitor event history table (archive).

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PM_INSTANCE_ID Number(20,0) DECIMAL(20) NOT NULL Instance Identifier
2 PM_EVENT_DEFN_SET Number(5,0) INTEGER NOT NULL Performance Monitor Event Definition Set - used to categorize events.
3 PM_EVENT_DEFN_ID Number(5,0) INTEGER NOT NULL Performance Monitor Event Identifier
4 PM_AGENTID Number(10,0) DECIMAL(10) NOT NULL Performance Monitor Agent Identifier.
5 PM_AGENT_DTTM DateTime(26) TIMESTAMP Agent Date/Time
6 PM_MON_DTTM DateTime(26) TIMESTAMP Monitor Date/Time
7 PM_PROCESS_ID Number(8,0) INTEGER NOT NULL Process ID
8 PM_FILTER_LEVEL Character(2) VARCHAR2(2) NOT NULL Reset all filters
00=00-No Change
01=01-Standby
02=02-Error
03=03-Warning
04=04-Standard
05=05-Verbose
06=06-Debug
9 PM_METRIC_VALUE1 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 1
10 PM_METRIC_VALUE2 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 2
11 PM_METRIC_VALUE3 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 3
12 PM_METRIC_VALUE4 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 4
13 PM_METRIC_VALUE5 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 5
14 PM_METRIC_VALUE6 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 6
15 PM_METRIC_VALUE7 Character(128) VARCHAR2(128) NOT NULL Metric Value 7
16 PM_ADDTNL_DESCR Long Character CLOB Additional Description