# Salesforce: Contact Enhanced

## Description

* Each record represents a contact with additional account and owner information.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/salesforce/resources/salesforce.svg" alt="" data-size="line"> Salesforce

## Columns

| Type     | Name                           | Description                                                                                                                                                                                              |
| -------- | ------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| STRING   | contact\_id                    | Unique contact ID.                                                                                                                                                                                       |
| STRING   | contact\_name                  | Name of contact.                                                                                                                                                                                         |
| STRING   | account\_id                    | ID of contact's account.                                                                                                                                                                                 |
| INTEGER  | department                     | The contact’s department.                                                                                                                                                                                |
| STRING   | contact\_description           | A description of the contact.                                                                                                                                                                            |
| STRING   | email                          | The contact’s email address.                                                                                                                                                                             |
| INTEGER  | individual\_id                 | ID of the data privacy record associated with this contact. This field is available if Data Protection and Privacy is enabled. This is a relationship field.                                             |
| BOOLEAN  | contact\_is\_deleted           | Indicates whether the object has been moved to the Recycle Bin (true) or not (false). Label is Deleted.                                                                                                  |
| DATETIME | last\_activity\_date           | Value is the most recent of either:Due date of the most recent event logged against the record.Due date of the most recently closed task associated with the record.                                     |
| STRING   | lead\_source                   | The lead’s source.                                                                                                                                                                                       |
| STRING   | mailing\_city                  | Mailing address details.                                                                                                                                                                                 |
| STRING   | mailing\_country               | Mailing address details.                                                                                                                                                                                 |
| STRING   | mailing\_country\_code         | Mailing address details.                                                                                                                                                                                 |
| INTEGER  | mailing\_postal\_code          | The ISO codes for the mailing address’s state and country.                                                                                                                                               |
| STRING   | mailing\_state                 | Mailing address details.                                                                                                                                                                                 |
| STRING   | mailing\_state\_code           | The ISO codes for the mailing address’s state and country.                                                                                                                                               |
| STRING   | mailing\_street                | Street address for mailing address.                                                                                                                                                                      |
| INTEGER  | master\_record\_id             | If this record was deleted as the result of a merge, this field contains the ID of the record that remains. If this record was deleted for any other reason, or has not been deleted, the value is null. |
| INTEGER  | mobile\_phone                  | Contact’s mobile phone number.                                                                                                                                                                           |
| STRING   | contact\_owner\_id             | The ID of the owner of the account associated with this contact.                                                                                                                                         |
| STRING   | phone                          | Telephone number for the contact. Label is Business Phone.                                                                                                                                               |
| INTEGER  | reports\_to\_id                | This field doesn’t appear if IsPersonAccount is true.This is a relationship field.                                                                                                                       |
| STRING   | contact\_owner\_name           | Name of owner of the account associated with this contact.                                                                                                                                               |
| STRING   | account\_name                  | Name of the account.                                                                                                                                                                                     |
| INTEGER  | account\_number                | Account number assigned to this account (not the unique, system-generated ID assigned during creation).                                                                                                  |
| STRING   | account\_source                | The source of the account record. For example, Advertisement, Data.com, or Trade Show.                                                                                                                   |
| DECIMAL  | account\_annual\_revenue       | Estimated annual revenue of the account.                                                                                                                                                                 |
| STRING   | account\_description           | Text description of the account.                                                                                                                                                                         |
| STRING   | account\_industry              | An industry associated with this account.                                                                                                                                                                |
| BOOLEAN  | account\_is\_deleted           | Indicates whether the object has been moved to the Recycle Bin (true) or not (false).                                                                                                                    |
| INTEGER  | account\_number\_of\_employees | Number of employees working at the company represented by this account.                                                                                                                                  |
| STRING   | account\_owner\_id             | The ID of the user who currently owns this account.                                                                                                                                                      |
| INTEGER  | account\_parent\_id            | ID of the account parent object, if any.                                                                                                                                                                 |
| INTEGER  | account\_rating                | The account’s prospect rating, for example Hot, Warm, or Cold.                                                                                                                                           |
| STRING   | account\_type                  | Type of account, for example, Customer, Competitor, or Partner.                                                                                                                                          |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/salesforce-contact-enhanced.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
