Importing COVID-19 and Respiratory Infections using a .csv file

TOI-Facility Importing COVID-19 and Respiratory Infections using a .csv file_RIFC.docx

[NCEZID] National Healthcare Safety Network (NHSN) Coronavirus (COVID-19) Surveillance in Healthcare Facilities

Importing COVID-19 and Respiratory Infections using a .csv file

OMB: 0920-1317

Document [docx]
Download: docx | pdf


Facility - Importing COVID-19 and Respiratory Infections using a .csv file for Resident Impact and Facility Capacity (RIFC) summary data

  1. NHSN COVID-19 and Respiratory Infections Resident Impact and Facility Capacity Import File Format – use this format for calendar dates June 12, 2023 and going forward



Field

Requirement

Values

Format

Description of Field


orgid

Conditional

-

-

FACILITY IDENTIFIER – required if this is a group import. Note: If this is a facility import do not include this field in the .csv upload


collectionDate

Required

-

mm/dd/yyyy

Date for which patient counts are reported

numltcfbeds

Required

0 to 3000

Must be a whole number

Must be <=3000

ALL BEDS (FIRST SURVEY ONLY): Total number of beds within the certified Medicare and/or Medicaid long-term care facility

numltcfbedsocc

Required

0 to 3000

Must be whole number

Must be <= All Beds, if populated, or <=3000

CURRENT CENSUS: Total number of beds that are occupied on the reporting calendar day

numrespostest

Required

0 to 3000

Must be a whole number

POSITIVE TESTS: Number of residents with a new positive COVID-19 viral test result.

Exclude staff and facility personnel who have a positive SARS-CoV-2 antigen test, but a negative SARS-CoV-2 NAAT (PCR).

totResUpToDate

Conditional

0 to 3000

Must be a whole number

Required if numrespostest > 0

If entered must be </= numrespostest

UP TO DATE: residents who are up to date with COVID-19 vaccines 14 days or more before the specimen collection date.

totResNotUpToDate

Conditional

0 to 3000

Auto populated by the system. Do no need to enter a count in the csv file for this variable.

This variable is also Not editable by user within the application

NOT UP TO DATE: The count for residents who may or may not have been vaccinated with any COVID-19 vaccine but are NOT considered up to date

numResHospPos

Required

0 to 3000

Must be a whole number

HOSPITALIZATION WITH POSITIVE COVID19 TEST: Number of residents who have been hospitalized with a positive COVID-19 test

numResHospUpToDate

Conditional

0 to 3000

Must be a whole number

Required if

numResHospPos > 0

If entered must be </= numResHospPos

HOSPITALIZATIONS WITH A POSITIVE COVID-19 TEST AND UP TO DATE: the number of residents who were hospitalized with a positive COVID-19 test and also up to date with COVID-19 vaccinations at the time of the positive COVID-19 test.

numresdied

Required

0 to 10000

Must be a whole number

Must be <=10000

TOTAL DEATHS: Residents who have died for any reason in the facility or another location

numresc19died

Conditional

0 to 10000

Must be a whole number

Must be <=10000


Required if numresdied > 0


If entered, must </=

numresdied

COVID-19 DEATHS: Of the number of reported Total Deaths, report the number of residents with COVID-19 who died in the facility or another location.

Optional Influenza Variables

numresposflutest


0 to 3000

Must be a whole number

POSITIVE TESTS: Enter the number of residents with a newly positive Influenza test result.

totResUpToDateFlu

Conditional

0 to 3000

Must be a whole number. Required if numresposflutest > 0. If entered must be </= to numresposflutest

UP TO DATE: Include residents with a newly positive Influenza test result who are up to date with Influenza (flu) vaccines for the current flu season (2023-2024)

totResNotUpToDateFlu

Conditional

0 to 3000

Auto populated by a system. Do not need to enter a count in the csv file for this variable. This variable is also NOT editable by user within the application.

NOT UP TO DATE: Based on the counts entered for POSITIVE TESTS and UP TO DATE, the count for residents who are NOT considered up to date for the current flu season have been calculated here.

numResHospPosFlu


0 to 3000

Must be a whole number

Hospitalizations in residents with a positive Influenza Test: Number of residents who have been hospitalized with a positive Influenza test.

numResHospUpToDateFlu

Conditional

0 to 3000

Must be a whole number. Required if numResHospPosFlu > 0. If entered must be </= to numResHospPosFlu

Hospitalizations with a positive Influenza Test and Up to Date: Based on the number reported for "Hospitalizations with a positive Influenza Test" indicate the number of residents who were hospitalized with positive Influenza test and also up to date with Influenza vaccine at the time of positive Influenza test.

Optional RSV variables

numresposrsvtest


0 to 3000

Must be a whole number

POSITIVE TESTS: Enter the number of residents with a newly positive RSV test result.

totResUpToDateRsv

Conditional

0 to 3000

Must be a whole number. Required if numresposrsvtest > 0. If entered must be </= to numresposrsvtest

UP TO DATE: Include residents with a newly positive Influenza test result who are up to date with RSV vaccines for the current RSV season (2023-2024)

totResNotUpToDateRsv

Conditional

0 to 3000

Auto populated by a system. Do not need to enter a count in the csv file for this variable. This variable is also NOT editable by user within the application.

NOT UP TO DATE: Based on the counts entered for POSITIVE TESTS and UP TO DATE, the count for residents who are NOT considered up to date for the current RSV season have been calculated here.

numResHospPosRsv


0 to 3000

Must be a whole number

Hospitalizations in residents with a positive RSV Test: Number of residents who have been hospitalized with a positive RSV test.

numResHospUpToDateRsv

Conditional

0 to 3000

Must be a whole number. Required if numResHospPosRsv > 0. If entered must be </= to numResHospPosRsv

Hospitalizations with a positive RSV Test and Up to Date: Based on the number reported for "Hospitalizations with a positive RSV Test" indicate the number of residents who were hospitalized with positive RSV test and also up to date with RSV vaccine at the time of positive RSV test.







File Typeapplication/vnd.openxmlformats-officedocument.wordprocessingml.document
File TitleRIFC File Layout LTC Facility
SubjectNHSN, LTCF, COVID-19
File Modified0000-00-00
File Created2024-10-31

© 2024 OMB.report | Privacy Policy