Query TISS Errors missing days: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (This query will go away with old TISS sheets. If it's still relevant with the CCI version it will come up again there. Removed question)
mNo edit summary
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{LegacyContent
|explanation=no more TISS28.mdb
|successor=[[Query check_TISS_each_day]]
|content=
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=There are no TISS28 entries for a day that should have at least one based on [[Accept 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;Dispo DtTm
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_coding=query ''TISS_Errors_duplicate_Items''
|DIC_coding=query ''TISS_Errors_missing_days''
|DIC_status=retired
|DIC_status=retired
|DIC_app=TISS28.accdb
|DIC_app=TISS28.accdb
Line 18: Line 27:
=== If you do need to check these now... ===
=== If you do need to check these now... ===
If any records are listed:  
If any records are listed:  
# follow [[Finding a patient in EPR]] to check if [[Arrive DtTm]] and [[Dispo DtTm]] are different than in [[CFE]]  
# 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)
#* fix [[CFE]] if different from EPR (always trust EPR)
# if dates were same as EPR
# if dates were same as EPR
Line 25: Line 34:


== Log ==
== Log ==
* 2021-10-07 - deleted as part of [[Change to collect TISS data in CCI Picklist]]
* 2019-02-11 - changed to '''include''' vetted
* 2019-02-11 - changed to '''include''' vetted


Line 30: Line 40:
{{Related Articles}}
{{Related Articles}}


[[Category: TISS28 checks]]
 
[[Category: Data Processing]]
[[Category:Legacy TISS28 check]]
[[Category:TISS28 Scanning Process]]
[[Category:TISS28 Scanning Process]]
}}

Latest revision as of 15:47, 2022 April 19

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

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, Dispo DtTm
Firmness: hard check
Timing: always
App: TISS28.accdb
Coding: query TISS_Errors_missing_days
Uses L Problem table: not relevant for this app
Status: retired
Implementation Date: not entered
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

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
    • 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

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_TISS_Errors_missing_days&oldid=155571"