Forecast Configs
This table has 1 row per forecast config object.
| 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_AT | Timestamp_NTZ | Time when the config was created. | ||
| CREATED_BY | Varchar | ID of the user who created the config. | ||
| CREATED_BY_NAME | Varchar | Name of the user who created the config. | ||
| DESCRIPTION | Varchar | Additional notes on the config. | ||
| 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. |
| HIERARCHY_TYPE | Varchar | The Hierarchy type. | ||
| ID | Varchar | Unique ID of the forecast config. | ||
| IS_DELETED_IN_APP | Boolean | Is the latest dml_type "delete" or "backfill-delete". | Where is_deleted_in_app = false Only keeps undeleted rows. | |
| MODE | Varchar | Config mode. | ||
| NAME | Varchar | Name of the config. | ||
| OBJECT_SETTINGS | Variant | Additional settings of the config. | ||
| 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 | |
| PERIOD_LENGTH | Varchar | The Forecast period. | ||
| STATUS | Varchar | Status of the config. | ||
| STATUS_DISABLED_AT | Timestamp_NTZ | Time the config has been changed to disabled status. | ||
| STATUS_ENABLED_AT | Timestamp_NTZ | Time the config has been changed to enabled status. | ||
| SUBMITTED_AT | Timestamp_NTZ | Time of submission of the config. | ||
| 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 prospect with ID of "1" but each will have a different surrogate ID. | |
| TENANT_ID | Varchar | Tenant Id. | ||
| UPDATED_AT | Timestamp_NTZ | Time when the config was last updated. | ||
| UPDATED_BY | Varchar | ID of the user who last updated the config. | ||
| UPDATED_BY_NAME | Varchar | Name of the user who last updated the config. |