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
16073 c0c5d796e7d1e00b5c728bfe3fbab89c73153ed6c7e4d598b71384b63fe40592 68ac74ef6cb0b7c04a3c1ee1 688a83b37d0edf08a27c33e2 David Grant David Grant goblin8u2@gmail.com 017724 16 2025-09-30 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-30 22:14:57 -0.3 hrs 68ac74ef6cb0b7c04a3c1edf 000017355 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:07:54 2026-05-13 23:33:01
16072 81e6adbb3cae75b14032cb97b9937ef99031d4d101b937d30a1c1af7d381e8e3 6893c26400b25407968a6bb8 67ced3487abf9f3ed8fe8867 Lois Edgar Lois Edgar edgar@colorado.edu 004065 236 2025-09-30 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. 24+ pt conf cxl (At home therapy) SL 9/23 Sophia L. 2025-09-23 18:08:08 -172.4 hrs 6893c26400b25407968a6bb7 000015579 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-05-13 23:33:01
16071 baa66f17ab90f0263067f23417b590ae32bfcab6f1483968cf18a594baed6509 684051bfba4f5364e0aee940 67ced3057abf9f3ed8fe6c91 Anita Chakraborty Anita Chakraborty sunbeamuk1@yahoo.com 001690 37 2025-09-30 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Sophia L. 2025-09-30 21:43:29 -0.8 hrs 684051bfba4f5364e0aee93f 000008087 2.00 100.00 100.00 - - - - - - - - 2026-02-19 23:07:54 2026-05-13 23:33:01
16070 b819ac2ef4e4346c6f5112abaed1df40e4d6f7d62ed9bade9fab91588a1eb9b5 68dafcd1b6a6ba918b439e8a 68a499beca96e381ab336765 Natalie St Denis Natalie St Denis natalie@stdenislong.net 017821 54 2025-09-30 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Sophia L. - Sophia L. 2025-10-06 20:46:37 141.8 hrs 68dafcd1b6a6ba918b439e89 000021562 4.00 95.95 95.95 - - - - - - - - 2026-02-19 23:07:54 2026-05-13 23:33:01
16069 47b3656d8f5eff21b4cffab0775b7311615453eed87444a599a06feb80efeb6f 68928dec835e78e7f17007bf 67ced4be7abf9f3ed8fedfb3 Kiersten Pierpoint Kiersten Pierpoint pierpoint_kiersten@svvsd.org 011512 33 2025-09-30 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-09-09 23:15:06 -503.7 hrs 68928dec835e78e7f17007be 000015460 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-05-13 23:33:01
16068 58586f746dcd41ea9afa2462567451cc9202ad36725fd3cf654741b5bc6a56cb 687a744de1e39f0862795266 67ced3487abf9f3ed8fe887c Cheryl Edson Cheryl Edson capn.bob65@ptboulder.com 004072 174 2025-09-30 Cancel 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Completing PT from home- sc Sonya C. 2025-07-25 19:16:01 -1611.7 hrs 687a744de1e39f0862795258 000013506 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-05-13 23:33:01
16067 fa48f60af9106d76fccf9aa5a0d42a1a3523a3d0783ab29ee25cfde2896ea576 686fd269397ab7081d1bb001 686d335baee4b4086fc8a142 Sila Heath Sila Heath - 017583 11 2025-09-30 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. Thought that he cancelled w/ Annie and that they agreed to see her in a month - sc Sonya C. 2025-09-30 22:21:13 -0.6 hrs 686fd269397ab7081d1baffe 000012402 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-05-13 23:33:01
16066 99f463e96ccc58b16f7b1799cd1f8e11ab4f43e4bd5eba17d9118668f9a3d462 6823946ee6f1660780a41715 67ced3247abf9f3ed8fe7a68 Carol Cogswell Carol Cogswell cogswell@colorado.edu 002871 146 2025-09-30 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-09-30 22:50:59 -0.2 hrs 6823946ee6f1660780a4170c 000005410 3.00 85.00 72.25 - - - - - - - - 2026-02-19 23:07:54 2026-05-13 23:33:01
16065 d6ff4556dfdb58f91f85c4d7cebfdf134bd9a060e9a0dc58ef0677aedf7c616e 68a5e5da4f5b4b21d5eff8a6 68a5e4d825566307d108fe49 William Lucca William Lucca cblucca@msn.com 017831 23 2025-09-30 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Primary - - Yes Frances Lawrence - Kenneth Dave Francisco 2025-10-17 18:15:07 403.0 hrs 69ba00797254c57bffa092f2 000016862 3.00 233.00 50.00 - - - - - - - - 2026-02-19 23:07:54 2026-05-13 23:33:01
16064 6912deba709d2c76a678abdcdcc32e2f1750e094701d6d1986f8c18111c99a5a 68acb1253f49ecbe613cd0e4 67ced4de7abf9f3ed8fee50b Donna Racette Donna Racette donnaracette@yahoo.com 011968 89 2025-09-30 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Laura Shove - Laura Shove 2025-10-01 00:12:10 0.7 hrs 68acb1253f49ecbe613cd0e3 000017438 3.00 78.70 62.70 - - - - - - - - 2026-02-19 23:07:54 2026-05-13 23:33:01
16063 1ddb4126a37c5fbf49398a3018b13b4dc9bef021fd6718d76f7cf4efb705ee09 689b54a7a1ade907e2f4104d 67ced5677abf9f3ed8fefa67 Sara Ruwitch Sara Ruwitch sruwitch@gmail.com 013790 31 2025-09-30 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-10-17 18:56:06 403.4 hrs 689b54a7a1ade907e2f4104c 000015981 4.00 126.19 181.19 - - - - - - - - 2026-02-19 23:07:54 2026-05-13 23:33:01
16062 8cdff0e03b3baad5c62144a3711ec6b1cd2042017525aefbf1c1964f40010c79 686d8d102f337e0881931fe8 67ced4727abf9f3ed8fed268 Nancy McGann Nancy McGann nancymcgann@imail.org 010378 45 2025-09-30 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Michelle W. 2025-08-20 13:17:53 -994.2 hrs 686d8d102f337e0881931fe7 000012176 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-05-13 23:33:01
16426 97180608bf51722d5eec5c45cbf047293840eb5781ece470e83ee4f7ac82f02a 68d2fb95912b27c9b9a73690 68d0c9ee8e6ddc2060033d1f Cassandra Bull Cassandra Bull bull.cass@gmail.com 019904 6 2025-09-29 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a679be05de5fabb1c08f2d ASH (CIGNA) OT/PT Initial Evaluation - GET OUTCOME 67a2a0045c4b0cd527adf872 Longmont Unpaid - Patient - - Yes Sophia L. - Sonya C. 2025-09-29 13:08:39 0.1 hrs 68d2fb95912b27c9b9a7368f 000020695 5.00 80.00 0.00 - - - - - - - - 2026-02-19 23:09:00 2026-05-13 23:34:01
16425 24897ef8f58824ec821eb67e78af85947c8f606888f98638feab88435e38427c 68d2e47c78cb5010b3fddff2 68d2e46da836ecd5b3debfc5 Clara Santos Clara Santos santosjclara@gmail.com 019920 7 2025-09-29 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-09-30 15:00:03 26.0 hrs 68d2e47c78cb5010b3fddff1 000020671 4.00 80.00 80.00 - - - - - - - - 2026-02-19 23:09:00 2026-05-13 23:34:01
16424 2e1e566b160660f01479f4863728ffc3140a9da7551e2c6d977264b41022fcc8 68c1a915a84083220674b861 6880f33f283f2e0843200752 Mandi Hutson Mandi Hutson mandihutson22@gmail.com 017678 13 2025-09-29 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Jayson Encarnacion 2025-09-30 18:02:53 29.0 hrs 68c1a915a84083220674b860 000019395 4.00 95.75 95.75 - - - - - - - - 2026-02-19 23:09:00 2026-05-13 23:34:01
16423 775fe62f9d270b37930884a5d2c0ac75ed3bfa4743144b7dfcf15aefdeab81e7 6890c1575fb16e084beace81 688b9e50b561e730dbaffafc Nicole Burns Nicole Burns nicoleburns16@gmail.com 017731 7 2025-09-29 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-09-15 15:56:02 -333.1 hrs 6890c1575fb16e084beace7d 000015200 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:00 2026-05-13 23:34:01
16422 b49b101e0e96daaf0ff13f58774f926618b1958179ec1e256f20d2bafdd1dfdb 688d2f5fad743c0840405f39 67ced3217abf9f3ed8fe791b Lana Clymore Lana Clymore lclymore@gmail.com 002760 66 2025-09-29 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 1x/week Samantha Saunders 2025-09-22 13:36:40 -167.4 hrs 688d2f5fad743c0840405f32 000015180 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:00 2026-05-13 23:34:01
16421 24470a1c95d42a640a62d60d1744172347cffa5a1987158b60b3d2d2a3387c66 68d4c7111d7be9033780dc7d 67e66735efbf2c53d8d60621 Helen Virene Helen Virene chanipaul@proton.me 016899 28 2025-09-29 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Peter Gagnon - Peter Gagnon 2025-10-01 02:36:42 37.1 hrs 68d4c7111d7be9033780dc7c 000020947 3.00 233.00 0.00 - - - - - - - - 2026-02-19 23:09:00 2026-05-13 23:34:01
16420 336c06304a6fde3e82c18e9a806efef30fdc516ba954821605b0005c23efe119 68c18611af2d0e08a1f6a649 68a878f1dbb256308f3d0560 Mercedes Giveans Mercedes Giveans Mercedes@ptboulder.com 019724 8 2025-09-29 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-29 13:33:15 0.1 hrs 68c18611af2d0e08a1f6a646 000019348 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:09:00 2026-05-13 23:34:01
16419 4de70eaefde05498d2adfc4e0c0d4935a09c9e2ca63c9f37ec9ad9288a0cc332 68bb16f538034493465e4c52 687a95e9e9301707d8e07673 Dale Kishbaugh Dale Kishbaugh kishbaughdale@gmail.com 017655 8 2025-09-29 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Hope Adair - Kenneth Dave Francisco 2025-09-30 16:11:42 26.7 hrs 68bb16f538034493465e4c51 000018908 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:08:44 2026-05-13 23:34:01
16418 f4eae7b0c092c1cf9c80e3c1863f21b591629d306b73b47106ad627753cd16b7 68b852039a04b20823dbaeb9 6888e114dc80142d6a2c2097 TM Frey Morris TM Frey Morris drpiefrey@mac.com 017716 29 2025-09-29 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Michelle W. - Michelle Osgood 2025-09-29 13:37:24 0.1 hrs 69c71ee907e49130023d6168 000018481 3.00 228.00 0.00 - - - - - - - - 2026-02-19 23:08:44 2026-05-13 23:34:01
16417 cf053c24c98601408f4f58f69fa8275c8ab5f68f8370ef3e213435467af5d055 689a21de235a96077c176676 689a215725ee00a9358909d3 Louise Pearson Louise Pearson wingedpickle@mac.com 017776 6 2025-09-29 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. Patient sent message via PTE needing to cancel appointment Dawn Singleton 2025-09-28 19:06:54 -18.6 hrs 689a21de235a96077c176671 000015925 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:08:44 2026-05-13 23:34:01
16416 a03d56e37b4f1024aa1f9a36b47b9c9f24838fd08f983499cddc3778761b31e0 68d15c21ff655a680b058f6d 67ced3457abf9f3ed8fe8753 Tedi Dupont Tedi Dupont ettdup@gmail.com 003973 25 2025-09-29 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-29 14:46:50 0.8 hrs 68d15c21ff655a680b058f6c 000020382 3.00 81.66 81.66 - - - - - - - - 2026-02-19 23:08:44 2026-05-13 23:34:01
16415 76dd1bc4d98bba657130466531628848dad6aa01a29c6a66107ec966f294ab39 68c9ab0e0a0dc60c1d039840 68489a57f839a307c1be27be Rita McCurry Rita McCurry mccurryrita@gmail.com 017434 18 2025-09-29 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes John Phinney - Sonya C. 2025-09-29 13:50:38 -0.2 hrs 68c9ab0e0a0dc60c1d03983f 000019905 3.00 80.26 80.26 - - - - - - - - 2026-02-19 23:08:44 2026-05-13 23:34:01
16414 bfb4d94437bdbb1dbe88c9be9a7f4b2b6e9b53cd708b33d7193ce00011960285 68c870c8becaa4023b7253a8 684855e5778dab0797732b59 Patrick Hiester Patrick Hiester patrickhiester@gmail.com 017427 21 2025-09-29 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Rosey Reed - Peter Gagnon 2025-10-01 02:40:16 36.7 hrs 68c870c8becaa4023b7253a7 000019813 3.00 60.00 40.00 - - - - - - - - 2026-02-19 23:08:44 2026-05-13 23:34:01