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

From CCMDB Wiki
Jump to navigation Jump to search
PTorres (talk | contribs)
PTorres (talk | contribs)
Line 13: Line 13:
This one doesn't require checking with collectors.  
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]]
# follow [[Finding a patient in EPR]] and make sure the [[Arrive DtTm]] or [[Dispo DtTm]] are correct in [[CFE]]
# check the image of the TISS form to see if there is an accidental extra TISS day/item
#* correct the dates in CFE if applicable
# If the TISS item '''''really''''' is extra, delete records in [[L_TISS_Item table]].


== Log ==
== Log ==

Revision as of 15:41, 11 February 2019

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

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

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: