Meeting Types
This table has 1 row per meeting type configuration and per org id. Meeting types define the different types of meetings that can be scheduled within an organization, including their settings, availability, and booking rules.
| Column | Type | Definition | Sample Value(s) | Sample Use |
|---|---|---|---|---|
| BENTO | Varchar | A collection of machines that power the Outreach app. Orgs live inside these. | This may distinguish orgs that are in different data centers. | |
| CREATED_TIME | Timestamp_NTZ | The timestamp when the meeting type was originally created in the system. | 2019-01-01 20:14:01:10 | |
| CREATOR_ID | Varchar | The ID of the user who created the meeting type. | Maps to USERS table | |
| DESCRIPTION | Varchar | The default description of meetings of this type. | ||
| DML_AT | Timestamp_NTZ | A datetime (local to server) in which the row was last modified. dml_at can be used to identify updated and new records, but as tables may not see changed records every day, it is not authoritative on when the table was last synced. | 2019-01-01 12:14:01:10 | Where dml_at::date >= current_date-7 This will return all rows modified in the last 7 days. |
| DML_TYPE | Varchar | The type of manipulation that last occurred to a row. | 'update', 'delete', 'insert', 'backfill', 'backfill-delete' | Where dml_type <> 'delete' Excludes deleted rows. |
| DURATION | Number | The default duration of meetings of this type in minutes. | 15, 30, 45, 60 | Used for scheduling and time slot calculations. |
| ID | Varchar | Uniquely identifies meeting type in the table. Fields in other tables that match to this ID will be called thisTable_id. e.g. ID in the calls table will appear as the meeting_type_id in another table. | Count(1), count(id), and count(distinct id) are equivalent in a table without joins or groupings for a given bento & o_id. | |
| IS_DELETED_IN_APP | Boolean | Is the latest dml_type "delete" or "backfill-delete". | Where is_deleted_in_app = false Only keeps undeleted rows. | |
| IS_INTERNAL | Boolean | Flag indicating the meeting is internal default meeting type created by Outreach and not by an organization user. | Where is_internal = false to get user-created meeting types. | |
| LOCATION | Varchar | The default location for meetings of this type. | Conference Room A, Prague, Czech Republic | |
| MEETING_COUNT_DATE_ALGORITHM | Varchar | The algorithm used to count number of meeting held by a user within a calendar month. Used for flexible round robin meeting types. | 'created_at_this_month' = Counts meetings based on when they were booked, 'start_time_this_month' = Counts meetings based on when they take place. | |
| MEETING_COUNT_OUTCOME_FILTER | Varchar | Decides which meetings to count towards meeting held by a user within a calendar month. Used for flexible round robin meeting types. | 'any' = Count all meetings, 'exclude_not_held' = Exclude meetings marked as no show. | |
| NAME | Varchar | The name of the meeting type. | ||
| O_ID | Varchar | Organization ID, also called instance ID. This is the ID for your unique Outreach account. | Most commonly used on joins alongside other primary keys. where a.o_id = b.o_id and a.id = b.a_id | |
| OWNER_ID | Varchar | The ID of the meeting type owner. | Maps to USERS table for determining meeting type ownership. | |
| QUEUE_LOGIC | Varchar | Determines queue logic for round robin meeting types. | 'none' = Meeting does not use round robin logic, 'round_robin_strict' = Round distribution of meetings disregarding how many meetings were held by a user, 'round_robin_flexible' = Flexible round robin distribution of meetings based on a number of meeting held by a user. | |
| REMINDERS_ENABLED | Boolean | Flag indicating if meeting reminders are enabled for this meeting type. | ||
| SHARE_TYPE | Varchar | The sharing configuration for this meeting type. | 'private' = Meeting type is private to the meeting type owner, 'shared' = Meeting type is shared and can be used by all users with permissions. | |
| SURROGATE_ID | Varchar | An md5 hash of bento, o_id and ID for a table. | This can be used to get distinct counts of records if an account has more than 1 org instance. Two orgs will both have a meeting type with ID of "1" but each will have a different surrogate ID. | |
| TEAM_ID | Varchar | The ID of the team this meeting type is associated with. Used for round robin meeting types. | Maps to TEAMS table for round robin meetings. | |
| TITLE | Varchar | The default title/subject of the meeting type. | ||
| UPDATED_TIME | Timestamp_NTZ | The timestamp when the meeting type was last updated in the system. | 2019-01-01 20:14:01:10 |