Skip to main content

Error when entering absence: The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_History_Schedule Periods".

Error when entering absence: The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_History_Schedule Periods".

H
Written by Harry Ledger
Updated over 3 weeks ago

This error is indicative of the employee's working pattern not being set up correctly. There are a few stages to checking the working schedules have periods in them.

Find the working pattern name

To find the working pattern for an employee, follow these steps.

  1. In the Employee zone, click Career History.

  2. Next to the employee's name, click the black arrow.

  3. On the All Appointments tab, click the current appointment.

  4. On the Career History tab, in the Additional Details section, and in the Working Pattern field, make a note of the Working Pattern name.


Check that there are periods assigned to the schedules

  1. In the Employee zone, click Lookups, then click the Pattern folder.

  2. Click Working Patterns., then select the relevant pattern.

  3. Click the Days tab. A list containing the working schedule name for each of the working days will be displayed. Make a note of these.
    ​Note: Please ensure that the week number starts with 1, and goes up sequentially. If the first week record in the days tab starts with a number higher than 1, this can prevent the system from calculating the working pattern correctly and will cause this error.

  4. In the Employee zone, click Lookups then click the Pattern folder.

  5. Click Working Schedules then locate and select the working schedule applied to the working days.

  6. Click the Periods tab.

  7. If there are no periods, click New, then enter the period details.

  8. Click Save.

πŸ€“ Tip: Ensure that the days column adds up to 1 as this is what is used by the system to calculate the absence days. Also, the period's day values must total 1.


Absences before appointment start date

You may also experience this error if you are trying to enter an absence before the appointment start date, but after their continuous service date. This is because the employee does not have a valid working pattern for the dates you are trying to enter.

Did this answer your question?