invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

PeopleProfiles: Crisp People Profiles

read only

  • Catalogus: Crisp
  • Schema: Views
  • Label: People Profiles

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel PeopleProfiles worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

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

Voorbeeldqueries

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

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: