TimeOffRequests
Returns a list of time off requests.
Columns
| Name | Type | ReadOnly | References | Description |
| StartDate | Date | True | ||
| EndDate | Date | True | ||
| Id [KEY] | String | True | ||
| Name | String | True | ||
| EmployeeId | String | False | ||
| Start | Date | False | ||
| End | Date | False | ||
| StatusLastChanged | Date | True | ||
| StatusLastChangedByUserId | String | True | ||
| Status | String | False |
The allowed values are approved, denied, superceded, requested, canceled. | |
| TypeId | String | False | ||
| TypeName | String | True | ||
| ActionsApprove | Boolean | True | ||
| ActionsBypass | Boolean | True | ||
| ActionsCancel | Boolean | True | ||
| ActionsDeny | Boolean | True | ||
| ActionsEdit | Boolean | True | ||
| ActionsView | Boolean | True | ||
| AmountAmount | String | False | ||
| AmountUnit | String | True | ||
| Created | Date | True | ||
| Dates | String | True | ||
| Notes | String | True | ||
| NotesEmployee | String | True | ||
| NotesManager | String | False | ||
| TypeIcon | String | True |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| Action | String |
Limit to requests that the user has a particular level of access to. Legal values are: view or approve. Defaults to view. The allowed values are view, approve. |