Home > EMResource > Community Resources - General > Validation Rules for HHS COVID Data


This document provides information about the current HHS COVID dataset, Juvare offerings to expedite configuration and automatic submissions, instructions on standing up reporting, and suggestions to streamline data collection. This document is updated as revisions are introduced.


Beds


Group

Rule (ID Expression)

User-Friendly Validation Message

Standard Status Types
B1Beds

#All Adult Hospital Beds <= #All Hospital Beds

The number of adult beds cannot be greater than the total number of beds.

  • HHS: All Adult Hospital Beds
  • HHS: All Hospital Beds
B2Beds

#All Hospital Inpatient Beds <= #All Hospital Beds

The number of inpatient beds cannot be greater than the total number of beds.

  • HHS: All Hospital Inpatient Beds
  • HHS: All Hospital Beds
B3Beds

#Adult Hospital Inpatient Beds + #All Inpatient Pediatric Beds <= #All Hospital Inpatient Beds

The number of inpatient adult beds and inpatient pediatric beds cannot be greater than the total number of inpatient beds.

  • HHS: Adult Hospital Inpatient Beds
  • HHS: All Inpatient Pediatric Beds
  • HHS: All Hospital Inpatient Beds
B4Beds#All Hospital Inpatient Beds Occupancy <= #All Hospital Inpatient BedsThe number of occupied inpatient beds cannot be greater than the total number of inpatient beds.
  • HHS: All Hospital Inpatient Beds Occupancy
  • HHS: All Hospital Inpatient Beds
B5Beds#Adult Hospital Inpatient Bed Occupancy + #Pediatric Inpatient Bed Occupancy <= #All Hospital Inpatient Beds OccupancyThe number of occupied adult inpatient beds and occupied pediatric inpatient beds cannot be greater than the total number of occupied inpatient beds.
  • HHS: Adult Hospital Inpatient Bed Occupancy
  • HHS: Pediatric Inpatient Bed Occupancy
  • HHS: All Hospital Inpatient Beds
B6Beds#ICU Beds <= #All Hospital Inpatient BedsThe number of ICU beds cannot be greater than the total number of inpatient beds.
  • HHS: ICU Beds
  • HHS: All Hospital Inpatient Beds
B7Beds#Adult ICU Beds <= #ICU BedsThe number of adult ICU beds cannot be greater than the total number of ICU beds. 
  • HHS: Adult ICU Beds
  • HHS: ICU Beds
B8Beds#ICU Bed Occupancy <= #ICU BedsThe number of occupied ICU beds cannot be greater than the total number of ICU beds.
  • HHS: ICU Bed Occupancy
  • HHS: ICU Beds
B9Beds#Adult ICU Bed Occupancy <= #Adult ICU BedsThe number of occupied adult ICU beds cannot be greater than the total number of adult ICU beds.
  • HHS: Adult ICU Bed Occupancy
  • HHS: Adult ICU Beds
B10Beds#Adult ICU Bed Occupancy <= #ICU Bed OccupancyThe number of occupied adult ICU beds cannot be greater than the number of occupied ICU beds.
  • HHS: Adult ICU Bed Occupancy
  • HHS: ICU Bed Occupancy
B11Beds#All Hospital Inpatient Beds Occupancy <= #All Hospital BedsThe number of occupied inpatient beds cannot be greater than the total number of beds.
  • HHS: All Hospital Inpatient Beds Occupancy
  • HHS: All Hospital Beds
B12Beds#All Hospital Beds <= 9999The number of hospital beds cannot be greater than 9999.

HHS: All Hospital Beds

B13Beds#All Adult Hospital Beds <= 9999The number of adult hospital beds cannot be greater than 9999.HHS: All Adult Hospital Beds
B14Beds#Hospital Inpatient Bed Occupancy <= 9999The number of inpatient bed occupancy cannot be greater than 9999.HHS: All Hospital Inpatient Beds
B15Beds#Adult Hospital Inpatient Bed Occupancy <= 9999 The number of adult inpatient bed occupancy cannot be greater than 9999.HHS: Adult Hospital Inpatient Beds
B16Beds#All Hospital Inpatient Beds <= 9999The number of inpatient beds cannot be greater than 9999.HHS: All Hospital Inpatient Beds
B17Beds#All Adult Hospital Inpatient Beds <= 9999 The number of adult inpatient beds cannot be greater than 9999.HHS: Adult Hospital Inpatient Beds
B18Beds#ICU Bed Occupancy <= 9999The number of ICU bed occupancy cannot be greater than 9999.HHS: ICU Beds
B19Beds#Adult ICU Bed Occupancy <= 9999The number of adult ICU bed occupancy cannot be greater than 9999.HHS: Adult ICU Beds
B20Beds#All ICU Beds <= 9999The number of ICU beds cannot be greater than 9999.HHS: ICU Beds
B21Beds#All Adult ICU Beds <= 9999The number of adult ICU beds cannot be greater than 9999.HHS: Adult ICU Beds
B22Beds#All Pediatric Inpatient Beds null The number of pediatric inpatient beds is required. 

