I'd like to help. What I couldn't figure out:
-- There are duplicated rows in the Register table.
What is the reason of having them duplicated?
i.e. What is the granularity of the Register table?
-- How the Register table relates to the Turnup one?
Are there fields that common in both? Or may be
they could be built using some calculations?
These are questions helping to make sense of data.
Others may follow, but after answering those first.