NonPrimaryStateTax
Add/update non-primary state tax
Table Specific Information
Select
The provider 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 provider.
- 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. | |
| Exemptions2 | Decimal | False |
State tax exemptions 2 value.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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| DeductionsAmount | Decimal |
Box 4(b) on form W4 (year 2020 or later): Deductions amount. Decimal (12,2), This column is for INSERT and UPDATE only. |
| HigherRate | Bool |
Box 2(c) on form W4 (year 2020 or later): Multiple Jobs or Spouse Works. Boolean, This column is for INSERT and UPDATE only. |
| OtherIncomeAmount | Decimal |
Box 4(a) on form W4 (year 2020 or later): Other income amount. Decimal (12,2), This column is for INSERT and UPDATE only. |
| DependentsAmount | Decimal |
Box 3 on form W4 (year 2020 or later): Total dependents amount. Decimal (12,2), This column is for INSERT and UPDATE only. |