Difference between revisions of "Pay Rates Import"
From sbv.wiki
Line 10: | Line 10: | ||
|- | |- | ||
− | | 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 28: | Line 28: | ||
|- | |- | ||
− | | | + | | Labor Levels |
− | | The ID or name of the | + | | The ID or name of the labor level, e.g. Department |
− | | | + | | The labor level ID, labor level description or the scheduler ID, e.g. Office |
− | | | + | | No |
|- | |- | ||
− | | | + | | Pay Rate 2 |
− | | | + | | Pay Rate 2, Rate 2 |
| | | | ||
− | | | + | | No |
+ | |||
+ | |- | ||
+ | | Pay Rate 3 | ||
+ | | Pay Rate 3, Rate 3 | ||
+ | | | ||
+ | | No | ||
+ | |||
+ | |- | ||
+ | | Pay Rate 4 | ||
+ | | Pay Rate 4, Rate 4 | ||
+ | | | ||
+ | | No | ||
|} | |} |
Revision as of 22:01, 16 December 2015
The pay rates import adds or updates the employee’s pay rates.
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 Rate | Pay Rate, Rate | Yes | |
Labor Levels | The ID or name of the labor level, e.g. Department | The labor level ID, labor level description or the scheduler ID, e.g. Office | No |
Pay Rate 2 | Pay Rate 2, Rate 2 | No | |
Pay Rate 3 | Pay Rate 3, Rate 3 | No | |
Pay Rate 4 | Pay Rate 4, Rate 4 | No |