Query check dx primary not exactly one: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary =  
|DIC_summary=There has to be exactly one dx per patient with [[Dx Primary]] checked, and it has to be an [[Admit Diagnosis]]
* there has to be exactly one dx per patient with [[Dx Primary]] checked
|DIC_related_concepts=Dx Primary; Admit Diagnosis; Primary Admit Diagnosis
| DIC_related_concepts = [[Dx Primary]]
|DIC_firmness=hard check
| DIC_firmness = hard check
|DIC_coding=query ''check_dx_primary_not_exactly_one''
| DIC_timing =
|DIC_implementation_date=2018-10-01
| DIC_app = CCMDB.mdb
|DIC_status=implemented
| DIC_coding = query ''check dx primary not exactly one''
|DIC_LProblem=No
| DIC_status = implemented
|DIC_app=CCMDB.mdb
| DIC_implementation_date = 2018-10-01
}}
}}
Incidentally, this check also makes sure that at least one Admit Diagnosis must be present, so this doesn't need to be checked separately.
Incidentally, this check also makes sure that at least one Admit Diagnosis must be present, so this doesn't need to be checked separately.



Revision as of 10:48, 12 November 2018

Data Integrity Checks
Summary: There has to be exactly one dx per patient with Dx Primary checked, and it has to be an Admit Diagnosis
Related: Dx Primary, Admit Diagnosis, Primary Admit Diagnosis
Firmness: hard check
Timing: always
App: CCMDB.mdb
Coding: query check_dx_primary_not_exactly_one
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2018-10-01
Backlogged: true
  • Cargo


  • SMW
"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. 
  • Categories:  
  • form:

Incidentally, this check also makes sure that at least one Admit Diagnosis must be present, so this doesn't need to be checked separately.

Related articles

Related articles: