PSPMSYSDEFN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PM_SYSTEMID	Number(5,0)	INTEGER NOT NULL	Performance Monitor System Identifier.
2	DBNAME	Character(8)	VARCHAR2(8) NOT NULL	Database Name
3	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
4	PM_BUFF_INT	Number(4,0)	SMALLINT NOT NULL	Agent Buffering Interval (sec)
5	PM_MAX_BUFF	Number(9,0)	DECIMAL(9) NOT NULL	Agent Max Buffer Size (bytes)
6	PM_SAMPLE_INT	Number(4,0)	SMALLINT NOT NULL	Agent Event Sample Rate (sec)
7	PM_PING_INT	Number(4,0)	SMALLINT NOT NULL	Agent Heartbeat Interval (sec)
8	PM_MAX_HIST_AGE	Number(4,0)	SMALLINT NOT NULL	Retention period (days)
9	PM_ARCHIVE_MODE	Character(1)	VARCHAR2(1) NOT NULL	Archive Mode 0=Archive Nothing 1=Archive Data 2=Delete Data 3=Delete System Default Value: 0
10	PM_MAX_TRANS_TMOUT	Number(4,0)	SMALLINT NOT NULL	PMU Timeout (days)
11	GUID	Character(36)	VARCHAR2(36) NOT NULL	Unique Identifier
12	PM_USER_TRACE	Character(1)	VARCHAR2(1) NOT NULL	Allow Performance Trace Y/N Table Edit Default Value: N
13	PM_SAMPLING_RATE	Number(5,0)	INTEGER NOT NULL	Agent PMU Sample Rate (1/X)
14	PM_FILTER_LEVEL3	Character(2)	VARCHAR2(2) NOT NULL	Sample Filter Override 00=00-No Change 01=01-Standby 04=04-Standard 05=05-Verbose 06=06-Debug Default Value: 00
15	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
16	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
17	PM_THRESHOLD	Number(9,0)	DECIMAL(9) NOT NULL	Notification Threshold (sec)