Table Type: Historical Data
Contains the Agent schedules.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| management_unit_id | string | Primary Key | The ID of the management unit associated with this schedule |
| user_id | string | Primary Key | The ID of the user associated with this schedule |
| start_date | datetime | Primary Key, Required | The start date of the schedule |
| schedule_id | string | The ID of the schedule | |
| activity_code | string | The activity code associated with this schedule | |
| length_minutes | int32 | Required | The duration of the activity in minutes |
| external_activity_type | string | The external activity type | |
| external_activity_id | string | The external activity id | |
| paid | boolean | Whether this is a paid schedule | |
| time_off_request_id | string | The ID of the time off request associated with this schedule | |
| db_last_updated | datetime | When this record was last updated in UTC. | |
| db_when_created | datetime | When this record was created in UTC. |