# HourApprovals: Simplicate Hours Approvals Fetches the approval status of each day for each employee Can retrieve and modify data using insert, update and delete. - Catalog: `Simplicate` - Schema: `Hours` - Primary Keys: `id` - Label: Hours Approvals ## Table Columns The columns of the table `HourApprovals` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `approvalstatus_description` | `string` | Approval Status Description | ☐ | | | `approvalstatus_id` | `string` | Approval Status ID | ☐ | | | `approvalstatus_label` | `string` | Approval Status Label | ☐ | | | `date` | `string` | Date | ☐ | | | `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 | ☐ | | | `id` | `string` | ID | ☐ | |