General Visit (PT Boulder API)

Total rows: 99,414
id row_key pte_visit_id pte_patient_id patient_full_name patient_first_name patient_last_name patient_email patient_code patient_total_appointment_visit date_of_service appointment_status provider_id provider_name service_id service_name location_id location_name invoice_status invoice_number current_responsibility package_invoice_number package_invoice_name claim_created_info created_by reason last_update_by last_update_date cancellation_notice treatment_note_id treatment_note_number units charges payments summary_total_appointments summary_total_charges summary_total_payments summary_total_units summary_total_patients summary_average_charges summary_average_payments summary_average_units created_at updated_at
356 58396826312f64b489a7fd1634293209bcd4df2f5ccd3144b1d0eba64be04495 696a7b3cfcb28a9a5cca9a56 67ed93364921cf049b750726 Colleen Dufresne Colleen Dufresne colleendufresneco@gmail.com 016966 60 2026-02-18 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Renee Carr - Sonya C. 2026-02-18 15:27:05 0.5 hrs 696a7b3cfcb28a9a5cca9a55 000034005 3.00 80.56 80.56 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
355 53c0b5df4e68475be42136f1fbc3f854ed37acfea74132e9af7613b49748dc55 695ff6e84302f991aaf3cdc2 695ff5acf879d6ab89350215 Melanie Arato Melanie Arato melaniearato@gmail.com 020476 7 2026-02-18 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt is feeling better Michelle W. 2026-01-26 17:09:32 -549.8 hrs 695ff6e84302f991aaf3cdbe 000033063 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
354 e01bce56c84c19e15db754e9baec88774093fe110769be5423e9ee6f29d8ac17 69249bf979302696103ede15 67ced6507abf9f3ed8ff1975 Julie Yang Julie Yang julie.yang@ptofboulder.com 016438 47 2026-02-18 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Sonya C. 2026-02-18 16:55:18 1.9 hrs 69249bf979302696103ede11 000028199 3.00 85.12 85.12 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
353 8482168214a29ea972e5bfb1db8aa7bf0f4cc63cacca829f180b42e9abaa9376 68f8e859a1d87f0a26a53415 67ced3577abf9f3ed8fe8ded Michele Gerard Michele Gerard braindr2@aol.com 004536 47 2026-02-18 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. not needed Laura Shove 2026-01-14 15:38:56 -839.4 hrs 68f8e859a1d87f0a26a5340f 000024346 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
352 e574b4d02ab377cac7d8ac213729e239bd778fb0214f0a711f29f207c6b7c369 695569ead35b3261f3701d12 67ced3487abf9f3ed8fe88a6 Anne Edwards-Turnacliff Anne Edwards-Turnacliff turnacliff@comcast.net 004086 100 2026-02-18 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24+ appt not approved by ins Michelle W. 2026-02-17 16:47:40 -22.5 hrs 695569ead35b3261f3701d11 000032216 3.00 0.00 0.00 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
351 2bf4351464c94f13c19c6493fa42188c9b38dd2037c78d2580fe8ede32ac42a0 698b513a3b1220d63151e56d 698b50b03b1220d63151c5c5 Mario Morency Mario Morency mariomorency@gmail.com 020717 6 2026-02-18 Checked Out 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Mark Jerome Para-ase 2026-03-04 23:14:03 343.7 hrs 698b513a3b1220d63151e56c 000037088 4.00 82.00 82.00 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
350 177cd987dbf0a2fa8c13d3a39cb75980d49e5116421da28044ae81ab844f30d8 69812c59ce177a3ebbfcb9e1 67ced31a7abf9f3ed8fe773e Dejanka Dejanovic Dejanka Dejanovic deyadej27feb118@gmail.com 002601 62 2026-02-18 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Secondary - - Yes Sophia L. - Sophia L. 2026-02-18 15:53:47 0.4 hrs 69812c59ce177a3ebbfcb9e0 000036317 2.00 60.00 20.00 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
349 ffb2a5f6f017e763c31ac6372787e15e81fbdbf3b8108ca662c2adb2f1f719f9 69811ce6161ac7050f712122 696fa431bfc63af4bd16cb83 Cassie Powell Cassie Powell cassie.michaelp@gmail.com 020583 11 2026-02-18 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Michelle W. - Mark Jerome Para-ase 2026-03-10 22:09:09 486.7 hrs 69811ce6161ac7050f712121 000036287 3.00 80.00 80.00 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
348 284d4a23be81cf8344a2bc1d05d251620892da8367ccb07faa095301ca28e269 697a36a2b3ee243cf6280d62 697a3594647cd21e465f9005 Alyssa Mriscin Alyssa Mriscin amriscin@icloud.com 020646 9 2026-02-18 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Laura Sage - Mark Jerome Para-ase 2026-02-19 20:37:05 29.1 hrs 697a36a2b3ee243cf6280d5d 000035677 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
347 764f8cd43e37b0d9ec7f670b79cfe1c496768750e27f2fd7272acc59e128a7f5 695d9b0fe276777a0ac7ccdc 695d9a1be276777a0ac7bcd5 Ashley McGillivray Ashley McGillivray ashleymcgillivray12@gmail.com 020468 17 2026-02-18 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Renee Carr Sami out sick - sc Sonya C. 2026-02-18 15:27:46 -0.0 hrs 695d9b0fe276777a0ac7ccdb 000032829 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
346 ae8b84ceeec57d256e6f9b5a033112834fbee5506ebb88be9ff371a77d25cc83 69496cbe7f7dd7dacf863804 67ced3d37abf9f3ed8feb184 Christine Kemp Christine Kemp christywkemp@gmail.com 007573 135 2026-02-18 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Renee Carr - Mark Jerome Para-ase 2026-02-19 21:30:08 30.0 hrs 69978125de42d103630e0bb4 000031455 4.00 90.94 90.94 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
345 aa4d91d01875bb9e72d8ed35985acd9811c1b067847daaeb14f6804b0fa38f58 6939aa2bf3564a07bfa64cd4 67ced6267abf9f3ed8ff1434 Mary White Mary White bolles1@comcast.net 015990 50 2026-02-18 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Sonya C. 2026-02-18 15:31:19 0.0 hrs 6939aa2bf3564a07bfa64cd3 000030316 3.00 82.36 82.36 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
344 21456c6f59d07a465193706a1d845201f0effa03abb10a6c94b55043a8c99d76 693215851c1b2af793882d22 693214ee941dc3fa1efcd1b8 Melissa Werner Melissa Werner mwernerboulder@gmail.com 020337 5 2026-02-18 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ Patient found an office that could see her asap. -RC Renee Carr 2025-12-29 21:16:57 -1218.2 hrs 693215851c1b2af793882d21 000029743 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
343 78e2801b3f6f62675f3a1cce15af84e312bb9636e061d770ca18b5cdde2332ed 6967d8594974f67144186b88 6966922c721a458e35c08f0b Ann Humble Ann Humble awhumble@msn.com 020502 6 2026-02-18 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Laura Sage - Laura Sage 2026-02-18 15:44:42 -0.0 hrs 6967d8594974f67144186b87 000033664 3.00 85.12 85.12 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
342 54f53d13ddf530455534d61140445a5482de353528b5ac445133eff9a7e3cd16 69651edab7104aef3f6d4e38 67ced57b7abf9f3ed8fefd50 Robert Ukeiley Robert Ukeiley rukeiley@biologicaldiversity.org 014038 28 2026-02-18 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Mark Jerome Para-ase 2026-02-19 16:20:06 24.6 hrs 69651edab7104aef3f6d4e37 000033273 4.00 95.00 95.00 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
341 f70ae191ea748c23b68987fc1e5260678b1925ecb4b8076d1120c55354e718b7 691632212cfc546a56aa331f 67ced4207abf9f3ed8fec255 Mark Lewis Mark Lewis mark@markpix.com 009007 235 2026-02-18 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Rosey Reed - Sonya C. 2026-02-18 15:30:26 -0.2 hrs 691632212cfc546a56aa331c 000027166 3.00 85.00 72.25 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
340 043e4d3b69572ed743198973901ae7d046335db061b22b7af3305a32fb6d2b40 698d080d7b1499b377a0165e 67ced4947abf9f3ed8fed86b Regina Meadows Regina Meadows gpioneerwoman2014@gmail.com 010891 23 2026-02-18 Checked Out 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sonya C. - Mark Jerome Para-ase 2026-02-24 20:40:14 148.7 hrs 698d080d7b1499b377a0165d 000037356 3.00 237.00 35.00 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
339 7f19957b303206cdce5195d6509ecb8c96652fb22b5d71e6cafd2c2301e72022 6983785d63c94189aaa36e33 68017885831990d97bdb1b73 James Lewis James Lewis jimlewis8128@gmail.com 017083 57 2026-02-18 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sonya C. 2026-02-18 16:01:46 0.0 hrs 6983785d63c94189aaa36e32 000036515 4.00 79.00 79.00 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
338 01b6fde9de828940bbc86c62666e77dbbb76f8027302439a08e3efbd634d0c39 69836e49bbdb518afae5d5de 684c77d17f968c69509f1b91 Chris Tanner Chris Tanner chris2249@gmail.com 017446 25 2026-02-18 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes John Phinney - John Phinney 2026-02-18 16:02:13 0.0 hrs 69836e49bbdb518afae5d5dd 000036504 3.00 83.38 83.38 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
337 fcc077ae33d543d2126b61740c22f7104cf5a6ee65f2704ab07a3a5df66d9b21 697a56eb8d0f2d86cc5e651d 696fc7950aa6c393a758c48c Richard Brummer Richard Brummer atlr9138@gmail.com 020588 15 2026-02-18 Cancel 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ scheduling conflict Michelle W. 2026-01-28 19:39:12 -500.3 hrs 697a56eb8d0f2d86cc5e6519 000035733 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
336 71fc3c84a6999b3fc8815f5c59ce78beea06cf7db55750a09917b0da012647d1 69729920027d57ab75c0a675 67ced3fe7abf9f3ed8febb36 Marcia Larson Marcia Larson larson4045@gmail.com 008400 52 2026-02-18 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Elizabeth Cousins - Michelle W. 2026-02-18 15:56:48 -0.1 hrs 699cb13c40ee00c16f0840c8 000034954 3.00 82.36 82.36 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
335 8fa9f9145719b443850b0bfc04570b8372764ba0afd2c0a0de56c293dd27b08a 6970fc144301c7eb69fc84b7 694b07a4a76ff39ba6f026c8 Chris Gray Chris Gray jchrisgray@mac.com 020416 7 2026-02-18 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Samantha Saunders pt conf cxl sami sick SL 2/18 Sophia L. 2026-02-18 15:31:02 -0.5 hrs 6970fc144301c7eb69fc84b6 000034623 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
334 9593b3dc7136733a3a19ff2ca5354c6bbb66f31046f65d811a373c3336875b7b 6970fbf15b04e847560e364f 67ced37a7abf9f3ed8fe9972 Chris Gray Chris Gray chris.a.gray13@gmail.com 005519 1 2026-02-18 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Samantha Saunders wrong pt Samantha Saunders 2026-01-21 16:17:09 -671.7 hrs 6970fbf15b04e847560e364e 000034622 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
333 ca62a3d0971db82b798a0e3bdb45db8a73896f01459b0381cc5377f2dacfa218 69611900dcd48dbe9cc9c9ca 67ced4d87abf9f3ed8fee421 Richard Przywitowski Richard Przywitowski dick_lois@comcast.net 011890 83 2026-02-18 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Laura Sage 2026-02-18 15:55:53 -0.1 hrs 69611900dcd48dbe9cc9c9c9 000033139 3.00 82.42 82.42 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06
332 65342e4a553ed6b4e95a72d00b8b12f19e49074649a95ae6e4311629228d7a1f 69272eab1875efcd0827fde6 67ced4637abf9f3ed8fecf83 Karla McClure Karla McClure mkmcclure@gmail.com 010131 54 2026-02-18 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Jerome Para-ase 2026-02-19 16:53:03 24.9 hrs 69272eab1875efcd0827fde4 000028970 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:25:43 2026-04-26 22:49:06