How Do I ... Tidy up my clinical data coding ?
I have recently joined the Fort Dodge Marketing Scheme and I want to alter historic information so the scan picks it up.
This procedure can also be used to 'tidy up' your data making it easier to find and analysis your database.
All the clinical lines are allocated a breakdown ( analysis code), this code allows quick searches and grouping together of work, procedures and stock.
Generally the analysis code is allocated at the time of transaction automatically by the procedure/stock item used. If no code has been initially allocated defaults will be used e.g. all stock will go through code 254.
You now want to see what the breakdown of flea products are, you can of course use the text search or Data Major and look for 'Drontal', ' Program' etc. but this can take a while. What you need to do is change the code associated with them.
It is a simple procedure:
- Create a file with one of the text editor, the file
should be called 'clinical' and live in either the
text sub-directory or the main vet data directory.
The layout is as per:
Code Clinical Text Code Clinical Text Code Clinical Text Code Clinical Text
For example
100 Drontal Tabs 101 Synulox
The case is not important e.g. Synulox = SyNuLoX = SYNULOX
In this case any line that contains 'Synulox' will have the code changed to 101 and any line containing 'Drontal Tabs' will be changed to 100.
Repeat as many times as required to catch all the work.
Note: The system will stop searching as soon as a match is found so make sure if there are two similar lines then the longer appear first e.g.
100 Drontal 101 Drontal Tabs
- Run the menu option:
System Mangement -> Setup -> Search & Replace -> Clinical
All the clinical records will be scanned and any match found the analysis code will be changed and a summary printed of the number found.
This is a one off procedure, you don't need to run it every day/week/month, only when you want to re-vamp your codes.
I want to change analysis code to another?
This can also be done with theis option, you still specify the Analysis code you WANT first then the one you want to change from. For example, you want to cnage all work under code 100 to 150 and all work under 101 to 160 you would have in your clinical file:
150 100 160 101