PSPTUMPMTAGR

(SQL Table)
Index Back

Usage Monitor Aggregation Tbl

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTUM_GUID Character(36) VARCHAR2(36) NOT NULL Guid
2 DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
3 TOOLSREL Character(20) VARCHAR2(20) NOT NULL Tools Release Number
4 PTUM_MAX_DTTM DateTime(26) TIMESTAMP Max Date Time
5 PTUM_MIN_DTTM DateTime(26) TIMESTAMP Min Date Time
6 PTUSERNAME Character(30) VARCHAR2(30) NOT NULL User Name
7 PTTST_NAME Character(30) VARCHAR2(30) NOT NULL Test Name (see PSPTTSTDEFN).
8 PTTST_CASE_NAME Character(30) VARCHAR2(30) NOT NULL Test Case Name
9 PTBUSTRANSACTION Character(60) VARCHAR2(60) NOT NULL Business Transaction
10 OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type
11 OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1
12 OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL Object Value 2
13 OBJECTVALUE3 Character(30) VARCHAR2(30) NOT NULL Object Value 3
14 OBJECTVALUE4 Character(30) VARCHAR2(30) NOT NULL Object Value 4
15 OBJECTVALUE5 Character(30) VARCHAR2(30) NOT NULL Object Value 5
16 OBJECTVALUE6 Character(30) VARCHAR2(30) NOT NULL Object Value 6
17 OBJECTVALUE7 Character(30) VARCHAR2(30) NOT NULL Object Value 7
18 ROW_COUNT Number(8,0) INTEGER NOT NULL Number to Purge