1. Database Views
  2. Create View

Custom View Creator Widget

Create your own custom views by combining information from different tables.

  • 1 Select Tables
  • 2 Choose Fields
  • 3 Define Joins
  • 3 Preview
Patients Standard Master list of all individuals receiving care, including demographics and identifiers.
Appointments Standard Scheduled visits and time slots for patients across various services.
Diagnostic Reports Standard Results and interpretations from lab tests, imaging, and other diagnostics.
Claims Standard Billing records submitted to payers for reimbursement of medical services.
Encounters Standard Documented clinical interactions between providers and patients during care delivery.

Rosters - BCBS Custom

Monthly enrollment data from Blue Cross Blue Shield showing patients attributed to your practice under BCBS plans.

Rosters - Humana Custom

Monthly enrollment data from Humana showing patients attributed to your practice under Humana plans.

Patients

Patient ID Primary Key

First Name
Last Name
Date of Birth
Sex
Address
City
State
Zip Code
Phone Number
Email
Insurance Plan Number
Insurance Group Number
Primary Care Provider
Next Appointment Date

Rosters - BCBS Custom Dataset

Member ID Primary Key

Roster Month

Member First Name
Member Last Name
Medicare ID
Date of Birth
Sex
Address
City
State
Zip Code
Phone Number
Primary Care Provider
Plan Start Date
Plan End Date
PCP Begin Date
PCP End Date
Left Table
Left Table Column
Join Type
Right Table
Right Table Column
Roster - BCBS Roster - BCBS Roster - BCBS Roster - BCBS Patients Patients Patients Roster - BCBS Roster - BCBS
06/2025 Maria Smith UVYP78AGVDJ PT6883 Dr. Alan Thomas 06/10/2025 12/03/2024 07/10/2022
06/2025 Maria Smith UVYP78AGVDJ PT6883 Dr. Thomas 06/10/2025 12/03/2024 07/10/2022
06/2025 James Lopez 5NX607MUH9G PT3472 Dr. Lee 06/20/2025 02/23/2024 12/20/2023
06/2025 John Smith 4DQG1UWAGVY PT4807 Dr. Patel 06/14/2025 06/06/2024 03/06/2024
06/2025 Sophia Lopez 8CVX0DCKHPJ PT7557 Dr. Patel 06/20/2025 11/29/2023 06/04/2023
06/2025 Aisha Johnson 5CNDWY4D6D2 PT3474 Dr. Nguyen 06/14/2025 11/18/2024 10/11/2022
06/2025 Emily Brown G5HWDQJX92A PT6109 Dr. Adams 06/12/2025 10/15/2023 08/22/2022
06/2025 Carlos Hernandez 18A7DQXFUKT PT2381 Dr. Lee 06/13/2025 01/10/2024 04/01/2023
06/2025 Liam Davis A39DCQUKF2L PT5417 Dr. Thomas 06/13/2025 03/17/2024 01/05/2022
06/2025 David Clark 7F4NQJXPYVD PT8392 Dr. Patel 06/11/2025 07/01/2023 09/30/2022
06/2025 Olivia Miller JF62DQNR8LY PT7255 Dr. Nguyen 06/12/2025 08/14/2024 05/02/2023

Custom View Created Successfully

Go Back to Views