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.