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.