CSP #2028 - Data documentation - Seattle Epidemiologic Research and Information Center (ERIC)
Attention A T users. To access the menus on this page please perform the following steps. 1. Please switch auto forms mode to off. 2. Hit enter to expand a main menu option (Health, Benefits, etc). 3. To enter and activate the submenu links, hit the down arrow. You will now be able to tab or arrow up or down through the submenu options to access/activate the submenu links.

Seattle Epidemiologic Research and Information Center (ERIC)

Menu
Menu

Quick Links

Veterans Crisis Line Badge
My healthevet badge
 

CSP #2028 - Data documentation


Participant data comes from four main sources: 

  1. Prospective survey data, detailed below, is collected via REDCap and transformed for long term storage in SQL 
  2. Historic VA electronic medical data, detailed below 
  3. De novo biospecimens 
  4. Participant tracking data

Prospective survey data

Documentation

Prospective Survey Data Dictionary

MVP COVID-19

The MVP COVID-19 Survey was developed for use by the Million Veteran Program. For this study, this survey is administered once at enrollment. Data include demographic information, a detailed symptom report, report of any testing and treatment, an evaluation of how COVID has impacted their daily lives, and non-COVID diagnoses and medication use. Data is stored in the REDCap schema, MVPCOVID19 table.

Flu-Related Symptoms Questionnaire

The Flu-Related Symptoms Questionnaire is collected at baseline and at up to 10 follow up study visits. Data include a detailed symptoms report (FluPRO®) and medication use. Repeat assessments are stored in a long format in the REDCap schema, FluPro table.

Vaccines Questionnaire

The Vaccinations Questionnaire is collected at baseline and at up to 10 follow up study visits. In each questionnaire, participants are asked to report if they have received any COVID-19 vaccinations since the last time the questionnaire was collected. Data are stored in a long format with one row per vaccine dose reported in the REDCap schema, Vaccines table.

Long-Term Symptoms Questionnaire

The Long-Term Symptoms Questionnaire is collected at up to 10 follow up study visits (i.e., not at the enrollment visit). Data include an evaluation of general health, functional status, report of symptoms, and report of recent testing and hospital admission. Repeat assessments are stored in a long format in the REDCap schema, LongTermSymptoms table.

Historic VA electronic medical record data 

Electronic medical record data from January 1, 2018 to present day are extracted and regularly updated for all EPIC3 participants. Extraction of fields that approximate prospective infectious disease data collected by the Department of Defense (DoD) was prioritized.

Extracted data are organized into the following tables: 

  • Dflt.Extract_DiagnosticAdminCodes
  • Dflt.Extract_ProcedureAdminCodes
  • Dflt.HealthFactorsDetail_Tobacco-GCS
  • Dflt.ID_DeathDate
  • Dflt.ID_LengthOfService
  • Dflt.ID_Outcome_Transfers_NonVA
  • Dflt.ID_Outcome_Transfers_VA
  • Dflt.ID_Transfers
  • Dflt.Patient_LabResults
  • Dflt.REF_DiagnosticAdminCodes
  • Dflt.REF_Drugs
  • Dflt.Ref_HealthFactors
  • Dflt.REF_HF_Tobacco_GCS
  • Dflt.REF_Lab_CombinedAll
  • Dflt.REF_ProcedureAdminCodes
  • Dflt.TEMP_PatientLabChem
  • Dflt.TEST_OrderedCOVLabs
  • Dflt.UploadCLCs
  • Dflt.Vitals_HtWtBMI

Documentation

Specific data fields are described in Retrospective Data Dictionary.

A description of how extracted data fields map to VA EHR data fields and the prospective infectious disease data collected by the DoD is provided in VA Retrospective EHR Map to DoD Infectious Disease Survey.

Conditions and procedures

Both binary indications of the diagnosis of conditions and occurrence of procedures within a given number of days following the index date from the COVID Shared Data Resource and individual administrative codes indicating diagnosis or procedure with the date the code was applied in the EHR were included in the extract.



Return to CSP #2028 home