Query TISS Errors TISS date out of admission

Legacy Content

This page contains Legacy Content.

Explanation: Now entered in CCMDB.accdb directly, and a set of queries for CCI and TISS and LOS take care of it there.
Successor: Query check CCI TISS NrDays GT LOS; Query check CCI TISS NrDays LT LOS, Query check TISS each day

Click Expand to show legacy content.

Data Integrity Checks
Summary:	TISS date is not during admission
Related:	TISS28, Dispo DtTm field
Firmness:	hard check
Timing:	always
App:	TISS28.accdb
Coding:	query TISS_Errors_TISS_date_out_of_admission
Uses L Problem table:	not relevant for this app
Status:	retired
Implementation Date:	2016-07-11
Backlogged:	true

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

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

2021-10-07 - deleted from CFE
2019-01-06 - added L_Problems link and changed the date range tested to be Dispo_DtTm within the last year.