search

ncats / CTSA-Metrics

17 stars 16 forks source link

Incorrect use of table alias in OMOP Postgres SQL script #42

Closed sguptawustl closed 2 years ago

sguptawustl commented 2 years ago

A couple of column names use table alias that are not appropriate. Please see details below. This is with reference to https://github.com/ncats/CTSA-Metrics/blob/master/Informatics%20Metric%20OMOP%20PostgreSQL.sql

Issue instance #1: line# 219 ----> WHERE DATE_PART('year', per.birth_datetime) < 1900 description of issue: non-existing table alias 'per' in 'per.birth_datetime'

Issue instance #2: line# 240 ----> WHERE DATE_PART('year', per.birth_datetime) < 1900 description of issue: non-existing table alias 'per' in 'per.birth_datetime'