Forecasts
This table has 1 row per forecast 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. | |
| COMMENT | Varchar | Any comments on the forecast. | ||
| CREATED_AT | Timestamp_NTZ | Time when the forecast was created. | ||
| CREATED_BY | Varchar | ID of the user who created the forecast. | ||
| CREATED_BY_NAME | Varchar | Name of the user who created the forecast. | ||
| 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. |
| FORECAST_CONFIG_ID | Varchar | ID of the forecast config. | ||
| FORECAST_CONFIG_NAME | Varchar | Name of the forecast config. | ||
| FORECAST_CONFIG_TYPE | Varchar | Type of forecast config. | ||
| ID | Varchar | Unique ID of the forecast. | ||
| IS_DELETED_IN_APP | Boolean | Is the latest dml_type "delete" or "backfill-delete". | Where is_deleted_in_app = false Only keeps undeleted rows. | |
| 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 | Can be user id or territory id. | ||
| OWNER_NAME | Varchar | User / Territory Name | ||
| OWNER_TYPE | Varchar | User, Territory | ||
| PERIOD_END | Timestamp_NTZ | Forecast period end time. | ||
| PERIOD_START | Timestamp_NTZ | Forecast period start time. | ||
| SUBMITTED_AT | Timestamp_NTZ | Time when the forecast was submitted. | ||
| SUBMITTED_BY | Varchar | ID of the user who submitted the forecast. | ||
| SUBMITTED_BY_NAME | Varchar | Name of the user who submitted the forecast. | ||
| UPDATED_AT | Timestamp_NTZ | Time when the forecast was last updated. | ||
| UPDATED_BY | Varchar | ID of the user who last updated the forecast. | ||
| UPDATED_BY_NAME | Varchar | Name of the user who last updated the forecast. |