Orphans in Centralized data.accdb

From CCMDB Wiki
Revision as of 19:25, 1 May 2014 by 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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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.

Orphans can be found by query "NDC_orphans" in Centralized_date_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.

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