# DW_PROJECT_ROLE_TYPE_D

This table stores information about various roles, both seeded and user defined.

## Details

Module: Project Costing

## Key Columns

PROJECT_ROLE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PROJECT_ROLE_ID | NUMBER | 38 | 0 | True | The system generated number to uniquely identify the role |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. System Generated unique identifier |  |
START_DATE_ACTIVE | DATE |  |  |  | First effective date of project role typecreated. |  |
END_DATE_ACTIVE | DATE |  |  |  | Last effective date for the project role type |  |
JOB_ROLE_ID | NUMBER | 38 | 0 |  | JOB_ROLE_ID |  |
ROLE_ID | NUMBER | 38 | 0 |  | ROLE_ID |  |
IS_SEEDED | VARCHAR2 | 16 |  |  | This column denotes whether the role is seeded |  |

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