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
16113 5cff8f5b2958ee2edafc2be1a8bad67d3fd8aab6d5e4ec2af0392a21ed31a2d7 68c3229776aa2268b2fbc360 67ced2f27abf9f3ed8fe6154 Jacqueline Crandall Jacqueline Crandall pjcrandall@gmail.com 000731 6 2025-09-30 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ see chart note Michelle W. 2025-09-29 13:04:47 -31.4 hrs 68c3229776aa2268b2fbc35b 000019572 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:55 2026-06-11 23:37:35
16112 6abc93197983ea8062104909eb1555817877e2919f3790c480a98175ea1e8dc6 68c2eff4c15ff907e934ba48 68558245f66d4507af39692e Kathleen Stjernholm Kathleen Stjernholm katie.stjernholm@gmail.com 017486 21 2025-09-30 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a679a3294b1b37ef18c48c AIM AUTH NEEDED - GET OUTCOME 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. pt sick from infusion yesterday (no fee) - RAR 9/30 Rosey Reed 2025-09-30 20:43:19 0.2 hrs 68c2eff4c15ff907e934ba47 000019514 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:55 2026-06-11 23:37:35
16111 7f7b2356a6cea8211589345a5d78dd6a78733e70d6dd684de75e4173f1c585b6 68c0500b8a128a089e51edb4 67ced5a47abf9f3ed8ff030e Darcy Vanderbush Darcy Vanderbush experiencejoys@gmail.com 014528 34 2025-09-30 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl - RAR 9/10 Rosey Reed 2025-09-10 21:47:27 -478.7 hrs 68c0500b8a128a089e51edb3 000019185 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:55 2026-06-11 23:37:35
16110 603d5a81606f79ebfaa5a0d341d9f8bd2485ccb387486e5384b2612a5de0bf75 68b064c9ed830916f852c2d1 67ced4207abf9f3ed8fec255 Mark Lewis Mark Lewis mark@markpix.com 009007 235 2025-09-30 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Laura Shove - Kenneth Dave Francisco 2025-10-01 21:28:44 25.0 hrs 68b064c9ed830916f852c2d0 000017937 2.00 85.00 85.00 - - - - - - - - 2026-02-19 23:07:55 2026-06-11 23:37:35
16109 023265041941f56719e464011822a16d19da85901d173ece5c496b7d318b4fc9 68a619d4bfdbe307f30a91fb 68a617c36d094004d66b2c11 Allana Ruby Allana Ruby akruby24@hotmail.com 017848 5 2025-09-30 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. waiting to move John Phinney 2025-09-23 21:17:37 -167.2 hrs 68a619d4bfdbe307f30a91fa 000016921 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:55 2026-06-11 23:37:35
16108 a1307f2b1ecf0d09130624cf6a196a027287d26a4c27efa06e8a2248ec8af410 688a72f8eaccd49bfa550fad 67ced3bc7abf9f3ed8feab9c Lucy Judson Lucy Judson lucyjudson1951@gmail.com 007069 82 2025-09-30 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. 24+ pt conf cxl SL 8/27 Sophia L. 2025-08-27 19:05:44 -817.4 hrs 688a72f8eaccd49bfa550fac 000014830 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:55 2026-06-11 23:37:35
16107 4db6aa6f651be8b677bac4438bcb4428bae54394f80ff553ef960e8e8afd6067 68cc4df62462c207a1f1ca1d 68cc4c18f9594426dc3e2122 Courtney Hannah Courtney Hannah courtneyaz@comcast.net 019890 22 2025-09-30 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-30 20:43:38 -0.0 hrs 68cc4df62462c207a1f1ca1c 000020148 3.00 75.05 75.05 - - - - - - - - 2026-02-19 23:07:55 2026-06-11 23:37:35
16106 c4022cf4ec25b0c34701d04237ab979f299f4f7c29928a363ee707e30183f21e 68cafdc7f19d54cea52440ad 68a8156c99c65c4a78a604a3 Michael Platt Michael Platt mnmplatt@comcast.net 019205 4 2025-09-30 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Julie Petersen-Hanson - Kenneth Dave Francisco 2025-10-17 22:08:37 409.4 hrs 68cafdc7f19d54cea52440ac 000020040 3.00 85.00 110.50 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:35
16105 c9c22699915f69299e997747faf5c33aea81d943345e29230935b3cd40638432 68a88c736bda5a077df0ae13 67ced30c7abf9f3ed8fe7057 Anthony Arnold Anthony Arnold arnoldpeter@earthlink.net 002012 99 2025-09-30 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-09-30 20:39:21 -0.1 hrs 68a88c736bda5a077df0ae12 000017219 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:35
16104 75c589ad0c4ce8d473433465a9b93c9b5f5c08e0b033b61e68b3bb47baeaa2f3 68db0845f0c2a9983aed4e1f 67ced4f47abf9f3ed8fee8ad Carol Rhode Carol Rhode juneau1601@gmail.com 012278 172 2025-09-30 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Rosey Reed 2025-09-30 20:58:41 -0.0 hrs 68db0845f0c2a9983aed4e1e 000021583 2.00 56.80 56.80 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:35
16103 f799f68f76ff4242a03ff1abe7b2ff93ac0a09489160180f71fc08161353e3f2 68cc725fff18af0885efc594 68a62ac0870ed4ee268fc6f6 Lynn Walloch Lynn Walloch lynnwalloch@yahoo.com 017859 13 2025-09-30 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Amie Russell - Kenneth Dave Francisco 2025-10-16 21:26:47 384.4 hrs 68cc725fff18af0885efc593 000020221 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:35
16102 de18f5c0b6b9f9b13e577847a02c24ad221699ee9f8589cf23be0a03c29b98d3 68c32ef396546f2c23ebf746 68c32e4d7d1596f365999a7d Arlene Heinz Arlene Heinz arlene.heinz@gmail.com 019844 12 2025-09-30 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Anne Majewski 2025-09-30 21:44:23 0.7 hrs 68c32ef396546f2c23ebf745 000019595 3.00 80.70 80.70 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:35
16101 b89ec469d927e37e6a81b94659f91058f08fce63e267baa6088a350dd314e421 68b9dcfe7d17f6d60f13272f 68af314f5600c5d3177de9fe Brandon Asbury Brandon Asbury brandoboco9@gmail.com 019757 12 2025-09-30 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Kenneth Dave Francisco 2025-10-17 20:24:41 407.4 hrs 68b9dcfe7d17f6d60f13272e 000018739 3.00 85.00 110.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:21
16100 13020d176827e2618019b1c502ff0ce1bb536302f19d74ab4d6790d34e94691c 686da14e843c22571881eec9 683881eb7923430874b4d8ef Amy Webb Amy Webb amyjwebb@comcast.net 017337 8 2025-09-30 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. 24+ pt is OOT -mw Michelle W. 2025-09-25 14:21:19 -126.6 hrs 686da14e843c22571881eec8 000012199 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:21
16099 8581846396f9ad92099014f0989cf9e8997ab7b34105e39df7f6443981af94c6 685060aab18d0207f5310ac6 67ced5a27abf9f3ed8ff02c6 Sarah Sato Sarah Sato swaymire@gmail.com 014504 69 2025-09-30 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Gillian B. 24+ pt conf RAR 9/23 Rosey Reed 2025-09-23 20:46:15 -168.2 hrs 685060aab18d0207f5310ac0 000009477 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:21
16098 86f211f13b197f3785a3b52f258c5e7fbeff9bf498ae8ded9fa87b5f649fa9df 68c9ddd79035697068cb6f9a 68a62957870ed4ee268fbcae Julie Thiesen Julie Thiesen thiesenjulie@gmail.com 017858 7 2025-09-30 No Show 6899858814e44ebdae34c0b7 Rayann Greer 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 689983a679e412ce7c3dfcf6 Westminster Unpaid - Unidentified - - No Rayann Greer - Frances Lawrence 2025-09-30 23:35:27 2.3 hrs 68c9ddd79035697068cb6f99 000019984 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:21
16097 595265a80cc4c749ce978853cdfa6a3ba412fef045fe5891ee0bb00136cff153 68ba0ab2f3bd6d454a535873 67ced3b27abf9f3ed8fea8d5 Nancy Hall Nancy Hall nancy.hall@ptofboulder.com 006832 9 2025-09-30 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-30 21:03:10 -0.2 hrs 68ba0ab2f3bd6d454a535872 000018812 3.00 75.12 75.12 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:21
16096 1673d9c67c1f26ba52a6ef17fbff83183bf9475bd27b6ff8be829c025ac456dd 68a8d333a092db97da10a3f3 68a8d210490b127db69946d6 Hope Morado Hope Morado hopemorado@gmail.com 019733 8 2025-09-30 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. pt is going into labor - sc Sonya C. 2025-09-23 19:16:24 -170.0 hrs 68a8d333a092db97da10a3ee 000017324 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:21
16095 3162e8b7883a59b46084a4d3da80a351bcc9b023e82c311eee197ecfcc6a04f2 689cc75546fccb5a5e8c5a22 684b54dc6c6578079e97b33c Ronald Wittmann Ronald Wittmann wittmannrc@gmail.com 017442 36 2025-09-30 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-30 23:11:19 1.9 hrs 689cc75546fccb5a5e8c5a1d 000016181 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:21
16094 28a2e5197e201475881eaeb94e67c8c2497770dcf3405a11124b3d416f2422fa 68d311c3175f3b10f13ce483 68a746a730f2e93c52681c6a Jacqueline Riseman Detsky Jacqueline Riseman Detsky drjackiesy@yahoo.com 017882 45 2025-09-30 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Julie Petersen-Hanson - Frances Lawrence 2025-09-30 22:18:55 0.8 hrs 68d311c3175f3b10f13ce482 000020743 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:21
16093 effa592b801bf73efe4eb54b692d4d25ef67a405adc9fe7c0f202e64704148ba 68cc3975cb71999847a70086 68472194d172aa9bfb716478 Louise Grauer Louise Grauer louise.a.grauer@gmail.com 017421 11 2025-09-30 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Rosey Reed - Kenneth Dave Francisco 2025-10-01 21:41:58 24.2 hrs 68cc3975cb71999847a70085 000020134 3.00 234.00 35.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:21
16092 d23c33e45027305f8f566f2406bd7bfd3dd2575aa58f5c5a0faf84f97a0ddd1f 688a82bd029a895ed523117b 67ced3e47abf9f3ed8feb589 Maria Klitchman Maria Klitchman elena.klitchman@bvsd.org 007916 30 2025-09-30 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-09-30 21:38:49 0.1 hrs 688a82bd029a895ed523117a 000014845 2.00 100.00 100.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:21
16091 e1dc9bd37915f7c76777ed8bbecae6621566c68ecfcf426e4868f60e77c76c24 687918b64ee9ca082f50c839 67ced35a7abf9f3ed8fe8f01 Marilyn Fausset Marilyn Fausset mbrownfausset@comcast.net 004628 32 2025-09-30 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. surgery Laura Shove 2025-08-12 20:54:17 -1176.6 hrs 687918b64ee9ca082f50c838 000013323 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:21
16090 f43e510c39965a2fe5b0b883abdbb71ff118595e19edc070088159e14a00146c 68c3263b32c6ff08a1ac6bdb 68013f86b4e0078342ef637d Susan Vent Susan Vent sjvent@gmail.com 017077 25 2025-09-30 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-09-30 21:38:46 -0.1 hrs 68c3263b32c6ff08a1ac6bda 000019587 2.00 65.39 65.39 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:21
16089 322a041140817f8cd678b191ed96f2b806bb8d1cc205143fb161e48825205388 68c0b77e28e1fd3ca995b8e0 68b0c782e0928300d23f55be Dayna Sommer Dayna Sommer daynasommertime@gmail.com 019778 6 2025-09-30 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Amie Russell - Kenneth Dave Francisco 2025-10-17 18:06:01 404.4 hrs 68c0b77e28e1fd3ca995b8df 000019338 3.00 119.31 119.31 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:21