This table has 1 row per note and per org id. Only notes associated with Accounts or Prospects are included.
Note: pinned_at is a nullable timestamp — a non-null value indicates the note is pinned. This field is surfaced as a boolean pinned in the GraphQL and Public APIs.
| 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 | The UTC datetime that the note was created in Outreach. | ||
| CREATOR_ID | Varchar | ID of the note's creator. Maps to different tables based on the "creator_type" field. | ||
| CREATOR_TYPE | Varchar | Polymorphic type of the creator entity. | 'User', 'SystemActor' | Used with creator_id to determine creator of the note. |
| 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. |
| ID | Varchar | Represents an individual row of data in a table. Fields in other tables that match to this ID will be called thisTable_id. e.g. ID in the notes table will appear as the note_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. | |
| MESSAGE | Varchar | Body text of the note. This field contains PII and is subject to compliance deletion on GDPR requests. | ||
| NOTE_TYPE | Varchar | The activity type of the note. | 'note', 'call', 'coffee', 'beer', 'meeting' | Filter by note type. |
| OPPORTUNITY_ID | Varchar | ID of the associated opportunity. | Maps to the OPPORTUNITIES table. | |
| 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 | |
| PINNED_AT | Timestamp_NTZ | Timestamp when the note was pinned. Null if the note is not pinned. | ||
| SUBJECT_ID | Varchar | ID of the parent entity the note belongs to. Maps to different tables based on the "subject_type" field. | ||
| SUBJECT_TYPE | Varchar | The type of the parent entity the note belongs to. Only Account and Prospect notes are included in this table. | 'Account', 'Prospect' | Used with subject_id to determine the parent entity. |
| 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. | |
| UPDATED_AT | Timestamp_NTZ | The UTC datetime for the last time this record was updated. |