Share this page

# TM_ACTUALS

This table stores the actuals for each time sheet item including cost information and associated Activities. A single time sheet item will contain a row in this table for each Activity associated with the item (a single row if no Activities are used), and an additional row for the total, which is indicated by the TOTALS_FLAG.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
ITG_ACTIVITIES_NLS | ACTIVITY_ID | ACTIVITY_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY
TM_TIME_SHEET_LINES | TIME_SHEET_LINE_ID | TIME_SHEET_LINE_ID
KNTA_USERS | USER_ID | CREATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
ACTUALS_ID | NOT NULL | NUMBER | System-generated identifier
VERSION | NOT NULL | NUMBER | System-generated version for the entity. This column must not be updated manually.
ACTIVITY_ID | NULLABLE | NUMBER | Indicates an associated Activity to time sheet item.
ACT_CAP_LABOR_BSE | NULLABLE | NUMBER | Captures the actual capitalized labor costs in the system's base currency.
ACT_CAP_LABOR_LCL | NULLABLE | NUMBER | Captures the actual capitalized labor costs in the local currency.
ACT_CAP_LABOR_CUR_LCL | NULLABLE | VARCHAR2(255) | Captures the currency code for the local currency used by the actual capitalized labor costs.
ACT_CAP_NON_LABOR_BSE | NULLABLE | NUMBER | Captures the actual capitalized non-labor costs in the system's base currency.
ACT_CAP_NON_LABOR_LCL | NULLABLE | NUMBER | Captures the actual capitalized non-labor costs in the local currency.
ACT_CAP_NON_LABOR_CUR_LCL | NULLABLE | VARCHAR2(255) | Captures the currency code for the local currency used by the actual capitalized non-labor costs.
ACT_OP_LABOR_BSE | NULLABLE | NUMBER | Captures the actual operational labor costs in the system's base currency.
ACT_OP_LABOR_LCL | NULLABLE | NUMBER | Captures the actual operational labor costs in the local currency.
ACT_OP_LABOR_CUR_LCL | NULLABLE | VARCHAR2(255) | Captures the currency code for the local currency used by the actual operational labor costs.
ACT_OP_NON_LABOR_BSE | NULLABLE | NUMBER | Captures the actual operational non-labor costs in the system's base currency.
ACT_OP_NON_LABOR_LCL | NULLABLE | NUMBER | Captures the actual operational non-labor costs in the local currency.
ACT_OP_NON_LABOR_CUR_LCL | NULLABLE | VARCHAR2(255) | Captures the currency code for the local currency used by the actual operational non-labor costs.
TOTALS_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether the row represents a total for a single time sheet item, as opposed to an Activity. Y = Total, N = Non-Total.
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
TIME_SHEET_LINE_ID | NULLABLE | NUMBER | References the TIME_SHEET_LINE_ID in TM_TIME_SHEET_LINES.
TIME_ACTUALS_SEQ | NULLABLE | NUMBER | Captures the internal ordering of the rows for each time sheet item.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
FK19BFB4DFA2C1EF93_I | NONUNIQUE | 1 | ACTIVITY_ID
FK19BFB4DFE2408E7_I | NONUNIQUE | 1 | TIME_SHEET_LINE_ID
SYS_C005201593 | UNIQUE | 1 | ACTUALS_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
TM_ACTUALS_S | ACTUALS_ID

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: