Releases

A running description of all bug fixes and improvements to the Archive.

Pending
Not yet released
 * Category (e.g., PCR, Antigen) column added to CovidTests dataset. See wiki page for this dataset for details.
 * Missing custody and nursing records for certain days in StaffWork replaced (bug #115704).
 * Gaps in Covidtransmission filled (bug #116290)
 * Incorrect CovidInfection test dates due to data entry error (bug [http://tfsweb02:8080/tfs/CCHCS/QM/_workitems/edit/116593 116593)
 * Birthyear added to StaffRoster.

Release 1.42
Released May 3, 2021
 * CovidInfection.CovidLOC column values simplified to "Quarantine", "Isolation", and "Died". Other values were no longer reliable. In cases where one of these three remaining values does not apply to the resident, the column is now NULL. See wiki page for this dataset for details.

Release 1.41
Released April 26, 2021
 * Brand added to StaffCovidVaccination dataset. See wiki page for this dataset for details.
 * In cases where a given staff in StaffRoster had multiple BoundedBirthDecades due to data entry error, the modal birth decade is now used.
 * Gaps filled in daily records fro some residents in CovidTransmission dataset.

Release 1.4
Released April 19, 2021
 * New StaffRoster dataset added which lists all active staff each month. See wiki page on this dataset for details.
 * RoomCapacity and BunkCapacity in CovidTransmission show NULL when this value is not available. Previously, these columns showed 0 when the value was unknown.

Release 1.3
Released April 12, 2021
 * New CovidTests dataset added which provides results of all completed Covid-related tests on residents, when data are available. See wiki page on this dataset for details.
 * FloorNumber and BedLevel added to CovidTransmission dataset. See wiki page for this dataset for details.
 * Some duplicate appointments removed from Activity and durations of activities with a recorded duration over 720 minutes set to NULL as they are likely data entry errors.
 * CovidInfection.Sequence column set to NULL as it was problematic. This column will be removed in a future release. To get all values for any given test, joining on ResidentId + Day is sufficient.  See wiki page for this dataset for further details.
 * Set Activity.PersonContacts and Activity.PersonContactMinutes to 0 for all educational activities on or after April 8, 2021 because all such activities have been conducted in-residence from that point to the present.

Release 1.23
Released April 5, 2021
 * StaffCovidInfection.Gender now shows NULL if not "Male" or "Female".
 * Removed records in StaffWork where there were multiple records per staff per day per shift. StaffWork now contains only one record maximum per staff per day per shift.
 * ILI removed from Comorbidity dataset as it is already included in CovidInfection dataset.
 * Removed errant semicolon from CovidInfection dataset
 * StaffWork.Institution and StaffCovidVaccination columns now show "Other" if work/vaccination location is not a prison.

Release 1.22
Released March 29, 2021
 * Starting and Ending columns in Demographics, Comorbidity, and Disability updated such that each record spans the period [Starting, Ending), with the Ending date of one record equal to the Starting date of the next for the same patient and date element.

Release 1.21
Released March 22, 2021


 * Bug fix wherein Sequence value for CovidInfection records where element="TestResultDate" was incorrect. Corrected by setting Day value of these records to equal the collection date of the test.  Value column of these records still shows the date the test result was received, which may be the same as the collection date or may be a later date.


 * Bug fix wherein demographic values were missing from the demographics dataset. Corrected by setting the minimum startdate of all demographic values to January 1, 2016.


 * Warning added to description of CovidInfection.SxOnset stating that since the Covid-19 surge starting in December, 2020, SxOnset data are not be complete.

Release 1.2
Released on March 15, 2021
 * Full and incremental files for each of the following datasets were restored to the SFTP site:
 * 1) StaffWork
 * 2) StaffCovidVaccination
 * 3) StaffCovidInfection


 * "Hospitalized" removed as a value from Comorbidity dataset as this information is already and more appropriately provided via the LocationStarus and OutToMedical columns of the CovidTransmission dataset.

Release 1.1
Released on March 1, 2021

Note: All staff datasets (StaffWork, StaffCovidInfection, StaffCovidVaccination) remain offline and will be restored in a future release once all privacy safeguards have been implemented.


 * CovidInfection dataset normalized to reduce file size. No longer one record per resident per day.  See ResidentData/CovidInfection for details.
 * Addition of Hospitalization element in CovidInfection dataset.
 * Additional values included in CovidLOC element in CovidInfection dataset.
 * Treatment dataset containing Tamiflu and Bamlanivimab data added.
 * Dates for historical comorbidities in Comorbidity dataset now start at beginning of month instead of end of month.
 * Replaced truncated ethnicity values in Demographics dataset with full values
 * Fixed bug in CovidInfection wherein Ili dates were not correct.
 * Fixed bug in Activity wherein there was a semicolon in some job descriptions

Release 1.01
Released February 17, 2021


 * Split each dataset into full and incremental files.

Release 1.0
Released on February 8, 2021

The is the initial deployment of the research datamart SFTP files

The following zipped files were deployed to the SFTP site. Each zipped file contains a semicolon separated file of relevant data from January 1, 2016 through February 8, 2021. Filenames follow the convention of foldername+"_"+MMDDYYYY. Example: "Demographics_02082021". The suffix date represents the date the data were last compiled.


 * Activity\Activity.zip
 * Comorbidity\Comorbidity.zip
 * CovidInfection\CovidInfection.zip
 * CovidTransmission\CovidTransmission.zip
 * Demographics\Demographics.zip
 * Disability\Disability.zip
 * Immunization\Immunization.zip
 * StaffCovidInfection\StaffCovidInfection.zip
 * StaffCovidVaccination\StaffCovidVaccination.zip
 * StaffWork\StaffWork.zip