Cmdlets for Paylocity

Build 23.0.8839


Add/update non-primary state tax

Table Specific Information


The 本製品 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 本製品.

  • EmployeeId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM NonPrimaryStateTax WHERE EmployeeId = '123'


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)


Following is an example of how to Update a Non-PrimaryStateTax table:

UPDATE [NonPrimaryStateTax] SET Percentage = 2.5, Exemptions = 10 WHERE employeeId = '123'


Name Type ReadOnly References Description
EmployeeId [KEY] String True


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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839