Looking to validate my design - I have a master file - a billing category table with billing ID , description, service fee, create date, last maintained date, inactive date. If whatever reason there is an increase in fee for (billing id : 19 - desc: Main category ) - my design as it stands would update last maintained date and populate inactive date for record 19 with the date of termination … then create a record with (id: 20 and the same desc: Main category) the new increased service fee. and populate create & last maintained date populated with the date of creation leaving the inactive date null.
From that point on we would have to attach the new record 20 to all the customers who had 19 going forward with an effective date of the change.
What other options are there?