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
93541 f3d7703e3fb6b020154a91db04f9d5c1573707287415bcd05f99b8a3c85fc04f 692618b6a180d124eebd633d 67ced3357abf9f3ed8fe813a Michael Divjak Michael Divjak keschmeyer@yahoo.com 003453 459 2026-03-05 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-11-25 21:41:27 -2398.8 hrs 692618b6a180d124eebd6315 000028782 0.00 0.00 0.00 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:59
93540 dbe65e7c6dbad0a1dfa51159eadeef39e3d71fd071a99553906fd40cc14167a2 692618b44adaafffa92b1576 67ced3357abf9f3ed8fe813a Michael Divjak Michael Divjak keschmeyer@yahoo.com 003453 459 2026-03-05 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-11-25 21:41:22 -2398.8 hrs 692618b44adaafffa92b154e 000028742 0.00 0.00 0.00 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:59
93539 5437104710a9f53cc67800ded596928382c9a30d964539f448c2f19727d37114 692618b2a21b1aeb10416802 67ced3357abf9f3ed8fe813a Michael Divjak Michael Divjak keschmeyer@yahoo.com 003453 459 2026-03-05 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Christian Kenneth Abungan 2026-03-11 15:20:35 138.8 hrs 692618b2a21b1aeb104167da 000028702 3.00 85.34 85.34 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:59
93538 1f42318c286938eb9927c8b25fc268a7f8239fcd9247963adfc95a2509b2df2b 6994985e0afa3b91a22f869d 692de8a8b6fea6a4e18b749c Nicole Johenning Nicole Johenning johenning6@hotmail.com 020310 14 2026-03-05 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Patient - - Yes Laura Sage - Michelle W. 2026-03-05 20:52:34 0.1 hrs 6994985e0afa3b91a22f869c 000037846 3.00 83.39 48.39 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:59
93537 97a6e4f8850263651d29bba281b9c7a2636d94c9e1cdccec836b262b47438159 698ce58c506272adbf5874d2 6965268f95b0115ccf4cfb41 Scott Culley Scott Culley scottculley@msn.com 020491 23 2026-03-05 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Michelle W. - Michelle W. 2026-03-05 20:52:26 0.1 hrs 698ce58c506272adbf5874d1 000037295 3.00 77.10 77.10 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:59
93536 6645d9c32495d20b0bc8bac0e437381f9ed5a559c3ccea268344a7d31f47269f 69850e251c26f80b62499a78 67ced5337abf9f3ed8fef295 Patrice Rowe Patrice Rowe pat_rice01@yahoo.com 013123 48 2026-03-05 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2026-03-05 20:39:41 -0.1 hrs 69850e251c26f80b62499a77 000036734 2.00 54.44 54.44 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:59
93535 1698574c886bfcbc356fe193c76dae89986f4b0ae998965c3ce6249679112446 698274e4b532be7ac92fff41 67ced2ea7abf9f3ed8fe5bde Kristina Berquist Kristina Berquist kzberquist@aol.com 000265 199 2026-03-05 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Christian Kenneth Abungan 2026-03-11 17:25:42 140.7 hrs 698274e4b532be7ac92fff40 000036479 3.00 82.00 82.00 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:59
93534 5f8a53f0ce79bf284e909d97229418c7528df4010ee36538b938b4febce88db6 693b374d98858f2582834d17 67ced39a7abf9f3ed8fea2b4 Stacey Gurr Stacey Gurr sngurr@gmail.com 006309 217 2026-03-05 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+ Ins auths limitation- sc Sonya C. 2026-02-02 21:14:29 -743.5 hrs 693b374d98858f2582834d0f 000030557 0.00 0.00 0.00 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:59
93533 9de06c4033693cc89a86ef4ce9d6e06c93ac490059012a9ecce7471c70dc7890 6912665f94ecd9b465f495b7 67ced2ed7abf9f3ed8fe5d37 Patricia Beumer Patricia Beumer patty1@beumerfamily.com 000380 818 2026-03-05 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 2/17 Sophia L. 2026-02-17 21:41:26 -383.1 hrs 6912665f94ecd9b465f4958f 000026672 2.00 0.00 0.00 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:59
93532 68be7fa425a09e9f438d94178d7d581d0b363733da6ffa1bbf8a4ac9987ee14d 699cd19466b693052b4d4ae8 68a8154699c65c4a78a5fd70 Claire Lay Claire Lay bokomaru4@gmail.com 018852 4 2026-03-05 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 68998453d9ae21be8001ca00 Boulder Julie Unpaid - Unidentified - - No Frances Lawrence would like to reschedule in 2 weeks Frances Lawrence 2026-03-04 18:40:35 -26.3 hrs 699cd19466b693052b4d4ae7 000038845 0.00 0.00 0.00 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:59
93531 7ca6eb66e76dea0c39a41e942ab26e396ece6e858dfd5f14249a00faf6d896ce 699497a4197e786d921c9d12 69826f53ea53570a92c6df73 Michael Wu Michael Wu mikewu@umich.edu 020686 6 2026-03-05 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No John Phinney 24+ pt has a sick kid at home Michelle W. 2026-03-04 21:28:06 -23.5 hrs 699497a4197e786d921c9d11 000037840 0.00 0.00 0.00 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:59
93530 9f2ad20ccc1df313c4d0a5828f591110c01272f939ed8f901d665386a705f638 69935a07a08a528c05e48eb1 699358e49ce679b0e8ba945a Drew Johnson Drew Johnson drew.edwin.johnson@gmail.com 020759 9 2026-03-05 Cancel 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Work conflict, +24 hr notice. VR Veronica Rasmussen 2026-02-27 16:01:43 -149.0 hrs 69935a07a08a528c05e48eb0 000037719 0.00 0.00 0.00 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:46
93529 93ba84cac2c72d302628b5054cf5eaab20b3765779844f03dbe8df7996f5994a 697947effe60502fe4977dde 6979464c72b5ce8994529503 Dominic Beer Dominic Beer lascervezas@gmail.com 020645 14 2026-03-05 Checked Out 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sonya C. - Christian Kenneth Abungan 2026-03-12 15:35:36 162.6 hrs 697947effe60502fe4977dd4 000035630 3.00 240.00 10.00 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:46
93528 cdc6e98acfe74d87d807f75f73d0c514d7254239493539dd5ad297bd3412d371 696162b03b06d2dccffaf666 6920dcb2a1c5559afd0a6949 Chloe Bowie Chloe Bowie chloereignbowie@gmail.com 020290 14 2026-03-05 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sophia L. - Haley Paull 2026-03-05 20:56:18 -0.1 hrs 696162b03b06d2dccffaf665 000033224 3.00 235.00 0.00 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:46
93527 dcc71179aca50aa31f04f3b2b5a865d058e8a94af5e2b8ba470e51c845311005 693898d3798388d06ad2bcfd 67ced5cd7abf9f3ed8ff0898 Albert Vitt Albert Vitt avitt@trengr.com 015000 92 2026-03-05 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2026-03-05 21:11:41 0.2 hrs 693898d3798388d06ad2bcfc 000030199 3.00 83.38 83.38 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:46
93526 4f9fc1342f4cb55e20e59b26562f783fbc7e059c9830162c4468491c2f518877 69a60ae056a0d6440b1bc80d 67ced2f67abf9f3ed8fe63be Ellen Blockhus Ellen Blockhus emblockhus@comcast.net 000937 74 2026-03-05 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Samantha Saunders - Christian Kenneth Abungan 2026-03-12 14:47:14 161.5 hrs 69ab01170dd7963b2abfdd21 000039831 4.00 60.00 70.00 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:46
93525 47dc73c24b7106eac13d2586afd476e38125042ed662d6a1ba09d61fcd05d8c3 69a0b053e0d72c42e3998967 67ced30b7abf9f3ed8fe6fa6 Angel Davis Angel Davis selinadavis54@gmail.com 001953 44 2026-03-05 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Sophia L. - Michelle Osgood 2026-03-05 21:26:08 0.2 hrs 69a0b053e0d72c42e3998966 000039488 3.00 230.00 0.00 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:46
93524 8e1a5e4fab2196ece9dd9f6a95d21f1be6b694b60925bce49238064253758442 699f48c39b919f674b570bd5 67ced4f47abf9f3ed8fee8ad Carol Rhode Carol Rhode juneau1601@gmail.com 012278 165 2026-03-05 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Laura Shove - Haley Paull 2026-03-05 21:48:51 0.6 hrs 699f48c39b919f674b570bd4 000039216 3.00 83.38 83.38 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:46
93523 6e55b03626d21d58aee762db18cc45eac6dc1fc199adcd6d8b50ca569cb31566 699cc535781fee0e448a3fd1 67ced3ce7abf9f3ed8feb01f Amy Howard Amy Howard amh.howard@gmail.com 007454 6 2026-03-05 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Marguerite Barth - Haley Paull 2026-03-05 21:13:45 -0.0 hrs 699cc535781fee0e448a3fd0 000038817 3.00 84.15 84.15 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:46
93522 215a086257d80e05c2c9112ef40c30d5d75c85dbf9bf08dabf7c0eb2e4041027 6998d2d875012cbc3c878b21 6998d1dd75012cbc3c875f06 Timothy McDonald Timothy McDonald timromc@gmail.com 020802 15 2026-03-05 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 2/26 - doesn't need appt Sophia L. 2026-02-26 16:24:30 -172.8 hrs 6998d2d875012cbc3c878b20 000038543 3.00 0.00 0.00 - - - - - - - - 2026-03-05 22:26:10 2026-04-24 22:44:46
93521 68f92256a14302a7e50d645eb233bee4abd11ad8b96816aadc617e06c16b13cc 6994d5f8784be2f40086ad9a 68ffc5335db4b50989b61856 Marcia Mason Marcia Mason mllmason@mac.com 020150 13 2026-03-05 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes John Reed - Sonya C. 2026-03-05 21:51:53 0.6 hrs 6994d5f8784be2f40086ad99 000037978 3.00 232.00 50.00 - - - - - - - - 2026-03-05 22:26:09 2026-04-24 22:44:46
93520 6d81643306f63e8a099980b31e9429531d1159219c187fcbd972b3b5f063e345 697cd0a466681d238534383e 6965380eeb9024b69957ec98 Jazmine Zaldivar Jazmine Zaldivar jazmine.zaldivar@gmail.com 020495 28 2026-03-05 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Renee Carr other appt Samantha Saunders 2026-03-02 20:59:13 -72.3 hrs 697cd0a466681d238534383d 000036077 0.00 0.00 0.00 - - - - - - - - 2026-03-05 22:26:09 2026-04-24 22:44:46
93519 8657fe8a61937b0917e2cbf81d8bd253e266a0bf0685ae11ed3d501d06072909 6978e2351422f2d29986deff 687a93bbf31feff2b5c844cd Shane Brown Shane Brown shane.brown@colorado.edu 017654 26 2026-03-05 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Renee Carr 24+_ scheduling conflict -mw Michelle W. 2026-02-23 21:04:18 -240.2 hrs 6978e2351422f2d29986defe 000035408 3.00 0.00 0.00 - - - - - - - - 2026-03-05 22:26:09 2026-04-24 22:44:46
93518 a505358f3a47c8930401677191e8038d199599edffc2530b2b5402e50dac900c 69541aceb27337d2b88cbbdd 68361a11c03fb8088a923089 Robert German Robert German rfgerman@icloud.com 017316 14 2026-03-05 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt will be oot Michelle W. 2026-02-05 22:56:44 -670.3 hrs 69541aceb27337d2b88cbbdc 000032038 0.00 0.00 0.00 - - - - - - - - 2026-03-05 22:26:09 2026-04-24 22:44:46
93517 d5aaaeaca445e54dd0c28c15f8f830e13a6c7ef9b20d5a1a543691733a565b75 693869ded98a0035c066db27 67ced4007abf9f3ed8febbae Michelle Laub Michelle Laub michelle.laub@bvsd.org 008440 56 2026-03-05 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2026-03-05 21:12:59 -0.0 hrs 693869ded98a0035c066db26 000030127 2.00 100.00 100.00 - - - - - - - - 2026-03-05 22:26:09 2026-04-24 22:44:46