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. | |
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. |