UKG is providing customers with three options for customer who use UKG Workforce Central in the cloud to use while Workforce Central is unavailable:
- UKG Excel Timesheet Aggregator Solution
- Excel Scheduling Solution
- On-Premise Clock Punch Collection Server
- Quick Timestamp Offline Mode (QTSO)
What is the Excel Timesheet Punch Aggregator Solution?
UKG has created a macro-driven Excel file that presents punch data and hours in an Excel timesheet. It also integrates with the On-Premise Clock Punch Server for consumption of the CSV punch files. This provides a simple approach for customers to consolidate punch files and better visualize how many hours each employee worked. It also provides a means to store manually-added punch data for later integration back into UKG Workforce Central.
The Excel Timesheet Punch Aggregator Solution is a good fit for:
- Customers using On-Premise Clock Punch Server for clocks and wanting to view/edit those punches in a summary timesheet.
- Customers who are using other solutions for capturing punches and can save them in CSV format for importing into this Excel timesheet (contact support for more information on importing CSV files).
- Customers who want to manually enter employee punches into a summary timesheet
What are the requirements?
- 64-bit version of Microsoft Excel
- Basic Excel skills
- Windows PC (MacOS not supported)
- Ability to store Excel spreadsheets on a local server
- This solution is available now
- Please contact UKG support for more details
What is the Excel Scheduling Solution?
The Excel Schedule Solution is an MS Excel file that can be used to create a very simple schedule. This solution will not include any workload information (including forecasting or budgeting). The calculations of scheduled hours, employee rule violations, and accruals are not supported.
The Excel Schedule solution is a good fit for:
- Customers who will find value in a basic scheduling tool. The solution allows you to enter employee information (name, location, job), shift templates and pay code edits.
- Customers who have simple Excel skills and the ability to save files locally
What are the requirements?
- Simple Excel skills
- Ability to store the Excel file locally
- If you are interested in this option, contact UKG Customer Support.
What is the On-Premise Clock Punch Collection Server?
The On-Premise Clock Punch Collection Server (OPPC) is installed at the customer site to collect punches from clocks and store them in CSV format while UKG Workforce Central is unavailable. This will keep the clocks from running out of memory so that punches can continue to be entered and collected. Punch CSV files can be imported to Workforce Central when it is back online and can be accessed and used as needed, while Workforce Central is unavailable, by importing the CSV files into the Excel Timecard Solution.
OPPC is a good fit for:
- Customers with clocks that are at risk of exceeding storage capacity before Workforce Central is back online, and want to use punch data to confirm employee work time once Workforce Central is back online
- Customers who would like to access clock punch data prior to Workforce Central becoming available
OPPC is not a good fit for:
- Customers who do not have the ability to provide a server with network accessibility from all their clocks, or do not have IT staff who can install and manage the server
- Customers who have 4500 series clocks that do not support Device Initiated communication. These include the following models and firmware versions:
- Kronos Series 4500 Part Number 8602000-xxx, firmware versions 2.x.x
- Kronos Series 4500 Part Number 8602004-xxx, firmware versions 2.x.x
- Kronos Series 4500 Part Number 8602800-000 to 8602800-499, firmware versions 2.x.x
- Kronos series 4500 terminals with the analog modem communication option
What are the requirements?
To use OPPC, customers should be prepared to:
- Install Apache Tomcat Webserver, Java, and UKG-provided software on a Windows Server 2012 R2 Standard or Higher (64-bit), and run and monitor the server
- Install OPPC on a server in a network location accessible to all of their clocks
- Physically configure each clock to communicate to the On-Premise Punch Collection Server
- Physically configure each clock again to communicate with the Workforce Central Server when back online
- Use Workforce Integration Manager to import punches once Workforce Central is back online
- Customers who wish to view/access punch data while Workforce Central is unavailable must use a tool like the Excel Timecard solution
Important information for customers using Attestation or Activities
There is a version of OPPC that enables customers to retrieve offline Attestation punches and Activities transactions from the majority of UKG clocks. These punches will be moved to a CSV file to ensure clocks will not run out of memory. Once these Attestation and Activities forms are collected, customers’ clocks that were configured for Attestation or Activities offline will be re-configured to support “simple punches” so customer can continue collecting punches. Once Workforce Central is available, clocks will be returned to the previous configuration.
- OPPC is currently available.
- Customers should contact UKG support for more details on this solution.
What is QTSO?
Quick Time Stamp Offline (QTSO) is a solution for simple punch collection. QTSO is a stand-alone application that runs on Windows 10 and allows employees to enter time stamps when communication to the Workforce Central system is not available.
It allows you to capture an employee badge #, punch time and transfer. There is no validation of the user, no punch rules, etc. This includes the badge ID or username, timestamp based on the local server, transfer string, mode used (badge or username). The punch information is stored in encrypted format in the local file system.
UKG is providing an extract utility that can be used to export your QTSO punch DB file to a CSV file. You can then view the punches for your employees and manipulate the information to get the hours worked in the Excel Timesheet Solution.
The WFC server connection attributes for QTSO can be configured so that QTSO will transfer the punch detail to the WFC server when it becomes available.
Who is a good candidate for this solution?
- Customers who simply want to capture basic punch information at a desktop
- Customers who have groups of employees who are co-located and can access a single desktop or a laptop machine
- Customers who do not use Attestation or Activities — both are not supported by QTSO.
- QTSO can be used in a stand-alone environment with no internet connection
What Are The Requirements?
- QTSO is a software solution that must be installed on a 64-bit Windows 10 machine. Complete instructions will be provided.—QTSO has a local DB limit of 150K punches. This is per installed instance of QTSO. Once the limit is reached, the provided rollover script can be used to extract punches into a CSV file so you can continue using QTSO.
- We recommend that you run and use QTSO in a stand-alone environment
This solution is available now. Please contact your UKG Customer Support representative or submit a ticket via the Kronos Community.