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 8: | Line 8: | ||
|DIC_related_concepts=TISS28; Arrive DtTm field; Dispo DtTm field | |DIC_related_concepts=TISS28; Arrive DtTm field; Dispo DtTm field | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_coding=query '' | |DIC_coding=query ''TISS_Errors_TISS_date_out_of_admission'' | ||
|DIC_implementation_date=2016-07-11 | |DIC_implementation_date=2016-07-11 | ||
|DIC_status=retired | |DIC_status=retired | ||
Line 26: | Line 26: | ||
== Log == | == Log == | ||
2019-01-06 - added L_Problems link and changed the date range tested to be [[Dispo_DtTm]] within the last year. | * 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 == |
Revision as of 15:22, 2021 October 7
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_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: |