DW_PROJECT_MNGR_CRRNT_D

This table provides the latest Project manager for a project.

Details

Module: Project Costing

Key Columns

PROJECT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PROJECT_ID NUMBER 38 0 True The identifier of the project to which the objects belong
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. System generated Unique Identifier.
RESOURCE_SOURCE_ID NUMBER 38 0 The identifier of the resource assigned to the project
PROJECT_ROLE_ID NUMBER 38 0 The identifier of the role that is assigned to the RESOURCE_SOURCE_ID
START_DATE_ACTIVE DATE The first effective date for the project party
END_DATE_ACTIVE DATE The last effective date for the project party
RESOURCE_NAME VARCHAR2 999 Name of the Resource.