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
14745 c6a8a85d756b0b82c3030f2efc46cc2849f573930120a595dd538e8776dd28d1 68e028037e334af5734e28e6 67ced5d47abf9f3ed8ff0985 James Voss James Voss jim.voss@colorado.edu 015079 45 2025-10-13 Checked Out 68535c6303dd08c79c018795 John Reed 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-10-13 14:02:25 0.0 hrs 69c5bf47feeebf347b192c65 000022222 5.00 193.66 193.66 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14744 6b42936390b522f73fe70958027ca71b331e4fa32caa881c056f4c6b5c5bba95 68d1cf54691f338c0b824717 6896481e1d2a819c6a62a428 Katherine Lightfoot Katherine Lightfoot katie.lightfoot@colorado.edu 017771 44 2025-10-13 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Rosey Reed - Rosey Reed 2025-10-13 14:49:18 0.8 hrs 68fbbb7c70557da9f0040976 000020550 3.00 85.00 55.00 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14743 04dbeaba99403f34c1db9c1f1613f4af3a38d69f0ea9f12c833bff1c24ab48ed 6880faf92ef7fc084ca29315 67ced2e87abf9f3ed8fe59a7 Christin Bellian Christin Bellian christinbellian@gmail.com 000076 140 2025-10-13 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. 24+ pt conf cxl SL 10/10 - going to Breckenridge Sophia L. 2025-10-10 15:03:48 -70.9 hrs 6880faf92ef7fc084ca29310 000013967 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14742 9c7bccd3366cb6c7b129ffd775d86f92da230e3b36977f1f9b60c2c3121f0226 68dd5314438639f38359835f 67ced5177abf9f3ed8feee4e Bronna Romanoff Bronna Romanoff bdromanoff@gmail.com 012758 24 2025-10-13 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Rosey Reed - Sonya C. 2025-10-13 14:08:36 -0.1 hrs 68dd5314438639f38359835e 000021837 4.00 171.76 171.76 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14741 fa34e11e3a0ab4a08cb0302ded7483a05e9ff9f45f6f0c24a8fee7b1907189a7 68c3243a43746a079a4a4b3f 68c323cd96546f2c23eb9583 Gabina Salazar Gabina Salazar gabyss2580@gmail.com 019842 56 2025-10-13 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-10-13 14:52:45 0.6 hrs 68c3243a43746a079a4a4b3e 000019581 4.00 100.00 100.00 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14740 d0f2e3bd24d4e30bee8ee165501ae1a81a6e98f9078b568ed8907b40c0b26245 68af675e26c9a3345f8560a7 68221b8507a60c078def4097 Sharon Martinez Sharon Martinez sharon.mama12@yahoo.com 017220 11 2025-10-13 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Secondary - - Yes Sonya C. - Mark Leo Guevarra 2025-10-20 22:20:33 176.1 hrs 68af675e26c9a3345f8560a6 000017884 3.00 95.48 92.38 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14739 39bf24153ff19edbfd49fd522adbcc7276b0e60d9614344e4cf48ebfdc6fbcf4 68e43eba43f13b2bbd09e919 67ced2f87abf9f3ed8fe651a Bruce Carpenter Bruce Carpenter bruceacarp@hotmail.com 001053 125 2025-10-13 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-10-13 14:36:21 0.1 hrs 68e43eba43f13b2bbd09e918 000022448 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14738 7aa26f36e90f2e3fe4449d4f31c4cc5635a3a8e84814c7b953fe7d8e079c6fcb 68d1815434312db589ca2e49 67ced5f17abf9f3ed8ff0d48 Callum Taylor Callum Taylor callumtaylor@me.com 015400 19 2025-10-13 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Samantha Saunders - Mark Leo Guevarra 2025-10-21 16:16:35 193.8 hrs 68d1815434312db589ca2e48 000020461 3.00 82.00 19.00 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14737 158297e20efff0009d99e407ce10c8bc4cccf394db9f120ee98fdf58d32cc344 68a633db4ce27b21b366da5a 68a6315c85a86b3c4dee85e1 Alan Sorota Alan Sorota sorota12@aol.com 017867 18 2025-10-13 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. . Peter Gagnon 2025-10-06 15:21:26 -167.1 hrs 68a633db4ce27b21b366da58 000017010 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14736 9e040c6b831b6613888ca209af605f3a10c2fcd55041b1f1578f6246cd2a2011 689f87d7d5baa307dfd0e662 67ced3f67abf9f3ed8feb968 Sherri Laber Sherri Laber sherri.laber@yahoo.com 008246 27 2025-10-13 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Secondary - - Yes Sophia L. - Rosey Reed 2025-10-13 14:35:38 0.1 hrs 689f87d7d5baa307dfd0e661 000016471 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14735 d8087a4d819fe4311cad37d57ea0794e2690f895591262f35aaada99c3a6cd84 688a4a2f99de3307937a0396 6837463af6142b08391bddd6 Nancy McCoy Nancy McCoy annemccoy27@gmail.com 017327 48 2025-10-13 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt having surgery- sc Sonya C. 2025-09-08 15:15:45 -839.2 hrs 688a4a2f99de3307937a0390 000014774 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14734 eb5f4f422d0321534fd4b80d9f57fee2d492ab72f242f4d65ab35de53f71fea5 6891295c680b2be6d5d950a9 67ced6447abf9f3ed8ff17e6 Richard Wolf Richard Wolf richwolf@infoscapes.com 016305 107 2025-10-13 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. Libby will be out of office Elizabeth Cousins 2025-09-26 15:53:34 -406.9 hrs 6891295c680b2be6d5d950a8 000015337 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14733 7a66965b8553ad578fd51a25269bf4b06836454f6be72d67077530f24557f021 68e913dbcf6575099d895a3e 68dd4ad85586a80982267801 Deborah Correll Deborah Correll dbcorrell@yahoo.com 019966 21 2025-10-13 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-13 14:59:26 -0.0 hrs 68e913dbcf6575099d895a3d 000023010 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14732 f9dd2c452cfa4e0dfec541831c69a915ff84b482f0a67b8812c150522628db55 68d2ec6844c7854b95708bf4 68ae31c602a116dd897f1858 Lucia Karki Lucia Karki lucia.karki@hotmail.com 019749 13 2025-10-13 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Patient - - Yes Emmie Gebhardt - Mark Leo Guevarra 2025-10-17 21:50:46 102.8 hrs 68d2ec6844c7854b95708bf3 000020676 3.00 82.00 81.80 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14731 483b84c3ec3f5213f92775ca057ec1655c26274ad065b2db6d74cf0e6e7ac84b 68d17265152b0c07eaa0b7f3 67ced3d67abf9f3ed8feb244 Joseph Kent Joseph Kent j.mkent@comcast.net 007637 319 2025-10-13 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-10-22 15:59:20 217.0 hrs 68d17265152b0c07eaa0b7f2 000020424 3.00 82.00 77.00 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14730 bc977b3a34ba4086ff9cc0cd14c3e1b85369cc6a37cdc6066aa686484a3ad5a2 68cd8d23623f78d0557a8fee 68cd8c7944260a08a862447a Violet Helsing Violet Helsing nielsentina@yahoo.com 019898 9 2025-10-13 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. pt is not feeling well per Tina N -mw Michelle W. 2025-10-13 14:22:54 -0.6 hrs 68cd8d23623f78d0557a8fed 000020320 1.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14729 54d2c4a7e223da99bcf45500a9076690036ab97c894cdd135649f05556d5cc06 68bf3d8fe40c6bf26cc2e114 68a613fa8d204e08519a4c3c Chandra Beck Chandra Beck chandra.beck22@gmail.com 017845 30 2025-10-13 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Amie Russell - Mark Leo Guevarra 2025-10-22 18:38:21 219.6 hrs 68bf3d8fe40c6bf26cc2e113 000019103 3.00 78.77 78.77 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14728 14d16139cd9ad0a4534263c249e2e0014b066da05ce38f5a84959ada0d5680ab 68ac8641c9c67989e1d00ca9 689264aa22e70f07b2aca32b Kumiko Pentz Kumiko Pentz jpentz1@gmail.com 017754 11 2025-10-13 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-10-13 15:02:25 0.0 hrs 68ac8641c9c67989e1d00ca8 000017376 3.00 80.37 80.37 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14727 c4f927658e7e18b9e242515e455decbda604f5e11ad224ed4e2cd5ea653b8a98 68b9ad2f73eb2a0fe28c89ee 6840939c41546d0bc96f1398 Grace Keeling Grace Keeling keelings@gmail.com 017389 12 2025-10-13 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ Per email request - sc Sonya C. 2025-10-13 03:03:23 -12.2 hrs 68b9ad2f73eb2a0fe28c89ed 000018665 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14726 e4823ff4c0ab59489fa41ea17637b5d5f16edc4c8a5e9d3a8812f5d1a5f9a623 68af2d04b3461907e3aa4d6d 68af2b6bacebc94ce8ed20e5 George Kretke George Kretke gkretke@msn.com 019756 25 2025-10-13 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Michelle W. - Rosey Reed 2025-10-13 15:09:58 -0.1 hrs 68af2d04b3461907e3aa4d6c 000017755 3.00 237.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14725 4c7384cb2bd24b7f0c86f9eb508ae0bb08bd772174c990b0f2b0c7a4858262b0 68a3484ddde57e085fab1d99 67ced3107abf9f3ed8fe720a Robin Davis Robin Davis rdavis5669@comcast.net 002157 126 2025-10-13 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. 24+ - per VM request, she finished her work w/Dawn in Sept. - sc Sonya C. 2025-10-13 11:44:33 -3.5 hrs 68a3484ddde57e085fab1d98 000016526 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14724 e966d7b2d894cca5f774c4480fc6abfd3e456a5b1fe520564c3fac6882760ac8 6890f367c1f7c6e6b3decc64 67ced3c67abf9f3ed8feae45 David Kaslow David Kaslow david.kaslow@du.edu 007296 109 2025-10-13 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Mark Leo Guevarra 2025-10-21 17:49:31 194.6 hrs 6890f367c1f7c6e6b3decc60 000015248 3.00 60.00 65.00 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14723 60f01c2ba77beb5f758048ae409058c06c526656757c8f09b50f3d0e8db4f18e 687e6660564e4807cd3e2556 67ced3dc7abf9f3ed8feb382 Chet Kieffer Chet Kieffer chetkieffer@gmail.com 007743 116 2025-10-13 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. Libby will be on Vacation Elizabeth Cousins 2025-09-08 15:57:06 -839.3 hrs 687e6660564e4807cd3e2551 000013644 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14722 114c035c1e90c50862df0292a343e6f2592e8b81c78ff6cbbd9d5990c18d593a 68d176a4152b0c07eaa0f1fc 68a7419f5ecac95c5376d4cb Regan Kline Regan Kline rak777@hotmail.com 017879 8 2025-10-13 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-10-22 16:01:23 216.5 hrs 68d176a4152b0c07eaa0f1fb 000020439 3.00 85.00 110.50 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10
14721 ebf34376d05f0e5d615e88ebbb42a1b0e6cfd37abc4c1fcf9289a3eaeea870ca 68adf656344cc1979be976eb 68adf51e15d4d207dafad28b Susan Anderson Susan Anderson andersonsusane@msn.com 019745 6 2025-10-13 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Michelle W. - Sonya C. 2025-10-13 15:25:37 -0.1 hrs 69827bd3d9b499e49cd513e0 000017585 4.00 314.00 0.00 - - - - - - - - 2026-02-19 23:03:32 2026-06-11 23:34:10