PeopleProfiles: Crisp People Profiles
read only
- Catálogo:
Crisp - Esquema:
Views - Label: People Profiles
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla PeopleProfiles. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | 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. |
Ejemplos de 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
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: