Query TISS Errors missing days

Legacy Content

This page contains Legacy Content.

• Explanation: no more TISS28.mdb
• Successor: Query check_TISS_each_day

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

• 2021-10-07 - deleted as part of Change to collect TISS data in CCI Picklist
• 2019-02-11 - changed to include vetted

Related articles