As far as the other data tables; Visits go in a separate encounter
table (BP, etc). Lab results in a table related to encounters. I
consider this a pretty small and simple project.
Hi Beatrice,
I am assuming that Jeff is stateside. He may have a few things that
you wouldn't have. There are the HIPPA provisions. In addition,
where the clinical management database I worked on got fairly
complicated was when it got into payments. In Canada there is one
payer most times. In this system there had to be provision for
multiple payers and provision to capture multiple receipts per event.
Their system is complicated.
I am only commenting because in Jeff's original post he talks of
insurance numbers. I am not sure how far he would take this within
what he is planning. If it does get to billing and receipts, the
focus does change at least in that part of the system.
If billing is a separate issue, you are right in that it becomes an
event capture which is patient focused.
Dave McQueen
--
...................
David A. McQueen
LICHEN Software
Barrie, ON, CANADA
www.lichen-software.com
(705)720-9022