PPM_USAGE_MONITORING

This table stores the PPM usage monitoring information.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

USERNAME

NOT NULL

VARCHAR2(200)

Username of the log-in user

LOGON_SESSION_ID

NOT NULL

NUMBER

User session identifier

MODULE

NULLABLE

VARCHAR2(255)

The module the user visited

PAGE

NULLABLE

VARCHAR2(255)

The page the user visited

FIRST_TIME

NOT NULL

DATE

Date when the user's first hit happened

LAST_TIME

NOT NULL

DATE

Date when the user's last hit happened
COUNT NOT NULL NUMBER The user's hit ount
CREATION_DATE NOT NULL DATE Date when the record was created

Indexes

Index Name

Index Type

Sequence

Column Name

PPM_USAGE_MON_IX1

UNIQUE

 

USERNAME

PPM_USAGE_MON_IX2 NONUNIQUE   CREATION_DATE
PPM_USAGE_MON_IX3 NONUNIQUE   MODULE, PAGE