RPT_FCT_TM_COST

This table stores the Effort data for a Work Item on a Time Sheet Line.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

COST_ID

NOT NULL

NUMBER

System-generated identifier by the sequence RPT_FCT_TM_COST_S

TIME_SHEET_LINE_ID

NOT NULL

NUMBER

ID derived from the PPM TM_TIME_SHEET_LINES table.

TIME_SHEET_ID

NOT NULL

NUMBER

ID derived from the PPM TM_TIME_SHEETS table.

ACT_CAP_LABOR_BSE

NULLABLE

NUMBER

Actual Capitalized Cost.

ACT_OP_LABOR_BSE

NULLABLE

NUMBER

Actual Operational Cost.

CUR_BSE

NULLABLE

VARCHAR2(255)

Base currency used for actual cost on time sheets.

ACTUAL_EFFORT

NULLABLE

NUMBER

Actual effort in hours on the time sheet line.

Indexes

Index Name

Index Type

Sequence

Column Name

RPT_FCT_TM_COST_B1

NONUNIQUE

1

TIME_SHEET_ID

RPT_FCT_TM_COST_B2

NONUNIQUE

1

TIME_SHEET_LINE_ID

SYS_C003624099

UNIQUE

1

COST_ID

Sequences

Sequence Name

Sequence Type

RPT_FCT_TM_COST_S

COST_ID