These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- IT Training Tracker
- Data model
The tables behind IT Training Tracker
IT Training Tracker ships with 12 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 12
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Learners and enrollments:
Learners connects to Enrollments, and each enrollment points to Courses.
Courses and delivery:
Courses connects to class sessions and Assessments; Attendance links a learner to a session.
Results:
Assessment results links a learner to an assessment.
Certification:
Certification requirements links to Enrollments; certification awards links a requirement and a person.
Fees and people:
Fees links to Learners; Courses links its Instructor to People, and People links to Users.
Every table, by feature
- Learners and enrollments3
- Courses and sessions3
- Attendance4
- Assessments4
- Certification records4
- Fees2
- Shared and settings1
- Learners
People enrolled in IT training courses.
- Enrollments
Learner enrollment in a course, with lifecycle status.
Linked to Learners, Courses - Courses
IT training courses with instructor, schedule, capacity and status.
Linked to People
- Courses
IT training courses with instructor, schedule, capacity and status.
Linked to People - Class sessions
Scheduled deliveries of a course in a room.
Linked to Courses - People
Staff and instructors referenced by IT training operations.
Linked to Users
- Attendance
Attendance record for one learner at one class session.
Linked to Class sessions, Learners - Class sessions
Scheduled deliveries of a course in a room.
Linked to Courses - Learners
People enrolled in IT training courses.
- Courses
IT training courses with instructor, schedule, capacity and status.
Linked to People
- Assessments
Graded assessment belonging to a course.
Linked to Courses - Assessment results
Learner score for an assessment, with grading status.
Linked to Assessments, Learners - Courses
IT training courses with instructor, schedule, capacity and status.
Linked to People - Learners
People enrolled in IT training courses.
- Certification requirements
Certification required for an enrollment's role.
Linked to Enrollments - Certification awards
Certification awarded to a person against a requirement.
Linked to People, Certification requirements - Enrollments
Learner enrollment in a course, with lifecycle status.
Linked to Learners, Courses - People
Staff and instructors referenced by IT training operations.
Linked to Users
- Fees
Training fee charged to a learner, with paid amount and status.
Linked to Learners - Learners
People enrolled in IT training courses.
Keys and references
Keep the references intact during import. The learner’s name is readable, but the reference on an enrollment, attendance record or result is the dependable link. A course can have multiple sessions and assessments. A certificate requirement belongs to an enrollment, while an award belongs to a person and a requirement. Do not merge those identities during migration.
Migration order
- Bring in Users and People used for instructors and access.
- Load Learners and Courses with their existing dates and states.
- Load Enrollments, class sessions and Assessments with their references.
- Load Attendance, assessment results, Fees and certification requirements.
- Load certification awards after both People and requirements are present.
Set up IT Training Tracker your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.