South Africa South Africa
Reseller Sign-In/Apply

Reseller Zone

Welcome

Get access to your Distributor Dashboard today and explore our Knowledge Base, Downloads, Assets and Support Tickets.

Login to your account

Importing Adjustments from SAP

Leave adjustments can be exported from SAP systems to file, for import into Jarrison Time. However the format of the file needs to match Jarrison Time’s import requirements.

The file layout created by SAP will be a daily transaction listing that follows this format:
Column 1 – EmpNum
Column 2 – Date
Column 3 – LeaveType
Column 4 – LeaveType.Desc
Column 5 – Hours
Column 6 – Indicator
Column 7 – ChgDate

Details of the column fields:

Empnum:
Same as JT Employee number
Date:
Date format on file: yyyymmdd (e.g. 20241215)
LeaveType:
This is the leave code in the SAP system
LeaveType.Desc:
This is the adjustment description found in JT (e.g., Annual Leave, Sick Leave) that the leave type will be linked with
Hours:
Total number of daily hours to reflect in JT
JT will always import “Custom time” and then link the hours accordingly
JT will not ignore non-working days (Thus, if it’s in the import file JT will add it)
Indicator:
This field will indicate if JT should add, remove, or modify the transaction
Indicator – 1 is only for add/insert any leave types
Indicator – 2 is only for remove/delete leave types
Indicator – 3 is only for changes/modifications on leave types and leave hours changes.
Change date:
This is the date on which the transaction was added or modified in SAP (JT does not refer to or use this column at all)

In Jarrison Time, the import will be done from Import > Adjustments, and then select SAP as the File Format. Then Browse to the file location, and click Import.

Related Articles

Still a bit stuck?

Send us a support message below.

Glossary of Terms

.Net Framework

(known as “dot net”) .Net is a software development framework for building and running applications on Windows.

.Net Framework

(known as “dot net”) .Net is a software development framework for building and running applications on Windows.

Access Control

Access control refers to the restriction of people’s ability to clock on biometric devices based on location and/or time. Advanced access control includes anti-passback and zone sequencing.

Access Control

Access control refers to the restriction of people’s ability to clock on biometric devices based on location and/or time. Advanced access control includes anti-passback and zone sequencing.

Access Groups

Access Groups in Jarrison Time are combinations of Devices and Time Zones, used to determine on which devices and at which times members of the Access Groups may clock. Access Groups also facilitate restrictions based on too much or too little clocking in specified time-frames.

Access Groups can by synchronized or imported by Third-Party Import, or by users.

Access Groups

Access Groups in Jarrison Time are combinations of Devices and Time Zones, used to determine on which devices and at which times members of the Access Groups may clock. Access Groups also facilitate restrictions based on too much or too little clocking in specified time-frames.

Access Groups can by synchronized or imported by Third-Party Import, or by users.

Access Zone

In Jarrison Time an Access Zone is how devices are grouped together to form logical zones for the purposes of access control. The option is available with the JT Live module.

Access Zone

In Jarrison Time an Access Zone is how devices are grouped together to form logical zones for the purposes of access control. The option is available with the JT Live module.

Adjustments (Manual Adjustments)

Adjustments are the method of covering absence of time by employees in Jarrison Time. Examples of adjustments would be Annual leave and Sick leave. Adjustments are typically applied by a user via Daily Details as needed, or can be imported from file. It’s very important that Adjustments are correctly configured and applied as paid or unpaid. (Unpaid will result in Short Time.)

Adjustments (Manual Adjustments)

Adjustments are the method of covering absence of time by employees in Jarrison Time. Examples of adjustments would be Annual leave and Sick leave. Adjustments are typically applied by a user via Daily Details as needed, or can be imported from file. It’s very important that Adjustments are correctly configured and applied as paid or unpaid. (Unpaid will result in Short Time.)

Anti Passback

Anti Passback is a form of access control where people are restricted from clocking on the device most recently clocked on, until they have clocked at another device.

Anti Passback

Anti Passback is a form of access control where people are restricted from clocking on the device most recently clocked on, until they have clocked at another device.

Approval Bypass

Approval Bypass is a feature of Jarrison Time Approvals that allows for the first approval tier to be approved without any exceptions being cleared.

Approval Bypass

Approval Bypass is a feature of Jarrison Time Approvals that allows for the first approval tier to be approved without any exceptions being cleared.

Approvals

Approvals are a system-wide setting that forces users to correct Exceptions and then lock periods from further editing, ready for submission to payroll.

Jarrison Time allows for up to three tiers of Approvals: Daily Summary (timesheet), Pay totals, Department totals. Starting at timesheet level, each tier needs to be approved before the next one can process.

Approvals

Approvals are a system-wide setting that forces users to correct Exceptions and then lock periods from further editing, ready for submission to payroll.

Jarrison Time allows for up to three tiers of Approvals: Daily Summary (timesheet), Pay totals, Department totals. Starting at timesheet level, each tier needs to be approved before the next one can process.

Area

An Area in Jarrison Time refers to a GPS location with a set radius, which designates a permitted T&A clocking area for JT Clock users.

Area

An Area in Jarrison Time refers to a GPS location with a set radius, which designates a permitted T&A clocking area for JT Clock users.

Area Schedule

The Area Schedule is used in conjunction with JT Clock to determine where JT Clock users should clock on a given day.

Area Schedule

The Area Schedule is used in conjunction with JT Clock to determine where JT Clock users should clock on a given day.

Authentication

Authentication in the context of access control or T&A is the means by which a person identifies themselves to biometric devices for clocking purposes.

Authentication

Authentication in the context of access control or T&A is the means by which a person identifies themselves to biometric devices for clocking purposes.

Authorizations

In Jarrison Time it is possible to allow employees to earn unapproved overtime when working additional hours. The unapproved time must then be authorized (to change to payable OT) or declined by a user. Authorization categories are setup so the system knows where to send approved or declined time.

Authorizations

In Jarrison Time it is possible to allow employees to earn unapproved overtime when working additional hours. The unapproved time must then be authorized (to change to payable OT) or declined by a user. Authorization categories are setup so the system knows where to send approved or declined time.

Award interpretation

In Australia, award interpretation refers to the process of applying the rules and conditions set out in modern awards to calculate employee pay, entitlements, and working conditions, such as overtime, penalty rates, and allowances.

Award interpretation

In Australia, award interpretation refers to the process of applying the rules and conditions set out in modern awards to calculate employee pay, entitlements, and working conditions, such as overtime, penalty rates, and allowances.

Biometric Device (Reader)

A biometric device is a type of device (also known as a reader), usually wall-mounted but can be handheld, used to authenticate a person’s identity by recognizing some part of their body. Jarrison Time is directly compatible with a wide range of biometric devices covering the following means of authentication: Fingerprint, Face, Palm. Tags and PINs can also be accepted if the device supports it.

Biometric Device (Reader)

A biometric device is a type of device (also known as a reader), usually wall-mounted but can be handheld, used to authenticate a person’s identity by recognizing some part of their body. Jarrison Time is directly compatible with a wide range of biometric devices covering the following means of authentication: Fingerprint, Face, Palm. Tags and PINs can also be accepted if the device supports it.

Bouncing (Shift Sensing)

Bouncing is a system-based method of assigning Day Programs to employees based on their clocking times. The selection of Day Programs the system can apply and when to apply them needs to be configured.

Bouncing (Shift Sensing)

Bouncing is a system-based method of assigning Day Programs to employees based on their clocking times. The selection of Day Programs the system can apply and when to apply them needs to be configured.

Breaks

Breaks in Jarrison Time are used to allow time off duty during the day. Breaks must be correctly configured and applied as paid or unpaid. (Unpaid breaks affect Target Time.)

Breaks

Breaks in Jarrison Time are used to allow time off duty during the day. Breaks must be correctly configured and applied as paid or unpaid. (Unpaid breaks affect Target Time.)

Clocking

Clocking can refer to the action of authenticating on a biometric device, or the result of that authentication which is a transaction containing basic personnel data, and time and date of the authentication.

Clocking

Clocking can refer to the action of authenticating on a biometric device, or the result of that authentication which is a transaction containing basic personnel data, and time and date of the authentication.

Clocking Groups

Jarrison Time uses Clocking Groups to group devices together to determine where group member Time & Attendance clockings come from. Clockings from devices outside the group are then considered as Access clockings.

Clocking Groups can be assigned by users or by Third-Party Import.

Clocking Groups

Jarrison Time uses Clocking Groups to group devices together to determine where group member Time & Attendance clockings come from. Clockings from devices outside the group are then considered as Access clockings.

Clocking Groups can be assigned by users or by Third-Party Import.

Counters

A counter in Jarrison Time is a type of field used to track incidences of certain events e.g. Absence, Shift Count etc.

Counters typically derive their values in Day Programs or Pay Groups and are then used for reporting or other calculations.

Counters

