Orphans in Centralized data.mdb: Difference between revisions
Ttenbergen (talk | contribs) (Created page with "An orphan in Centralized_data.mdb is a record where * RecordStatus is incomplete * the record doesn't have the same SentDtTm as the newest SentDtTm for that location. O...") |
TOstryzniuk (talk | contribs) mNo 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 | ||
* [[RecordStatus]] is incomplete | * [[RecordStatus field]] is incomplete | ||
* the record doesn't have the same SentDtTm as the newest SentDtTm for that location. | * the record doesn't have the same SentDtTm as the newest SentDtTm for that location. | ||
Orphans can be found by query "NDC_orphans" in [[ | 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). | ||
Revision as of 18:12, 2014 May 2
An orphan in Centralized_data.mdb is a record where
- RecordStatus field is incomplete
- the record doesn't have the same SentDtTm as the newest SentDtTm for that location.
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).
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.