DW_PROJECT_ELEMENT_D

This table stores the common non-versioned information related to tasks and structures

Details

Module: Project Costing

Key Columns

PROJ_ELEMENT_ID

Columns

Columns
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.