General Visit (PT Boulder API)

Total rows: 101,785
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
18553 04cf5eab85f1f41a2a34d55048df9135c1cc5d5630bd0e2d6a2be7626fb710ce 68810ba9ea26da0783f38d3d 67ced3577abf9f3ed8fe8ded Michele Gerard Michele Gerard braindr2@aol.com 004536 47 2025-09-10 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. 24+ pt received conf of cancellation on 9/8, still showing up in system - RAR 9/10 Rosey Reed 2025-09-10 17:23:22 0.1 hrs 68810ba9ea26da0783f38d3c 000013997 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18552 2da5066a40c9cd37dfb7a6acf9366daec9f1391b158e94ac0d01acc5afeab9c9 68acccf9a88e2da1cb44e2d2 67ced3497abf9f3ed8fe88ac Berta Egan Berta Egan bertae999@gmail.com 004088 90 2025-09-10 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-10 17:21:22 -0.1 hrs 68acccf9a88e2da1cb44e2d1 000017469 3.00 80.00 60.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18551 793733a2608d66b03171cbda7c3a5034191ea623804dd0a00b2d52b4531515d7 68a391252db0500861e6d491 68a390322dac430785c21ed1 Serena Randolph Serena Randolph serena.randolph@gmail.com 017817 16 2025-09-10 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-08-19 20:15:37 -525.2 hrs 68a391252db0500861e6d48d 000016587 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18550 a919e76b0a6a374327b09ab72f7559a721656cfb9cb6d53a5e6145f0d37f2b3b 68791855d128f707b53abeec 67ced35a7abf9f3ed8fe8f01 Marilyn Fausset Marilyn Fausset mbrownfausset@comcast.net 004628 32 2025-09-10 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. surgery Laura Shove 2025-08-12 20:53:17 -692.6 hrs 68791855d128f707b53abeeb 000013317 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18549 6a036af913a9809aad2fc9dcb423a9db05914ae6581ad0eefbe750b936575bf9 68b6fd6712deb61370328589 67ced5cf7abf9f3ed8ff08d4 Robert Volckens Robert Volckens rob.volckens@gmail.com 015020 9 2025-09-10 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Patient - - Yes Elizabeth Cousins - Sophia L. 2025-09-10 17:39:51 -0.1 hrs 68b6fd6712deb61370328588 000018283 3.00 85.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18548 7d7830d4360035f0e06342074bd1d317bc639cd478011dc38de13fb9fcce1381 68a6308aaf93783b9d5d3b69 682750e4e1d78f96208ec404 Siri Cavanna Siri Cavanna siriloe2@gmail.com 017253 14 2025-09-10 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. pt conf cxl SL 9/10 Sophia L. 2025-09-10 16:12:17 -1.5 hrs 68a6308aaf93783b9d5d3b68 000016985 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18547 f19848d36e908c986b26ef0eba5dab572f90e7f8656b85e81b766a793954615e 688a8bb91609e8c26d61fa5b 688a8ac7029a895ed5235cac Sandra Steele Sandra Steele 1cufan@comcast.net 017726 6 2025-09-10 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-10-17 15:24:23 885.7 hrs 688a8bb91609e8c26d61fa56 000014871 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18546 65c2730a49b424d4673284190bcf2a7f3151f68d88d0645952dae46d6ae90a33 6883a5b8470e6173cace8033 686558bb1fc573aa62e2de35 Ashley Molner Hagan Ashley Molner Hagan ashleymolner303@gmail.com 017562 21 2025-09-10 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Ranjini Ridgway cxl SL 8/27 Sophia L. 2025-08-27 15:37:52 -338.4 hrs 6883a5b8470e6173cace8032 000014357 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18545 4f45ad48992c187353e6a6dbc030a6d757c2f308578b9ae5010aab4133084f70 68795f171d491707b99d2c68 67ced3da7abf9f3ed8feb331 Hamida Khanum Hamida Khanum hamida.khanum@ptofboulder.com 007716 70 2025-09-10 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Secondary - - Yes Stephanie Braun - Sophia L. 2025-09-10 18:26:23 0.4 hrs 68795f171d491707b99d2c67 000013429 3.00 81.40 64.85 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18544 ea16cdcaf09c328543f75e09e56ceedf5650c7e04532f80f362fab68780a50c8 688a83c037f5b45dcdd2aec9 67ced2fa7abf9f3ed8fe6667 Richard Bolen Richard Bolen rbolen@centurylink.net 001164 166 2025-09-10 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-10 19:07:25 0.9 hrs 688a83c037f5b45dcdd2aec2 000014854 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18543 c6f8ebce69facd645de8471b6e5762f567940fc3c0754144c39ab0e6b913bb18 68c04e2c43860c08b6526998 67ced33d7abf9f3ed8fe848b Anne Costain Anne Costain costain@colorado.edu 003736 24 2025-09-10 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-09-10 18:27:29 -0.0 hrs 68c04e2c43860c08b6526997 000019182 3.00 83.09 78.14 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18542 7cf1ca138408211e0d90ee732ed5b9baaf7c70264840d98e33b6681535d4f559 68a898c15cdf9b882ed02f64 686e9ea42f735407e832c269 Jiayin Wang Jiayin Wang janejiayin16@gmail.com 017597 21 2025-09-10 Checked Out 68535c6303dd08c79c018795 John Reed 67e84dd55868616a0a1bdc44 Kaiser Initial Evaluation OT/PT 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - Sonya C. 2025-09-10 18:09:51 -0.3 hrs 68f26b53ae502f08ad73930b 000017236 5.00 461.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18541 9f146aa3b46bab3b08993cb59e279d233af06fc54c63e3e728d5a801abb26adc 689f454f3e367f0849501405 67ced5797abf9f3ed8fefd02 Theresa Simmons-Smith Theresa Simmons-Smith smithtess444@aol.com 014012 102 2025-09-10 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-09-10 18:27:05 -0.0 hrs 6913c56c8d8eaeaa924a53f7 000016379 4.00 171.76 171.76 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18540 b11ca02aa15a2da0dcc775572f351b2bf70cc291d3c1cecfa46f70f78a1617e7 6892742984a794086c7a4986 689272e47f3e617ebd4cfbfe Bryce Miller Bryce Miller bryce@hatchboulder.com 017756 7 2025-09-10 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-10-21 21:34:11 987.1 hrs 6892742984a794086c7a4981 000015442 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18539 49b49c736b5f0f663c09b0c01759fc6d5c56f6a692c2c0237a20b8c9a003a4fe 6887bb3ab91e65374119de16 67ced5a37abf9f3ed8ff02d8 Aaron Stoddard Aaron Stoddard builderaaron@hotmail.com 014510 125 2025-09-10 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. eval after surgery Samantha Saunders 2025-09-08 19:29:15 -47.0 hrs 6887bb3ab91e65374119de0e 000014491 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18538 a294892aee9e8aeefb57e597bdf6265b83ec25f404e7bcc771bebb6041d7a9eb 687a9a1a3a9f4f0880d48a64 67ced30a7abf9f3ed8fe6f49 Eiko Arentzen Eiko Arentzen eiko.arentzen@gmail.com 001922 131 2025-09-10 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-09-09 23:36:30 -18.9 hrs 687a9a1a3a9f4f0880d48a5c 000013574 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18537 853945f39e2caf09ed820348dddcc413175a29609fba8a72f6c929c9a4bc8b05 687829f803b376078293f783 67f9602ca72fbb50374a4725 Renee Hopper Renee Hopper reneehopper@outlook.com 017038 20 2025-09-10 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Anne Palma 2025-09-11 19:00:35 24.5 hrs 687829f803b376078293f782 000013286 4.00 85.00 85.02 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18536 e5d244044db0f9e27ef96578e60e3d0eddcabdeacf146002afdee1a9028fea7a 6851d2e5495c400822a4e765 67ced3017abf9f3ed8fe6acc Patricia Bosak Patricia Bosak tbosak1018@aol.com 001539 168 2025-09-10 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Gillian B. - Rosey Reed 2025-09-10 18:28:08 -0.0 hrs 6851d2e5495c400822a4e761 000009661 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18535 aa65aa63ee2b1725c8519faeaf9c9fb3a38469a101cd74e51b0c69302c1d9bc3 6876c1cbaa89e207bcffa4ac 67ced5177abf9f3ed8feee3c Stephen Roman Stephen Roman sa3roman@gmail.com 012752 48 2025-09-10 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Anne Palma 2025-09-11 16:21:22 21.6 hrs 6876c1cbaa89e207bcffa4ab 000013100 5.00 95.45 95.45 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18534 249a83beecd42f01270ac1ec893e7ad19393ae63c7d4a4d4a6caec0f75d8f288 68b1daab65022149ab0db601 68b1da9f777428f3f33f0405 Hannah Ardner Hannah Ardner hannah.ardner@gmail.com 019780 15 2025-09-10 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sophia L. - Sophia L. 2025-09-10 19:46:49 0.8 hrs 68b1daab65022149ab0db600 000018191 3.00 70.36 38.36 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18533 fdb16b61c3119a1642555db089e80f170601b413414572162d0a7b81064fb9b9 68a4d303482471cb585f09ef 68a4d1cbb7a2ac08140d2bce Chelsea Hackett Chelsea Hackett chelsea.hackett@gmail.com 017825 16 2025-09-10 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. nln AM 24+ Anne Majewski 2025-08-29 19:13:09 -287.8 hrs 68a4d303482471cb585f09ee 000016749 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18532 0742ede67d9a4b9f0d1e14157910f09f8024e2ddc3d657f32ac3ebfcf1ef31b2 689d04488efd4b1a82a21aa1 68715c28bd72dd080830c7a6 Carol McCool Carol McCool mccool23@gmail.com 017612 8 2025-09-10 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Maia H. 2025-09-03 18:01:03 -169.0 hrs 689d04488efd4b1a82a21aa0 000016219 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18531 7aeb4d103306460459cc68db6cd9b8378099537d383631a38b63d416fab1c4cb 6887f78e03d9f1079f5da421 6887f54841dc4a3f61f0bab7 Charles Rhoades Charles Rhoades srhoades@stonecroftcapital.com 017715 7 2025-09-10 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. Pt conflict Samantha Saunders 2025-09-10 14:10:47 -4.8 hrs 6887f78e03d9f1079f5da420 000014554 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18530 77a306ebc042f3636b825894b36f4a22a9f71fd88c8e25cf7f1bd185360cc724 68713e48bf71e50794b55d7a 67ced30a7abf9f3ed8fe6f70 Adam Chavez Adam Chavez adamjchavez@gmail.com 001935 67 2025-09-10 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-22 22:03:16 1011.1 hrs 68713e48bf71e50794b55d79 000012629 2.00 85.00 85.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42
18529 9974c72ed94552b54e018d338712023175f5a326f43e19d28f73096bb85efa7c 681cd0bb34703907b4e13a99 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-09-10 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Ranjini Ridgway - Gillian B. 2025-06-16 14:46:41 -2068.2 hrs 681cd0bb34703907b4e13a73 000004802 7.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:54 2026-05-14 23:40:42