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

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 11: Line 11:


== Causes and solutions ==
== Causes and solutions ==
This one doesn't require checking with collectors.
If there is an extra day, review image, check EPR to make sure CFE is right.
If the TISS day '''''really''''' is extra, delete records in L_TISS_Item.


== Log ==
== Log ==

Revision as of 12:57, 2019 February 11

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 (CCMDB.accdb, Centralized data front end.accdb, TISS28.accdb, SAP, DSM Labs Consistency check.accdb, not entered) of allowed values for the "DICApp" property. 
  • Categories: 
  • form:

Causes and solutions

This one doesn't require checking with collectors.

If there is an extra day, review image, check EPR to make sure CFE is right.

If the TISS day really is extra, delete records in L_TISS_Item.

Log

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: