Date printed: 12-16-2018 Last updated: 10-12-2007
To view our complete support knowledge base and most current version of this article visit support.timeips.com.
The report contains each employee's name, start date, tenure, and hours worked, as well as the available, earned, used, and lost hours for each benefit type. This file may be modified and imported using the "Benefits Import/Update" section of the page. Select the .csv file and click "Import/Update Benefits" to load the modified file into TimeIPS.
A benefits import file (or IAPI transaction) must always contain "Employee" as the first column. All other columns are optional.
When importing benefit levels, only the "Available" columns (for example, "Sick Available" and "Vacation Available") are used. For each "Available" column, a corresponding "Effective" column must also be filled with a date (for example 10/1/2009) that tells TimeIPS when the new benefit total becomes effective. The Available and Effective pair is equivalent to a Benefit Reset option, meaning that you have created a set-point where accruals will begin at the level specified on the date effective and calculate forward from that point.
To identify an employee on import, the system looks for three fields in order:
All the other columns on the export, such as worked hours, total used, lost, etc. are only informational and are not used by TimeIPS when importing.