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 SSPSSPQualifyingDay
- Qualifying day for SSPSSPNonQualifyingDay
- SSP Non Qualifying DaySSPGeneral
- SSP DaySSPWithheld
- SSP Day - WithheldHolidayTaken
- Holiday takenHolidayBooked
- Holiday bookedAuthorised
- Authorised absenceUnauthorised
- Unauthorised absenceMedical
- MedicalEducational
- Study leave etcCompassionate
- Compassionate leaveMaternity
- Maternity leavePaternity
- Paternity leaveJury
- Jury ServiceSuspension
- SuspensionPunctuality
- LatenessCustom1
- Custom 1Custom2
- Custom 2Custom3
- Custom 3Custom4
- Custom 4Custom5
- Custom 5Custom6
- Custom 6Custom7
- Custom 7Custom8
- Custom 8Custom9
- 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 absenceMorning
- A mornings absenceAfternoon
- 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>