invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

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_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 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_id varchar2 itgen_crp_people_id 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 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: