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 This column is for Oracle Internal use only. 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