Employees
Create, update, delete, and query Reckon Employees.
Table Specific Information
This table has a Custom Fields column. See the カスタムフィールド page for more information.
Select
The following filters support server-side execution. Other filters are executed client-side.
Reckon Accounts Hosted 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. 使用できる値は次のとおりです。Regular, Unspecified, Officer, Statutory, Owner | |
| Gender | String | False |
The gender of the employee. 使用できる値は次のとおりです。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. 使用できる値は次のとおりです。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. 使用できる値は次のとおりです。NotSet, UseTimeData, DoNotUseTimeData | |
| SickTimeAccrualPeriod | String | False |
Sick-time hours accrual period. 使用できる値は次のとおりです。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. 使用できる値は次のとおりです。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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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. 使用できる値は次のとおりです。ALL, ACTIVE, INACTIVE, NA デフォルト値はALLです。 |
| NameMatchType | String |
This pseudo column is deprecated and should no longer be used. Type of match to perform on name. 使用できる値は次のとおりです。EXACT, STARTSWITH, ENDSWITH, CONTAINS デフォルト値はCONTAINSです。 |