Query TISS Errors TISS date out of admission: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (Text replacement - "TISS28.mdb" to "TISS28.accdb") |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 5: | Line 5: | ||
|DIC_coding=query ''TISS_Errors_NrTISSDays_NE_LOS'' | |DIC_coding=query ''TISS_Errors_NrTISSDays_NE_LOS'' | ||
|DIC_implementation_date=2016-07-11 | |DIC_implementation_date=2016-07-11 | ||
|DIC_status= | |DIC_status=retired | ||
|DIC_LProblem=Yes | |DIC_LProblem=Yes | ||
|DIC_app=TISS28.accdb | |DIC_app=TISS28.accdb | ||
}} | }} | ||
[[Query check CCI Date]] will already take care of this in CCMDB.accdb | |||
== Causes and solutions == | == Causes and solutions == |
Revision as of 22:19, 2020 December 2
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: |