Query check minimal data set incomplete: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) No edit summary |
||
(13 intermediate revisions by 2 users 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; Arrive DtTm; Boarding Loc; Service tmp entry | ||
| DIC_firmness = hard check | |DIC_firmness=hard check | ||
|DIC_coding=query ''check_minimal_data_set_incomplete'' | |||
|DIC_implementation_date=2009-08-18 | |||
| DIC_coding = query '' | |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]]. | ||
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. | ||
Line 29: | Line 27: | ||
==== implementation ==== | ==== implementation ==== | ||
Check is done as part of module "tmp_checker" calling query "minimal_data_set_incomplete". | Check is done as part of module "tmp_checker" calling query "minimal_data_set_incomplete". | ||
== Log == | |||
* 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 == |
Revision as of 16:18, 2021 July 29
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, Arrive DtTm, 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 |
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
- Locn_bad - missing location
- FirstName_bad - missing first name
- LastName_bad - missing last name
- 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
- admdate_bad - Arrive DtTm missing or after today
- disdate_bad - if Dispo DtTm is present it can't be after today or before Arrive DtTm
- Transfer_before_adm - Transfer Ready DtTm is present and is before Arrive 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
implementation
Check is done as part of module "tmp_checker" calling query "minimal_data_set_incomplete".
Log
- 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: |
|