This RUBIN-2_readme20240104.txt file was generated on 20240104 by Kaylee Alexander ------------------- GENERAL INFORMATION ------------------- 1. Title of Dataset Admission Discharge Transfer (ADT) Room Occupancy Data from the University of Utah and Veterans Affairs from the CDC-funded Granular Modeling Project 2. Author Information Principal Investigator Contact Information Name: Michael Rubin, MD, PhD Institution: University of Utah/Salt Lake City Veterans Affairs Address: Division of Epidemiology, 295 Wakara Way, Salt Lake City, UT 81408 Email: michael.rubin@hsc.utah.edu ORCID: 0000-0002-2900-5548 Associate or Co-investigator Contact Information Name: Molly Leecaster, PhD Institution: University of Utah/Salt Lake City Veterans Affairs Address: Division of Epidemiology, 295 Wakara Way, Salt Lake City, UT 81408 Email: molly.leecaster@utah.edu Associate or Co-investigator Contact Information Name: Candace Haroldsen, MSPH Institution: University of Utah/Salt Lake City Veterans Affairs Address: Division of Epidemiology, 295 Wakara Way, Salt Lake City, UT 81408 Email: candace.haroldsen@hsc.utah.edu 3. Date of data collection (single date, range, approximate date) 2018 (specific dates removed for data privacy) 4. Geographic location of data collection (where was data collected?): University of Utah Hospital Acute Care Ward, Salt Lake City, Utah, USA 5. Information about funding sources that supported the collection of the data: Centers for Disease Control and Prevention (CDC) RFTOP #2015-006, "Granular Modeling–Simulating the Transmission of Healthcare Associated Infections in Hospitals" -------------------------- SHARING/ACCESS INFORMATION -------------------------- 1. Licenses/restrictions placed on the data: CC BY NC - Allows others to use and share your data non-commercially and with attribution. 2. Links to publications that cite or use the data: NA 3. Links to other publicly accessible locations of the data: NA 4. Links/relationships to ancillary data sets: NA 5. Was data derived from another source? No 6. Recommended citation for the data: Rubin, Michael, Molly Leecaster, and Candace Haroldsen. 2024. "Cleaned Event-level Wireless Sensor Data from the University of Utah from the CDC-funded Granular Modeling Project." The Hive: University of Utah Research Data Repository. www.doi.org/10.7278/S50d-6wz0-jk8j. --------------------- DATA & FILE OVERVIEW --------------------- 1. File List A. Filename: Final_ADT_redacted.csv Short description: This dataset contains room occupancy during the study period at University of Utah hospital. 2. Relationship between files: NA 3. Additional related data collected that was not included in the current data package: NA 4. Are there multiple versions of the dataset? No -------------------------- METHODOLOGICAL INFORMATION -------------------------- 1. Description of methods used for collection/generation of data: Admission, Discharge, and Transfer (ADT) data is captured in both participating hospitals to characterize room occupancy and non-occupancy in wards. 2. Methods for processing the data: These data are pulled from multiple sources collected during the study by study staff as well as harvested EHR data. Data were adjudicated and compiled into one comprehensive file. Data manipulation included redaction of dates, replaced with study days 1-n, as well as transformation from long format to wide for ease of use. 3. Instrument- or software-specific information needed to interpret the data: SAS 9.4 and MS SQL SSMS v18.8 were used for importing and processing data. No special software is required for use of current dataset (csv format). 4. Standards and calibration information, if appropriate: NA 5. Environmental/experimental conditions: This study was performed in vivo in acute care hospitals 6. Describe any quality-assurance procedures performed on the data: Quality assurance was performed manually as many of the data sources were originally collected on paper and were therefore not conducive to programatic processing. 7. People involved with sample collection, processing, analysis and/or submission: Candace Haroldsen, MSPH (Data Manager); Kristina Stratford (Study Coordinator), Tavis Huber (Study Coordinator) ----------------------------------------- DATA-SPECIFIC INFORMATION FOR: SensorData_Phase2.csv ----------------------------------------- 1. Number of variables: 11 2. Number of cases/rows: 360 3. Variable List A. Name: RoomAlias Description: redacted/aliased room number B. Name: StudyDay Description: nteger 1-n; replaces date C. Name: start_dt_1 Description: time of admission to room on study day D. Name: end_dt_1 Description: time of discharge or transfer out of room on study day E. Name: PatID_1 Description: redacted/aliased patient identifier VALUES: Format is PAT-xxxUU; if 3 digit number begins with a 9 it indicates an empty room (non-occupancy) F. Name: start_dt_2 Description: time of second admission to room on study day G. Name: end_dt_2 Description: time of second discharge or transfer out of room on study day H. Name: PatID_2 Description: redacted/aliased patient identifier VALUES: Format is PAT-xxxUU; if 3 digit number begins with a 9 it indicates an empty room (non-occupancy) I. Name: start_dt_3 Description: time of third admission to room on study day J. Name: end_dt_3 Description: time of third discharge or transfer out of room on study day K. Name: PatID_3 Description: redacted/aliased patient identifier VALUES: Format is PAT-xxxUU; if 3 digit number begins with a 9 it indicates an empty room (non-occupancy) 4. Missing data codes: NA 5. Specialized formats of other abbreviations used: Patient IDs are formatted as indicated above. UU indicates hospital 1. VA indicates hospital 2. Times are in 24 hour format (military).