[MT-L] Meditech Data Repository and SQL Training
Arvin, Kim
We are soon to be implementing Meditech's Data Repository. Our current
NPR staff does not have very much SQL report writing experience. Does
anyone out there have a guidline as to how much SQL knowledge will be
required to function in the DR environment? And, are there any
suggestions of vendors who would provide training in SQL report writing?
Thanks for the info!
Kim Arvin
Applications Analyst/Programmer
Parkview Medical Center
400 West 16th Street
Pueblo, CO 81003
This email and any attached files are confidential and intended solely for the intended recipient(s). If you are not the named recipient you should not read, distribute, copy or alter this email. Any views or opinions expressed in this email are those of the author and do not represent those of the company. Warning: Although precautions have been taken to make sure no viruses are present in this email, the company cannot accept responsibility for any loss or damage that arise from the use of this email or attachments.
===###===###===###===###===###===###===
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 or to SUBSCRIBE, 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
Do NOT send email to meditech...@MTUsers.com. This is a system email box that is NOT monitored by a human. 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.
===***===***===***===***===***===***===
Doug Hiteshew
This is the URL for the Data Repository Product Home Page:
http://208.206.3.232/prdr/homepage.asp
There is a lot of good information here.
Your requested nugget of knowledge is here. (see below) In brief, one
full time FTE for just the Data Repository. (Good luck with that!!) At
the very least you will need to have several people trained in SQL
Administration and Report Writing SQL Server Reporting Services (SSRS)
and perhaps Access and/or Crystal Reports.
I suggest contacting AcmeWare for training in SQL Admin and report
writing: http://www.acmeware.com/
Do not forget to investigate obtaining the Blue Elm DRAuditor software.
It automates the process of comparing the data in your DR tables to what
is in your MAGIC or C/S System. There is really no other way you can
accomplish this. http://www.blueelm.com/
HTH.
Doug
Doug Hiteshew, MT(ASCP)
Senior Systems Analyst
Johnson Memorial Hospital
Franklin, IN 46131
V: 317-736-3397
C: 317-409.0108
F: 317-346-3011
E: dhit...@johnsonmemorial.org
The Meditech DR Staffing Document is the same for both C/S and MAGIC,
and reads:
"MEDITECH recommends that the customer's Data Repository Core Team be
comprised of at least the following:
1. SQL Database/Windows Administrator (required) - A staff member on
site who is proficient in SQL Server Administration.
NOTE: It is the customer's responsibility to secure a resource that is
able to perform the functions below.
This person must understand the following aspects of SQL Server:
Administrating Security
Administrating Users, Workgroups, SQL Roles
Responsible for maintaining the hardware
Installation of Windows/SQL software
Installing Windows/SQL Service Packs
Managing access to DR Server/SQL/Databases
Creating/managing SQL Objects
Creating/managing customer defined tables
Managing Reports and/or ODBC Reporting Tools
Performing SQL database backups and server backups
Executing routine maintenance on indexes, full text catalogs, etc
Performing database tuning and performance monitoring
2. Data Repository Team Lead - A staff member who will coordinate the
maintenance of the Data Repository application.
This person will be responsible for the following:
Monitoring all Data Repository transfers and background jobs
Understanding of the terminology associated with MEDITECH data
structures and SQL
Familiar with one or more MEDITECH applications
Experience in SQL Reporting
3. Report Writers - Staff members that are proficient in SQL report
writing.
Report creation staffing will be dependent on the individual site's
anticipated reporting requirements.
Full Time Equivalent Staffing
MEDITECH estimates that the implementation and support of the Data
Repository product will require 1 Full Time Equivalent (FTE) staff for
those administrative and operative responsibilities detailed above.
The number of FTEs required for writing reports will need to be
determined by the customer, based on anticipated site-specific needs.
The customer should evaluate the expected report development efforts and
plan accordingly."