Jul 20, 2023
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 |