Power BI Connector for Reckon

Build 26.0.9655

WorkersCompCodes

Query Reckon Workers Comp Code entries. Requires QBXML Version 7.0 or higher.

Columns

Name Type ReadOnly References Description
ID [KEY] String True

The unique identifier.

Name String True

The name of the workers comp code. This is required to have a value when inserting.

Desc String True

The description of the workers comp code.

CurrentRate Double True

Indicates the workers comp insurance premium rate that is currently in effect for the current comp code. If the code doesn't have a current effective date--that is, it has a future date only, then this field is empty.

CurrentEffectiveDate Datetime True

Indicates the date at which the workers' compensation code went into effect. This field contains a value only if the code is currently in effect. If the code has only a future date, then this field is empty.

NextRate Double True

Indicates the workers comp insurance premium rate that will occur after the current rate and effective date.

NextEffectiveDate Datetime True

Indicates the the first effective date that will occur after the current effective date.

RateHistory String True

The rate of the workers comp code.

IsActive Boolean True

Whether or not the workers comp code is active.

TimeCreated Datetime True

The datetime the entry was made.

TimeModified Datetime True

The last datetime the entry was modified.

EditSequence String True

An identifier used for versioning for this copy of the object.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655