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.
- Sports & Extra-curricular
- Data model and import order
The tables behind Sports & Extra-curricular
Sports & Extra-curricular 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
- Change it
- Add fields and tables in Proto
How the model is organised
Activities and coaches:
Courses, activity groups, People, Users. Courses are Planned, Open, Active, Completed or Cancelled.
Enrollments and learners:
Enrollments, Learners. Enrollments are Requested, Approved, Active, Completed or Withdrawn.
Sessions and attendance:
Class sessions, Attendance. Sessions are Scheduled, Delivered or Cancelled; attendance is Present, Absent or Excused.
Assessments:
Assessments, assessment results. Results are Submitted, Graded or Reviewed.
Achievements:
Activity achievements, with Achievement, awarded at and Evidence.
Activity fees:
Fees. Draft, Issued, part paid, Paid or Voided.
Every table, by feature
- Activities and coaches4
- Enrollments and learners3
- Sessions and attendance4
- Assessments4
- Achievements3
- Activity fees3
- Courses
Scheduled activity courses with instructor, capacity and term dates.
Linked to People - Activity groups
Coached activity groups for an academic term.
Linked to People - People
Staff, coaches and instructors who act in the program.
Linked to Users - Users
Users
Linked to Users
- Enrollments
Learner-to-course enrollment records and their lifecycle state.
Linked to Learners, Courses - Learners
Students enrolled in athletics and enrichment activities.
- Courses
Scheduled activity courses with instructor, capacity and term dates.
Linked to People
- Class sessions
Individual scheduled meetings for a course.
Linked to Courses - Attendance
Per-session attendance for each learner.
Linked to Learners, Class sessions - Courses
Scheduled activity courses with instructor, capacity and term dates.
Linked to People - Learners
Students enrolled in athletics and enrichment activities.
- Assessments
Graded assessments defined for a course.
Linked to Courses - Assessment results
Learner scores against an assessment.
Linked to Assessments, Learners - Courses
Scheduled activity courses with instructor, capacity and term dates.
Linked to People - Learners
Students enrolled in athletics and enrichment activities.
- Activity achievements
Awards and achievements earned by a learner in an activity group.
Linked to Learners, Activity groups - Activity groups
Coached activity groups for an academic term.
Linked to People - Learners
Students enrolled in athletics and enrichment activities.
- Fees
Activity fees charged to a learner with payment status.
Linked to Learners - Learners
Students enrolled in athletics and enrichment activities.
- Enrollments
Learner-to-course enrollment records and their lifecycle state.
Linked to Learners, Courses
Keys and references
A course references its instructor; an activity group references its coach, both from People. 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. Achievements reference a learner and an activity group. Fees reference a learner.
Import courses by course code and learners by learner number, matching your student information system.
Migration order
- Load Users and People for coaches and staff.
- Load Courses and activity groups for the term.
- Load Learners and their Enrollments.
- Load class sessions and Assessments.
- Load open Fees and past activity achievements if needed.
- Reconcile enrollments and outstanding fees with the source, test permissions and replay the exception cases before the term starts.
Set up Sports & Extra-curricular your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.