PSPMMONITORGBL (SQL Table)	Index Back
Global Setup Performance monitor global setup record. There is only a single row with setup information for the performance monitoring system.

PSPMMONITORGBL

(SQL Table)

Global Setup

Performance monitor global setup record. There is only a single row with setup information for the performance monitoring system.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PM_DBTRUNCATE Character(1) VARCHAR2(1) NOT NULL Archive: Clear PMUs & Events
Y/N Table Edit
Default Value: N

2 PM_ENABLECONSOLE Character(1) VARCHAR2(1) NOT NULL Enable PPMConsole

3 PM_PPM_CONSOLEPWD Character(50) VARCHAR2(50) NOT NULL Console Admin Password

4 PM_GUID_PREFIX Number(10,0) DECIMAL(10) NOT NULL GUID Prefix

5 PM_AGENT_SEQUENCE Number(10,0) DECIMAL(10) NOT NULL Agent Sequence Number

6 PM_SYSTEM_SEQUENCE Number(10,0) DECIMAL(10) NOT NULL System Sequence Number

7 PM_COLL_NUM_ROWS Number(10,0) DECIMAL(10) NOT NULL Maximum Rows

8 PM_SRCH_MAX_ROWS Number(7,0) INTEGER NOT NULL Search Row Limit

9 PM_PPMI_OPRID Character(30) VARCHAR2(30) NOT NULL PPMI User ID
Prompt Table: PSPMPPMIOPR_VW

10 PM_PPMI_PSWD Character(254) VARCHAR2(254) NOT NULL PPMI Password

11 PM_LOOKUP_DTTM DateTime(26) TIMESTAMP Last Look-up Timestamp

12 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.

13 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PM_DBTRUNCATE	Character(1)	VARCHAR2(1) NOT NULL	Archive: Clear PMUs & Events Y/N Table Edit Default Value: N
2	PM_ENABLECONSOLE	Character(1)	VARCHAR2(1) NOT NULL	Enable PPMConsole
3	PM_PPM_CONSOLEPWD	Character(50)	VARCHAR2(50) NOT NULL	Console Admin Password
4	PM_GUID_PREFIX	Number(10,0)	DECIMAL(10) NOT NULL	GUID Prefix
5	PM_AGENT_SEQUENCE	Number(10,0)	DECIMAL(10) NOT NULL	Agent Sequence Number
6	PM_SYSTEM_SEQUENCE	Number(10,0)	DECIMAL(10) NOT NULL	System Sequence Number
7	PM_COLL_NUM_ROWS	Number(10,0)	DECIMAL(10) NOT NULL	Maximum Rows
8	PM_SRCH_MAX_ROWS	Number(7,0)	INTEGER NOT NULL	Search Row Limit
9	PM_PPMI_OPRID	Character(30)	VARCHAR2(30) NOT NULL	PPMI User ID Prompt Table: PSPMPPMIOPR_VW
10	PM_PPMI_PSWD	Character(254)	VARCHAR2(254) NOT NULL	PPMI Password
11	PM_LOOKUP_DTTM	DateTime(26)	TIMESTAMP	Last Look-up Timestamp
12	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.
13	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.