# PeopleProfiles - Catalog: `Crisp` - Schema: `Views` 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 `PeopleProfiles` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `active_last` | `datetime` | | ☐ | Timestamp at which the user was last active. | | `active_now` | `char` | | ☐ | Whether user is considered active right now or not. | | `company_description` | `varchar2` | | ☐ | Company description. | | `company_domain` | `varchar2` | | ☐ | Company domain name. | | `company_emails` | `varchar2` | | ☐ | Company emails (comma-separated list). | | `company_geolocation_city` | `varchar2` | | ☐ | City name. | | `company_geolocation_coordinates_latitude` | `varchar2` | | ☐ | Latitude coordinate. | | `company_geolocation_coordinates_longitude` | `varchar2` | | ☐ | Longitude coordinate. | | `company_geolocation_country` | `varchar2` | | ☐ | Country code. | | `company_geolocation_region` | `varchar2` | | ☐ | Region code. | | `company_legal_name` | `varchar2` | | ☐ | Company legal name. | | `company_metrics_arr` | `decimal` | | ☐ | Annual Recurring Revenue. | | `company_metrics_employees` | `int32` | | ☐ | Number of employees. | | `company_metrics_market_cap` | `decimal` | | ☐ | Market capitalization. | | `company_metrics_raised` | `decimal` | | ☐ | Money raised. | | `company_name` | `varchar2` | | ☐ | Company name. | | `company_phones` | `varchar2` | | ☐ | Company phones (comma-separated list). | | `company_tags` | `varchar2` | | ☐ | Company tags (comma-separated list). | | `company_timezone` | `varchar2` | | ☐ | Company timezone offset (UTC). | | `company_url` | `varchar2` | | ☐ | Company website URL. | | `created_at` | `datetime` | | ☑ | Profile creation timestamp. | | `email` | `varchar2` | | ☑ | Email for people profile. | | `notepad` | `varchar2` | | ☐ | Private notepad on people profile. | | `people_id` | `varchar2` | | ☑ | People identifier. | | `person_address` | `varchar2` | | ☐ | Address for user. | | `person_avatar` | `varchar2` | | ☐ | Avatar for user. | | `person_description` | `varchar2` | | ☐ | Description for user. | | `person_employment_domain` | `varchar2` | | ☐ | Company domain name. | | `person_employment_name` | `varchar2` | | ☐ | Company name. | | `person_employment_role` | `varchar2` | | ☐ | User role in company. | | `person_employment_seniority` | `varchar2` | | ☐ | User seniority in company. | | `person_employment_title` | `varchar2` | | ☐ | User title in company. | | `person_gender` | `varchar2` | | ☐ | Gender for user. | | `person_geolocation_city` | `varchar2` | | ☐ | City name. | | `person_geolocation_coordinates_latitude` | `varchar2` | | ☐ | Latitude coordinate. | | `person_geolocation_coordinates_longitude` | `varchar2` | | ☐ | Longitude coordinate. | | `person_geolocation_country` | `varchar2` | | ☐ | Country code. | | `person_geolocation_region` | `varchar2` | | ☐ | Region code. | | `person_locales` | `varchar2` | | ☐ | Locales (comma-separated list). | | `person_nickname` | `varchar2` | | ☐ | Nickname for user (includes first name and last name). | | `person_phone` | `varchar2` | | ☐ | Phone number for user. | | `person_segments` | `varchar2` | | ☐ | Segments (classifications) (comma-separated list). | | `person_timezone` | `varchar2` | | ☐ | Timezone offset of user (UTC). | | `person_website` | `varchar2` | | ☐ | Website of user. | | `score` | `int16` | | ☐ | Score associated to this profile, from 1 to 5 (based on ratings from user). | | `updated_at` | `datetime` | | ☑ | Profile update timestamp. |