ODBC Driver for Workday

Build 25.0.9434

TaxRates

Retrieves a single or a collection of State Unemployment Insurance (SUI) tax rates configured for different company entities.

Workday Resource Information

Retrieves all company SUI rates. You can filter the company SUI rates by company, payroll state authority tax code, or effective date.

Secured by: Process: Tax Filing/W-2s (Run) - USA

Scope: USA Payroll

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier for the company's State Unemployment Insurance (SUI) rate.

ApplicableRate String False

The applicable SUI tax rate assigned to the company.

CompanyInstance_Company String False

The reference ID used for Workday Web Services lookups. For supervisory organizations, this also serves as the Organization ID.

CompanyInstance_Descriptor String False

A preview or summary of the company instance.

CompanyInstance_Fein String False

The Federal Employer Identification Number (FEIN) associated with the US-based company.

CompanyInstance_Id String False

Unique identifier for the company instance.

Ein String False

The Employer Identification Number (EIN) used for the company's SUI rate.

EinType String False

The type of EIN assigned. Valid values: 'SUI EIN' (State Unemployment Insurance EIN), 'STATE EIN' (State-level EIN), 'FEIN' (Federal EIN).

EndDate String False

The expiration date for the SUI rate entry.

Exempt Bool False

Indicates whether the company is exempt from SUI tax.

RateType String False

Specifies the type of rate assigned. Valid values: 'OR' (override rate) and 'DR' (default rate).

StartDate Datetime False

The date when the SUI rate becomes effective.

StateInstance_Descriptor String False

A preview or summary of the state instance.

StateInstance_Id String False

Unique identifier for the state instance.

StateInstance_PayrollStateAuthorityTaxCode String False

The payroll tax authority's state tax code associated with the SUI tax.

TaxCode String False

The payroll tax code assigned to the SUI rate. Default value: 'W_SUIER'.

Company_Prompt String False

Filters results by company reference ID or Workday ID. Example: company=comp1andcompany=comp2andcompany=cb550da820584750aae8f807882fa79a.

Effective_Prompt Date False

Filters results by the effective date of the SUI rate using the format yyyy-mm-dd.

PayrollStateAuthorityTaxCode_Prompt String False

Filters results by state tax authority using FIPS code or Workday ID. Example: payrollStateAuthorityTaxCode=06andpayrollStateAuthorityTaxCode=3b3d378d5f4a48b8b3ac46fee0703226andpayrollStateAuthorityTaxCode=48.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434