KCRT_FG_DEMAND_SCHEDULE_INT

This is a child table of the KCRT_REQUESTS_INT table. It is used to import data into the KCRT_FG_DEMAND_SCHEDULE table. This table will be processed through the Java report that calls a PL/SQL package that can be run either from the command line or through the report job scheduler. This allows the user to immediately run the interface but also allows for scheduled processing. The PL/SQL package queries this table, validates against appropriate tables and imports into the production tables. It can also release the request, depending on its status, by calling the Workflow APIs.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KCRT_REQUESTS_INT	TRANSACTION_ID	PARENT_TRANSACTION_ID
KCRT_REQUESTS	REQUEST_ID	REQUEST_ID
KCRT_REQUEST_TYPES_NLS	REQUEST_TYPE_ID	REQUEST_TYPE_ID

Column Descriptions

Column Name	Null?	Data Type	Description
GROUP_ID	NOT NULL	NUMBER	Value used to tie records in the interface tables together. Most of the database processing is done based on this value. The value must be the same as the parent's GROUP_ID in the KCRT_REQUESTS_INT table.
TRANSACTION_ID	NOT NULL	NUMBER	System-generated record identifier
PARENT_TRANSACTION_ID	NOT NULL	NUMBER	Links this table to TRANSACTION_ID in the KCRT_REQUESTS_INT
REQUEST_ID	NULLABLE	NUMBER	Refers to the REQUEST_ID in KCRT_REQUESTS table
REQUEST_TYPE_ID	NULLABLE	NUMBER	Request type ID used by this 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_INT_N1	NONUNIQUE	1	GROUP_ID
KCRT_FG_DEMAND_SCHEDULE_INT_N1	NONUNIQUE	2	TRANSACTION_ID

Sequences

This table uses no sequences.