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
93864 6388df32741e57008056fce2b5045ee77ac8c198de23cb79751bdf60b305c051 69ab95dbbcb8bc94258963c6 694c3d8d6492c879b647b888 Kartar Khalsa Kartar Khalsa kartar@kartarkhalsa.com 020417 12 2026-03-09 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Miranda Samson - Michelle W. 2026-04-01 17:48:06 552.6 hrs 69ab95dbbcb8bc94258963c5 000040441 3.00 85.47 85.47 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93863 48821104b486bb0dbe06dc48deb05a2a301bffd3a97fc25c05b82747c954d06c 69a1dd63cf2502548791c391 695c0c844e524e5fcfe8c268 Laura Baldridge Laura Baldridge laura_murphy99@yahoo.com 020450 18 2026-03-09 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Haley Paull boulder loc 3/2 - hp Haley Paull 2026-03-02 18:12:11 -167.0 hrs 69a1dd63cf2502548791c390 000039626 0.00 0.00 0.00 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93862 8c01016f78e55da0c3abbf235e84950418904659dd4b8eae29eaf181634e0cc6 6996315072b0a000b80c16b3 69962fcc55d56b15eadc0081 Kathleen Webster Effinger Kathleen Webster Effinger kate.effinger@gmail.com 020783 12 2026-03-09 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Michelle W. - Sonya C. 2026-03-09 17:08:24 -0.1 hrs 6996315072b0a000b80c16b2 000038178 4.00 175.14 101.19 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93861 100db9350b5bc493dc497558f7eb6f6895f61448e8ea9e271fb3c215e680d3a9 698f529b8ce584977db04e5b 67ced3137abf9f3ed8fe73e7 Susana de Slough Susana de Slough susanaflough@hotmail.com 002316 46 2026-03-09 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sonya C. - Haley Paull 2026-03-09 17:11:50 -0.1 hrs 69e271f83fbb8682e8f469de 000037524 3.00 237.00 0.00 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93860 b8d8e85fe58e470dbd6270e290695753a2e9d6e399b9290fbea8e46345988bd6 696fca452672c2acd273b6cc 67ced4a37abf9f3ed8fedb11 Kim Nguyen Kim Nguyen 0372kn@gmail.com 011117 24 2026-03-09 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Sophia L. 2026-03-09 17:32:30 0.3 hrs 696fca452672c2acd273b6cb 000034472 3.00 85.12 85.12 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93859 0f2dd6825f559bcd492d901ade55283bffd98027918de30542153461e333f58e 699c8dd405e63ee885381272 67ced3787abf9f3ed8fe98d3 Gail Grant Gail Grant gailgrant790@gmail.com 005466 91 2026-03-09 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Michelle W. heart procedure 3/5 - HP Haley Paull 2026-03-05 19:46:53 -93.7 hrs 699c8dd405e63ee885381271 000038774 0.00 0.00 0.00 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93858 d66b6599454a1afd6960a173eb929f3a9acc644f468640fd7d3531fdc5df085c 6997599af2f3a618dbb2fd76 696585f570d5df9079500f00 Michael Ebersole Michael Ebersole mj.ebersole17@gmail.com 020498 32 2026-03-09 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Haley Paull 2026-03-09 17:54:57 0.4 hrs 6997599af2f3a618dbb2fd75 000038317 3.00 85.00 85.00 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93857 f2ab0f51296a13d13d9624a54cb484e48532925f7aa5a1179b27f8e27d20a4b5 698a3eeb667add85fc77f2cb 67ced4ec7abf9f3ed8fee772 Edwin Rehme Edwin Rehme erehme@outlook.com 012173 12 2026-03-09 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Laura Sage - Sonya C. 2026-03-09 17:25:32 -0.1 hrs 698a3eeb667add85fc77f2ca 000037030 2.00 60.02 60.02 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93856 4da53dea6ddbf84c7eb4a7a8bd3c517f95a457abdf3402a3f90b595b23f8fcb1 695ee254bb3cd32c53713418 67ced5ef7abf9f3ed8ff0d00 Susan Tauger Susan Tauger susantauger@yahoo.com 015376 268 2026-03-09 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Renee Carr pt is not feeling well Michelle W. 2026-03-09 16:40:15 -0.8 hrs 695ee254bb3cd32c53713417 000032982 0.00 0.00 0.00 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93855 50f5728746d3ebcb6f0864a241649f1023b8cd245e1b2de930a16027a8cb7c70 6993662dd65791369b021e36 67ced5f07abf9f3ed8ff0d2a Annette Taylor Annette Taylor annejohn742@yahoo.com 015390 7 2026-03-09 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes John Phinney - Christian Kenneth Abungan 2026-03-12 18:15:14 72.5 hrs 6993662dd65791369b021e35 000037733 3.00 82.00 82.00 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93854 8702ffc98d5b7b7c2998cb44d7b28eb0a66dea3677530cd165e147573962e026 69ab3ff7d81f91eb31983362 67ced5117abf9f3ed8feed40 Amy Schmidthuber Amy Schmidthuber aschmidty17@comcast.net 012668 133 2026-03-09 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a679a3294b1b37ef18c48c AIM AUTH NEEDED - GET OUTCOME 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Haley Paull - Christian Kenneth Abungan 2026-03-13 14:38:16 92.4 hrs 69ab3ff7d81f91eb31983361 000040423 3.00 85.00 85.00 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93853 ce64c1d6fb1ff50bf56c60d3292c5c1412c5dd71f240b7f796161f4ccddcd1c2 6994a2720f1b51650c2b3b72 6994a1a2deec4ec5075d2c07 Keith Pietrasiewicz Keith Pietrasiewicz Pietrasiewiczk@bouldercolorado.gov 020767 19 2026-03-09 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Laura Sage - Christian Kenneth Abungan 2026-03-12 18:16:43 72.0 hrs 6994a2720f1b51650c2b3b71 000037857 4.00 95.71 90.47 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93852 b2372834649c1378deb6e3dc0a6afbe1165891046d977c24a7d47b03e7763a61 697156bfcf6871ddc8f0189a 67ced42c7abf9f3ed8fec4c2 Deborah Martin Deborah Martin dmartin0811@gmail.com 009214 66 2026-03-09 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Laura Shove 24+ rxl to 03/11- sc Sonya C. 2026-02-26 21:46:29 -260.5 hrs 697156bfcf6871ddc8f01899 000034798 0.00 0.00 0.00 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93851 0efd726b84a7e1ca79d4c65ff9b2befc952e52c97066d2f6c0c73767c533c7f2 699cce8d55b51fe7aeacee24 696ff6acb3ce3d1710a31f96 Craig Bushman Craig Bushman bushming@gmail.com 020595 6 2026-03-09 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Christian Kenneth Abungan 2026-03-13 14:19:21 91.8 hrs 699cce8d55b51fe7aeacee23 000038840 3.00 85.00 50.00 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93850 2975318cf4628d5db4c664a6c81609a77324293147f178332e8b942f2ef6628c 69989aa10b76380d22a32551 69989a1dca38ab6335b2a964 Georgina Gould Georgina Gould geegould@gmail.com 020797 13 2026-03-09 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Laura Sage - Christian Kenneth Abungan 2026-03-12 18:03:59 71.6 hrs 69989aa10b76380d22a32550 000038487 3.00 85.00 85.00 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93849 e1ffeaa998d64093a6be16da764ae148ba03979f864ed83696c92ff258d1b5b5 6997501dde42d10363fdef63 69974f5fde42d10363fd9e42 Jennifer Montoya Jennifer Montoya jenamontoya@gmail.com 020790 11 2026-03-09 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a67a90213226f6552a9bea KAISER FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Laura Sage - Michelle W. 2026-03-09 14:34:29 -3.9 hrs 6997501dde42d10363fdef62 000038298 0.00 0.00 0.00 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93848 61931d7a9f8a96263ea47ef14e961c5563aa35226d9408bc956800c4fb7f5288 69963f2cb7a22e67d8ea0659 69963e3531d8908677ec81e5 Brooklyn Faerman Brooklyn Faerman boulder.jules@gmail.com 020786 1 2026-03-09 Cancel 68535c6303dd08c79c018795 John Reed 67a679be05de5fabb1c08f2d ASH (CIGNA) OT/PT Initial Evaluation - GET OUTCOME 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. 24+ pt needs to see the dr first Michelle W. 2026-02-20 19:24:41 -407.1 hrs 69963f2cb7a22e67d8ea0658 000038220 0.00 0.00 0.00 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93847 4d00427a95079c6988096c838be18ce9520c5a564c16c7618cb505037b25c8f7 697bd553090bd03df213f8c9 68f169ebe66b06a2061fc56d Jay Flora Jay Flora debraflora@comcast.net 020092 20 2026-03-09 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Haley Paull 2026-03-09 18:30:51 0.0 hrs 697bd553090bd03df213f8c8 000036031 3.00 85.12 85.12 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93846 4520094f8a14ced1dda609be6a4555e6be45e911666e5df1527ccdc860c67094 697b82008014179f82e45a97 67e6650defbf2c53d8d5d246 Thomas Chalmers Thomas Chalmers thcdolt@comcast.net 016802 39 2026-03-09 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Renee Carr 24+ per email request, no reason given - sc Sonya C. 2026-03-09 05:11:59 -13.3 hrs 697b82008014179f82e45a96 000035871 0.00 0.00 0.00 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93845 16ebade1ad088cf04bcd92a388307aa5dbf2482122661406cb65f8020d654410 6977dd2c1b0997c73ab3626e 67ced6167abf9f3ed8ff1218 David Weiss David Weiss davidlinda_weiss@msn.com 015810 71 2026-03-09 Checked Out 67ace27f67327b083edb451f Michelle Osgood 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Elizabeth Cousins - Haley Paull 2026-03-09 18:44:58 0.2 hrs 69c40f2683d58d1cf193196e 000035346 4.00 341.37 32.96 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93844 bd22cb183ef5b266edcec3058ff46290e0eac8489f180398ef9126d094ee645a 6966b074d2caf6c91e5b6166 695ec8eb2081c2bdabaa5547 Ashley Etchart Ashley Etchart ashleyetchart@gmail.com 020474 13 2026-03-09 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sophia L. - Christian Kenneth Abungan 2026-03-13 15:17:35 92.8 hrs 6966b074d2caf6c91e5b6165 000033540 4.00 312.00 95.00 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93843 46ff087c51f616ad11e9b92c71d482df613d76f8acfd211295e1374a69603f6e 695c230af63c25b3ac08ca17 686542b06de526088c4c9127 Ann Firby Ann Firby ann@firby.us 017560 41 2026-03-09 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 1/28 pt called to cxl d/t schedule conflict Laura Sage 2026-01-28 16:48:52 -961.7 hrs 695c230af63c25b3ac08ca13 000032514 0.00 0.00 0.00 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93842 254f3ea6804ddabf21615eaa26e1d8a24eb2c4af5abcebd068bc6680e88d246b 698f9359c2f99d603793c9cc 68433cce75c7b0f1beb7313c Neil Sherman Neil Sherman nsherman0@icloud.com 017413 51 2026-03-09 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2026-03-09 18:45:54 0.0 hrs 698f9359c2f99d603793c9cb 000037583 3.00 83.38 83.38 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93841 981f16ed3b8039088cb57f371c46287a86283c128ddbf231674bdc8180df8968 6925d6df779adcd2d7bdc78f 67ced33d7abf9f3ed8fe8449 Gregory Cortopassi Gregory Cortopassi greg@cortoimages.com 003714 77 2026-03-09 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-11-25 16:21:58 -2498.4 hrs 6925d6df779adcd2d7bdc783 000028501 0.00 0.00 0.00 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17
93840 ba792df3c3953435880f609e0e5bd1a305134196942a2d98d3072b0f2290979e 6925d6dc8b2d4a5b7ddb0ba5 67ced33d7abf9f3ed8fe8449 Gregory Cortopassi Gregory Cortopassi greg@cortoimages.com 003714 77 2026-03-09 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Haley Paull 2026-03-09 18:32:39 -0.2 hrs 6925d6dc8b2d4a5b7ddb0b99 000028489 3.00 83.38 83.38 - - - - - - - - 2026-03-09 22:26:40 2026-04-24 22:44:17