Importing Auto Holiday Pay Rules

You can use the Auto Holiday Pay Rules import template to import auto holiday pay rules to reduce the amount of manual work required.

Note: This import template is only available to service providers.

To upload and import auto holiday pay rules, do the following:

1. Select Client.
2. From the Client|Change menu, select Auto Holiday Pay Rules.
3. On the Auto Holiday Pay Rules form, click Import to launch the Data Import Tool form. (This button displays for all user roles except Inquiry Only.)

The Auto Holiday Pay Rules import template option and its tabs/fields automatically display when you access this template directly from the Auto Holiday Pay Rules form.

You can navigate directly to the Data Import Tool by clicking (Back Office), then select Data Import Tool on the Operations|Import Processing menu.

When you select the import template that you want, the required file layout displays in the form. Before you can upload and import data, your file must be saved in either comma-separated values (.csv) tabular format or text tab delimited (.txt) format with no spaces or special characters in the file name. (Note: You can click Download Sample Header File to download a sample Excel data file in .csv format, which can be saved in either .csv or .txt format before importing it.)

The layout requirements are:

Field Description

Column Number

The corresponding column number for the imported data.

Category Description

Client ID (required): Unique identifier for the client.
Employee Type: Type of employee.
Pay Method: Method by which the employee will be paid.

Note: The Variable Salary option in the Pay Method field on the Employee Details form only displays if the VARSALMETHOD custom feature code is enabled on the System Parameters form.

FLSA Exempt: FLSA exempt status.
Pay Group: Pay group assigned to holiday.
Pay Code (required): Pay code assigned to holiday.
Number of Hours (required): Number of holiday hours.

Required?

Indicates if the field is required.

Note the following when using the Auto Holiday Pay Rules import template:

Users whose user role is set to DENY for the Auto Holiday Pay form cannot view the Auto Holiday Pay Rules import template in the Data Import Tool.
Users whose user role is set to INQUIRY for the Auto Holiday Pay form, but whose user role is also set to DENY for the Data Import Tool cannot view the Import Rules link on the Auto Holiday Pay form.
Users whose user role is set to INQUIRY for the Auto Holiday Pay form can view the Auto Holiday Pay Rules import template for Miscellaneous Invoice, but cannot import data.
Users whose user role is set to INQUIRY for the Data Import Tool can view the form and import template options, but cannot import data.
Users who do not have access to a particular company through client access groups are unable to import data into that company.
The system appends imported rules to the end of the existing rule list.
The import process ignores duplicate data.