# DW_PROJECT_WORK_TYPE_D

This table stores Implementation-defined work types.

## Details

Module: Project Costing

## Key Columns

WORK_TYPE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
WORK_TYPE_ID | NUMBER | 38 | 0 | True | The system generated number that uniquely identifies the work type |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. System generated Unique Identifier. |  |
BILLABLE_CAPITALIZABLE_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates whether the work type is billable or capitalizable |  |
UTILIZABLE_FLAG | VARCHAR2 | 16 |  |  | Indicates if the work type is utilizable or not. |  |
START_DATE_ACTIVE | DATE |  |  |  | First effective date of the work type |  |
END_DATE_ACTIVE | DATE |  |  |  | Last effective date of the work type |  |
TP_AMT_TYPE_CODE | VARCHAR2 | 32 |  |  | Determines the classification of the cross charge amount "Cost","Revenue" |  |

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