You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 27 Next »


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


All Rules


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 Hospital Inpatient Beds

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

  • HHS: Adult Hospital Inpatient 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 <= #All Hospital Inpatient Beds OccupancyThe number of occupied adult inpatient beds cannot be greater than the total number of occupied inpatient beds.
  • HHS: Adult Hospital 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
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
P1Patients(#Total hospitalized adult suspected/confirmed + #Hospitalized Peds suspected/confirmed) <= #All Hospital BedsThe number of suspected and confirmed adult patients plus the number of suspected and confirmed pediatric patients cannot be greater than the total number of beds.
  • HHS: Total hospitalized adult suspected/confirmed
  • HHS: Hospitalized Peds Confirmed/Suspected COVID
  • HHS: All Hospital Beds
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
P12Patients#Total ICU adult suspected/confirmed <= Total hospitalized adult suspected/confirmedThe number of suspected ICU patients cannot be greater than the total number of suspected patients.
  • HHS: Total ICU adult suspected/confirmed positive
  • HHS: Total hospitalized adult suspected/confirmed
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 COVID)The 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
P15Patients

(#Hospitalized adult suspected/confirmed - #Hospitalized adult confirmed) <= (#Total hospitalized adult suspected/confirmed + #Hospitalized Peds suspected/confirmed) - (#Hospitalized adult confirmed COVID + #Hospitalized pediatric confirmed COVID)

The number of COVID suspected adult patients cannot be greater than the total number of COVID suspected patients.
  • HHS: Total hospitalized adult suspected/confirmed
  • HHS: Hospitalized Peds Confirmed/Suspected COVID
  • HHS: Hospitalized adult confirmed-positive COVID
  • HHS: Hospitalized ped confirmed-positive
P16Patients(#Total ICU adult suspected/confirmed - #Hospitalized ICU adult confirmed COVID) <= #Total suspected/confirmed patients in ICUThe number of ICU adult suspected or confirmed positive COVID patients cannot be greater than the total number of COVID suspected patients in the ICU.HHS: Suspected COVID in ICU
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 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
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

P28Patients#Suspected COVID in ICU is required.The number of suspected COVID in the ICU is required.HHS: Suspected COVID in ICU
P29Patients#Confirmed COVID in ICU is required.The number of confirmed COVID in the ICU is required.HHS: Confirmed COVID in ICU
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