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