Query TISS Errors missing days: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(18 intermediate revisions by 2 users 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 [[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;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=implemented
|DIC_status=retired
|DIC_app=TISS28.mdb
|DIC_app=TISS28.accdb
}}
}}
== Causes and solutions ==
== 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:  
If any records are listed:  
* compare the [[Arrive DtTm]] and [[Dispo DtTm]] to dates in [[L TISS Item table]];
# follow [[Finding a patient in EPR]] to check if Arrive DtTm and [[Dispo DtTm]] are different than in [[CFE]]
** consider if the record is currently urgent, if not, could ignore
#* fix [[CFE]] if different from EPR (always trust EPR)
*** between reports, only do HSC ICUs because of CRRT
# if dates were same as EPR
{{Discuss | who = Pagasa | question = CRRT what? need link to the page on the wiki that explains }}
#* 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
*** we may only be looking until e.g. end of last month
#* tell collector which day(s) you need them to check
** follow [[Finding a patient in EPR]] to confirm [[Arrive DtTm]] and [[Dispo DtTm]], correct in [[CFE]] if different than EPR
** otherwise, TISS is wrong (usually missing or extra day); usually it's the first or last day that is missing, sometimes one in middle
{{Discuss | who=Pagasa | question = 
* are the following still how we do this? }}
*** get copy of info for pt from CFE
*** scan TISS form and blank out the addressograph
*** email collector with the question
*** no log of these questions is kept
* when collector provides info for missing day, add data in L_TISS_Item table


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


== Related articles ==
== Related articles ==
{{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"