Difference between revisions of "Hours Import"
From sbv.wiki
| Line 1: | Line 1: | ||
| − | The employee import allows you to add hours to the employee’s time card. | + | The employee import allows you to add hours to the employee’s time card. An hours import is identified by the sheet name or file name containing the word "hours". |
| − | + | ||
{| class="wikitable" | {| class="wikitable" | ||
| Line 10: | Line 9: | ||
|- | |- | ||
| − | | 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 |
|- | |- | ||
Revision as of 01:56, 25 December 2015
The employee import allows you to add hours to the employee’s time card. An hours import is identified by the sheet name or file name containing the word "hours".
| 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 |
| Pay Date | Pay Date, Date | Yes | |
| Pay Type / Hours | The pay type ID | The column header identifies the pay type. The data in each row represents the hours for the pay type. | Yes |
