Query TISS Errors missing days

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

If any records are listed:

• 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
    • 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
  • 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, send it to data collector to review
    • copy the .pdf from the TISS28 form images directory to the regional server
    • email the collector the link to the .pdf

Log

• 2019-02-11 - changed to include vetted