Notifications
Clear all
General Discussion
3
Posts
3
Users
0
Reactions
81
Views
Topic starter
Gang!
We have been doing a lot of conversions and migrations of smaller offices to our main Centricity system and now need to do some cleanup. Has anyone written a report that exports all the dictionary entries for each Category under CODES AND CATEGORIES?
I would like to export these all out to excel or something else so we can sort them by description and start to remove duplicates and build a single setup of each instance.
I appreciate any help!
Posted : October 30, 2014 11:35 am
In CPS I use this query to get that information:
SELECT CASE
WHEN oc.CATNAME LIKE '+%'
THEN
'''' + oc.CATNAME
ELSE
oc.CATNAME
END Category, o.DESCRIPTION Name, o.CODE Code, o.ORDERTYPE [Order Type], p.Description, o.NUMVISITS
FROM ORDERCODES o
JOIN ORDERCAT oc ON o.ORDCATID = oc.ORDCATID
LEFT JOIN Procedures p ON o.CODE = 'CPT-' + p.Code
LEFT JOIN MedLists ml ON p.PlaceOfServiceMId = ml.MedListsId
ORDER BY o.CODE, o.Description
Posted : November 3, 2014 4:28 am
Hi,
I have a crystal report that I use for this - if someone could link me to the instructions on uploading files to a post I will share it. I used to have it book marked but had to have my computer reimaged and now I can't find it on the forum. Otherwise it is a pretty simple report..
It is pretty much just the ORDERCODES table. The fields youre probably looking for are the ORDERTYPE, CODE and DESCRIPTION. It can be linked to the order category you use by linking the ORDERCODES table to the ORDERCAT table via the ORDCATID (present in both tables). The description in the ORDERCAT table is your order category - I usually group on this so I see the orders under each category.
As an FYI ORDERTYPE is one of 3: R(Referral), T(Test), S(Service).
Thanks,
Mike
Posted : November 10, 2014 11:24 am
