Share this page

# RPT_DIM_TM_TIME_SHEETS

This table stores the definition of each Time Sheet within the ETL range derived from the PPM TM_TIME_SHEETS table.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
TIME_SHEET_ID | NOT NULL | NUMBER | ID derived from the PPM TM_TIME_SHEETS table
CREATION_DATE | NOT NULL | DATE | Date on which the time sheet was created.
CREATED_BY | NOT NULL | NUMBER | ID for the user derived who created the time sheet.
RESOURCE_ID | NOT NULL | NUMBER | ID for the user for whom the time sheet was created. This is a foreign key into the RPT_DIM_RM_RESOURCES
DESCRIPTION | NULLABLE | VARCHAR2(650) | Description of the time sheet.
PERIOD_ID | NULLABLE | NUMBER | ID for the period. This is a foreign key to the RPT_DIM_TM_PERIODS_MV
STATUS | NULLABLE | VARCHAR2(150) | Status for the Time Sheet.
TIME_SHEET_NUMBER | NULLABLE | NUMBER | Time Sheet Number.
REQUIRED_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether a time sheet is required for this period based on the Time Sheet Policy for the resource

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
RPT_DIM_TM_TIME_SHEETS_1 | NONUNIQUE | 1 | TIME_SHEET_ID
RPT_DIM_TM_TIME_SHEETS_1 | NONUNIQUE | 2 | STATUS

## Sequences

This table uses no sequences.

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: