# Absences Fetches all absence for employees Can retrieve and modify data using insert, update and delete. - Catalog: `Simplicate` - Schema: `HRM` - Primary Keys: `id` ## Table Columns The columns of the table `Absences` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `absencetype_blocked` | `boolean` | | ☐ | | | `absencetype_color` | `string` | | ☐ | | | `absencetype_id` | `string` | | ☐ | | | `absencetype_label` | `string` | | ☐ | | | `created_at` | `string` | Created On | ☐ | | | `description` | `string` | Description | ☐ | | | `employee_amount` | `float` | Employee Amount | ☐ | | | `employee_declarable` | `string` | Billable Employee | ☐ | | | `employee_employee_id` | `string` | Employee ID | ☐ | | | `employee_id` | `string` | Employee ID | ☐ | | | `employee_name` | `string` | Employee Name | ☐ | | | `employee_person_id` | `string` | Employee Person ID | ☐ | Added in order to comply with the original sales/sales responsible_employee response | | `employee_tariff` | `float` | Employee Rate | ☐ | | | `end_date` | `string` | End Date | ☐ | | | `hours` | `float` | Hours | ☐ | | | `id` | `string` | ID | ☐ | | | `start_date` | `string` | Start Date | ☐ | | | `updated_at` | `string` | Updated On | ☐ | | | `year` | `int64` | Year | ☐ | |