Share this page

# RPT_DIM_TM_TIME_SHEET_LINES

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

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
TIME_SHEET_LINE_ID | NOT NULL | NUMBER | ID derived from the PPM TM_TIME_SHEET_LINES table
TIME_SHEET_ID | NOT NULL | VARCHAR2(260) | Foreign key to the Time Sheet ID from RPT_DIM_TM_TIME_SHEETS table
STATE | NULLABLE | NUMBER | Time Sheet Line state.
WORK_ITEM_TYPE | NULLABLE | VARCHAR2(255) | Indicates the type of item derived from the PPM TM_TIME_SHEET_LINES table. Valid values are REQUEST, PACKAGE, TASK, PROJECT, and MISC
WORK_ITEM_SET_TYPE | NULLABLE | VARCHAR2(12) | Indicates the type of item set. Valid values are REQUEST_TYPE, WORKFLOW, PROJECT, and MISC
WORK_ITEM_ID | NULLABLE | VARCHAR2(255) | Identifies the item that this line represents derived from the PPM TM_TIME_SHEET_LINES table. Valid values represent Request IDs, Package IDs, Task IDs, and Miscellaneous Items
WORK_ITEM_SET_ID | NULLABLE | VARCHAR2(255) | Identifies the parent type of the item derived from the PPM TM_TIME_SHEET_LINES table. Valid values represent Request Types, Workflows, Projects, and Miscellaneous Items
PROGRAM_ID | NULLABLE | VARCHAR2(255) | Identifies the PPM program against which time is logged for this line
TASK_ID | NULLABLE | VARCHAR2(255) | Identifies the PPM Task against which time is logged for this line
REQUEST_ID | NULLABLE | VARCHAR2(255) | Identifies the PPM Request against which time is logged for this line
PACKAGE_ID | NULLABLE | VARCHAR2(255) | Identifies the PPM Package against which time is logged for this line
MISC_CODE | NULLABLE | VARCHAR2(255) | Identifies the name of the PPM Miscellaneous Item against which time is logged for this line
REQUEST_TYPE_ID | NULLABLE | VARCHAR2(255) | Identifies the PPM request type for the request work item, if it exists for the line
MASTER_PROJECT_ID | NULLABLE | VARCHAR2(255) | Identifies the PPM Project for the Task or Project Work Item, if it exists for the line
ACTUAL_APPROVER_USER_ID | NULLABLE | VARCHAR2(40) | Identifies the PPM Resource who approved this line. This is a foreign key into the RPT_DIM_RM_RESOURCES table
USER_DATA1-20 | NULLABLE | VARCHAR2(255) | User data segment
VISIBLE_USER_DATA1-20 | NULLABLE | VARCHAR2(255) | User data segment
WORK_ITEM_NAME | NULLABLE | VARCHAR2(300) | Name of the work item entity against which time is logged for this line
WORK_ITEM_SET_NAME | NULLABLE | VARCHAR2(300) | Name of the parent entity against which time is logged for this line
REQUEST_TYPE_NAME | NULLABLE | VARCHAR2(80) | PPM Request Type against which time is logged for this line, the WORK_ITEM_TYPE is 'REQUEST'
TASK_NAME | NULLABLE | VARCHAR2(300) | PPM Task Name against which time is logged for this line, the WORK_ITEM_TYPE is 'TASK' or 'PROJECT'
PROGRAM_NAME | NULLABLE | VARCHAR2(300) | PPM program name against which time is logged for this line, the WORK_ITEM_TYPE is 'PROGRAM'
PROJECT_NAME | NULLABLE | VARCHAR2(300) | PPM Project Name against which time is logged for this line, the WORK_ITEM_TYPE is 'TASK' or 'PROJECT'
PACKAGE_NUMBER | NULLABLE | VARCHAR2(40) | PPM Package Number against which time is logged for this line, the WORK_ITEM_TYPE is 'PACKAGE'
CHARGE_CODE_ID | NULLABLE | NUMBER | Foreign key to RPT_DIM_TM_CHARGE_CODES_MV
CHARGE_PERCENT | NULLABLE | FLOAT | Percentage for Charge code
MISC_NAME | NULLABLE | VARCHAR2(150) | PPM Miscellaneous Name against which time is logged for this line when WORK_ITEM_TYPE is 'MISC'
ACTUAL_APPROVER_FIRST_NAME | NULLABLE | VARCHAR2(80) | First Name of the PPM Resource who approved the line
ACTUAL_APPROVER_LAST_NAME | NULLABLE | VARCHAR2(80) | Last Name of the PPM Resource who approved the line
NLS_STATUS | NULLABLE | VARCHAR2(150) | Status of the Time Sheet Line in the PPM definition language

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
RPT_DIM_TM_TIME_SHEET_LIN_1 | NONUNIQUE | 1 | TIME_SHEET_ID
RPT_DIM_TM_TIME_SHEET_LIN_1 | NONUNIQUE | 2 | STATE

## 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: