General Visit (PT Boulder API)

Total rows: 99,414
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
92615 24c54ddf1e31938be0faac1eff1c4d8b994444c27315b4300963a21c30906205 69399b2f65406ddbf18ffa12 690a2953dccc549c80c7cde1 Zachary Smith Zachary Smith zacharyxandersmith@gmail.com 020193 11 2026-02-25 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 1/28 Sophia L. 2026-01-28 15:02:31 -672.0 hrs 69399b2f65406ddbf18ffa11 000030272 0.00 0.00 0.00 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92614 8927cf04927a6b220c6d9f768a5d709789dc69f399f4f2c211b27d3bc3570133 69249bf979302696103ede16 67ced6507abf9f3ed8ff1975 Julie Yang Julie Yang julie.yang@ptofboulder.com 016438 47 2026-02-25 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Haley Paull 2026-02-25 22:07:16 7.1 hrs 69249bf979302696103ede12 000028200 3.00 82.36 82.36 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92613 fe1dc148a0d12d261bb9ac5a1f9a1d76c3e68c083c98e077d621e2adc9cbf214 68f8e859a1d87f0a26a53416 67ced3577abf9f3ed8fe8ded Michele Gerard Michele Gerard braindr2@aol.com 004536 47 2026-02-25 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Haley Paull 2026-02-25 16:00:28 1.0 hrs 68f8e859a1d87f0a26a53410 000024347 3.00 80.56 80.56 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92612 b52f086bc87f3ecc2860f9e8e3e6c316baef58edd8b243fb3fda0de67a9766b2 699759efdc5b193c66a50a1e 68542b28a1c53a74b1edcff4 Rosemarie Foster Rosemarie Foster rmpfphd@gmail.com 017477 30 2026-02-25 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Anne Majewski - Sonya C. 2026-02-25 15:20:31 0.1 hrs 69c57e403daa30aeafc4eee4 000038319 3.00 85.12 67.82 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92611 df931eadb15e6b92ae454cdbfc5b89ce6f1518dca1977f803dc4bb4fd88ac3f7 698e352405454887621a14c9 68a8150599c65c4a78a5f02f Janelle Cluff Janelle Cluff jcluff@gmail.com 018193 8 2026-02-25 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sonya C. - Mark Jerome Para-ase 2026-03-13 16:26:36 385.2 hrs 699f822257b9f07ccd5937e1 000037444 6.00 82.00 82.00 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92610 111978e31d4163f851e09c43cce9b9f4f3673e64b522635cfec518eb91eae6fe 6940855ff3b9929a01c6a750 6882ab38922db9ad884da2ad Elizabeth Deshaies Elizabeth Deshaies deshaies.elizabeth@gmail.com 017703 21 2026-02-25 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Christian Kenneth Abungan 2026-03-03 16:42:17 145.5 hrs 6940855ff3b9929a01c6a74f 000030826 5.00 95.00 95.00 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92609 b79914a5a4612802b87704c16ffe95ef7441018715a3b5f433ef3cd70ec8a06c 6984b7cef2fceb1ab653744b 68f1004186869fdb1f3148aa Jerry Crisafulli Jerry Crisafulli jtcrimpson@gmail.com 020083 18 2026-02-25 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Michelle W. - Christian Kenneth Abungan 2026-02-26 20:20:39 28.8 hrs 6984b7cef2fceb1ab653744a 000036627 3.00 82.00 82.00 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92608 4e558752d280a5d1583d14f92eed5e01a8422883d5806b27bb5956f5693f6804 697a36a2b3ee243cf6280d63 697a3594647cd21e465f9005 Alyssa Mriscin Alyssa Mriscin amriscin@icloud.com 020646 9 2026-02-25 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Laura Sage - Christian Kenneth Abungan 2026-02-26 19:30:49 28.0 hrs 697a36a2b3ee243cf6280d5e 000035678 3.00 85.00 85.00 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92607 a34c81de3917d897a90bc086eb364666c5402702518f2b129fe1f1457853ca42 695e851d67414f7b9856a19b 68ffd3c83a5099793b1a6a05 Diane Fear Diane Fear djfear96@gmail.com 020152 13 2026-02-25 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 2/18 needs to see her MD LS Laura Sage 2026-02-18 19:31:19 -164.0 hrs 695e851d67414f7b9856a199 000032858 0.00 0.00 0.00 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92606 3edc57d3a6212262bee2a94d5afe559d68aeec0d9d42995c4286b9f86fc67cdb 695d9b3782293c1594a98359 695d9a1be276777a0ac7bcd5 Ashley McGillivray Ashley McGillivray ashleymcgillivray12@gmail.com 020468 17 2026-02-25 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Renee Carr - Mark Jerome Para-ase 2026-03-12 18:14:16 362.7 hrs 695d9b3782293c1594a98358 000032831 3.00 85.00 85.00 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92605 96e897eba0b31949d1780898b3cb70496157224dbbc10f6ec647a64beade9bb7 69496cbe7f7dd7dacf863805 67ced3d37abf9f3ed8feb184 Christine Kemp Christine Kemp christywkemp@gmail.com 007573 135 2026-02-25 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Renee Carr - Christian Kenneth Abungan 2026-03-03 18:40:18 147.2 hrs 69c693ba2cd19963700069a9 000031456 3.00 64.32 64.32 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92604 2f28b9d6c1e2287c097b93a99dea0ad50301a8ac265ca9a4fa9995927b8c5669 6941c4d53d6de90e6bc78031 67ced4177abf9f3ed8fec075 Jane Manning Jane Manning jhmanning5@gmail.com 008847 90 2026-02-25 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Mark Jerome Para-ase 2026-03-12 17:27:46 362.0 hrs 69b2f7bfa146bf996c72b3a6 000030968 3.00 82.00 82.00 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92603 b4a66e955f685fdd29fa1dc737a2a35c193060e87e9d3604d607389f3fe99cf4 6998b9b453ff41833fcbab2d 68e4165d3b8c4a09adb5fc36 Lisa Selhorn Lisa Selhorn lisa.ritacco@gmail.com 020000 15 2026-02-25 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sonya C. - Mark Jerome Para-ase 2026-04-03 21:38:07 893.9 hrs 6998b9b453ff41833fcbab2c 000038521 4.00 314.00 19.00 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92602 4ec5ecabe3ae946bb6919069ef22d1ee647ac951a196105bc4222c25b662744d 6967d891805c8d72d8752264 6966922c721a458e35c08f0b Ann Humble Ann Humble awhumble@msn.com 020502 6 2026-02-25 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Laura Sage DC 2/18/26 Miranda Samson 2026-02-18 16:20:56 -167.4 hrs 6967d891805c8d72d8752263 000033666 0.00 0.00 0.00 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92601 3e408a37b7487f4ec8024e16e2e2480c7aeebb2153eed512fd64705ce08d17b8 69651f1aba857c2aae4beb47 67ced57b7abf9f3ed8fefd50 Robert Ukeiley Robert Ukeiley rukeiley@biologicaldiversity.org 014038 28 2026-02-25 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle W. 2/23 - hp Haley Paull 2026-02-23 16:47:32 -47.0 hrs 69651f1aba857c2aae4beb46 000033275 0.00 0.00 0.00 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92600 79ab61c04603dacf2247abd9f14350d1bfe6feb2214b75731fca000cf39dc084 691632212cfc546a56aa3320 67ced4207abf9f3ed8fec255 Mark Lewis Mark Lewis mark@markpix.com 009007 235 2026-02-25 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 2/24 pt cxl appt, "long story" will make his Friday 2/27 appt Haley Paull 2026-02-24 19:55:55 -19.8 hrs 691632212cfc546a56aa331d 000027167 0.00 0.00 0.00 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92599 41fe1a97e4b391d632c5aa4a998bea77bdcca10af67c54f523645a1de83ea4c7 699f1d2c925e8fe73ab8673d 67ced4d87abf9f3ed8fee421 Richard Przywitowski Richard Przywitowski dick_lois@comcast.net 011890 83 2026-02-25 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2026-02-25 16:04:46 0.1 hrs 699f1d2c925e8fe73ab8673c 000039125 0.00 0.00 0.00 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92598 75b31feaa057cbb8c6ed48118a39058d675f969f6619bc9795b6d1ecf2c51f4c 699cbbfce1f6b121fad88c99 69384198af2c7a253e30fcec Roger Krimstock Roger Krimstock roger.krimstock101@gmail.com 020351 8 2026-02-25 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Sophia L. - Mark Jerome Para-ase 2026-03-12 22:05:16 366.1 hrs 699cbbfce1f6b121fad88c98 000038793 3.00 237.00 10.00 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92597 fb06fac6b54835806e71cc360a0ea208cb7540c63cdc07c42ac0256d43bb9ad7 6995f5cacfb71292fa8a1305 69160f6351c428d308c9ac08 Norman Chapin Norman Chapin machisapin@gmail.com 020240 20 2026-02-25 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle Osgood - Christian Kenneth Abungan 2026-03-03 18:49:04 146.8 hrs 6995f5cacfb71292fa8a1304 000038087 2.00 82.00 82.00 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92596 c6a61899a781b968efea9a7b13740d4cc204ecb1cd56fc5674bcf96ab7003df1 698a4cccd525dd9fb19973f4 698a4bc1fc9f6e2cad549a58 Pamela Reynolds Pamela Reynolds pamreynolds170@gmail.com 020715 7 2026-02-25 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Christian Kenneth Abungan 2026-02-26 19:35:35 27.6 hrs 698a4cccd525dd9fb19973f3 000037043 2.00 82.00 82.00 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92595 87993376b33dcd38e607312ceea2b4da6dc89c7bd39c500c52656d7e44be3968 697a56eb8d0f2d86cc5e651e 696fc7950aa6c393a758c48c Richard Brummer Richard Brummer atlr9138@gmail.com 020588 15 2026-02-25 Checked Out 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - Sonya C. 2026-02-25 16:02:14 0.0 hrs 697a56eb8d0f2d86cc5e651a 000035734 3.00 235.00 0.00 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92594 ec12e0d0f6ba67bcb63431edf1488a874d1e9ac8b809330a1d53314d89a86f5d 6961192151306f527a5ea53e 67ced4d87abf9f3ed8fee421 Richard Przywitowski Richard Przywitowski dick_lois@comcast.net 011890 83 2026-02-25 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2026-02-25 16:04:38 0.1 hrs 6961192151306f527a5ea53d 000033140 3.00 82.42 82.42 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92593 6f9505bad51814e2065a68ae0b3e1c84ed61b8b2c5318ce9d56810e69f7a23f7 69272eab1875efcd0827fde7 67ced4637abf9f3ed8fecf83 Karla McClure Karla McClure mkmcclure@gmail.com 010131 54 2026-02-25 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. kids are sick today - sc Sonya C. 2026-02-25 15:17:48 -0.7 hrs 69272eab1875efcd0827fde5 000028971 3.00 0.00 0.00 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92592 33aad613970b109a2986ba2a66888653da6ebd16f48f3d6dafec2fa134cab82a 69977c0931b6d3cb80c72388 67ced52e7abf9f3ed8fef1db Andrea Sedlmayr Andrea Sedlmayr andreasedlmayr@gmail.com 013061 92 2026-02-25 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Laura Shove - Haley Paull 2026-02-25 16:12:54 -0.0 hrs 69977c0931b6d3cb80c72387 000038368 3.00 80.56 80.56 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27
92591 54121e91ce1aa23164f29fab016445a2c3e571748ca78ebac3cf0d431ce9fb6c 699735f4d21d2abed2702fdb 696695b7eb514eeb8895de6e Jeffrey Ditges Jeffrey Ditges jeff@source-communications.com 020503 9 2026-02-25 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Patient - - Yes Eva Tucker - Michelle W. 2026-02-25 16:17:15 0.0 hrs 699735f4d21d2abed2702fda 000038248 3.00 82.36 65.62 - - - - - - - - 2026-02-25 22:26:01 2026-04-25 22:48:27