External systems

Pamica

The external system PAMICA supports integration with attendance systems, which is implemented using an XML interface based on the following schema provided by STORMWARE:

https://www.stormware.cz/schema/pamica/dochazka.xsd

Global Settings – Attendance

The PAMICA system must be prepared for attendance import by adjusting the global settings.

To correctly import data from the attendance system, you need to set the import path:

  • open Settings – Global Settings – Attendance

  • in the field Import Path, enter the location of the attendance data files.

Import of Vacation and Sick Days

  • These absences are imported as ideal values. This means that half-days are merged into a single day.

  • The first half-day is always imported as a full day of vacation, while the second half-day of absence is not imported.

Absence Display Options

  • In the XML files, absence records are listed separately by day.

  • You can choose whether to import them individually or to group them into a single item.

Performing the Attendance Import

  • The import is carried out via File – Data Communication – Attendance Import.

Attendance Import Wizard – Step 1
On the first page of the wizard, use the Browse button to select the path to the XML file that contains the attendance data (the file generated in the SYSDO system). After clicking Next, the data import will begin. Once completed, an import log will be displayed.

This log provides information about the performed checks, calculations, and payroll recalculations into which the new attendance data has been imported.

The imported data can then be manually adjusted, or the import can be repeated if the prepared file contained inconsistencies. Please note: repeating the import of attendance for an employee will overwrite and delete the previously imported (incorrect) data for that employee.


Creating Payroll Records Before Import
Before importing attendance into the PAMICA program, you must first manually create the Payroll for each employee for the given month. If no payroll record exists, it is not possible to import attendance data from SYSDO into PAMICA.

Imported payrolls containing attendance data can then be processed in the usual way.


Employee ID (Employment Number)
Employees are matched using their Employment Number.
In SYSDO, go to Administration – Users – (Advanced Mode) – General tab and enter the employment number from the PAMICA system into the EID field.


Work Schedule
The work schedule corresponds to the work shift defined in the SYSDO system. The system uses the “to be worked” value set for the specific work plan.

The schedule contains planned working hours for the entire month.

  • For individual shift rotations, the calendar is imported.

  • In other cases, the schedule serves for verification purposes only.

 

Absences

To match absences between the SYSDO attendance system and the PAMICA payroll system, it is necessary to fill in the attendance code and, optionally, the attendance name in the definition of absence items.

attendance_codeattendance_name
DVacation
SDSick days
PVPaid leaves
NVUnpaid leaves
NSickness
OCRFamily member care
MDMaternity leave
RDParental leave
ODPaternity leave
AAbsence
LDoctor
SVBusiness leave

Presences

To match items between the SYSDO attendance system and the PAMICA payroll system, it is necessary to fill in the attendance code and, optionally, the attendance name in the definition of payroll items.

attendace_codeattendance_name
PPOvertime
PUAdditional hours

Administration – Work Shifts – Edit Work Shift – (Advanced Mode) – Report Information – Working time: full | part

Full-time

  • Overtime work = untransferred extra work + worked time during an overtime plan type

Part-time

  • Additional work beyond contracted hours = untransferred extra work up to the full-time workload value

  • Overtime work = untransferred extra work exceeding the full-time workload value + worked time during an overtime plan type

Allowances
To match items between the SYSDO attendance system and the PAMICA payroll system, you must enter the attendance code and, optionally, the attendance name in the definition of payroll items.

attendance_codeattendance_name
PSHoliday work
PVWeekend work
NONight work

Keloc

IDPeriodCodeHoursMeal ticketsSumFromTo
111120180947  26.09.201826.09.2018
11112018091105    
222220180966  13.09.201813.09.2018
22222018091101    
33332018091114    

kódy:

  • 1 – worked
  • 0 – overtime
  • 17 – doctor
  • 20 – sickness
  • 4 – vacation
  • 6 – unpaid leave
  • 21 – member family care
  • 22 – maternity leave
  • 8 – parental leave
  • 15 – holiday work

Infos

IDSurnameFirst nameMonthYearTimeHoursDays
1111PracovníkA09201820405
1111PracovníkA092018501 
2222PracovníkB0920182071
2222PracovníkB092018506.75 
3333Sekretářka 092018106 

časové složky:

  • 101 = overtime
  • 20 = vacation
  • 50 = paid leave
  • 10 = unpaid leave
  • 90 = sickness

Leave a Reply