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

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
PTorres (talk | contribs)
CCMDB_legit, approved
1,617 edits
m Text replacement - "|DIC_LProblem=no" to "|DIC_LProblem=No"
 
(9 intermediate revisions by the same user not shown)
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
{{Data Integrity Check
|DIC_summary=[[TISS]] date is not during admission
|DIC_summary=[[TISS]] date is not during admission
|DIC_related_concepts=TISS28; Arrive DtTm field; Dispo DtTm field
|DIC_related_concepts=TISS28; Dispo DtTm field
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_coding=query ''TISS_Errors_NrTISSDays_NE_LOS''
|DIC_coding=query ''TISS_Errors_TISS_date_out_of_admission''
|DIC_implementation_date=2016-07-11
|DIC_implementation_date=2016-07-11
|DIC_status=implemented
|DIC_status=retired
|DIC_LProblem=Yes
|DIC_LProblem=No
|DIC_app=TISS28.mdb
|DIC_app=TISS28.accdb
}}
}}
[[Query check CCI Date]] will already take care of this in CCMDB.accdb


== Causes and solutions ==
== Causes and solutions ==
Line 15: Line 22:
# check the image of the TISS form to see if there is an accidental extra TISS day/item  
# 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]].
#* 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]]
#* correct the dates in CFE if applicable
#* correct the dates in CFE if applicable
{{DT | pull into standard troubleshooting page: if there is an extra TISS day that is identical to previous, just delete it, if the "offending" TISS day is different from surrounding, then confirm with collector }}


== Log ==
== Log ==
2019-01-06 - added L_Problems link and changed the date range tested to be [[Dispo_DtTm]] within the last year.
* 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.


== Related articles ==
== Related articles ==
{{Related Articles}}
{{Related Articles}}


[[Category: TISS28 checks]]
[[Category: Registry checks]]
[[Category: Data Processing]]
[[Category: Length of stay]]
[[Category:TISS28 Scanning Process]]
[[Category:TISS28 Scanning Process]]
[[Category:Legacy Registry check]]
[[Category:Legacy TISS28 check]]

Latest revision as of 22:13, 22 July 2025

Legacy Content

This page contains Legacy Content.

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
  • Cargo


  • SMW


  • Categories:  
  • form:

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

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

  • 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.

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_TISS_Errors_TISS_date_out_of_admission&oldid=165129"