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     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.