A counter in Jarrison Time is a type of field used to track incidences of certain events e.g. Absence, Shift Count etc.

Counters typically derive their values in Day Programs or Pay Groups and are then used for reporting or other calculations.

Day Programs

Day Programs are the way Jarrison Time stores all rules regarding daily shift details, such as shift start and end times, when to issue NT or OT, break times, should late arrivals, early departures, short time be tracked, etc.

Day Programs are linked via Shift Pattern, or applied by user using Day Schedule or Alternate Day Program options (can also be imported).

Day Programs

Day Programs are the way Jarrison Time stores all rules regarding daily shift details, such as shift start and end times, when to issue NT or OT, break times, should late arrivals, early departures, short time be tracked, etc.

Day Programs are linked via Shift Pattern, or applied by user using Day Schedule or Alternate Day Program options (can also be imported).

Day Schedule

The Day Schedule is a user-based method of assigning Day Programs to employees, usually when they follow a working pattern that changes often and Bouncing is not suitable.

Day Schedule

The Day Schedule is a user-based method of assigning Day Programs to employees, usually when they follow a working pattern that changes often and Bouncing is not suitable.

Engine

The Engine is a service type of application that should be set to automatically start and always be running in the background. Its purpose is to communicate with any hardware or external databases per configuration, as well as perform automated tasks for Jarrison Time e.g. backups or email reports. It only can run on one machine and is considered a user to the system (i.e. to have the engine on a server and Jarrison Time installed for a user would require two user licences).

Engine

The Engine is a service type of application that should be set to automatically start and always be running in the background. Its purpose is to communicate with any hardware or external databases per configuration, as well as perform automated tasks for Jarrison Time e.g. backups or email reports. It only can run on one machine and is considered a user to the system (i.e. to have the engine on a server and Jarrison Time installed for a user would require two user licences).

eSkan Device

eSkan devices are mobile devices used for validating the driver’s licence cards, typically used outside office parks or residential complexes. eSkan devices can be integrated with the Visitors module in Jarrison Time.

eSkan Device

eSkan devices are mobile devices used for validating the driver’s licence cards, typically used outside office parks or residential complexes. eSkan devices can be integrated with the Visitors module in Jarrison Time.

Exceptions

Exceptions in Jarrison Time refer to any T&A events which are not normal or expected, and indicate something amiss which needs attention. Examples of Exceptions include Missing clockings and Absence.

Exceptions

Exceptions in Jarrison Time refer to any T&A events which are not normal or expected, and indicate something amiss which needs attention. Examples of Exceptions include Missing clockings and Absence.

File Creator

The File Creator is a built-in tool used to create files for exporting data from Jarrison Time to payroll, or other software. The File Creator can create a flat ACSII file, comma-separated file, an Excel-format document, or send the layout to Jarrison Time’s own SQL database in the Export_File table where another system can read it, or it can send directly to the API of compatible payroll systems. The content layouts of the export typically need to be known before configuring a layout as each organization as their own requirements. There is no limit to the number of exports that can be created.

File Creator

The File Creator is a built-in tool used to create files for exporting data from Jarrison Time to payroll, or other software. The File Creator can create a flat ACSII file, comma-separated file, an Excel-format document, or send the layout to Jarrison Time’s own SQL database in the Export_File table where another system can read it, or it can send directly to the API of compatible payroll systems. The content layouts of the export typically need to be known before configuring a layout as each organization as their own requirements. There is no limit to the number of exports that can be created.

Firmware

Firmware is a low-level set of instructions typically provided by the hardware manufacturer, which determine the functionality of the hardware it is loaded on. Firmware can be upgraded, and for many device types JT requires a particular version of firmware (or higher), before integration can occur.

Firmware

Firmware is a low-level set of instructions typically provided by the hardware manufacturer, which determine the functionality of the hardware it is loaded on. Firmware can be upgraded, and for many device types JT requires a particular version of firmware (or higher), before integration can occur.

I/O Register

The In/Out Register is a screen that displays who is on or off site, providing a listing can be filtered according to various attributes. The list is generated according to the devices that have been marked for tracking this.

I/O Register

The In/Out Register is a screen that displays who is on or off site, providing a listing can be filtered according to various attributes. The list is generated according to the devices that have been marked for tracking this.

Interface

An interface is a piece of software used by Jarrison Time to handle communication between the time and attendance software and specific hardware i.e. biometric devices that are part of the clocking system. Interfaces should be installed on any machines that interact with hardware directly. E.g. if you are installing Suprema biometric devices the server will require the Suprema interface.

Interface

An interface is a piece of software used by Jarrison Time to handle communication between the time and attendance software and specific hardware i.e. biometric devices that are part of the clocking system. Interfaces should be installed on any machines that interact with hardware directly. E.g. if you are installing Suprema biometric devices the server will require the Suprema interface.

Job Costing (Module)

Job Costing is a licensed Jarrison Time module that enables the tracking of Time Categories and/or Counters for specific Jobs and Actions. E.g. employee clocks for two hours at the warehouse and then two hours at the factory, earning four hours NT and two hours Warehousing time and two hours of Factory time. Employees can be linked with Grades, which are linked with Rates, enabling costing to be calculated.

Job Costing (Module)

Job Costing is a licensed Jarrison Time module that enables the tracking of Time Categories and/or Counters for specific Jobs and Actions. E.g. employee clocks for two hours at the warehouse and then two hours at the factory, earning four hours NT and two hours Warehousing time and two hours of Factory time. Employees can be linked with Grades, which are linked with Rates, enabling costing to be calculated.

JT Clock

JT Clock is a licensed feature that allows Jarrison Time to connect via the Internet and collect clockings from JT Clock Myself or JT Clock Team app users. Clockings can be imported optionally with GPS location and photo.

JT Clock

JT Clock is a licensed feature that allows Jarrison Time to connect via the Internet and collect clockings from JT Clock Myself or JT Clock Team app users. Clockings can be imported optionally with GPS location and photo.

JT Clock Myself

JT Clock Myself is an Android-based app used for personal clocking (a person clocks themself on their own phone). It sends the clockings back to Jarrison Time via the Internet.

JT Clock Myself

JT Clock Myself is an Android-based app used for personal clocking (a person clocks themself on their own phone). It sends the clockings back to Jarrison Time via the Internet.

JT Clock Team

JT Clock Team is an Android-based app that can be used to clock many people on the same device. It sends the clockings back to Jarrison Time via the Internet.

JT Clock Team

JT Clock Team is an Android-based app that can be used to clock many people on the same device. It sends the clockings back to Jarrison Time via the Internet.

JT Enroll

JT Enroll is a free standalone Jarrison Systems product that can be used to capture employee fingerprints from remote sites, to send back to Jarrison Time users for importing.

JT Enroll

JT Enroll is a free standalone Jarrison Systems product that can be used to capture employee fingerprints from remote sites, to send back to Jarrison Time users for importing.

JT File Arranger

JT File Arranger is a standalone Jarrison Systems product that can be used to transfer clocking files from the export location of an external system to the import location of Jarrison Time. No licence is required for use.

JT File Arranger

JT File Arranger is a standalone Jarrison Systems product that can be used to transfer clocking files from the export location of an external system to the import location of Jarrison Time. No licence is required for use.

JT Lite

JT Lite is a licensed version of Jarrison Time used only for access control purposes.

JT Lite

JT Lite is a licensed version of Jarrison Time used only for access control purposes.

JT Live

JT Live is a licensed module of Jarrison Time that permits instant visibility of clockings in the software (as opposed to waiting for clocking imports) and enables greater access control functionality, namely anti-passback and zone sequencing. JT Live runs as a service on the same machine that hosts the engine. Only Sagem Morpho and Sigma devices are compatible with JT Live.

JT Live

JT Live is a licensed module of Jarrison Time that permits instant visibility of clockings in the software (as opposed to waiting for clocking imports) and enables greater access control functionality, namely anti-passback and zone sequencing. JT Live runs as a service on the same machine that hosts the engine. Only Sagem Morpho and Sigma devices are compatible with JT Live.

JT Manager

JT Manager is a software management application intended to help installers with the process of implementing JT, transferring servers, installing new users etc.

JT Manager

JT Manager is a software management application intended to help installers with the process of implementing JT, transferring servers, installing new users etc.

JT Monitor

JT Monitor is a companion service to the Device Engine and JT Live. JT Monitor can be set to check the status of the engine and some other critical system aspects, and notify recipients of potential issues. It can also be used to automatically restart the JT Live or engine service if it has stopped for some reason. No additional licensing is required for JT Monitor.

JT Monitor

JT Monitor is a companion service to the Device Engine and JT Live. JT Monitor can be set to check the status of the engine and some other critical system aspects, and notify recipients of potential issues. It can also be used to automatically restart the JT Live or engine service if it has stopped for some reason. No additional licensing is required for JT Monitor.

JT Support

JT Support is a licensed Jarrison Systems product, used primarily for managing multiple backups.

JT Support

