General Visit (PT Boulder API)

Total rows: 100,227
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
7491 afec52beb5a4e47adc290beb65f994976ad16a841d13eb0990b39e3830794859 691b45587b62bb355abc05fd 67ced3497abf9f3ed8fe88ac Berta Egan Berta Egan bertae999@gmail.com 004088 90 2025-12-15 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sophia L. 2025-12-15 20:38:20 -0.1 hrs 691b45587b62bb355abc05fc 000027329 3.00 82.00 62.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7490 6765bb415affabcabcd2610f84dc5e54c65004bbbab0c06c1db157ec6b8a893a 690a82b3f3622a78bbe23c30 68408687731455084b508154 Linda Panter Linda Panter lkbildstein@gmail.com 017387 19 2025-12-15 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ was able to get in w/PT sooner w/in walking distance - sc Sonya C. 2025-11-12 19:42:35 -793.0 hrs 690a82b3f3622a78bbe23c2f 000026058 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7489 ca4d06ba6e55e6d37b255e90dae07b93c742e30bccd2f82cfaa5a60a5ab6e127 694048918a9aef5ab3d4a6c4 68792a503c87fc911599aeaf Katelyn Johnston Katelyn Johnston katelynj15@icloud.com 017645 6 2025-12-15 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Michelle W. - Sophia L. 2025-12-15 21:02:08 0.0 hrs 694048918a9aef5ab3d4a6c3 000030750 1.00 130.00 130.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7488 92fd289e06c3d2f3ad13012b5dc9ddd5e0661f23f53cbb37fc02ec1f0425076d 693c6137673c9ec3ea23c408 68017885831990d97bdb1b73 James Lewis James Lewis jimlewis8128@gmail.com 017083 57 2025-12-15 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sophia L. - Michelle Osgood 2025-12-15 21:39:59 0.7 hrs 693c6137673c9ec3ea23c407 000030636 4.00 306.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7487 82669e86f538dd44d51eae715905157cabdbbd61c444d8221ffdb397b2785c0f 692dfb816981da069d316710 68a62d3e7ca29d8ccbb7821b Robert Schmidt Robert Schmidt robwschmidt@msn.com 017863 22 2025-12-15 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Frances Lawrence - Eva Tucker 2025-12-15 21:57:21 1.0 hrs 6948afce3536351e45cb9e84 000029178 4.00 170.07 170.07 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7486 7895d754ad1b4f2aff769dd49bc3af64d7dd8d9d9f5776bc2c415889557d245b 69249b16097f838223a2127a 67ced6507abf9f3ed8ff1975 Julie Yang Julie Yang julie.yang@ptofboulder.com 016438 47 2025-12-15 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Renee Carr 2025-12-15 21:04:58 0.1 hrs 69249b16097f838223a21279 000028191 3.00 80.26 80.26 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7485 f2b0fc79d3d1a3cb7a7bc199697682b6746c9d17b771b804daf9c43068dd225d 691b75d5b63a51ba4d7b91c3 67ced3a17abf9f3ed8fea497 Daniela Gaal Daniela Gaal dsg@boulder50.us 006470 54 2025-12-15 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Renee Carr 2025-12-15 21:01:38 0.0 hrs 691b75d5b63a51ba4d7b91c2 000027448 3.00 83.09 83.09 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7484 27b6a4d74120ffb4d0ad6d2da28b6d8e57222ea948037f37c12446556e4177d2 69162b126aba5564e28d565f 69162ae71834b06955b6f89f Megan Gossard Megan Gossard gossard.m@gmail.com 020242 16 2025-12-15 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Rosey Reed 24 + job schedule and vacation change - RC Sonya C. 2025-12-12 18:43:23 -74.3 hrs 69162b126aba5564e28d565e 000027141 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7483 e8dbc8b61d79c2c6d5f65d7aa26da6ef17fcc53a7cad94fd715937249dad78e4 69126ede94ecd9b465f5e97e 67ced4b87abf9f3ed8fedea5 Allison Novak Allison Novak novak0319@gmail.com 011422 30 2025-12-15 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2026-01-12 15:54:09 666.9 hrs 6965196521264e61d79d8ecf 000026752 4.00 82.00 81.60 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7482 dad6612b43e003128fe39a857c96e8380c83711095f67c64da27411b32c937ce 690a39b53417420e6da243b2 688151c2e5c757a0095202c6 Thomas Crowley Thomas Crowley thomas.crowley2554@att.net 017692 12 2025-12-15 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24+ see contact log -mw Michelle W. 2025-12-11 22:31:27 -94.5 hrs 690a39b53417420e6da243b1 000025914 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7481 531f56e2daf01f6dcef2eeac11dc6cc2bfef5af8c824a89452a49ebe25bc7685 68f2b758c7ae4bfbd79e9aaf 67ced5fb7abf9f3ed8ff0e89 Christopher Tennant Christopher Tennant christopher.j.tennant@gmail.com 015507 12 2025-12-15 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+ see chart note Michelle W. 2025-11-18 15:02:33 -654.0 hrs 68f2b758c7ae4bfbd79e9aae 000023952 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7480 39d03b508e4f41f6926f3d4668eea51b5345bbcf9b5bb75e3de43bc1ae696317 68dd7840167a7afac63fc8e4 67ced2fa7abf9f3ed8fe6667 Richard Bolen Richard Bolen rbolen@centurylink.net 001164 166 2025-12-15 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sophia L. 2025-12-15 20:58:03 -0.0 hrs 68dd7840167a7afac63fc8db 000021907 3.00 80.26 80.26 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7479 cbd802f6bbebb3af7fd920fcbcbe227dcddea5d659c08c28abab33b9b619b73c 685d6df47d774308254c3619 67ced6167abf9f3ed8ff1218 David Weiss David Weiss davidlinda_weiss@msn.com 015810 71 2025-12-15 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Elizabeth Cousins 2025-12-01 21:12:57 -335.8 hrs 685d6df47d774308254c3612 000010906 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7478 fb890746b7eff0bc9149354390fc2fc039ebde1f306628c58d75b7d9ee5fdb5e 69307e58dfe289c776b52b55 68c077def1afc1f68ec1e0e1 Colman Kahn Colman Kahn nanakahn@gmail.com 019825 18 2025-12-15 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Elizabeth Cousins - Mark Leo Guevarra 2025-12-30 19:59:44 358.7 hrs 69307e58dfe289c776b52b54 000029538 3.00 60.00 60.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7477 2f5bce604579a63c55da4acf78ba70a51c48aff6efd8dcc7c6ea5a613c2da158 68f6a30f566aab52d044ef39 67ced5b07abf9f3ed8ff04b7 Kayla Smith Kayla Smith thekaylajsmith@gmail.com 014669 28 2025-12-15 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 12/15 - work schedule has changed Sophia L. 2025-12-15 16:11:01 -5.1 hrs 68f6a30f566aab52d044ef38 000024090 3.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7476 c48e10bc868fbf4fb03a75bc3ff3160d6d27d867a484ad4938a0c12ad31f8241 68f008e8afb0d3aea0024e57 68f00739f8d92b00e83a66c2 Wendy O'Connor Wendy O'Connor wendyohh54@aol.com 020079 18 2025-12-15 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sonya C. - Michelle W. 2025-12-15 21:11:09 -0.1 hrs 6945c9cea5c44773bb7fde4a 000023667 3.00 83.24 78.24 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7475 a7cbe7a9bd8bdc110d1ee22b4f18b37594ad071da2bf8c152c2f0922b1d9d555 68bf316c2c6d9dcb7b7bd68d 67ced3067abf9f3ed8fe6d15 Deborah Appel Deborah Appel debbie2175@me.com 001734 90 2025-12-15 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Rosey Reed - Renee Carr 2025-12-15 21:15:24 0.0 hrs 68bf316c2c6d9dcb7b7bd68c 000019081 3.00 78.70 62.70 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7474 84824ddf4a10abdfdd6077c276262f04ab8df219290522acd539d369cf267f0c 692db248c4b33aecfdbfad3b 67ced37b7abf9f3ed8fe9984 Suzanne Forrester Suzanne Forrester suzanne@sgforrester.com 005525 16 2025-12-15 Cancel 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ already has an appt booked on this day - RAR 12/9 Rosey Reed 2025-12-09 21:57:12 -143.5 hrs 692db248c4b33aecfdbfad3a 000029096 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7473 56910c928b0f671d269a497ce9d6b3b1f831f82c3a15453c9856ef1cf85c3938 690d173978ac217931cc4c6c 68c323cd96546f2c23eb9583 Gabina Salazar Gabina Salazar gabyss2580@gmail.com 019842 56 2025-12-15 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Michelle Osgood 2025-12-12 15:00:59 -78.5 hrs 690d173978ac217931cc4c6a 000026340 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7472 0d4b26bfed3df274f47ebc859a36ebfb7e78420f70909e9b88d88ef66c885134 6900f41cfaef03f2a63f2e76 6900f33c4131694f4f59bb62 Marc McDonough Marc McDonough marc.mcdonough@tifin.com 020156 19 2025-12-15 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed out of town Samantha Saunders 2025-12-12 17:26:04 -76.3 hrs 6900f41cfaef03f2a63f2e75 000025045 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7471 e9125e1fb99a44d8b6759a1aa070fbde59c805a8fdefd6c1362cff0bd5dbd717 68f7d5603c0662732fcc065e 67ced3c57abf9f3ed8feae03 Joanne Karpinski Joanne Karpinski jkarpins@gmail.com 007274 24 2025-12-15 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Kenneth Dave Francisco 2026-01-06 18:31:26 524.8 hrs 695d5518d91aa67a53eab0d7 000024260 3.00 79.79 79.79 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7470 9d75d9c1f13878cbed3a16468af074a8bc016b4bbbe66dfb8badb95b8ea3c9dd 691214631154c8a2d635c67b 67ced6147abf9f3ed8ff11c0 Murielle Ting Murielle Ting pbelle259@gmail.com 015781 23 2025-12-15 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Rosey Reed - Mark Leo Guevarra 2025-12-19 18:25:47 92.4 hrs 691214631154c8a2d635c67a 000026495 4.00 95.71 95.71 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7469 b5ea1922573a082404f5fbfa0484a6018cbbfc4c77dd1953b198fceaa576fa28 690a44070794fab0062c3ded 680908e6dc968f594897748f Peggy Moore Peggy Moore pjmoore46@msn.com 017113 70 2025-12-15 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Sonya C. - Sophia L. 2025-12-15 22:25:08 0.4 hrs 690a44070794fab0062c3de9 000025960 3.00 79.51 63.35 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7468 ea85ce11d61843869587f38512e51bb63f44c304585f407f7ccf5c2a5dc935c9 690916be53ea41c5c5a2eb6f 67ced33b7abf9f3ed8fe83c2 Brandon Cornacchione Brandon Cornacchione mscornacchione1963@gmail.com 003669 115 2025-12-15 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Renee Carr 2025-12-15 22:03:37 0.1 hrs 690916be53ea41c5c5a2eb6e 000025771 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04
7467 128f10e5199cdb9f6e91e72b90471880edd71c3b048852b2cfce27c50d6503c6 6908f980fb9ff059f38ba89b 6908f904fb9ff059f38b82f3 Sharla Ferguson Sharla Ferguson sharlamittone@gmail.com 020188 9 2025-12-15 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67fe758025fd260826e4f8b1 Pelvic Floor Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2026-01-12 15:55:51 665.9 hrs 6908f980fb9ff059f38ba89a 000025733 1.00 150.00 150.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-02 23:09:04