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]; meditech-l@mtusers.com
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]'; 'meditech-l@mtusers.com'
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
meditech-l@MTUsers.com
http://mtusers.com/mailman/listinfo/meditech-l
