Difference between revisions of "Punch Import"
From sbv.wiki
(Created page with "This imports punches, typically from an existing system where the punch information matches the employee’s ID. Required Columns {| class="wikitable" |- | '''Column Type'''...") |
m |
||
| (8 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | This imports punches, typically from an existing system where the punch information matches the employee’s ID. | + | This imports punches, typically from an existing system where the punch information matches either the employee’s ID, clock ID, payroll ID or SSN. A punch import is identified by the sheet name or file name containing the word "punch". |
| − | + | ||
| − | + | ||
{| class="wikitable" | {| class="wikitable" | ||
| + | |||
|- | |- | ||
| − | + | ! 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 | ||
| + | |- | ||
| + | | Punch Comment | ||
| + | | Comment | ||
| + | | | ||
| + | | No | ||
|- | |- | ||
| − | | | + | | Worked Labor Levels |
| − | + | | The ID or name of the worked labor level prefixed with "Worked", e.g. Worked Department | |
| + | | The labor level ID, labor level description or the scheduler ID, e.g. Office | ||
| + | | No | ||
| + | |} | ||
| − | + | ==Sample of Punch Import== | |
| − | Punch | + | |
| − | + | [[File:SBV Punch Import Sample.png]] | |
| + | == See also == | ||
| − | + | * [[Import]] | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
Latest revision as of 18:34, 29 November 2022
This imports punches, typically from an existing system where the punch information matches either the employee’s ID, clock ID, payroll ID or SSN. A punch import is identified by the sheet name or file name containing the word "punch".
| 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 |
| Punch Comment | Comment | No | |
| Worked Labor Levels | The ID or name of the worked labor level prefixed with "Worked", e.g. Worked Department | The labor level ID, labor level description or the scheduler ID, e.g. Office | No |
Sample of Punch Import
