Skip to main content

Error: The INSERT statement conflicted with the CHECK constraint "Future Absence must have an End Date"

Error: Future Absence must have an End Date

H
Written by Harry Ledger
Updated over a month ago

This error appears when you attempt to enter an absence record with a future start date but no end date, and the absence type is not a Sickness absence type. To resolve this, you need to enter an end date for the absence record.

In SelectHR, open-ended absences are only allowed for sickness absence types. This is because, in most cases, it's not possible to predict how long an employee will be off work due to illness. Unlike planned absences, such as annual leave or parental leave, sickness absences often don't have a clear return date.

To ensure accurate absence records, SelectHR performs a validation check when you enter an absence record:

  • If the absence has a future start date, and

  • It is missing an end date,

Then the system checks whether the absence type is classified as Sickness.

If the absence isn't Sickness, and it has a future start date but no end date, SelectHR blocks the entry and displays the error message.

This validation ensures you can only record Sickness without an end date. For all other absence types, you need to enter an end date when scheduling future absences.

Did this answer your question?