training_completions
Courses each employee finished. One row is one person finishing one course.
- One row is
- one person finishing one course
- Columns
- 5
- Rows in Sample
- 44,222
- Rows in Standard
- 44,222
- Rows in Full
- 44,222
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 |
|---|---|---|---|
| completion_idkey | integer | Unique id for the row. | |
| employee_id | integer | Links to employees. | |
| course_id | integer | Links to training_courses. | |
| completed_date | date | Day finished. | 2009-10-20 to 2025-12-31 |
| score | integer | Test score out of 100. | 72 to 100 |
How it connects
This table points to
- employee_id matches employees.employee_id
- course_id matches training_courses.course_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| completion_id | employee_id | course_id | completed_date | score |
|---|---|---|---|---|
| 1 | 203280 | 5 | 2009-10-20 | 91 |
| 2 | 200369 | 5 | 2009-10-22 | 97 |
| 3 | 202054 | 3 | 2009-10-25 | 72 |
| 4 | 211015 | 3 | 2009-10-26 | 81 |
| 5 | 213107 | 1 | 2009-10-28 | 92 |