CCMDB Wiki

Query TISS Errors missing days: Difference between revisions

← Older edit
m old TISS will be retired shortly, so waste of time to work on this now, so taking out.
mNo edit summary
 
(8 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 [[Accept 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=retired
|DIC_status=retired
|DIC_app=TISS28.accdb
|DIC_app=TISS28.accdb
Line 14: 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 26: 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 31: 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"