KCRT_FG_DEMAND_SCHEDULE

This table stores the Demand Management scheduling data for requests. If the Demand Management Scheduling 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_REQUESTS

REQUEST_ID

REQUEST_ID

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

SCHEDULE_DATE

NULLABLE

DATE

Date that the demand was scheduled

REJECT_DATE

NULLABLE

DATE

Date that the demand was rejected

EFFORT

NULLABLE

NUMBER

Effort associated with the satisfied demand in hours

DEMAND_SATISFIED_DATE

NULLABLE

DATE

Date that the demand was satisfied

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_FG_DEMAND_SCHEDULE_U1

NONUNIQUE

1

REQUEST_ID

Sequences

This table uses no sequences.