# sla_report_analysis SLA Status Analysis - Catalog: `Odoo` - Schema: `helpdesk` The data in this table is partitioned per value of the column. This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API. ## Table Columns The columns of the table `sla_report_analysis` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `close_date` | `datetime` | Close date | ☐ | | | `company_id_label` | `string` | | ☐ | | | `company_id` | `string` | | ☐ | | | `create_date` | `datetime` | Ticket Create Date | ☐ | | | `display_name` | `string` | Display Name | ☐ | | | `failed_sla_rate` | `decimal` | % of Failed SLA | ☐ | | | `id` | `int32` | ID | ☐ | | | `ongoing_sla_rate` | `decimal` | % of SLA In Progress | ☐ | | | `partner_id_label` | `string` | | ☐ | | | `partner_id` | `string` | | ☐ | | | `priority` | `string` | Minimum Priority | ☐ | | | `sale_order_id_label` | `string` | | ☐ | | | `sale_order_id` | `string` | | ☐ | | | `sla_deadline` | `datetime` | SLA Deadline | ☐ | | | `sla_exceeded_hours` | `int32` | Working Hours to Reach SLA | ☐ | Day to reach the stage of the SLA, without taking the working calendar into account | | `sla_id_label` | `string` | | ☐ | | | `sla_id` | `string` | | ☐ | | | `sla_reached_datetime` | `datetime` | SLA Reached Date | ☐ | | | `sla_stage_id_label` | `string` | | ☐ | | | `sla_stage_id` | `string` | | ☐ | | | `sla_status_fail` | `boolean` | SLA Status Failed | ☐ | | | `sla_status_failed` | `int32` | Number of SLA Failed | ☐ | | | `sla_status_ongoing` | `int32` | Number SLA In Progress | ☐ | | | `sla_status_successful` | `int32` | Number of SLA Successful | ☐ | | | `sla_status` | `string` | Status | ☐ | | | `successful_sla_rate` | `decimal` | % of Successful SLA | ☐ | | | `team_id_label` | `string` | | ☐ | | | `team_id` | `string` | | ☐ | | | `ticket_assignation_hours` | `int32` | Working Hours to Assign | ☐ | | | `ticket_close_hours` | `int32` | Working Hours to Close | ☐ | | | `ticket_closed` | `boolean` | Ticket Closed | ☐ | | | `ticket_deadline` | `datetime` | Ticket Deadline | ☐ | | | `ticket_id_label` | `string` | | ☐ | | | `ticket_id` | `string` | | ☐ | | | `ticket_stage_id_label` | `string` | | ☐ | | | `ticket_stage_id` | `string` | | ☐ | | | `ticket_type_id_label` | `string` | | ☐ | | | `ticket_type_id` | `string` | | ☐ | | | `user_id_label` | `string` | | ☐ | | | `user_id` | `string` | | ☐ | |