I go about this the opposite way. I create a computed field to pull the
information on my picture, then create a selection prompt that says the
'answer' is nil. Works great!
Computed field xx.npi
DAT=FREE
JFY=L
LEN=10
[EMAIL PROTECTED]"NPI"]
Page two Select prompt:
xx.npi EQ
"" (double quotes - nil)
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Joe Cocuzzo
Sent: Friday, February 09, 2007 5:07 AM
To: Benoy, Marc; [email protected]
Subject: [MEDITECH-L] RE: NPR - How to find Data in a Dictionary that DoesNOT
Exist
Not clear whether you want to write a report that picks the doctors that do not
have a particular insurance pin, or do not have any of several selected
insurance pins.
The general solution is to write the report in the main segment, and have a
computed select field that tests for the existance of the data in the child
segment, and returns a true if there is no data in the child segment.
In the simpler case where you want to see if MC-UPIN is filled in for a doctor:
Set up computed select field on page 2
xx.ck EQ
1
Set up that field as follows
xx.ck
DAT=INT
LEN=1
[EMAIL PROTECTED]"MC-UPIN"] "";1}
If you wanted to make the report flexible, so that the user could enter the pin
mnemonic to check:
Have an IG select on Page 2 to collect the desired pin to check:
MIS.INS.PIN.mnemonic IG
PIN TO CHECK
xx.ck EQ
1
DAT=INT
LEN=1
[EMAIL PROTECTED] "";1}
Joe Cocuzzo
Vice President
NPR Services
Iatric Systems, Inc.
Phone/Fax: (978) 805-4115
Email: [EMAIL PROTECTED]
Web: www.iatric.com
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Benoy, Marc
Sent: Friday, February 02, 2007 1:10 PM
To: [email protected]
Subject: NPR - How to find Data in a Dictionary that Does NOT Exist
Hi,
I am having a problem with returning data from a dictionary when that incidence
does not exist.
Can you help?
More specifically, I have been asked to write a report that gives me those
physicians that do not have a certain insurance pin and number.
I am able to return physicians that do have a certain pin but not those that do
not. Mistakenly, I wrote first the report with a select operator of NE but this
simply leads to the report not to print the PIN and number for those physicians
that do have it.
Example:
Our INS contains three choices: MC-UPIN, MCD-UPIN, and NPI.
In the MIS Provider dictionary a provider may be assigned any of the above
(multiple group response).
How do I retrieve those providers that "do" not have one or many of these, e.g.
which provider does not have the NPI pin.
Thanks,
Marc
Marc Benoy RN, MS, MBA
Clinical IT Project Manager
301.552.8876 (Phone)
301.552.8181 (Fax)
[EMAIL PROTECTED]
Doctors Community Hospital
8118 Good Luck Road
Lanham, MD 20706
Magic LIVE 5.4 and TEST 5.4 & 5.61
CONFIDENTIALITY STATEMENT: This communication, including attachments, is for
the exclusive use of addressee and may contain proprietary, confidential or
privileged information. If you are not the intended recipient, you are hereby
notified that any disclosure, use, copying, dissemination, distribution or
taking of any action in reliance on the content of this information is strictly
prohibited. If you are not the intended recipient, please notify the sender
immediately by return email and delete this communication and destroy all
copies. 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
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
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