HHS: All Inpatient Pediatric Beds

B23Beds

#Pediatric Inpatient Bed Occupancy null 

The number of pediatric inpatient bed occupancy is required. 

HHS: Pediatric Inpatient Bed Occupancy

B24Beds#Total Staffed Pediatric ICU Beds null The number of pediatric ICU beds is required. 

HHS: Staffed Pediatric ICU Beds

B25Beds#Staffed Pediatric ICU Bed Occupancy null The number of pediatric ICU bed occupancy is required. 

HHS: Staffed Pediatric ICU Bed Occupancy

B26Beds#All Pediatric Inpatient Beds <= #All Hospital Inpatient BedsThe number of pediatric ICU bed occupancy cannot be greater than the number of all inpatient beds.
  • HHS: Pediatric ICU Bed
  • HHS: All Hospital Inpatient Beds
B27Beds#Pediatric Inpatient Bed Occupancy <= #All Pediatric Inpatient BedsThe number of pediatric inpatient bed occupancy cannot be greater than the number of all inpatient pediatric beds. 
  • HHS: Pediatric Inpatient Bed Occupancy
  • HHS: All Inpatient Pediatric Beds
B28Beds#Staffed Pediatric ICU Bed Occupancy <= #All Pediatric Inpatient Beds The number of pediatric ICU beds cannot be greater than the number of all inpatient pediatric beds. 
  • HHS: Pediatric ICU beds
  • HHS: All Inpatient Pediatric Beds
B29Beds#Total Staffed Pediatric ICU Beds <= #All ICU BedsThe number of pediatric ICU beds cannot be greater than the number of ICU beds. 
  • HHS: Pediatric ICU beds
  • HHS: ICU Beds
B30Beds#Staffed Pediatric ICU Bed Occupancy <= #Pediatric Inpatient Bed OccupancyThe number of pediatric ICU bed occupancy cannot be greater than the number of pediatric inpatient bed occupancy. 
  • HHS: Pediatric ICU Bed Occupancy
  • HHS: Pediatric Inpatient Bed Occupancy
B31Beds#Staffed Pediatric ICU Bed Occupancy <= #ICU Bed OccupancyThe number of pediatric ICU bed occupancy cannot be greater than the number of ICU bed occupancy. 
  • HHS: Pediatric ICU Bed Occupancy
  • HHS: ICU Bed Occupancy

Vents


Group

Rule (ID Expression)

User-Friendly Validation Message

Standard Status Types
V1Vents#Mechanical ventilators in use <= #Total Mechanical ventilatorsThe number of mechanical ventilators in use cannot be greater than the total number of mechanical ventilators.
  • HHS: Mechanical ventilators in use
  • HHS: Total Mechanical ventilators

Patients


Group

Rule (ID Expression)

User-Friendly Validation Message

Standard Status Types
P2Patients#Hospitalized adult confirmed COVID <= #Total hospitalized adult suspected/confirmedThe number of confirmed adult patients cannot be greater than the number of suspected and confirmed adult patients.
  • HHS: Hospitalized adult confirmed-positive COVID
  • HHS: Total hospitalized adult suspected/confirmed
P3Patients#Hospitalized peds confirmed COVID <= #Hospitalized Peds suspected/confirmedThe number of confirmed pediatric patients cannot be greater than the number of suspected and confirmed pediatric patients.
  • HHS: Hospitalized peds confirmed-positive COVID
  • HHS: Hospitalized Peds suspected/confirmed COVID
P4Patients#Hospitalized and ventilated COVID patients <= #Mechanical ventilators in useThe number of hospitalized and ventilated COVID patients cannot be greater than the total number of ventilators in use.
  • HHS: Hospitalized and ventilated COVID patients
  • HHS: Mechanical ventilators in use
P5Patients#Hospitalized ICU adult confirmed COVID <= #Adult ICU Bed OccupancyThe number of confirmed adult ICU patients cannot be greater than the number of occupied ICU beds.
  • HHS: Hospitalized ICU adult confirmed-positive COV
  • HHS: Adult ICU Bed Occupancy
