consider changing is_deceased NVARCHAR(2) NOT NULL to bit, and use a 1 and 0 instead.
where do you mention deceased date?
what's the purpose of "row is current", row start date and row end date?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle