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.