Query check minimal data set incomplete: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "{{DT" to "{{TT")
mNo edit summary
Line 9: Line 9:
| DIC_implementation_date = 2009-08-18
| DIC_implementation_date = 2009-08-18
}}
}}
The implementation ''date'' is approximate based on [[Minimal Data Set]].


{{TT | _dev_CCMDB
{{Discuss |  
need to add previous location, and confirm all others in [[Minimal Data Set]] are checked. }}
* 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.  


The implementation ''date'' is approximate based on [[Minimal Data Set]].
* There was talk about removing [[Arrive DtTm]] so pts can be entered even while still in ER.
 
}}


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.

Revision as of 15:00, 2020 November 26

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
Firmness: hard check
Timing:
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: true
  • Cargo


  • SMW


  • Categories: 
  • form:

The implementation date is approximate based on Minimal Data Set.

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


  • SMW


  • Cargo


  • Categories

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

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