Separated database

andres_paglayan wrote on Monday, December 05, 2005:

Rod mentioned using a separated database per clinic.
Can we discuss that further in this forum?

What about the patient database?
Should that be shared?
or should they go duplicated?
or use LDAP for patients?

sunsetsystems wrote on Monday, December 05, 2005:

In the case of the inquiry from innocuous, it’s my understanding that the patients are actually required to be separate; i.e. the clinics are not allowed to share them.  Privacy laws I guess.

But isn’t the situation somewhat similar in the U.S.?

– Rod
www.sunsetsystems.com

andres_paglayan wrote on Monday, December 05, 2005:

right,
I was thinking on a multisite practice when I asked that question.

There’s no question if applying to a site hosting multiple sets of data

A quick workaround is having more than one openemr installation in the same machine.

jimbo456 wrote on Monday, December 05, 2005:

Here’s an issue to consider. What about when you run FreeB server. It can only be run for one site at a time, shutdown the process and start a new process for the next site. Correct? Is it possible to have multiple copies running. I would like to setup a cron job for running the freeb server at night.We are getting ready to add a 2nd practice. I am going to run separate db’s, website directories, and sql-ledger.

Jim Proctor

sunsetsystems wrote on Monday, December 05, 2005:

I expect you can run multiple FreeB servers listening on different port numbers.  Currently they are hard-coded at port 18081 but this should be easy to remedy.  You’d also want to do something to make them write their output to different directories.  More configuration parameters.

– Rod
www.sunsetsystems.com

drbowen wrote on Monday, December 05, 2005:

By the By.  What is the default FreeB directory for writing these PDFs?

sunsetsystems wrote on Monday, December 05, 2005:

/usr/share/freeb/public.

– Rod
www.sunsetsystems.com

sankar1234 wrote on Wednesday, December 07, 2005:

May be in the administration settings, a checkbox "View Providers Patients Only" that inhibits the provider to see other patients.

We have to change the DB queries to reflect this checkbox setting.

my 2 cents…

-Sankar

sankar1234 wrote on Wednesday, December 07, 2005:

I don’t think Innocous is worried about billing.  In India, the concept of CPT is zippo. Most of the time, it is paid by the patient, who gets either reimbursed by the company or not.  It is paid by the patient upfront in private practices. 

slim180 wrote on Wednesday, September 23, 2009:

Solomon Dynamics is rather pricey accounting package.  I hope that it can provide some in-site here.  It can run large businesses.  They address separate databases in two steps:

Inner Companies
Master Companies

Inner Companies exists in the same database.  Actually there are two databases that make a pair.  Every screen supports a company.  Companies can share many types of information.  Every report will optionally group and page break and total on company.  Reports also show some or all inner companies.  I think this a good way to start. 

They use separate databases when size or performance is effected.  Also, separate database are used to really split things up beyond what the inner company will do.  This is where the package gives each master company their own chart (or set) of accounts that can’t be shared with any other companies.

Master companies can share transactions though but have far less automatic sharing of information.  There are ways to export or create cross-company transactions.  I would say that this is by design.  I know less about this, but I can reference the application and manual if you think this is relevant.