Query TISS Errors TISS date out of admission
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, Dispo DtTm field |
| Firmness: | hard check |
| Timing: | always |
| App: | TISS28.accdb |
| Coding: | query TISS_Errors_TISS_date_out_of_admission |
| 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
- 2021-10-07 - deleted from CFE
- 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: |