The Covid_rept query in CFE contains a list of patients who have either COVID-19 (SARS-COV-2) confirmed or are under Observation for suspected infection NOS for it.
- Julie, pls have a look at that query in CFE and let me know if it contains what we need, otherwise explain what we need.
- The query looks great. Just one additional request on the pivot - please make the column area to be combination of Arrived_Dt and Obs_for_Covid in order to show the trend across time. Thanks. --JMojica 08:58, 2020 April 20 (CDT)