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
KenGersing
commented
6 years ago
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