Survive / Expired: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "Category: 1Main table" to "")
m (Text replacement - "CCMDB.mdb" to "CCMDB.accdb")
Line 5: Line 5:


===Data encoding===
===Data encoding===
The field name in [[Centralized_data.mdb]] and [[CCMDB.mdb]] is [[R_SurviveExpire]].
The field name in [[Centralized_data.mdb]] and [[CCMDB.accdb]] is [[R_SurviveExpire]].


== Legacy Data ==
== Legacy Data ==
This field used to also encode whether a deceased patient had had an [[Autopsy]]. These were rolled into the "expire" option. This is one field in [[CCMDB.mdb]]. It is two fields (survive/expire) and (autopsy) in Ed's database. It was implemented as a single field to prevent the combination survive/autopsy.[[Category: Legacy Data]]
This field used to also encode whether a deceased patient had had an [[Autopsy]]. These were rolled into the "expire" option. This is one field in [[CCMDB.accdb]]. It is two fields (survive/expire) and (autopsy) in Ed's database. It was implemented as a single field to prevent the combination survive/autopsy.[[Category: Legacy Data]]


[[Category:L Log table Legacy]]
[[Category:L Log table Legacy]]


[[Category: 2016 Time and Place changes]]
[[Category: 2016 Time and Place changes]]

Revision as of 12:01, 2019 September 22

The Survive / Expired field tracks if a patient survived to be discharged. Options are Survive, Expire.

2016 Time and Place changes

The data in this field will be collected in the Dispo field after the Category: 2016 Time and Place changes. It will have several "died - ..." options.

Data encoding

The field name in Centralized_data.mdb and CCMDB.accdb is R_SurviveExpire.

Legacy Data

This field used to also encode whether a deceased patient had had an Autopsy. These were rolled into the "expire" option. This is one field in CCMDB.accdb. It is two fields (survive/expire) and (autopsy) in Ed's database. It was implemented as a single field to prevent the combination survive/autopsy.