@Raghavendra Raghunath-Oracle @Bhaskar Konar@Gina DiVenti Yes, we have explored many options. In OTBI, although the subject area will show the effective date, it will still only pull in the most recent or current address row, and not show previous addresses. We have tried building an analysis with and without the address…

The logic of this proposed solution for the flags is correct - however, I think it would also be useful to have one field that does this logic and displays the correct and final Ethnicity/Race versus only adding 2 additional flags to report on? Suggest calling it US Federal Ethnicity/Race and then it would display the full…