Query TISS Errors missing days: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
PTorres (talk | contribs)
CCMDB_legit, approved
1,608 edits
PTorres (talk | contribs)
CCMDB_legit, approved
1,608 edits
Line 8: Line 8:
}}
}}
== Causes and solutions ==
== Causes and solutions ==
If any records are listed:
The physical TISS forms might simply not have arrived at office yet.
* compare the [[Arrive DtTm]] and [[Dispo DtTm]] to dates in [[L TISS Item table]];
 
** consider if the record is currently urgent, if not, could ignore
=== Do you need to check these '''now'''? ===
*** between reports, only do STB and HSC ICUs because CRRT is included in Monthly reports  
* 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  
{{Discuss | who=Julie | question = which report/s are these actually included in? }}
{{Discuss | who=Julie | question = which report/s are these actually included in? }}
** we may only be looking until e.g. end of last month


*** we may only be looking until e.g. end of last month
=== If you do need to check these now... ===
** follow [[Finding a patient in EPR]] to confirm [[Arrive DtTm]] and [[Dispo DtTm]], correct in [[CFE]] if different than EPR
If any records are listed:
** otherwise, TISS is wrong (usually missing or extra day); usually it's the first or last day that is missing, sometimes one in middle, send it to data collector to review
# follow [[Finding a patient in EPR]] to check if [[Arrive DtTm]] and [[Dispo DtTm]] are different than in [[CFE]]
*** copy the .pdf from the [[TISS28 form images]] directory to the regional server
#* fix [[CFE]] if different from EPR (always trust EPR)
*** email the collector the link to the .pdf
# 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 ==
== Log ==

Revision as of 17:14, 11 February 2019

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


  • SMW
"TISS28.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property.
  • 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

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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_TISS_Errors_missing_days&oldid=135180"