Enhance search function

Discussion in 'Feature: Requests and Planning' started by qilin, Sep 26, 2007.

  1. qilin

    qilin Member

    To find a patient with a particular diagnosis, finding, etcin consults and/or results metadata. Under Search tab.
  2. Jason

    Jason Developer / Handyman Staff Member

    Have you tried it in the Reports > Query Tab ?
  3. qilin

    qilin Member

    missed that.

    can metadata of the results be queried the same way too?
  4. Graham

    Graham Developer Staff Member

    Not at present.

    In the meantime, it may be better to resort to a specialist reporting tool like Crystal Reports
  5. qilin

    qilin Member

    Iam doing the search manually using MS Access now.
  6. Graham

    Graham Developer Staff Member

    Results metadata can now be queried in R211B11
  7. qilin

    qilin Member

  8. Jason

    Jason Developer / Handyman Staff Member

  9. kgmamman

    kgmamman New Member

    How does one extract a list of all the patientsentered byone particular user?
  10. Jason

    Jason Developer / Handyman Staff Member

    You mean the demographics entered by a user ?

    I wouldn't expect that information to be recorded.

    If there is a systematic error in the database, you can look at the database tables directly. Might be able to fix it with a good SQL query.
  11. Graham

    Graham Developer Staff Member

    If you know which day these patients were created, you can do a sql query on the REGDATE field which is a timestamp containing the date and time a patient was created.

    Otherwise there is no way.
  12. kgmamman

    kgmamman New Member

    If a user wanted to audit his/her patients eg: if I would like to know how many of the ACL patients seen by myself were operated and how many were treated conservatively, I would first need to pull out my list of ACL patients first. This is assuming that all my patients are entered with my sign in user ID.

    Also if i would like to pull out only the entire list of patients entered by one user selectively.



  13. Graham

    Graham Developer Staff Member

    You need to assign the patients to a doctor first before you can do such reporting.

    So, on the main demographics screen, after the patient has been entered by reception staff, they then need to assign the patient's PHCP to you.

    This is also needed for the autofiling of documents so that they go to the correct inbox.
  14. Jason

    Jason Developer / Handyman Staff Member

    2 practical ways of doing this are:

    (1) each patient should have a diagnosis of "ACL problems" or the letters ACL in a diagnosis field. You probably didnt do this, quite likely not systematically.

    (2) If you are lucky, you have a standard way of putting diagnoses in a consult regarding these patients.

    Maybe you could query for the letters ACL in a consult note, and print off a list of patients with this criteria. Of course, that will pick up the patients whom you have said, "ACL was normal".



    Not sure what you mean here. For your patients, the best way to "mark" them as yours would be to either select yourself as the PHCP (on the patients > details > personal & contact Tab) or to put your name in a Miscell- field.




    That's currently not possible. I am assuming you are talking about personal & contact information being entered by a certain person. I can see how a bigger clinic might want that ... to keep track of stuff that is entered well / poorly, etc.

    If you really want that feature outline a good business case.



    Q: do you have more than 1 doctor using Synapse ?
  15. Graham

    Graham Developer Staff Member

    It would make things easier if you first entered the diagnosis with it's ICD10 coding, and then the procedure again with the correct ICD10 coding.

    With that, and the PHCP assigned, it's fairly straight forward to do the SQL queries.



  16. Jason

    Jason Developer / Handyman Staff Member

    I think that these are "Implementation Issues" where if users want to track certain things, they need to be aware of how they can be systematic about data entry, especially if there is a high likelihood of wanting certain data down the road. We cannot force users to be systematic about data entry as this would slow things down too much.

  17. Graham

    Graham Developer Staff Member

    kgmamman works in an academic institute ... he knows he will want to do this advanced type of query!

  18. Jason

    Jason Developer / Handyman Staff Member

    Well, then there are only 2 choices:

    (1) systematic text data entry

    (2) codified disease entry.



    I am not sure either was done, making data retrieval difficult.
  19. Graham

    Graham Developer Staff Member

    I don't mind adding a field that records who added the patient ... but I want to know the business case first.

  20. kgmamman

    kgmamman New Member



    [:O] Never used the PHCP so far

Share This Page