Orphans in Centralized data.accdb: Difference between revisions
Ttenbergen (talk | contribs) |
|||
| Line 6: | Line 6: | ||
== Orphan definition == | == Orphan definition == | ||
There should be no ''incomplete'' records in [[CCMDB.mdb]] on a laptop that are not | There should be no ''incomplete'' records in [[CCMDB.mdb]] 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. | ||
* [[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. | ||
== What to do with orphans == | == What to do with orphans == | ||