ncats/CTSA-Metrics

Issue with Column Names for Observations Present - PCORnet Oracle Code

Closed this issue · 1 comments

Running the latest PCORnet Oracle code, 44b05d4, provided me with errors. I updated the column names as follows and then it ran successfully:
select 'Observations Present' AS domain, null as Patients_with_Standards, null as UNIQUE_TOTAL_PATIENTS, null as Percent_Standards , Case When Count(*) = 0 then 'No Observation' else 'Observations Present' end as values_present From Vital

Merged code closing issues