All messages should be posted in plain text.  HTML will be converted to
attachments.    The meditech-l web site is MTUsers.com
======================================

Title: NPR HELP

MIS.DOC.DICT DPM has a main segment of “main”. This is where the “name” field is located.

 

This field will require the doctor’s mnemonic as its subscript.

 

You would need to provide that subscript in order to return “name”, as such:

 

@MIS.DOC.DICT.name[<doctor’s mnemonic]

 

The “activity” segment is a daughter segment of “int.occurrances”, so you have access to all the fields in that segment. One of the fields there is “oe.order.doctor”, which is the mnemonic of the ordering doctor for the activity. This is the only doctor mnemonic you have directly available in NUR.PC.WORK.

 

You could either use the “oe.order.doctor” field as a subscript, replacing “doctor’s mnemonic” like this:

 

@[EMAIL PROTECTED]

 

or do a possessive, like this:

 

@oe.order.doctor’s.name

 

The research above is based on looking at C/S 5.4 Data Definitions, where we use MIS.DOC instead of MIS.DOC.DICT, but MAGIC will be quite similar. You should verify with your own data definitions.

 

 

Thank you,

Mitch Lawrence

Senior Applications Analyst - Advanced Report Writer

General Financials Support

CHRISTUS Information Management

Tel 361.881.3408  Fax 361.888.6117

Mob 361.549.8456

[EMAIL PROTECTED]

 

If someone has "Made your day", send them a Spirit Buck! 


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Leigh Shipper
Sent: Wednesday, March 15, 2006 2:16 PM
To: [EMAIL PROTECTED]
Subject: [MEDITECH-L] NPR HELP

 

I am trying to pull a query response into a report written in NUR.PC.WORK  detail segment nur.pc.work.activity. My query is a pointer to the MIS.DOC.DICT. I am trying to pull in the doc's name. Can anyone tell me how to do this? This is what I have tried:

[EMAIL PROTECTED]@cd.response["QUERYMNEMONIC"]]
[EMAIL PROTECTED]@ADM.PAT.ccdqr.response["QUERYMNEMONIC"]]
Thanks,
Leigh

Leigh Shipper
Sr. Systems Analyst
Beaufort Memorial Hospital
843-522-7904
[EMAIL PROTECTED]

_______________________________________________
meditech-l mailing list
[email protected]
http://mtusers.com/mailman/listinfo/meditech-l

Reply via email to