[MT-L] LSS: Single or multiple databases

[Jimerson, Linda K.]

We are MT 5.63 site, and are implementing LSS for approx 8 hospital owned clinics, including an Urgent Care, and a Behavioral Health clinic. If you are an LSS site, do you have single or multiple databases? Are you happy with your choice? Why? Would you elect to go the same direction if you were starting new?

Thanks in advance for sharing.

Linda Jimerson
San Juan Regional Medical Center
I.T. Dept, Ancillary Analyst
Phone: 505-609-6436
Cell: 505-486-3773
Fax: 505-609-6881

====================================

Please do NOT send messages that ask "Please post to the list" or "I'd like to see your answers" or "Send that info to me, too" These are useless messages that just waste the email server's resources. Instead, email the original requester and ask that they send you or post the results of their question.

To UNSUBSCRIBE, go to http://MTUSers.net
for information.

You can locate the:
1) meditech-l archives
2) NPR/Magic/CS tips
3) job opportunities in the Meditech community
http://mtusers.net

If you need help or advice on how to use the meditech-l, email lo...@MTUsers.com or ju...@MTUsers.net. Both of these people help manage the meditech-l, so they are your best resource.

[cbodn...@rcrh.org]

We have 12 databases in Magic. The reason for this was multiple and multitudinous..
:)

At the time of (staggered) implementation for all these, they all had different TAX ID's and separate statements. Mandatory separate database....

Due to convergence of business entities, now 5 have the same Tax ID and 4 others have the same Tax ID.
One is in a separate Magic MIS, two others are billing services only.

It is very time consuming to maintain this many databases, both from LSS's perspective, and my own. If we didn't use VB or Summit scripting tools it would be impossible.

After all the business merging, we basically picked one database per TAX ID for new providers, unless it was due to geography (all the clinics cover about a 300 mile range).

HTH,

Cindy Bodnar-Anderson
IS, Regional Health

====================================

Regional Health's mission is to provide and support health care excellence in partnership with the communities we serve.

Note: The information contained in this message, including any attachments, may be privileged, confidential, or protected from disclosure under state or federal laws . If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the Sender immediately by a "reply to sender only" message and destroy all electronic or paper copies of the communication, including any attachments.

[Jimerson, Linda K.]

Cindy,
I should have clarified....we are implementing the MPM Clinicals (no clinics are LIVE yet). We have had the billing portion for several years, and use MT Scheduling.

We are considering merging to one or possibly two db, with the thought of making life easier for providers. Our CBO director seemed to be OK with the possibility.

Questions:
1. What was the merging to one db like? LSS recommended if we do decide to go to a single, get a new db, and abandon the others we were currently building.
2. Would it be your recommendation to do it this way again, or would you have left as it was, in hindsight?
3. What problems did this create?
4. How did your providers feel?

Thanks!

Linda