Dear Colleagues!
Please help me to deal with my problem.
I have a table in my source database which contains the care sites (exactly departments), but this table has been versioned by effective and expiry date columns. Mostly the changes are simple renaming, but sometimes this changes are part of a merging or separation process. The location did not change so I can’t store it in location history table.
In short: only the care care_site_name getting change but the care_site_source_value not.
For our researchers it is very important to know that what was the care site valid name when the visit was.
Is it a correct way for resolving this problem that i increase my care_site table with two column (effective_date and expiry_date)?
Will Atlas working well with these kind of modification?
My other idea is to inserting into the location history table with same location data. In this way I can versioning the care site table too, but i store the same location as many time any renaming happened. - I think this is more “hacky” than adding new columns to the table.
If anyone has a suggestion or idea, many thanks if you share it me.
Br,
Adam