Lab table

jamesx2 · Post by **jamesx2** » Mon Feb 25, 2008 9:41 pm

Which table has all the lab information on it? I am slowly learning how to write my own query reports. I would like to write one for lab cases but the only table I see with lab is the appointment table and all the values are 0. I am assuming that there is another table that has the lab info.

Post by **jordansparks** » Mon Feb 25, 2008 9:57 pm

labcase

jamesx2 · Post by **jamesx2** » Tue Feb 26, 2008 3:11 pm

I have been playing around with the lab table and have come up with a couple suggestions.

1) It would be nice if we can assign a couple labcases to the same appointment. We sometimes deliver a couple labcases to the patient on the same appointment.

2) It would be nice if we could track the amount of money the lab is charging us for each case.

3) Have some way to track redo cases. It would be nice to be able to track redo cases so we can make sure that the lab is not charging us for cases that need to be redone due to errors on the lab's part.