Reconnect check orphans query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_summary=Record meets following conditions | |DIC_summary=Record meets following conditions* [[RecordStatus field]] is incomplete* the record doesn't have the same [[SentDtTm field]] as the newest SentDtTm for that location. | ||
* [[RecordStatus field]] is incomplete | |||
* the record doesn't have the same [[SentDtTm field]] as the newest SentDtTm for that location. | |||
|DIC_related_concepts=RecordStatus field; SentDtTm field; Service/Location field | |DIC_related_concepts=RecordStatus field; SentDtTm field; Service/Location field | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
| Line 8: | Line 6: | ||
|DIC_coding=query ''PL_1orphans'' | |DIC_coding=query ''PL_1orphans'' | ||
|DIC_status=implemented | |DIC_status=implemented | ||
|DIC_LProblem=no | |||
|DIC_app=Centralized data front end.accdb | |DIC_app=Centralized data front end.accdb | ||
|DIC_backlogged=No | |||
}} | }} | ||
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. | ||
Revision as of 15:25, 18 March 2022
| Data Integrity Checks | |
| Summary: | Record meets following conditions* RecordStatus field is incomplete* the record doesn't have the same SentDtTm field as the newest SentDtTm for that location. |
| Related: | RecordStatus field, SentDtTm field, Service/Location field |
| Firmness: | hard check |
| Timing: | always |
| App: | Centralized data front end.accdb |
| Coding: | query PL_1orphans |
| 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.