End Date (Classroom Accommodation)

The date the accommodation was last considered available for the student. This is a calculated field and is Read-Only.

Business Object Classroom Accommodation
Optionality Mandatory
Data Format Date

Calculation Logic

The End Date of the Classroom Accommodation record will be the earlier of the following:

  • The latest Registration Exit Date of contiguous school enrolments meeting the following criteria:
    • No more than a 6 month gap exists between school enrolments
    • Only school enrolments on or after the start date of the student accommodation are considered
    • Only enrolments for that student and school are considered
    • Deleted Student School Enrolments will be excluded.

If there are no school enrolments to use for calculation of the end date - set the end date equal to the start date of the accommodation.

Technical Notes

The student has to be enrolled at the school on the start date of the accommodation. The enrolment can start before the accommodation starts but it must not end before the accommodation starts. If the student happens to have an overlapping enrolment at the school on the start date of the accommodation then the enrolment with the LATEST exit date is chosen. The enrolment that is chosen that describes the student being enrolled at the school on the start date of the accommodation is referred to as the “anchor” enrolment.

Following the anchor enrolment, it is possible for the student to leave the school and then come back to that school within six months of leaving (the duration is calculated as six months not 180 days.) These enrolments as known as continuous enrolments. A continuous enrolment must have a start date that is greater than the start date of the previous (or anchor) enrolment AND have an end date that is greater than the end date of the previous (or anchor) enrolment. As with the selection of the anchor enrolment, if there are overlapping enrolments at the school then the enrolment with the LATEST exit date is chosen. There can be ANY number of continuous enrolments in a chain (and they can potentially overlap) as long as the gap between them is not more than six months. Note: there are existing warning rules on school enrolments to flag overlapping enrolments within a school or authority.

Contiguous School Enrolments

The following illustrates a single accommodation record and the end date being extended with each new school enrolment created for the student.
Note: Gaps in school enrolments less than 6 months allows the end date to be extended with each new school enrolment.

Contiguous School Enrolments - Retroactive Classroom Accommodation

The following illustrates a single accommodation record and the end date being calculated from the latest school enrolment created for the student.

Non-Contiguous School Enrolments

The following illustrates the calculation of the end date where the student has school enrolment gap with a school of 6 months or more.
The student moves from “blue” school to “orange” school and then back to “blue” school. Since there is a gap of more than 6 months, the calculated end date cannot be extended as in the illustration above.
A second accommodation record is required for the 2018/2019 school enrolment.

Validation Rules

User Interface Guidelines

Unless otherwise specified, this data element should adhere to the guidelines below.

Data Format Guidelines

When this data element is presented, it should be formatted as Date.

Read Only Field

When this data element is displayed it should adhere to the following guidelines:

Field Name End Date
Null Values blank
Hint Text None
Security Requirements This field is always available.

Editable Field

This field is a calculated field and therefore, never editable by a user.

Data Grid Column

When this data element is displayed in a PASIprep Data Grid it should adhere to the following guidelines:

Column Heading End Date
Column Width Auto
Filtering Style Date
Contains The formatted End Date as outlined above.
Null Values Blank
Column Security Requirements This column is always available.
Data Security Requirements The data in this column is always available.