Query TISS Errors TISS date out of admission

Data Integrity Checks
Summary:	TISS date is not during admission
Related:	TISS28, Arrive DtTm field, Dispo DtTm field
Firmness:	hard check
Timing:	always
App:	TISS28.mdb
Coding:	query TISS_Errors_NrTISSDays_NE_LOS
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2016-07-11
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

This one doesn't require checking with collectors.

1. check the image of the TISS form to see if there is an accidental extra TISS day/item
   • If the TISS item really is extra, delete records in L_TISS_Item table.
2. follow Finding a patient in EPR and make sure the Arrive DtTm or Dispo DtTm are correct in CFE
   • correct the dates in CFE if applicable

Log

2019-01-06 - added L_Problems link and changed the date range tested to be Dispo_DtTm within the last year.