Hello all, Thanks for all your replies; however I am looking for those physicians that do "not" have a certain NPI pin.
Therefore on page two I have to have a select where I enter the INS pin that I
am looking for and loop this through all the possible pins a provider may have.
The providers that do not have this INS pin, these are the ones I am looking
for.
Example:
Doctor A MC-UPIN 123
MDC-UPIN 456
NPI 789
Doctor B MC-UPIN 111
MDC-UPIN 222
If I am looking for those physicians with no "NPI", then Doctor B should be
returned.
Thanks for your time,
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.
-----Original Message-----
From: Joe Cocuzzo [mailto:[EMAIL PROTECTED]
Sent: Friday, February 09, 2007 8:07 AM
To: Benoy, Marc; [email protected]
Subject: RE: NPR - How to find Data in a Dictionary that Does NOT 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.
<<winmail.dat>>
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= 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
