General Visit (PT Boulder API)

Total rows: 104,043
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
101618 0e4d48c5ef11ff77b3796de3f0aefdbf9137490f2aa836cf249187f43369927e 69f23e13385db80e1cd0edd4 67ced3107abf9f3ed8fe720a Robin Davis Robin Davis rdavis5669@comcast.net 002157 126 2026-05-14 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Michelle W. - Sophia L. 2026-05-14 17:10:36 0.2 hrs 69f23e13385db80e1cd0edd3 000046546 2.00 151.00 0.00 - - - - - - - - 2026-05-14 22:31:49 2026-06-10 22:36:50
101617 c328eb64466fb51137d48f727ba10d3785e2ba98ce01607d13dad88e918d3c4b 69cbee821512feedec82f5d7 67ced3b67abf9f3ed8feaa28 Paula Hamlin Paula Hamlin bothofus@edwardhamlin.com 006945 21 2026-05-14 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2026-05-14 17:07:28 0.1 hrs 69cbee821512feedec82f5d0 000043182 4.00 95.95 95.95 - - - - - - - - 2026-05-14 22:31:49 2026-06-10 22:36:50
101616 c5a77e5a93ffd1f25bdd31e3015357c8bedc4177f2ff0c3925e79d561237b601 69cbdad2b51111c559c2da39 67ced49b7abf9f3ed8fed98b Jennifer Pennington Jennifer Pennington jpenningtondvm@gmail.com 010987 29 2026-05-14 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl no reason given SL 5/1 Sophia L. 2026-05-01 15:00:14 -314.0 hrs 69cbdad2b51111c559c2da38 000043137 0.00 0.00 0.00 - - - - - - - - 2026-05-14 22:31:49 2026-06-10 22:36:50
101615 93354aba9b021a3bead55a938bac736458ffd3fa0ca4f9ce7c1f9d055d986fde 69c1a66be3d54575fa1c8122 6955544b3cae7ce7f26fcc0f Joshua Hansen Joshua Hansen menotyou9@gmail.com 020440 21 2026-05-14 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Patient - - Yes Sonya C. - Sonya C. 2026-05-14 17:16:28 0.3 hrs 69c1a66be3d54575fa1c8120 000042206 4.00 95.00 0.00 - - - - - - - - 2026-05-14 22:31:49 2026-06-10 22:36:50
101614 1e0732a395598992e255ccb3b06b0572f8780d390dbf1b598f00355361b4c85e 69b1d3d5073777f4c2febe5e 67ced2fe7abf9f3ed8fe691c Howard Anderson Howard Anderson anderson7575@comcast.net 001395 122 2026-05-14 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Sophia L. - Sophia L. 2026-05-14 17:07:29 0.1 hrs 69b1d3d5073777f4c2febe5d 000040919 3.00 237.00 0.00 - - - - - - - - 2026-05-14 22:31:49 2026-06-10 22:36:50
101613 71aca3aa03385a2a6612a677eb578a529360386fa688f46add878553548d4fd4 6801374a4618d5eaf0280b81 67ced41a7abf9f3ed8fec126 Betrah Mignerey Betrah Mignerey davidandbea2022@gmail.com 008906 230 2026-05-14 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 3/19 - pt going into hospice Sophia L. 2026-03-19 14:31:43 -1346.5 hrs 6801374a4618d5eaf0280b5d 000002630 0.00 0.00 0.00 - - - - - - - - 2026-05-14 22:31:36 2026-06-10 22:36:50
101612 8d45ec8de8c27839a98f94b269f04ca92e1ddb43c4f4ac2f3da4435297e1a853 69deac4818e81923ab7a9c87 67ced3447abf9f3ed8fe870e Judi Duncan Judi Duncan judiduncan@comcast.net 003950 46 2026-05-14 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Primary - - Yes Laura Sage - Michelle W. 2026-05-14 17:12:42 -0.0 hrs 69deac4818e81923ab7a9c86 000044810 3.00 235.00 0.00 - - - - - - - - 2026-05-14 22:31:36 2026-06-10 22:36:50
101611 9d41e41543b4eed446c35163e4b862a3bf040d6fa5e6836e8aff44f5c6c66430 69cd6e64d4e03a9d1f65192d 69cd6c9795f5b7aae9618745 Kendall Burns Kendall Burns burns404@sbcglobal.net 021023 8 2026-05-14 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Primary - - Yes Michelle W. - Michelle W. 2026-05-14 17:15:51 0.0 hrs 69cd6e64d4e03a9d1f65192c 000043409 3.00 233.00 0.00 - - - - - - - - 2026-05-14 22:31:36 2026-06-10 22:36:50
101610 0233d62c839e7bba663bce99fb6fbf2f5f25bd74c674e39c40486ad7c940a719 69bd6f8c604121226a8ed706 696e8106e06e1642875304f6 Sheri Martinez Sheri Martinez sherimartinez@earthlink.net 020578 30 2026-05-14 Checked Out 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - Veronica Rasmussen 2026-05-14 17:15:33 0.0 hrs 69bd6f8c604121226a8ed6fb 000041978 3.00 237.00 0.00 - - - - - - - - 2026-05-14 22:31:36 2026-06-10 22:36:50
101609 584e166cc2b4bde3d0e80284c3eb2cd9ecf39327ec75e19bdd0e0d8b65406b01 69b9c87c328b9df26933edd2 68a8e243845721aac967a05b Karen Roper Karen Roper tandy.108@gmail.com 019734 20 2026-05-14 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Haley Paull - Haley Paull 2026-05-14 17:17:44 0.0 hrs 69b9c87c328b9df26933edd1 000041653 3.00 236.00 0.00 - - - - - - - - 2026-05-14 22:31:36 2026-06-10 22:36:50
101608 4767585b10c8cb0bfd92a9a8d49bde769208fa26424baae6d265af60d7087d4d 69a5da5624b72cddbcedf5fd 69a5d7cdc97b4d475583c888 Lisa Mendoza Lisa Mendoza lisa.boldini@gmail.com 020849 3 2026-05-14 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Haley Paull 24+ pt got in sooner at another facility -mw Michelle W. 2026-03-17 19:34:48 -1389.7 hrs 69a5da5624b72cddbcedf5fc 000039780 0.00 0.00 0.00 - - - - - - - - 2026-05-14 22:31:36 2026-06-10 22:36:50
101607 6c38469d3aba6ae85bc02dcd3e12d3e054f0e29027fa391f2d77d780ee9ac978 6a0226bfecfe21bfbd3c69d5 68c85e7310ce867bf21a954a Nancy McNeill Nancy McNeill nancymcneill@mac.com 019855 41 2026-05-14 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Sophia L. - Christian Kenneth Abungan 2026-05-21 18:53:39 169.4 hrs 6a0226bfecfe21bfbd3c69d4 000047641 3.00 450.00 10.00 - - - - - - - - 2026-05-14 22:31:36 2026-06-10 22:36:50
101606 83daebe4c5a850d0717700061717e19438a540acbd53d8e6575c43c4745ff1c2 69fcb9a90000614daad0e229 68bc842e4d292e713a858054 Sarah Proctor Sarah Proctor kittengurgle@gmail.com 019814 23 2026-05-14 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Julie Petersen-Hanson - Christian Kenneth Abungan 2026-05-21 17:12:47 167.7 hrs 69fcb9a90000614daad0e228 000047386 3.00 232.00 40.00 - - - - - - - - 2026-05-14 22:31:35 2026-06-10 22:36:50
101605 96cfdb87c06f99a3222a901f709d900ffc72e7487429dc61ef8978eff6d70e7e 69d94903c02bbd434e51825a 69cfdd838e3f597ef082f0b3 Brittany Woods Brittany Woods peakpetcarellc@gmail.com 021039 12 2026-05-14 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Laura Sage - Sophia L. 2026-05-14 17:12:27 -0.3 hrs 69d94903c02bbd434e518259 000044511 3.00 226.00 0.00 - - - - - - - - 2026-05-14 22:31:35 2026-06-10 22:36:50
101604 9a1d68d9fd43418eeb115ed00aefce9de3eea493f8befaa94c171ec58d47e67d 69d81ca85be07e6699a241a9 67ced3957abf9f3ed8fea14c Elisabeth Friess Elisabeth Friess bpfriess@gmail.com 006189 80 2026-05-14 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Haley Paull - Haley Paull 2026-05-14 19:25:00 1.9 hrs 69d81ca85be07e6699a241a8 000044390 3.00 236.00 0.00 - - - - - - - - 2026-05-14 22:31:35 2026-06-10 22:36:50
101603 38db7666dc9827f6434034ed5b6e94ccd903360f0e68a99a7ba505bf6c358b39 69d549a0a441ec08cc58666d 696fe55e0b43b2467ba04d0b Evelyn Eby Evelyn Eby catherine.brinks@gmail.com 020591 26 2026-05-14 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Primary - - Yes Sara Thompson - Michelle W. 2026-05-14 17:43:25 0.2 hrs 69d549a0a441ec08cc58666c 000044032 2.00 158.00 0.00 - - - - - - - - 2026-05-14 22:31:35 2026-06-10 22:36:50
101602 a006fdb04a3447b70c9ba68cca4b31476059612fbdff26545b3924175e612c44 69c6bfa7eb5d16ec316c7084 67ced4cb7abf9f3ed8fee1cf Maxene Pollack Maxene Pollack maxene5448@gmail.com 011692 40 2026-05-14 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Haley Paull - Christian Kenneth Abungan 2026-05-21 18:39:55 169.2 hrs 69c6bfa7eb5d16ec316c7080 000042867 3.00 237.00 25.00 - - - - - - - - 2026-05-14 22:31:35 2026-06-10 22:36:50
101601 4977a6035b4d48a6250031d6453ffc5e5aff0c7a438d01cab498de41ae146952 69c1ac1362f5f7888f558c8a 67ec1346d7360808195998d8 Erin Black Erin Black black_erin@svvsd.org 016945 87 2026-05-14 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. - Michelle W. 2026-04-01 15:59:09 -1033.5 hrs 69c1ac1362f5f7888f558c89 000042214 0.00 0.00 0.00 - - - - - - - - 2026-05-14 22:31:35 2026-06-10 22:36:50
101600 ef8f33144f9d6937184d59b05fd9d285813338f7545ed1f44b3ce9eb75afc852 696a5722f889a42904b2b760 694ef6b68de8906cab2eea28 Linda Moore Linda Moore mooreism@comcast.net 020418 13 2026-05-14 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 5/7 Sophia L. 2026-05-07 16:28:09 -169.0 hrs 696a5722f889a42904b2b75f 000033965 0.00 0.00 0.00 - - - - - - - - 2026-05-14 22:31:35 2026-06-10 22:36:50
101599 91116bd50927b9c69131249c7b563810b851cba9fa9e1b4f8eb3ea1f5d24c3c4 6912621ebdf02904c30d564d 67ced2ed7abf9f3ed8fe5d37 Patricia Beumer Patricia Beumer patty1@beumerfamily.com 000380 818 2026-05-14 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - Sonya C. 2026-05-14 17:31:15 0.0 hrs 6912621ebdf02904c30d5635 000026639 2.00 159.00 0.00 - - - - - - - - 2026-05-14 22:31:35 2026-06-10 22:36:50
101598 fedf55bc11b8f35ec1acd2165a3bfbaa7d5bdb16a75a37cf45d96e6ff0dc0996 69dd3bac8a6b03eaa274cc61 67ced3ea7abf9f3ed8feb6c7 Laura Kohlerschmidt Laura Kohlerschmidt lkohlerschmidt@gmail.com 008022 73 2026-05-14 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - Sonya C. 2026-05-14 17:49:19 0.1 hrs 69dd3bac8a6b03eaa274cc5e 000044610 3.00 234.00 0.00 - - - - - - - - 2026-05-14 22:31:35 2026-06-10 22:36:50
101597 3a718d72f75e1500a2e79d92d72b844afe6087a0d5e3cabbbb10205af99d17bc 69d555d8a941411331adce70 67ced3107abf9f3ed8fe7249 Walter Davis Walter Davis wsdavisdds@comcast.net 002178 143 2026-05-14 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. pt had to leave- having complications from recent colonoscopy SL 5/14 cxl Sophia L. 2026-05-14 17:22:05 -0.4 hrs 69d555d8a941411331adce6f 000044043 0.00 0.00 0.00 - - - - - - - - 2026-05-14 22:31:35 2026-06-10 22:36:50
101596 b2b83a89e42c3351b918845ac63d0c3e8995e5ffb380bc8e415d6d19ab653136 69a06ef9fe948a30a37b8a51 696e7ade4402fdd9b62542ad Cicely Lewis Cicely Lewis clewis011503@hayoo.com 020577 12 2026-05-14 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Sophia L. - Christian Kenneth Abungan 2026-05-21 16:19:48 166.3 hrs 69a06ef9fe948a30a37b8a50 000039335 3.00 236.00 15.00 - - - - - - - - 2026-05-14 22:31:35 2026-06-10 22:36:50
101595 67021d2d1e593856bd64787097b2a4a8b8c58be8f21101a3493de0bddefab805 69dd1ba11da60712f4f7be77 69dd1973ae9baebadd46c188 William Boothby William Boothby bboothby01@gmail.com 021090 12 2026-05-14 No Show 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - John Phinney 2026-05-14 19:33:39 1.3 hrs 69dd1ba11da60712f4f7be73 000044567 3.00 0.00 0.00 - - - - - - - - 2026-05-14 22:31:35 2026-06-10 22:36:50
101594 c33755c72ed784700c04acd95c04212e3a65f070d668a1aa9529ca0922ae2de9 696eb802cbd555b92d6ba008 6806972243b7fe84d4f9f04c Glenda Russell Glenda Russell gmrussell5@hotmail.com 017099 48 2026-05-14 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Sophia Phillips - Christian Kenneth Abungan 2026-05-21 18:53:43 168.6 hrs 696eb802cbd555b92d6ba007 000034366 1.00 150.00 15.00 - - - - - - - - 2026-05-14 22:31:35 2026-06-10 22:36:50