Difference between revisions of "Punch Import"
From sbv.wiki
Line 8: | Line 8: | ||
! Notes | ! Notes | ||
! Required | ! Required | ||
+ | |||
|- | |- | ||
− | | Employee | + | | Employee Identifier |
− | | Employee ID, Emp ID, ID | + | | Employee ID, Emp ID, ID, Employee Number, Clock_ID, Payroll_ID, SSN_ID |
− | | | + | | This is used to uniquely identify the employee. Note the distinction with the clock ID, SSN, and Payroll ID fields is the “_”. With a multi-facility configuration you must also provide the Facility column. |
| Yes | | Yes | ||
Line 18: | Line 19: | ||
| Punch Date, Punch Time, Punch Date Time | | Punch Date, Punch Time, Punch Date Time | ||
| | | | ||
− | |Yes | + | | Yes |
|- | |- | ||
| Punch Type | | Punch Type | ||
| Punch Type | | Punch Type | ||
− | | In, Out | + | | In, Out, Back From Break, Back From Lunch |
− | | | + | | No |
|} | |} | ||
==See Also== | ==See Also== | ||
[[Import]] | [[Import]] |
Revision as of 22:23, 16 December 2015
This imports punches, typically from an existing system where the punch information matches the employee’s ID.
Column Type | Identifiers | Notes | Required |
---|---|---|---|
Employee Identifier | Employee ID, Emp ID, ID, Employee Number, Clock_ID, Payroll_ID, SSN_ID | This is used to uniquely identify the employee. Note the distinction with the clock ID, SSN, and Payroll ID fields is the “_”. With a multi-facility configuration you must also provide the Facility column. | Yes |
Punch Date Time | Punch Date, Punch Time, Punch Date Time | Yes | |
Punch Type | Punch Type | In, Out, Back From Break, Back From Lunch | No |