General Visit (PT Boulder API)

Total rows: 104,153
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
26705 b8666fd7337c6bc5373f2d4b1a980b89e76a0cf98a62f5e63b1232af50641868 6851d71e2cd2aa07591af039 67ced4157abf9f3ed8fec00c Helena Mandelman Helena Mandelman helena.beem@gmail.com 008812 17 2025-07-07 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-07-07 21:58:07 5.2 hrs 686c43076e5a7473936da450 000009666 4.00 68.42 68.42 - - - - - - - - 2026-02-19 23:38:11 2026-06-12 00:04:17
26704 31a7c0258315bc4cce4a7cbe2d4956d45eb638be1c2ffc710b73ba00534c71f7 68504590c7f0e6f784e42605 67ced4157abf9f3ed8fec00c Helena Mandelman Helena Mandelman helena.beem@gmail.com 008812 17 2025-07-07 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-06-17 21:02:02 -475.7 hrs 68504590c7f0e6f784e42600 000009439 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:38:11 2026-06-12 00:04:17
26703 321db539962678f815784d0f55cb1c3d3440e49e02a1f9bc8ce9d2eb06edb023 682b72d175b13d086af97c75 67ced4607abf9f3ed8fecede Alice Loveday Alice Loveday ajoyce5491@yahoo.com 010076 160 2025-07-07 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Gillian B. - Maia H. 2025-06-20 18:18:58 -406.4 hrs 682b72d175b13d086af97c74 000006094 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:38:11 2026-06-12 00:04:17
26702 bd8fbbb300f07fe4cb2c7891fcbf5d191c2be92ab5abf361eb8ed91257520643 6849aa4438c651087c9c64d4 67ced36d7abf9f3ed8fe9564 Sean Fitzgerald Sean Fitzgerald sean.fitzgerald@colorado.edu 005173 37 2025-07-07 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Maia H. - Eva Tucker 2025-07-07 16:55:54 -0.1 hrs 6849aa4438c651087c9c64d3 000008988 3.00 80.00 112.00 - - - - - - - - 2026-02-19 23:38:11 2026-06-12 00:04:17
26701 3f12af6c24d54c2ec1c3c6c64dad594b36be8192e5f279ec29f660c97e3be16e 682cad7713b92b50a6e854ad 682cac0bbd74b0078dac4e15 Heidi Young Heidi Young heidi.e.young@gmail.com 017268 13 2025-07-07 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. She needs Friday appts. - sc Sonya C. 2025-07-03 16:17:20 -96.7 hrs 682cad7713b92b50a6e854a9 000006235 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:38:11 2026-06-12 00:04:17
26700 d26758b614b7b24e3a8f63f54fc85a6a46686ea3a9851fa3f86bbd3a152004b2 68264ff680900c07c0d93cbd 67e6659aefbf2c53d8d5e7d9 Melissa Klausing Melissa Klausing melissateresafred@yahoo.com 016836 12 2025-07-07 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Maia H. - Elizabeth Cousins 2025-07-07 20:09:23 3.2 hrs 68264ff680900c07c0d93cbc 000005827 1.00 130.00 130.00 - - - - - - - - 2026-02-19 23:38:11 2026-06-12 00:04:17
26699 eb7c102160f22d112d99b0e2f2019df24aff20c1ad12524ab1814fcbac4a73d3 682369c58dab8e416ec47c5c 67ec5862d7360808195cb100 Gary Xander Gary Xander garyx2@comcast.net 016954 10 2025-07-07 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-06-03 17:04:49 -815.9 hrs 682369c58dab8e416ec47c57 000005343 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:38:11 2026-06-12 00:04:17
26698 5f60cee63f1acc52b38470944d5bbcb2dc62b64abf35af99fe152704b45dced8 681a342afa0aac774fe01081 67ced4667abf9f3ed8fed01c Pam Lowy Pam Lowy pamlowy@yahoo.com 010182 7 2025-07-07 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a679a3294b1b37ef18c48c AIM AUTH NEEDED - GET OUTCOME 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. - Michelle W. 2025-06-11 16:20:51 -624.7 hrs 681a342afa0aac774fe01080 000004413 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:38:11 2026-06-12 00:04:17
26697 daa83bedcdf3028d9953c27ce81fd6235845131e7189ccfa958b8d356e4c7293 6849b089c8a53a0775d93ca5 67ced6267abf9f3ed8ff1434 Mary White Mary White bolles1@comcast.net 015990 50 2025-07-07 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-07-07 17:16:18 0.0 hrs 6849b089c8a53a0775d93ca4 000008998 5.00 154.16 154.16 - - - - - - - - 2026-02-19 23:38:11 2026-06-12 00:04:17
26696 5e42142ee54e9c6bd9c6901d1f27e953a82710fe538c5a88b68d7c2f0303ce16 68489a70f839a307c1be2877 68489a57f839a307c1be27be Rita McCurry Rita McCurry mccurryrita@gmail.com 017434 18 2025-07-07 Checked Out 67c8f28f945598c08d4245c7 John Phinney 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-07-07 16:53:24 -0.4 hrs 686d17fd1fec0b6e3dc54c46 000008932 4.00 171.76 171.76 - - - - - - - - 2026-02-19 23:38:11 2026-06-12 00:04:17
26695 9f3c79a0b9873fb7c77c31c6fe81f570c18a50d9389adac3b132cfb64f38dd34 68475316871ca6080766afce 67ced34f7abf9f3ed8fe8b1a Barry Erdman Barry Erdman barry.erdman@gmail.com 004295 5 2025-07-07 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Gillian B. - Gillian B. 2025-06-30 20:58:31 -164.3 hrs 68475316871ca6080766afcd 000008788 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:38:11 2026-06-12 00:04:17
26694 208a141271373dc9872babed975436c540863a6ac6a052e1dd746257aea0610b 68378242fe5d6b0777689874 68016e69d0c68a9aee96256f Anne Slichter Anne Slichter aslichter@gmail.com 017081 23 2025-07-07 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Ranjini Ridgway 2025-07-07 23:51:10 6.6 hrs 686c5d83adde6d27f6113f63 000007329 3.00 80.29 80.29 - - - - - - - - 2026-02-19 23:38:10 2026-06-12 00:04:17
26693 0509a6f0c5b7fbddc8a167c45b853bb5cee977204102cfe7d55fd1bc05e66046 682f8e9e5730c041a343732d 682f8c11ed4091089c68f148 Christopher Roberts Christopher Roberts crayroberts@lpbroadband.net 017295 9 2025-07-07 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-10-02 15:39:23 2086.4 hrs 682f8e9e5730c041a3437329 000006682 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:38:10 2026-06-12 00:04:17
26692 4d6e5016f8d4ad19b214f1c3837ce52d83756ba4cfdf35c6230f8650237b3e54 682627fb1b5104085b0596d9 67ced6137abf9f3ed8ff119f Stephen Tilson Stephen Tilson srtilson@gmail.com 015770 6 2025-07-07 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sonya C. - Allison Reyes 2025-06-05 17:22:56 -767.9 hrs 682627fb1b5104085b0596d7 000005771 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:38:10 2026-06-12 00:04:17
26691 3150fae94d87453cc4b18d5280b138c890ade90a9d2667e705ab3837ecba12a9 680948ac3ff4f964ec27c83a 67ced60e7abf9f3ed8ff1112 Sally Thorner Sally Thorner sally.thorner@gmail.com 015723 85 2025-07-07 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. Car not working 24+ Elizabeth Cousins 2025-07-06 19:36:08 -21.6 hrs 680948ac3ff4f964ec27c839 000003283 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:38:10 2026-06-12 00:04:17
26690 8db6917a7ff0749f828fbf8286249a43c83c9166acb7a1a3f208fb89ee00136a 684b2c6ac1f89e0826cc1634 67ced3267abf9f3ed8fe7b2b Aileen Balasalle Aileen Balasalle aileen.balasalle@gmail.com 002936 37 2025-07-07 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 7/2 Sophia L. 2025-07-02 17:29:52 -120.0 hrs 684b2c6ac1f89e0826cc1633 000009182 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:38:10 2026-06-12 00:04:17
26689 fc6eaa6ef419b9870122ab904f5dfb07c5f773ecb03691bd2ae124c8b32c2197 681b9e77e55b6007b0e195bf 67ced6507abf9f3ed8ff196c Helen Yambert Helen Yambert helen.triller@att.net 016435 52 2025-07-07 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Elizabeth Cousins 2025-07-07 20:09:47 2.4 hrs 681b9e77e55b6007b0e195be 000004643 3.00 60.00 60.00 - - - - - - - - 2026-02-19 23:38:10 2026-06-12 00:04:17
26688 848e794bbe517279115542317357c282ac5e0cc9c7740b51910004a2f594e3a8 684066f7ea79c407d2a49ddb 67ced5877abf9f3ed8fefef7 Yogesh Vaidya Yogesh Vaidya yogesh.stg@gmail.com 014179 61 2025-07-07 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Elizabeth Cousins - Ranjini Ridgway 2025-07-07 18:00:13 0.0 hrs 684066f7ea79c407d2a49dda 000008111 2.00 47.40 47.40 - - - - - - - - 2026-02-19 23:38:10 2026-06-12 00:04:17
26687 d163975b452b911c28e8bb54fdb19967f1721d6021bfaa67313c44357fc4f27d 684b3f7cc96d4e0773bf0918 67ced2e97abf9f3ed8fe5a7f Susan Benson Susan Benson susan.benson52@yahoo.com 000148 116 2025-07-07 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-07 18:08:50 -0.1 hrs 684b3f7cc96d4e0773bf0910 000009198 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:38:10 2026-06-12 00:04:17
26686 8a78b4ad90c674dc30cc84ce25e594e24632e994417531b203fbd85ecc3d58e4 682748e9ceddb607fc86b9be 682747e77e4dce07d584ea87 Robert Shapiro Robert Shapiro robertlshapiro@gmail.com 017252 26 2025-07-07 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Maia H. duplicate with Emily Emily Pickner 2025-06-12 13:05:18 -605.2 hrs 682748e9ceddb607fc86b9bd 000005915 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:38:10 2026-06-12 00:04:17
26685 add74661c65abaa07eca834061d5564ce7c7d40ca366ab29db383ad6ee57cbce 686bdd2acac57e07a9d97446 686bdc662237934714373a11 Darryl Hobson Darryl Hobson darryl@ihcclinic.com 017575 39 2025-07-07 Cancel 68535c6303dd08c79c018795 John Reed 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-07-07 23:07:18 4.6 hrs 686bdd2acac57e07a9d97445 000011872 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:38:10 2026-06-12 00:04:17
26684 c3503f79926f73c94af226ee0a0f0bd5acd98ce277f2a06e0f9a848e923593e5 685dab2a4f802f08314fb173 67ea9760128d6a27c05dd70a Kerrie Lessway Kerrie Lessway klessway91@gmail.com 016917 15 2025-07-07 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Maia H. 11:45am Carrie L apt at 12:30am, does need to cxl, does realize there is a fee. Please call back 303.842.1137 Ranjini Ridgway 2025-07-07 18:40:50 0.2 hrs 685dab2a4f802f08314fb172 000010988 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:38:10 2026-06-12 00:04:17
26683 28bf3b9c96bd3d8ef06d52a0a472ef43b8ca8e85bb7f916fe3e67d78099ec0e5 684b01dad57de2080d111542 684b00b6063afe0857096e53 Kyle Wofford Kyle Wofford kylecwofford@gmail.com 017440 12 2025-07-07 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-07-07 18:38:08 0.1 hrs 686eb84590c3abec32a0e674 000009130 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:38:10 2026-06-12 00:04:17
26682 b5f28ed7b7fb0ddd7c811c69139ed9bb1e4b16853392050bf3ecac88cde7c798 6849b075188c4cc2f1fc18d3 67ced4907abf9f3ed8fed7ab Susan Nazarenus Susan Nazarenus nazarenus@comcast.net 010827 25 2025-07-07 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Ranjini Ridgway 2025-07-07 18:38:04 0.1 hrs 6849b075188c4cc2f1fc18d2 000008997 3.00 85.26 85.26 - - - - - - - - 2026-02-19 23:38:10 2026-06-12 00:04:17
26681 3d5bfa531bfa0af88e4e8bdff9a4048e3966c11c30d1236c598163c04c3defbe 68430604dc4e270887f37b64 67ed6ad0ebea6c0850ecd806 Ruth Parker Ruth Parker ruthrmchp5@gmail.com 016963 14 2025-07-07 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Maia H. - Sonya C. 2025-07-07 18:29:40 -0.0 hrs 68430604dc4e270887f37b63 000008528 3.00 80.26 80.26 - - - - - - - - 2026-02-19 23:38:10 2026-06-12 00:04:17