Check Duplicate Task Entries: Difference between revisions
Ttenbergen (talk | contribs) Created page with "{{Cleaner.mdb Data Integrity Checks}}: Make sure there is only one entry in Tasks.mdb for each ward stay. (As per the contents of "discussion".) ==== Discussion ==== If all p..." |
Ttenbergen (talk | contribs) m Text replacement - "CCMDB.mdb" to "CCMDB.accdb" |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{ | {{LegacyContent | ||
|explanation=Collection of [[Tasks Elements]] was discontinued as part of move to [[ICD10]]/[[CCI]]. | |||
|content= | |||
This used to be done in cleaner. Is it still an issue? If so we should move it to [[Centralized data front end.accdb]]. Ttenbergen 10:49, 2015 June 25 (CDT) | |||
Make sure there is only one entry in Tasks.mdb for each ward stay. (As per the contents of "discussion".) | |||
==== Discussion ==== | ==== Discussion ==== | ||
If all parties agree that the following either boils down to the above or just does not make sense, it can be deleted. | If all parties agree that the following either boils down to the above or just does not make sense, it can be deleted. | ||
| Line 8: | Line 17: | ||
i.e. same serial/location w/diff study#? Yes this happened before but Ed’s program is now catching it bec we brought this up to him . You mean Ed’s program now stores the Tasks? Another case we found is the same patient entered twice with different serial no, same loc and consequently diff study no. (happens when another DC covers for another during vacation or maybe when the DC is really tired). So that is not really Task specific then? | i.e. same serial/location w/diff study#? Yes this happened before but Ed’s program is now catching it bec we brought this up to him . You mean Ed’s program now stores the Tasks? Another case we found is the same patient entered twice with different serial no, same loc and consequently diff study no. (happens when another DC covers for another during vacation or maybe when the DC is really tired). So that is not really Task specific then? | ||
I was tempted to say: | I was tempted to say: | ||
“The data is sent straight from the DCs CCMDB. | “The data is sent straight from the DCs CCMDB.accdb to the tasks.mdb that is its repository. There is no .csv stage. The data processors check it in that access db. Am I misinterpreting your check request, or does that information address the issue?“” | ||
But now I think you are talking about checking tasks for medicine, not the tasks we are collecting in Medicine. | But now I think you are talking about checking tasks for medicine, not the tasks we are collecting in Medicine. | ||
In that case, I actually think some of the previous questions really apply to both as well, e.g. the post-op stuff. Does it not? '' | In that case, I actually think some of the previous questions really apply to both as well, e.g. the post-op stuff. Does it not? '' | ||
| Line 14: | Line 23: | ||
I made the following: find counts>1 of (PHIN and admitdate and location) | I made the following: find counts>1 of (PHIN and admitdate and location) | ||
Query Generated and posted | Query Generated and posted | ||
[[Category:Task Elements]] | |||
[[Category:Legacy Data Processing]] | |||
}} | |||