Adrian Midgley <[log in to unmask]> writes
>As an exercise I worked it out for Surgery Manager, a system which
>at the time was well looked after and I liked, and found it
>trivially easy:-
>
>Repeats are held in one table of the database.
>
>When a repeat is given, a record is added to another table which
>holds all prescriptions which have been produced or recorded.
>
>It sounds as though System 5 (and Jewson/Torex/Ambridge mobile
>toilets and GP computing) store the prescriptions including repeat
>lists in a single table, and therefore one cannot do the simple
>thing of crosstabbing the repeat list using Access, and then listing
>those patietns with more than [n] lines returned.
This is getting technical, but System 5 holds Repeats and Acute scripts
in a single table (marked with an R or an A etc), and each prescription
issue in a second table (so for example an ATENOLOL repeat script can
have zero, one or many issues).
The data is beautifully stored for the purpose, but sadly System5
doesn't yet offer an easy way to get it out in that way!
>The requirement to report patients with more than [n] active repeats
>is in RFA4
True, and as mentioned in my other message, is part of the development
needed for System 5 and RFA4.
--
Jon Rogers
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
|