StaffData/Deprecated/StaffCovidInfection

Table containing results for returned/reported COVID diagnostic tests on CDCR staff

StaffId
Anonymized integer uniquely identifiying each staff member. StaffId is stable across tables and timepoints. 88758923, -9450823
 * Examples

ViralTestDate
Collection date of most recent test. In cases where more than one test is collected on the same day, positive tests are picked first, then negative tests, then indeterminate tests. If a tie remains, the last test result that day will be picked. Note: In some cases, the test result is reported by the employee and test collection date is not known. In these cases, the date CDCR was informed by the employee is used as the test collection date. 2019-11-05, 2020-01-31
 * Examples

ViralTestReceivedDate
Date most recent test result received by CDCR, when known. 2020-05-07
 * Example

ViralTestResult
The test result. DETECTED, NOT DETECTED, INDETERMINATE
 * Values

OrderName
Available information regarding the type of test performed. Note: Due to issues in the source data, some values are missing or irrelevant and in other cases, the full order description is truncated. SARS-CoV-2 NAA, SARS CoV 2 RNA, COVID-19
 * Examples:

Specimen
Collection site of test Oropharyngeal; Nasal
 * Examples

Vendor
The vendor of the lab test. In cases where the employee reported the result to CDCR, the vendor is listed as "Sharepoint" MDX; MMED
 * Examples

Details
Pipe (|) delimited list of the the N1 and N2 cycle threshold values as well as any variant detected, when available. Note, this information is only available on a small subset of tests. |N1Ct: 36.1186 |N2Ct: 44.383 |N1Ct: 23.0849 |N2Ct: 22.9991 |Variant: SARS-CoV-2 - B.1.617.2 lineage |N1Ct: 27.538 |N2Ct: 33.907 |Variant: Wild Type
 * Examples