Query check minimal data set incomplete: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
 
(12 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]].
{{Discuss |
* There was talk about adding [[Previous Location]] to this, but we now know that is not always available and leads people to enter bad data, so maybe we should not.
* There was talk about removing [[Arrive DtTm]] so pts can be entered even while still in ER and avoid erroneous entries.
}}


Trying to send or clicking the "Pre-send checker" button triggers data integrity checks for the minimal data set. If there are errors you get a message "You have patients with an incomplete or wrong minimal data set." Click OK and the query listing the actual errors will open. For any line in the query at least one column other than [[Patient_ID]] would have "Problem" and the current content of the column in it; that column is the one where you have an error. The heading of the columns should be self-explanatory.
Trying to send or clicking the "Pre-send checker" button triggers data integrity checks for the minimal data set. If there are errors you get a message "You have patients with an incomplete or wrong minimal data set." Click OK and the query listing the actual errors will open. For any line in the query at least one column other than [[Patient_ID]] would have "Problem" and the current content of the column in it; that column is the one where you have an error. The heading of the columns should be self-explanatory.


=== 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 36: Line 31:


== Log ==
== Log ==
* 2019-10-27 - will only check for recordstatus complete or incomplete now
* 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
* 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.



Latest revision as of 13:54, 2022 May 31

Data Integrity Checks
Summary: makes sure the Minimal Data Set is collected before records can be sent.
Related: Minimal Data Set, Serial number, Service/Location, First Name, Last Name, PHIN field, Chart number, Boarding Loc, Service tmp entry
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: query check_minimal_data_set_incomplete
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2009-08-18
Backlogged: No
  • Cargo


  • SMW


  • Categories: 
  • form:

The implementation date is approximate based on Minimal Data Set.

Trying to send or clicking the "Pre-send checker" button triggers data integrity checks for the minimal data set. If there are errors you get a message "You have patients with an incomplete or wrong minimal data set." Click OK and the query listing the actual errors will open. For any line in the query at least one column other than Patient_ID would have "Problem" and the current content of the column in it; that column is the one where you have an error. The heading of the columns should be self-explanatory.

some problems being checked

implementation

Check is done as part of module "tmp_checker" calling query "minimal_data_set_incomplete".

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

Related articles

Related articles: