DW_RESOURCE_CLASS_D

This table stores the details of resource classes.

Details

Module: Project Costing

Key Columns

RESOURCE_CLASS_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RESOURCE_CLASS_ID NUMBER 38 0 True Unique identifier of the resource class.
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Source record id
RESOURCE_CLASS_CODE VARCHAR2 64 Holds the code used to identify the resource class. The supported resource class codes are PEOPLE, EQUIPMENT, MATERIAL_ITEMS and FINANCIAL_ELEMENTS.
RESOURCE_CLASS_SEQ NUMBER 38 0 Indicates the order of display for each resource class.
CREATED_BY VARCHAR2 128 Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 128 Who column: indicates the user who last updated the row.