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

need sql script

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

3 Posts

3 Users

0 Reactions

79 Views

RSS

sharansunkara

(@sharansunkara)

Posts: 83

Estimable Member

Topic starter

Hello,
I am looking for a script that i can run in sql that will show patients who were seen in a facility in the year of 2018 that are on either, Medicare, Medicaid or Self Pay. Any help on this would be appreciated. Thanks!

Posted : May 1, 2019 6:03 am

jesran

(@jesran)

Posts: 13

Active Member

In Centricity EMR something like:

SELECT MEDRECNO

FROM PERSON... JOIN INSURANC... JOIN INSURECO

WHERE INSURECO.PLANCODE IN ['Medicare, Medicaid, Selfpay#s'] AND INSURANC.PSISTATE='P'

I think those are the important parts. The rest you should be able to construct yourself.

Good luck,

Gerald Neale, BSN

Posted : May 1, 2019 6:42 am

dmontgomery

(@dmontgomery)

Posts: 59

Trusted Member

I would be happy to help you with this, the biggest question to answer from your side would be which CPS product you are using though.

- Are you using combined product? (If not are you using CPS EMR or PM)

If you are using combined you could do something like this, assuming any patient "seen" would have a visit created in PM.

Select pp.PatientId,
pp.Last,
pp.First,
ic.ListName as 'Insurance Carrier'
From PatientVisit pv
INNER JOIN PatientProfile pp ON pv.PatientProfileId = pp.PatientProfileId
INNER JOIN InsuranceCarriers ic ON pv.PrimaryInsuranceCarriersId = ic.InsuranceCarriersId
Where pv.FacilityId IN ('Get list of facility ids to put here')
AND
pv.PrimaryInsuranceCarriersId IN ('Get list of Insurance ids to put here')
AND
pv.Visit >= '01/01/2018'
AND
pv.Visit < '01/01/2019'

Also, you would have to make some changes if you want patients where the insurance you mentioned is something other than Primary. That can be done though without too much trouble.

Posted : May 3, 2019 3:56 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 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