The Employee Data Export page lets you export employee information (like new employees hired, changes to existing employees' pay rate, last name changes, etc.) to your payroll app The application or software used by your organization to manage payroll..

The Employee Data Export page helps ensure consistency of employee data between CLEARVIEW and your payroll app The application or software used by your organization to manage payroll..

The page begins with a filter Drop-down boxes that let you select from the options available. that you can use to select the Area*, Store, Payroll Grouping and whether you want to Include Inactive* employees in the export.

The following information is displayed on the page:

Only the key fields are displayed on the page. To view all the data that will be included in the export file click on the Show Full Details button.

  • Employee Number: Unique number used to identify and map the employee data to your payroll package..

  • Last Name: The employee's last name.

  • First Name: The employee's first name.

  • Status: Whether the employee is currently employed or was previously employed at your organization.

    • Active indicates that the employee is currently employed at your organization.

    • Inactive means that the employee was previously employed at your organization but was terminated.

  • Hire Date: The date on which the employee started working at your organization.

  • Salary: The salary for the period set by your organization.

    The salary is the Rate recorded in the Job & Pay tab of electronic employee files when the Type is Salary.

  • Rate: The hourly pay rate for the employee (if the employee is paid by hours worked).

    The rate is displayed in the Rate column in the Job & Pay tab of electronic employee files when the Type is Hourly.

  • Termination Date: The date entered in Termination Date when the Status of the electronic employee file was changed to Inactive.

  • Last Day Worked: The date on which the last time card was recorded for the employee.

  • Exported to Payroll*: Yes indicates that the data for the employee has been previously been exported, while No indicates that the employee is new and their data hasn't been exported before.

TO EXPORT EMPLOYEE INFORMATION TO YOUR PAYROLL APP:

Your Payroll Package must be selected for CLEARVIEW to create an export that's compatible.

Click here to learn how to configure your Payroll.

  1. Open the Employee Data Export page.

  2. Select the Area* and Store for which you want to create the export.

  3. Select the Payroll Grouping* or Payroll Employer* for which you want to create the export.

  4. Select which terminated employees you want to include in the report from the Include Inactive* drop-down list.

  5. Click on the Go button.

  6. Review the data displayed in the table.

    Only the key fields are displayed on the page. To view all the data that will be included in the export file click on the Show Full Details button.

Associated Settings

  • Payroll controls how employee pay is processed.

  • Employee File Controls controls the fields on the Create/Update Employee Information page.

  • Employee Numbers controls how employee numbers are assigned to new employees.

  • Employee Termination Reasons controls the list of potential reasons for terminating an employee.

  • Stores controls the Payroll Grouping Code or Payroll Employer for your organization.

*optional section or field that may or may not be visible depending on the settings selected, whether the supplier is integrated or not, etc.