Skip to main content
The Data Dictionary has the most up-to-date field definitions for all RevenueBase tables. Use it as your primary reference for column names and descriptions.
Pre-Joined Tables are ready-made views that combine multiple base tables (e.g., Person/Contacts, Companies, Insight) so you can query them without writing joins yourself. Use them when you need a single table that already links people, companies, and optional insight data.

​
Benefits of pre-joined tables

  • Fewer joins — Query one table instead of joining tables manually.
  • Consistent keys — Join keys and relationships are defined and documented for each pre-joined view.
  • Easier analytics — Start with Person + Organization or Person + Organization + Insight and filter or aggregate as needed.

​
Available pre-joined views

Table NameViewDescription
VELOCITY_BASE_UNLIMITED_LATESTPerson + OrganizationContacts joined to Organization (one row per contact).
VELOCITY_ENHANCED_UNLIMITED_LATESTPerson + Organization + InsightContacts, Organization, and Insight in one view.

​
When to use which

  • Person + Organization — When you need contact and organization attributes together (e.g., contact email + organization name) without insight fields.
  • Person + Organization + Insight — When you also need insight or score fields on the same row.
For custom joins or other combinations, use the base tables and Joining tables.