PeopleProfiles: Crisp People Profiles
read only
- Catalog:
Crisp - Schema:
Views - Label: People Profiles
Can only retrieve data.
Table Columns
The columns of the table PeopleProfiles are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
active_ |
datetime |
itgen_crp_active_last | filters on the platform, writable | Timestamp at which the user was last active. | |
active_ |
char |
itgen_crp_active_now | filters on the platform, writable | Whether user is considered active right now or not. | |
company_ |
varchar2 |
itgen_crp_company_description | filters on the platform, writable | Company description. | |
company_ |
varchar2 |
itgen_crp_company_domain | filters on the platform, writable | Company domain name. | |
company_ |
varchar2 |
itgen_crp_company_geolocation_city | filters on the platform, writable | City name. | |
company_ |
decimal |
itgen_crp_company_geolocation_coordinates_latitude | filters on the platform, writable | Latitude coordinate. | |
company_ |
decimal |
itgen_crp_company_geolocation_coordinates_longitude | filters on the platform, writable | Longitude coordinate. | |
company_ |
varchar2 |
itgen_crp_company_geolocation_country | filters on the platform, writable | Country code. | |
company_ |
varchar2 |
itgen_crp_company_geolocation_region | filters on the platform, writable | Region code. | |
company_ |
varchar2 |
itgen_crp_company_legal_name | filters on the platform, writable | Company legal name. | |
company_ |
decimal |
itgen_crp_company_metrics_arr | filters on the platform, writable | Annual recurring revenue. | |
company_ |
int32 |
itgen_crp_company_metrics_employees | filters on the platform, writable | Number of employees. | |
company_ |
decimal |
itgen_crp_company_metrics_market_cap | filters on the platform, writable | Market capitalization. | |
company_ |
decimal |
itgen_crp_company_metrics_raised | filters on the platform, writable | Money raised. | |
company_ |
varchar2 |
itgen_crp_company_name | filters on the platform, writable | Company name. | |
company_ |
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_ |
varchar2 |
itgen_crp_company_url | filters on the platform, writable | Company website URL. | |
created_ |
datetime |
itgen_crp_created_at | filters on the platform, writable | Profile creation timestamp. | |
email |
varchar2 |
itgen_crp_email | 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_ |
varchar2 |
itgen_crp_people_id | filters on the platform, writable | People identifier. | |
person_ |
varchar2 |
itgen_crp_person_address | filters on the platform, writable | Address for user. | |
person_ |
varchar2 |
itgen_crp_person_avatar | filters on the platform, writable | Avatar for user. | |
person_ |
varchar2 |
itgen_crp_person_description | filters on the platform, writable | Description for user. | |
person_ |
varchar2 |
itgen_crp_person_employment_domain | filters on the platform, writable | Company domain name. | |
person_ |
varchar2 |
itgen_crp_person_employment_name | filters on the platform, writable | Company name. | |
person_ |
varchar2 |
itgen_crp_person_employment_role | filters on the platform, writable | User role in company. | |
person_ |
varchar2 |
itgen_crp_person_employment_seniority | filters on the platform, writable | User seniority in company. | |
person_ |
varchar2 |
itgen_crp_person_employment_title | filters on the platform, writable | User title in company. | |
person_ |
varchar2 |
itgen_crp_person_gender | filters on the platform, writable | Gender for user; one of male and female. | |
person_ |
varchar2 |
itgen_crp_person_geolocation_city | filters on the platform, writable | City name. | |
person_ |
decimal |
itgen_crp_person_geolocation_coordinates_latitude | filters on the platform, writable | Latitude coordinate. | |
person_ |
decimal |
itgen_crp_person_geolocation_coordinates_longitude | filters on the platform, writable | Longitude coordinate. | |
person_ |
varchar2 |
itgen_crp_person_geolocation_country | filters on the platform, writable | Country code. | |
person_ |
varchar2 |
itgen_crp_person_geolocation_region | filters on the platform, writable | Region code. | |
person_ |
varchar2 |
itgen_crp_person_nickname | filters on the platform, writable | Nickname for user (includes first name and last name). | |
person_ |
varchar2 |
itgen_crp_person_phone | filters on the platform, writable | Phone number for user. | |
person_ |
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_ |
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_ |
datetime |
itgen_crp_updated_at | filters on the platform, writable | Profile update timestamp. |
Sample Queries
--
-- 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
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: