Contact Attempts
The contact_attempts table contains data about contact attempts made to entities, such as from a canvass task or a log contact form, in the organization.
This table can be used to determine which entities were contacted and when, as well as metadata about the contact attempt such as its disposition and when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| entity_id | The numerical identifier of the entity who was contacted. Relates to the id column in the entities table. |
INT8 | Yes |
| action_entity_id | The numerical identifier of the task/entity relationship within which this contact was performed, if this contact was performed within a task. Relates to the id column in the action_entities table. |
INT8 | Yes |
| action_id | The numerical identifier of the task within which this contact was performed, if this contact was performed within a task. Relates to the id column in the actions table. |
INT8 | Yes |
| campaign_id | The numerical identifier of the campaign within which this contact was performed. Relates to the id column in the campaigns table. |
INT8 | Yes |
| contact_info_type | The type of contact info used for the attempt. One of Address, PhoneNumber, Email, or NULL. |
VARCHAR | Yes |
| contact_info_id | The numerical identifier of the type of contact info used for the attempt. Can be used with contact_info_type to look up the object itself in the appropriate table. |
INT8 | Yes |
| disposition | A number representing the disposition of the contact. 0 is contacted, 1 is attempted, 2 is marked as bad, 3 is skipped, and 4 is marked as do not contact. |
INT4 | Yes |
| created_by_id | The numerical identifier of the user who created this contact attempt. Relates to the id column in the users table. |
INT8 | Yes |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was updated. | TIMESTAMP | No |
| target_type | The type of object that contains the contact attempt, such as a task or a log contact form on entity profiles. One of Action or CustomForm. |
VARCHAR | Yes |
| target_id | The numerical identifier of the type of object this contact attempt is contained in. Can be used with target_type to look up the object itself in the appropriate table. |
INT8 | Yes |
| note | A note left when the contact attempt was created. | VARCHAR | Yes |