# 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 |  |  | This column is for Oracle Internal use only. 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 | 999 |  |  | 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. |  |
SERVICE_TYPE_CODE | VARCHAR2 | 32 |  |  | The type of work performed on the task |  |
CHARGEABLE_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates if expenditure items can be charged to the task. Only lowest level tasks can be chargeable |  |
BILLABLE_FLAG | VARCHAR2 | 16 |  |  | Default flag for items charged to the task that indicates if the item can accrue revenue (Y or N). For capital projects this flag is used as capitalizable_flag. For indirect projects this flag is set to N and is not used. ***** |  |
WORK_TYPE_ID | NUMBER | 38 | 0 |  | Work Types are predefined types of work, for example, Vacation, Training, and Administration. |  |
CAPITALIZABLE_FLAG | VARCHAR2 | 16 |  |  | CAPITALIZABLE_FLAG |  |
DENORM_DISPLAY_SEQUENCE | NUMBER | 38 | 0 |  | Denormalized column from PJF_PROJ_ELEMENT_VERSION ***** |  |
DENORM_WBS_LEVEL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure ***** |  |
DENORM_WBS_NUMBER | VARCHAR2 | 256 |  |  | Denormalized column from PJF_PROJ_ELEMENT_VERSION ***** |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.