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 count
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