Sorry, I resent it thinking it never went. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Wednesday, May 30, 2012 12:25 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: accounting question; medical billing systems
Dennis, I got two copies of your previous post, one with 10:24 am Sent Stamp 10:29 AM received stamp and the other with a 11:01 AM Sent stamp and a 11:02 AM Received stamp. I am in another Google based List (MapInfo-L, GIS) and my provider (Go Daddy) decided to block essentially all e-mail from that List. Google will not provide bounce-backs so Go Daddy cannot determine why the e-mails are being bounced; a completely unacceptable situation with no potential solution in sight. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Wednesday, May 30, 2012 11:51 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: accounting question; medical billing systems I'm not getting any copies of mine back, but they are apparently being posted. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ben Petersen Sent: Wednesday, May 30, 2012 11:39 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: accounting question; medical billing systems I've noticed that I'm getting back two copies of my post. Is that happening to others? > Family Table (holds address, home phones, and primary addressee link) Did I understand that there was a bill-to column here also? > Patient Table (holds name, personal phones, e-mail, date of birth, > family and "bill to" links) > Transaction table (holds date, time, patient link, etc) > Transaction detail table ( links to transaction table, holds line > item, price, quantity, patient share, and payments/credits) My reflexive inclination here would be to not have the patient share as a separate column, but a separate line item. Each line item with it's own bill-to, using the patient id for their share. Eliminate bill-to's from other tables. > I'm moving toward changing this hierarchy, putting the Patient table > at the top, with the family table just being an incidental (and > temporary) location link. Yep. > I kind of like the idea of a person having several different addresses > so maybe a separate linking table is actually needed as Bill D. > suggests. It works well in the app I mentioned. Same for Phone/Fax > One last thing. I've always had charges and credits in the same > column in the trans. detail table, with charges being positive > currencies and credits being negative, simple summing them > establishing running balances. Anyone object to that method, or > should I separate out credits into their own table? Like so many things it depends, but if it haven't gotten in your way so far, I don't think there is anything inherently wrong with it. Ben
