PSPTUMPMTAGR

index back

Usage Monitor Aggregation Tbl


PeopleSoft Field Name Field Type Column Type Description
PTUM_GUID Character(36) VARCHAR2(36) NOT NULL Guid
DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
TOOLSREL Character(20) VARCHAR2(20) NOT NULL Tools Release Number
PTUM_MAX_DTTM DateTime(26) TIMESTAMP Max Date Time
PTUM_MIN_DTTM DateTime(26) TIMESTAMP Min Date Time
PTUSERNAME Character(30) VARCHAR2(30) NOT NULL User Name
PTTST_NAME Character(30) VARCHAR2(30) NOT NULL Test Name (see PSPTTSTDEFN).
PTTST_CASE_NAME Character(30) VARCHAR2(30) NOT NULL Test Case Name
PTBUSTRANSACTION Character(60) VARCHAR2(60) NOT NULL Business Transaction
OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type
OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1
OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL Object Value 2
OBJECTVALUE3 Character(30) VARCHAR2(30) NOT NULL Object Value 3
OBJECTVALUE4 Character(30) VARCHAR2(30) NOT NULL Object Value 4
OBJECTVALUE5 Character(30) VARCHAR2(30) NOT NULL Object Value 5
OBJECTVALUE6 Character(30) VARCHAR2(30) NOT NULL Object Value 6
OBJECTVALUE7 Character(30) VARCHAR2(30) NOT NULL Object Value 7
ROW_COUNT Number(8,0) INTEGER NOT NULL Number to Purge
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19