Reconnect check orphans query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 13: | Line 13: | ||
}} | }} | ||
See [[Orphans in Centralized data.mdb]] for more info and how to fix this problem. | See [[Orphans in Centralized data.mdb]] for more info and how to fix this problem. | ||
== Log == | |||
* 2023-08-15 - reformatted to remove * data and only show D_ID and send_dttm and filter fields to make this easier to read. This was as part of validating the query when it started to show false positives after [[Change to having each collector collect both programs on the same laptop]]. The query will need further review as we move this to other laptops - for now Pagasa can eyeball that the only ones on there are same-sentDtTm for H6 | |||
== Related articles == | == Related articles == |
Revision as of 10:52, 2023 August 15
Data Integrity Checks | |
Summary: | Record meets following conditions
|
Related: | RecordStatus field, SentDtTm field, Service/Location field |
Firmness: | hard check |
Timing: | always |
App: | Centralized data front end.accdb |
Coding: | Reconnect_check_orphans query |
Uses L Problem table: | no |
Status: | implemented |
Implementation Date: | not entered |
Backlogged: | No |
See Orphans in Centralized data.mdb for more info and how to fix this problem.
Log
- 2023-08-15 - reformatted to remove * data and only show D_ID and send_dttm and filter fields to make this easier to read. This was as part of validating the query when it started to show false positives after Change to having each collector collect both programs on the same laptop. The query will need further review as we move this to other laptops - for now Pagasa can eyeball that the only ones on there are same-sentDtTm for H6