PSPMEVENTHIST

index back

Event history

Performance monitor event history table.

PeopleSoft Field Name Field Type Column Type Description
PM_INSTANCE_ID Number(20,0) DECIMAL(20) NOT NULL Instance Identifier
PM_EVENT_DEFN_SET Number(5,0) INTEGER NOT NULL Performance Monitor Event Definition Set - used to categorize events.
PM_EVENT_DEFN_ID Number(5,0) INTEGER NOT NULL Performance Monitor Event Identifier
PM_AGENTID Number(10,0) DECIMAL(10) NOT NULL Performance Monitor Agent Identifier.
PM_AGENT_DTTM DateTime(26) TIMESTAMP Agent Date/Time
PM_MON_DTTM DateTime(26) TIMESTAMP Monitor Date/Time
PM_PROCESS_ID Number(8,0) INTEGER NOT NULL Process ID
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
PM_METRIC_VALUE1 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 1
PM_METRIC_VALUE2 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 2
PM_METRIC_VALUE3 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 3
PM_METRIC_VALUE4 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 4
PM_METRIC_VALUE5 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 5
PM_METRIC_VALUE6 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 6
PM_METRIC_VALUE7 Character(128) VARCHAR2(128) NOT NULL Metric Value 7
PM_ADDTNL_DESCR Long Character CLOB Additional Description
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20