Query TISS Errors TISS date out of admission
From CCMDB WikiJump to navigationJump to search
|Data Integrity Checks|
|Summary:||TISS date is not during admission|
|Related:||TISS28, Arrive DtTm field, Dispo DtTm field|
|Uses L Problem table:||not relevant for this app|
Query check CCI Date will already take care of this in CCMDB.accdb
Causes and solutions
This one doesn't require checking with collectors.
- 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.
- 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.