Difference between revisions of "Pay Rates Import"
From sbv.wiki
(Created page with "The pay rates import adds or updates the employee’s pay rates. Required Columns {| class="wikitable" |- | '''Column Type''' | '''Identifiers''' | '''Notes''' |- | Emplo...") |
m |
||
| (5 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
The pay rates import adds or updates the employee’s pay rates. | The pay rates import adds or updates the employee’s pay rates. | ||
| − | + | A pay rates import is identified by the sheet name or file name containing the word "Pay Rates". | |
{| 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 | ||
| + | |- | ||
| + | | Starting 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 | |
| − | | | + | |} |
| − | + | ||
| − | + | == See also == | |
| − | + | * [[Import]] | |
| − | + | ||
Latest revision as of 21:03, 27 June 2023
The pay rates import adds or updates the employee’s pay rates.
A pay rates import is identified by the sheet name or file name containing the word "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 |
| Starting 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 |
