You'll need to qualify your information search by creating a computed field and looking for the policy number associated with the insurance of interest. In BAR.PAT the VAL statement would look like this...
[EMAIL PROTECTED]@account,@[EMAIL PROTECTED],1]] Hope this helps, Barry Christenson - Sr. Business Analyst Corporate Information Systems CRMC - Business Information Systems 1140 'T' Street, Fresno, CA 93721 Office: (559) 459-6418 / Ext. - 56418 / Cell - (559) 250-7974 / Pager - (559) 488-8358 / Fax - (559) 459-6025 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Daisy Reyna Sent: Tuesday, March 20, 2007 4:32 PM To: [email protected] Subject: [MEDITECH-L] MRI REPORT I created a report in MRI.PAT. Trust me, I don't know what I'm doing so I really need your help.. I've been able to retrieve all the information that I need except for the policy number. Can this be pulled from MRI? I need Medicare patients and their policy numbers but I don't need all the accounts. I tried using MRI.DRC.insured.policy.number in my picture and I get this error with it translates ERROR: Cannot find field: MRI.DRC.insured.policy.number as there is no value yet for MRI.DRC.insurance in region D Your help would be so appreciated Daisy =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit MTUsers.COM. To check the status of the meditech-l, visit MTUsers.NET. For help, email [EMAIL PROTECTED] ______________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l ------------------------------------------------------- WARNING/CONFIDENTIAL: ------------------------------------------------------- This email, including attachments, may contain information that is privileged, confidential, and/or exempt from disclosure under applicable law (including, but not limited to, protected health information). It is not intended for transmission to, or receipt by, any unauthorized persons. If the reader of this message is not the intended recipient you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you believe this email was sent to you in error, do not read it. Reply to the sender informing them of the error and then destroy all copies and attachments of the message from your system. Thank you. =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit MTUsers.COM. To check the status of the meditech-l, visit MTUsers.NET. For help, email [EMAIL PROTECTED] ______________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
