api_project_assignments
⚠️ Important: Some fields in this table will be deprecated on Wednesday, January 7th, 2025. Please review the Deprecated Fields section below and migrate to the recommended alternatives.
This table provides project assignment data from Simplicate.
Description
The api_project_assignments table exposes project assignment entities, which represent the assignment of employees to
specific project services and item types.
Fields
| Field Name | Type | Description |
|---|---|---|
project_assignment_id | Integer | Unique identifier for the project assignment |
project_id | Integer | Identifier of the project |
project_service_id | Integer | Identifier of the project service |
project_item_type_id | Integer | Identifier of the project item type |
item_type_id | Integer | Identifier of the item type (hour type) |
employee_id | Integer | Identifier of the assigned employee |
assignment | String | Name or description of the assignment |
Deprecated Fields
⚠️ Deprecation Notice: The following fields will be deprecated on Wednesday, January 7th, 2025. Please migrate to the recommended alternatives.
| Deprecated Field | Type | Recommended Alternative |
|---|---|---|
key_project_assignment_id | Integer | project_assignment_id |
key_project_id | Integer | project_id |
key_project_service_id | Integer | project_service_id |
key_project_item_type_id | Integer | project_item_type_id |
key_item_type_id | Integer | item_type_id |
key_employee_id | Integer | employee_id |
assignment_name | String | assignment |
Related Tables
api_projects- Project details viaproject_idapi_project_services- Service details viaproject_service_idapi_employees- Employee details viaemployee_idapi_item_types- Item type details viaitem_type_idapi_project_assignments_facts- Daily facts viaproject_assignment_id