PSPMMETRIC1_LVW (SQL View)	Index Back
Perf. Mon. Metric View Used for prompting.

PSPMMETRIC1_LVW

(SQL View)

Perf. Mon. Metric View

Used for prompting.

SELECT L.PM_METRICID , L.LANGUAGE_CD , L.DESCR60 , L.PM_METRICLABEL FROM PSPMMETRIC_LNG L , PSPMMETRICDEFN M WHERE L.PM_METRICID = M.PM_METRICID AND M.PM_METRICTYPE IN ('1', '2', '3')

Related Language Record for PSPMMETRIC1_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PM_METRICID_1 Number(5,0) INTEGER NOT NULL Performance Monitor Metric Table Identifier

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

4 PM_METRICLABEL_1 Character(30) VARCHAR2(30) NOT NULL Performance Monitor Metric Label

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PM_METRICID_1	Number(5,0)	INTEGER NOT NULL	Performance Monitor Metric Table Identifier
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
4	PM_METRICLABEL_1	Character(30)	VARCHAR2(30) NOT NULL	Performance Monitor Metric Label