Hi, everybody, I installed a WikiPedia at MTUsers.net/mwiki just for this sort of usage. My intent over time is that the WikiPedia may become such a knowledgebase that it can offload some of the work from the email list. We all want and need the list to work as efficiently as it can.
Any of you folk who have information that might have long term general use, after you post it to the meditech-l, please enter in it the meditech-l WikiPedia. At the least, it will help someone in the future. At the most, it may save the meditech-l from being too overwhelmed at some future date. If you need help getting the information into the WikiPedia, please contact me at [EMAIL PROTECTED] I'll be glad to assist. Thanks for your help and support, Gil meditech-l manager -------------------------------------------------------------------------------- From: meditech-l@mtusers.com on behalf of Doug Hiteshew Sent: Mon 6/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. =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= 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
