Hello, Side note. In 5.5.2 the nursing data is moved to new tables (or the tables are renamed). I have multiple reports I now have to rewrite. If you are looking at an upgrade soon I would wait to write my reports. If you are already at 5.5.2 the tables names are different. I will see if I can find the new names. Thanks
-----Original Message----- From: Jamie McDonald [mailto:[EMAIL PROTECTED] Sent: Friday, May 04, 2007 11:51 AM To: Kathryn Wohnoutka; [EMAIL PROTECTED]; [email protected] Subject: RE: Client Server: Data Repository Request Oops! I accidentally gave out my cell phone. You can reach me at 785-623-5023 Thanks! Jamie -----Original Message----- From: Jamie McDonald [mailto:[EMAIL PROTECTED] Sent: Friday, May 04, 2007 8:39 AM To: Kathryn Wohnoutka; [EMAIL PROTECTED]; [email protected] Subject: RE: Client Server: Data Repository Request Hi Katie! I have lots of reports written out of the DR for nursing. The tables that you will use: NurPocWorkActivity, NurQueryResults, NurQueryResultsMultiple Use less often: NurPocWorkTdRepeatResults, or NurPocWorkTdRepeatResultMult NurPocWorkActivity: This will give you the user/nurse and I would also suggestion entering either the BaseID(Intervention) or the AssessmentID, whatever makes sense, so that query process quickly. Typically I use AssessmentID. You will also want to select the max SeqID on this table. Of course if you are only after the last entry you should also select on the max ActivityDateTime. Example: INNER JOIN livedb.dbo.NurPocWorkActivity NPWA ON ANC.SourceID = NPWA.SourceID AND ANC.VisitID = NPWA.VisitID AND NPWA.BaseID IN ('1750064','1750219','1750218','2500401') AND convert(varchar(12),ANC.DateTime,101) = convert(varchar(12),NPWA.ActivityDateTime,101)AND --NPWA.ActivityDateTime > '01/01/07' AND NPWA.ActivitySeqID = (SELECT MAX(NPWA1.ActivitySeqID) FROM livedb.dbo.NurPocWorkActivity NPWA1 WHERE NPWA.SourceID = NPWA1.SourceID AND NPWA.VisitID = NPWA1.VisitID AND NPWA.AssessmentID = NPWA1.AssessmentID AND NPWA.ActivityDateTime = NPWA1.ActivityDateTime) INNER JOIN livedb.dbo.NurQueryResults NQR ON NPWA.SourceID = NQR.SourceID AND NPWA.VisitID = NQR.VisitID AND NPWA.BaseID = NQR.BaseID AND NPWA.OccurrenceSeqID = NQR.OccurrenceSeqID AND NPWA.ActivityDateTime = NQR.DateTime AND NPWA.ActivitySeqID = NQR.ActivitySeqID AND NQR.QueryID = 'MS.TXRCRD2' Feel free to give me a call, 785-650-5029. Thanks! Jamie -----Original Message----- From: Kathryn Wohnoutka [mailto:[EMAIL PROTECTED] Sent: Thursday, May 03, 2007 3:24 PM To: '[EMAIL PROTECTED]'; '[email protected]' Subject: 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 [email protected] http://mtusers.com/mailman/listinfo/meditech-l
