CCMDB Wiki

Query check minimal data set incomplete: Difference between revisions

← Older edit
m Text replacement - "cross check " to "cross check "
 
(10 intermediate revisions by the same user not shown)
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
|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_timing =
|DIC_coding=query ''check_minimal_data_set_incomplete''
| DIC_app = CCMDB.accdb
|DIC_implementation_date=2009-08-18
| DIC_coding = query ''check_minimal_data_set_incomplete''
|DIC_status=implemented
| DIC_status = implemented
|DIC_app=CCMDB.accdb
| DIC_implementation_date = 2009-08-18
|DIC_backlogged=No
}}
}}
The implementation ''date'' is approximate based on [[Minimal Data Set]].
The implementation ''date'' is approximate based on [[Minimal Data Set]].
Line 14: Line 14:


=== some problems being checked ===
=== some problems being checked ===
* Locn_bad - missing location
* FirstName_bad - missing [[First Name]]
* FirstName_bad - missing first name
* LastName_bad - missing [[Last Name]]
* LastName_bad - missing last name
* 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
* ServiceLocn_bad - [[Service/Location]] not filled
* admdate_bad - [[Arrive DtTm]] missing or after today
* dispoDtTm_bad - [[Dispo DtTm]] GT today
* disdate_bad - if [[Dispo DtTm]] is present it can't be after today or before [[Arrive DtTm]]
* admDtTm_after_dispoDtTm - first [[Boarding Loc]] missing or after [[Dispo_DtTm]]
* Transfer_before_adm - [[Transfer Ready DtTm]] is present and is before [[Arrive DtTm]]
* DOB_bad - [[DOB]] is blank (other validation is done later)
* Transfer_after_disch - [[Transfer Ready DtTm]] and [[Dispo DtTm]] are present, and [[Transfer Ready DtTm]] is after [[Dispo DtTm]]
* disdate_bad - if [[Dispo DtTm]] is present it can't be after today or before first [[Boarding Loc]]
* adm_after_disch - [[Dispo DtTm]] is present and [[Arrive DtTm]] is after [[Dispo DtTm]]
* missing_first_boarding_loc: - no [[Boarding Loc]] entered
* missing_first_service - no [[Service tmp entry]] entered
* Board_Serv_time_blank - a [[Boarding Loc]] or [[Service tmp entry]] has a blank time


==== implementation ====
==== implementation ====
Line 29: Line 31:


== Log ==
== Log ==
* 2022-05-31 - update to catch an empty [[Service/Location]] scenario not previously accounted for, ie the blank entry from s_dispo 
* 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
* 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-01-28 - wasn't checking for [[DOB]], fixed
* 2021-01-28 - wasn't checking for [[DOB]], fixed
* 2019-10-27 - will only check for recordstatus complete or incomplete now
* 2019-10-27 - will only check for [[RecordStatus]] complete or incomplete now
* 2019-04-28 - tweaked check for [[Chart]] to not give overflow error for very long chart numbers.
* 2019-04-28 - tweaked check for [[Chart]] to not give overflow error for very long chart numbers.


Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_minimal_data_set_incomplete"