P6Patients#Hospitalized ICU adult confirmed COVID <= #Hospitalized adult confirmed COVIDThe number of confirmed adult ICU patients cannot be greater than the number of confirmed adult patients.
  • HHS: Hospitalized ICU adult confirmed-positive COV
  • HHS: Hospitalized adult confirmed-positive COVID
P7Patients#Hospital Onset <= #All Hospital Beds The number of hospital-onset patients cannot be greater than the total number of beds.
  • HHS: Hospital Onset
  • HHS: All Hospital Beds
P8Patients#ED/Overflow and Ventilated <= #ED/OverflowThe number of ventilated ED overflow COVID patients cannot be greater than the total number of ED overflow COVID patients.
  • HHS: ED/Overflow and Ventilated
  • HHS: ED/Overflow
P9Patients#Prev Day COVID Related ED Visits <= #Prev Day Total ED VisitsThe number of COVID-related ED visits in the last 24 hours cannot be greater than the number of ED visits in the last 24 hours.
  • HHS: Prev Day COVID Related ED Visits
  • HHS: Prev Day Total ED Visits
P10Patients#Total ICU adult suspected/confirmed <= #ICU Bed OccupancyThe number of ICU adult suspected or confirmed positive COVID patients cannot be greater than the number of occupied ICU beds.
  • HHS: Total ICU adult suspected/confirmed positive
  • HHS: ICU Bed Occupancy
P11Patients#Hospitalized ICU adult confirmed COVID <= #Total ICU adult suspected/confirmedThe number of confirmed adult ICU patients cannot be greater than the number of ICU adult suspected or confirmed positive COVID patients.
  • HHS: Hospitalized ICU adult confirmed-positive COV
  • HHS: Total ICU adult suspected/confirmed positive
P13Patients#Hospitalized ICU adult confirmed COVID <= #Confirmed COVID in ICUThe number of confirmed adult ICU patients cannot be greater than the total number of confirmed ICU patients.
  • HHS: Hospitalized ICU adult confirmed-positive COV
  • HHS: Confirmed COVID in ICU
P14Patients#Hospitalized adult confirmed COVID <= #Hospitalized adult confirmed COVID + #Hospitalized pediatric confirmed COVIDThe number of confirmed adult COVID patients cannot be greater that the total number of confirmed COVID patients.
  • HHS: Hospitalized adult confirmed-positive COVID
  • HHS: Hospitalized ped confirmed-positive
P17Patients#Hospitalized adult confirmed COVID + #Hospitalized pediatric confirmed COVID <= 9999The total number of COVID confirmed patients cannot be greater than 9999.
  • HHS: Hospitalized adult confirmed-positive COVID
  • HHS: Hospitalized ped confirmed-positive
P18Patients#Total confirmed COVID in ICU <= 9999The total number of COVID confirmed patients in the ICU cannot be greater than 9999.HHS: Confirmed COVID in ICU
P19Patients#Hospitalized ICU adult confirmed COVID <= 9999The number of COVID confirmed adult patients in the ICU cannot be greater than 9999.

HHS: Hospitalized ICU adult confirmed-positive COV

P20Patients#Total suspected/confirmed patients in ICU <= 9999The total number of COVID suspected patients in the ICU cannot be greater than 9999.HHS: Suspected/confirmed COVID in ICU
P21Patients#Total ICU adult suspected/confirmed - #Hospitalized ICU adult confirmed COVID <= 9999The number of COVID suspected adult patients in the ICU cannot be greater than 9999.
  • HHS: Hospitalized ICU adult suspected/confirmed COV
  • HHS: Hospitalized ICU adult confirmed-positive COV
P22Patients#Prev Day Total ED Visits <= 9999The number of ED visits in the last 24 hours cannot be greater than 9999.

HHS: Prev Day Total ED Visits

P23Patients#Prev Day Deaths <= 9999The number of deaths in the last 24 hours cannot be greater than 9999.

HHS: Prev Day Total Deaths

P24Patients#Total hospitalized adult suspected/confirmed is required.The number of adult suspected or confirmed patients is required.

HHS: Total hospitalized adult suspected/confirmed

P25Patients#Hospitalized adult confirmed COVID is required.The number of adult confirmed COVID is required.

HHS: Hospitalized adult confirmed-positive COVID

P26Patients#Hospitalized Peds suspected/confirmed is required.The number of pediatric suspected or confirmed patients is required.

HHS: Hospitalized Peds suspected/confirmed 

