SSIS Components for Workday

Build 23.0.8839

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 Description
Id [KEY] String Unique identifier for company SUI rate.
ApplicableRate String Supported for: SELECT. The applicable rate for the company SUI.
CompanyInstance_Company String 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 Supported for: SELECT. A preview of the instance
CompanyInstance_Fein String Supported for: SELECT. The FEIN for the US company.
CompanyInstance_Id String Supported for: SELECT. Id of the instance
Ein String Supported for: SELECT. The EIN value for the company SUI rate.
EinType String Supported for: SELECT. The EIN type. Valid values: SUI EIN, STATE EIN, FEIN.
EndDate String Supported for: SELECT. The end date value of the row for company SUI rate.
Exempt Bool Supported for: SELECT. If true, the SUI rate is exempt.
RateType String Supported for: SELECT. The rate type. Valid values: OR for override rate, DR for default rate.
StartDate Datetime Supported for: SELECT. The start date value of the row for company SUI rate.
StateInstance_Descriptor String Supported for: SELECT. A preview of the instance
StateInstance_Id String Supported for: SELECT. Id of the instance
StateInstance_PayrollStateAuthorityTaxCode String Supported for: SELECT. The Payroll Authority Tax Code for a Payroll Tax Authority.
TaxCode String Supported for: SELECT. The payroll tax code. As of v1, the default value is W_SUIER.
Company_Prompt String The company reference ID or WID that represents 1 or more companies. Example: company=comp1andcompany=comp2andcompany=cb550da820584750aae8f807882fa79a
Effective_Prompt Date The effective date for the SUI rate, using the yyyy-mm-dd format.
PayrollStateAuthorityTaxCode_Prompt String 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 23.0.8839