CCMDB Wiki

Query TISS Errors missing days: Difference between revisions

← Older edit
m Text replacement - "{{DT" to "{{TT"
mNo edit summary
 
(10 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{LegacyContent
|explanation=no more TISS28.mdb
|successor=[[Query check_TISS_each_day]]
|content=
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=There are no TISS28 entries for a day that should have at least one based on [[Arrive DtTm]] and [[Dispo DtTm]]
|DIC_summary=There are no TISS28 entries for a day that should have at least one based on Accept DtTm and [[Dispo DtTm]]
|DIC_related_concepts=TISS28;Arrive DtTm;Dispo DtTm
|DIC_related_concepts=TISS28;Dispo DtTm
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_coding=query ''TISS_Errors_duplicate_Items''
|DIC_coding=query ''TISS_Errors_missing_days''
|DIC_status=needs review
|DIC_status=retired
|DIC_app=TISS28.accdb
|DIC_app=TISS28.accdb
}}
}}
{{TT | _Dev_TISS28
change to wait till complete }}


== Causes and solutions ==
== Causes and solutions ==
Line 17: Line 23:
* consider if the record is currently urgent, if not, could ignore
* consider if the record is currently urgent, if not, could ignore
** between reports, only do STB and HSC ICUs because CRRT is included in Monthly reports  
** between reports, only do STB and HSC ICUs because CRRT is included in Monthly reports  
{{Discuss | who=Julie | question = which report/s are these actually included in? }}
** we may only be looking until e.g. end of last month
** we may only be looking until e.g. end of last month


=== If you do need to check these now... ===
=== If you do need to check these now... ===
If any records are listed:  
If any records are listed:  
# follow [[Finding a patient in EPR]] to check if [[Arrive DtTm]] and [[Dispo DtTm]] are different than in [[CFE]]  
# follow [[Finding a patient in EPR]] to check if Arrive DtTm and [[Dispo DtTm]] are different than in [[CFE]]  
#* fix [[CFE]] if different from EPR (always trust EPR)
#* fix [[CFE]] if different from EPR (always trust EPR)
# if dates were same as EPR
# if dates were same as EPR
Line 29: Line 34:


== Log ==
== Log ==
* 2021-10-07 - deleted as part of [[Change to collect TISS data in CCI Picklist]]
* 2019-02-11 - changed to '''include''' vetted
* 2019-02-11 - changed to '''include''' vetted


Line 34: Line 40:
{{Related Articles}}
{{Related Articles}}


[[Category: TISS28 checks]]
 
[[Category: Data Processing]]
[[Category:Legacy TISS28 check]]
[[Category:TISS28 Scanning Process]]
[[Category:TISS28 Scanning Process]]
}}
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_TISS_Errors_missing_days"