help with date field and normalization

[jeff5656]

I am making many tables in an attempt to normalize my relataional database.  I cannot figure out how to handle the date - the billing data changes each day - not sure where to store this.  Here are my tables:

 

patient_table: has pt_id, patient name, medical record number date of admission etc.

billing_table has: billing_id, HP (enum L,M,H), consult (also enum L,M,H), and some others.

 

Now each day someone will choose the billing level (radio button).  Which table would each day get stored in?  Do I make a new table or add a column to one of the above tables? 

If this is unclear let me know.  I have other tables (i.e list of diagnoses, but I left that out).

[crtreedude]

It would seem to me that you need a detail table, which uses both your patient and billing table (since it appears your billing table is billable codes or something)

 

You need a table for the invoice, and then you would have the detail for the invoice.

 

Or so I would think.