Patient ID Sequence

docutek wrote on Tuesday, August 14, 2012:

I want to begin patient numbering at 17500 rather than at 1 so I can continue the sequence from my previous practice software. In which file do I edit. Thank you.

juggernautsei wrote on Friday, August 17, 2012:

Hi,

my suggestion on this would be to put in your first patient and then go to the patient table and change the PID to 17500. The next patient that is entered into the system would be auto assigned 17501.

Sherwin
(ww2.openmedpractice.com)

pfwilliams wrote on Friday, August 24, 2012:

You can rest the auto-increment of the ID field in the Patient_Data table with this SQL statement:

ALTER TABLE PATIENT_DATA AUTO_INCREMENT = 17500;

It will not allow you to set auto-increment lower than the highest existing value in the table.