# DW_PROJECT_D

This table stores the non-translatable fields in a project.

## Details

Module: Project Costing

## Key Columns

PROJECT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PROJECT_ID | NUMBER | 38 | 0 | True | The system-generated number that uniquely identifies a project |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. System generated Unique Identifier. |  |
PROJECT_NUMBER | VARCHAR2 | 32 |  |  | Project Number |  |
PROJECT_TYPE_ID | NUMBER | 38 | 0 |  | The project type that classifies the project and defaults project information upon project entry. |  |
CARRYING_OUT_ORGANIZATION_ID | NUMBER | 38 | 0 |  | The identifier of the organization that is responsible for the project work |  |
PUBLIC_SECTOR_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates whether the project is in the public sector or the private sector |  |
PROJECT_STATUS_CODE | VARCHAR2 | 32 |  |  | The status of the project. |  |
START_DATE | DATE |  |  |  | The date on which the project starts |  |
COMPLETION_DATE | DATE |  |  |  | The date on which the project is completed |  |
CLOSED_DATE | DATE |  |  |  | The date that the project was closed by changing the project status to Closed |  |
ORG_ID | NUMBER | 38 | 0 |  | Indicates the identifier of the business unit associated to the row. |  |
PROJECT_UNIT_ID | NUMBER | 38 | 0 |  | Project unit assigned to the project. |  |
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity assigned to the project. |  |
PROJECT_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Currency code of the project |  |
WORK_TYPE_ID | NUMBER | 38 | 0 |  | Work_Types are predefined types of work, for example, Vacation, Training, and Administration. |  |
SERVICE_TYPE_CODE | VARCHAR2 | 32 |  |  | A classification of the service or activity associated with a project. |  |
PROJFUNC_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Project functional currency. The default value is the value entered for the associated ledger. |  |
PRIORITY_CODE | VARCHAR2 | 32 |  |  | Indicates priority of the project. |  |
PROJECT_CATEGORY | VARCHAR2 | 32 |  |  | Category to indicate FINANCIAL, EXECUTION, TODO, FIN_EXEC projects |  |
ENABLE_BILLING_FLAG | VARCHAR2 | 16 |  |  | Indicates the billable status of the project type |  |
ENABLE_CAPITALIZATION_FLAG | VARCHAR2 | 16 |  |  | Indicates the capitalization status of the project type |  |
CAPITAL_COST_TYPE_CODE | VARCHAR2 | 16 |  |  | Name of the cost type for projects of this project type. |  |
CLIN_LINKED_CODE | VARCHAR2 | 16 |  |  | Indicates whether the project is linked and if the linkage is at the Project or Task level. |  |

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