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

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.