|
|
| Line 38: |
Line 38: |
|
| |
|
| == {{CCMDB Data Integrity Checks|implemented}} == | | == {{CCMDB Data Integrity Checks|implemented}} == |
| query ''minimal_data_set_incomplete''
| | [[Query check minimal data set incomplete]] |
|
| |
|
| 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".
| |
|
| |
|
|
| |
|