search

Analyticsphere / bq2

SQL query development for Connect for Cancer Preventions' BQ2 database.
https://analyticsphere.github.io/bq2/
0 stars 1 forks source link

Filter out deprecated variables #26

Open jacobmpeters opened 9 months ago

jacobmpeters commented 9 months ago

We need to add a column-level filter that filters out deprecated variables.

We are operating under the assumptions that

  1. When a variable is listed as "Deprecated" in the Deprecated, New, or Revised column of the Data Dictionary, it should be excluded from BQ2.
  2. When a variable is listed as "New" or "Revised" in the Deprecated, New, or Revised column of the Data Dictionary, it should be included in BQ2 unless other filters apply.