KCRT_FG_SLA

If the Demand Management SLA field group is linked to a request's request header type, a row will exist in this table for the request.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KCRT_REQUEST_TYPES_NLS	REQUEST_TYPE_ID	REQUEST_TYPE_ID

Column Descriptions

Column Name	Null?	Data Type	Description
REQUEST_ID	NOT NULL	NUMBER	Request identifier
REQUEST_TYPE_ID	NOT NULL	NUMBER	Request type used by the request
SERVICE_REQUESTED_DATE	NULLABLE	DATE	Date that the service was requested
SLA_LEVEL_CODE	NULLABLE	VARCHAR2(30)	Service level agreement level. See lookup type 'DEM - SLA Level'
SLA_LEVEL	NULLABLE	VARCHAR2(100)	Service level agreement level. See lookup type 'DEM - SLA Level'
VIOLATION_DATE	NULLABLE	DATE	Date that the SLA rule was violated
SERVICE_SATISFIED_DATE	NULLABLE	DATE	Date that the service was satisfied

Indexes

Index Name	Index Type	Sequence	Column Name
KCRT_FG_SLA_U1	NONUNIQUE	1	REQUEST_ID

Sequences

This table uses no sequences.