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