EmployeeBenefitSetup
Add/update employee's benefit setup
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 EmployeeBenefitSetup WHERE EmployeeId = '123'
Insert
Following is an example of how to inserting into EmployeeBenefitSetup table. For example:
INSERT INTO EmployeeBenefitSetup (EmployeeId, BenefitSalary, BenefitClass, BenefitSalaryEffectiveDate, BenefitClassEffectiveDate) VALUES ('123', '250', 'FULL', '2021-02-10', '2021-02-10')
Update
Following is an example of how to Update a EmployeeBenefitSetup table:
UPDATE EmployeeBenefitSetup SET BenefitSalary = '250', BenefitClass = 'FULL', BenefitClassEffectiveDate = '2021-02-10', BenefitSalaryEffectiveDate = '2021-02-10' WHERE EmployeeId = '123'
Columns
| Name | Type | ReadOnly | References | Description |
| EmployeeId [KEY] | String | True |
Employees.EmployeeId |
Id of the Employee. |
| BenefitSalary | Decimal | False |
Salary used to configure benefits.Decimal(12,2) | |
| BenefitClass | String | False |
Benefit Class code. Values are configured in Web Pay Company > Setup > Benefits > Classes. | |
| BenefitSalaryEffectiveDate | Date | False |
Date when Benefit Salary takes effect. Common formats include *MM-DD-CCYY*, *CCYY-MM-DD*. | |
| DoNotApplyAdministrativePeriod | Bool | False |
Applicable only for HR Enhanced clients and Benefit Classes with ACA Employment Type of Full Time. | |
| IsMeasureAcaEligibility | Bool | False |
Only valid for HR Enhanced clients and Benefit Classes that are ACA Employment Type of Full Time. | |
| BenefitClassEffectiveDate | Date | False |
Date when Benefit Class takes effect. Common formats include *MM-DD-CCYY*, *CCYY-MM-DD*. | |
| CompanyId | String | True |
Id of the Company. |