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, 2024, Oracle and/or its affiliates.