This table stores the common non-versioned information related to tasks and structures
Module: Project Costing
PROJ_ELEMENT_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
PROJ_ELEMENT_ID | NUMBER | 38 | 0 | True | The unique identifier for the project element | ||
SOURCE_RECORD_ID | VARCHAR2 | 128 | System Generated unique identifier | ||||
ELEMENT_NUMBER | VARCHAR2 | 128 | User-defined number that uniquely identifies the element within a project or structure | ||||
PROJECT_ID | NUMBER | 38 | 0 | The identifier of the project to which the element belongs | |||
CARRYING_OUT_ORGANIZATION_ID | NUMBER | 38 | 0 | The identifier of the organization that is responsible for the work. | |||
ELEMENT_TYPE | VARCHAR2 | 32 | Identifies the element type. FINANCIAL, EXECUTION or FIN_EXEC | ||||
START_DATE | DATE | The date on which the task starts; | |||||
COMPLETION_DATE | DATE | The date on which the task is completed | |||||
MANAGER_PERSON_ID | NUMBER | 38 | 0 | The identifier of the person who manages the task. This is a task-specific attribute. | |||
MANAGER_NAME | VARCHAR2 | 2048 | This is the name of task manager. | ||||
CLIN_ELEMENT_ID | NUMBER | 38 | 0 | The identifier of the parent task, which is directly linked to the contract line. |