[MT-L] Report - pull data from Multiple Type Query - Magic 5.6.4

[Rob...@saintmarysregional.com]

I am writing an NPR report in Magic 5.6.4 that will pull data from some queries entered by nurses. The screen is setup as a "NUR" screen. The report will then have a form overlayed onto it by FOL. Most of the queries are pulling data fine except for two that are setup as multiple type queries, they are not pulling any data. The two queries are:

"PNEIMMCONT" and "PNEIMMCOMO". The queries are setup in MIS as group response queries and are setup to "Y" for multiple. There group response mnemonic is the same as there query mnemonic. The report is written in ADM.PAT for FOL (Forms On Line), the detail segment is adm.patient.file

The data fields are setup as follows:
DAT=FREE
JFY=L
LEN=25
VAL=@cdm.response

I then have a line attribute on the line they are on that has this:
ECB="PNEIMMCOMO"^cd.query,DO{@Next(cdm.seq.no) .,
ECE=.},

And the other one is setup like this:
ECB=" PNEIMMCONT "^cd.query,DO{@Next(cdm.seq.no) .,
ECE=.},

There are no errors on the report, it just doesn't pull any data. I can see the data in PCI. Any help would be appreciated! Thanks much!

Thanks,
Rob Eby
Information Systems Support
(479) 964-5382
Saint Mary's Regional Medical Center

===###===###===###===###===###===###===

Please do NOT send messages that ask "Please post to the list" or "I'd like to see your answers" or "Send that info to me, too" These are useless messages that just waste the email server's resources. Instead, email the original requester and ask that they send you or post the results of their question.

To UNSUBSCRIBE or to SUBSCRIBE, go to http://MTUsers.net for information.

You can locate the:
1) meditech-l archives
2) NPR/Magic/CS tips
3) job opportunities in the Meditech community
http://mtusers.net

Do NOT send email to meditech...@MTUsers.com. This is a system email box that is NOT monitored by a human. If you need help or advice on how to use the meditech-l, email lo...@MTUsers.com or ju...@MTUsers.net. Both of these people help manage the meditech-l, so they are your best resource.

===***===***===***===***===***===***===

[Joe Cocuzzo]

I do not recommend using ADM as source for NUR query responses. Despite Meditech knowledgebase article(s) saying that this is the place for "most recent responses", the more accurate characterization is:

"Most recent response if intervention is set to Default Queries Y, unless most recent documentation undone -
If Default Queries = Y and undone, all queries will be empty in ADM but could exist in NUR on prior valid intervention or assessment.
If default queries = N then ADM has the most recent NON NIL response. So, if a user has deleted a response, the old value REMAINS in ADM.PAT"

I have known of sites doing Med Recon via NUR queries where they decided to do default queries = N, with med queries set to demo recall = Y and they wrote their recon reports (based on MT advice) in ADM. As a result they had to train their nurses to enter a dot for medications that the patient had from prior visits so they would delete off the report.

The best way is to write the report out of NUR, where you can get the most recent, not undone, post-edit values, which is the accurate information from NUR documentation.

The way to skip undone documentation is to check for a ".99" on the counter for a particular time documented:

IF{@activity[,,,,,td.act.ctr#"0."_".99"] "";1}

The way to reject a particular instance of documentation because it was subsequently edited:

IF{@activity[,,,,,td.act.ctr+"0.01"] "";1}

For more info, check out my 2011 MUSE International Workshop Powerpoint and report examples here:

http://www.iatric.com/MUSE2011 "NPR Report Writing for the Nursing Module (Magic C/S but not 6.x)"

But, if you must use ADM on your report, you are looking at the wrong segment. The NUR multiple queries go here:

clinical.cus.def.mult.qry.resp (ccdqr.mult.resp)
[ccdqr.patient,ccdqr.query, ccdqr.mult.seq.no]
*AA.CCDQR[aa,ggv]M[ggvN]

Field Name Len Dat Typ J DPM Offset/Local/VAL
ccdqr.mult.seq.no 3 PINT R ggvN
ccdqr.mult.abn.result 2 CHOICE L *AA.CCDQR[aa,ggv]M[ggvN]AB
ccdqr.mult.comment 60 FREE L *AA.CCDQR[aa,ggv]M[ggvN]C
ccdqr.mult.response 75 QRY.RESP L *AA.CCDQR[aa,ggv]M[ggvN]|0

Joe Cocuzzo
Vice President
NPR Services
Iatric Systems, Inc.
Phone/Fax: (978) 805-4115
Email: mailto:Joe.C...@iatric.com
Web: http://www.iatric.com/

Iatric Systems is a leading provider of integrated software applications, interfaces and reporting solutions for hospitals and healthcare systems.
__________