[MT-L] Meditech Magic - DR
Joy Merritts
I am extremely new to DR so bear with me.
How do I get a group response to pull into a query?
I am using SET @Language = 'OELANGUAGE' and get 1 which is the element code not the element name. I need to pull the element name.
Joy C. Merritts
Assistant IT Director
J.C. Blair Memorial Hospital
1225 Warm Springs Avenue
Huntingdon, PA 16652
(814) 643-8771 (fax)
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
Arquette, Mark
You probably want to include the DMisGroupResponseElements table in your query which holds the mapping between the element codes and element names. Our DMisGroupResponseElements table would not populate automatically / correctly until Meditech found and patched in a necessary DTS. If you have the same problem with your table (data not flowing into the DR table), let me know and I can look up the required DTS # to request from Meditech to fix the problem.
Mark Arquette
SQL / DBA Programmer Analyst
CareTech Solutions
Blanchard Valley Health System
Office: (419) 423-5343
Help Desk: (419) 423-5211
Helping extraordinary people do extraordinary things
Best in KLAS Partial IT Outsourcing 2012 Extensive IT Outsourcing Best in KLAS Awards: | |
Ganesh Seshadri
Do you mean, for example, patient smith is entered with a language of 15 and you want it to display “Russian”?
Let’s say the query is called LANGUAGE and group response tied to this query goes by mnemonic LANG.
If you’re working out of ABS, then table AbsQueries would have the QueryID (“LANGUAGE”) and Response (15) fields.
Table DMisQueries would have the link between the QueryID (LANGUAGE) and the mnemonic of the group response GroupResponseID(LANG)
Table DMisGroupResponseElements contains the value you’re looking for in Name (Russian) which you can get after joining SourceID, GroupResponseID (LANG) from DMisQueries and Response in AbsQueries (15) with CodeID in DMISGroupResponseElements.
You could of course skip the DMisQueries table and its join by hard coding the value of GroupResponseID with “LANG” which would also be faster, but keeping the join with DMisQueries you avoid any problems with hardcoding the Group Resp Value in the Query Dictionary in case you change it to a different mnemonic.
I’m sure the more DR literate people can give you a better way of doing this, but this is what I use.
Join AbstractData with AbsQueries to get the language code, then join that with DMisQueries to get the Group Resp mnemonic, and finally join with DMisGroupResponseElements to get the name of the language from the code.
From: meditech-...@mtusers.com [mailto:meditech-...@mtusers.com] On Behalf Of Joy Merritts
Sent: Thursday, May 16, 2013 10:39 AM
To: medit...@mtusers.com
Subject: [MT-L] Meditech Magic - DR
I am extremely new to DR so bear with me.
Machado, Jorge
It actually has the response value as: English
Jorge
SQLPower4DR
From: meditech-...@mtusers.com [mailto:meditech-...@mtusers.com] On Behalf Of Ganesh Seshadri
Sent: Thursday, May 16, 2013 11:44 AM
To: Joy Merritts; medit...@mtusers.com
Subject: Re: [MT-L] Meditech Magic - DR
This email and any files transmitted with it are confidential
and are intended solely for the use of the individual or
entity to which they are addressed. If you are not the
intended recipient or the person responsible for delivering
the email to the intended recipient, be advised that you have
received the email in error and that any use, dissemination,
forwarding, printing or copying of the email is strictly
prohibited. If you have received this email in error, please
immediately notify Bristol Hospital at 860-585-3000 and
delete this message.
Brower, John C
We are C/S but the solution should be similar.
In this case C.Name is the group response value that corresponses with the query response
SELECT TOP 100 C.Name FROM AdmVisits A
INNER JOIN AdmVisitQueries B ON A.VisitID = B.VisitID
INNER JOIN DMisGroupResponseElements C ON B.QueryID = C.GroupResponseID
WHERE B.QueryID = 'GEN.PL' AND B.Response IN ('7', '3', '2')
***********************************************************************
This electronic transmission contains information from Methodist Health
System and should be considered confidential and privileged. The
information contained in the above messages is intended only for the
use of the individual(s) and entity(ies) named above. If you are not the
intended recipient, be aware that any disclosure, copying, distribution,
or use of this information is prohibited. If you receive this transmission
in error, please notify the sender immediately by return e-mail.
Methodist Health System, its subsidiaries and affiliates hereby claim all
applicable privileges related to the transmission of this communication.
MUSE
Joy, you are receiving plenty of good information, but you may also consider a full day of DR training. See the workshops below that will be offered as part of the 2013 International MUSE Conference in Washington, DC - that’s just a 3-hour drive for you.
Workshop details: http://www.museweb.org/2013_tuesday_training_workshops
Conference information: http://www.museweb.org/2013_international_muse_conference_washington_dc
Alan Sherbinin
MUSE CEO
mu...@museweb.org
877-491-4703 ext. 8
Soup to Nuts – Data Repository 101
MEDITECH’s Data Repository (DR) has long been an invaluable resource for hospitals to meet their reporting needs. With the continued adoption of MEDITECH 6.0 and with ARRA Meaningful Use reporting and attestation requirements, Data Repository has become a critical component of the MEDITECH HCIS. Our “Soup to Nuts” workshops will teach you all things DR – everything you need to know to monitor, maintain and best utilize your DR to provide your organization with timely and impactful information.
In our DR 101 workshop, we’ll provide an introduction to the DR module in MEDITECH along with details on how the data transfer process works, how to check on overall system health and data transfer functionality, how to interpret informational messages and potential errors from the DR system log, and how to best follow-up with MEDITECH on any DR-related issues.
Next, we’ll dive into the basics of Microsoft SQL Server, the relational database system that hosts your DR data. This will include an overview of database management with SQL Server Management Studio, along with a discussion of best practices for data validation. Finally we’ll outline the report development and presentation options that are included with Microsoft SQL Server.
If you are in the planning stages for implementing DR, have recently brought your LIVE DR system online or have an already-established system, join us to learn about the DR from start to finish.
Instructor: Ian Proffer, Acmeware
Soup to Nuts – Data Repository 102
Continuing our “Soup to Nuts” DR Tuesday workshops, this session will teach you everything you need to know about DR report writing with Microsoft SQL Server, so you can provide timely and impactful information to your organization.
The DR report writing process starts with knowing where to get the data you need and how to write T-SQL code to return the results accurately and efficiently. We’ll demonstrate the tools and methods you can use to determine the best tables to use for different reporting scenarios. We’ll teach you how to easily combine data from multiple MEDITECH modules, as well as things to consider when joining these tables together. We’ll share other tips and best practices to consider while doing your report development, including naming conventions and how to organize your stored procedures to improve productivity. You’ll learn about some of the built-in and custom T-SQL functions we use to make certain calculations or conversions easier. Lastly we’ll demonstrate the basics of using SQL Server Reporting Services to design and publish your reports within your organization.
Be sure to join us if you want to learn all you can about writing and presenting efficient and useful reports using your MEDITECH Data Repository and SQL Server’s reporting tools suite.
Instructor: Jamie Gerardo, Acmeware
From: meditech-...@mtusers.com [mailto:meditech-...@mtusers.com] On Behalf Of Joy Merritts
Sent: May-16-13 7:39 AM
To: medit...@mtusers.com
Subject: [MT-L] Meditech Magic - DR
I am extremely new to DR so bear with me.
