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:
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_code | attendance_name |
D | Vacation |
SD | Sick days |
PV | Paid leaves |
NV | Unpaid leaves |
N | Sickness |
OCR | Family member care |
MD | Maternity leave |
RD | Parental leave |
A | Absence |
L | Doctor |
SV | Business 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_code | attendance_name |
PP | Overtime |
PU | Additional 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_code | attendance_name |
PS | Holiday work |
PV | Weekend work |
NO | Night work |
Keloc
ID | Period | Code | Hours | Meal tickets | Sum | From | To |
1111 | 201809 | 4 | 7 | 26.09.2018 | 26.09.2018 | ||
1111 | 201809 | 1 | 105 | ||||
2222 | 201809 | 6 | 6 | 13.09.2018 | 13.09.2018 | ||
2222 | 201809 | 1 | 101 | ||||
3333 | 201809 | 1 | 114 |
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
ID | Surname | First name | Month | Year | Time | Hours | Days |
1111 | Pracovník | A | 09 | 2018 | 20 | 40 | 5 |
1111 | Pracovník | A | 09 | 2018 | 50 | 1 | |
2222 | Pracovník | B | 09 | 2018 | 20 | 7 | 1 |
2222 | Pracovník | B | 09 | 2018 | 50 | 6.75 | |
3333 | Sekretářka | 09 | 2018 | 10 | 6 |
časové složky:
- 101 = overtime
- 20 = vacation
- 50 = paid leave
- 10 = unpaid leave
- 90 = sickness