DW_PROJECT_PARTY_D

This table provides all the project people whether active or inactive.

Details

Module: Project Costing

Key Columns

PROJECT_PARTY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PROJECT_PARTY_ID NUMBER 38 0 True System generated number that uniquely identifies the project party    
SOURCE_RECORD_ID VARCHAR2 64     System generated Unique Identifier.    
PROJECT_ID NUMBER 38 0   The identifier of the project to which the objects belong    
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.    
PROJECT_PARTY_TYPE VARCHAR2 16     Party Type