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.