> ## Documentation Index
> Fetch the complete documentation index at: https://docs.revenuebase.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Person + Organization + Insights

> Pre-joined view of person, organization, and insights

<Note>
  The [Data Dictionary](/docs/data-features/data-dictionary) has the most up-to-date field definitions for this table. Use it as your primary reference for column names and descriptions.
</Note>

## What's included

`VELOCITY_ENHANCED_UNLIMITED` is a pre-joined table that combines
[Person](/docs/data-features/data-tables/person),
[Organization](/docs/data-features/data-tables/organization),
and [Insights](/docs/data-features/data-tables/insight) 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](/docs/data-features/data-dictionary).

Field names, descriptions, and examples are sourced from the [Person](/docs/data-features/data-tables/person), [Organization](/docs/data-features/data-tables/organization), and [Insight](/docs/data-features/data-tables/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](mailto: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 |

<Note>
  For the complete list of person fields, see [Person + Organization](/docs/data-features/pre-joined-tables/person-organization) documentation. This table includes all person fields with `_PER` suffix.
</Note>

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

<Note>
  For the complete list of company fields, see [Person + Organization](/docs/data-features/pre-joined-tables/person-organization) documentation. This table includes all company fields with `_ORG` suffix from the Companies category.
</Note>

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

<Note>
  For the complete list of insight fields, see [Insight](/docs/data-features/data-tables/insight) documentation. This table includes all insight fields with `_ORG` suffix from the Company Insights category.
</Note>

### Example queries

#### Find contacts at companies using specific technologies

```sql theme={null}
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

```sql theme={null}
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;
```

### See also

* [Person + Organization](/docs/data-features/pre-joined-tables/person-organization) when you don't need insight fields.
* [Pre-Joined Tables overview](/docs/data-features/pre-joined-tables/pre-joined-overview) for when to use each view.
* [Person](/docs/data-features/data-tables/person), [Organization](/docs/data-features/data-tables/organization), and [Insight](/docs/data-features/data-tables/insight) for the complete field reference.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.