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
100328 66b0225d1128d6494523c9a3bdcd25aebcc6fea6e0bc2bdc08926e877bc82953 69cbee821512feedec82f5d4 67ced3b67abf9f3ed8feaa28 Paula Hamlin Paula Hamlin bothofus@edwardhamlin.com 006945 21 2026-05-04 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Haley Paull 2026-05-04 18:15:52 1.8 hrs 69cbee821512feedec82f5cd 000043179 4.00 95.95 95.95 - - - - - - - - 2026-05-04 22:31:53 2026-06-11 22:39:36
100327 371124df807e5e2aaa168dba247e13ffde32d28e5da7d678d084d11d42f8d71b 69d53200ea62b1df0f59f487 69b193d0bb3aed335741b3e4 Holly Higgins Holly Higgins hc2011va@gmail.com 020892 25 2026-05-04 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Sophia L. - Sophia L. 2026-05-04 16:37:34 -0.1 hrs 69d53200ea62b1df0f59f486 000043975 4.00 313.00 0.00 - - - - - - - - 2026-05-04 22:31:40 2026-06-11 22:39:36
100326 85878fb0696e3d22b3d2f190012a8d8bb03633e30a0b6347731dc51f8074be9f 69ce7c3b06a2d0611eb51aa3 69b04ebc1736fe222ac8f534 Gloria Gallegos Gloria Gallegos GLORAIAXALAPA7@GMAIL.COM 020886 14 2026-05-04 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - Haley Paull 2026-05-04 16:46:17 0.0 hrs 69ce7c3b06a2d0611eb51aa2 000043482 3.00 233.00 0.00 - - - - - - - - 2026-05-04 22:31:40 2026-06-11 22:39:36
100325 c25b9f73d662cd375b010654d218a36dbe0cf1f5c22539b1d1c287008fc9bb03 69c6ddce7571c11165f4088d 69c6dcdc88d02bc7bd4d018e Shayla Cogan Shayla Cogan shayla.remington31@gmail.com 020993 12 2026-05-04 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Laura Sage pt called to cxl today's appt, she is sick. LS Laura Sage 2026-05-04 14:53:56 -1.9 hrs 69c6ddce7571c11165f40889 000042895 0.00 0.00 0.00 - - - - - - - - 2026-05-04 22:31:40 2026-06-11 22:39:36
100324 dad4076d1b43e444a7cabc8cae21fad1b149e2b97bd4389369f9fb5301e045e1 69c18f607097fa3081ff3993 69c18df2eb212bae6b8b5829 Fredric Gordon Fredric Gordon fgordon970@gmail.com 020963 12 2026-05-04 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Michelle W. - Sonya C. 2026-05-04 16:45:48 0.0 hrs 69c18f607097fa3081ff3992 000042164 3.00 237.00 0.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100323 dfab3bdb3395e5aa669dc981babc432a962aa9ee7e5234452727b5adad47d72e 69bd6f8c604121226a8ed703 696e8106e06e1642875304f6 Sheri Martinez Sheri Martinez sherimartinez@earthlink.net 020578 30 2026-05-04 Cancel 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a67ab091753108089752a5 RTM READY 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Veronica is out sick -mw Michelle W. 2026-05-04 14:38:37 -2.1 hrs 69bd6f8c604121226a8ed6f8 000041975 0.00 0.00 0.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100322 a98fd20b86df13c78da78e5922bdcc9ffa7860bcefefa7a07b1b35aa6fc29569 699e3b978fa6d94f7f9feb93 67ced3757abf9f3ed8fe97cb Janet Hart Janet Hart janethart80301@icloud.com 005378 167 2026-05-04 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Haley Paull non needed Laura Shove 2026-05-04 14:39:32 -2.1 hrs 699e3b978fa6d94f7f9feb92 000039095 0.00 0.00 0.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100321 42c9d979550b632417e9ab514a84b258a5f016a56278b2cb0304993c96893a56 69caac2389f7443e685d4db3 67ced3037abf9f3ed8fe6be6 Gabrielle Bottcher Gabrielle Bottcher gabyb4468@aol.com 001633 32 2026-05-04 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sophia L. - Sonya C. 2026-05-04 16:43:40 -0.3 hrs 69caac2389f7443e685d4db2 000043028 3.00 237.00 0.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100320 3877d7d18735c1920f361db61552f9321c8d8532dfc96e03ddfc8d866360ea88 6924f055ddb3983e13e73078 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2026-05-04 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Ranjini Ridgway - Sonya C. 2026-05-04 17:08:54 0.1 hrs 6924f055ddb3983e13e73046 000028363 5.00 391.00 0.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100319 2d9caf0b6c04e7a2cfeca33de85aa441d90756d9ca05207478e48fca335e5af2 69efccbf1eb8a1eb74545f29 697140d6f5e6d50f9c545978 Angela Immitt Angela Immitt angela.immitt@gmail.com 020604 13 2026-05-04 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67ab091753108089752a5 RTM READY 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Miranda Samson - Haley Paull 2026-05-04 17:13:18 -0.0 hrs 69efccbf1eb8a1eb74545f28 000046245 3.00 232.00 0.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100318 25ade4791298716f48113ec2d7865a006927d62e971f8f35da5a5d361d3a0dba 69e6669b17599de70d1a4c08 68a8153199c65c4a78a5f925 Brad Hoeben Brad Hoeben bhoeben@yahoo.com 018639 25 2026-05-04 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Michelle W. - Christian Kenneth Abungan 2026-05-07 18:36:53 73.4 hrs 69e6669b17599de70d1a4c07 000045384 3.00 85.00 85.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100317 e35c193968502c182e32578b502a9459b1249d7763e1f833404f03324bf1a975 69c1826dbae7a78ab3473b0a 67ced5487abf9f3ed8fef5c8 Karyn Spratt Karyn Spratt 54spratt@gmail.com 013396 60 2026-05-04 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - Haley Paull 2026-05-04 18:15:56 1.0 hrs 69c1826dbae7a78ab3473b09 000042147 3.00 235.00 0.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100316 70bc9e369868203ee23ae93e1737b6f6c99f63c57ab8edf3bf9745fc7704da38 698a476d45beb7fdf323cb2a 698a46cfefc313d192561705 Aileen Maldonado Aileen Maldonado lilytrevizo2@gmail.com 020714 4 2026-05-04 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Laura Sage 24+ Per VM request - no reason given - sc Sonya C. 2026-04-25 16:19:32 -216.9 hrs 698a476d45beb7fdf323cb28 000037035 0.00 0.00 0.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100315 29f6fcb2b6aca2382dce29264c8d1da339b3286c58667801303252839f652210 69cee0f9502919689a4c240b 67ced3017abf9f3ed8fe6acc Patricia Bosak Patricia Bosak tbosak1018@aol.com 001539 168 2026-05-04 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Michelle W. - Sonya C. 2026-05-04 17:35:32 0.1 hrs 69cee0f9502919689a4c240a 000043646 2.00 156.00 0.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100314 e20048068d80c55c5e999d4c46e946ed756197b39c664ef8b0e745e4728a0e2c 698a1f2dea81722c9cdb5a82 67ced3077abf9f3ed8fe6d90 Cheryl Dart Cheryl Dart cbdart@msn.com 001775 29 2026-05-04 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 4/2 cxl d/t conflict LS Laura Sage 2026-04-02 15:47:07 -769.7 hrs 698a1f2dea81722c9cdb5a81 000036996 0.00 0.00 0.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100313 606694c064d91b4b88b9dee1483a7245d683ca00fb004ac9b7f950d64d476e1d 695ee08bc1c9d14b093dd185 67ced5ef7abf9f3ed8ff0d00 Susan Tauger Susan Tauger susantauger@yahoo.com 015376 268 2026-05-04 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Renee Carr admin error Renee Carr 2026-01-23 22:38:56 -2418.9 hrs 695ee08bc1c9d14b093dd17a 000032947 0.00 0.00 0.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100312 3ea091ca71c4a9126e7eba1f5bc3cee400eebbfc286e9238521afa01bf903ac1 69f8af892a9f0df94ca7dffe 67ced3757abf9f3ed8fe97cb Janet Hart Janet Hart janethart80301@icloud.com 005378 167 2026-05-04 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Laura Shove - Sonya C. 2026-05-04 18:25:29 -0.1 hrs 69f8af892a9f0df94ca7dffd 000046912 5.00 386.00 0.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100311 7d196bcf44df1afe607685015434850c0a7abf58f0e84c92bfd1e53a920cb0f3 69f513027ec2065105fa0efa 67ced5287abf9f3ed8fef0ee Kelly Scott Kelly Scott kellygirlscott@gmail.com 012982 241 2026-05-04 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Christian Kenneth Abungan 2026-05-08 15:46:48 93.3 hrs 69fe0577f6c40ed7e7ab3715 000046908 4.00 82.00 82.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100310 a68c0a80391debe7a32a3b17b91f67b7d310081ad5dd5985517aef9b77aad5c3 69efb22b62148a21b35b0058 6903933a5f0b8e719f693315 Kris McNichols Kris McNichols kbmcnic@gmail.com 020175 28 2026-05-04 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes John Reed - Christian Kenneth Abungan 2026-05-07 19:38:43 73.1 hrs 69efb22b62148a21b35b0057 000046216 3.00 233.00 60.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100309 3d7785dad6d34e1cc54ba7e791ac17464e8d578a831332b3081d9b0f3dba3509 69e945b44b259ac476dff979 67ced3ef7abf9f3ed8feb7d5 Megan Kram Megan Kram krammegan23@gmail.com 008112 43 2026-05-04 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle Osgood 4/27 - scheduling conflict - HP Haley Paull 2026-04-27 21:49:45 -164.7 hrs 69e945b44b259ac476dff978 000045845 2.00 0.00 0.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100308 d031d860401be24dffc822525b92d0ed0b8d69b456abbb1ca1e2e6c5734146b2 69dd37a061f21d8bee408fab 67ced3057abf9f3ed8fe6ce2 Lailoni Apodaca Lailoni Apodaca lailoniapodaca1@msn.com 001717 42 2026-05-04 Cancel 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. Per VM request, her back is better & doesn't need PT - sc Sonya C. 2026-05-04 00:41:14 -17.8 hrs 69dd37a061f21d8bee408faa 000044601 0.00 0.00 0.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100307 0a82add5df0355facebaa7e3db08308bdadf344811ce4fd704479988b5d0a434 69dd1453d63e3b6d4a5867b2 69a5bd842eb954c8b06c439d Miriam Sparks Miriam Sparks miriamsparks@hotmail.com 020847 7 2026-05-04 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Michelle W. - Sonya C. 2026-05-04 18:26:14 -0.1 hrs 69fe0a79132493e140e72684 000044560 4.00 387.00 0.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100306 b9c0c61e0eb80be96eed8d80f92306a31aa0456acccefdde8c2ece0f7185560e 69d55bf6c47adc5ee8563e7f 69d55a59e98f943b77bce155 Rachel Dorrough Rachel Dorrough rrd235@hotmail.com 021057 5 2026-05-04 Cancel 689a313a77dba4d845e313cf Sara Thompson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Haley Paull 24+ thought ins would cover more -mw Michelle W. 2026-05-04 17:22:55 -1.1 hrs 69d55bf6c47adc5ee8563e7e 000044056 5.00 0.00 0.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100305 62878779cf19e3363ab822ed357a49e751ca2e8f9ad332f74043dff07b609235 69d55bb3e3224276b2851533 68a8159099c65c4a78a60b52 Sara Thompson Sara Thompson sschuman85@gmail.com 019534 1 2026-05-04 Cancel 689a313a77dba4d845e313cf Sara Thompson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Haley Paull wrong pt Haley Paull 2026-04-07 19:32:48 -647.0 hrs 69d55bb3e3224276b2851532 000044054 0.00 0.00 0.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36
100304 8bafa62c612a55762086957b71f58da32ce2e6eff6a48d4afb30c65ebd8d8268 69d54605496b00abf142a1fd 69d544e9ea62b1df0f6253fb Diana Lentz Diana Lentz ddgmlentz@hotmail.com 021056 3 2026-05-04 Cancel 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Haley Paull 24+ pt conf cxl SL 4/13 - got into another practice closer to home Sophia L. 2026-04-13 15:18:04 -507.2 hrs 69d54605496b00abf142a1fc 000044028 0.00 0.00 0.00 - - - - - - - - 2026-05-04 22:31:39 2026-06-11 22:39:36