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