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

Crystal report of ins carriers w/the clearinghouse name in EDI tab

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

2 Posts

1 Users

0 Reactions

65 Views

RSS

lkeith

(@lkeith)

Posts: 457

Honorable Member

Topic starter

We are in the process of bringing up Encoda and moving away from Centricity EDI. I was asked to get a report of the insurance carriers w/the clearinghouse loaded so the manager can make sure of who hasn't been switched over. I am using the tables of Clearinghouse, Insurance Carrier Company Processing and Insurance Carriers.

I can produce a report of the clearinghouses and get everything including those that have been set up for Encoda. However, if I try and report the clearinghouse along with the Insurance company name and insurance carrier ID, it only pull the Centricity clearinghouse but it's not even pulling all of those.

I don't understand why it's not letting me get this and I'm tired of beating my head against the wall. Any suggestions of what I might be doing wrong?

Linda

Posted : April 20, 2018 2:56 am

lkeith

(@lkeith)

Posts: 457

Honorable Member

Topic starter

Update: I found this sql script but I was told that it was missing some carriers.

select

ic.InsuranceCarriersId,
ic.Inactive,

ic.Name,

ic.ListName,

icc.ClaimPayerId,

ch.ClearinghouseName

from

InsuranceCarriers as ic

join InsuranceCarrierCompany as icc

on icc.InsuranceCarriersId = ic.InsuranceCarriersId

join Clearinghouse as ch

on ch.ClearinghouseId = icc.ClaimClearinghouseId

Our manager then asked if I could get those carriers that don't have a clearinghouse ID at all (we have some that are setup that way, not sure why though). I've just gotten into writing scripts so this is new territory. Is there a change I could make to this to pull any and all carriers, regardless if there is a clearinghouse or not?

Posted : April 20, 2018 8:19 am

Share:

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