AdditionalRates
Add/update additional rates
Table Specific Information
Select
The connector 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 connector.
- 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. |