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