Orphans in Centralized data.accdb

From CCMDB Wiki
Revision as of 13:46, 26 May 2014 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search

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

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.

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Orphans_in_Centralized_data.accdb&oldid=38790"