---
title: "ProjectAssignments (Simplicate)"
description: "Project Assignments"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Projects.ProjectAssignments
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Projects.ProjectAssignments
updated: 2024-10-18T06:48:11Z
license: https://documentation.invantive.eu/en/
---

# ProjectAssignments: Simplicate Project Assignments

`insert` `update` `REST`

- Catalog: `Simplicate`
- Schema: `Projects`
- Primary Keys: `id`
- Label: Project Assignments

Fetches all available assignments for projects

Can retrieve data and change data using `insert` and `update`.

## API Source

- Endpoint: `/projects/assignment`
- Operation: `get /projects/assignment`

## Table Columns

The columns of the table `ProjectAssignments` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `created_at` | `varchar2` | Created at | [ ] |  |  |
| `description` | `varchar2` | Description | [ ] |  |  |
| `end_date` | `varchar2` | End Date | [ ] |  |  |
| `hours` | `double` | Hours | [ ] |  |  |
| `hours_total` | `double` | Hours Total | [ ] |  |  |
| `hours_type` | `varchar2` | Hours Type | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `is_planned` | `char` | Is Planned | [ ] |  |  |
| `name` | `varchar2` | Name | [ ] |  |  |
| `project_has_register_mileage_enabled` | `char` | itgen_spe_project_has_register_mileage_enabled | [ ] |  |  |
| `project_id` | `varchar2` | Project ID | [ ] |  |  |
| `project_name` | `varchar2` | Project Name | [ ] |  |  |
| `project_organization_id` | `varchar2` | Project Organisation ID | [ ] |  |  |
| `project_organization_name` | `varchar2` | Project Organisation Name | [ ] |  |  |
| `project_organization_relation_number` | `varchar2` | itgen_spe_project_organization_relation_number | [ ] |  |  |
| `project_person_full_name` | `varchar2` | Project Person Full Name | [ ] |  |  |
| `project_person_id` | `varchar2` | Project Person ID | [ ] |  |  |
| `project_person_relation_number` | `varchar2` | itgen_spe_project_person_relation_number | [ ] |  |  |
| `project_project_manager_amount` | `double` | Project Manager Amount | [ ] |  |  |
| `project_project_manager_declarable` | `varchar2` | Project Manager Declarable | [ ] |  |  |
| `project_project_manager_employee_id` | `varchar2` | Project Manager Employee ID | [ ] |  |  |
| `project_project_manager_id` | `varchar2` | Project Manager ID | [ ] |  |  |
| `project_project_manager_name` | `varchar2` | Project Manager Name | [ ] |  |  |
| `project_project_manager_person_id` | `varchar2` | Project Manager Person ID | [ ] |  | Added in order to comply with the original sales/sales responsible_employee response |
| `project_project_manager_tariff` | `double` | Project Manager Tariff | [ ] |  |  |
| `project_project_number` | `varchar2` | Project Number | [ ] |  |  |
| `projecthourstype_billable` | `char` | itgen_spe_projecthourstype_billable | [ ] |  |  |
| `projecthourstype_budgeted_amount` | `double` | itgen_spe_projecthourstype_budgeted_amount | [ ] |  |  |
| `projecthourstype_color` | `varchar2` | itgen_spe_projecthourstype_color | [ ] |  |  |
| `projecthourstype_hourstype_billable` | `double` | itgen_spe_projecthourstype_hourstype_billable | [ ] |  |  |
| `projecthourstype_hourstype_blocked` | `char` | itgen_spe_projecthourstype_hourstype_blocked | [ ] |  |  |
| `projecthourstype_hourstype_color` | `varchar2` | itgen_spe_projecthourstype_hourstype_color | [ ] |  |  |
| `projecthourstype_hourstype_id` | `varchar2` | itgen_spe_projecthourstype_hourstype_id | [ ] |  |  |
| `projecthourstype_hourstype_label` | `varchar2` | itgen_spe_projecthourstype_hourstype_label | [ ] |  |  |
| `projecthourstype_hourstype_tariff` | `double` | itgen_spe_projecthourstype_hourstype_tariff | [ ] |  |  |
| `projecthourstype_hourstype_type` | `varchar2` | itgen_spe_projecthourstype_hourstype_type | [ ] |  |  |
| `projecthourstype_hourstype_vatclass_code` | `varchar2` | itgen_spe_projecthourstype_hourstype_vatclass_code | [ ] |  |  |
| `projecthourstype_hourstype_vatclass_id` | `varchar2` | itgen_spe_projecthourstype_hourstype_vatclass_id | [ ] |  |  |
| `projecthourstype_hourstype_vatclass_label` | `varchar2` | itgen_spe_projecthourstype_hourstype_vatclass_label | [ ] |  |  |
| `projecthourstype_hourstype_vatclass_name` | `varchar2` | itgen_spe_projecthourstype_hourstype_vatclass_name | [ ] |  |  |
| `projecthourstype_hourstype_vatclass_percentage` | `double` | itgen_spe_projecthourstype_hourstype_vatclass_percentage | [ ] |  |  |
| `projecthourstype_id` | `varchar2` | itgen_spe_projecthourstype_id | [ ] |  |  |
| `projecthourstype_tariff` | `double` | itgen_spe_projecthourstype_tariff | [ ] |  |  |
| `projectservice_default_service_id` | `varchar2` | itgen_spe_projectservice_default_service_id | [ ] |  |  |
| `projectservice_id` | `varchar2` | Project Service ID | [ ] |  |  |
| `projectservice_name` | `varchar2` | Project Service Name | [ ] |  |  |
| `projectservice_revenue_group_id` | `varchar2` | itgen_spe_projectservice_revenue_group_id | [ ] |  |  |
| `projectservice_use_in_resource_planner` | `char` | itgen_spe_projectservice_use_in_resource_planner | [ ] |  |  |
| `spent_amount` | `varchar2` | Spent Amount | [ ] |  |  |
| `spread` | `varchar2` | itgen_spe_spread | [ ] |  |  |
| `start_date` | `varchar2` | Start Date | [ ] |  |  |
| `status_color` | `varchar2` | Status Colour | [ ] |  |  |
| `status_created_at` | `varchar2` | Status Created at | [ ] |  |  |
| `status_id` | `varchar2` | Status ID | [ ] |  |  |
| `status_is_blocked` | `char` | Status is Blocked | [ ] |  |  |
| `status_is_done` | `char` | Status is Done | [ ] |  |  |
| `status_name` | `varchar2` | Status Name | [ ] |  |  |
| `status_order` | `int64` | Status Order | [ ] |  |  |
| `status_updated_at` | `varchar2` | Status Updated at | [ ] |  |  |
| `updated_at` | `varchar2` | Updated at | [ ] |  |  |
| `use_spread` | `char` | Use Spread | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Simplicate](/en/release-notes/drivers?driver=simplicate)

