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.