Orphans in Centralized data.accdb

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 laptop per:

• the record doesn't have the same SentDtTm as the newest SentDtTm for that location.

For wards/units with more than one laptop per:

• SentDtTm is older than 10 days

ward/units with more than one collector

• see Serial number for most up to date information on shared collection
• as of creation of check there were
  • HSC_H4H and STB_5B and?

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.