Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Below is a slightly stylized version ERD of a typical student. Note that it does not include other capabilities that are delivered on top of the standard PosiEd in K-12  applications such as well-being academic assessments, etc. At this point, we are just reviewing the core requirements.

The students and their family

The 1st and most obvious record is to create Contact Record for the student themselves, so change contact to person account. Here you will populate the student's primary contact details. Note that you do not yet have to specify anything related to items such as their grade level. House, etc. This will come later.

The second step is to create Person Account records for their family and career contacts. These can be associated with the student contact via contact, contact relationships.  Review how relationships are to be optimally configured. How the cascading of contact details will work and how data import of these relationships can occur?

Billing Account

A Billing Account record should then be established. This is an account of type billing account and this is the level at which all billing for one or more students to a single bill, payer is made. It is also the point at which Contract associations, etc., are made.

Once the billing account record has been created on the student account record link to the bill.

Academic Term Enrollments

An Academic Term enrollment associates a student with a particular Academic Term. While some information about a student's enrollment history with an educational institution is held by the student record. It is not granular enough Academic term level analysis. Academic term enrollments are typically also used to drive enrollment billing functions.

Each year, the student should have a new Academic Term Enrollment record created for them and these records will also consequently be associated with Course Offering Participant Records, which in turn are associated with cohort members.

Other Accounts Record Types

PosiEd and EDC require a number of account record types to be configured, including Grade Levels, House, Tutor role group and so on. [There are others such as Department Educational Institution, etc., but these are not relevant for this discussion.]

A common question as is to why some of these entries are set up as accounts as opposed to simple pick lists for example. The reason is that account associations provide a more flexible and long-term recording of various associations. It allows you to, for example, see that a student moves from  roll group to another which is something that you can't see with just a pick list.

These associations also provide better reporting such as Generating the program term application timeline in brackets [PTAT].  Note check on this.

These count records need to be set up to establishing student records  Academic Term Enrollments.