SynapseDirect

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.

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

Graham:

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

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.

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

Graham:

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.

Never used the PHCP so far

kgmamman:

Never used the PHCP so far

This is the only way to show which patient is "owned" by which doc.

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

 I head a unit with 4 other orthopaedic surgeons and we all do more or less the same surgeries. Must confess my 3 colleagues are not very fond of computers in general, however with me having introduced Synapse they are all thrilled.

Case:

From time to time we conduct audits especially for the expensive surgeries and  this doubt came up when we decided to audit ACL and TKR's. The audit proposed was pertaining to an  individual/s preference of treatment and therefore the question came up as how to pull up the cases of Dr X to see if he was more successful in treating cases rather conservatively (and saving money ) compared to Dr Y who was more radical.

 I dont think coding would work here as  the codes for ACL's would be the same for all doctors.

Yes Jason is right, the entry is not systematic

I wonder if my case is clear enough?

Graham:

kgmamman:

Never used the PHCP so far

This is the only way to show which patient is "owned" by which doc.

Now i get the point. All the while my impression was who ever entered the details owned the patient.

>Now i get the point. All the while my impression was who ever entered the details owned the patient.

That would mean the receptionists would own all the patients! 

kgmamman:

Now i get the point. All the while my impression was who ever entered the details owned the patient.

I can think up one potential method to populate the PHCP field with the "correct" surgeon.  It would depend on if each patient had the surgeon's name "somewhere" in a consult note.  It would assume that only that surgeon's name appeared in the patient's files.

Method:  search through consult notes for a patient for the surgeon's name.  If the surgeon's name was Firstname Lastname ... search for Lastname .... and if it exists ... change that patient's PHCP to Lastname.  

There isn't a way to query on this field at present.

But a 3rd party tool like Crystal Reports could build the report for you.

I was envisioning it might be doable in IBOconsole.

IBOconsole allows you to enter sql queries .. but it does not construct them for you.

So, you need a QBE tool.