Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Patient copay and outstanding balance - CPS12

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

3 Posts

3 Users

0 Reactions

78 Views

RSS

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Topic starter

Hello,

Would anyone know which SQL Server tables/columns would contain the Patient copay and outstanding balance? Thanks.

Posted : June 17, 2014 4:04 am

dmontgomery

(@dmontgomery)

Posts: 59

Trusted Member

There isn't going to be a specific column for copay, but overall balance of a ticket can be found in the PatientVisitAgg table. This table has a variety of balances (patient, insurance, etc...) available.

Posted : June 18, 2014 11:30 pm

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

We've had to extract the copay from a text field, and it's ugly. Ready? This is gonna hurt...

SELECT CAST(
       CASE WHEN al.Name LIKE 'Copay % (Billing Only)'
       THEN SUBSTRING(al.Name, PATINDEX('%[0-9]%', al.Name) - 1, PATINDEX('% (B%', al.Name) - (PATINDEX('%[0-9]%', al.Name) - 1))
       ELSE
           CASE WHEN al.Name LIKE '%/[0-9] Copay'
           THEN SUBSTRING(al.Name, PATINDEX('%/[0-9] %', al.Name) + 1, 1)
           ELSE SUBSTRING(al.Name, PATINDEX('%/[0-9][0-9] %', al.Name) + 1, 2)
           END
       END
       AS money) AS Copay
FROM PatientVisit pv
INNER JOIN AllocationSet al
ON pv.AllocationSetId = al.AllocationSetId
WHERE al.Name LIKE '%Copay%'

That was not fun to write. But it works, for us at least.

Our allocation sets are formatted as either "##/## Copay" or "Copay ## (Billing Only)" - I have no idea how universal that is. So you might need to modify that to fit however your allocation sets are formatted. And obviously you'll need more than that in the FROM/WHERE clauses, but it's the stuff up top that's important.

Posted : September 9, 2014 6:30 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
12 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0