Share this page

# PPM_INT_TIMESHEET_DATA

This table stores time sheet line data that created by imported external data..

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
PPM_INT_CONFIGURATIONS | SOLUTION_ID | SOLUTION_ID
PPM_INT_WORK_ITEM_SET | WORK_ITEM_SET_ID | WORKING_SET_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
ID | NOT NULL | NUMBER(19) | Identifier for time
SOLUTION_ID | NOT NULL | NUMBER(19) | The Integration solution Id
NAME | NOT NULL | VARCHAR2(200) | The time sheet line name
WORKING_SET_ID | NOT NULL | NUMBER(19) | ID of the work set that the time sheet line belongs to
DATA_JSON | NOT NULL | VARCHAR2(4000) | The json formatted data of external data for time sheet
DESCRIPTION | NOT NULL | VARCHAR2(4000) | Description of the time sheet line
EFFORT | NOT NULL | NUMBER | The effort of imported external data for time sheet line. DEFAULT: `0`
ERROR_MESSAGE | NOT NULL | VARCHAR2(4000) | The error message when retrieve external time sheet line data
CREATION_DATE | NOT NULL | DATE | Date record was created

## Indexes

This table uses no indexes.

## Sequences

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