Patient Numbering

Management and Administration
1

drholmes wrote on Friday, August 19, 2011:

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

2

visolveemr wrote on Friday, August 19, 2011:

Hi

To start the patient numbering from 3000, edit the sql/database.sql file for patient_data table AUTO_INCREMENT value.  Set the value to 3000 (which by default set with 1)

Thanks
ViCareplus Team

3

docutek wrote on Tuesday, August 14, 2012:

I tried this, it did not work. The auto_increment cannot be changed. Please help!

4

pfwilliams wrote on Friday, August 24, 2012:

Change the “3000” to whatever you like and run this SQL:

ALTER TABLE PATIENT_DATA AUTO_INCREMENT = 3000;

It will not allow you to set it lower than the highest value already existing in the table.