General Visit (PT Boulder API)

Total rows: 100,908
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
13042 8607d1a256102ceab6376930666d00132c861a3a7168bfcbe610df3b04ff001e 68ac9fdd73a16b9b688abe53 67ced5f27abf9f3ed8ff0d51 Ralph Wappel Ralph Wappel rwappel@gmail.com 015403 38 2025-10-27 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Emmie Gebhardt 2025-10-27 16:26:58 -0.1 hrs 68ac9fdd73a16b9b688abe4e 000017418 3.00 78.70 78.70 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13041 2d34d765a8febb653961870194969b6ca58f1148eb31adcdc7a1d837c7bde6e8 688bb85270b54993569dfa0b 67ced5597abf9f3ed8fef841 Rachel Trueblood Rachel Trueblood truebloodelf@gmail.com 013607 240 2025-10-27 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Maia H. - Mark Leo Guevarra 2025-10-29 20:58:30 52.5 hrs 688bb85270b54993569dfa08 000014986 2.00 159.00 10.00 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13040 9c4f1a51cb4afa91117903a7bbf24f0be5d42a866b46f7cb8cc17c4194082a06 68cc3dc5c5afb244d3f4a4a3 6806972243b7fe84d4f9f04c Glenda Russell Glenda Russell gmrussell5@hotmail.com 017099 48 2025-10-27 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia Phillips Sophia out of office-sc Sonya C. 2025-10-27 13:16:00 -3.5 hrs 68cc3dc5c5afb244d3f4a4a2 000020136 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13039 f7642700f7640d60e0f6e9ceac5f4fbff6fb666284725db01adc5f2a7cfbc351 687fa83c95c6c05c50965aef 67ced3ea7abf9f3ed8feb6c7 Laura Kohlerschmidt Laura Kohlerschmidt lkohlerschmidt@gmail.com 008022 71 2025-10-27 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-28 13:57:05 21.2 hrs 69038e6b95f36a0941a2d698 000013765 4.00 82.00 65.60 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13038 ca622c045f35d68640dcf516e04d79b1eed4a2eb0f8fd7d57c5892abd577e483 68dc4d65c1e0fa097a5471a2 67ced3a17abf9f3ed8fea4ac Kristina Jensen Kristina Jensen kgraceco@icloud.com 006477 7 2025-10-27 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Anne Palma 2025-10-31 15:08:20 94.1 hrs 68dc4d65c1e0fa097a5471a1 000021733 4.00 73.01 73.01 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13037 a537b68a64fe7bcd087d4d9fb010f201cbef778da4cd4eb87e97f76f52934134 68a8c45cfc757507747faf52 68927a5581dca5077cc2ae98 Dianne Inglis Dianne Inglis Diannecinglis@icloud.com 017757 30 2025-10-27 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. pt conf cxl SL 10/27 - dizzy and unwell Sophia L. 2025-10-27 15:21:38 -1.6 hrs 68a8c45cfc757507747faf51 000017308 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13036 a1187d60fd76b00849bee60fbfe86970b19f46b484479b703f8bf36a777049d2 68893155337f8b083fabe10f 67ced4d77abf9f3ed8fee3f1 Gail Promboin Gail Promboin burnboin@msn.com 011874 124 2025-10-27 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Unidentified - - No Maia H. - Rosey Reed 2025-10-27 16:50:00 -0.2 hrs 68893155337f8b083fabe10e 000014673 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13035 c43e2f22c3489ce090940c08115304d3000e7b5dda31b547057d0eb75d27250e 68657762d5b0000c266761fa 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-10-27 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Gillian B. - Gillian B. 2025-07-02 19:33:52 -2805.4 hrs 68657762d5b0000c266761ee 000011655 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13034 76d238c7b7f556e8312d528ad643e9aae5fb2210c951652627a0447e466cbecf 68502ef59189370889e4ade0 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-10-27 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Gillian B. - Rosey Reed 2025-10-27 17:04:18 0.1 hrs 68502ef59189370889e4adcc 000009352 5.00 390.00 0.00 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13033 a4791ea86a18b0bf75e7f69cf8b329512e4324cf4231a295920f2ef0b5c14ab9 68ff928d45427708eb7cd9b1 6830b48e8df562d524fd9c8a Judith Oehler Judith Oehler judyo@hotmail.com 017304 20 2025-10-27 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Frances Lawrence - Anne Palma 2025-10-30 19:06:19 73.9 hrs 68ff928d45427708eb7cd9b0 000024868 4.00 82.00 82.00 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13032 742c61b43b47de62ea5f734545173fcee076baba685eb4ca5d799fb880c94351 68ed298bf50c6ec0a455f263 684840b5f839a307c1ba93c5 David Wynja David Wynja chris@wynja.com 017425 13 2025-10-27 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - System 2025-11-17 07:00:44 493.8 hrs 68ed298bf50c6ec0a455f262 000023172 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13031 dd92b702632fa483a12e5834e0de01a4754a54fd649e2035a3229a6abc8b3a5d 68e43ef13b8c4a09adb7823b 67ced2f87abf9f3ed8fe651a Bruce Carpenter Bruce Carpenter bruceacarp@hotmail.com 001053 125 2025-10-27 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sonya C. - Peter Gagnon 2025-10-30 15:55:24 70.7 hrs 68e43ef13b8c4a09adb7823a 000022449 3.00 81.40 64.85 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13030 101d85c15257a0107c3be2c4e823679ffa4934fed9ec994b14e87e0abfbb479e 68dfdb7afbc56209797b2c95 67ced2f87abf9f3ed8fe64e7 Rodney Allen Rodney Allen roddy.allen19@gmail.com 001036 19 2025-10-27 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Sophia L. - Rosey Reed 2025-10-27 17:16:25 0.0 hrs 69024547e5287c11309f948c 000022140 4.00 103.39 82.37 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13029 b2034ece3099d4d139aa3fefde32000f255ce8f3453225a35dc78a1dc801846d 68d5b7cca9040793a65bc78f 68bb1405f45d4ebac1e95a47 Joelean Lambrecht Joelean Lambrecht jnjlambrecht@yahoo.com 019805 42 2025-10-27 Cancel 689a30c929b2b7d86495c1c4 Amie Russell 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Sara Thompson scheduling conflict, will reschedule Frances Lawrence 2025-10-26 13:28:46 -27.8 hrs 68d5b7cca9040793a65bc78e 000021119 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13028 45df610f6135a25d03dd136dc4e7cf3fd09a2a301ab0fbd882048d61b091698b 68b9c3b372432b0784f9aa66 6893cf46991c8a07b5078073 Denise Froning Denise Froning denisefroning@yahoo.com 017764 15 2025-10-27 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Emmie Gebhardt 2025-10-27 17:12:01 -0.0 hrs 68b9c3b372432b0784f9aa62 000018687 4.00 95.48 95.48 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13027 d4629064f0ed0d4ce730713245e27263dce837c6c9191d35352c3180a0fd562e 6883ba9c66b5e807d7a63602 67ced50e7abf9f3ed8feece0 Amy Schlotthauer Amy Schlotthauer harmshauer@hotmail.com 012636 45 2025-10-27 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Miranda Samson - Miranda Samson 2025-10-27 18:46:24 1.5 hrs 6904fd8ac66c580a118ccf75 000014382 3.00 77.82 77.82 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13026 72722694ada551e654560a34f233cf0c9539ba9ad224db8f27013a5c77a34233 68ed69019dc06508a42f3dc3 68a8153699c65c4a78a5fa31 Charles Izurieta Charles Izurieta charles.izurieta@gmail.com 018691 18 2025-10-27 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. Sophia out of office-sc Sonya C. 2025-10-27 13:18:52 -4.2 hrs 68ed69019dc06508a42f3dc2 000023240 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13025 afb5ba3d6b327740bff89a1da2936aabae8429c5ead500e822be8fcada7cd467 68daa2d72690198acf02f24f 68d5987de4b79f09d2a8f2d2 Sukru Ergin Sukru Ergin erginsukru@gmail.com 019933 24 2025-10-27 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-10-27 17:35:05 0.1 hrs 68daa2d72690198acf02f24a 000021295 5.00 154.00 154.00 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13024 501b6be652a25cd14dcc073df76f9e69c57b02aa4efb0c5fd8da9627d1b92ffd 68d18730c3c70408c5612206 68221b8507a60c078def4097 Sharon Martinez Sharon Martinez sharon.mama12@yahoo.com 017220 11 2025-10-27 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. - Sophia Phillips 2025-10-13 14:20:34 -339.2 hrs 68d18730c3c70408c5612205 000020474 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13023 b84a57f32a3cdb483b5f850d4cc28da92a89917c4750d9db647e91db8055489b 688a5f3e99de3307937ad733 67e1258a54aaaa3a80096c69 Kenneth Chan Kenneth Chan kennethsaichan@gmail.com 016747 16 2025-10-27 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Emmie Gebhardt 2025-10-27 17:31:36 0.0 hrs 688a5f3e99de3307937ad72e 000014814 3.00 77.82 77.82 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13022 25e34b89d6a0d1d36232ce720090440d01f2c5aea25155f5b4bc9df172ddbfe1 6894e6e19e87024d9e1f2028 67ced5197abf9f3ed8feeea2 Joe Romig Joe Romig jromig@ponderosa-assoc.com 012786 15 2025-10-27 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Rosey Reed 2025-10-27 17:44:20 -0.0 hrs 6894e6e19e87024d9e1f2027 000015727 3.00 81.40 81.40 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13021 338b46d93f21c3b7a4602afba2230dd859cbba667265fd78f2fabd6ce2b99801 68f688b2a12b4908bc29ac15 67ced5917abf9f3ed8ff005c Sally Sandusky Sally Sandusky sally@csico.net 014298 35 2025-10-27 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-28 13:57:09 19.7 hrs 68f688b2a12b4908bc29ac14 000024059 3.00 77.82 77.82 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13020 ee0d4c0d9afafccce6567fc8c16bf64a326da299d4a9645926ab3ac7bbb6a6c9 68daa8aab76a99c70e9b2127 68a613fa8d204e08519a4c3c Chandra Beck Chandra Beck chandra.beck22@gmail.com 017845 30 2025-10-27 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sara Thompson - Mark Leo Guevarra 2025-10-29 20:38:06 50.4 hrs 68daa8aab76a99c70e9b2126 000021319 3.00 82.90 82.90 - - - - - - - - 2026-02-19 22:58:44 2026-05-07 23:24:53
13019 c5bc6d1f610f41b119a1a7b11ecbb1a470eeeb4d1da3d8cab4ebb491616a8b06 68cc6c52c06536085e885dae 67ced5917abf9f3ed8ff005c Sally Sandusky Sally Sandusky sally@csico.net 014298 35 2025-10-27 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. 24+ Out of town - sc Sonya C. 2025-10-20 19:06:54 -167.1 hrs 68cc6c52c06536085e885dad 000020193 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:58:28 2026-05-07 23:24:53
13018 7aaae4a4be2a5d44084320613c1cf54be8797b356ddb6563a53805f7952c9a37 6893da994b76da5b183f4014 67ced5ef7abf9f3ed8ff0d00 Susan Tauger Susan Tauger susantauger@yahoo.com 015376 268 2025-10-27 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. Per email - "My mom (Susan) still has fluid on her lungs" - sc , Sonya C. 2025-10-27 11:57:28 -6.3 hrs 6893da994b76da5b183f4013 000015669 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:58:28 2026-05-07 23:24:53