Table Type: Historical Data
Contains the Time off requests.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| id | string | Primary Key | The globally unique identifier for the object. |
| status | string | The status of this time off request | |
| substatus | string | The substatus of this time off request | |
| user_id | string | The ID of the user associated with this time off request | |
| is_full_day_request | boolean | Whether this is a full day request | |
| marked_as_read | boolean | Whether this request has been marked as read by the agent | |
| activity_code_id | string | The ID of the activity code associated with this time off request. Activity code must be of the TimeOff category | |
| paid | boolean | Whether this is a paid time off request | |
| daily_duration_minutes | int32 | The daily duration of this time off request in minutes | |
| notes | string | The notes associated with this time off request | |
| submitted_by_id | string | The user who submitted this time off request | |
| submitted_date | datetime | The timestamp when this request was submitted | |
| reviewed_by_id | string | The user who reviewed this time off request | |
| reviewed_date | datetime | The timestamp when this request was reviewed | |
| modified_date | datetime | The timestamp when this request was last modified | |
| request_days | string | The days requested off | |
| db_last_updated | datetime | When this record was last updated in UTC. | |
| db_when_created | datetime | When this record was created in UTC. |