change_requests
Changes deployed to business systems. One row is one change.
- One row is
- one change
- Columns
- 10
- Rows in Sample
- 1,726
- Rows in Standard
- 1,726
- Rows in Full
- 1,726
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 |
|---|---|---|---|
| change_idkey | integer | Unique id for the row. | |
| system_id | integer | Links to it_systems. | |
| title | text | What the change was. | |
| change_type | text | Standard is routine and pre-approved, normal goes through review, emergency skips it. | emergency; normal; standard |
| risk_level | text | Risk as assessed by the requester. | high; low; medium |
| requested_by_employee_id | integer | Who asked for it. Links to employees. | |
| requested_at | date and time | When it was requested. | 2018-01-01 09:43 to 2025-12-29 16:23 |
| deployed_at | date and time | When it went live. | 2018-01-03 22:40 to 2026-01-01 01:40 |
| tested_in_staging | true/false | True when it was tested before going live. | |
| outcome | text | Successful, or rolled back. | rolled back; successful |
How it connects
This table points to
- system_id matches it_systems.system_id
- requested_by_employee_id matches employees.employee_id
Tables that point here
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| change_id | system_id | title | change_type | risk_level | requested_by_employee_id | requested_at | deployed_at | tested_in_staging | outcome |
|---|---|---|---|---|---|---|---|---|---|
| 40001 | 6 | New report or field | standard | medium | 205945 | 2018-01-02 14:55:12 | 2018-01-03 22:40:15 | true | successful |
| 40002 | 3 | Bug fix release | standard | low | 212015 | 2018-01-03 08:57:33 | 2018-01-04 22:37:05 | true | successful |
| 40003 | 9 | Configuration update | normal | low | 202311 | 2018-01-01 11:54:47 | 2018-01-05 00:56:37 | true | successful |
| 40004 | 4 | Certificate renewal | standard | medium | 206878 | 2018-01-08 10:43:53 | 2018-01-09 22:37:45 | true | successful |
| 40005 | 1 | Capacity increase | normal | low | 200983 | 2018-01-01 11:18:41 | 2018-01-11 23:23:22 | true | successful |