Notifications
Clear all
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
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
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
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
