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 |
The End Date of the Classroom Accommodation record will be the earlier of the following:
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.
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.
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.
The following illustrates a single accommodation record and the end date being calculated from the latest school enrolment created for the student.
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.
This data element is used in the following validation rules:
Unless otherwise specified, this data element should adhere to the guidelines below.
When this data element is presented, it should be formatted as Date.
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. |
This field is a calculated field and therefore, never editable by a user.
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. |