I'd maintain a small csv file with two fields Denial Code and Text you want to use.
A small loop to first open the file and count the lines. Then a small loop to redimension an array with the current count and populate it. Then use a lookup (binary or sequential) to match the code and pop in the text. Shirley Hammack I.T. Financial Analyst Duncan Regional Hospital 580-251-8939 From: [email protected] [mailto:[email protected]] Sent: Friday, February 20, 2009 7:54 AM To: [email protected] 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 Please consider the environment before printing this e-mail. "CONFIDENTIALITY NOTICE: This e-mail and any files transmitted with it are the property of DRH and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify 580.251.8773 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." --- 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
