Cmdlets for Paylocity

Build 23.0.8839


Get local taxes by tax code. Get all local taxes. Add new local tax. Delete local tax by tax code

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.
  • TaxCode supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM LocalTaxes WHERE EmployeeId = '123'

SELECT * FROM LocalTaxes WHERE EmployeeId = '123' AND TaxCode = 'AL-BIR1'


Following is an example of how to inserting into LocalTaxes table. For example:

INSERT INTO LocalTaxes (EmployeeId, TaxCode, FilingStatus) VALUES ('999621027', 'AL-BIR1', 'N/A')


Following is an example of how to Delete LocalTaxes from the table:

DELETE FROM LocalTaxes WHERE employeeId = '123' AND TaxCode = 'AL-BIR1'


Name Type ReadOnly References Description
EmployeeId [KEY] String True


Id of the Employee.

Exemptions Decimal False

Local tax exemptions value.Decimal (12,2)

Exemptions2 Decimal False

Local tax exemptions 2 value.Decimal (12,2)

FilingStatus String False

Employee local tax filing status. Must match specific local tax setup.

WorkPSD String False

Work location PSD. Must match Company setup.

ResidentPSD String False

Resident PSD (political subdivision code) applicable in PA. Must match Company setup.

TaxCode String False

Local tax code.

CompanyId String True

Id of the Company.

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