Home Forums Discussions General Discussion How to find out the account of the latest pt added to ac?

I am looking for the easiest way to find the account number of the last new patient added to AC? Does anyone know how to do this. Only way I know how is by guessing.

There may be other ways, but off the top of my head if you open your Amazing Charts/importitems folder you will see a listing of all patient folders, scroll to the bottom to see the folder listed with the highest ID.

Good luck
Aaron

If you have direct DB access, I would just run a max(---.id) query.

Fail that, go to the chart ID field on the front page where you search for patients, and digit by digit increment until you have determined the max ID in the database. Slower, but the same end-result.

Create a new dummy patient - it will give you that number and it is 1 less - you will have extra patient but if you put in as John Doe you can change at the next new patient or just inactivate it.

Dear Gerardo,

If you have the admin password, this worked on two AC 6.6.5 systems

Short version . . .

Active-patients + Inactive-patients + 999 = newest AC ID#

(The 999 may be some other constant, depending on your starting patient-ID#.)

Long version . . .

1) Go to view-administrative_options and logon with the admin password.

2) Add active-patients and inactive-patients to get total-patients.

3) Add to total-patients the starting-patient-ID#, which you undoubtedly remember from setting up the system, right? (It's often 1000. You can find it by entering a new patient and comparing the new ID# to the total-patient figure.)

4) Subtract 1.

It's easier than it looks.

Example from office#1:

3542 active-patients
+290 inactive-patients
-----
3832 total-patients
+1000 starting-ID# for this office, typical for AC
-----
4832
-1
----
4831 last-patient-ID#

Example from office #1:

6516 active-patients
+4195 inactive-patients
-----
10711 total-patients
+3999 starting-id# for this office, less typical
-----
14710
-1
-----
14709 = last-patient-ID#

Cheers,

Carl Fogel

Where y = patient before last patient, then add one.

Of course, kidding. There are some good answers up there.

If you are not so mathematically inclined....

1. Run the audit log on the computer where the AC database is located. (As described elsewhere by Sandeep, this may involve running the database optimizer first).

2. Click on the column in the audit log "PatientID" to sort by number. The highest number will come to the top. The description should be "Created new patient".

That's your number.

You may have to reset the dates on the log if you have not created a new patient in the past 24 hours (the default is for a one day log).

thanks everyone!

If you can stand 1 more (simpler, I think):
Click on Reports from Main "form" (program)
choose Demographics as the category, Chart ID as the field, <> (not equals as the operator and 0 as the value,
Click [add Criteria to Query], then [Run Report].
Then click twice on the Report column HEADER ID (first click sorts Ascending, 2nd click Descending) then the TOP value is the last Chart ID Created.

Roger,

That's what I wrote three posts up, lol.

No, your answer is brilliant. That is what I will use when I need to know that.

Thanks.

Indy
do you have direct DB access?
I think I want that

thanks
Lynn

Lynn,

We do, and AC now offers that to Doctors who request it within certain constraints.

It can be vauleable in certain contexts; we have had folks who needed to move servers and they couldn't get the AC backup to work so we used the SQL backup, we have done forensic database analysis for a client that was being accused of mis-conduct in front of the medical board by his ex-partner, and making possible some new technology where access to the Doctor's data is essential.

Hand-in-hand is the understanding that it is far too easy to do ill-repairable damage with those tools by inexperienced people.

Why do you want direct database access. I can access it, but there is no reason to ever do this.

I absolutely need access to the DATA that is in the database. The reporting capabilities of AC are OK, but the implementation is very limited, and, shall we say, quirky.
For instance, I can search for certain lab results, such as hemoglobin A1c. I have to indicate a value of the result to filter on in order for the search to work (for instance I can search for all hemoglobin A1c results. But in order To do so I have to put in "look for a result say greater than 0.1, a nonsense number), in which case I get the results for all determinations) however the report has no indication as to the date of that lab draw. There are numerous other examples as well where the date of either the note or the result or the medication or the order is not available in the report when it is run.
I have no desire in any way, manner, or form to add to, or change the database. But I really do want to get my hands on the data.
I've had to create an interface that captures the inbound laboratory HL-7 files prior to upload through the interface to amazing charts, parses the files, and put the results in an Access database for my reporting purposes.
We asked for access to the database once upon a time. I will try to do so again.

See PM