Skip to content

Sage 50 Payroll Employee Absences XML

The Importing Employee Absences Into Sage 50 Payroll task allows you to insert or update Absence entries associated with Employees in Sage 50 Payroll.

For an Employee Absence to be imported, the Employee must already exist in Sage 50 Payroll.

Employee Matching

The Employee is matched based on the provided EmployeeReference in the XML.

<?xml version="1.0"?>
<Company
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <EmployeeAbsences>
  <EmployeeAbsence>
      <EmployeeReference>1</EmployeeReference>
    </EmployeeAbsence>
  </EmployeeAbsences>
</Company>

EmployeeReference

Required
Employee Reference
The numeric identifier of the Employee that you would like to associate Payments with.

Absence Matching

Existing Absence entries are matched based on the provided Date in the XML.

<?xml version="1.0"?>
<Company>
  <EmployeeAbsences>
    <EmployeeAbsence>
      <Date>2017-05-24T00:00:00</Date>
    </EmployeeAbsence>
  </EmployeeAbsences>
</Company>

Date

Optional
Date Range
The date of the Employee Absence.

Employee Absence Fields

The following Employee Absence fields can be set using Zynk.

<?xml version="1.0"?>
<Company>
  <EmployeeAbsences>
    <EmployeeAbsence>
      <AbsenceType>HolidayBooked</AbsenceType>
      <DayType>FullDay</DayType>
      <Comment>Annual leave</Comment>
    </EmployeeAbsence>
  </EmployeeAbsences>
</Company>

AbsenceType

Optional
Absence Type
The type of the Employee Absence. The following values are valid for the AbsenceType, the description as specified in the Sage 50 Payroll documentation appears in italic.

  • SSPWaiting - Waiting day for SSP
  • SSPQualifyingDay - Qualifying day for SSP
  • SSPNonQualifyingDay - SSP Non Qualifying Day
  • SSPGeneral - SSP Day
  • SSPWithheld - SSP Day - Withheld
  • HolidayTaken - Holiday taken
  • HolidayBooked - Holiday booked
  • Authorised - Authorised absence
  • Unauthorised - Unauthorised absence
  • Medical - Medical
  • Educational - Study leave etc
  • Compassionate - Compassionate leave
  • Maternity - Maternity leave
  • Paternity - Paternity leave
  • Jury - Jury Service
  • Suspension - Suspension
  • Punctuality - Lateness
  • Custom1 - Custom 1
  • Custom2 - Custom 2
  • Custom3 - Custom 3
  • Custom4 - Custom 4
  • Custom5 - Custom 5
  • Custom6 - Custom 6
  • Custom7 - Custom 7
  • Custom8 - Custom 8
  • Custom9 - Custom 9

DayType

Optional
Whether this is a half day absence or full day. The following values are valid for the DayType, the description as specified in the Sage 50 Payroll documentation appears in italic.

  • FullDay - A full days absence
  • Morning - A mornings absence
  • Afternoon - An afternoons absence

Comment

Optional
Comment
The comment associated with the Absence entry.

Samples

Sample import file for importing a new Employee Absence
If there is already an Absence associated with the Employee on the specified Date then the import of the record will fail 

<?xml version="1.0"?>
<Company>
  <EmployeeAbsences>
    <EmployeeAbsence RecordOperation="Insert">
      <EmployeeReference>1</EmployeeReference>
      <Date>2018-02-09T00:00:00</Date>
      <AbsenceType>HolidayBooked</AbsenceType>
      <DayType>FullDay</DayType>
      <Comment>Annual leave</Comment>
    </EmployeeAbsence>
  </EmployeeAbsences>
</Company>

Sample import file for updating an existing Employee Absence
If there isn't an Absence associated with the employee for the specified Date then the import of the record will fail

<?xml version="1.0"?>
<Company>
  <EmployeeAbsences>
    <EmployeeAbsence RecordOperation="Update">
      <EmployeeReference>1</EmployeeReference>
      <Date>2018-02-09T00:00:00</Date>
      <AbsenceType>HolidayBooked</AbsenceType>
      <DayType>FullDay</DayType>
      <Comment>Annual leave</Comment>
    </EmployeeAbsence>
  </EmployeeAbsences>
</Company>

Sample import file for updating an existing Employee Absence for the specified Date otherwise inserting a new Employee Absence on that Date.

<?xml version="1.0"?>
<Company>
  <EmployeeAbsences>
    <EmployeeAbsence RecordOperation="Upsert">
      <EmployeeReference>1</EmployeeReference>
      <Date>2018-02-09T00:00:00</Date>
      <AbsenceType>HolidayBooked</AbsenceType>
      <DayType>FullDay</DayType>
      <Comment>Annual leave</Comment>
    </EmployeeAbsence>
  </EmployeeAbsences>
</Company>