Query TISS Errors missing days: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "{{DT" to "{{TT")
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=There are no TISS28 entries for a day that should have at least one based on [[Arrive DtTm]] and [[Dispo DtTm]]
|DIC_summary=There are no TISS28 entries for a day that should have at least one based on [[Accept DtTm]] and [[Dispo DtTm]]
|DIC_related_concepts=TISS28;Arrive DtTm;Dispo DtTm
|DIC_related_concepts=TISS28;Arrive DtTm;Dispo DtTm
|DIC_firmness=hard check
|DIC_firmness=hard check
Line 8: Line 8:
}}
}}


{{TT | _Dev_TISS28
{{Discuss | This seems to imply [[Query TISS Errors NrTISSDays NE LOS]], so is that other query actually necessary still? }}
change to wait till complete }}


== Causes and solutions ==
== Causes and solutions ==

Revision as of 22:30, 2020 December 2

Data Integrity Checks
Summary: There are no TISS28 entries for a day that should have at least one based on Accept DtTm and Dispo DtTm
Related: TISS28, Arrive DtTm, Dispo DtTm
Firmness: hard check
Timing: always
App: TISS28.accdb
Coding: query TISS_Errors_duplicate_Items
Uses L Problem table: not relevant for this app
Status: needs review
Implementation Date: not entered
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:
This seems to imply Query TISS Errors NrTISSDays NE LOS, so is that other query actually necessary still? 
  • SMW


  • Cargo


  • Categories

Causes and solutions

The physical TISS forms might simply not have arrived at office yet.

Do you need to check these now?

  • consider if the record is currently urgent, if not, could ignore
    • between reports, only do STB and HSC ICUs because CRRT is included in Monthly reports

which report/s are these actually included in?

  • SMW


  • Cargo


  • Categories
    • we may only be looking until e.g. end of last month

If you do need to check these now...

If any records are listed:

  1. follow Finding a patient in EPR to check if Arrive DtTm and Dispo DtTm are different than in CFE
    • fix CFE if different from EPR (always trust EPR)
  2. if dates were same as EPR
    • put the .pdf of the form on the regional server and email the collector the link; remember to delete the form once you have your answer
    • tell collector which day(s) you need them to check

Log

  • 2019-02-11 - changed to include vetted

Related articles

Related articles: