# PeopleCompanyEmails: Crisp People Company Emails - Catalog: `Crisp` - Schema: `Views` - Label: People Company Emails This is a read-only view. The Crisp API may not support changing the data or the Invantive UniversalSQL driver for Crisp does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Crisp API. ## View Columns The columns of the view `PeopleCompanyEmails` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `company_email` | `varchar2` | | ☑ | Email address of the company. | | `company_email` | `varchar2` | | ☑ | Email address of the company. | | `company_name` | `varchar2` | | ☐ | Company name. | | `company_name` | `varchar2` | | ☐ | Company name. | | `email` | `varchar2` | | ☑ | Email for people profile. | | `email` | `varchar2` | | ☑ | Email for people profile. | | `people_id` | `varchar2` | | ☑ | People identifier. | | `people_id` | `varchar2` | | ☑ | People identifier. |# PeopleCompanyEmails: Crisp People Company Emails - Catalog: `Crisp` - Schema: `Views` - Label: People Company Emails This is a read-only view. The Crisp API may not support changing the data or the Invantive UniversalSQL driver for Crisp does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Crisp API. ## View Columns The columns of the view `PeopleCompanyEmails` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `company_email` | `varchar2` | | ☑ | Email address of the company. | | `company_email` | `varchar2` | | ☑ | Email address of the company. | | `company_name` | `varchar2` | | ☐ | Company name. | | `company_name` | `varchar2` | | ☐ | Company name. | | `email` | `varchar2` | | ☑ | Email for people profile. | | `email` | `varchar2` | | ☑ | Email for people profile. | | `people_id` | `varchar2` | | ☑ | People identifier. | | `people_id` | `varchar2` | | ☑ | People identifier. |