RE: [MEDITECH-L] Client Server: Data Repository Request

2007-06-18 Thread Julia Carter
@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 th

RE: [MEDITECH-L] Client Server: Data Repository Request

2007-06-18 Thread Doug Hiteshew
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 'Dr

Re: [MEDITECH-L] Client Server: Data Repository Request

2007-05-05 Thread Julie Ames
You may need the following tables NurQueryResults, NurQueryResultsMultiple, NurPocWorkTdRepeatResults, NurPocWorkTdRepeatResultMult depending on what type of queries you are pulling. If you have to account for "Undones", you will need NurPocWorkActivity also. Note: The tables changed with C/S 5

RE: [MEDITECH-L] Client Server: Data Repository Request

2007-05-05 Thread Doug Hiteshew
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 direct