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.
- Education ERP
- Data model and import order
The tables behind Education ERP
Education ERP ships with 22 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
- 22
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Admissions and enrollment
Applications, Enrollments, Programs, academic periods. Review applications and carry accepted students into the right campus, program and term.
Student records and attendance
Attendance, Students, Enrollments. Keep student identity, enrollment history and session attendance connected.
Fees and collections
Fee plans, Charges, Receipts, receipt allocations. Connect approved fee plans, concessions, due dates, receipts and outstanding balances.
Faculty and timetables
Class sessions, faculty assignments, Rooms, academic periods. Plan teaching assignments and publish sessions without room or faculty conflicts.
Campus purchasing
Purchase requests, Campuses, Organizations. Route departmental requests through the right campus and budget owner.
Institution finance
Journal entries, journal lines, Accounts, Organizations. Reconcile student accounts and campus expenditure to reviewed financial postings.
Every table, by feature
- Admissions and enrollment4
- Student records and attendance3
- Fees and collections4
- Faculty and timetables4
- Campus purchasing3
- Institution finance4
- Shared and settings3
- Applications
Applicant evidence and the recorded admission decision.
Linked to Users, Programs, Academic periods - Enrollments
Student placement in a program and academic period.
Linked to Users, Students, Applications, Programs - Programs
Academic programs with capacity and award context.
Linked to Users, Campuses - Academic periods
Terms and admission windows used for enrollment and fees.
Linked to Users, Campuses
- Attendance
Dated student attendance for one class session.
Linked to Users, Enrollments, Class sessions - Students
Stable student identity separate from each enrollment.
Linked to Users - Enrollments
Student placement in a program and academic period.
Linked to Users, Students, Applications, Programs
- Fee plans
Approved charge schedule and policy version for an enrollment.
Linked to Users, Enrollments - Charges
Student fee obligations and due dates.
Linked to Users, Fee plans, Students - Receipts
Confirmed collection evidence against a student account.
Linked to Users, Students - Receipt allocations
Allocation of one receipt across student charges.
Linked to Users, Receipts, Charges
- Class sessions
Scheduled teaching sessions linked to faculty and room.
Linked to Users, Faculty assignments, Rooms, Academic periods - Faculty assignments
Faculty allocation to programs for an academic period.
Linked to Users, Programs, Academic periods, Student groups - Rooms
Teaching spaces with capacity and campus ownership.
Linked to Users, Campuses - Academic periods
Terms and admission windows used for enrollment and fees.
Linked to Users, Campuses
- Purchase requests
Campus expenditure request against a budget owner.
Linked to Users, Campuses - Campuses
Operating campus and legal-entity mapping.
Linked to Users, Organizations - Organizations
Legal entities with separate books and permissions.
Linked to Users
- Journal entries
Balanced, reviewed entries with a traceable source.
Linked to Users, Organizations - Journal lines
Debits and credits attached to one journal.
Linked to Users, Journal entries, Accounts, Organizations - Accounts
Chart of accounts for the entity ledger.
Linked to Users, Organizations - Organizations
Legal entities with separate books and permissions.
Linked to Users
Keys and references
Keep student identity separate from application and enrollment. Link fees to the enrollment and attendance to the scheduled session. Retain the payment-provider reference when importing receipts, and do not allocate more than the confirmed receipt or open charge.
Every organization keeps stable source identifiers. Import references by those identifiers, never by a display name that can change. Keep monetary values with their currency and unit quantities with their units. Preserve original evidence and dated correction history.
Migration order
- Load Organizations, Users and the approved Accounts structure.
- Load Campuses, Programs, academic periods, Rooms and Students.
- Load Applications and Enrollments, then faculty assignments and class sessions.
- Load fee plans, Charges, confirmed Receipts and receipt allocations; reconcile opening journals separately.
- Reconcile source totals, test permissions and replay exception cases before opening the next operating period.
Set up Education ERP your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.