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
24474 9768c45595613fd1ef3f95f66dd5b9cc1bad0e6040089eb60c4ba7acc8e68c3c 68701aa1f3c238c3a3a7e3e1 67ced44a7abf9f3ed8feca93 Kathlyn Oltmans Kathlyn Oltmans theoltmans@comcast.net 009710 62 2025-07-22 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Laura Shove - Laura Shove 2025-07-22 21:37:43 0.1 hrs 68701aa1f3c238c3a3a7e3e0 000012506 2.00 62.51 62.51 - - - - - - - - 2026-02-19 23:31:58 2026-06-11 23:58:38
24473 094f9ebbc18c84fa5cb94655e90ea68b60c5b31af266b7d83d8281e128dcf6f3 685eb3272dbc640811360984 685eb205588c6a085dd42cad Elisa Podhajsky Elisa Podhajsky lisapodhajsky@gmail.com 017535 6 2025-07-22 Checked Out 683aa08158eaf318442499e4 James Fowlkes 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Sonya C. - James Fowlkes 2025-07-22 21:33:46 0.1 hrs 685eb3272dbc640811360980 000011050 4.00 60.00 50.00 - - - - - - - - 2026-02-19 23:31:58 2026-06-11 23:58:38
24472 2b87c16e642ca3ff946101b80e4b62d43e77589a7c9ced1cb8c49496c70065cb 68406c1cf8d02711fc29f380 67ced3067abf9f3ed8fe6d09 Connie Champ Connie Champ conchamp@me.com 001730 6 2025-07-22 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 6/19 Sophia L. 2025-06-19 15:37:44 -797.9 hrs 68406c1cf8d02711fc29f37b 000008122 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:58 2026-06-11 23:58:38
24471 af3009e7c8ce3282810e7fba5ea04e665c2e5f839b9e7cc6bcb5865d4cf7d86d 6822788822eac7088b2b7d3d 67feac5dc2341907fb9d58ee Jennifer Lindsey Jennifer Lindsey jennyjane1947@gmail.com 017062 7 2025-07-22 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Eva Tucker 24+ pt conf cxl SL 7/14 Sophia L. 2025-07-14 16:48:33 -196.7 hrs 6822788822eac7088b2b7d3c 000005297 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:58 2026-06-11 23:58:38
24470 6f8108f3ec1cdb4e52732dda00af0c7f8b585c86177bd1ed20570e746c7c7775 67e67222ceb9f104f028eb92 67ced5457abf9f3ed8fef556 Michael Spizzirri Michael Spizzirri mrspizzirri@gmail.com 013358 31 2025-07-22 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton Eva out sick - sc Sonya C. 2025-07-22 19:25:29 -2.1 hrs 67e67222ceb9f104f028eb91 000151921 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:38
24469 b140ded6ffa321062c21176803981a646449dd8c890c94b816bf09a627b9b218 68703eb77d25e907b3aba4d9 68599286ed08c1df3c5041eb Katherine Robertson - Mazur Katherine Robertson - Mazur katie.jay3@gmail.com 017504 43 2025-07-22 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-22 21:53:46 0.1 hrs 6888d4d72657b207f7052f5c 000012576 4.00 95.95 95.95 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24468 d447b0b97b495a832427478debdc332b392f6ab03b7a741e1933d22e705996f9 685eff41a88649740b7a1352 685efe8487e5939a4605944f Callie Maron Callie Maron callie.maron@gmail.com 017542 8 2025-07-22 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Anne Majewski 2025-07-22 17:20:08 -4.4 hrs 685eff41a88649740b7a1351 000011222 2.00 85.00 85.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24467 123e5d395a241608b43a4e3b9e1649861837dfc03aa752c188b8bf02bffd82e9 685efe8e138ccaa93268d76c 685c13569b296107804f0caa Judith Jessup Judith Jessup judyejessup@gmail.com 017520 21 2025-07-22 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Gillian B. - Ranjini Ridgway 2025-08-19 18:28:32 668.7 hrs 688045b18a0f42fc75cd7348 000011218 4.00 99.00 99.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24466 453c695412ba23c52feaf504beddb44af62dc2c4b999f4c322268c925d08400f 685d5ccde6dd200873a6d24f 685d5aff10240ca9c3528579 Robin Vaughan Robin Vaughan robinlv88@gmail.com 017528 71 2025-07-22 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Michelle Osgood 2025-07-22 22:44:08 1.0 hrs 6880f40bea26da0783f2bbc2 000010876 4.00 102.16 102.16 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24465 59854e7f5e04e17a54ff5462be402a94e5bdda1beb464120c93446826c01ce85 6859901037a31edf6287596e 68598f3286524007d8885056 Rebecca Fellows Rebecca Fellows rebeccafellows@msn.com 017503 4 2025-07-22 Checked Out 682ca33c115b6e82fb427e49 Sarah Emrey 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Sophia L. - Sarah Emrey 2025-07-22 21:46:52 0.0 hrs 6859901037a31edf6287596d 000010313 3.00 83.09 66.20 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24464 eb8ab54ab0056ca961da31fb9f9f6630b89414de06a0a1d264a993eafdf87599 6850382ee1988b077a96b355 685036ee837be607f336383d Shiv Sharma Shiv Sharma swami.shivbharti@gmail.com 017449 11 2025-07-22 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a67ab091753108089752a5 RTM READY 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 7/21 Sophia L. 2025-07-21 15:11:57 -30.6 hrs 6850382ee1988b077a96b351 000009409 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24463 90485bbae3487c901094bf52685844427260f4094b6f3af99f8a5ea9fc665d48 687939385179bbcac2e310ae 680fc55aff733807cc7b7d4a Katherine Whiteman Katherine Whiteman katie.bimacgroup@gmail.com 017143 8 2025-07-22 No Show 683aa08158eaf318442499e4 James Fowlkes 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. - James Fowlkes 2025-07-22 22:21:54 0.4 hrs 687939385179bbcac2e310ad 000013392 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24462 5ddf09e3aeac5c52053d42bf708b10f59ed41d36548dc76deee6369458a5fa0d 68766ffbe230508047f3421d 67ced6587abf9f3ed8ff1a56 Dean Zadak Dean Zadak deanzadak@gmail.com 016513 19 2025-07-22 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Secondary - - Yes John Phinney - Sonya C. 2025-07-22 21:51:43 -0.1 hrs 68b9de7bfbbbe608561640ea 000012944 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24461 bb56b3e285c43caee70ee6d8e895b8213b7cccb5df8faf0c248cb092e93dd3c8 685dc9b08c4d39082c3a8334 67ced5197abf9f3ed8feeea2 Joe Romig Joe Romig jromig@ponderosa-assoc.com 012786 15 2025-07-22 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Maia H. 2025-07-18 20:39:14 -97.3 hrs 685dc9b08c4d39082c3a8333 000011029 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24460 139d38e5e65f04cadf5fbb819ea0e1ae03fc1c2bb635e280f30a3efe43c2e4d6 685052001dbcd862ed62a20b 67ced3207abf9f3ed8fe78be Sharon Bailey Sharon Bailey markandteriking@msn.com 002729 24 2025-07-22 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-22 22:01:11 0.0 hrs 685052001dbcd862ed62a207 000009459 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24459 f1e570cb3ec35d66ea3fd098ca4a64e115ef066d55e4c150e6437d9229c40be4 683f16c9de2dcc07bd8bc518 67ced5807abf9f3ed8fefde6 Sophia Updike Sophia Updike smupdike1@gmai.com 014088 69 2025-07-22 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Gillian B. - Allison Reyes 2025-06-27 18:07:54 -603.9 hrs 683f16c9de2dcc07bd8bc517 000007882 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24458 cf72ffa644b856aecfd52f5d71f1246f0ceced355c7d5ce4c13b067e58d5e45c 683765b7aaae2f07a2218663 67ced3e17abf9f3ed8feb4cc Jennifer Kirk Jennifer Kirk jenniferjkirk@comcast.net 007853 24 2025-07-22 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 7/21 Sophia L. 2025-07-21 22:37:37 -23.4 hrs 683765b7aaae2f07a221865e 000007283 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24457 2b7db255e68cfd00bb6df37757937b3fc08eb910859c0912abb999653b1cd636 67e67226ceb9f104f028ec9a 67ced39a7abf9f3ed8fea2b4 Stacey Gurr Stacey Gurr sngurr@gmail.com 006309 217 2025-07-22 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Dawn Singleton - Laura Shove 2025-07-23 00:21:17 2.4 hrs 67e67226ceb9f104f028ec99 000151927 4.00 -120.05 95.95 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24456 95188d188fe82cbbdf310689fe4bac57404ed27a3577aa84833c18b583c64696 6830d4660d3dfb08294912f9 6830d345583d150774ae2652 Katie Kessler Katie Kessler katie.spellman@gmail.com 017305 14 2025-07-22 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Anne Majewski 2025-07-22 17:20:11 -4.9 hrs 6830d4660d3dfb08294912f4 000006857 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24455 d01720eab595a8ba29a48814674ce51c769167178e162f2b1ce46f94f08e6eef 686fef67179d30c8c7e2f695 67ced3ef7abf9f3ed8feb7d5 Megan Kram Megan Kram krammegan23@gmail.com 008112 43 2025-07-22 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sonya C. - Ranjini Ridgway 2025-07-24 20:56:56 46.4 hrs 686fef67179d30c8c7e2f690 000012456 3.00 232.00 25.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24454 fe60975a07ee5ec447942f9dffba6a71f3188c67a845f143c91222100a9df326 685444b6c4acfac7f74f9a45 6835dc433e74d508214726a7 Gregory Ingraham Gregory Ingraham gregoryingraham0@gmail.com 017309 9 2025-07-22 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-22 22:33:44 0.1 hrs 68a4c50bf724ca8f58fcb4a7 000009950 3.00 81.96 81.96 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24453 c8ca126cbf981fcdf19c315f70fa9b066ea9700a1205ad63cb9caeeae6a46897 68471f0b0dce47f5bff49d0b 67ced4e67abf9f3ed8fee65e Catherine Rauer Catherine Rauer cathy.rauer730@gmail.com 012081 7 2025-07-22 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ - see pt note Sonya C. 2025-06-26 19:37:15 -626.9 hrs 68471f0b0dce47f5bff49d0a 000008739 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24452 9f8445fb0ae59b29140435b22429729173021670297ae683c5188c55cefa5398 68430c18bc178807f2ad35a5 68430a198c453108154a9837 Eve Beilovei Eve Beilovei evebeilovei@gmail.com 017409 9 2025-07-22 Checked Out 683aa08158eaf318442499e4 James Fowlkes 67a679a3294b1b37ef18c48c AIM AUTH NEEDED - GET OUTCOME 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - James Fowlkes 2025-07-22 23:04:00 0.6 hrs 68430c18bc178807f2ad35a4 000008547 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24451 8405a87dbd2e29849aa43e7e9e40d3d43da11073d741e6905f8e9b9650215699 683622762a6dd40784d97400 67ced56d7abf9f3ed8fefb34 Brian Steege Brian Steege bsteege@gmail.com 013858 57 2025-07-22 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-22 22:22:59 -0.1 hrs 688290aac821f807f1a09e93 000007083 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37
24450 118fd4a81faae2471644527db60c96d684142d0df7a6d134aed46a2735ecea8d 687033561fec0b6e3dd7326c 67ced45b7abf9f3ed8fecdf1 Candice Morris Candice Morris morris_candice@hotmail.com 009997 14 2025-07-22 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Eva Tucker Eva out sick today- sc Sonya C. 2025-07-22 14:16:33 -8.5 hrs 687033561fec0b6e3dd7326b 000012561 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:41 2026-06-11 23:58:37