Visit the MTUsers WikiPedia at MTUsers.NET/mwiki What about this section of the L?
Julia Carter, CPAR Consultant Consultant People 396 W Main Street Lewisville, TX 75057-3866 LL 469.948.4000 Ext 308 [EMAIL PROTECTED] e http://www.cpeople.org -----Original Message----- From: meditech-l@mtusers.com [mailto:[EMAIL PROTECTED] On Behalf Of Doug Hiteshew Sent: Monday, June 18, 2007 2:00 PM To: 'Olsen Ron'; 'meditech-l@mtusers.com' Subject: RE: [MEDITECH-L] Client Server: Data Repository Request Hello Ron. I apologize for the lengthy delay in responding to you. At the International MUSE Conference in San Diego a couple of weeks ago, at the Data Repository Networking Session, this "Sharing Place" idea was discussed. In the past SQL code has been shared on the Meditech web page somewhere, and also in one or two other sites. If I wasn't having a "middle aged" moment I might be able to recall what those were. At the DR Networking Session, Glenn D'Abate, from Acmeware, Inc, made an offer to have sponsor a sharing place for SQL code. Perhaps this message will stimulate a discussion and a consensus can be reached. Doug Doug Hiteshew, MT(ASCP) Senior Systems Analyst Johnson Memorial Hospital Franklin, IN V: 317-736-3397 F: 317-346-3011 E: [EMAIL PROTECTED] -----Original Message----- From: Olsen Ron [mailto:[EMAIL PROTECTED] Sent: Saturday, May 05, 2007 8:37 AM To: Doug Hiteshew Subject: RE: [MEDITECH-L] Client Server: Data Repository Request Doug, is there anywhere you know of that we can share our SQL queries? Ron Olsen Information Systems Coordinator Mercy Regional Health Center Manhattan, Kansas - 785-776-2830 x 1454 'Dream it to Reality' -----Original Message----- From: meditech-l@mtusers.com [mailto:[EMAIL PROTECTED] On Behalf Of Doug Hiteshew Sent: Friday, May 04, 2007 1:24 PM To: meditech-l@mtusers.com Subject: RE: [MEDITECH-L] Client Server: Data Repository Request Hello Katie. We are a MAGIC 5.5 SR3 site, however, I was under the impression that the table names were now identical (?) in both C/S and MAGIC. At any rate below is the SQL code for obtaining the response (Y/N) to the NUR Query "NURDECUBIT". Perhaps this will give you a point in the right direction. (The elapsed time calculation is looking for patients that have been inpatients for at least 7 days.) Change the name of the Query that you are interested in from NURDECUBIT to whatever, and plug this code into either the SQL Query Analyzer or into Access Projects and you should start getting results. SELECT BarVisits.AdmitDateTime, BarVisits.DischargeDateTime, BarVisits.AccountNumber, BarVisits.Name, BarVisits.RoomID, NurQueryResults.Query, NurQueryResults.DateTime, NurQueryResults.Response, DATEDIFF(dd, BarVisits.AdmitDateTime, BarVisits.DischargeDateTime) AS LOS FROM dbo.NurQueryResults RIGHT OUTER JOIN dbo.BarVisits ON dbo.NurQueryResults.VisitID = dbo.BarVisits.VisitID WHERE (dbo.NurQueryResults.QueryID = 'NURDECUBIT') AND (dbo.BarVisits.DischargeDateTime >= CONVERT(DATETIME, '2006-11-01 00:00:00', 102)) AND (DATEDIFF(dd, dbo.BarVisits.AdmitDateTime, dbo.BarVisits.DischargeDateTime) >= 7) Good luck. Doug Doug Hiteshew, MT(ASCP) Senior Systems Analyst Johnson Memorial Hospital Franklin, IN V: 317-736-3397 F: 317-346-3011 E: [EMAIL PROTECTED] -----Original Message----- From: Kathryn Wohnoutka [mailto:[EMAIL PROTECTED] Sent: Thursday, May 03, 2007 4:24 PM To: [EMAIL PROTECTED]; meditech-l@mtusers.com Subject: [MEDITECH-L] Client Server: Data Repository Request We are working on constructing a Pain report (PCS Intervention/Assessment and MAR Assessment documentation) using DR. Is anyone else using DR for PCS assessments? If so, what tables are you using? Thank you in advance for your assistance, Katie Wohnoutka Citizens Memorial Hospital Bolivar, Mo. The information contained in this e-mail, including any attachments,is legally privileged and confidential. If you are not the intended recipient, you are hereby notified that any use or dissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone 417-328-6526 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Citizens Memorial Hospital for any loss or damage arising in any way from its use. =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit MTUsers.NET. To check the status of the meditech-l, visit MTUsers.NET. For help, email [EMAIL PROTECTED] Visit the MTUsers WikiPedia at MTUsers.NET/mwiki ______________________________________ meditech-l mailing list meditech-l@MTUsers.com http://mtusers.com/mailman/listinfo/meditech-l =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit MTUsers.NET. To check the status of the meditech-l, visit MTUsers.NET. For help, email [EMAIL PROTECTED] Visit the MTUsers WikiPedia at MTUsers.NET/mwiki ______________________________________ meditech-l mailing list meditech-l@MTUsers.com http://mtusers.com/mailman/listinfo/meditech-l =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit MTUsers.NET. To check the status of the meditech-l, visit MTUsers.NET. For help, email [EMAIL PROTECTED] Visit the MTUsers WikiPedia at MTUsers.NET/mwiki ______________________________________ meditech-l mailing list meditech-l@MTUsers.com http://mtusers.com/mailman/listinfo/meditech-l =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit MTUsers.NET. To check the status of the meditech-l, visit MTUsers.NET. For help, email [EMAIL PROTECTED] Visit the MTUsers WikiPedia at MTUsers.NET/mwiki ______________________________________ meditech-l mailing list meditech-l@MTUsers.com http://mtusers.com/mailman/listinfo/meditech-l
