General Visit (PT Boulder API)

Total rows: 100,569
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
10203 61a443d82bd3b05a707bcb5814856a2a5a1283e125082c23e59927c6b89dca45 68ed1a7b8bc9f041e0712865 67ced3c67abf9f3ed8feae45 David Kaslow David Kaslow david.kaslow@du.edu 007296 109 2025-11-19 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Rosey Reed - Jayson Encarnacion 2025-11-24 18:50:18 123.1 hrs 68ed1a7b8bc9f041e0712864 000023150 3.00 237.00 15.00 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:51
10202 618840e916cc1e41b520782672aec9398dc8ade5f9e960bd81cff4559c7a8881 68d2f62a1e44c9f888b38097 67ced3857abf9f3ed8fe9ca5 Marilyn Francois Marilyn Francois 2250fran@gmail.com 005792 17 2025-11-19 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Jayson Encarnacion 2025-11-21 21:59:22 54.2 hrs 68d2f62a1e44c9f888b38096 000020685 4.00 82.00 82.00 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:51
10201 6b0d227b5af246752d26c4d433423557701c140f8ce3f9f560ffa51b38585b74 68ae35910a19e69af2e98492 67ced3247abf9f3ed8fe7a68 Carol Cogswell Carol Cogswell cogswell@colorado.edu 002871 146 2025-11-19 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sophia L. - Sophia L. 2025-11-19 16:35:49 0.8 hrs 68ae35910a19e69af2e9848f 000017654 3.00 85.00 72.25 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:51
10200 b1e2a34bccfe9f17b88cf66d1992258b56b20fa430a60f1cd424e2b1696ee5a2 68f7b0331ece9009eb463e5a 68a4e622dd3cb8f81a2b9dbe Vicki Gazdik Vicki Gazdik vickigazdik@gmail.com 017828 22 2025-11-19 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-11-19 16:11:09 0.2 hrs 68f7b0331ece9009eb463e59 000024191 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:51
10199 c34d3b154676dc136ae0a559e7f3378811f343c66e026a75b0d7a88879c9a881 68e6a68f0094c8c3e48d8160 67ced4557abf9f3ed8feccd0 Roberta Osborn Roberta Osborn osenbaugh@hotmail.com 009901 37 2025-11-19 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia Phillips 24+ sch conflict - sc Sonya C. 2025-11-17 16:23:11 -47.6 hrs 68e6a68f0094c8c3e48d815f 000022762 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:51
10198 ceec85dd41348a3fb34370fce9e8fdcca35b9e9364700b9fbd2b9ba22408672c 68dd6d982050a909801ed908 67ced4637abf9f3ed8fecf83 Karla McClure Karla McClure mkmcclure@gmail.com 010131 54 2025-11-19 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Jayson Encarnacion 2025-11-21 16:59:57 49.0 hrs 68dd6d982050a909801ed900 000021885 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:51
10197 c862c1567e599cf55da9b67cc70bcba92afc70ce883b0d6518d4b147ff86f4e3 68d41153744410099d1fedd9 67ced6507abf9f3ed8ff1969 Keiko Yamamori Keiko Yamamori keikoyamamori@aol.com 016434 103 2025-11-19 No Show 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed - Sophia L. 2025-11-19 16:38:21 0.6 hrs 68d41153744410099d1fedd6 000020802 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:51
10196 3343841d6b70b5ac3210df5ce9beb304ab3dd496fd5b684582ed9b8e56fe8f9a 68ff8cc4c9fd81098a46c6bf 67ced5d47abf9f3ed8ff0985 James Voss James Voss jim.voss@colorado.edu 015079 45 2025-11-19 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-11-19 16:11:02 -0.1 hrs 69c5cde24ae031e3572cc0d7 000024855 3.00 75.12 75.12 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:51
10195 a8da45362a85bfe55a370c5cbda14bb4bd45dedf5da43f667c2d8481dcea3f77 68fbbc2aa0dc250911c57a7b 67ced2f87abf9f3ed8fe64e7 Rodney Allen Rodney Allen roddy.allen19@gmail.com 001036 19 2025-11-19 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Sonya C. - Sophia L. 2025-11-19 16:10:34 -0.1 hrs 68fbbc2aa0dc250911c57a7a 000024748 3.00 83.09 66.20 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:51
10194 f58d86090395f683b71c16599fa78c0aef03cf4c962e131b41026874af6c765c 68b8a2b85dfa4104558febef 6895234dd7634722d0f894e3 Julian Alexander Julian Alexander alexandrianlibrary1@msn.com 017768 16 2025-11-19 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. pt no showed Michelle W. 2025-11-19 16:49:48 0.6 hrs 68b8a2b85dfa4104558febee 000018595 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:51
10193 bb298907d8e98154159c04575275bc2614c6e03b8ac08f38ff58a92cc50f4e4e 68b07b67ed830916f8539dc7 67ced34d7abf9f3ed8fe8a3c Barbara Eng Barbara Eng bbeng5843@aol.com 004221 154 2025-11-19 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Sophia L. - Sophia L. 2025-11-19 16:06:47 -0.1 hrs 6920fa086b9d0b21309c54b3 000017966 3.00 80.65 64.26 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:51
10192 0e3d008690c65ce91fa0e6bd38bb38ec1bc113429929cf7162265cec38fb028f 68f27e749871e709add2f99a 68f246d958f71908e4de2f1b Andrew Grant Andrew Grant akgrant23@gmail.com 020094 6 2025-11-19 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-11-20 00:05:42 7.6 hrs 68f27e749871e709add2f998 000023891 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:51
10191 5f8f2e1798d161092a02c3e134d6ab8edc8659acf050f0127cb39db5df1ddff4 68ed285e5a964208e0bfc7c5 68ed27c339b9d509af18c579 Shoshana Chandler Shoshana Chandler shashachandler@gmail.com 020053 10 2025-11-19 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sophia L. - Jayson Encarnacion 2025-11-24 18:21:05 121.9 hrs 68ed285e5a964208e0bfc7c4 000023167 2.00 82.00 65.60 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:50
10190 49a6f35b83c20363cc4fccb5bbcd8ee04d73731916e3e1e9bdfed001311ebe33 68e549fb8b2be4cde2f5121d 67ced5477abf9f3ed8fef598 Laura Rulon Laura Rulon lrulon@yahoo.com 013380 322 2025-11-19 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-11-19 17:25:57 0.9 hrs 68e549fb8b2be4cde2f5121c 000022517 4.00 95.95 95.95 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:50
10189 9c7c6fbbb4dcc55c5d8d1c126d6512c0fcd59730e15613752c938e2adb449c4a 68c1aba8810f1d6160ded8d7 67ced6407abf9f3ed8ff176a Kit Wise Kit Wise kitwise@comcast.net 016264 62 2025-11-19 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed sick Marguerite Barth 2025-11-19 16:16:27 -0.2 hrs 68c1aba8810f1d6160ded8d6 000019398 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:50
10188 117255c33d87de678fbe3db754b35143a4df037776a9db5e4687d9b38b7b6dab 68f2667704cf6556cf256159 68f2666b866fbf5decd64a10 Mary Witcher Mary Witcher mollywitcher@yahoo.com 020097 12 2025-11-19 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Michelle W. 2025-11-19 22:46:48 6.0 hrs 691e1ecbe992068770401875 000023874 4.00 171.76 171.76 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:50
10187 07156cc9713cebd0f2cf194b6a126291c32e53a5f76c9e27d763d52bce6d6c9d 68f1691a97762f457e59fce3 67ced5877abf9f3ed8fefefd Robert Sinton Robert Sinton bsinton@mac.com 014181 37 2025-11-19 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Rosey Reed - Sophia L. 2025-11-19 21:36:41 4.9 hrs 68f1691a97762f457e59fce2 000023837 3.00 80.65 80.65 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:50
10186 1e7cc384125d48a36bd57bb34dcee2317f4e8d7e8243783f826f644d3f7b11e9 690d1682d987e9909559a632 68c323cd96546f2c23eb9583 Gabina Salazar Gabina Salazar gabyss2580@gmail.com 019842 56 2025-11-19 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sophia L. 2025-11-19 16:51:32 -0.1 hrs 6920ed8986985fcb871db4ac 000026336 4.00 100.00 100.00 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:50
10185 7ccfcefffd9ed659e63f3c2d90b695bd83c8b5ecfc8dc003981a735d34ffcd88 68fa85209efb790a07b62d0d 68c323cd96546f2c23eb9583 Gabina Salazar Gabina Salazar gabyss2580@gmail.com 019842 56 2025-11-19 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ stated that she needs to go back to surgeon- sc Sonya C. 2025-11-03 21:05:40 -379.9 hrs 68fa85209efb790a07b62d08 000024583 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:50
10184 d2d49178e32494e42f0d389522b66f2d1c71b1b0e687f9ac8e3d8eb55f885c1f 68f66f49034fe7acc450ef10 67ced5597abf9f3ed8fef841 Rachel Trueblood Rachel Trueblood truebloodelf@gmail.com 013607 240 2025-11-19 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Rosey Reed - Jayson Encarnacion 2025-11-24 19:09:31 122.2 hrs 68f66f49034fe7acc450ef0f 000024010 3.00 238.00 10.00 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:50
10183 769a144d27e554ed1e6366a7c7689cdf8613a80ac3cf9fde6baf2d5d23be4af8 68f12dacc7ae4bfbd7964231 68c85e7310ce867bf21a954a Nancy McNeill Nancy McNeill nancymcneill@mac.com 019855 34 2025-11-19 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Jayson Encarnacion 2025-11-24 19:25:18 122.4 hrs 68f12dacc7ae4bfbd7964230 000023770 1.00 130.00 130.00 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:50
10182 d518ed387bb79553773c5d66712c97ac1efa491cad87cf7d3621ca49a92236fe 68dd60bc4a7b4d7108443697 67ced6627abf9f3ed8ff1baf William Zuromski William Zuromski bjzuromski@yahoo.com 016628 35 2025-11-19 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Jayson Encarnacion 2025-11-21 18:47:29 49.8 hrs 68dd60bc4a7b4d7108443693 000021853 3.00 82.00 16.00 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:50
10181 6f9aa1e9067000fce8db76a487cff7c7a2a822db5991cc286b7b840477a321bf 689cc2fec55113080d93c310 67ced3577abf9f3ed8fe8ded Michele Gerard Michele Gerard braindr2@aol.com 004536 47 2025-11-19 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Sophia L. 2025-11-19 17:09:45 0.2 hrs 689cc2fec55113080d93c30d 000016170 3.00 80.65 80.65 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:50
10180 f13e85bf13a4fb912be08c41f86d28265474e037143b016c917d77e360532d8d 69024490490c1c0997bafd1d 68c9bf5f0a0dc60c1d045231 Amber Williams Amber Williams ambyrlight@gmail.com 019876 11 2025-11-19 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sonya C. - Jayson Encarnacion 2025-11-21 19:27:13 50.2 hrs 69024490490c1c0997bafd1c 000025229 4.00 310.00 30.00 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:50
10179 21ef43b1e1d9733750edf270b2520de9664e7bc3eeec0a41c485f6a54c1cc68f 68e68cba3e8aa1fba7870d28 68e68c236fc6580a094e37ee Marlene Yates Marlene Yates eaglecloudfarms@yahoo.com 020016 11 2025-11-19 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. pt conf cxl - sick SL 11/19 Sophia L. 2025-11-19 15:03:56 -2.2 hrs 68e68cba3e8aa1fba7870d27 000022745 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:37 2026-05-05 23:16:50