PSPMTRANSDEFN

(SQL Table)
Index Back

PMU Defn.

Performance monitor PMU definitions.

  • Related Language Record: PSPMTRANS_LNG
  • # 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