PSPMSYSDEFAULTS

PeopleSoft Field Name	Field Type	Column Type	Description
PTPHONYKEY	Number(3,0)	SMALLINT NOT NULL	Key Field for ADS definition
PM_SELPROF_ITER	Number(9,0)	DECIMAL(9) NOT NULL	Selective Profiling Iteration
PM_BUFF_INT	Number(4,0)	SMALLINT NOT NULL	Agent Buffering Interval (sec)
PM_UM_BUFFERSIZE	Number(6,0)	INTEGER NOT NULL	Buffer Size
USEMON_SW	Number(3,0)	SMALLINT NOT NULL	Enable Usage Monitoring Default: 0
PM_MAX_BUFF	Number(9,0)	DECIMAL(9) NOT NULL	Agent Max Buffer Size (bytes)
PM_SAMPLE_INT	Number(4,0)	SMALLINT NOT NULL	Agent Event Sample Rate (sec)
PM_PING_INT	Number(4,0)	SMALLINT NOT NULL	Agent Heartbeat Interval (sec)
PM_MAX_HIST_AGE	Number(4,0)	SMALLINT NOT NULL	Retention period (days)
PM_ARCHIVE_MODE	Character(1)	VARCHAR2(1) NOT NULL	Archive Mode 0=Archive Nothing 1=Archive Data 2=Delete Data 3=Delete System Default: 0
PM_MAX_TRANS_TMOUT	Number(4,0)	SMALLINT NOT NULL	PMU Timeout (days)
PM_USER_TRACE	Character(1)	VARCHAR2(1) NOT NULL	Allow Performance Trace Y/N Table Edit Default: N
PM_SAMPLING_RATE	Number(5,0)	INTEGER NOT NULL	Agent PMU Sample Rate (1/X)
PM_FILTER_LEVEL2	Character(2)	VARCHAR2(2) NOT NULL	Reset All Filters 01=01-Standby 02=02-Error 03=03-Warning 04=04-Standard 05=05-Verbose 06=06-Debug
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.
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.

index back

(c)David Kurtz 2020, www.go-faster.co.uk

PeopleTools 8.58 PTRef generated on 21-DEC-20