CCMDB Wiki

Query check minimal data set incomplete: Difference between revisions

← Older editNewer edit →
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=makes sure the [[Minimal Data Set]] is collected before records can be [[sending | sent]].
|DIC_summary=makes sure the [[Minimal Data Set]] is collected before records can be [[sending | sent]].
|DIC_related_concepts=Minimal Data Set; Serial number; Service/Location; First Name; Last Name; PHIN field; Chart number; Arrive DtTm; Boarding Loc; Service tmp entry
|DIC_related_concepts=Minimal Data Set; Serial number; Service/Location; First Name; Last Name; PHIN field; Chart number; Boarding Loc; Service tmp entry
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_coding=query ''check_minimal_data_set_incomplete''
|DIC_coding=query ''check_minimal_data_set_incomplete''
Line 19: Line 19:
* PHIN_bad - PHIN is present but not an acceptable PHIN
* PHIN_bad - PHIN is present but not an acceptable PHIN
* chart_bad - chart is blank or has spaces or other non-numerical things in it
* chart_bad - chart is blank or has spaces or other non-numerical things in it
* admdate_bad - [[Arrive DtTm]] missing or after today
* admdate_bad - first [[Boarding Loc]] missing or after today
* disdate_bad - if [[Dispo DtTm]] is present it can't be after today or before [[Arrive DtTm]]
* disdate_bad - if [[Dispo DtTm]] is present it can't be after today or before first [[Boarding Loc]]
* Transfer_before_adm - [[Transfer Ready DtTm]] is present and is before [[Arrive DtTm]]
* adm_after_disch - [[Dispo DtTm]] is present and first [[Boarding Loc]] is after [[Dispo DtTm]]
* Transfer_after_disch - [[Transfer Ready DtTm]] and [[Dispo DtTm]] are present, and [[Transfer Ready DtTm]] is after [[Dispo DtTm]]
* adm_after_disch - [[Dispo DtTm]] is present and [[Arrive DtTm]] is after [[Dispo DtTm]]
* [[Boarding Loc]] and [[Service tmp entry]] can't have a blank time  
* [[Boarding Loc]] and [[Service tmp entry]] can't have a blank time  


Line 32: Line 30:
* 2022-04-21 - removed any checks based on Accept and Arrived DtTm and old Transfer Ready DtTm field
* 2022-04-21 - removed any checks based on Accept and Arrived DtTm and old Transfer Ready DtTm field
* 2022-03-24 - updated to flag any blank times in [[Service tmp entry]] or [[Boarding Loc]]; if you have the entry there should be no reason to have the time blank - use what Cognos gives you and update it later if needed
* 2022-03-24 - updated to flag any blank times in [[Service tmp entry]] or [[Boarding Loc]]; if you have the entry there should be no reason to have the time blank - use what Cognos gives you and update it later if needed
* 2021-07-22 - added back and then removed again a cross check for [[Arrive DtTm]] - minimal can't check for this since pt might still be in ER and not have one; this should become resolved with [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]
* 2021-07-22 - added back and then removed again a cross check for ''Arrive DtTm'' - minimal can't check for this since pt might still be in ER and not have one; this should become resolved with [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]
* 2021-06-17 - updated to include check for first [[Boarding Loc]] and first [[Service tmp entry]]
* 2021-06-17 - updated to include check for first [[Boarding Loc]] and first [[Service tmp entry]]
* 2021-01-28 - wasn't checking for [[DOB]], fixed
* 2021-01-28 - wasn't checking for [[DOB]], fixed
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_minimal_data_set_incomplete"