How to identify valid concepts and concept relationships?

[schuemie]

Many queries like this one identify valid concepts and relationships by checking whether the current system date is between the valid_start_date and the valid_end_date. Although there's nothing incorrect about that, I always check whether invalid_reason IS NULL.

@ericaVoss, @alondhe: any thoughts on what should be recommended best practice?

[PRijnbeek]

Sysdate should be replaced by GETDATE() in the queries if we take this approach