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
15553 bdddab0bea3a5e36ab0d2f2314f27d9ef7c93a723d8c87a8bf7ab6184a87e0f2 689f873bc93793087b4e15a9 67ced3f67abf9f3ed8feb968 Sherri Laber Sherri Laber sherri.laber@yahoo.com 008246 27 2025-10-06 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Secondary - - Yes Sophia L. - Rosey Reed 2025-10-06 15:20:15 0.8 hrs 689f873bc93793087b4e15a8 000016466 3.00 -70.82 83.09 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15552 810c907e16dcdd8bab024ee314d7cdc6961b04c793d7f338b1ba81897cb67a1d 688a4a2f99de3307937a0395 6837463af6142b08391bddd6 Nancy McCoy Nancy McCoy annemccoy27@gmail.com 017327 48 2025-10-06 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt having surgery- sc Sonya C. 2025-09-08 15:15:45 -671.2 hrs 688a4a2f99de3307937a038f 000014773 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15551 07743c94d25bbe7c899af34f09a4dc877e00a12be7c38548996a654824e1d4e0 68dad290e357404742a7b9a5 67ced3a17abf9f3ed8fea4ac Kristina Jensen Kristina Jensen kgraceco@icloud.com 006477 7 2025-10-06 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-09 19:40:15 76.9 hrs 68dad290e357404742a7b9a4 000021391 4.00 70.45 70.45 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15550 2947971874d1b1b55fa19cf791d98edc78ec4df8498efb44c420c179ef467458 68d2b548b09dd7080599a505 68d2b51907213e079588f54d Christopher Walzer Christopher Walzer chriswalzer@comcast.net 019916 28 2025-10-06 Cancel 68535c6303dd08c79c018795 John Reed 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. 24+ still in a lot of pain,- sc Sonya C. 2025-10-06 14:14:20 -0.5 hrs 68d2b548b09dd7080599a504 000020571 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15549 36e3336178b3e165390cea3b396c616edfddf872261bedd38f3bcdb9095bb814 68c0443840fc4f3c6d0f1cc2 67ced3a17abf9f3ed8fea4a9 Daniel Hernandez Daniel Hernandez hernandez_daniel@svvsd.org 006476 48 2025-10-06 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-06 14:40:10 -0.1 hrs 68c0443840fc4f3c6d0f1cbe 000019160 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15548 f96d740ff68f62f92f22dcd7cab5d2d2128a53ed804859bb9f7f80553eddd426 68e03c92eb9e3909a7498730 67ced35a7abf9f3ed8fe8efb Stephen Fausett Stephen Fausett cafsaf1964@gmail.com 004626 6 2025-10-06 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Michelle W. 2025-10-06 14:37:07 -0.4 hrs 68e03c92eb9e3909a749872f 000022245 4.00 170.07 170.07 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15547 65cc6c27da3082bc69710a1af57e3a9e3fb256d505b4815407f64f3b612299c3 68cad6b4b01f4a9d28bec013 68cad6a481d753083e522003 Stephen Fausett Stephen Fausett steve@ptob.com 019881 1 2025-10-06 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. (duplicate pt accidentally scheduled here) Sophia L. 2025-10-03 21:13:38 -65.8 hrs 68cad6b4b01f4a9d28bec012 000020005 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15546 d67b44e0472d4a8f03bf4fc001af21c439a3b00d46f5b618a693ce0b4f0c1f2b 68bf3d793621154d6cd15080 68a613fa8d204e08519a4c3c Chandra Beck Chandra Beck chandra.beck22@gmail.com 017845 30 2025-10-06 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Primary - - Yes Amie Russell - Kenneth Dave Francisco 2025-10-10 15:33:18 96.6 hrs 68bf3d793621154d6cd1507f 000019102 3.00 0.00 25.00 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15545 376af86e7328a77563aeef0898d1083f04275d2f26a0521c5be4574dcdd0ea0c 68af1c5e06a0ec9bb6989f91 68af1b04a23675335b1d3864 Janet Branham Janet Branham jbran281@gmail.com 019753 6 2025-10-06 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. - Michelle W. 2025-08-28 18:57:09 -932.0 hrs 68af1c5e06a0ec9bb6989f90 000017711 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15544 ebc2b8342a3f832f1dfedd464cd8a2945c5dfd3e007c42367cac36bc4630e385 68ac860df16e7507d3e746ff 689264aa22e70f07b2aca32b Kumiko Pentz Kumiko Pentz jpentz1@gmail.com 017754 11 2025-10-06 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. Sees PA-C next day. Michelle Osgood 2025-09-29 15:18:50 -167.7 hrs 68ac860df16e7507d3e746fe 000017375 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15543 07db4cb34ec1cf5cc7792b12a5410768f384bdd47081866d404c3ee4cfcafedc 68dab491560e7bf8b52437cb 68bb234f83c31468e4f54258 Brian Hedstrom Brian Hedstrom brian.hedstrom@gmail.com 019811 9 2025-10-06 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Rosey Reed 2025-10-06 15:12:44 -0.0 hrs 68dab491560e7bf8b52437ca 000021353 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15542 7746e22501a06ab4fe8143a56e36b03d0568874b1aa810b381ed346357600c6e 68befc42904934661d947614 68befb23347a016661c952ea Kathryn Heien Kathryn Heien borkheien@msn.com 019815 9 2025-10-06 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-09 15:52:09 72.6 hrs 68befc42904934661d947613 000019007 4.00 315.00 10.00 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15541 8c445ff8af74317bce7a8b6b78710ed46e7777776888637ec24544f76709ac79 68af2ce1acebc94ce8ed38e4 68af2b6bacebc94ce8ed20e5 George Kretke George Kretke gkretke@msn.com 019756 25 2025-10-06 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Rosey Reed 2025-10-06 15:10:18 -0.1 hrs 68af2ce1acebc94ce8ed38e3 000017754 5.00 75.00 75.00 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15540 fc7046474e73a3864c232076caee5eac30da764f50dd6601590f7708d5bd45fc 68a8808ca3aeb40777b6fde0 681924f2b2c8fc7022464a1f Michael Livesay Michael Livesay michaellivesay2@gmail.com 017179 44 2025-10-06 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-06 16:00:00 0.8 hrs 68a8808ca3aeb40777b6fdd9 000017195 3.00 80.26 80.26 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15539 3f60b55b13bb30c3277c5c94e58fb91325aea1e8d04f622a5790b297be1f7ce4 6890f367c1f7c6e6b3decc63 67ced3c67abf9f3ed8feae45 David Kaslow David Kaslow david.kaslow@du.edu 007296 109 2025-10-06 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Mark Leo Guevarra 2025-10-21 17:43:41 362.5 hrs 6890f367c1f7c6e6b3decc5f 000015247 3.00 60.00 65.00 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15538 d16c69ed7d8ff8657bb0a284fe58ea477229f402633b5642ab2987e5ef23c51e 687e6660564e4807cd3e2555 67ced3dc7abf9f3ed8feb382 Chet Kieffer Chet Kieffer chetkieffer@gmail.com 007743 116 2025-10-06 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Rosey Reed 2025-10-06 15:15:28 0.0 hrs 687e6660564e4807cd3e2550 000013643 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15537 ba842bb50bc8aa56dd1ddf59adc3a0d7bdab651393de0359d0d9a69eb8b91f21 68e02b5d40b64a08c487714f 67ced5477abf9f3ed8fef598 Laura Rulon Laura Rulon lrulon@yahoo.com 013380 322 2025-10-06 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Miranda Samson - Sonya C. 2025-10-06 16:12:22 0.7 hrs 68e02b5d40b64a08c487714e 000022230 4.00 95.95 95.95 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15536 37decbc2050741987b8c9c85897a1652f781569029344f4a1c4d1b23eace1dd0 68af6f7a0a80090ac141425c 6863f90f10b0f90876859428 Jennifer De Julio Jennifer De Julio jendejulio@msn.com 017553 14 2025-10-06 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. decreased frequency Miranda Samson 2025-10-01 22:32:57 -113.0 hrs 68af6f7a0a80090ac141425b 000017894 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15535 c01391b4dcdb5bab1097890e78a266f30d0d3040c1b54c25b326e42f4674017c 687e6759b05d59cabb8849e3 687e6628566432084beb732f Patricia Pederson Patricia Pederson rpederson@comcast.net 017660 32 2025-10-06 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-10-06 15:33:01 0.1 hrs 687e6759b05d59cabb8849e0 000013653 2.00 59.50 59.50 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15534 5b9a7d6ce3e3688e5c84f54080d725cca34e1289531f2d6fb1ca080300aca470 68b08b48e112015202ff8bd5 68a5df6f0a9ff4d6b25f77d0 Randall Harrison Randall Harrison rharri4145@gmail.com 017829 20 2025-10-06 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Primary - - No Sara Thompson - Emmie Gebhardt 2025-10-06 15:34:18 -0.2 hrs 68b08b48e112015202ff8bd4 000018016 3.00 236.00 0.00 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15533 86a10c6ef4bd9e619fff39fc0957cd695d8040300af5ffaceca83072e781e8a8 68a398600a2270a2a786935e 68a397a049b511ee4c7653e4 Benjamin Brown Benjamin Brown benjaminbrown1230@gmail.com 017818 25 2025-10-06 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67a90213226f6552a9bea KAISER FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. conflict, messaged sami through PTwired on 10/5 Samantha Saunders 2025-10-06 14:17:08 -1.5 hrs 68a398600a2270a2a7869359 000016607 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15532 7e5ffba7fa004de499edc14b3f4db51282f07a8b42cbb9b97017876c1fe9b30f 68dda5ef6c9208130bf8eded 67ced3e57abf9f3ed8feb59e Yekaterina Klopp Yekaterina Klopp katya.klopp@gmail.com 007923 52 2025-10-06 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-06 16:06:07 0.1 hrs 6984d4dd45002fa2b3937446 000021949 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15531 53f5723f965ca880e13acb802e06d7d8637b71819af2c098410d39eb76f74a90 68d2dd5978cb5010b3fd8cad 68c84981fcdd9c82695f24b0 Michele Gerra Michele Gerra mike@mikegerra.com 019853 6 2025-10-06 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-09 19:55:46 75.9 hrs 69038bf028ac9f097a7dee15 000020659 4.00 38.43 38.43 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15530 58a37433daa91a8998f646e36fa6e57d869d5b747ad802d1ce6ab0f9336f6ba6 68cae7ee3251f3b8a2987cea 68cae7e256bd091ec769ba53 Kenneth Roth Kenneth Roth ken@kenrothassoc.com 019882 16 2025-10-06 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-10-22 15:23:56 383.4 hrs 68cae7ee3251f3b8a2987ce9 000020024 4.00 180.00 180.00 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07
15529 59c9b4eb8198d687e9eae2ec6639079831d8761d8f980fc990faf13798e8b388 68b8812c8ff92cda5521115e 68b1e83ef391642b2654c4d7 Joyce Gordon Joyce Gordon jay_gee@comcast.net 019783 53 2025-10-06 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-10-06 16:02:51 0.0 hrs 68b8812c8ff92cda5521115d 000018532 2.00 59.50 59.50 - - - - - - - - 2026-02-19 23:06:31 2026-06-11 23:36:07