Good point! The tables I mentioned are CS 5.5.2: NurPocWorkActivity,
NurQueryResults,NurQueryResultsMultiple Use less often:
NurPocWorkTdRepeatResults, or NurPocWorkTdRepeatResultMult
Prior to 5.5.2 the two tables that had name changes were NurQueryResults and
NurQueryResultsMultiple they used to be NurPocWorkTdResults and
NurPocWorkTdResultsMult. There was also a change with one of the primary keys.
It is now the BaseID. I can't recall what it used to be. It should be easy
enough to identify.
You can also use find and replace, which should make replacing your old code
with the new updates much easier.
Thanks and have a great day!
Jamie
-----Original Message-----
>From Giles, Cathy <[EMAIL PROTECTED]>
Sent Mon 5/7/2007 7:17 AM
To Jamie McDonald <[EMAIL PROTECTED]>; Kathryn Wohnoutka <[EMAIL PROTECTED]>;
[EMAIL PROTECTED]; [email protected]
Subject RE: Client Server: Data Repository Request
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.
Important: This email and any attachments may contain confidential information
subject to protection under the Federal Standards for Privacy of Individually
Identifable Health Information (45 C.F.R. Parts 160 and 164). If you or your
organization is a “Covered Entity” under the above mentioned regulations, you
are obligated to treat such information in a manner consistent with the
regulations. If it appears that this email was sent to you in error, (1) you
are prohibited from utilizing or disseminating this email or any attachments;
(2) please immediately delete it from your computer and any servers or other
locations where it might be stored, and email this sender or call the Hays
Medical Center Privacy Officer at (785) 623-2188 advising that you have done
so. We appreciate your cooperation.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
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
