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 |
