Share this page

# TM_TIME_SHEETS

This table stores the definition of each time sheet including the copied policy information from the resource's time sheet policy.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
ITG_TRUSTEE | TRUSTEE_ID | BASE_TRUSTEE_ID
KNTA_SECURITY_GROUPS_NLS | SECURITY_GROUP_ID | BILLING_APPROVER_SEC_GRP_ID
ITG_CALENDAR | CALENDAR_ID | CALENDAR_ID
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KTMG_PERIODS | PERIOD_ID | PERIOD_ID
RSC_RESOURCES | RESOURCE_ID | RESOURCE_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
TIME_SHEET_ID | NOT NULL | NUMBER | System-generated identifier
VERSION | NOT NULL | NUMBER | System-generated version for the entity. This column must not be updated manually
RESOURCE_ID | NOT NULL | NUMBER | Identifies the Resource that this time sheet belongs to.
PERIOD_ID | NULLABLE | NUMBER | Identifies the period for which this time sheet tracks actuals
CALENDAR_ID | NOT NULL | NUMBER | Identifies the unique internal calendar for the time sheet. It is used by the system to keep track of actual information and must not be modified. This calendar does not reference the Resource's calendar.
STATUS_CODE | NULLABLE | NUMBER | Indicates the status of the time sheet
DESCRIPTION | NULLABLE | VARCHAR2(650) | Describes the time sheet. This value defaults to the format "Resource - Period".
SEQ | NULLABLE | NUMBER | Contains the internal order of time sheets for display when a Resource has multiple time sheets for a given period.
EXCEPTION_MESSAGE | NULLABLE | VARCHAR2(650) | Stores the policy exceptions for display in the time sheet, if any exceptions exist.
BASE_TRUSTEE_ID | NULLABLE | NUMBER | Identifies the billing approver of the time sheet if it is configured to be a participant group.
BILLING_APPROVER_SEC_GRP_ID | NULLABLE | NUMBER | Identifies the billing approver of the time sheet if it is configured to be a Security Group.
TIME_ENTRY_DURATION_CODE | NULLABLE | VARCHAR2(255) | Indicates the granularity of effort entered into the time sheet. This is controlled by the time sheet Policy. Valid values are DAY and PERIOD.
TIME_ENTRY_UNIT_CODE | NULLABLE | VARCHAR2(255) | Indicates the unit of measurement for time entry into the time sheet. This is controlled by the time sheet Policy. Valid values are HOURS and PERCENT.
PERIOD_HOURS_CALC_TYPE_CODE | NULLABLE | VARCHAR2(255) | Indicates the setting for calculating the number of hours in a period. This is controlled by the time sheet policy. Valid values are WORKDAY and FIXED.
PERIOD_HOURS | NULLABLE | NUMBER | If PERIOD_HOURS_CALC_TYPE_CODE is set to FIXED, this column indicates the fixed number of hours in a period.
WORKDAY_HOURS | NULLABLE | NUMBER | If PERIOD_HOURS_CALC_TYPE_CODE is set to WORKDAY, this column indicates the number of hours in a working day.
DUPLICATE_ALLOWED_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether multiple time sheets are allowed in a given period.
MIN_MAX_HOURS_CALC_TYPE_CODE | NULLABLE | VARCHAR2(255) | Indicates the setting for calculating the number of hours when checking for minimum and maximum requirements. This is controlled by the time sheet Policy.
TIME_SHEET_REQUIRED_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether a Resource must submit a time sheet for every period.
MAX_HOURS_PER_DAY | NULLABLE | NUMBER | Indicates the maximum number of hours per day a Resource may log time for in the time sheet.
MAX_HOURS_PER_TIME_SHEET | NULLABLE | NUMBER | Indicates the maximum number of hours per time sheet a Resource may log.
MIN_HOURS_PER_TIME_SHEET | NULLABLE | NUMBER | Indicates the minimum number of hours per time sheet a Resource must log.
MAX_PERCENT_PER_TIMESHEET | NULLABLE | NUMBER | Indicates the maximum percentage allowed on the time sheet.
MIN_PERCENT_PER_TIMESHEET | NULLABLE | NUMBER | Indicates the minimum percentage required on the time sheet.
PREVENT_VIOLATION_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether a Resource is prevented from submitting a time sheet if there are policy violations.
PGM_ACTIVITIES_REQUIRED_FLAG | NOT NULL | VARCHAR2(1) | Indicates whether Activities are required to be added to Program items on the time sheet.
REQ_ACTIVITIES_REQUIRED_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether Activities are required to be added to Request items on the time sheet.
TSK_ACTIVITIES_REQUIRED_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether Activities are required to be added to Task items on the time sheet.
PRJ_ACTIVITIES_REQUIRED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether Activities are required to be added to Project items on the time sheet.
PKG_ACTIVITIES_REQUIRED_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether Activities are required to be added to Package items on the time sheet.
MISC_ACTIVITIES_REQUIRED_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether Activities are required to be added to Miscellaneous items on the time sheet.
WORKITEM_REQ_ENABLED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether Requests can be added as work item to the time sheet.
WORKITEM_TSK_ENABLED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether Tasks can be added as work item to the time sheet.
WORKITEM_PGM_ENABLED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether Programs can be added as work item to the time sheet.
WORKITEM_PRJ_ENABLED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether Projects can be added as work item to the time sheet.
WORKITEM_PKG_ENABLED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether Packages can be added as work item to the time sheet.
WORKITEM_MSC_ENABLED_FLAG | NOT NULL | VARCHAR2(4) | Indicates whether Miscellaneous can be added as work item to the time sheet.
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
CREATION_DATE | NOT NULL | DATE | Date the 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
ALLOW_EMPTY_LINE | NOT NULL | NUMBER | Level how to deal with empty time sheet lines in this time sheet
ITG_ACTIVITIES_REQUIRED_FLAG | NOT NULL | VARCHAR2(1) | (Added in 9.22) Flag to show whether the activity is required on Item type External Data for the specific time sheet
WORKITEM_INT_ENABLED_FLAG | NOT NULL | VARCHAR2(1) | (Added in 9.22) Flag to show whether External Data is enabled as an work item for the specific time sheet

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
FKF38627E05BD31FCB_I | NONUNIQUE | 1 | BASE_TRUSTEE_ID
FKF38627E05F1CC5BE_I | NONUNIQUE | 1 | CALENDAR_ID
FKF38627E0A1B1A5A3_I | NONUNIQUE | 1 | RESOURCE_ID
FKF38627E0A7DB71D8_I | NONUNIQUE | 1 | BILLING_APPROVER_SEC_GRP_ID
SYS_C005201597 | UNIQUE | 1 | TIME_SHEET_ID
TM_TIME_SHEETS_N1 | NONUNIQUE | 1 | PERIOD_ID
TM_TIME_SHEETS_N3 | NONUNIQUE | 1 | STATUS_CODE
TM_TIME_SHEETS_N3 | NONUNIQUE | 2 | RESOURCE_ID
TM_TIME_SHEETS_N3 | NONUNIQUE | 3 | PERIOD_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
TM_TIME_SHEETS_S | TIME_SHEET_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: