PRS

The AS_OF_DATE is used to search through data that was active as of (at the time of) the specified date. This means that the record has an EFFECTIVE_END_DATE > AS_OF_DATE. This does not mean that the EFFECTIVE_START_DATE is not > the AS_OF_DATE. The AS_OF_DATE is not used to match on records that were effective at the time of the specified date.