Person + Organization + Insights

The Data Dictionary has the most up-to-date field definitions for this table. Use it as your primary reference for column names and descriptions.

What’s included

VELOCITY_ENHANCED_UNLIMITED is a pre-joined table that combines Person, Organization, and Insights in one view. Use this view when you need contact, company, and company-level insight (e.g., technographics, hiring signals) columns in a single query. No need to join the three base tables yourself — the view is maintained for you. Note that all insights are company-level only.

Data dictionary

For the complete and most current field reference, see the Data Dictionary. Field names, descriptions, and examples are sourced from the Person, Organization, and Insight table pages. This pre-joined table includes all person fields (suffix _PER), all company fields (suffix _ORG from Companies category), and all insight fields (suffix _ORG from Company Insights category).

Identifiers

Field	Description	Example
`RBID_PER`	RevenueBase’s unique identification for the person. The RBID stays the same if someone changes their job.	`rb-pabq6o2xf`
`RBID_ORG`	RevenueBase’s unique identifier for a company	`rb-oab75n3pe`
`RBID_PAO`	RevenueBase’s unique identifier for the person at a specific company.	Concatenates `RBID_PER` with `RBID_ORG`: `rb-pabq6o2xf-rb-oab75n3pe`

Key person fields

Field	Description	Example
`FIRST_NAME_PER`	The person’s first name	Marc
`LAST_NAME_PER`	The person’s last name	Rojas
`FULL_NAME_PER`	The person’s full name	Kathryn E. Gibson
`EMAIL_ADDRESS_PER`	The person’s work email address	kcollins@fortmckaygroup.com
`JOB_TITLE_PER`	The person’s current job title	Senior Technical Consultant
`JOB_LEVEL_PER`	The seniority level of the person’s job	Manager
`JOB_FUNCTION_PER`	The department that the person works in.	Information Technology

For the complete list of person fields, see Person + Organization documentation. This table includes all person fields with _PER suffix.

Key company fields

Field	Description	Example
`COMPANY_NAME_ORG`	Name of the organization	Dell Technologies
`DOMAIN_ORG`	Domain of the company’s website	fsiservices.com
`EMPLOYEE_COUNT_MAX`	Maximum number of employees	10000
`EMPLOYEE_COUNT_RANGE_ORG`	Range of employee count	5001 to 10000
`INDUSTRY_LINKEDIN_ORG`	Industry description from LinkedIn	[ ""Software Development"" ]
`REVENUE_RANGE_ORG`	Range of the company’s revenue	`$50M to <$100M`
`HEADQUARTERS_CITY_ORG`	City where the company HQ is located	New York
`HEADQUARTERS_STATE_NAME_ORG`	State where the company HQ is located	NY
`HEADQUARTERS_COUNTRY_NAME_ORG`	Country where the company HQ is located	United States

For the complete list of company fields, see Person + Organization documentation. This table includes all company fields with _ORG suffix from the Companies category.

Insight fields

Field	Description	Example
`ABM_TECH_ORG`	There is evidence of particular activity based management technologies in use	6Sense;Demandbase;Uberflip;Terminus;Engagio;Triblio
`ANALYTICS_TECH_ORG`	There is evidence of particular analytics technologies in use	Tableau;Power BI;Segment;Looker;Qlik
`CRM_TECH_ORG`	There is evidence of particular customer relationship management technologies in use	Salesforce CRM;Hubspot;Microsoft Dynamics;Zoho;Pipedrive CRM;SugarCRM
`SALES_ROLE_COUNT_ORG`	Number of people with sales titles associated with the organization	4
`SALES_OPEN_ROLES_COUNT_ORG`	Number of open job postings for sales positions at the organization	6
`LAST_FUNDING_AMOUNT_ORG`	If the organization received funding, the last funding amount	15400000
`LAST_FUNDING_DATE_ORG`	If the organization received funding, the last funding date	2022-09-22
`LAST_FUNDING_TYPE_ORG`	If the business received funding, the last funding type	Post-IPO Equity
`TOTAL_FUNDING_AMOUNT_ORG`	If the organization received funding, the total amount of funding to date	175500000
`EMPLOYEE_ON_LINKEDIN_GROWTH_RATE_ORG`	Percentage of latest month’s employee growth rate as a percentage.	4
`HAS_CIO_ORG`	If the business has a chief information officer	Yes
`HAS_CISO_ORG`	If the business has a chief information security officer	Yes

For the complete list of insight fields, see Insight documentation. This table includes all insight fields with _ORG suffix from the Company Insights category.

Example queries

Find contacts at companies using specific technologies

SELECT 
    RBID_PER,
    FIRST_NAME_PER,
    LAST_NAME_PER,
    EMAIL_ADDRESS_PER,
    JOB_TITLE_PER,
    COMPANY_NAME_ORG,
    CRM_TECH_ORG,
    SALES_ROLE_COUNT_ORG
FROM RELEASE.VELOCITY_ENHANCED_UNLIMITED_LATEST
WHERE CRM_TECH_ORG IS NOT NULL
  AND SALES_ROLE_COUNT_ORG > 0
LIMIT 100;

Find contacts at companies with recent funding

SELECT 
    FIRST_NAME_PER,
    LAST_NAME_PER,
    EMAIL_ADDRESS_PER,
    COMPANY_NAME_ORG,
    LAST_FUNDING_AMOUNT_ORG,
    LAST_FUNDING_DATE_ORG,
    LAST_FUNDING_TYPE_ORG
FROM RELEASE.VELOCITY_ENHANCED_UNLIMITED_LATEST
WHERE LAST_FUNDING_DATE_ORG >= DATEADD(month, -12, CURRENT_DATE())
  AND JOB_LEVEL_PER IN ('VP', 'Director', 'C-Suite')
ORDER BY LAST_FUNDING_DATE_ORG DESC;

Getting Started

Base Tables

Pre-Joined Tables

Joining Tables

Person + Organization + Insights

What’s included

Data dictionary

Identifiers

Key person fields

Key company fields

Insight fields

Example queries

Find contacts at companies using specific technologies

Find contacts at companies with recent funding

See also

​What’s included

​Data dictionary

​Identifiers

​Key person fields

​Key company fields

​Insight fields

​Example queries

​Find contacts at companies using specific technologies

​Find contacts at companies with recent funding

​See also

What’s included

Data dictionary

Identifiers

Key person fields

Key company fields

Insight fields

Example queries

Find contacts at companies using specific technologies

Find contacts at companies with recent funding

See also