Appointments | Prime Medical Center


7834021	JS John Smith	Jun 26, 2025	09:00 AM	Confirmed	Eligible	EC Dr. Emily Carter
1943820	Rachel Green	Jun 26, 2025	10:30 AM	Not Confirmed	Eligible	AH Dr. Alan Hughes
5021139	CM Carlos Mendoza	Jun 26, 2025	11:15 AM	Confirmed	Eligible	PN Dr. Priya Nair
8672455	ML Mei Lin	Jun 26, 2025	01:00 PM	Confirmed	Eligible	EC Dr. Emily Carter
8921034	John Smith	Jun 26, 2025	08:30 AM	Confirmed	Ineligible	SK Dr. Sarah Kim
9903823	AR Aisha Robinson	Jun 26, 2025	03:15 PM	Not Confirmed	Eligible	AH Dr. Alan Hughes
1170934	MC Michael Chen	Jun 26, 2025	04:00 PM	Confirmed	Ineligible	EC Dr. Emily Carter
6457209	Julia Santos	Jun 27, 2025	09:30 AM	Confirmed	Eligible	PN Dr. Priya Nair
2087310	AH Amir Hassan	Jun 27, 2025	10:45 AM	Not Confirmed	Eligible	SK Dr. Sarah Kim
9326017	Olivia Turner	Jun 27, 2025	01:30 PM	Confirmed	Eligible	EC Dr. Emily Carter

Activity

07:45 AM

Synced 3 tables from Epic

patients (4,322 records), Appointments (9,451 records), Claims (6,245 records)

07:50 AM

Ran workflow: Eligibility Check Bot

Verified insurance for 1,120 patients

07:58 AM

Uploaded file to Referrals Upload

referrals_batch_may.csv (1,120 rows)

08:00 AM

Mapped fields from referrals_batch_may.csv

Linked to FHIR resource: ReferralRequest

08:10 AM

Created dashboard: Daily Operational Metrics

Included KPIs: No-show %, Claims volume, Avg. wait time

08:15 AM

Executed No-Show Follow-Up Bot

Flagged 14 missed appointments for automated contact

08:22 AM

Synced lab results from Quest Diagnostics

489 new lab reports processed for 312 patients

08:30 AM

Triggered automated patient transportation

Scheduled 23 Uber Health rides for today’s discharges

08:38 AM

Processed 789 claims from AthenaHealth

Matched to visits and payer eligibility files

08:50 AM

Scheduled report: Weekly Claims Summary

Deliver every Monday at 6:00 AM to billing@prime-health.com

Filters

Appointment Date

Start Date

End Date

Locations

Providers

Appointment Type

Status

Booked Checked Out Billed Cancelled Open Stale Checked In

Topics

Inbox Activity React Files

Recent

Users

Events Tomorrow

Files

to close

to select

to navigate

Activity

James Collins

Added 2 files to task PR-3

list-of-users

35kb

list-of-users

30kb

May 04

B

Bob Dean

Marked PR-6 as Completed

Today

Crane

Added 5 card to Payments

+2

Project status updated

Marked PR-3 as In progress

Feb 10

Mark Colbert

Earned a "Top endorsed" badge

Apr 06

D

David Lidell

Added a new member to Preline

May 15

Lana Robinson

Added 2 files to task PR-7

weekly-reports.xls

4kb

monthly-reports.xls

12kb

Now

Cmd + K

Formatting

Bold
Ctrl + b
Italic
Ctrl + i
Underline
Ctrl + u
Strikethrough
Ctrl + Alt + u
Small text
Ctrl + s

Insert

Mention person (@Brian)
@
Link to doc (+Meeting notes)
+
#hashtag
#hashtag
Date
/date Space
Time
/date Space
Note box
/note red Enter

Add team account

Team name

Subscription plan

Import contacts

Gmail account

Import your Gmail account contacts.

Notion

Add your contacts to a Notion file and upload it here.

Word file Add your contacts to a Word file and upload it here.

Upload file

Drop your files here or browse

CSV, XLS, DOCX

View Appointment Details

Appointment ID

Patient

Date

Time

Provider

Department

Status

Appointment Type

Reason

Contact Number

Edit user

Avatar

Name

Email

Phone

Address

AI Search

How can I help?
You can ask questions like:
- Show me all appointments scheduled for next week at the Citadel location
- Show me all cancelled appointments from the last 30 days
- Show me appointments with no-show status for Dr. Smith this month
Show me all appointments for next week where insurance status is 'ineligible'
Absolutely. I've generated a filtered view for you that includes:
- Appointments where insurance eligibility status has failed verification
- Includes patient information and appointment details for follow-up
- Sorted by most recent appointments first to prioritize urgent cases
- Shows all appointments regardless of location or provider for comprehensive review
You can view the dataset by clicking on the link below:
- View: Appointments with Failed Insurance Eligibility Status
SQL Logic Used

SQL

SELECT appointments.id, appointments.patient_id, appointments.date, appointments.time, appointments.location, appointments.status, appointments.eligibility_status, appointments.provider_name, appointments.appointment_type, patients.first_name, patients.last_name, patients.phone_number, patients.email, insurance.plan_name, insurance.member_id, insurance.group_number FROM appointments JOIN patients ON appointments.patient_id = patients.id LEFT JOIN insurance ON patients.insurance_id = insurance.id WHERE appointments.eligibility_status = 'failed' OR insurance.id IS NULL ORDER BY appointments.date DESC, appointments.time DESC;