General Visit (PT Boulder API)

Total rows: 104,043
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
101793 e332eab0994a0c80de9c963185a03b05997d42359a15a32b488ef539bee7dc3f 69f383dd4f34c78f9d6965ea 69cade787727abf2ddf1046e Arianna Guzzi Arianna Guzzi acguzzi@comcast.net 021006 16 2026-05-18 New 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Veronica Rasmussen - Veronica Rasmussen 2026-04-30 16:31:25 -437.5 hrs 69f383dd4f34c78f9d6965e9 000046704 0.00 0.00 0.00 - - - - - - - - 2026-05-18 22:31:33 2026-06-10 22:36:11
101792 99e7b7a688032bf848955ed88473e93d0457d191e4016e02ec10bda417be1c86 69ebc2a15c932603da9fc0fb 69652ceeedcf46bcc16ffc26 James Rector James Rector jbrector46@gmail.com 020492 31 2026-05-18 Checked In 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Laura Shove - Laura Shove 2026-05-19 13:27:28 15.5 hrs 69ebc2a15c932603da9fc0fa 000046106 0.00 0.00 0.00 - - - - - - - - 2026-05-18 22:31:33 2026-06-10 22:36:11
101791 8e4c253067e6fc419a0da636339c618956676a3abccfacf98efc245c2cccc3a7 69e7948fad299015feabac39 69e77a31728aadb9e1a2e53d Diego Cervantes Diego Cervantes atglogos6@gmail.com 021142 11 2026-05-18 Cancel 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Laura Sage 24+ pt missed his IE-mw Michelle W. 2026-04-29 21:19:00 -456.7 hrs 69e7948fad299015feabac38 000045495 0.00 0.00 0.00 - - - - - - - - 2026-05-18 22:31:33 2026-06-10 22:36:11
101790 9045de6e5c04c6ee760f1b3300a467b7a554fc59c5592b4302c4e7a5681408d9 69c1a5da32bf13d613f303ce 69c141a7e2b98a8560e2cf1d Peter Carney Peter Carney pcarney413@yahoo.com 020958 5 2026-05-18 New 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Laura Sage - Laura Sage 2026-03-23 20:43:05 -1345.3 hrs 69c1a5da32bf13d613f303cd 000042202 0.00 0.00 0.00 - - - - - - - - 2026-05-18 22:31:33 2026-06-10 22:36:11
101789 d553cd7762b3752354f01c2a7e0f438fffe5b04e394eef3de8d9abfa83a483fe 69963468b7a22e67d8e6e3bf 691b8d00ab1373dea5d1519e Susan Johnson Susan Johnson susan36@comcast.net 020255 37 2026-05-18 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. cxl all May appts d/t travel LS Laura Sage 2026-04-23 20:47:42 -601.2 hrs 69963468b7a22e67d8e6e3b9 000038189 0.00 0.00 0.00 - - - - - - - - 2026-05-18 22:31:33 2026-06-10 22:36:11
101788 3dbffcb07ed3ce9d96540aa356e6b9bb9c56d5d75b9390f6e015d464a0b032b9 69fbab618411329e0981fa24 6823b00248048d03791a9751 Cheryl Barnes Cheryl Barnes revcheryl.barnes@gmail.com 017233 26 2026-05-18 New 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Peter Gagnon - Michelle W. 2026-05-08 16:26:22 -246.1 hrs 69fbab618411329e0981fa23 000047331 0.00 0.00 0.00 - - - - - - - - 2026-05-18 22:31:33 2026-06-10 22:36:11
101787 951e74b90fb4ff933017757f7b6d1be70c9a1ecc0ef87cc1e4162a28c3b785ce 6a0253018378f756e6c11b3c 67ced4ca7abf9f3ed8fee1bd Heather Politi Heather Politi heather.politi@gmail.com 011686 4 2026-05-18 New 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Peter Gagnon - Peter Gagnon 2026-05-11 22:06:56 -168.9 hrs 6a0253018378f756e6c11b3b 000047706 0.00 0.00 0.00 - - - - - - - - 2026-05-18 22:31:33 2026-06-10 22:36:11
101786 f7f6e0bd85babbaed04521c14c1dc85a400b18f4688bf9c58b2820a069dfbb13 69af1909a5557257984e7a12 67ced5117abf9f3ed8feed40 Amy Schmidthuber Amy Schmidthuber aschmidty17@comcast.net 012668 133 2026-05-18 New 67ace2bb7bc1a911a084fa01 Laura Shove 67a679a3294b1b37ef18c48c AIM AUTH NEEDED - GET OUTCOME 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Haley Paull - Lourdes Casilao 2026-05-15 18:29:46 -77.0 hrs 69af1909a5557257984e7a11 000040524 0.00 0.00 0.00 - - - - - - - - 2026-05-18 22:31:33 2026-06-10 22:36:11
101785 9559a344ea821fccdb7f495ac21ba61d7a0ca40aa24cb407d5f5585b3086d9aa 69e10cd70f97ea2e5c27fabb 69b879730a17e84dafbda6ff Jennifer Mclees Jennifer Mclees mclees_jennifer@svvsd.org 020923 20 2026-05-15 Cancel 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Family emergency, VR Veronica Rasmussen 2026-05-15 13:10:58 0.2 hrs 69e10cd70f97ea2e5c27fab9 000045097 3.00 0.00 0.00 - - - - - - - - 2026-05-15 22:31:03 2026-06-10 22:36:37
101784 b721dd7b3107767430eea6386002949056b9c7a8f13e71c1417cd09835a78c29 69d66388f44a480ceb437552 68a38e7aba796dc7de088f3a Kerstin Dickson Kerstin Dickson kl.dickson@comcast.net 017816 28 2026-05-15 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Sophia L. - Mark Jerome Para-ase 2026-05-21 20:11:08 151.2 hrs 69d66388f44a480ceb437551 000044123 2.00 156.00 20.00 - - - - - - - - 2026-05-15 22:31:03 2026-06-10 22:36:37
101783 d311b3f4bc118eadc7e479a301954595dc2a09e498bd4d7dcf43788cc70f1d43 69cd29ba62838e1d77f6e6c4 68a8154599c65c4a78a5fd48 Karen Laszlo Karen Laszlo karen.laszlo@gmail.com 018844 21 2026-05-15 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Michelle W. 24+ pt is feeling better -mw Michelle W. 2026-05-14 15:59:37 -21.0 hrs 69cd29ba62838e1d77f6e6c3 000043307 0.00 0.00 0.00 - - - - - - - - 2026-05-15 22:31:03 2026-06-10 22:36:37
101782 60f5bdac3a7b86f95f07f7c9191dfb327a1b40547e0724621e2e904cfb7e121d 69c30e601350ba6602e8d929 67ced3747abf9f3ed8fe9777 Lynn Flynn Lynn Flynn lynnflynn@aol.com 005350 35 2026-05-15 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Haley Paull 24+ pt is sick -mw Michelle W. 2026-05-14 14:20:04 -22.7 hrs 69c30e601350ba6602e8d925 000042478 0.00 0.00 0.00 - - - - - - - - 2026-05-15 22:31:03 2026-06-10 22:36:37
101781 3dce6625626746b45341ceb960dc4e1cd26726eb0d31c1961aa835c78954db3f 69f0bb883aa57815ac2b2c83 6983a9d9cd7b98a58cd9159e Itzayana Salas Itzayana Salas rod_salas_07@hotmail.com 020688 18 2026-05-15 Checked Out 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Veronica Rasmussen - Veronica Rasmussen 2026-05-15 13:36:23 0.1 hrs 69f0bb883aa57815ac2b2c82 000046290 4.00 318.00 0.00 - - - - - - - - 2026-05-15 22:31:03 2026-06-10 22:36:37
101780 8ab541649c5ddbb1c6ab208d10b79faa303ff3343f35561b5277902db96ee185 69ebcb3a1122de73e0b5495a 69e26d133ea43ac2ad5c93cc Sarah Fischman Sarah Fischman sjack2ga@hotmail.com 021133 9 2026-05-15 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. 4/28 - seeing Annie in BLDR instead - HP Haley Paull 2026-04-28 15:02:28 -406.5 hrs 69ebcb3a1122de73e0b54959 000046118 0.00 0.00 0.00 - - - - - - - - 2026-05-15 22:31:03 2026-06-10 22:36:37
101779 c21b3f1099714f52fda90c5f29144356f9cf9cadce32b13f0fcad6a9e1d0dfeb 69ea980ca7b480ea68747280 69c198e919c2676ef0b6e4ef Sarah Wentz Sarah Wentz sarahmwentz@gmail.com 020966 19 2026-05-15 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Primary - - Yes Eva Tucker - Mark Jerome Para-ase 2026-05-21 16:19:14 146.8 hrs 69ea980ca7b480ea6874727f 000046029 3.00 235.00 20.00 - - - - - - - - 2026-05-15 22:31:03 2026-06-10 22:36:37
101778 af8e9a68867184355c32e22bc1b644b710e356108b06035cc0d6bc40bda83c45 69cfc8fc041b554bbff4a71d 698cba6347ba088b7fd1f800 Judi Morell Judi Morell jamorell63@gmail.com 020729 15 2026-05-15 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Sophia L. - Mark Jerome Para-ase 2026-05-21 20:10:30 150.7 hrs 69cfc8fc041b554bbff4a71c 000043677 2.00 156.00 60.00 - - - - - - - - 2026-05-15 22:31:03 2026-06-10 22:36:37
101777 b8140b6380f23edd3499ce62c8ea349985b72cfbb2e15250e73792ce3f95271a 69c17b277c9dc4717ef7ee1d 69c179d2d6f99ac7f74b4677 Diane Hirschhorn Diane Hirschhorn diane.hirschhorn@gmail.com 020962 14 2026-05-15 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Laura Sage 24+ OOT - sc Sonya C. 2026-05-04 15:32:40 -262.0 hrs 69c17b277c9dc4717ef7ee1c 000042133 0.00 0.00 0.00 - - - - - - - - 2026-05-15 22:31:03 2026-06-10 22:36:37
101776 3bdbc5fab9cf120c703aeb2276f72f7e1d3a552a1ceabb409e80f04b8d5c2c61 69d90bbd348b62d3b5297170 691f7a560cf11db82b6ccc36 Scott Vogel Scott Vogel scottvogel695@gmail.com 020281 21 2026-05-15 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Michelle W. 5/13 - Pt called int Jury Duty - HP Haley Paull 2026-05-13 16:12:04 -45.8 hrs 69d90bbd348b62d3b529716f 000044431 0.00 0.00 0.00 - - - - - - - - 2026-05-15 22:31:03 2026-06-10 22:36:37
101775 3515cf9d081e749049dc60253952d95df3f43949c1189275b07d7ad1ea3a94b5 69cfd8c86ffecceb46e9c8af 69b45498c7c8ca8a9326f27c Caitlin McDonnell Caitlin McDonnell mcdonnell.caitlinm@gmail.com 020911 30 2026-05-15 Checked Out 68535c6303dd08c79c018795 John Reed 67a67ab091753108089752a5 RTM READY 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sonya C. - Mark Jerome Para-ase 2026-05-21 17:23:03 147.4 hrs 69cfd8c86ffecceb46e9c8ad 000043694 3.00 231.00 8.50 - - - - - - - - 2026-05-15 22:31:03 2026-06-10 22:36:37
101774 45b858ae32c5749b37bc2ba2f4795ac098e06510d2c9a02ec60f43a73c02c8ee 69c6a21a60456d3fd1eb1803 69652ceeedcf46bcc16ffc26 James Rector James Rector jbrector46@gmail.com 020492 31 2026-05-15 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Haley Paull - Haley Paull 2026-05-15 13:58:01 -0.0 hrs 69c6a21a60456d3fd1eb1802 000042834 3.00 234.00 0.00 - - - - - - - - 2026-05-15 22:31:03 2026-06-10 22:36:37
101773 fa62e07e4035a47eb84e6963cc24f2e6d6878e650ce34267653bc49fd27e8e37 69c68fe271f343b2b8eed8ec 67ced4407abf9f3ed8fec8a7 Richard Montgomery Richard Montgomery rmont2u@yahoo.com 009546 99 2026-05-15 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Haley Paull - Haley Paull 2026-05-15 13:48:44 -0.2 hrs 69c68fe271f343b2b8eed8eb 000042831 2.00 157.00 0.00 - - - - - - - - 2026-05-15 22:31:03 2026-06-10 22:36:37
101772 94fd7155c6b87dd3a8f5a6e91a50a8e3378afc5c42a125f88e65f0f79b4f5963 69a077df7a10e5b5bc1edbd0 687fc387fc35fe079a7fcc66 Kate Spradling Kate Spradling kate.spradling4@gmail.com 017672 20 2026-05-15 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Sonya C. - Sophia L. 2026-05-15 13:57:55 -0.0 hrs 69a077df7a10e5b5bc1edbce 000039345 2.00 156.00 0.00 - - - - - - - - 2026-05-15 22:31:03 2026-06-10 22:36:37
101771 b2b6126410e365c3d9797dd37f93698664f8f8c27bbcd216bd71c47bed39b6ef 6973dbfd115d15d27113226b 67ced32c7abf9f3ed8fe7d44 Craig Colley Craig Colley calcolley@gmail.com 003115 103 2026-05-15 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. therapy no longer need 3/26 - HP Haley Paull 2026-03-26 20:40:01 -1193.3 hrs 6973dbfd115d15d271132263 000035179 0.00 0.00 0.00 - - - - - - - - 2026-05-15 22:31:03 2026-06-10 22:36:37
101770 81a1178a5f38b1f1a4d0ac6f15aaed7fec6c00db16388305e9e1d63c188b2aeb 69ea9f00dfb5c352beb974ec 69ea9e2a005096e6af54934f Anne Helsley-Marchbanks Anne Helsley-Marchbanks ahelsley@wisc.edu 021161 7 2026-05-15 Checked Out 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Laura Sage - Veronica Rasmussen 2026-05-15 14:15:30 0.0 hrs 69ea9f00dfb5c352beb974eb 000046033 3.00 237.00 0.00 - - - - - - - - 2026-05-15 22:31:03 2026-06-10 22:36:37
101769 0186bf7fd7bcd15a7ef6350c8b698096c78820c6d4ad3d6766fe0078c4ba771f 69e92938ee4cd6e795ed0f1e 68d4ae7b8bf10c6d835d936c Amy Puls Amy Puls amylpuls@gmail.com 019929 42 2026-05-15 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Laura Sage - Michelle W. 2026-05-15 14:28:02 -0.0 hrs 69e92938ee4cd6e795ed0f15 000045757 3.00 80.47 80.47 - - - - - - - - 2026-05-15 22:31:03 2026-06-10 22:36:37