Home Forums Discussions Problems First and Last date

Is there a way to determine when a provider started and stopped writing notes?

This is an example of what was being discussed in the thread of "Accessing the AC database through the back end", and would be where access directly to the database would be important. Using SQL Server Management Express a short script could be written to do a search like that. I am not personally facile with the language, but have had similar scripts written for me, and don't think it would take a lot of effort. First step is getting the password to gain access.

the easiest way would be to run a query WHERE provider =x ORDER BY created date

Or similar.

It will return all created notes, and you just observe the first and last date.

I don't see how to do an "ORDER BY" in the report. I can export an an XCL file, but no date field comes across unless I query "DATE >01/01/1990" or something, then the field is a text field.

David,

I wasn't clear - I was describing how to construct a simple SQL query to get the the desired set with minimal effort.

James has discussed this before, but you can take a copy of the AC database files - mount them into another machine running SQL Studio express, and run the query from Studio. Not a real-time solution, but functional for extracting data DIY.

I am not sure I understand Wendell's question. Is it, for example, "for Dr. X, what is the first and last day she wrote a note?"

If so, couldn't you run a report on "notes and encounters"... "provider seen = Dr. X".?

If you know the approximate date, could you use the audit log, sort by provider, and find the answer that way?

Well, here's the senario and solution.

I was asked to provide reference for hospital privileges for a former associate. The files that I used to keep that information on were with my old payroll system that has long been forgotten. I honestly could not remember the dates.

I called her to ask what dates she had provided and she never called me back. We are on good terms, guess she somehow overlooked the message.

I would up calling the hospital and told them the situation, they gave me the dates she had provided and I used them.

Then I saw Indy's response above. What I did then was query provider seen and encounter date. I started with > 1/1/2003 and marched it up until I came up with 9/17/2003. I then marched down from < 01/01/2008 until I came to 01/17/2007. These dates are somewhat different than they gave me but are within 6 months or so. She had been a resident with me, doing COC clinic at my office, so there was no "ramp up" time. Her COC visits were co-signed so they were different.

The solution was somewhat clunky, but I did it in less than 5 minutes once I figured out how to solve the problem.