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.
- Timetable Generator
- Data model and import order
The tables behind Timetable Generator
Timetable Generator 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
Timetable slots:
Timetable slots. Status Proposed, Approved or Published, linking Course, Instructor and Room with starts at and ends at.
Rooms and capabilities:
Room capabilities. Room name, Capacity, Equipment and unavailable intervals.
Courses and sessions:
Courses, class sessions, People. Courses are Planned, Open, Active, Completed or Cancelled; sessions are Scheduled, Delivered or Cancelled.
Enrollments and learners:
Enrollments, Learners. Enrollments are Requested, Approved, Active, Completed or Withdrawn.
Attendance and assessments:
Attendance, Assessments, assessment results. Attendance is Present, Absent or Excused; results are Submitted, Graded or Reviewed.
Learner fees:
Fees. Status Draft, Issued, part paid, Paid or Voided.
Every table, by feature
- Timetable slots4
- Rooms and capabilities2
- Courses and sessions3
- Enrollments and learners3
- Attendance and assessments5
- Learner fees3
- Shared and settings1
- Timetable slots
Proposed, approved and published timetable slots.
Linked to Courses, People, Room capabilities - Courses
Course catalog with instructor, capacity and delivery window.
Linked to People - People
Staff and instructors referenced by courses and timetable slots.
Linked to Users - Room capabilities
Room capability evidence captured against an enrollment.
Linked to Enrollments
- Room capabilities
Room capability evidence captured against an enrollment.
Linked to Enrollments - Timetable slots
Proposed, approved and published timetable slots.
Linked to Courses, People, Room capabilities
- Courses
Course catalog with instructor, capacity and delivery window.
Linked to People - Class sessions
Scheduled class sessions for a course.
Linked to Courses - People
Staff and instructors referenced by courses and timetable slots.
Linked to Users
- Enrollments
Learner to course enrollment lifecycle.
Linked to Learners, Courses - Learners
Learners enrolled in courses.
- Courses
Course catalog with instructor, capacity and delivery window.
Linked to People
- Attendance
Attendance captured per session and learner.
Linked to Learners, Class sessions - Assessments
Assessments defined for a course.
Linked to Courses - Assessment results
Learner scores against assessments.
Linked to Assessments, Learners - Class sessions
Scheduled class sessions for a course.
Linked to Courses - Learners
Learners enrolled in courses.
- Fees
Learner fees with amount, paid amount and status.
Linked to Learners - Learners
Learners enrolled in courses.
- Enrollments
Learner to course enrollment lifecycle.
Linked to Learners, Courses
Keys and references
A slot references a course, an instructor from People and a room capability record. A course references its instructor. Sessions and assessments reference a course. Enrollments reference a learner and a course. Attendance references a session and a learner; results reference an assessment and a learner. Fees reference a learner. People reference a user account. Each room capability record also references the enrollment it was captured against.
Import courses by course code and learners by learner number. Keep slot start and end times in the site’s time zone.
Migration order
- Load Users and People for instructors and staff.
- Load room capabilities with capacity, equipment and unavailable intervals.
- Load Courses with capacity, dates and instructor.
- Load Learners and their Enrollments.
- Load timetable slots for the term, then class sessions, Assessments and open Fees.
- Reconcile the published timetable, enrollments and outstanding fees with the source, test permissions and replay the exception cases before the term starts.
Set up Timetable Generator your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.