---
title: "ProjectEmployeeAssignments (Simplicate)"
description: "Project Employee Assignments"
language: es
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/es/datamodels/simplicate/Simplicate.Projects.ProjectEmployeeAssignments
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Projects.ProjectEmployeeAssignments
updated: 2026-11-18T23:54:08Z
license: https://documentation.invantive.eu/es/
---

# ProjectEmployeeAssignments: Asignaciones de empleados de proyecto de Simplicate

`read only` `REST`

- Catálogo: `Simplicate`
- Esquema: `Projects`
- Etiqueta: Asignaciones de empleados de proyecto

Obtiene todas las asignaciones disponibles para proyectos

Solo puede recuperar datos.

## Fuente de la API

- Punto final: `/projects/assignment`
- Operación: `get /projects/assignment`

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `ProjectEmployeeAssignments`. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `amount` | `double` | Amount | [ ] |  |  |
| `created_at` | `varchar2` | Creado en | [ ] |  |  |
| `declarable` | `varchar2` | Declarable | [ ] |  |  |
| `description` | `varchar2` | Description | [ ] |  |  |
| `employee_id` | `varchar2` | Identificación del Empleado | [ ] |  |  |
| `end_date` | `varchar2` | Fecha Final | [ ] |  |  |
| `hours` | `double` | Hours | [ ] |  |  |
| `hours_total` | `double` | Total de horas | [ ] |  |  |
| `hours_type` | `varchar2` | Tipo de horario | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `id_2` | `varchar2` | itgen_spe_id_2 | [ ] |  |  |
| `is_planned` | `char` | Está planificado | [ ] |  |  |
| `name` | `varchar2` | Name | [ ] |  |  |
| `name_2` | `varchar2` | itgen_spe_name_2 | [ ] |  |  |
| `person_id` | `varchar2` | Identificación de la Persona | [ ] |  | Añadido para cumplir con la respuesta original de ventas/ventas responsible_employee |
| `project_has_register_mileage_enabled` | `char` | itgen_spe_project_has_register_mileage_enabled | [ ] |  |  |
| `project_id` | `varchar2` | Identificación del Proyecto | [ ] |  |  |
| `project_name` | `varchar2` | Nombre del Proyecto | [ ] |  |  |
| `project_organization_id` | `varchar2` | ID de organización del proyecto | [ ] |  |  |
| `project_organization_name` | `varchar2` | Nombre de la organización del proyecto | [ ] |  |  |
| `project_organization_relation_number` | `varchar2` | itgen_spe_project_organization_relation_number | [ ] |  |  |
| `project_person_full_name` | `varchar2` | Nombre completo de la persona del proyecto | [ ] |  |  |
| `project_person_id` | `varchar2` | ID de persona del proyecto | [ ] |  |  |
| `project_person_relation_number` | `varchar2` | itgen_spe_project_person_relation_number | [ ] |  |  |
| `project_project_manager_amount` | `double` | Monto del gerente de proyecto | [ ] |  |  |
| `project_project_manager_declarable` | `varchar2` | Gestor de proyectos declarable | [ ] |  |  |
| `project_project_manager_employee_id` | `varchar2` | ID de empleado del gerente de proyecto | [ ] |  |  |
| `project_project_manager_id` | `varchar2` | ID de gerente de proyecto | [ ] |  |  |
| `project_project_manager_name` | `varchar2` | Nombre del Administrador del Proyecto | [ ] |  |  |
| `project_project_manager_person_id` | `varchar2` | ID de persona del gerente del proyecto | [ ] |  | Añadido para cumplir con la respuesta original de ventas/ventas responsible_employee |
| `project_project_manager_tariff` | `double` | Tarifa de gerente de proyecto | [ ] |  |  |
| `project_project_number` | `varchar2` | Número de proyecto | [ ] |  |  |
| `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` | ID de servicio del proyecto | [ ] |  |  |
| `projectservice_name` | `varchar2` | Nombre del servicio del proyecto | [ ] |  |  |
| `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` | Monto gastado | [ ] |  |  |
| `spread` | `varchar2` | itgen_spe_spread | [ ] |  |  |
| `start_date` | `varchar2` | Fecha Inicial | [ ] |  |  |
| `status_color` | `varchar2` | Color de estado | [ ] |  |  |
| `status_created_at` | `varchar2` | Estado creado en | [ ] |  |  |
| `status_id` | `varchar2` | ID de estado | [ ] |  |  |
| `status_is_blocked` | `char` | El estado está bloqueado | [ ] |  |  |
| `status_is_done` | `char` | El estado está terminado | [ ] |  |  |
| `status_name` | `varchar2` | Nombre de estado | [ ] |  |  |
| `status_order` | `int64` | Orden de estado | [ ] |  |  |
| `status_updated_at` | `varchar2` | Estado actualizado en | [ ] |  |  |
| `tariff` | `double` | Tariff | [ ] |  |  |
| `updated_at` | `varchar2` | Actualizado en | [ ] |  |  |
| `use_spread` | `char` | Usar propagación | [ ] |  |  |


## Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:

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