Hi, I'm working on a db for reimbursement of contractors. The hourly rates depend on the case that the individual performs. Rates change over time as you would expect and these rates are set in the care_rate table.
Should the reimbursement rate be captured in the timeclock table as a fixed amount at the time of entry (by selecting from rate table) or should it contain the id of the case as shown in the timeclock table?
Alternate timeclock table (recording of contractor time)
case_rate (25.00 for example)