Query check minimal data set incomplete

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, Chart number, Arrive DtTm, Overstay Project]]
Firmness:	hard check
Timing:	always
App:	CCMDB.mdb
Coding:	query check minimal data set incomplete
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2009-08-18
Backlogged:	true

• Cargo

• SMW

"CCMDB.mdb" is not in the list (CCMDB.accdb, Centralized data front end.accdb, TISS28.accdb, SAP, DSM Labs Consistency check.accdb, not entered) of allowed values for the "DICApp" property. Property "DICRelatedConcepts" (as page type) with input value "Minimal Data Set]], Serial number, Service/Location, First Name, Last Name, PHIN, Chart number, Arrive DtTm, [[Overstay_Predictor_Project_Collection_Instructions#In addition to Minimal Data Set | Overstay Project" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• 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

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