Query TISS Errors TISS date out of admission

From CCMDB Wiki
Jump to navigationJump to search
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.accdb
Coding: query TISS_Errors_NrTISSDays_NE_LOS
Uses L Problem table: not relevant for this app
Status: retired
Implementation Date: 2016-07-11
Backlogged: true

  • Cargo

  • SMW

  • Categories: 

Query check CCI Date will already take care of this in CCMDB.accdb

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


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

Related articles

Related articles: