PPM_SERVICE_RECORDS

This table stores information on each run of a background service. By default the last 50 runs are stored and older runs are automatically purged.

To see the data populated in the PPM_SERVICE_RECORDS table, PPM Server administrators need to set the server configuration parameter com.kintana.core.server.LOG_EXCEPTIONS_TO_DB to true.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KNTA_USERS	USER_ID	LAST_UPDATED_BY
KNTA_SERVICES_NLS	SERVICE_ID	SERVICE_ID

Column Descriptions

Column Name	Null?	Data Type	Description
SERVICE_RECORD_ID	NOT NULL	NUMBER	System-generated identifier
CREATED_BY	NOT NULL	NUMBER	Identifier for the user that created the record
CREATION_DATE	NOT NULL	DATE	Date record was created
LAST_UPDATED_BY	NOT NULL	NUMBER	Identifier for the user that last updated the record
LAST_UPDATE_DATE	NOT NULL	DATE	Date record was last updated
VERSION	NOT NULL	NUMBER	System-generated version for the entity. This column should not be updated manually
SERVICE_ID	NULLABLE	NUMBER	The background service id
RUN_START_DATE	NOT NULL	DATE	The start time of the run
RUN_FINISH_DATE	NULLABLE	DATE	The end time of the run
NODE_NAME	NOT NULL	VARCHAR2(128)	The PPM node in which this run took place
STATUS	NULLABLE	VARCHAR2(4000)	Additional information about the run

Indexes

Index Name	Index Type	Sequence	Column Name
PPM_SERVICE_RECORDS_PK	UNIQUE	1	SERVICE_RECORD_ID

Sequences

Sequence Name	Sequence Type
PPM_SERVICE_RECORDS_S	SERVICE_RECORD_ID