PSPMAGENTTYP_VW (SQL View)	Index Back
Agent type view Performance monitor agent type view. Selects distinct agent types from the agent table.

PSPMAGENTTYP_VW

(SQL View)

Agent type view

Performance monitor agent type view. Selects distinct agent types from the agent table.

SELECT DISTINCT PM_SYSTEMID , PM_AGENT_TYPE FROM PSPMAGENT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PM_SYSTEMID Number(5,0) INTEGER NOT NULL Performance Monitor System Identifier.

2 PM_AGENT_TYPE Character(32) VARCHAR2(32) NOT NULL Performance Monitor Agent Name.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PM_SYSTEMID	Number(5,0)	INTEGER NOT NULL	Performance Monitor System Identifier.
2	PM_AGENT_TYPE	Character(32)	VARCHAR2(32) NOT NULL	Performance Monitor Agent Name.