Forecast Calls

This table has 1 row per forecast call object.

ColumnTypeDefinitionSample Value(s)Sample Use
BENTOVarcharA collection of machines that power the Outreach app. Orgs live inside these.This may distinguish orgs that are in different data centers.
COMMENTVarcharAny comments on the forecast metric.
CREATED_ATTimestamp_NTZTime when the forecast call was created.
DEFAULTFloatThe Forecast metric default value.
DML_ATTimestamp_NTZA 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:10Where dml_at::date >= current_date-7 This will return all rows modified in the last 7 days.
DML_TYPEVarcharThe type of manipulation that last occurred to a row.'update', 'delete', 'insert', 'backfill', 'backfill-delete'Where dml_type <> 'delete' Excludes deleted rows.
FORECAST_IDVarcharID of the associated forecast.
FORECAST_METRIC_NAMEVarcharName of the forecast metric.
IDVarcharUnique ID of the forecast call.
IS_DELETED_IN_APPBooleanIs the latest dml_type "delete" or "backfill-delete".Where is_deleted_in_app = false Only keeps undeleted rows.
KEYVarcharThe Forecast metric key.
O_IDVarcharOrganization 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_IDVarcharID of the Owner. This can be user id or territory id.
OWNER_NAMEVarcharThe name of the owner. This will be the name of a User or Territory, depending on the OWNER_TYPE.
OWNER_TYPEVarcharThe type of owner. There are two possible values: `User` or `Territory`.
SURROGATE_IDVarcharAn 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.
VALUEFloatThe Forecast metric value.