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
16673 a4e5296f18fd64c1ae0592e7df77bac5e182fa8aacb3d1c5fcbcf353c2b56e76 68bf26157661c5037ba37249 68a5f331cc00ec0894e708c3 Sandra Squires Sandra Squires ssquires2@comcast.net 017835 32 2025-09-25 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Amie Russell - Emmie Gebhardt 2025-09-25 15:43:39 -0.0 hrs 68bf26157661c5037ba37248 000019069 3.00 75.12 75.12 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:50
16672 d4dc6461951ae142602dab9f98746970a7a4b6c6173892711ff8922caca12b1b 68a8a291ab4a7ea757ca8bb7 67ced4de7abf9f3ed8fee517 Joan Raderman Joan Raderman joan@circleofcareproject.org 011972 42 2025-09-25 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Maia H. - Sonya C. 2025-09-25 15:53:33 0.1 hrs 68d6e70ca7272966fffa88a1 000017254 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:50
16671 3e5132c9611fd46cd389e5e0c34f505508db57d03161cf2894c75c69394181ac 685d689510240ca9c352e716 67ced3e47abf9f3ed8feb574 Sarah Kline Sarah Kline sarah.kline@tracegains.com 007909 37 2025-09-25 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sophia L. - Sophia L. 2025-09-25 16:21:23 0.6 hrs 685d689510240ca9c352e715 000010897 4.00 95.71 72.01 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:50
16670 96394e74b957c1a9f928c1bb16a0b6a749826fca085e5631579d54effead2e0c 6851a8eefebf870839f84771 6851a78603dd08c79cf7942c Alexandra King Alexandra King alexandrawaterman@gmail.com 017463 37 2025-09-25 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Jayson Encarnacion 2025-09-26 15:49:26 24.1 hrs 6851a8eefebf870839f8476c 000009632 4.00 95.95 95.95 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:50
16669 190a0632f9686f68e266fc83c031ab338362249ec7cf6d38cca650599d286ef2 68a7530545d2d5cf96fc0d7d 67ced2e97abf9f3ed8fe5a7f Susan Benson Susan Benson susan.benson52@yahoo.com 000148 116 2025-09-25 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Sonya C. - Sonya C. 2025-09-25 15:52:43 -0.1 hrs 68a7530545d2d5cf96fc0d7c 000017091 3.00 80.26 63.94 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16668 40f73be66074515dbc733301a5991f0c3e76e608b461a16353a022307fc70939 689f87b09e365d6ea0cfa1ea 689f865f86088c9243dfeae8 Hollie Hardman Hollie Hardman holliehardman@gmail.com 017808 26 2025-09-25 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-11-06 18:55:53 1010.9 hrs 689f87b09e365d6ea0cfa1e8 000016470 4.00 95.77 95.77 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16667 9ac49358772a38e4ce9a3962e71fc470e9984be550457a6676eaa2a555ff918a 68b1d6ee3697f09a45731c98 68a8152599c65c4a78a5f6b1 Mary Griffin Mary Griffin marymgriffin@comcast.net 018517 38 2025-09-25 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Frances Lawrence - Frances Lawrence 2025-09-25 16:16:25 0.0 hrs 68b1d6ee3697f09a45731c97 000018177 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16666 800487fff0821b853474e7ab0133ade02f2c00b07372b7a10631fe3f3e494850 6890fe7534738607a3dbe9d7 68406e2f4540440824476dfb Jaleen Hooper Jaleen Hooper jaleen220@gmail.com 017383 8 2025-09-25 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Emily Pickner - Sophia L. 2025-09-17 17:04:43 -191.2 hrs 6890fe7534738607a3dbe9d6 000015269 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16665 10d5006e30c37b57a066aa019bf6449c4631b4bae830e69ac4b352a9fc77c401 6877d022f83a450870bcb3df 67ced3327abf9f3ed8fe8029 Jennifer Dingman Jennifer Dingman devding@msn.com 003362 37 2025-09-25 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Ranjini Ridgway - Mark Leo Guevarra 2025-09-26 15:30:19 23.3 hrs 6877d022f83a450870bcb3de 000013165 3.00 84.92 84.92 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16664 6996f4917224235ee255ca18c91c0b3499a590adbc291a6b96f72a93bcc77190 6862fe022ac8410797a39ff0 67e1258d54aaaa3a80096cc0 Jonas Wills Jonas Wills jonaswills@gmail.com 016776 20 2025-09-25 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a679a3294b1b37ef18c48c AIM AUTH NEEDED - GET OUTCOME 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-09-25 15:51:20 -0.4 hrs 6862fe022ac8410797a39fef 000011357 4.00 85.00 85.00 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16663 13b529e22e8c419777147e60b78b77053175b1c63701d5d2a1c9fab87972872f 67e67191ceb9f104f028c536 67ced3617abf9f3ed8fe9141 Gregory Glass Gregory Glass glass.greg@gmail.com 004820 11 2025-09-25 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Dawn Singleton - Sophia L. 2025-09-25 16:21:16 0.1 hrs 67e67191ceb9f104f028c535 000151695 3.00 85.00 72.25 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16662 70a4b421fb7a87f7c71118c4bd3b26ae2457f0f2eadb7289060ddeccae3c4faf 68d1c0a08c72b8e028cd306b 687660311feff75b1eccb122 April Smiley April Smiley aprils327@gmail.com 017629 23 2025-09-25 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Rosey Reed - Kenneth Dave Francisco 2025-11-13 16:02:19 1175.5 hrs 68d1c0a08c72b8e028cd306a 000020533 2.00 107.70 122.70 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16661 04d22fc31f35203f3b3989ffebcfec76e10d70b48bd505cabaa4ca0bc2b5937c 68c2e44d75e1f4087db4091e 67ced30a7abf9f3ed8fe6f5e Mia Davies Mia Davies miadavies2705@gmail.com 001929 25 2025-09-25 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. called @9:51 to cxl today's appt - she is ill- sc Sonya C. 2025-09-25 15:52:26 -0.6 hrs 68c2e44d75e1f4087db4091d 000019505 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16660 3527a13a9d1e982ee55ab05bdaf7afe8cb791a5e63cd59170220dfaaf9aa727e 68b9c55809a34b8b62d15333 67ced47b7abf9f3ed8fed3f4 Mary McHugh Mary McHugh maryemchugh@gmail.com 010510 31 2025-09-25 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Sonya C. - Jayson Encarnacion 2025-09-26 15:13:26 22.7 hrs 68b9c55809a34b8b62d1532f 000018690 3.00 237.00 10.00 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16659 9db3927d937e80b3085d3542a91392087a0c7dcdbc489da698904be22e828c18 689ba8a1f8b9fe0786902d76 689ba7c5d5e35daf6d4da252 Martha Johnson Martha Johnson woyi28@yahoo.com 017785 9 2025-09-25 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-09-08 13:25:39 -411.1 hrs 689ba8a1f8b9fe0786902d71 000016054 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16658 0c236cb9e3fc4e9d616b3bd6b9194def3b1e7c0759b4865463ff6fa3390e9e94 689b58514bf9e107b7742feb 67ced47b7abf9f3ed8fed3f4 Mary McHugh Mary McHugh maryemchugh@gmail.com 010510 31 2025-09-25 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ sc Sonya C. 2025-08-26 15:14:48 -721.3 hrs 689b58514bf9e107b7742fea 000015988 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16657 96f196647b68cf08e43239442e52e8fb035200ada4dd12f66e401fab3ac6a25f 68b2161250b03f0801b36ff8 68b2155e8466c5ad9200267e Heather Stephany Heather Stephany hleierman@gmail.com 019784 11 2025-09-25 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-25 16:45:36 0.0 hrs 68b2161250b03f0801b36ff3 000018268 4.00 128.42 96.31 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16656 efa4d432aafe45d9411d401821f9bc5558f95fc5132bbaf09db239b9d4bab3ce 687fbb32ac9c1a07c348ead2 67ced57c7abf9f3ed8fefd65 Barbara Stephens Barbara Stephens barbaramstephens@gmail.com 014045 133 2025-09-25 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Ranjini Ridgway - Mark Leo Guevarra 2025-09-26 15:34:35 22.8 hrs 687fbb32ac9c1a07c348ead1 000013817 4.00 105.23 105.23 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16655 7910f295b05add69a1b69cb08a233b5b54b2d094379f6985fe39c0eec662e4c4 687fa5ff0774a0938dc29100 67ced3ea7abf9f3ed8feb6c7 Laura Kohlerschmidt Laura Kohlerschmidt lkohlerschmidt@gmail.com 008022 73 2025-09-25 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a67875c9d2cdd464578564 ACN OT/PT Initial Evaluation - GET FORM AND OUTCOME 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. OOT - sc Sonya C. 2025-09-25 13:55:55 -2.8 hrs 687fa5ff0774a0938dc290ff 000013756 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16654 df39e009fd5793a8e26a895bfc27338a8bb3f5a572cf36dd37eaaeb8b7a91e44 68cc770cbafb6ef90f633612 68cc76ea387ef00863351b5e Jana Erdener Jana Erdener jana@erdener.org 019893 6 2025-09-25 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Sonya C. - Jayson Encarnacion 2025-09-26 17:38:33 24.6 hrs 695e8843718d48096b175c5d 000020230 3.00 304.00 20.00 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16653 9e182056c5676896a4743550e78a5d99a257f472d52c1965fb68301ae71e8d76 68c1acba1d0131c264508a64 68c1930a6bee0ad7960db662 Sevina Wood Sevina Wood sjowood@gmail.com 019828 5 2025-09-25 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 9/11 Sophia L. 2025-09-11 17:56:24 -335.1 hrs 68c1acba1d0131c264508a63 000019401 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16652 d5607238e69a9dd7a7b19bcd20d4239ae369f4d962ff861ba7fea56437a7c631 68c0a734120b33f4e7b7387c 68c0a610723a36ba29db4e08 Katherine Patton Katherine Patton kateleepatton@gmail.com 019827 2 2025-09-25 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a679be05de5fabb1c08f2d ASH (CIGNA) OT/PT Initial Evaluation - GET OUTCOME 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Frances Lawrence - Mark Leo Guevarra 2025-10-07 15:15:57 286.3 hrs 68c0a734120b33f4e7b7387b 000019298 4.00 147.52 147.52 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16651 f1c0bedb6cc1bdadafcde7072ef6b9e29b172f5f4de99746ba4fa0768ebe0d41 68b08aa9cfa7743e87590cf5 68a5df6f0a9ff4d6b25f77d0 Randall Harrison Randall Harrison rharri4145@gmail.com 017829 20 2025-09-25 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sara Thompson - Emmie Gebhardt 2025-09-25 16:51:22 -0.1 hrs 68b08aa9cfa7743e87590cf4 000018011 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16650 a6924fec1cfc1e582d3f7d6a0d9455d3de52dc6d9be78eb9ab010b52cdac9d6c 68a76a533fb82189c2f45aec 68a623b4537f40216dc1da81 Alice Lucchesi Alice Lucchesi aalucchesi@comcast.net 017851 8 2025-09-25 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sara Thompson - Emmie Gebhardt 2025-09-25 17:01:52 0.0 hrs 68a76a533fb82189c2f45aeb 000017127 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49
16649 40f7a24cbf0633e0c63028a75b3afd8390d9d5ad9281a37224ce30cb3e7ea68d 688ce1d9e03b95c45022e2c7 6866cb894d9eded6714b83ba Ann Liggett Ann Liggett ann.liggett5@gmail.com 017570 38 2025-09-25 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-25 17:06:01 0.1 hrs 68dd41c6b3b61d09d5c4008c 000015098 3.00 77.56 77.56 - - - - - - - - 2026-02-19 23:09:34 2026-06-11 23:38:49