ODBC Driver for Workday

Build 24.0.9060

TaxRates

Retrieves a single or a collection of company SUI rates.

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 company SUI rate.

ApplicableRate String False

Supported for: SELECT, INSERT. The applicable rate for the company SUI.

CompanyInstance_Company String False

Supported for: SELECT. The Reference ID to use for lookups within our Workday Web Services. For supervisory organizations, this is also the Organization_ID.

CompanyInstance_Descriptor String False

Supported for: SELECT. A preview of the instance

CompanyInstance_Fein String False

Supported for: SELECT. The FEIN for the US company.

CompanyInstance_Id String False

Supported for: SELECT, INSERT. Id of the instance

Ein String False

Supported for: SELECT, INSERT. The EIN value for the company SUI rate.

EinType String False

Supported for: SELECT. The EIN type. Valid values: SUI EIN, STATE EIN, FEIN.

EndDate String False

Supported for: SELECT, INSERT. The end date value of the row for company SUI rate.

Exempt Bool False

Supported for: SELECT, INSERT. If true, the SUI rate is exempt.

RateType String False

Supported for: SELECT. The rate type. Valid values: OR for override rate, DR for default rate.

StartDate Datetime False

Supported for: SELECT, INSERT. The start date value of the row for company SUI rate.

StateInstance_Descriptor String False

Supported for: SELECT. A preview of the instance

StateInstance_Id String False

Supported for: SELECT, INSERT. Id of the instance

StateInstance_PayrollStateAuthorityTaxCode String False

Supported for: SELECT. The Payroll Authority Tax Code for a Payroll Tax Authority.

TaxCode String False

Supported for: SELECT, INSERT. The payroll tax code. As of v1, the default value is W_SUIER.

Company_Prompt String False

The company reference ID or WID that represents 1 or more companies. Example: company=comp1andcompany=comp2andcompany=cb550da820584750aae8f807882fa79a

Effective_Prompt Date False

The effective date for the SUI rate, using the yyyy-mm-dd format.

PayrollStateAuthorityTaxCode_Prompt String False

The FIPS code or WID that represents 1 or more states. Example: payrollStateAuthorityTaxCode=06andpayrollStateAuthorityTaxCode=3b3d378d5f4a48b8b3ac46fee0703226andpayrollStateAuthorityTaxCode=48

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