Query check ICD10 mechanism vs trauma

Data Integrity Checks
Summary:	Mechanism of injury needs to be co-coded with certain other codes, and should always have a combined code that expresses the injury itself.
Related:	Observation after accident/injury, Mechanism of injury: animal rider or occupant of animal-drawn vehicle, Mechanism of injury: assault with bodily force, Mechanism of injury: bus occupant, Mechanism of injury: crushed or jammed or pinched in or between objects, Mechanism of injury: driver or occupant of ATV or off-road vehicle or snowmobile, Mechanism of injury: driver or occupant of watercraft, Mechanism of injury: explosion, Mechanism of injury: fall or jump (not necessarily from a height), Mechanism of injury: firearm (GSW), Mechanism of injury: hanging or strangulation (accidental or intentional), Mechanism of injury: hypodermic needle, Mechanism of injury: knife or other sharp object, stabbing, Mechanism of injury: machinery, Mechanism of injury: motorcyclist, Mechanism of injury: occupant or driver of car or truck, Mechanism of injury: other NOS, Mechanism of injury: pedal cyclist vs powered vehicle, Mechanism of injury: pedal cyclist, not with powered vehicle, Mechanism of injury: pedestrian vs powered vehicle, Mechanism of injury: pilot or occupant of aircraft, Mechanism of injury: struck by an inanimate moving object/blunt trauma, Mechanism of injury: train occupant, Mechanism of injury: transport or vehicle accident NOS
Firmness:	hard check (not allowed) or soft check (allowed, but give error; in CFE this means it has to go into the ... table, and cross checks have to consider that table)
Timing:
App:	CCMDB.mdb
Coding:	query check_ICD10_mechanism_vs_trauma
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2019-01-22
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: