invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

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 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.

Exemples 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

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 :