Time Import Results Report

Interface Problems

The first worksheet in the Time Import Report contains any problems that occurred during the import.  Each employee, pay code, department, job code, shift code, rate code, etc. is validated against the information in the system.  Any items in the import file that do not have a corresponding match in the HRA system will be added to the Interface Problems report.

•      Cells that are colored in Red with White text indicate a critical error that prevented the item from being imported.   Rows that contain any red colored field indicates that the entire line item was not imported.

•      Cells that are colored in Blue with Black text indicate a warning item; the item was imported but the highlighted piece of information could not be brought into the system

In the report above, we can see that the time import found no match for employee with clock number 4855.  In addition we see that earning codes 4 and 5 in cells D2 and D3 had no matching earning code set up in the payroll system for this company and so these items also produced a critical error.  In cell F4 we see that the Department code 540 is not valid, however because Department is not a required import field the item was imported but without the Department information.

Imported Items

The second worksheet in the Time Import Report contains a complete listing of all the items that were imported during the import. 

The Matched Employee column shows the name and number of the employee that the item was imported into along with the batch and pay type of the check that the imported item is now on.  

The Line Number column indicates the line number in the time import file from which the time import record originated.