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 HSC ICUs because of CRRT

CRRT what? need link to the page on the wiki that explains

• 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

are the following still how we do this?

• SMW

• Cargo

• Categories

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