Orphans in Centralized data.accdb: Difference between revisions

Line 6:

== Orphan definition ==

There should be no ''incomplete'' records in [[CCMDB.accdb]] on a laptop that are not included in the ''most recent send'' into centralized database on Regional server. 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.

There should be no ''incomplete'' or ''complete'' records in [[CCMDB.accdb]] on a laptop that are not included in the ''most recent send'' into centralized database on Regional server.

=== 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.

* [[RecordStatus field]] is incomplete

* the record doesn't have the same [[SentDtTm field]] as the newest SentDtTm for that location.

=== complete orphans ===

In the very rare circumstance that something goes wrong during the later stages of sending, a record may not get changed from [[RecordStatus]] "complete" to "sent" at the end of sending. Such a record would not show up as an orphan because it its sent date is the same as the max send date. Usually this record would just be sent again next time (since collectors would not delete an unsent record), and if that send goes through OK it will be set to "sent" then and all is good.

However, if (1) the collector changes or deletes the record between the two sends, or (2) we messed with [[Service/Location]] names between the sends, then the originally sent record would not be updated further in the next send. '''This record would show up as a "complete" orphan. '''

Fixing these would always need to be on a case-by-case basis.

== What to do with orphans ==

@@ Line 6: / Line 6: @@
 == Orphan definition ==
-There should be no ''incomplete'' records in [[CCMDB.accdb]] on a laptop that are not included in the ''most recent send'' into centralized database on Regional server.  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.
+There should be no ''incomplete'' or ''complete'' records in [[CCMDB.accdb]] on a laptop that are not included in the ''most recent send'' into centralized database on Regional server.
+=== 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.
 * [[RecordStatus field]] is incomplete
 * the record doesn't have the same [[SentDtTm field]] as the newest SentDtTm for that location.
+=== complete orphans ===
+In the very rare circumstance that something goes wrong during the later stages of sending, a record may not get changed from [[RecordStatus]] "complete" to "sent" at the end of sending. Such a record would not show up as an orphan because it its sent date is the same as the max send date. Usually this record would just be sent again next time (since collectors would not delete an unsent record), and if that send goes through OK it will be set to "sent" then and all is good.
+However, if (1) the collector changes or deletes the record between the two sends, or (2) we messed with [[Service/Location]] names between the sends, then the originally sent record would not be updated further in the next send. '''This record would show up as a "complete" orphan. '''
+Fixing these would always need to be on a case-by-case basis.
 == What to do with orphans ==