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 |
||
| (One intermediate revision by the same user not shown) | |||
| Line 6: | Line 6: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_summary=[[TISS]] date is not during admission | |DIC_summary=[[TISS]] date is not during admission | ||
|DIC_related_concepts=TISS28 | |DIC_related_concepts=TISS28; 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 22: | Line 22: | ||
# check the image of the TISS form to see if there is an accidental extra TISS day/item | # 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]]. | #* If the TISS item really is extra, delete records in [[L_TISS_Item table]]. | ||
# follow [[Finding a patient in EPR]] and make sure the | # 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 | #* correct the dates in CFE if applicable | ||
== 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 == | ||
Latest revision as of 15:28, 2022 April 19
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: |