Transactional Data
Transactional data is the data that changes overtime, for example:
- Student data - The student's data gets created whenever there is a new enrollment.
- Program Enrollment data - The students' Program Enrollment data gets created whenever the students enroll into Programs, and also whenever there are updates to the Program Enrollment data (e.g. end dates, graduation dates).
Below are some of the main transactional data required to at least allow students to view their own details, and perform enrollment related actions.
| RIO Education Data Set | Details | Description |
| Student (Contact) | Student personal details (biodata). | Personal details, e.g. first name, last name, preferred name, citizenship, birthdate, etc. |
| Student address details. | Student address details, e.g. street, city state, postal code, etc. | |
| Student contact details. | Student contact details used for communications, e.g. email, phone, mobile, etc. | |
| Student additional contact details. | Student's emergency/ guardian/ relative contact details. | |
| Program Enrollment | The Program Enrollment of the student. | Details of the student's Program Enrollments, e.g. Program, start date, end date, etc. |
| Course Enrollment | The Course Enrollment of the student - Courses under the Program that the student is enrolled to. | Details of the student's Course enrollments, e.g. Course, term, enrollment start date, end date, etc. |
| Result/Grade | The Course Enrollment results. | The result/grade details of the Courses that the student has completed. |
| Transfer Credit | The transfer credit details of the students. | The details of the external courses transferred over from external institutions to your institution, used to contribute to the completion progress. |
| Student Fee/Payment | The historical fees charged to the students and the corresponding payments. |
The details of fees charged to the students based on enrollments and the corresponding payments, e.g. description of fees, amount of fees, payment amount, payment date, etc. *The fees may be required for government reporting. |
| Financial Aid | The financial aid details per students. Mainly required for ongoing students under the current academic year. | The details of the financial aids awarded to the respective students e.g. Start Date, End Date, Total Amount, Max Amount per Term, etc. |
| Faculty (Contact) | Faculty personal and contact details. |
Personal details, e.g. first name, last name, preferred name, citizenship, birthdate, addresses etc. |
For a use case example on transactional data migration, see here.