ResidentData/Deprecated/CovidInfection

This table comprises data related to measuring and mitigating the COVID pandemic in CDCR.

Day
The day for which the record applies 2019-11-06, 2020-01-31
 * Examples

Month
Integer representing the year and month for which the record applies 201911, 202001
 * Examples

ResidentId
Stable anonymized signed integer ID value for the resident 578998371, -456578293
 * Examples

Sequence
An integer that uniquely identifies the specific record when there are multiple records of the same type for a given resident, ordered by most recent first. For example, if a given resident has three viral tests, test A collected on February 1, 2021 at 0800, test B collected on February 2, 2021 at 0800, and test C collected on February2, 2021 at 1200, then the sequence for the elements associated with each test would be as follows:

Element
The data element type. Elements can be any of the following:

CovidLOC
The COVID-related status of the resident as of the end of that day. Warning: ER, Telemetry, Med/Surg, Med/Surg ICU, ICU, ICU/Vent, and Resolved may be underreported in this data element. Naive, Confirmed Active, Quarantine, Isolation, Resolved, ER, Telemetry, Med/Surg, Med/Surg ICU, ICU, ICU/Vent, Died
 * Values

ViralTestStatus
Result of a COVID viral test (pcr OR antigen). Negative, Positive
 * Examples

ViralTestType
Concatenated descriptions of assay entered into EHRS and/or by the lab for the viral test. "CoV-2 RNA QUAL RT-PCR+(COVID19)-39433 PAN-SARS RNA", "Misc Test Other+COVID19"
 * Examples

ViralTestDate
Collection date of last completed viral test. Note that in cases where multiple tests with the same result have been collected, ViralTestDate should change to reflect the latest collection date of each test. 2020-12-01, 2021-02-09
 * Examples

ViralTestResultDate
Date last completed viral test result was recorded in the medical record. 2020-12-01, 2021-02-09 Note the possibility of cases where two or more tests collected on different days are received back on the same day. In this case, ViralTestResultDate will be the same across records for the same resident but with different ViralTestDates.
 * Examples
 * Comments

ViralTestSpecimen
Site of COVID specimen collection. Free text. Nasopharyngeal, NP+OP, Nasal
 * Examples

SxOnset
Equals 1 as of the day of COVID symptom onset per public health data. Stays as 1 until public health declares that symptoms have remitted, that the resident has been released from isolation, or that the case is resolved (whichever occurs first), at which point it switches to 0 for all subsequent days. null indicates no history of ever being symptomatic for COVID. Note that symptom onset often preceeds date of positive test collection. null,1,0
 * Values

Ili
Equals 1 if cough, shortness of breath, fever, temp>=37.8C, or SpO2<94 were recorded in the medical record on that day. Note that this is independent of COVID status. 0,1
 * Examples

HospitalizationDxs
This column under construction and currently not populated Comma-separated list of ICD 10 codes of the admitting diagnoses of any hospital admission that occurred on that day for that resident. Note that the hospitalization may or may not be related to COVID-19. 724.2, 789.0, 836.54, 995.3
 * Examples