General Visit (PT Boulder API)

Total rows: 100,726
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
12125 98d7fe37eaedc0cf1981c572c0bdd4af26a19c04837c93f166ae52db052401ee 68ddaca0df6b3708edef6803 67ced3a37abf9f3ed8fea4fa Sarah Hernandez Sarah Hernandez hernandez_sarah@svvsd.org 006503 90 2025-11-03 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-11-03 22:50:02 0.1 hrs 68ddaca0df6b3708edef6802 000021955 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:56:13 2026-05-06 23:21:56
12124 050717967632fd478041c6e6ffdcf2d16b08ecac4e9167657364564bc6b77120 68baf5da24b02a083d156215 67ced48d7abf9f3ed8fed72a Marlo McNulty Marlo McNulty marlo.f.stoll@gmail.com 010784 44 2025-11-03 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Jayson Encarnacion 2025-11-11 15:50:56 185.1 hrs 69135b8d3af01e7fbd743d8b 000018851 1.00 130.00 150.00 - - - - - - - - 2026-02-19 22:56:13 2026-05-06 23:21:56
12123 34f71f79523b8a1154c22e5c2043469a60a6e870d91ff4923e46511e311953c7 68d1d08aca2efd819116ffdd 6896481e1d2a819c6a62a428 Katherine Lightfoot Katherine Lightfoot katie.lightfoot@colorado.edu 017771 44 2025-11-03 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Jayson Encarnacion 2025-11-11 15:58:00 185.0 hrs 68d1d08aca2efd819116ffdc 000020556 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:56:13 2026-05-06 23:21:56
12122 c1159c987100302ddd27fd6963c8328dd105e2314a56030232947940d4c7f30a 6888eb8949ea90083c5d5675 68373ff77dfd39d6d490641b Laura Appelbaum Laura Appelbaum laurarappelbaum@gmail.com 017326 32 2025-11-03 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-11-03 22:49:10 -0.2 hrs 6888eb8949ea90083c5d5671 000014575 3.00 78.70 78.70 - - - - - - - - 2026-02-19 22:56:13 2026-05-06 23:21:56
12121 13eab032b58908a00267187825d81733f59d9f9833ecda98e2feb635bd620bc4 68f6a38a3813ae93939724aa 681a708f5288e5729fbcf929 Cambria Klinger Cambria Klinger pyronymph@gmail.com 017187 17 2025-11-03 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Primary - - Yes Michelle Osgood - Rosey Reed 2025-11-03 23:13:11 -0.0 hrs 6912698278dab437f9b3a296 000024096 5.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:13 2026-05-06 23:21:56
12120 d38b5d806263fc9ec337af3aa9d19ab19c571c3b31cff28fe81b95e72f8a0139 68e686e5c4b4ea295fe58f04 68e685bf76c2ba08a0acfcea Oliver Martinez Oliver Martinez nm002126@gmail.com 020014 8 2025-11-03 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - John Phinney 2025-11-04 01:23:58 2.1 hrs 68e686e5c4b4ea295fe58efe 000022732 3.00 80.37 80.37 - - - - - - - - 2026-02-19 22:56:13 2026-05-06 23:21:56
12119 9339455549f10ca3c9e93ab02f6c527ce17499d61ae1ce02cb61676bebd97ea9 68d6bf4732e82b256a467ffa 684b54dc6c6578079e97b33c Ronald Wittmann Ronald Wittmann wittmannrc@gmail.com 017442 36 2025-11-03 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Rosey Reed - Sonya C. 2025-10-07 22:10:21 -649.1 hrs 68d6bf4732e82b256a467ff4 000021208 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:55:57 2026-05-06 23:21:56
12118 dd73f3e9b1acb343e88a43028d2bfedb73994a21591203e8f0d84f7d356ade64 68f9450cdb00b6c3a7461041 68cc204ce7ec5007a1fb3341 Sytera Field Sytera Field syterafield@gmail.com 019887 12 2025-11-03 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Peter Gagnon - Haley Paull 2026-02-10 22:34:03 2375.1 hrs 68f9450cdb00b6c3a7461040 000024438 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:55:57 2026-05-06 23:21:56
12117 6554974d66a3fe8bc4827a106dde316d8517d31f3e99823ee0c443b822b8447a 68c1d6ec9c003b3ecf18f018 68c1d59dbf83f0d7ca3d3603 Eric Schaetzel Eric Schaetzel evschaetzel@gmail.com 019834 11 2025-11-03 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Jayson Encarnacion 2025-11-10 21:16:53 165.8 hrs 68c1d6ec9c003b3ecf18f010 000019436 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:55:57 2026-05-06 23:21:56
12116 dae554b6f25201fe479e43f3b18ff220cafce7aef2d2d8cfb6ba76ef3397db91 68b9fbd4228fb5401c2ae147 67ced3017abf9f3ed8fe6acc Patricia Bosak Patricia Bosak tbosak1018@aol.com 001539 168 2025-11-03 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Rosey Reed 2025-11-03 23:42:59 -0.0 hrs 68b9fbd4228fb5401c2ae146 000018787 3.00 81.40 81.40 - - - - - - - - 2026-02-19 22:55:57 2026-05-06 23:21:56
12115 5f8e04f4088d238401bcd435ff7c1a4f7f72acc4112bb0a4121ed640981542b3 685ecfeb588c6a085dd5098b 67ced33d7abf9f3ed8fe8449 Gregory Cortopassi Gregory Cortopassi greg@cortoimages.com 003714 77 2025-11-03 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Laura Shove 24+ pt conf cxl - doesn't think he needs it. Made another appt in Jan. Sophia L. 2025-10-30 16:05:48 -103.7 hrs 685ecfeb588c6a085dd5098a 000011091 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:55:57 2026-05-06 23:21:56
12385 e333d8fcaaaa99f039311ff2be9075733581ae9ed9b4a3d32d7198cc2c4f4419 68e9143b00ec063ecc02f326 68dd4ad85586a80982267801 Deborah Correll Deborah Correll dbcorrell@yahoo.com 019966 21 2025-10-31 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-31 13:20:28 0.3 hrs 68e9143b00ec063ecc02f325 000023012 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12384 641cc40c113460e2ec18c1a5a94caba3f4a4f865a335ce497096624e50d943c6 68cd8e4b491fbe0812094e94 68cb2cb2896d4d6d922bbdb8 Darcy Murray Darcy Murray darcy.lutes@gmail.com 019886 10 2025-10-31 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Jayvee Totanes 2025-11-03 16:23:33 75.4 hrs 68cd8e4b491fbe0812094e93 000020326 4.00 120.00 120.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12383 d7d9800950cbe3f210f3391b0b9bbcb1de3b301526e9a516300ebfe66fbcfc8d 68c17f2e488fc607dde194a3 67ced30d7abf9f3ed8fe70d2 Loretta Cheng Loretta Cheng lcheng2828@yahoo.com 002053 39 2025-10-31 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Stephanie Braun - Sophia L. 2025-10-31 13:35:00 0.6 hrs 68c17f2e488fc607dde194a2 000019343 2.00 156.00 0.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12382 de2fc2f555ca849dc920e0213d2ac66177f80b19e5be2391c68ade19ca4c267b 68ff913bf27eac0924470ef4 67ced3f67abf9f3ed8feb968 Sherri Laber Sherri Laber sherri.laber@yahoo.com 008246 27 2025-10-31 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Secondary - - Yes Dawn Singleton - Rosey Reed 2025-10-31 13:50:11 0.3 hrs 68ff913bf27eac0924470ef3 000024865 2.00 -40.00 59.50 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12381 2449850e3136e1c25cb9203aad48485f6d948425a755049563ee18405c1e9e2a 68e6c3130be92409d034ed47 67ced4317abf9f3ed8fec5c1 Sally Martin Sally Martin sallymartin51@gmail.com 009299 18 2025-10-31 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-10-31 13:27:55 -0.0 hrs 69175c9e5dd0ca43050fa80f 000022789 3.00 74.12 75.12 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12380 413d20c39507a2bd33d1a30fb4ccc6c3ccce2211a94f8fea09f167dde8814091 68def8e986a1425b0255f02b 68def7ccf6dc0196720ccae7 Maria del Carmen Marquez'Vargas Maria del Carmen Marquez'Vargas marquez2569@gmail.com 019983 20 2025-10-31 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Jayvee Totanes 2025-11-03 17:49:58 76.3 hrs 6920eb98ea1a5c367da5521f 000022119 3.00 82.00 182.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12379 f4a88d97d3689726f2d1b4feef5577157b15456101742907f8947125b33e1776 68d458413cda52f0bf27b8d3 67ced3f57abf9f3ed8feb95c Stefanie Kyser Stefanie Kyser steffpedals@gmail.com 008242 51 2025-10-31 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia Phillips - Jayson Encarnacion 2025-11-03 19:36:35 78.1 hrs 6909045ebde6301b6f655f54 000020901 1.00 80.00 80.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12378 43ea4bda411d8983ed4bb524b10d15cc20886c04fc8aebed382e3e5ab41617fb 68c1875a1e95d2b5936615c6 6841b65239bb100829b4835c Sara Amodio Sara Amodio drsaraamodio@gmail.com 017397 38 2025-10-31 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ OOT - dad had a stroke- sc Sonya C. 2025-10-23 15:12:05 -190.3 hrs 68c1875a1e95d2b5936615c2 000019358 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12377 c62442e28b45041fc5902382183498ee35f67460b983ea8b58d9e8aca04ef178 6903bfdf06fc3723c553b9b6 689fa18771452007b5c49eae Bryan Hofgard Bryan Hofgard bhofgard4@gmail.com 017811 11 2025-10-31 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Rosey Reed - Kenneth Dave Francisco 2025-11-04 23:36:24 105.9 hrs 6903bfdf06fc3723c553b9b5 000025457 3.00 82.00 80.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12376 7b9bdaa0e342a1ec09c5575c3deefa37a439e0c000ea70c09317fb9401ca579d 68cd669f6e774407b1039a56 67ced3ae7abf9f3ed8fea7cd Mazin Hakeem Mazin Hakeem mazhak@aol.com 006744 30 2025-10-31 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+ pt conf cxl SL 10/28 - can't move until next week Sophia L. 2025-10-28 19:39:02 -66.1 hrs 68cd669f6e774407b1039a55 000020283 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12375 8a50c0b37c7bfa2ec6f6eb06e01e5e318b781129d72af038781790dcb1bbaf17 68f66840034fe7acc45023a6 68f66834034fe7acc450233c Karen McNulty Karen McNulty karen.mary.mcnulty@gmail.com 020105 12 2025-10-31 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - No Sophia L. - Rosey Reed 2025-10-31 13:47:02 -0.2 hrs 68f66840034fe7acc45023a5 000024006 4.00 387.00 0.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12374 e43c77a15733ff7312aa8bf6cbf65a20ce582505f31d137e0fecd807756b8ca1 68d6f453dbf2a3a3b8d89665 68d6f42681f7d675e6168a92 Sandy Cole Sandy Cole graycarchiro@hotmail.com 019943 1 2025-10-31 Cancel 679aeda44d561307f6600a43 Dawn Singleton 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+ Need to figure out POC w/ surgeon - sc Sonya C. 2025-10-20 14:34:05 -263.4 hrs 68d6f453dbf2a3a3b8d89664 000021252 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12373 ffbccee63574dad0d4a1e79ff571bafe6461c67558abb7b606685a1509421fcd 68d2ff3bcdc37d570551d349 68d2fde29de4e7b15063be3d Susan Cary Susan Cary loveds.cary@gmail.com 019922 18 2025-10-31 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Pt needs to see Libby - sc Sonya C. 2025-09-23 21:19:31 -904.7 hrs 68d2ff3bcdc37d570551d345 000020712 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12372 7135e427df75b17205a07e4a7b0c8b9255b98817d4e6aca34ec901488c16e6b0 68cc44976de6103ea52e281f 685b1967d04cdf07db1be800 John Foster John Foster foster.r.john@gmail.com 017517 19 2025-10-31 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sonya C. 2025-11-20 17:11:58 483.2 hrs 68cc44976de6103ea52e281e 000020141 2.00 85.00 125.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41