ITG_COMPONENTS

This table stores all components that contain cost and effort information.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

ITG_CALENDAR

CALENDAR_ID

CALENDAR_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_USERS

USER_ID

CREATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

COMPONENT_ID

NOT NULL

NUMBER

System-generated identifier

COMPONENT_TYPE_CODE

NOT NULL

NUMBER

Type of component

VERSION

NOT NULL

NUMBER

System-generated version for the entity. This column must not be updated manually

BUSY_AMOUNT

NULLABLE

FLOAT

Busy amount for this component

START_TIME

NULLABLE

DATE

Start instant for this component

FINISH_TIME

NULLABLE

DATE

Finish instant for this component

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

ACT_CAP_LABOR_BSE

NULLABLE

NUMBER

Base value of the actual capitalized labor cost

ACT_CAP_LABOR_LCL

NULLABLE

NUMBER

Local value of the actual capitalized labor cost

ACT_CAP_LABOR_CUR_LCL

NULLABLE

VARCHAR2(255)

Local currency code of the actual capitalized labor cost

ACT_CAP_NON_LABOR_BSE

NULLABLE

NUMBER

Base value of the actual capitalized non-labor cost

ACT_CAP_NON_LABOR_LCL

NULLABLE

NUMBER

Local value of the actual capitalized non-labor cost

ACT_CAP_NON_LABOR_CUR_LCL

NULLABLE

VARCHAR2(255)

Local currency code of the actual capitalized non-labor cost

ACT_OP_LABOR_BSE

NULLABLE

NUMBER

Indicates the base value of the actual operational labor cost

ACT_OP_LABOR_LCL

NULLABLE

NUMBER

Local value of the actual operational labor cost

ACT_OP_LABOR_CUR_LCL

NULLABLE

VARCHAR2(255)

Local currency code of the actual operational labor cost

ACT_OP_NON_LABOR_BSE

NULLABLE

NUMBER

Base value of the actual operational non-labor cost

ACT_OP_NON_LABOR_LCL

NULLABLE

NUMBER

Local value of the actual operational non-labor cost

ACT_OP_NON_LABOR_CUR_LCL

NULLABLE

VARCHAR2(255)

Local currency code of the actual operational non-labor cost

PLAN_CAP_LABOR_BSE

NULLABLE

NUMBER

Base value of the planned capitalized labor cost

PLAN_CAP_LABOR_LCL

NULLABLE

NUMBER

Local value of the planned capitalized labor cost

PLAN_CAP_LABOR_CUR_LCL

NULLABLE

VARCHAR2(255)

Local currency code of the planned capitalized labor cost

PLAN_CAP_NON_LABOR_BSE

NULLABLE

NUMBER

Base value of the planned capitalized non-labor cost

PLAN_CAP_NON_LABOR_LCL

NULLABLE

NUMBER

Local value of the planned capitalized non-labor cost

PLAN_CAP_NON_LABOR_CUR_LCL

NULLABLE

VARCHAR2(255)

Local currency code of the planned capitalized non-labor cost

PLAN_OP_LABOR_BSE

NULLABLE

NUMBER

Base value of the planned operational labor cost

PLAN_OP_LABOR_LCL

NULLABLE

NUMBER

Local value of the planned operational labor cost

PLAN_OP_LABOR_CUR_LCL

NULLABLE

VARCHAR2(255)

Local currency code of the planned operational labor cost

PLAN_OP_NON_LABOR_BSE

NULLABLE

NUMBER

Base value of the planned operational non-labor cost

PLAN_OP_NON_LABOR_LCL

NULLABLE

NUMBER

Local value of the planned operational non-labor cost

PLAN_OP_NON_LABOR_CUR_LCL

NULLABLE

VARCHAR2(255)

Local currency code of the planned operational non-labor cost

EXCHANGE_RATE

NULLABLE

NUMBER

Exchange rate

CALENDAR_ID

NULLABLE

NUMBER

Provides the calendar ID used for this component. This value must correspond to CALENDAR_ID in ITG_CALENDAR

COMPONENT_SEQ

NULLABLE

NUMBER

Sequence number of this component

Indexes

Index Name

Index Type

Sequence

Column Name

FKF60306995F1CC5BE_I

NONUNIQUE

1

CALENDAR_ID

SYS_C005201536

UNIQUE

1

COMPONENT_ID

Sequences

Sequence Name

Sequence Type

ITG_COMPONENTS_S

COMPONENT_ID