|Home > Synergy > Hints and tips > Reports|
All authorisations are also entries.
Not all entries are authorisations of course.
It is perfectly ok to use either entries or authorisations. It is only terminology. Use authorisation when you need to check authorisation specific fields that are not in the generic entry type (like dosage, number authorised etc, last issued date).
Start date is not the same as last issued date. In general if you are looking for authorisations you might as well use authorisations because it will be clearer what you mean when someone else sees the query. Bear in mind that issues and discontinuations and sensitivities are all entries so entry based drug searches will find those too. So are problems and reminders of course but these won’t have drug codes so will be excluded automatically.Report for each Patient in “elevate_inclu”without Authorisation where( Authorisation.Read_Code Between “c31..” and “c31z.”or Authorisation.Read_Code Between “c51A.” and “c51z.”or Authorisation.Read_Code Between “cA1..” and “cA1z.”or Authorisation.Read_Code Between “cA1C.” and “c1Cz.” )and Authorisation.Last_Issued_Date in L720Dinto “elevate_excl1” ;
If you want to find if someone is “currently” on a medication (e.g. Atenolol), it might be quicker in performance terms to search in “treatment” table (which has only one entry per drug per patient) and then select a period backwards for “Last-Updated” field e.g. 1/1/02 – Today. It’s quick and dirty but useful!