ODBC Driver for QuickBooks

Build 24.0.9175

WorkersCompCodes

Queries QuickBooks Workers Compensation Codes, providing an overview of payroll classifications. Requires QBXML Version 7.0 or higher.

Columns

Name Type ReadOnly References ColumnSize Description
ID [KEY] String True 255

The unique identifier of the workers' compensation code.

Name String False 13

The name of the workers' compensation code. This field is required when inserting new records.

Desc String False 31

A description of the workers' compensation code, providing details about its purpose or usage.

CurrentRate Double False

The workers' compensation insurance premium rate currently in effect for this code. If no current rate exists and only a future effective date is set, this field is empty.

CurrentEffectiveDate Datetime False

The date when the current workers' compensation rate became effective. This field is only populated if the code is actively in effect.

NextRate Double False

The upcoming workers' compensation insurance premium rate that will take effect after the current rate expires.

NextEffectiveDate Datetime False

The date when the next workers' compensation rate becomes effective, following the expiration of the current rate.

RateHistory String False

A record of historical rates for the workers' compensation code, providing a timeline of past premium rates and their corresponding effective dates.

IsActive Boolean False

Indicates whether the workers' compensation code is active and in use.

TimeCreated Datetime True

The date and time when the workers' compensation code was initially created.

TimeModified Datetime True

The date and time when the workers' compensation code was last modified.

EditSequence String True

A versioning identifier for this workers' compensation code, used to track revisions.

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