Facility - Importing COVID-19 and Respiratory Infections using a .csv file for Resident Impact and Facility Capacity (RIFC) summary data
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 Type | application/vnd.openxmlformats-officedocument.wordprocessingml.document |
File Title | RIFC File Layout LTC Facility |
Subject | NHSN, LTCF, COVID-19 |
File Modified | 0000-00-00 |
File Created | 2024-10-31 |