AdditionalRates
Add/update additional rates
Table Specific Information
Select
The add-in will use the Paylocity API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the add-in.
- EmployeeId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM AdditionalRates WHERE EmployeeId = '123'
Insert
Following is an example of how to inserting into AdditionalRates table. For example:
INSERT INTO AdditionalRates (employeeid, Shift, Job, CostCenter1, CostCenter2, CostCenter3, EffectiveDate, ChangeReason, RateCode, Rate, RatePer, RateNotes) VALUES ('123', '1', '0000123', '100', '101', '100', '2021-02-09', 'Cost of Living Increase', 'CN', 500, 'week', 'NewRate')
Update
Following is an example of how to Update a AdditionalRates table:
UPDATE AdditionalRates SET CostCenter1 = '100', ratecode = 'CN', rate = 100, rateper = 'hour' WHERE employeeId = '123'
Columns
| Name | Type | ReadOnly | References | Description |
| EmployeeId [KEY] | String | True |
Employees.EmployeeId |
Id of the Employee. |
| CostCenter1 | String | False |
Not required. Valid values must match one of the system coded cost centers available in the Additional Rates Cost Center level 1 drop down. This cell must be in a text format. | |
| CostCenter2 | String | False |
Not required. Valid values must match one of the system coded cost centers available in the Additional Rates Cost Center level 2 drop down. This cell must be in a text format. | |
| CostCenter3 | String | False |
Not required. Valid values must match one of the system coded cost centers available in the Additional Rates Cost Center level 3 drop down. This cell must be in a text format. | |
| RatePer | String | False |
Required. Valid values are HOUR or WEEK. | |
| Rate | Decimal | False |
Required. Enter dollar amount that corresponds to the Per selection. | |
| RateCode | String | False |
Required. If populated, must match one of the system coded values available in the Additional Rates Rate Code drop down. | |
| ChangeReason | String | False |
Not required. If populated, must match one of the system coded values available in the Additional Rates Change Reason drop down. | |
| EffectiveDate | Date | False |
Required. Common formats include *MM-DD-CCYY*, *CCYY-MM-DD*. | |
| EndCheckDate | Date | False |
Not required. Must match one of the system coded check dates available in the Additional Rates End Check Date drop down. Common formats include *MM-DD-CCYY*, *CCYY-MM-DD*. | |
| RateNotes | String | False |
Not required. | |
| Job | String | False |
Not required. If populated, must match one of the system coded values available in the Additional Rates Job drop down. | |
| Shift | String | False |
Not required. If populated, must match one of the system coded values available in the Additional Rates Shift drop down. | |
| CompanyId | String | True |
Id of the Company. |