JT Support is a licensed Jarrison Systems product, used primarily for managing multiple backups.

JTR File

A JTR file is the file created when Registration details are saved by a user in Jarrison Time for offline licensing. The filename will be the site name, the extension is .jtr (Jarrison Time Registration). The file should be sent to supplier for activation codes.

JTR File

A JTR file is the file created when Registration details are saved by a user in Jarrison Time for offline licensing. The filename will be the site name, the extension is .jtr (Jarrison Time Registration). The file should be sent to supplier for activation codes.

LAN/WAN IP Devices

These are devices connected to a network through which they communicate with Jarrison Time. The devices must have static IP addresses.

LAN/WAN IP Devices

These are devices connected to a network through which they communicate with Jarrison Time. The devices must have static IP addresses.

Leave (Module)

The Leave module is a licensed module in Jarrison Time that allows for leave balance accumulation and reporting.

Leave (Module)

The Leave module is a licensed module in Jarrison Time that allows for leave balance accumulation and reporting.

Lockdown Dates

Lockdown Dates are used in Jarrison Time to prevent changes from being made to certain system aspects prior to a specified date. Lockdown dates can be independently applied for general T&A, for Leave, or for the Day Schedule.

Lockdown Dates

Lockdown Dates are used in Jarrison Time to prevent changes from being made to certain system aspects prior to a specified date. Lockdown dates can be independently applied for general T&A, for Leave, or for the Day Schedule.

Lockdown Override

The Override option corresponds with the Lockdown Dates feature in Jarrison Time. Override allows specified Users to make changes for a certain date range, for a limited time on a once-off basis. E.g. All users can be prevented from making any system changes prior to January 2021, however user Jim is set to be allowed to make changes to anywhere in 2020 – but can only do this until the end of today.

Overrides are applied from User Profiles.

Lockdown Override

The Override option corresponds with the Lockdown Dates feature in Jarrison Time. Override allows specified Users to make changes for a certain date range, for a limited time on a once-off basis. E.g. All users can be prevented from making any system changes prior to January 2021, however user Jim is set to be allowed to make changes to anywhere in 2020 – but can only do this until the end of today.

Overrides are applied from User Profiles.

Multiple Actions

A Multiple Action is some kind of change that can be applied to either one person or a group (filter) of people simultaneously. For example an adjustment Multiple Action could be used to give a single employee a month of leave, or a group of employees a single day of leave.

Note that some Multiple Actions cannot be reversed, if applied in error to a group they will need to be individually corrected.

Multiple Actions

A Multiple Action is some kind of change that can be applied to either one person or a group (filter) of people simultaneously. For example an adjustment Multiple Action could be used to give a single employee a month of leave, or a group of employees a single day of leave.

Note that some Multiple Actions cannot be reversed, if applied in error to a group they will need to be individually corrected.

Overtime Pre-Authorization

In Jarrison Time it is possible to authorize OT for employees ahead of time as opposed to letting them earn regular unauthorized overtime that later requires authorizing. Employees still need to clock to earn the pre-authorized time or it will remain as unauthorized.

Overtime Pre-Authorization

In Jarrison Time it is possible to authorize OT for employees ahead of time as opposed to letting them earn regular unauthorized overtime that later requires authorizing. Employees still need to clock to earn the pre-authorized time or it will remain as unauthorized.

Pay Groups

In Jarrison Time Pay Groups contain the rules for the pay cycle. E.g. Weekly or Monthly duration, Minimum NT requirements before OT, etc.

Pay Groups are assigned to people by users or Third-Party Import.

Pay Groups

In Jarrison Time Pay Groups contain the rules for the pay cycle. E.g. Weekly or Monthly duration, Minimum NT requirements before OT, etc.

Pay Groups are assigned to people by users or Third-Party Import.

Pay Totals

Pay Totals in Jarrison Time are Period Totals which have had the Pay Group rules applied.

Pay Totals

Pay Totals in Jarrison Time are Period Totals which have had the Pay Group rules applied.

Penalty Rates

Penalty rate is the term used in Australia for higher rates of pay that employees receive for working under certain conditions, such as outside normal working hours.

Penalty Rates

Penalty rate is the term used in Australia for higher rates of pay that employees receive for working under certain conditions, such as outside normal working hours.

Period Totals

Period Totals in Jarrison Time are the values of the daily totals for the period, added together.

Period Totals

Period Totals in Jarrison Time are the values of the daily totals for the period, added together.

We use cookies to ensure you get the best experience on our website. By using our website you agree to our Cookie Policy.