# ProjectAssignments: Simplicate Project Assignments Fetches all available assignments for projects - Catalog: `Simplicate` - Schema: `Projects` - Primary Keys: `id` - Label: Project Assignments - Retrieve: true - Insert: true - Update: true - Delete: false ## Table Columns The columns of the table `ProjectAssignments` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `created_at` | `string` | Created On | ☐ | | | `description` | `string` | Description | ☐ | | | `end_date` | `string` | End Date | ☐ | | | `hours_total` | `float` | Hours Total | ☐ | | | `hours_type` | `string` | Hours Type | ☐ | | | `hours` | `float` | Hours | ☐ | | | `id` | `string` | ID | ☐ | | | `is_planned` | `boolean` | Is Planned | ☐ | | | `name` | `string` | Name | ☐ | | | `project_has_register_mileage_enabled` | `boolean` | | ☐ | | | `project_id` | `string` | Project ID | ☐ | | | `project_name` | `string` | Project Name | ☐ | | | `project_organization_id` | `string` | Project Organisation ID | ☐ | | | `project_organization_name` | `string` | Project Organisation Name | ☐ | | | `project_organization_relation_number` | `string` | | ☐ | | | `project_person_full_name` | `string` | Project Person Full Name | ☐ | | | `project_person_id` | `string` | Project Person ID | ☐ | | | `project_person_relation_number` | `string` | | ☐ | | | `project_project_manager_amount` | `float` | Project Manager Amount | ☐ | | | `project_project_manager_declarable` | `string` | Project Manager Billable | ☐ | | | `project_project_manager_employee_id` | `string` | Project Manager Employee ID | ☐ | | | `project_project_manager_id` | `string` | Project Manager ID | ☐ | | | `project_project_manager_name` | `string` | Project Manager Name | ☐ | | | `project_project_manager_person_id` | `string` | Project Manager Person ID | ☐ | Added in order to comply with the original sales/sales responsible_employee response | | `project_project_manager_tariff` | `float` | Project Manager Rate | ☐ | | | `project_project_number` | `string` | Project Number | ☐ | | | `projecthourstype_billable` | `boolean` | | ☐ | | | `projecthourstype_budgeted_amount` | `float` | | ☐ | | | `projecthourstype_color` | `string` | | ☐ | | | `projecthourstype_hourstype_billable` | `float` | | ☐ | | | `projecthourstype_hourstype_blocked` | `boolean` | | ☐ | | | `projecthourstype_hourstype_color` | `string` | | ☐ | | | `projecthourstype_hourstype_id` | `string` | | ☐ | | | `projecthourstype_hourstype_label` | `string` | | ☐ | | | `projecthourstype_hourstype_tariff` | `float` | | ☐ | | | `projecthourstype_hourstype_type` | `string` | | ☐ | | | `projecthourstype_hourstype_vatclass_code` | `string` | | ☐ | | | `projecthourstype_hourstype_vatclass_id` | `string` | | ☐ | | | `projecthourstype_hourstype_vatclass_label` | `string` | | ☐ | | | `projecthourstype_hourstype_vatclass_name` | `string` | | ☐ | | | `projecthourstype_hourstype_vatclass_percentage` | `float` | | ☐ | | | `projecthourstype_id` | `string` | | ☐ | | | `projecthourstype_tariff` | `float` | | ☐ | | | `projectservice_default_service_id` | `string` | | ☐ | | | `projectservice_id` | `string` | Project Service ID | ☐ | | | `projectservice_name` | `string` | Project Service Name | ☐ | | | `projectservice_revenue_group_id` | `string` | | ☐ | | | `projectservice_use_in_resource_planner` | `boolean` | | ☐ | | | `spent_amount` | `string` | Spent Amount | ☐ | | | `spread` | `string` | | ☐ | | | `start_date` | `string` | Start Date | ☐ | | | `status_color` | `string` | Status Colour | ☐ | | | `status_created_at` | `string` | Status Created On | ☐ | | | `status_id` | `string` | Status ID | ☐ | | | `status_is_blocked` | `boolean` | Status Is Blocked | ☐ | | | `status_is_done` | `boolean` | Status Is Completed | ☐ | | | `status_name` | `string` | Status Name | ☐ | | | `status_order` | `int64` | Order Status | ☐ | | | `status_updated_at` | `string` | Status Updated On | ☐ | | | `updated_at` | `string` | Updated On | ☐ | | | `use_spread` | `boolean` | Use Spread | ☐ | |