Orphans in Centralized data.accdb - Revision history

Ttenbergen: /* location used accidentally by another laptop */

2026-01-07T16:12:00Z

location used accidentally by another laptop

← Older revision		Revision as of 11:12, 7 January 2026
Line 22:		Line 22:
	== What to do with orphans ==		== What to do with orphans ==
	=== location used accidentally by another laptop ===		=== location used accidentally by another laptop ===
	If another laptop (eg hsc a4) accidentally sends a patient with a different location (eg hsc h4) then the latest sentDtTm ~~fir~~ hsc h4 becomes that of hsc a4. If a4 sent after h4, then all of h4's most recently sent incomplete records will appear as orphans, because a later sentDtTm than theirs is found.		If another laptop (eg hsc a4) accidentally sends a patient with a different location (eg hsc h4) then the latest sentDtTm for hsc h4 becomes that of hsc a4. If a4 sent after h4, then all of h4's most recently sent incomplete records will appear as orphans, because a later sentDtTm than theirs is found.
			{{Discuss \| Pagasa, that would be "[[Laptop identifier]] instead of "location" now, right? [[User:Ttenbergen\|Ttenbergen]] 10:12, 7 January 2026 (CST)}}

	So: if you find a lot of orphans for a site (eg >10, maybe fewer on low volume unit) then likely nothing is wrong with the orphans, but something is wrong with a different record. Fix:		So: if you find a lot of orphans for a site (eg >10, maybe fewer on low volume unit) then likely nothing is wrong with the orphans, but something is wrong with a different record. Fix:
	# check the max_sentdttm listed for the group of false-positive orphans		# check the max_sentdttm listed for the group of false-positive orphans

Ttenbergen: Ttenbergen moved page Orphans in Centralized data.mdb to Orphans in Centralized data.accdb without leaving a redirect: Text replacement - "Orphans in Centralized data.mdb" to "Orphans in Centralized data.accdb"

2025-09-29T04:25:10Z

Ttenbergen moved page Orphans in Centralized data.mdb to Orphans in Centralized data.accdb without leaving a redirect: Text replacement - "Orphans in Centralized data.mdb" to "Orphans in Centralized data.accdb"

← Older revision	Revision as of 23:25, 28 September 2025
(No difference)

Ttenbergen: Text replacement - "[[Category: " to "[[Category:"

2025-07-30T16:56:41Z

Text replacement - "[[Category: " to "[[Category:"

← Older revision		Revision as of 11:56, 30 July 2025
Line 57:		Line 57:
	{{Related Articles}}		{{Related Articles}}

	[[Category: Data Processing]]		[[Category:Data Processing]]
	[[Category: PL queries]]		[[Category:PL queries]]

Ttenbergen: Text replacement - "[[Centralized_data.accdb]]" to "Centralized_data.accdb"

2025-07-23T19:54:29Z

Text replacement - "[[Centralized_data.accdb]]" to "Centralized_data.accdb"

← Older revision		Revision as of 14:54, 23 July 2025
Line 1:		Line 1:
	An orphan in [[[[Centralized_data.accdb]]]] is a record with [[RecordStatus field]] = incomplete that was not sent with the latest batch from its location.		An orphan in [[Centralized_data.accdb]] is a record with [[RecordStatus field]] = incomplete that was not sent with the latest batch from its location.

	Orphans can be found by [[Reconnect_check_orphans query]] in [[Centralized_data_front_end.accdb]].		Orphans can be found by [[Reconnect_check_orphans query]] in [[Centralized_data_front_end.accdb]].

Ttenbergen: Text replacement - "Centralized data.accdb" to "Centralized_data.accdb"

2025-07-23T19:52:52Z

Text replacement - "Centralized data.accdb" to "Centralized_data.accdb"

← Older revision		Revision as of 14:52, 23 July 2025
Line 1:		Line 1:
	An orphan in [[[[~~Centralized data~~.accdb]]]] is a record with [[RecordStatus field]] = incomplete that was not sent with the latest batch from its location.		An orphan in [[[[Centralized_data.accdb]]]] is a record with [[RecordStatus field]] = incomplete that was not sent with the latest batch from its location.

	Orphans can be found by [[Reconnect_check_orphans query]] in [[Centralized_data_front_end.accdb]].		Orphans can be found by [[Reconnect_check_orphans query]] in [[Centralized_data_front_end.accdb]].
Line 9:		Line 9:

	=== imcomplete orphans ===		=== imcomplete orphans ===
	All incomplete records for a given location, the sent date/time should be the same, and it should be the latest date/time sent to the [[~~Centralized data~~.accdb]] for that location.		All incomplete records for a given location, the sent date/time should be the same, and it should be the latest date/time sent to the [[Centralized_data.accdb]] for that location.
	* [[RecordStatus field]] is incomplete		* [[RecordStatus field]] is incomplete
	* the record doesn't have the same [[SentDtTm field]] as the newest SentDtTm for that location.		* the record doesn't have the same [[SentDtTm field]] as the newest SentDtTm for that location.

Ttenbergen: Text replacement - "Centralized_data.mdb" to "Centralized data.accdb"

2025-07-23T19:45:14Z

Text replacement - "Centralized_data.mdb" to "Centralized data.accdb"

← Older revision		Revision as of 14:45, 23 July 2025
Line 1:		Line 1:
	An orphan in [[~~Centralized_data~~.~~mdb~~]] is a record with [[RecordStatus field]] = incomplete that was not sent with the latest batch from its location.		An orphan in [[[[Centralized data.accdb]]]] is a record with [[RecordStatus field]] = incomplete that was not sent with the latest batch from its location.

	Orphans can be found by [[Reconnect_check_orphans query]] in [[Centralized_data_front_end.accdb]].		Orphans can be found by [[Reconnect_check_orphans query]] in [[Centralized_data_front_end.accdb]].

Ttenbergen: Text replacement - "Centralized data.mdb" to "Centralized data.accdb"

2025-07-23T19:41:20Z

Text replacement - "Centralized data.mdb" to "Centralized data.accdb"

← Older revision		Revision as of 14:41, 23 July 2025
Line 9:		Line 9:

	=== imcomplete orphans ===		=== imcomplete orphans ===
	All incomplete records for a given location, the sent date/time should be the same, and it should be the latest date/time sent to the [[Centralized data.~~mdb~~]] for that location.		All incomplete records for a given location, the sent date/time should be the same, and it should be the latest date/time sent to the [[Centralized data.accdb]] for that location.
	* [[RecordStatus field]] is incomplete		* [[RecordStatus field]] is incomplete
	* the record doesn't have the same [[SentDtTm field]] as the newest SentDtTm for that location.		* the record doesn't have the same [[SentDtTm field]] as the newest SentDtTm for that location.

Ttenbergen at 19:28, 19 April 2022

2022-04-19T19:28:54Z

← Older revision		Revision as of 14:28, 19 April 2022
Line 31:		Line 31:

	=== changed location ===		=== changed location ===
	If there is a second record for the same patient (see eg names, [[~~Arrive DtTm~~]]) with the same Pat_ID and different [[Service/Location]], then the location was likely changed.		If there is a second record for the same patient (see eg names, first [[Service tmp entry]] ) with the same [[Pat_ID]] and different [[Service/Location]], then the location was likely changed.
	Orphan can be deleted since the new record will take its place.		Orphan can be deleted since the new record will take its place.

	=== change Pat_ID ===		=== change Pat_ID ===
	If there is a second record for the same patient (see eg names, [[~~Arrive DtTm~~]]) with the same [[Service/Location]] and different Pat_ID, then the Pat_ID was likely changed.		If there is a second record for the same patient (see eg names, first [[Service tmp entry]]) with the same [[Service/Location]] and different [[Pat_ID]], then the Pat_ID was likely changed.
	Orphan can be deleted since the new record will take its place.		Orphan can be deleted since the new record will take its place.

Ttenbergen at 01:47, 25 March 2022

2022-03-25T01:47:40Z

← Older revision		Revision as of 20:47, 24 March 2022
Line 1:		Line 1:
	An orphan in [[Centralized_data.mdb]] is a record with [[RecordStatus field]] = incomplete that was not sent with the latest batch from its location.		An orphan in [[Centralized_data.mdb]] is a record with [[RecordStatus field]] = incomplete that was not sent with the latest batch from its location.

	Orphans can be found by ~~query~~ [[~~PL_1orphans~~]] in [[Centralized_data_front_end.accdb]].		Orphans can be found by [[Reconnect_check_orphans query]] in [[Centralized_data_front_end.accdb]].

	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]]). Assigning a new location used to be very common, but no longer is after [[PatientFollow Project]].		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]]). Assigning a new location used to be very common, but no longer is after [[PatientFollow Project]].

Ttenbergen at 19:11, 18 March 2021

2021-03-18T19:11:03Z

← Older revision		Revision as of 14:11, 18 March 2021
Line 3:		Line 3:
	Orphans can be found by query [[PL_1orphans]] in [[Centralized_data_front_end.accdb]].		Orphans can be found by query [[PL_1orphans]] in [[Centralized_data_front_end.accdb]].

	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]]). Assigning a new location used to be very common, but no longer is after [[PatientFollow Project]].

	== Orphan definition ==		== Orphan definition ==