---
title: "PeopleProfiles (Crisp)"
description: "People Profiles"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/datamodels/crisp/Crisp.Views.PeopleProfiles
original: https://documentation.invantive.eu/en/datamodels/crisp/Crisp.Views.PeopleProfiles
updated: 2026-11-16T20:44:02Z
license: https://documentation.invantive.eu/fr/
---

# PeopleProfiles: Crisp People Profiles

`read only`

- Catalogue : `Crisp`
- Schéma : `Views`
- Label: People Profiles

Permet uniquement de récupérer des données.

## Colonnes de table

Les colonnes de la table `PeopleProfiles` sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `active_last` | `datetime` | itgen_crp_active_last | [ ] | filters on the platform, writable | Timestamp at which the user was last active. |
| `active_now` | `char` | itgen_crp_active_now | [ ] | filters on the platform, writable | Whether user is considered active right now or not. |
| `company_description` | `varchar2` | itgen_crp_company_description | [ ] | filters on the platform, writable | Company description. |
| `company_domain` | `varchar2` | itgen_crp_company_domain | [ ] | filters on the platform, writable | Company domain name. |
| `company_geolocation_city` | `varchar2` | itgen_crp_company_geolocation_city | [ ] | filters on the platform, writable | City name. |
| `company_geolocation_coordinates_latitude` | `decimal` | itgen_crp_company_geolocation_coordinates_latitude | [ ] | filters on the platform, writable | Latitude coordinate. |
| `company_geolocation_coordinates_longitude` | `decimal` | itgen_crp_company_geolocation_coordinates_longitude | [ ] | filters on the platform, writable | Longitude coordinate. |
| `company_geolocation_country` | `varchar2` | itgen_crp_company_geolocation_country | [ ] | filters on the platform, writable | Country code. |
| `company_geolocation_region` | `varchar2` | itgen_crp_company_geolocation_region | [ ] | filters on the platform, writable | Region code. |
| `company_legal_name` | `varchar2` | itgen_crp_company_legal_name | [ ] | filters on the platform, writable | Company legal name. |
| `company_metrics_arr` | `decimal` | itgen_crp_company_metrics_arr | [ ] | filters on the platform, writable | Annual recurring revenue. |
| `company_metrics_employees` | `int32` | itgen_crp_company_metrics_employees | [ ] | filters on the platform, writable | Number of employees. |
| `company_metrics_market_cap` | `decimal` | itgen_crp_company_metrics_market_cap | [ ] | filters on the platform, writable | Market capitalization. |
| `company_metrics_raised` | `decimal` | itgen_crp_company_metrics_raised | [ ] | filters on the platform, writable | Money raised. |
| `company_name` | `varchar2` | itgen_crp_company_name | [ ] | filters on the platform, writable | Company name. |
| `company_timezone` | `int32` | itgen_crp_company_timezone | [ ] | filters on the platform, writable | Company time zone offset in minutes relative to UTC, negated (-120 stands for UTC+02:00). |
| `company_url` | `varchar2` | itgen_crp_company_url | [ ] | filters on the platform, writable | Company website URL. |
| `created_at` | `datetime` | itgen_crp_created_at | [x] | filters on the platform, writable | Profile creation timestamp. |
| `email` | `varchar2` | itgen_crp_email | [x] | filters on the platform, writable | Email for people profile. |
| `notepad` | `varchar2` | itgen_crp_notepad | [ ] | filters on the platform, writable | Private notepad on people profile. |
| `people_id` | `varchar2` | itgen_crp_people_id | [x] | filters on the platform, writable | People identifier. |
| `person_address` | `varchar2` | itgen_crp_person_address | [ ] | filters on the platform, writable | Address for user. |
| `person_avatar` | `varchar2` | itgen_crp_person_avatar | [ ] | filters on the platform, writable | Avatar for user. |
| `person_description` | `varchar2` | itgen_crp_person_description | [ ] | filters on the platform, writable | Description for user. |
| `person_employment_domain` | `varchar2` | itgen_crp_person_employment_domain | [ ] | filters on the platform, writable | Company domain name. |
| `person_employment_name` | `varchar2` | itgen_crp_person_employment_name | [ ] | filters on the platform, writable | Company name. |
| `person_employment_role` | `varchar2` | itgen_crp_person_employment_role | [ ] | filters on the platform, writable | User role in company. |
| `person_employment_seniority` | `varchar2` | itgen_crp_person_employment_seniority | [ ] | filters on the platform, writable | User seniority in company. |
| `person_employment_title` | `varchar2` | itgen_crp_person_employment_title | [ ] | filters on the platform, writable | User title in company. |
| `person_gender` | `varchar2` | itgen_crp_person_gender | [ ] | filters on the platform, writable | Gender for user; one of male and female. |
| `person_geolocation_city` | `varchar2` | itgen_crp_person_geolocation_city | [ ] | filters on the platform, writable | City name. |
| `person_geolocation_coordinates_latitude` | `decimal` | itgen_crp_person_geolocation_coordinates_latitude | [ ] | filters on the platform, writable | Latitude coordinate. |
| `person_geolocation_coordinates_longitude` | `decimal` | itgen_crp_person_geolocation_coordinates_longitude | [ ] | filters on the platform, writable | Longitude coordinate. |
| `person_geolocation_country` | `varchar2` | itgen_crp_person_geolocation_country | [ ] | filters on the platform, writable | Country code. |
| `person_geolocation_region` | `varchar2` | itgen_crp_person_geolocation_region | [ ] | filters on the platform, writable | Region code. |
| `person_nickname` | `varchar2` | itgen_crp_person_nickname | [ ] | filters on the platform, writable | Nickname for user (includes first name and last name). |
| `person_phone` | `varchar2` | itgen_crp_person_phone | [ ] | filters on the platform, writable | Phone number for user. |
| `person_timezone` | `int32` | itgen_crp_person_timezone | [ ] | filters on the platform, writable | Time zone offset of user in minutes relative to UTC, negated (-120 stands for UTC+02:00). |
| `person_website` | `varchar2` | itgen_crp_person_website | [ ] | filters on the platform, writable | Website of user. |
| `score` | `int16` | itgen_crp_score | [ ] | filters on the platform, writable | Score associated to this profile, from 1 to 5 (based on ratings from user). |
| `updated_at` | `datetime` | itgen_crp_updated_at | [x] | filters on the platform, writable | Profile update timestamp. |

## Exemples de Queries

```sql
--
-- List the people profiles of the website.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/crisp-data-model/webhelp/crisp-connector-crisp-people-profiles.html
--
select *
from   Crisp.Crisp.PeopleProfiles
limit  100
```


## Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :

- [Crisp](/fr/release-notes/drivers?driver=crisp)