P27Patients#Hospitalized peds confirmed COVID is required.The number of pediatric confirmed COVID is required.

HHS: Hospitalized peds confirmed-positive COVID

P30Patients#Total hospitalized adult suspected/confirmed <= #All Hospital Inpatient Beds OccupancyThe number of suspected/confirmed adult patients cannot be greater than the number of occupied inpatient beds.
  • HHS: Total hospitalized adult suspected/confirmed
  • HHS: All Hospital Inpatient Beds Occupancy
P31Patients#Previous Day's Confirmed Admits by Age (ALL + Peds) <= #All Hospital Inpatient Beds OccupancyThe number of confirmed COVID patients admitted in the last 24 hours cannot be greater than the number of occupied beds.
  • HHS: Prev day adult admits confirmed age unknown
  • HHS: Prev day adult admits confirmed COV 18-19
  • HHS: Prev day adult admits confirmed COV 20-29
  • HHS: Prev day adult admits confirmed COV 30-39
  • HHS: Prev day adult admits confirmed COV 40-49
  • HHS: Prev day adult admits confirmed COV 50-59
  • HHS: Prev day adult admits confirmed COV 60-69
  • HHS: Prev day adult admits confirmed COV 70-79
  • HHS: Prev day adult admits confirmed COV 80+
  • HHS: Prev day Peds Confirmed COV Admits
  • HHS: All Hospital Inpatient Beds Occupancy
P32Patients#Total hospitalized adult suspected/confirmed + #Hospitalized Peds suspected/confirmed <= #All Hospital Inpatient Beds OccupancyThe number of adult and pediatric confirmed/suspected patients cannot be greater than the number of occupied beds.
  • HHS: Total hospitalized adult suspected/confirmed
  • HHS: Hospitalized Peds Confirmed/Suspected COVID
  • HHS: All Hospital Inpatient Beds Occupancy
P33Patients#Hospitalized and ventilated COVID patients <= #Total hospitalized adult suspected/confirmed + #Hospitalized Peds suspected/confirmedThe number of ventilated COVID patients cannot be greater than the number of suspected/confirmed COVID patients.
  • HHS: Hospitalized and ventilated COVID patients
  • HHS: Total hospitalized adult suspected/confirmed
  • HHS: Hospitalized Peds Confirmed/Suspected COVID
P34Patients#Previous Day's Suspected Admits by Age (ALL + Peds) <= #All Hospital Inpatient Beds OccupancyThe number of suspected COVID patients admitted in the last 24 hours cannot be greater than the number of occupied beds.
  • HHS: Prev day adult admits suspected age unknown
  • HHS: Prev day adult admits suspected COV 18-19
  • HHS: Prev day adult admits suspected COV 20-29
  • HHS: Prev day adult admits suspected COV 30-39
  • HHS: Prev day adult admits suspected COV 40-49
  • HHS: Prev day adult admits suspected COV 50-59
  • HHS: Prev day adult admits suspected COV 60-69
  • HHS: Prev day adult admits suspected COV 70-79
  • HHS: Prev day adult admits suspected COV 80+
  • HHS: Prev day Peds suspected COV Admits
  • HHS: All Hospital Inpatient Beds Occupancy
P122Patients#ICUOccupied <= #Hospital_Inpatient_Bed_OccupancyThe number of occupied ICU beds cannot be greater than the total number of occupied inpatient beds.
  • HHS: ICU Bed Occupancy
  • HHS: All Hospital Inpatient Beds Occupancy
P123Patients#Influenza_COV_Conf_Prev_Day_Deaths <= #numConfC19PrevDiedThe previous day's deaths of patients with both influenza and COVID cannot be greater than the previous day's deaths due to COVID.
  • HHS: Influenza and COV Conf Prev Day's Deaths
  • HHS: Previous Day Deaths
P124Patients#Influenza_COV_Conf_Prev_Day_Deaths <= #Influenza_Confirmed_Prev_Day_DeathsThe previous day's deaths of patients with both influenza and COVID cannot be greater than the previous day's deaths due to influenza.

HHS: Influenza and COV Conf Prev Day's Deaths

HHS: Influenza Confirmed Prev Day's Deaths

Remdesivir


Group

Rule (ID Expression)

User-Friendly Validation Message

Standard Status Types
R1Remdesivir#Remdesivir Remaining <= 999,999The current inventory of Remdesivir cannot be greater than 999,999.HHS: Remdesivir
R2Remdesivir#Remdesivir Used <= 999,999The number of Remdesivir doses used on the previous day cannot be greater than 999,999.HHS: Remdesivir
  • No labels