PSPMTRANSDEFN(SQL Table) |
Index Back |
---|---|
PMU Defn.Performance monitor PMU definitions. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PM_TRANS_DEFN_SET | Number(5,0) | INTEGER NOT NULL | Performance monitor transaction definition set number. |
2 | PM_TRANS_DEFN_ID | Number(5,0) | INTEGER NOT NULL | Performance Monitor Transaction Definition Identifier. |
3 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
4 | PM_TRANS_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Performance Monitor Transaction Label. |
5 | PM_ADDTNL_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Additional Data Label |
6 | PM_CONTEXTID_1 | Number(5,0) | INTEGER NOT NULL |
Context Identifier 1
Prompt Table: PSPMCONTEXT1_VW |
7 | PM_CONTEXTID_2 | Number(5,0) | INTEGER NOT NULL |
Context Identifier 2
Prompt Table: PSPMCONTEXT2_VW |
8 | PM_CONTEXTID_3 | Number(5,0) | INTEGER NOT NULL |
Context Identifier 3
Prompt Table: PSPMCONTEXT3_VW |
9 | PM_METRICID_1 | Number(5,0) | INTEGER NOT NULL |
Performance Monitor Metric Table Identifier
Prompt Table: PSPMMETRIC1_VW |
10 | PM_METRICID_2 | Number(5,0) | INTEGER NOT NULL |
Performance Monitor Metric Table Identifier
Prompt Table: PSPMMETRIC2_VW |
11 | PM_METRICID_3 | Number(5,0) | INTEGER NOT NULL |
Performance Monitor Metric Table Identifier
Prompt Table: PSPMMETRIC3_VW |
12 | PM_METRICID_4 | Number(5,0) | INTEGER NOT NULL |
Performance Monitor Metric Table Identifier
Prompt Table: PSPMMETRIC4_VW |
13 | PM_METRICID_5 | Number(5,0) | INTEGER NOT NULL |
Performance Monitor Metric Table Identifier
Prompt Table: PSPMMETRIC5_VW |
14 | PM_METRICID_6 | Number(5,0) | INTEGER NOT NULL |
Performance Monitor Metric Table Identifier
Prompt Table: PSPMMETRIC6_VW |
15 | PM_METRICID_7 | Number(5,0) | INTEGER NOT NULL |
Performance Monitor Metric Table Identifier
Prompt Table: PSPMMETRIC7_VW |
16 | PM_DISPLAY_C1 | Character(1) | VARCHAR2(1) NOT NULL |
Display context 1
Y/N Table Edit Default Value: N |
17 | PM_DISPLAY_C2 | Character(1) | VARCHAR2(1) NOT NULL |
Display context 2
Y/N Table Edit Default Value: N |
18 | PM_DISPLAY_C3 | Character(1) | VARCHAR2(1) NOT NULL |
Display context 3
Y/N Table Edit Default Value: N |
19 | PM_DISPLAY_M1 | Character(1) | VARCHAR2(1) NOT NULL |
Display Metric 1
Y/N Table Edit Default Value: N |
20 | PM_DISPLAY_M2 | Character(1) | VARCHAR2(1) NOT NULL |
Display Metric 2
Y/N Table Edit Default Value: N |
21 | PM_DISPLAY_M3 | Character(1) | VARCHAR2(1) NOT NULL |
Display Metric 3
Y/N Table Edit Default Value: N |
22 | PM_DISPLAY_M4 | Character(1) | VARCHAR2(1) NOT NULL |
Display Metric 4
Y/N Table Edit Default Value: N |
23 | PM_DISPLAY_M5 | Character(1) | VARCHAR2(1) NOT NULL |
Display Metric 5
Y/N Table Edit Default Value: N |
24 | PM_DISPLAY_M6 | Character(1) | VARCHAR2(1) NOT NULL |
Display Metric 6
Y/N Table Edit Default Value: N |
25 | PM_DISPLAY_M7 | Character(1) | VARCHAR2(1) NOT NULL |
Display Metric 7
Y/N Table Edit Default Value: N |
26 | PM_FILTER_LEVEL | Character(2) | VARCHAR2(2) NOT NULL |
Reset all filters
00=00-No Change 01=01-Standby 02=02-Error 03=03-Warning 04=04-Standard 05=05-Verbose 06=06-Debug Default Value: 03 |
27 | PM_SAMPLING_ENABLE | Character(1) | VARCHAR2(1) NOT NULL |
Enable Sampling
Y/N Table Edit Default Value: Y |