You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Home > Transformations > Standard Data Definitions > Standard Punch Definition
Standard Punch Definition
print icon

detamoov supports the ability to import punches directly to payroll platforms. In order to import punches to a payroll platform, you need to have punch data formatted in the Standard Punch Definition. 

 

File Specifications

File Type Generated CSV
Header Row(s) Generated Yes
Footer Row(s) Generated No
End of Row Character CRLF (Carriage Return Line Feed)

 

Field Mappings

Field Required Data Type Notes
Company Code   String Company identifier in your payroll system.
Employee Number Yes String

Employee identifier in your payroll system.

External Employee ID   String

Employee identifier in the third party system capturing punches.

 

Will be supported in the future to fine employees using this ID vs. their employee number.

First Name   String Employee first name.
Last Name   String

Employee last name.

Punch ID   String Unique identifier for the punch in the third party system capturing punches.
Punch Type   String

In

Out

 

The type of punch collected. If not specified, a "raw" punch will be inserted into payroll.

Punch DateTime  

Datetime

yyyy-MM-ddTHH:mm:ssK 

Datetime associated with the punch in ISO 8601 format. This is the datetime passed to payroll for the punch.
Punch Recorded DateTime  

Datetime

yyyy-MM-ddTHH:mm:ssK 

If the the punch system utilizes rounding or other rules, this ist he actual time the punch was record. This datetime is not passed to payroll. Datetime must be in ISO 860 format.
Punch Time Zone   String Time Zone associated with the punch. Not utilized currently.
IP Address   String IP address recorded for the punch.
Latitude   Numeric Numeric latitude location where the punch was recorded.
Longitude   Numeric Numeric longitude location where the punch was recorded.

Notes

  String Notes recorded with the punch. Recommendation is to not include carriage returns or line feeds in the notes.

Custom Field 1

  String  
Custom Field 2   String

 

Custom Field 3

  String

 

Custom Field 4   String  
Custom Field 5

 

String  
scroll to top icon