TM_ACTUALS_EFFORT

This table has a many-to-one relationship with the TM_ACTUALS table. It stores the time breakdown cell data for time sheet items.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

TM_ACTUALS

ACTUALS_ID

ACTUALS_ID

Column Descriptions

Column Name

Null?

Data Type

Description

ACTUALS_ID

NOT NULL

NUMBER

Foreign key to the TM_ACTUALS table.

ACTUAL_EFFORT

NULLABLE

FLOAT

Stores the actual effort for a single cell of data that appears on the time breakdown of a time sheet item.

EFFORT_ORDER

NOT NULL

NUMBER

Defines the sequence order for the ACTUAL_EFFORT of the time breakdown. Valid values for this column start with 1 and increment by 1. Actuals for a time sheet item appear on the time breakdown in this order from left to right.

EFFORT_COST_BSE

NULLABLE

NUMBER

The cost value of the actual effort in base currency.

EFFORT_COST_LCL

NULLABLE

NUMBER

The cost value of the actual effort in local currency.

EFFORT_COST_CUR_LCL

NULLABLE

VARCHAR2(255)

The code for the local currency.

Indexes

Index Name

Index Type

Sequence

Column Name

SYS_C005201594

UNIQUE

1

ACTUALS_ID

SYS_C005201594

UNIQUE

2

EFFORT_ORDER

Sequences

This table uses no sequences.