Orphans in Centralized data.accdb: Difference between revisions
TOstryzniuk (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
An orphan in Centralized_data.mdb is a record where | An orphan in Centralized_data.mdb is a record where | ||
Orphans can be found by query "NDC_orphans" in [[Centralized_data_front_end.mdb]]. | Orphans can be found by query "NDC_orphans" in [[Centralized_data_front_end.mdb]]. | ||
Orphans can happen if a collector enters a patient, sends once while the patient is incomplete, and then deletes the patient or assigns a new location (since that is used to generate D_ID). | Orphans can happen if a collector enters a patient, sends once while the patient is incomplete, and then deletes the patient or assigns a new location (since that is used to generate D_ID). | ||
== Orphan definition == | |||
* [[RecordStatus field]] is incomplete | |||
For wards/units with only one collector: | |||
* the record doesn't have the same SentDtTm as the newest SentDtTm for that location. | |||
For wards/units with more than one collector: | |||
* SentDtTm is older than 10 days | |||
== What to do with orphans == | == What to do with orphans == | ||
Revision as of 13:46, 26 May 2014
An orphan in Centralized_data.mdb is a record where
Orphans can be found by query "NDC_orphans" in Centralized_data_front_end.mdb.
Orphans can happen if a collector enters a patient, sends once while the patient is incomplete, and then deletes the patient or assigns a new location (since that is used to generate D_ID).
Orphan definition
- RecordStatus field is incomplete
For wards/units with only one collector:
- the record doesn't have the same SentDtTm as the newest SentDtTm for that location.
For wards/units with more than one collector:
- SentDtTm is older than 10 days
What to do with orphans
If there is a second record for the same patient (see eg names) with the same Pat_ID and different location, then the location was likely changed. Orphan can be deleted since the new record will take its place.
If there is not a second record for the same patient the patient was likely deleted. This might be correct and intended, or accidental. The data processor should follow up with the data collector to find out what happened. If the record was correctly deleted, delete the orphan. If the record should not have been deleted the processor could send the info in the record to the collector to facilitate re-entry on the laptop.