This came up again in another use case for Compliance today - salary Grade Rate fields for Min, Midpoint, and Max would be really helpful!

@mgoswami I don't think works for our use cases, because this only allows to pull one specific date, versus a range of dates (for example 1/2025-12/2025). But this is still a good trick to know! Thank you.

@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…