Query TISS Errors missing days: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 10: Line 10:
If any records are listed:  
If any records are listed:  
* compare the [[Arrive DtTm]] and [[Dispo DtTm]] to dates in [[L TISS Item table]];  
* compare the [[Arrive DtTm]] and [[Dispo DtTm]] to dates in [[L TISS Item table]];  
** consider if the record is currently relevant, if not, could ignore
** consider if the record is currently urgent, if not, could ignore
*** between reports, only do HSC ICUs because of CRRT  
*** between reports, only do HSC ICUs because of CRRT  
{{Discuss | who = Pagasa | question = CRRT what? need link to the page on the wiki that explains }}
{{Discuss | who = Pagasa | question = CRRT what? need link to the page on the wiki that explains }}
*** we may only be looking until e.g. end of last month
*** we may only be looking until e.g. end of last month
** look up the patient in EPR to confirm adm and dis date, correct in [[CFE]] if different than EPR
** follow [[Finding a patient in EPR]] to confirm [[Arrive DtTm]] and [[Dispo DtTm]], correct in [[CFE]] if different than EPR
** otherwise, TISS is wrong (usually missing or extra day); usually it's the first or last day that is missing, sometimes one in middle
** otherwise, TISS is wrong (usually missing or extra day); usually it's the first or last day that is missing, sometimes one in middle
{{Discuss | who=Pagasa | question = 
* are the following still how we do this? }}
*** get copy of info for pt from CFE
*** get copy of info for pt from CFE
*** scan TISS form and blank out the addressograph
*** scan TISS form and blank out the addressograph

Revision as of 12:50, 11 February 2019

Data Integrity Checks
Summary: There are no TISS28 entries for a day that should have at least one based on Arrive DtTm and Dispo DtTm
Related: TISS28, Arrive DtTm, Dispo DtTm
Firmness: hard check
Timing: always
App: TISS28.mdb
Coding: query TISS_Errors_duplicate_Items
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: not entered
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

If any records are listed:

CRRT what? need link to the page on the wiki that explains

  • SMW


  • Cargo


  • Categories
      • we may only be looking until e.g. end of last month
    • follow Finding a patient in EPR to confirm Arrive DtTm and Dispo DtTm, correct in CFE if different than EPR
    • otherwise, TISS is wrong (usually missing or extra day); usually it's the first or last day that is missing, sometimes one in middle
  • are the following still how we do this?
  • SMW


  • Cargo


  • Categories
      • get copy of info for pt from CFE
      • scan TISS form and blank out the addressograph
      • email collector with the question
      • no log of these questions is kept
  • when collector provides info for missing day, add data in L_TISS_Item table

Log

Related articles

Related articles: