Query TISS Errors TISS date out of admission: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 31: | Line 31: | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category:TISS28 Scanning Process]] | [[Category:TISS28 Scanning Process]] | ||
[[Category:Legacy TISS28 | [[Category:Legacy Registry check]] | ||
[[Category:Legacy TISS28 check]] |
Revision as of 11:30, 2021 September 8
Legacy Content
This page contains Legacy Content.- Explanation: Now entered in CCMDB.accdb directly, and a set of queries for CCI and TISS and LOS take care of it there.
- Successor: Query check CCI TISS NrDays GT LOS; Query check CCI TISS NrDays LT LOS, Query check TISS each day
Click Expand to show legacy content.
Data Integrity Checks | |
Summary: | TISS date is not during admission |
Related: | TISS28, Arrive DtTm field, Dispo DtTm field |
Firmness: | hard check |
Timing: | always |
App: | TISS28.accdb |
Coding: | query TISS_Errors_NrTISSDays_NE_LOS |
Uses L Problem table: | not relevant for this app |
Status: | retired |
Implementation Date: | 2016-07-11 |
Backlogged: | true |
Query check CCI Date will already take care of this in CCMDB.accdb
Causes and solutions
This one doesn't require checking with collectors.
- check the image of the TISS form to see if there is an accidental extra TISS day/item
- If the TISS item really is extra, delete records in L_TISS_Item table.
- follow Finding a patient in EPR and make sure the Arrive DtTm or Dispo DtTm are correct in CFE
- correct the dates in CFE if applicable
Log
2019-01-06 - added L_Problems link and changed the date range tested to be Dispo_DtTm within the last year.
Related articles
Related articles: |