• Also, based on the phrasing of the question, it looks like a query against historical data. If all statuses were to be returned it could have been interpreted as show the most current status (or last status) on a given date.

    I did sort the data in descending order for a given claim by the complete date/time value which would put the most current status at the top of the list.