> For the complete documentation index, see [llms.txt](https://docs.lucernahealth.com/guide/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.lucernahealth.com/guide/insights-studio/population-builder/reference-guides/data-model-root-table-and-golden-tables.md).

# Data Model, Root Table and Golden Tables

### The data model

Population Builder uses the entire data model available in Leap, including claims, encounters, rosters, demographics, appointments, and more. To explore the data model further, go to Data Hub.

Having all domains available is what lets a single query span claims, appointments, and rosters at once. It also means the field picker is searching a very large set of tables and columns, which is why how you search matters.

***

### Root table

The root table sits above the query builder panel while building or editing populations. It's the table the population is counted against, and it determines what the query returns.

<div data-with-frame="true"><figure><img src="https://1578258752-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FnXt8wjwK8SlPIzyfLwqU%2Fuploads%2FbE3R2nSXgLbW2HHsxweH%2FScreenshot%202026-08-28%20at%2012.33.00%E2%80%AFAM%201.png?alt=media&amp;token=51156b2b-e2aa-465d-8a6e-0b9dfc0c87ac" alt=""><figcaption></figcaption></figure></div>

<div data-with-frame="true"><figure><img src="https://1578258752-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FnXt8wjwK8SlPIzyfLwqU%2Fuploads%2FEVwlnodQbbOYGYAaSx1O%2FScreenshot%202026-08-28%20at%2012.39.17%E2%80%AFAM%201.png?alt=media&amp;token=78290ce3-8e5d-4180-8631-f56e1a0d5fc1" alt=""><figcaption></figcaption></figure></div>

Leave it alone unless you have a specific reason to change it. The default is usually correct, and switching it can change your results in ways that aren't obvious.

To change it, click the edit icon, then the menu icon, and select Root Table from the dropdown.

<div data-with-frame="true"><figure><img src="https://1578258752-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FnXt8wjwK8SlPIzyfLwqU%2Fuploads%2FjGyQJklkWeJtC0JzuuiX%2FScreenshot%202026-08-28%20at%2012.33.40%E2%80%AFAM%201.png?alt=media&amp;token=93d26a89-a5a5-4975-95ae-048521e73a52" alt=""><figcaption></figcaption></figure></div>

<div data-with-frame="true"><figure><img src="https://1578258752-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FnXt8wjwK8SlPIzyfLwqU%2Fuploads%2FZD67kULNXD7YMYx51kb9%2FScreenshot%202026-08-28%20at%2012.34.17%E2%80%AFAM%201.png?alt=media&amp;token=690b46de-061e-494b-945d-4c3e33b1bba4" alt=""><figcaption></figcaption></figure></div>

<div data-with-frame="true"><figure><img src="https://1578258752-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FnXt8wjwK8SlPIzyfLwqU%2Fuploads%2FU2R42VAQzOxjKWKXqpr5%2FScreenshot%202026-08-28%20at%2012.35.06%E2%80%AFAM%201.png?alt=media&amp;token=86d91ffb-f0c7-4450-bc29-4463143a617c" alt=""><figcaption></figcaption></figure></div>

***

#### Simulated root table

While you're building or editing blocks, the count shown is calculated against a simulated root table. It's an estimate meant to help you understand your data as you go, not a live run.

<div data-with-frame="true"><figure><img src="https://1578258752-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FnXt8wjwK8SlPIzyfLwqU%2Fuploads%2Ffhv46smPjgTtPKjd8Mew%2FScreenshot%202026-08-28%20at%2012.51.43%E2%80%AFAM%201.png?alt=media&amp;token=4dd645ac-f48a-4249-85cc-dbddfabbde2d" alt=""><figcaption></figcaption></figure></div>

<div data-with-frame="true"><figure><img src="https://1578258752-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FnXt8wjwK8SlPIzyfLwqU%2Fuploads%2FCESoK6g72fPq8WuhxnFU%2FScreenshot%202026-08-28%20at%2012.52.30%E2%80%AFAM%201.png?alt=media&amp;token=bad20c26-ca5b-4e06-adcf-17937418a162" alt=""><figcaption></figcaption></figure></div>

It defaults to Dim Consumer Contact and can be changed at any time. To change it, click the edit icon, then the menu icon, and select Root Table from the dropdown.

***

### Golden tables

Working with the entire data model can be overwhelming. Golden tables narrow it down to a smaller, curated set of the most-used tables and fields.

When you search for a field, golden table fields show up first. So in most cases you type what you need and pick from the top results.

***

### Choosing the right field

Searching well is most of the work here.

* Search the concept, not the field name you're imaginin&#x67;**.** It's common to type what you assume a field is called, find nothing, and stop. Typing the plainest version of the idea works better.
* Expect to search more than onc&#x65;**.** A first search usually lands you in the right area rather than on the exact field. Searching `roster` returns roster-related fields; if you specifically need currently active members, `roster status` gets you closer.
* Check the table, not just the colum&#x6E;**.** Each result shows a column name and the table it comes from. The column name tells you what the field is; the table tells you what it's about.

Two fields with near-identical names can mean completely different things:

| Field          | What it actually means      |
| -------------- | --------------------------- |
| Facility State | Where a facility is located |
| Plan State     | Where the member's plan is  |

<figure><img src="https://1578258752-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FnXt8wjwK8SlPIzyfLwqU%2Fuploads%2F7CbFa91LJTy2YffDdnyt%2FScreenshot%202026-08-27%20at%204.44.44%E2%80%AFPM%201.png?alt=media&amp;token=7351a2dd-344b-4d10-b472-b00066113a3e" alt=""><figcaption></figcaption></figure>

* If you're building a rule about members and select Facility State, the results will be wrong in a way that's difficult to catch later. Hover the info icon next to a table name to learn more about that table before selecting.
* Search by table if you know it. If you already know which table holds the field you need, use the Search by table option instead of searching column names.
