Tableau Connector for Reckon

Build 24.0.9060

Employees

Create, update, delete, and query Reckon Employees.

Table Specific Information

This table has a Custom Fields column. See the Custom Fields page for more information.

Select

By default, SupportEnhancedSQL is set to true, and the following will be honored if present. Other filters will be executed client side. If SupportEnhancedSQL is set to false, only the following filters will be honored.

Reckon allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only the equals or = comparison. The available columns for Employees are Id, Name, TimeModified, and IsActive. TimeModified may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range. Name may be used with the = or LIKE conditions to establish a starts-with, ends-with, or contains syntax. For example: 

SELECT * FROM Employees WHERE Name LIKE '%George%' AND TimeModified > '1/1/2011' AND TimeModified < '2/1/2011'

Columns

Name Type ReadOnly References Description
ID [KEY] String True

The unique identifier of the employee.

Name String False

The name of the employee. This is required to have a value when inserting.

Salutation String False

A salutation, such as Mr., Mrs., etc.

FirstName String False

The first name of the employee.

MiddleInitial String False

A middle name or middle initial of the employee.

LastName String False

The last name of the employee.

AccountNumber String False

The account number for this employee.

SSN String False

The social security number of the employee.

EmployeeType String False

The type of employee.

The allowed values are Regular, Unspecified, Officer, Statutory, Owner.

Gender String False

The gender of the employee.

The allowed values are Unspecified, Male, Female.

Address String True

Full address returned by Reckon.

Line1 String False

First line of the address.

Line2 String False

Second line of the address.

City String False

City name for the address.

State String False

State name for the address.

PostalCode String False

Postal code for the address.

Country String False

Country for the address.

AlternatePhone String False

An alternate phone number for the employee.

Email String False

The email address of the employee.

PrintAs String False

How the employee name should be printed.

MobilePhone String False

The mobile phone number of this employee.

Pager String False

The pager number of this employee.

PagerPIN String False

The personal identification number for the pager of this employee.

Fax String False

The fax number of this employee.

BirthDate Date False

The date of birth of this employee.

HiredDate Date False

The date the employee was hired.

IsActive Boolean False

This property indicates whether this object is currently enabled for use by Reckon.

Notes String False

This property may contain any notes you wish to make concerning the transaction.

PayPeriod String False

Indicates how often employees are paid.

The allowed values are NotSet, Daily, Weekly, Biweekly, Semimonthly, Monthly, Quarterly, Yearly.

PayrollClassName String False

Class.FullName

A reference to the class into which this employee payroll falls. Id/Name Reference Properties.

PayrollClassId String False

Class.ID

A reference to the class into which this employee payroll falls. Id/Name Reference Properties.

Phone String False

The phone number of the employee.

ReleasedDate Date False

The date the employee was released (if he/she was released).

TimeDataForPaychecks String False

Indicates whether time data is used to create paychecks for this employee.

The allowed values are NotSet, UseTimeData, DoNotUseTimeData.

SickTimeAccrualPeriod String False

Sick-time hours accrual period.

The allowed values are BeginningOfYear, EveryHourOnPaycheck, EveryPaycheck.

SickTimeAccrualStartDate Date False

Sick-time accrual start date. The standard formatting for dates is YYYY-MM-DD; e.g., September 2, 2002 is formatted as 2002-09-02.

SickTimeAccrued String False

Sick-time hours accrued. Time is represented in hours followed by minutes, with the character ':' (colon) separating them. For instance, two hours and thirty minutes is represented as '2:30'. Seconds are not supported. The integrated application has no permission to access personal data. The Reckon administrator can grant permission to access personal data through the Integrated Application preferences.

SickTimeAvailable String False

Sick-time hours available. Time is represented in hours followed by minutes, with the character ':' (colon) separating them. For instance, two hours and thirty minutes is represented as '2:30'. Seconds are not supported. The integrated application has no permission to access personal data. The Reckon administrator can grant permission to access personal data through the Integrated Application preferences.

SickTimeMaximum String False

Sick-time maximum hours. Time is represented in hours followed by minutes, with the character ':' (colon) separating them. For instance, two hours and thirty minutes is represented as '2:30'. Seconds are not supported

SickTimeYearlyReset Boolean False

Sick-time hours resets each year. Default false.

SickTimeUsed String False

Sick-time hours used. Time is represented in hours followed by minutes, with the character ':' (colon) separating them. For instance, two hours and thirty minutes is represented as '2:30'. Seconds are not supported.

VacationTimeAccrualPeriod String False

Vacation-time hours accrual period.

The allowed values are BeginningOfYear, EveryHourOnPaycheck, EveryPaycheck.

VacationTimeAccrualStartDate Date False

Vacation-time accrual start date. The standard formatting for dates is YYYY-MM-DD; i.e., September 2, 2002 is formatted as 2002-09-02.

VacationTimeAccrued String False

Vacation-time hours accrued. Time is represented in hours followed by minutes, with the character ':' (colon) separating them. For instance, two hours and thirty minutes is represented as '2:30'. Seconds are not supported.

VacationTimeAvailable String False

Vacation-time hours available. Time is represented in hours followed by minutes, with the character ':' (colon) separating them. For instance, two hours and thirty minutes is represented as '2:30'. Seconds are not supported.

VacationTimeMaximum String False

Vacation-time maximum hours. Time is represented in hours followed by minutes, with the character ':' (colon) separating them. For instance, two hours and thirty minutes is represented as '2:30'. Seconds are not supported.

VacationTimeYearlyReset Boolean False

Vacation-time hours resets each year. Default false.

VacationTimeUsed String False

Vacation-time hours used. Time is represented in hours followed by minutes, with the character ':' (colon) separating them. For instance, two hours and thirty minutes is represented as '2:30'. Seconds are not supported.

CustomFields String False

Custom fields returned from Reckon and formatted into XML.

EditSequence String True

A string indicating the revision of the employee record.

TimeModified Datetime True

When the employee record was last modified.

TimeCreated Datetime True

When the employee record was created.

Pseudo-Columns

Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
StartModifiedDate String

This pseudo column is deprecated and should no longer be used. Earliest modified date to search for.

EndModifiedDate String

This pseudo column is deprecated and should no longer be used. Latest modified date to search for.

OpeningBalance String

The opening balance of the account (by default 0). Note that this property is used only when adding new accounts to Reckon.

OpeningDate String

The opening balance date of the account. Note that this property is used only when adding new accounts to Reckon.

ActiveStatus String

This pseudo column is deprecated and should no longer be used. Limits the search to active or inactive records only or all records.

The allowed values are ALL, ACTIVE, INACTIVE, NA.

The default value is ALL.

NameMatchType String

This pseudo column is deprecated and should no longer be used. Type of match to perform on name.

The allowed values are EXACT, STARTSWITH, ENDSWITH, CONTAINS.

The default value is CONTAINS.

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