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

SQL script to display all providers Smart Lists

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

4 Posts

4 Users

0 Reactions

77 Views

RSS

Jaisan

(@jaisan)

Posts: 29

Trusted Member

Topic starter

Good Morning All,

My practice is currently on CPS 12.0.12 and will be upgrading later this year to CPS 12.3.? Our billing section would like to review each of the providers Smart Prob List for outdated, obsolete and less specific ICD10 diagnosis found on the list.

Ultimate goal is to clean up the Smart List before migration, either by a purge and regeneration or running GE obsolete ICD10 problem script, but the providers really need to be convinced that Smart List need cleaning and/or reconstitution.

Do any CHUG members have a SQL script that can be shared to display and/or generate an excel spread sheet or report of the problem diagnosis found in each provider's SMART List?

As I am a novice at SQL, all help would be appreciated.

Thank you and appreciate any and all assistance.

Jaisan

Posted : February 22, 2018 7:13 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

I have a Crystal report that extracts all Smart Lists. This is the code from that report.

SELECT "QPICKS"."DESCRIPTION", "MasterDiagnosis"."Code", "MasterDiagnosis"."ShortDescription"
FROM ("CentricityPM"."dbo"."QPICKS" "QPICKS" INNER JOIN "CentricityPM"."dbo"."ICDDEPT" "ICDDEPT" ON "QPICKS"."QPID"="ICDDEPT"."GID") INNER JOIN "CentricityPM"."dbo"."MasterDiagnosis" "MasterDiagnosis" ON "ICDDEPT"."ICD10MasterDiagnosisId"="MasterDiagnosis"."MasterDiagnosisId"
ORDER BY "QPICKS"."DESCRIPTION"

Posted : February 22, 2018 7:25 am

acantu

(@acantu)

Posts: 722

Prominent Member

Recommend you check out this application:

https://marketplace.centricityusers.com/#/my-account/preview/515

It lets you modify the SmartList on demand, per user or global.

Posted : February 22, 2018 4:54 pm

Scott Forest

(@sforest)

Posts: 527

Honorable Member

GE also offers a utility that will clean up the smart list and purge the system of obsolete ICD10 codes. You should be able to find it on engage. It definitely doesn't offer the functionality that Arnold's solution has though.

Posted : February 23, 2018 3:28 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