it_tickets
Help desk tickets raised by employees. One row is one ticket.
- One row is
- one ticket
- Columns
- 12
- Rows in Sample
- 35,859
- Rows in Standard
- 35,859
- Rows in Full
- 35,859
This table describes the company, not individual guests, so it is identical in all three sizes.
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| ticket_idkey | integer | Unique id for the row. | |
| opened_at | date and time | When it was raised. | 2018-01-01 06:00 to 2025-12-31 20:02 |
| requester_employee_id | integer | Who raised it. Links to employees. | |
| assigned_team | text | IT team that owned it. | Business Applications; Data and Reporting; Guest App and Web; Network and Infrastructure; POS and Venue Systems; Service Desk |
| assigned_employee_id | integer | Who worked it. Links to employees. | |
| system_id | integer | The system concerned, if any. Can be empty. | |
| category | text | Kind of request. | |
| priority | text | P1 most urgent to P4 least. | P1; P2; P3; P4 |
| sla_target_hours | integer | Hours the team commits to close a ticket of this priority in. | 4 to 168 |
| first_response_at | date and time | When someone first replied. Can be empty. | 2018-01-01 16:10 to 2025-12-31 23:12 |
| closed_at | date and time | When it was closed. Empty while open. Can be empty. | 2018-01-01 23:32 to 2025-12-31 23:20 |
| status | text | Resolved, open, or closed automatically after 60 days without resolution. | closed: aged out; open; resolved |
How it connects
This table points to
- requester_employee_id matches employees.employee_id
- assigned_employee_id matches employees.employee_id
- system_id matches it_systems.system_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| ticket_id | opened_at | requester_employee_id | assigned_team | assigned_employee_id | system_id | category | priority | sla_target_hours | first_response_at | closed_at | status |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 700001 | 2018-01-01 06:00:00 | 212410 | Service Desk | 214138 | 10 | software install | P4 | 168 | 2018-01-02 19:18:19 | 2018-01-04 09:07:54 | resolved |
| 700002 | 2018-01-01 13:48:46 | 210609 | Business Applications | 217002 | configuration change | P2 | 24 | 2018-01-03 08:18:14 | 2018-01-04 18:26:13 | resolved | |
| 700003 | 2018-01-01 15:37:54 | 209146 | Service Desk | 209422 | email or calendar | P2 | 24 | 2018-01-01 16:29:57 | 2018-01-02 13:03:00 | resolved | |
| 700004 | 2018-01-01 15:49:46 | 212446 | Network and Infrastructure | 200025 | network outage | P2 | 24 | 2018-01-01 18:21:42 | 2018-01-05 16:00:57 | resolved | |
| 700005 | 2018-01-01 15:59:13 | 202311 | Guest App and Web | 201461 | app bug | P1 | 4 | 2018-01-01 16:10:39 | 2018-01-01 23:32:28 | resolved |