Query TISS Errors TISS date out of admission: Difference between revisions

Revision as of 10:50, 2021 September 2

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

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

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

@@ Line 1: / Line 1: @@
+{{LegacyContent
+|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]]
+|content=  }}
 {{Data Integrity Check
 |DIC_summary=[[TISS]] date is not during admission
@@ Line 26: / Line 31: @@
 {{Related Articles}}
-[[Category:TISS28 checks]]
-[[Category:TISS28 timing checks]]
+[[Category:Legacy Registry checks]]
-[[Category:Registry checks]]
-[[Category:Data Processing]]
-[[Category:Length of stay]]
 [[Category:TISS28 Scanning Process]]
+[[Category:Legacy TISS28 checks]]