PJS_UDB_TASK_DTLS

This table stores the project task details.

Details

  • Schema: FUSION

  • Object owner: FUSION

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
PROJECT_ID NUMBER 18 Yes PROJECT_ID
PLAN_LINE_ID NUMBER 18 Yes PLAN_LINE_ID
PROJ_ELEMENT_ID NUMBER 18 Yes PROJ_ELEMENT_ID
PLAN_HRS_INCREASED_FLAG VARCHAR2 1 PLAN_HRS_INCREASED_FLAG
START_DELAYED_FLAG VARCHAR2 1 START_DELAYED_FLAG
FINISH_DELAYED_FLAG VARCHAR2 1 FINISH_DELAYED_FLAG
START_PAST_FLAG VARCHAR2 1 START_PAST_FLAG
FINISH_PAST_FLAG VARCHAR2 1 FINISH_PAST_FLAG
START_DATE DATE START_DATE
FINISH_DATE DATE FINISH_DATE
QUANTITY NUMBER QUANTITY
ITD_QUANTITY NUMBER ITD_QUANTITY
PERCENT_COMPLETE NUMBER PERCENT_COMPLETE
MILESTONE_FLAG VARCHAR2 1 MILESTONE_FLAG
NO_OF_EXCEPTIONS NUMBER NO_OF_EXCEPTIONS
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
PLANNED_LABOR_COST_PJT NUMBER PLANNED_LABOR_COST_PJT
ACTUAL_LABOR_COST_PJT NUMBER ACTUAL_LABOR_COST_PJT
PLANNED_EXPENSE_COST_PJT NUMBER PLANNED_EXPENSE_COST_PJT
ACTUAL_EXPENSE_COST_PJT NUMBER ACTUAL_EXPENSE_COST_PJT

Indexes

Index Uniqueness Tablespace Columns
PJS_UDB_TASK_DTLS_U1 Unique Default PROJECT_ID, PLAN_LINE_ID, PROJ_ELEMENT_ID