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 This column is for Oracle Internal use only. 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