PrimaryStateTax
Add/update primary state tax
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 PrimaryStateTax WHERE EmployeeId = '123'
Insert
Following is an example of how to inserting into PrimaryStateTax table. For example:
INSERT INTO PrimaryStateTax (Employeeid, FilingStatus, TaxCalculationCode, Exemptions, Exemptions2, Percentage, W4FormYear, TaxCode, Amount) VALUES ('999621027', 'MS', 'AFAP', 10, 15, 5, 2019, GA, 100)
Update
Following is an example of how to Update a PrimaryStateTax table:
UPDATE PrimaryStateTax SET Exemptions = 20, Amount = 125 WHERE employeeId = '123'
Columns
| Name | Type | ReadOnly | References | Description |
| EmployeeId [KEY] | String | True |
Employees.EmployeeId |
Id of the Employee. |
| DeductionsAmount | Decimal | False |
Box 4(b) on form W4 (year 2020 or later): Deductions amount. Decimal (12,2) | |
| DependentsAmount | Decimal | False |
Box 3 on form W4 (year 2020 or later): Total dependents amount. Decimal (12,2) | |
| FilingStatus | String | False |
Employee state tax filing status. Common values are *S* (Single), *M* (Married). | |
| OtherIncomeAmount | Decimal | False |
Box 4(a) on form W4 (year 2020 or later): Other income amount. Decimal (12,2) | |
| TaxCalculationCode | String | False |
Tax calculation code. Common values are *F* (Flat), *P* (Percentage), *FDFP* (Flat Dollar Amount plus Fixed Percentage). | |
| Exemptions | Decimal | False |
State tax exemptions value.Decimal (12,2) | |
| Exemptions2 | Decimal | False |
State tax exemptions 2 value.Decimal (12,2) | |
| HigherRate | Bool | False |
Box 2(c) on form W4 (year 2020 or later): Multiple Jobs or Spouse Works. Boolean | |
| Percentage | Decimal | False |
State Tax percentage. Decimal (12,2) | |
| W4FormYear | Int | False |
The state W4 form year Integer | |
| TaxCode | String | False |
State tax code. | |
| SpecialCheckCalc | String | False |
Supplemental check calculation code. Common values are *Blocked* (Taxes blocked on Supplemental checks), *Supp* (Use supplemental Tax Rate-Code). | |
| Amount | Decimal | False |
State tax code. | |
| CompanyId | String | True |
Id of the Company. |