General Visit (PT Boulder API)

Total rows: 101,513
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
16861 be7167a01e48d301e971aa57ddc86a48630714f62f1f90ef49569fe20a8743bf 68a36c950a2270a2a78516f2 67ced2e87abf9f3ed8fe59a7 Christin Bellian Christin Bellian christinbellian@gmail.com 000076 140 2025-09-24 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Sophia L. - Samantha Saunders 2025-09-24 14:57:40 0.5 hrs 68da97a754521b08eacde773 000016551 3.00 89.00 85.00 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16860 62d0abfe191bcf23a8ddb9a12caee17329a21f85ea813659c6b6cabdced7611d 6893863fcf55ab0806450667 68938556431f72084b4993c3 Thomas Sheldon Thomas Sheldon tsheldond@aol.com 017762 26 2025-09-24 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Sophia L. 2025-09-24 15:14:23 0.7 hrs 68d40e2301338ffa94172066 000015499 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16859 1705f2f077cdf9d8859821213f9d07b5ab7d37073e6c843085c616fe6aa8b89e 687154890686fb29f020e035 67ced46c7abf9f3ed8fed124 Mary Moulton Mary Moulton mgmoulton@gmail.com 010270 57 2025-09-24 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 9/17 Sophia L. 2025-09-17 17:42:59 -164.8 hrs 687154890686fb29f020e034 000012677 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16858 b9eb2fded8a7b90ab4d9009817acc713ff3a4634b1744716491b61d342f68f39 68715185bd72dd08083088b2 67e1258954aaaa3a80096c24 Katharine Moulton Katharine Moulton kmoulton22@gmail.com 016724 41 2025-09-24 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. incorrect patient - sc Sonya C. 2025-07-11 18:08:30 -1796.4 hrs 68715185bd72dd08083088ad 000012667 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16857 56b879f4f3a658b79b405034b324542ce380dcf11bd6b089b12dc63d1d682c47 686fdbc80a571efbe796fefa 67ced4207abf9f3ed8fec255 Mark Lewis Mark Lewis mark@markpix.com 009007 235 2025-09-24 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. out of town Laura Shove 2025-09-17 15:02:57 -167.5 hrs 686fdbc80a571efbe796fef6 000012422 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16856 05261a4451dd9d34488525478d8eb792a5eedf3efa8ca4123ef1c053e8d921d4 68d2f3f4980f2591d0b06142 67ced3bb7abf9f3ed8feab84 Robert Joyet Robert Joyet robertajoyet@msn.com 007061 62 2025-09-24 Checked Out 67c8f28f945598c08d4245c7 John Phinney 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-24 14:43:40 -0.0 hrs 68d2f3f4980f2591d0b06141 000020678 4.00 171.76 171.76 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16855 70c7bf740c502bc8822c26356ba6c4f1d9e16aa5d356dd5825b5254b02d1f712 68a6339adbe19fe62869245e 68a6315c85a86b3c4dee85e1 Alan Sorota Alan Sorota sorota12@aol.com 017867 18 2025-09-24 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-09-24 14:37:22 -0.1 hrs 68e416c08c179f26f0ce44ea 000017007 3.00 80.26 80.26 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16854 8115f80e967c69654d441c0b698cd9e85ff47b30f3405ccae677d7f1b68e44a1 68cdecb8d85930106fca2e26 67ced3597abf9f3ed8fe8e7a Connie Farnbach Connie Farnbach the.farnbachs@comcast.net 004583 177 2025-09-24 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Marguerite Barth OOT Marguerite Barth 2025-09-22 21:28:00 -41.5 hrs 68cdecb8d85930106fca2e25 000020372 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16853 6c285086bf5326ee5c62c35f9a8d3eefd6020d5fa4e1700176de958af974853c 68a5ee8a085907081abf0df4 67ced6507abf9f3ed8ff1969 Keiko Yamamori Keiko Yamamori keikoyamamori@aol.com 016434 103 2025-09-24 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Rosey Reed 2025-09-24 15:05:44 0.1 hrs 68a5ee8a085907081abf0def 000016887 3.00 66.44 66.44 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16852 62a83637dc1e3e3a7ee6ad7dd7982498ff56a7920bb9573c02e348d1874fa6f6 6893d144c36d7ce665ef7c0a 6893cf46991c8a07b5078073 Denise Froning Denise Froning denisefroning@yahoo.com 017764 15 2025-09-24 No Show 68535c6303dd08c79c018795 John Reed 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-09-24 15:20:50 0.3 hrs 6893d144c36d7ce665ef7c09 000015650 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16851 3575e8a8c51fef0caba946c0cc4ce26bd761c232771112828daf25d8991c0f28 688baa31aba5ef08079db82b 685c3896f0873207fda55cbe Crystine Margolis Crystine Margolis margolismom@aol.com 017524 17 2025-09-24 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Rosey Reed 2025-09-24 15:02:16 0.0 hrs 688baa31aba5ef08079db82a 000014968 3.00 80.26 80.26 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16850 50391796cb3445bd1425eecf20fd7bbc334fe699092cfb3302620cb6aa46b876 6864516c6fc5eb214982d59a 67ced4637abf9f3ed8fecf83 Karla McClure Karla McClure mkmcclure@gmail.com 010131 55 2025-09-24 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Gillian B. - Mark Leo Guevarra 2025-09-25 18:18:59 27.3 hrs 6864516c6fc5eb214982d595 000011519 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16849 94260d3e47daace756c9270182557c0db096c6d32a9b5d45be705ddbea5f71d5 68557688fa24df076410e5df 67ced34d7abf9f3ed8fe8a3c Barbara Eng Barbara Eng bbeng5843@aol.com 004221 154 2025-09-24 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Maia H. - Rosey Reed 2025-09-24 14:56:51 -0.1 hrs 68557688fa24df076410e5d9 000010099 3.00 81.40 64.85 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16848 1b0fd2f42c005f1308259d58b14e2400d38cc78dad37f03694968282c548e0f3 68cb296e3302f26d457ece27 68a8158499c65c4a78a6092e Stuart Smith Stuart Smith smitstu@gmail.com 019428 5 2025-09-24 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Julie Petersen-Hanson - Frances Lawrence 2025-09-24 16:20:36 1.1 hrs 68cb296e3302f26d457ece26 000020088 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16847 72686efc13acd2a43078f9a846a10f932e18950e16ccec3b897733c4f079aecf 68af6b40fd4e04080d7173ff 68af6a35384e0f03c4c88f9e Denise Kosciusko Denise Kosciusko dkosciusko@gmail.com 019766 23 2025-09-24 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-09-25 18:41:06 27.4 hrs 68af6b40fd4e04080d7173fe 000017888 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16846 ff71e69bd311df8e9cc19185f8de1fad8c71ac307c4c834a4328fa36e59625cb 6879297a9a594c0768d7aedc 67ced3487abf9f3ed8fe88a6 Anne Edwards-Turnacliff Anne Edwards-Turnacliff turnacliff@comcast.net 004086 100 2025-09-24 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Ranjini Ridgway 24+ pt conf - RAR 9/16 Rosey Reed 2025-09-16 14:38:57 -192.6 hrs 6879297a9a594c0768d7aedb 000013349 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16845 7eb8c28624af4efac4f34152951cc5bcd120c84c843f75db9f4e015a9cca1300 68782a43518f6ed719202729 67f9602ca72fbb50374a4725 Renee Hopper Renee Hopper reneehopper@outlook.com 017038 20 2025-09-24 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-09-25 17:46:46 26.5 hrs 68782a43518f6ed719202727 000013289 3.00 85.00 85.01 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16844 69d0cd429c3cd3176efbdee2940909b1cb06b35803bba8bfed60794e7ff7f0d7 686e9210b6da685afdd53e35 67ced3c47abf9f3ed8feadcd Janet Kariya Janet Kariya desra019@gmail.com 007256 53 2025-09-24 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Stephanie Braun - Sophia L. 2025-09-24 15:13:17 -0.0 hrs 68d455da1cff87f5b6052f6b 000012266 4.00 136.86 136.86 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16843 bddddf20dd91e8386156c4cb05aa3446b8d73ed7e86b556ee1d9a2dd4e1c804b 68d40e71eeaf57c45156d001 6893cf46991c8a07b5078073 Denise Froning Denise Froning denisefroning@yahoo.com 017764 15 2025-09-24 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-24 15:30:16 0.0 hrs 68d40e71eeaf57c45156d000 000020798 4.00 95.95 95.95 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16842 ec573fe03cc5cb8afcbab2eedcd9fa1426244926949d7a71b1816acb55765dbd 68c881338319ea112193f3cc 68c880399ec5d41f375d6e58 Lynn Hildebrand Lynn Hildebrand lynn.hildebrand@colorado.edu 019861 17 2025-09-24 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Rosey Reed - Mark Leo Guevarra 2025-09-25 21:38:51 30.1 hrs 68c881338319ea112193f3cb 000019827 3.00 235.00 20.00 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16841 1502940a158ed2ce3eec8455ba166a1b6c6a7a7f7d3025e4c17f5ab87bee0823 68a64de84f240338440d21ee 67ced3397abf9f3ed8fe82d2 Kim Copeland Kim Copeland kccopeland28@gmail.com 003589 45 2025-09-24 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Secondary - - Yes Sonya C. - Peter Gagnon 2025-09-24 16:28:55 1.0 hrs 68a64de84f240338440d21ed 000017018 3.00 236.00 0.00 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16840 0adbdcb19d9baa4823827e59810e970646e82960b3d86211844ddc0889982d50 68b8a42ade05962b56b58d79 68518846e818be07f5bf4fd9 Lawrence Johnson Lawrence Johnson saredagj@mesanetworks.net 017458 29 2025-09-24 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-09-25 18:20:35 26.6 hrs 68b8a42ade05962b56b58d74 000018600 3.00 130.00 130.00 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16839 02c62f04317a6419e1886d65b65bb0daecb4aaf6d9f0069462c50ec8abeb0a8b 68b21e385f80eac85430de1e 68b21dbc59d70d07a54d46e2 Emily Gebhardt Emily Gebhardt emilydreyer@hotmail.com 019785 4 2025-09-24 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-09-25 21:32:31 29.8 hrs 68b21e385f80eac85430de1d 000018273 5.00 95.00 95.00 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16838 8ffde86434e4393c778b0ce006e5c82cd997d75160f53f54d2ada26f177ca831 687a9532131290f381d6d95e 687a93bbf31feff2b5c844cd Shane Brown Shane Brown shane.brown@colorado.edu 017654 26 2025-09-24 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24+ sc Sonya C. 2025-08-25 19:40:11 -716.1 hrs 687a9532131290f381d6d95d 000013558 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02
16837 8fb3a86542155803c607dcc5030d99a87a40ea8427508dffec0846e413d4543f 687a914728505e07a8fa806b 67ced61c7abf9f3ed8ff12de Debra Topping Debra Topping dbtopping@comcast.net 015876 152 2025-09-24 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Rosey Reed 2025-09-24 16:00:48 0.3 hrs 687a914728505e07a8fa806a 000013552 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:10:07 2026-05-13 23:35:02