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 |