DW_PROJECT_NON_LABOR_RES_D

This table stores the translated information for each Non Labor Resource.

Details

Module: Project Costing

Key Columns

NON_LABOR_RESOURCE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
NON_LABOR_RESOURCE_ID NUMBER 38 0 True Unique identifier of the non-labor resource
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. System Generated unique identifier
EXPENDITURE_TYPE_ID NUMBER 38 0 Unique identifier for Expenditure Types.
EQUIPMENT_RESOURCE_FLAG VARCHAR2 16 This flag identifies the non labor resources as equipment resource class or not
START_DATE_ACTIVE DATE First effective date of the non-labor resource
END_DATE_ACTIVE DATE Last effective date of the non-labor resource