Table Type: Historical Data
Stores the historical presence changes by user_id and start_time.
The end_time will be populated if the user has since changed state, and will be NULL if the data set does not extend that far. Either a system_presence or an organization_presence_id will be populated.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| start_time | datetime | Primary Key, Required | The start datetime of the user presence |
| user_id | string | Primary Key | The user_id of the user whose presence is being recorded. |
| system_presence | string | The user's presence state. This will be one of the following values: AVAILABLE, AWAY, BUSY, OFFLINE, IDLE, ON_QUEUE, MEAL, TRAINING, MEETING, BREAK | |
| end_time | datetime | The end datetime of the user presence. | |
| organization_presence_id | string | The organization presence id of the user. This may be NULL if the user is not in an organization presence state. | |
| db_last_updated | datetime | Required | When this record was last updated in UTC. |