Greetings,
Yeah this is a perfect place for a lookup table.
If the codes are unique (which in your case they are) then a Collection
is a great thing to use:
This will load the Collection
In the Declaration section of a module put
Dim DenialCodes as new collection
Sub loadCodes
d.open codefile...
do until d.eof
denialcodes.Add d("Full Text"),d("Code")
d.next_
loop
Now here's the magic.
All you need do to retrieve the value (full text) is to use:
Enter DenialCodes(MyCode) ' here MyCode is what you were comparing
against the list in your Select statement.
That's because the Code from above becomes a key in the collection.
Regards,
Thom
Thom C. Blackwell
Product Manager
Boston Software Systems
(866) 653-5105 ex 807
www.bossoft.com <http://www.bossoft.com/>
Sign up for my weekly webinar!
<http://www.bostonworkstation.com/customer_center/special_events.aspx>
LEGAL NOTICE Unless expressly stated otherwise, this message is
confidential and may be privileged. It is intended for the addressee(s)
only. Access to this E-mail by anyone else is unauthorized. If you are
not an addressee, any disclosure or copying of the contents of this
E-mail or any action taken (or not taken) in reliance on it is
unauthorized and may be unlawful. If you are not an addressee, please
inform the sender immediately, then delete this message and empty from
your trash.
From: [email protected] [mailto:[email protected]]
Sent: Friday, February 20, 2009 8:54
To: Talk
Subject: [talkbws] RE: Whats better than Select Case?
That's pretty much what I have.
Here is a short list of ANSI (denial reason codes) with their truncated
descriptions and our Laymen terms.
5
Proc Code/TOB Inconsistent W/P
OP ICD-9 procedure listed on IP acct
13
Date of Death Preceeds Date of
Wrong discharge date entered
16
Claim lacks info for Adjudicat
Ins request info from provider or patient
22
Pmt Adj/May be cov by other pa
Primary insurance not listed
24
Pmt Adj/Chgs cov by Capitation
Charges included in contract rate
Right now I'm using Select Case to say if X=22 then y=Primary insurance
not listed etc... The problem is once I get a substantial list set up
I don't want a Select Case function with 200 different cases. It would
work, but seems like such a pain to set up. I've thought about another
detestation but I've already got three going.
As I run the reports and find ANSI codes I want to substitute the laymen
description instead of the ANSI description for the final output.
Thanks.
p.s. do you remember the name of that example on the BWS website?
Brian Bennett
Affinity Health Systems
Systems Analyst
PBS\Clinic Billing
(920)628-9055
[email protected]
________________________________
From: [email protected] [mailto:[email protected]]
Sent: Thursday, February 19, 2009 8:43 AM
To: [email protected]
Subject: [talkbws] RE: Whats better than Select Case?
Greetings,
I take it this is a situation where you have:
If val=x then b="Q"
If val=z then b="P"
And there's lots of them then your lookup file is good approach and
there's an example to do that on our website.
But would need some details about what you're doing to suggest a "best"
approach.
Regards,
Thom
Thom C. Blackwell
Product Manager
Boston Software Systems
(866) 653-5105 ex 807
www.bossoft.com <http://www.bossoft.com/>
Sign up for my weekly webinar!
<http://www.bostonworkstation.com/customer_center/special_events.aspx>
LEGAL NOTICE Unless expressly stated otherwise, this message is
confidential and may be privileged. It is intended for the addressee(s)
only. Access to this E-mail by anyone else is unauthorized. If you are
not an addressee, any disclosure or copying of the contents of this
E-mail or any action taken (or not taken) in reliance on it is
unauthorized and may be unlawful. If you are not an addressee, please
inform the sender immediately, then delete this message and empty from
your trash.
From: [email protected] [mailto:[email protected]]
Sent: Thursday, February 19, 2009 9:23
To: Talk
Subject: [talkbws] Whats better than Select Case?
Anyone know if there is a better solution than Select Case? I thought
about using an answer file and looping for my If:then statements but am
not sure which would be better of there is an even better solution than
either the Case or answer files.
Thanks.
Brian Bennett
Affinity Health Systems
Systems Analyst
PBS\Clinic Billing
(920)628-9055
[email protected]
________________________________
CONFIDENTIALITY NOTICE: This e-mail communication and any attachments
may contain confidential and privileged information for the use of the
designated recipient(s) named above. If you are not the intended
recipient, you are hereby notified that you have received this
communication in error and that any review, disclosure, dissemination,
distribution or copying of it or its contents is prohibited. If you have
received this communication in error, please notify the sender at the
electronic mail address noted above and destroy all copies of this
communication and any attachments. Thank you for your cooperation.
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk
.aspx
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk
.aspx
________________________________
CONFIDENTIALITY NOTICE: This e-mail communication and any attachments
may contain confidential and privileged information for the use of the
designated recipient(s) named above. If you are not the intended
recipient, you are hereby notified that you have received this
communication in error and that any review, disclosure, dissemination,
distribution or copying of it or its contents is prohibited. If you have
received this communication in error, please notify the sender at the
electronic mail address noted above and destroy all copies of this
communication and any attachments. Thank you for your cooperation.
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk
.aspx
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
