DW_PROJECT_CLASS_ASSIGNMENT_D

This table stores project classifications.

Details

Module: Project Costing

Key Columns

PROJECT_CLASSES_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PROJECT_CLASSES_ID NUMBER 38 0 True Unique identifier for Project Classifications.    
SOURCE_RECORD_ID VARCHAR2 64     System generated Unique Identifier.    
PROJECT_ID NUMBER 38 0   The identifier of the project that is classified by the project class    
CLASS_CATEGORY_ID NUMBER 38 0   Unique identifier for Class Categories.    
CLASS_CODE_ID NUMBER 38 0   Unique identifier for Class Codes.    
CODE_PERCENTAGE NUMBER       The percentage associated with this classification    

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