api_project_assignments

Description

The api_project_assignments table exposes project assignment entities, which represent the planned allocation of hours and budget on project services.

Assignments can optionally be linked to a specific employee. When employee_id is NULL, the assignment represents unallocated or pooled hours on a project service.

Data period and exclusions

This table only contains assignments that meet all of the following criteria:

• The assignment has both a start date and an end date set.
• The assignment's end date is within the last 6 months (from the first day of the current month).

Assignments without dates or that ended more than 6 months ago are excluded. There is no filtering on project status (e.g. active/archived) or assignment status (e.g. done/blocked).

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. NULL when no specific employee is assigned
assignment	String	Name or description of the assignment

Related Tables

• api_projects - Project details via project_id
• api_project_services - Service details via project_service_id
• api_employees - Employee details via employee_id
• api_item_types - Item type details via item_type_id
• api_project_assignments_facts - Daily facts via project_assignment_id