KCRT_REQUEST_RSC_ACTUALS

This table stores the actuals for the resources assigned to a request.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

REQUEST_RSC_ACTUALS_ID

NULLABLE

NUMBER

System-generated identifier

ACTUAL_EFFORT

NULLABLE

NUMBER

For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update.

ACTUAL_START

NULLABLE

DATE

ACTUAL_FINISH

NULLABLE

DATE

SCHEDULED_EFFORT

NULLABLE

NUMBER

FROM_TM_FLAG

NOT NULL

VARCHAR2(1)

Not null column

Indexes

This table uses no indexes.

Sequences

Sequence Name

Sequence Type

KCRT_REQUEST_RSC_ACTUALS_S

REQUEST_RSC_ACTUALS_ID