Gorrie Regan 2 follows the Standard Time and Attendance Import/Export except for the leave export which is in the following format

Employee Leave Export Data

Purpose

This export creates a csv file containing leave records for each employee. It looks for leavecodes 'S' and 'V'. For each employee, it calculates the leave balance of each code and creates a record in the export.

File Format

The file will export as a .csv formatted file.

Exported Data

Total Length: 87 Characters

Column Header    | Format | Note
-----------------|--------|---------------------
EmployeeID       |Text    | Employee ID Number
Benefit Number   |Text    | The leave code 
Effective Date   |DateTime| The date exported
Amount           |Numeric | The leave amount
Action           |Numeric | Hardcoded as '0'

Sample Export:

EmployeeID,Benefit Number,Effective Date,Amount,Action

111,S,7/2/2018,180.00,0

111,V,7/2/2018,109.00,0

222,S,7/2/2018,112.25,0

222,V,7/2/2018,239.00,0

333,S,7/2/2018,628.75,0

333,V,7/2/2018,371.75,0

Current Customers Using this Layout

  • Blount County, AL
  • Cullman Co, AL
  • St. Clair Co, AL