Query TISS Errors missing days: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 10: | Line 10: | ||
If any records are listed: | If any records are listed: | ||
* compare the [[Arrive DtTm]] and [[Dispo DtTm]] to dates in [[L TISS Item table]]; | * compare the [[Arrive DtTm]] and [[Dispo DtTm]] to dates in [[L TISS Item table]]; | ||
** consider if the record is currently | ** consider if the record is currently urgent, if not, could ignore | ||
*** between reports, only do HSC ICUs because of CRRT | *** between reports, only do HSC ICUs because of CRRT | ||
{{Discuss | who = Pagasa | question = CRRT what? need link to the page on the wiki that explains }} | {{Discuss | who = Pagasa | question = CRRT what? need link to the page on the wiki that explains }} | ||
*** we may only be looking until e.g. end of last month | *** we may only be looking until e.g. end of last month | ||
** | ** follow [[Finding a patient in EPR]] to confirm [[Arrive DtTm]] and [[Dispo DtTm]], correct in [[CFE]] if different than EPR | ||
** otherwise, TISS is wrong (usually missing or extra day); usually it's the first or last day that is missing, sometimes one in middle | ** otherwise, TISS is wrong (usually missing or extra day); usually it's the first or last day that is missing, sometimes one in middle | ||
{{Discuss | who=Pagasa | question = | |||
* are the following still how we do this? }} | |||
*** get copy of info for pt from CFE | *** get copy of info for pt from CFE | ||
*** scan TISS form and blank out the addressograph | *** scan TISS form and blank out the addressograph | ||
Revision as of 12:50, 11 February 2019
| Data Integrity Checks | |
| Summary: | There are no TISS28 entries for a day that should have at least one based on Arrive DtTm and Dispo DtTm |
| Related: | TISS28, Arrive DtTm, Dispo DtTm |
| Firmness: | hard check |
| Timing: | always |
| App: | TISS28.mdb |
| Coding: | query TISS_Errors_duplicate_Items |
| Uses L Problem table: | not relevant for this app |
| Status: | implemented |
| Implementation Date: | not entered |
| Backlogged: | true |
Causes and solutions
If any records are listed:
- compare the Arrive DtTm and Dispo DtTm to dates in L TISS Item table;
- consider if the record is currently urgent, if not, could ignore
- between reports, only do HSC ICUs because of CRRT
- consider if the record is currently urgent, if not, could ignore
- we may only be looking until e.g. end of last month
- follow Finding a patient in EPR to confirm Arrive DtTm and Dispo DtTm, correct in CFE if different than EPR
- otherwise, TISS is wrong (usually missing or extra day); usually it's the first or last day that is missing, sometimes one in middle
- get copy of info for pt from CFE
- scan TISS form and blank out the addressograph
- email collector with the question
- no log of these questions is kept
- when collector provides info for missing day, add data in L_TISS_Item table
Log
Related articles
| Related articles: |