Reconnect check orphans query: Difference between revisions
Ttenbergen (talk | contribs) m →Log |
Ttenbergen (talk | contribs) m Text replacement - "[[Orphans in Centralized_data.accdb]] " to "Orphans in Centralized_data.accdb" |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 8: | Line 8: | ||
|DIC_coding=''Reconnect_check_orphans'' query | |DIC_coding=''Reconnect_check_orphans'' query | ||
|DIC_status=implemented | |DIC_status=implemented | ||
|DIC_LProblem= | |DIC_LProblem=No | ||
|DIC_app=Centralized data front end.accdb | |DIC_app=Centralized data front end.accdb | ||
|DIC_backlogged=No | |DIC_backlogged=No | ||
}} | }} | ||
See [[Orphans in | See [[Orphans in Centralized_data.accdb]]for more info and how to fix this problem. | ||
== Instructions == | |||
The temporary solution is to still vet all patients, but not with the [["Vet all sent" button]]. If Pagasa gets the orphans error at this point that would be expected. Instead of clearing the records in the error the records would need to be reviewed. As long as all are from H6, and only one other send dttm is in there, they aren't really orphans, they are as expected with two sends from same laptop. If that is the case and no other errors are thrown by the [["Vet all sent" button]], then just run the query "vet_all_sent" directly and manually, and Julie would get the data she expects. | |||
{{Collapsable | always=background | full= | |||
[[Change to having each collector collect both programs on the same laptop]] will always put patients who meet the criteria of "orphans" for H6. So we stopped implementing it further, but H6 will continue to cause this problem. }} | |||
== Log == | == Log == | ||