Notifications
Clear all
Topic starter
We are a FQHC and some of our providers have been using invalid ICD9 codes.
Those codes only have only 2 digits to the left of the decimal point. An example is
06.9 Other operations on thyroid (region) and parathyroid. How do we prevent providers from using these codes (4546 total)?
Thanks in advance.
John Kingery
DBA/Data Intergrator
Outside In
Posted : July 21, 2014 1:41 am
We are running into this currently. I ran a query to set a bunch of codes inactive on the database, and our billers are sending the rest in as they find them. In your case, you could run an update to set all your 2 digits to the left codes to inactive. I would go through them and double check to make sure they should be inactive first, though. We are taking our time with setting ours to inactive to make sure we don't set something inactive that should be there. If you are using CPS, this query should work:
--Run the select first to see what you will be setting to inactive
SELECT * FROM Diagnosis WHERE Code LIKE '__.%'
UPDATE Diagnosis SET Inactive = 1 WHERE Code LIKE '__.%'
You may also have to go through your Custom Problem Lists as well, in case there are any stored in there.
SELECT prob.DESCRIPTION, prob.CODE, prob.Duration, q.DESCRIPTION 'Custom List' FROM ICDDEPT prob JOIN QPICKS q ON prob.GID = q.QPID WHERE prob.CODE LIKE '__.%' ORDER BY prob.DESCRIPTION
Posted : July 21, 2014 2:05 am
Topic starter
Thanks Mike. So, the ICD9 codes table is not used at all?
Posted : July 21, 2014 2:17 am
Not for setting the codes inactive.
Posted : July 21, 2014 2:38 am
