Query check ICD10 mechanism vs trauma

Data Integrity Checks
Summary:	Traumas need mechanisms, and mechanisms need traumas (see also Template:ICD10 Guideline Trauma w mechanism).
Related:	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, Abdomen or lower back or pelvis NOS, wound/injury/trauma, Abdomen or lower back or pelvis, nerves NOS, injury/trauma, Abdomen or lower back or pelvis, soft tissues, open wound, injury/trauma, Abdomen or lower back or pelvis, superficial injury/trauma (minor, contusion), Abdomen or pelvic, blood vessels NOS, injury/trauma, Air embolism, traumatic, Ankle or foot or toes, amputation, injury/trauma, Ankle or foot or toes, blood vessels, wound/injury/trauma, Ankle or foot or toes, fracture, injury/trauma, Ankle or foot or toes, joints or ligaments, dislocation/sprain/strain, injury/trauma, Ankle or foot or toes, muscles/tendons, wound/injury/trauma, Ankle or foot or toes, nerves, wound/injury/trauma, Ankle or foot or toes, open wound, injury/trauma, Ankle or foot or toes, superficial injury/trauma (minor, contusion), Ankle or foot or toes, wound/injury/trauma, NOS, Aorta, abdominal, injury/trauma, Aorta, thoracic, injury/trauma, Bladder, traumatic laceration/rupture, Bladder, wound/injury/trauma, Bone NOS, nontraumatic fracture NOS, Bone NOS, osteoporosis with new pathologic fracture, Bone NOS, pathologic fracture due to neoplastic disease, Bone, disorder of bone continuity NOS, Bone, pathologic fracture NOS, Bone, stress fracture, Brain injury, diffuse (TBI), injury/trauma, Brain injury, focal (TBI), injury/trauma, Brain, cerebral edema, injury/trauma, Brain, concussion, injury/trauma, Brain/intracranial injury NOS, injury/trauma, Burns, 10-19% body surface area involved, Burns, 20-29% body surface area involved, Burns, 30-39% body surface area involved, Burns, 40-49% body surface area involved, Burns, 50-59% body surface area involved, Burns, 60-69% body surface area involved, Burns, 70-79% body surface area involved, Burns, 80-89% body surface area involved, Burns, 90% or more body surface area involved, Burns, up to 9% or unspecified body surface area involved, Carotid artery, injury/trauma, Clavicle or scapula or humerus, fracture, injury/trauma, Coding fractures in ICD10, Colon (large intestine), traumatic laceration/rupture, Colon (large intestine), wound/injury trauma, Cranial nerve, wound/injury/trauma, Ear, foreign body in, Eardrum (tympanic membrane), rupture, injury/trauma, Elbow or forearm, superficial injury/trauma (minor, contusion), Elbow or forearm, wound/injury/trauma, NOS, Elbow, joints or ligaments, dislocation/sprain/strain, injury/trauma, Elbow, open wound, injury/trauma, Electrical injury, Epidural hemorrhage, injury/trauma, Esophagus, burn, Esophagus, chemical burn, Esophagus, wound/injury/trauma, Eye (globe), wound/injury/trauma, Eye, burn or chemical burn, Eye, foreign body in, Fat embolism, traumatic, Femur or pelvis, nontraumatic fracture NOS, Femur or pelvis, osteoporosis with new pathologic fracture, Femur or pelvis, pathologic fracture due to neoplastic disease, Femur, fracture, injury/trauma, Flail chest, injury/trauma, Forearm, amputation, injury/trauma, Forearm, blood vessels, wound/injury/trauma, Forearm, muscles/tendons, wound/injury/trauma, Forearm, nerves, wound/injury/trauma, Forearm, open wound, injury/trauma, Gallbladder or bile ducts, traumatic laceration/rupture, Gallbladder or bile ducts, wound/injury/trauma, Gastrointestinal (GI) tract, burn, Gastrointestinal (GI) tract, chemical burn, Gastrointestinal (GI) tract, foreign body in, Genitorurinary tract, foreign body in, Head NOS, wound/injury/trauma, Head bones NOS, fracture, injury/trauma, Head, joints or ligaments, dislocation/sprain/strain, injury/trauma, Head, open wound, injury/trauma, Head, superficial injury/trauma (minor, contusion), Heart, wound/injury/trauma, Hemothorax, traumatic, Hip or thigh, amputation, injury/trauma, Hip or thigh, blood vessels, wound/injury/trauma, Hip or thigh, muscles/tendons, wound/injury/trauma, Hip or thigh, nerves, wound/injury/trauma, Hip or thigh, open wound, injury/trauma, Hip or thigh, superficial injury/trauma (minor, contusion), Hip or thigh, wound/injury/trauma, NOS, Hip, joints or ligaments, dislocation/sprain/strain, injury/trauma, ICU Interfacility Transfer, Inferior vena cava (IVC), injury/trauma, Internal organ NOS, burn, Internal organ NOS, chemical burn, Intra-abdominal organ NOS, traumatic laceration/rupture, Intra-abdominal organ NOS, wound/injury/trauma NOS, Intracranial hemorrhage, injury/trauma, Intrathoracic organ/structure NOS, wound/injury/laceration, Kidney, wound/injury/trauma, Knee or lower leg, blood vessels, wound/injury/trauma, Knee or lower leg, muscles/tendons, wound/injury/trauma, Knee or lower leg, open wound, injury/trauma, Knee or lower leg, superficial injury/trauma (minor, contusion), Knee or lower leg, wound/injury/trauma, NOS, Knee, joint or ligaments or cartilage, dislocation/sprain/strain/tear, injury/trauma, Knee, nerves, wound/injury/trauma, Lightning injury, Liver, wound/injury/trauma, Lower leg, amputation, injury/trauma, Lower leg, fracture, injury/trauma, Lower limb (leg) bones, level not specified/NOS, fracture, injury/trauma, Lower limb (leg), level not specified/NOS, amputation, injury/trauma, Lower limb (leg), level not specified/NOS, blood vessels, wound/injury/trauma, Lower limb (leg), level not specified/NOS, joints or ligaments, dislocation/sprain/strain, injury/trauma, Lower limb (leg), level not specified/NOS, muscles/tendons, wound/injury/trauma, Lower limb (leg), level not specified/NOS, nerves, wound/injury/trauma, Lower limb (leg), level not specified/NOS, open wound, injury trauma, Lower limb (leg), level not specified/NOS, superficial injury/trauma (minor, contusion), Lower limb (leg), level not specified/NOS, wound/injury/trauma, NOS, Lumbar spine or pelvis, joints or ligaments, dislocation/sprain/strain, injury/trauma, Lung NOS, wound/injury/trauma, Mouth or pharynx, burn, Mouth or pharynx, chemical burn, Multiple trauma, Muscle, disorder NOS, Muscle, strain, Neck structures NOS, wound/injury/trauma, Neck, blood vessels NOS, injury/trauma, Neck, joints or ligaments, dislocation/sprain/strain, injury/trauma, Neck, nerves NOS, injury/trauma, Neck, open wound, injury/trauma, Neck, superficial injury/trauma (minor, contusion), Nerve root, cervical spinal cord, injury/trauma, Nerve root, lumbar spinal cord, injury/trauma, Nerve root, thoracic spinal cord, injury/trauma, Observation after accident/injury, Osteoporosis without new pathologic fracture, Ovary or fallopian tube, wound/injury/trauma, Pancreas, wound/injury/trauma, Pelvis, fracture, injury/trauma, Pneumothorax, traumatic, Post-concussion syndrome, Rectum, traumatic laceration/rupture, Rectum, wound/injury/trauma NOS, Respiratory tract, burn, Respiratory tract, chemical burn, Respiratory tract, foreign body in, Rib, fracture, injury/trauma, Rotator cuff, tear or rupture, Rupture/laceration of artery, NOS, Shoulder or upper arm, amputation, injury/trauma, Shoulder or upper arm, muscles/tendons, wound/injury/trauma, Shoulder or upper arm, nerves, wound/injury/trauma, Shoulder or upper arm, open wound, injury/trauma, Shoulder or upper arm, superficial injury/trauma (minor, contusion), Shoulder or upper arm, wound/injury/trauma, NOS, Shoulder or upper, arm blood vessels, wound/injury/trauma, Shoulder, joints or ligaments, dislocation/sprain/strain, injury/trauma, Skin, burn, 1st degree, Skin, burn, 2nd degree, Skin, burn, 3rd degree, Skin, burn, degree unspecified, Skin, chemical burn, 1st degree, Skin, chemical burn, 2nd degree, Skin, chemical burn, 3rd degree, Skin, chemical burn, degree unspecified, Skull, fracture, injury/trauma, Small intestine, traumatic laceration/rupture, Small intestine, wound/injury/trauma, Spinal cord, cervical (C-spine), injury/trauma, Spinal cord, lumbar (L-spine), injury/trauma, Spinal cord, thoracic (T-spine), injury/trauma, Spleen, wound/injury/trauma, Sternum, fracture, injury/trauma, Stomach, traumatic laceration/rupture, Stomach, wound/injury/trauma, Subarachnoid hemorrhage, injury/trauma, Subdural hemorrhage/hematoma, injury/trauma, Superior vena cava (SVC), injury/trauma, Thorax NOS, wound/injury/trauma, Thorax, blood vessels NOS, injury/trauma, Thorax, bones NOS, fracture, injury/trauma, Thorax, joints or ligaments, dislocation/sprain/strain, injury/trauma, Thorax, nerves NOS, injury/trauma, Thorax, open wound, injury/trauma, Thorax, superficial injury/trauma (minor, contusion), Tooth, fracture (broken tooth), injury/trauma, Trachea or bronchus (airways) NOS, wound/injury/trauma, Trench foot (immersion foot), Ulna or radius (forearm), fracture, injury/trauma, Upper limb (arm) bones, level not specified/NOS, fracture, injury/trauma, Upper limb (arm), level not specified/NOS, amputation, injury/trauma, Upper limb (arm), level not specified/NOS, blood vessels, wound/injury/trauma, Upper limb (arm), level not specified/NOS, joints or ligaments, dislocation/sprain/strain, injury/trauma, Upper limb (arm), level not specified/NOS, muscles/tendons, wound/injury/trauma, Upper limb (arm), level not specified/NOS, nerves, wound/injury/trauma, Upper limb (arm), level not specified/NOS, open wound, injury trauma, Upper limb (arm), level not specified/NOS, superficial injury/trauma (minor, contusion), Upper limb (arm), level not specified/NOS, wound/injury/trauma, NOS, Ureter, wound/injury/trauma, Urethra, wound/injury/trauma, Urinary, pelvic or genitourinary organs NOS, wound/injury/trauma, Uterus, wound/injury/trauma, Vertebra or spinal cord, level not specified/NOS, fracture, injury/trauma, Vertebra, cervical (C-spine), fracture, injury/trauma, Vertebra, lumbar (L-spine), fracture, injury/trauma, Vertebra, nontraumatic fracture NOS, Vertebra, osteoporosis with new pathologic fracture, Vertebra, pathologic fracture due to neoplastic disease, Vertebra, thoracic (T-spine), fracture, injury/trauma, Wound/injury/trauma, body region NOS, Wrist or hand or finger bones, fracture, injury/trauma, Wrist or hand or fingers, amputation, injury/trauma, Wrist or hand or fingers, blood vessels, wound/injury/trauma, Wrist or hand or fingers, joints or ligaments, dislocation/sprain/strain, injury/trauma, Wrist or hand or fingers, muscles/tendons, wound/injury/trauma, Wrist or hand or fingers, nerves, wound/injury/trauma, Wrist or hand or fingers, open wound, injury/trauma, Wrist or hand or fingers, superficial injury/trauma (minor, contusion), Wrist or hand or fingers, wound/injury/trauma, NOS, Ear, foreign body in, Eye, foreign body in, Gastrointestinal (GI) tract, foreign body in, Genitorurinary tract, foreign body in, Lightning injury, Respiratory tract, foreign body in
Firmness:	hard check
Timing:
App:	CCMDB.accdb
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

• Categories:  

• form:

Change log

• 2023-08-09 - reviewed this, and it turns out Anoxic brain injury, NOS was not assigned to Category:Potential trauma, but Respiratory tract, foreign body in was. Assigned Lightning injury to this as well. No change to the query.
• 2019-09-11 - introduced Category:Potential trauma to allow things like Anoxic brain injury, NOS that may or may not be traumas to be coded combined with things like Mechanism of injury: hanging or strangulation (accidental or intentional)
• 2019-06-18 - removed Iatrogenic mechanism that was added before, I think I misunderstood that during the early troubleshooting for this query
• 2019-05-14 - included Iatrogenic mechanism as permitted mechanisms
• 2019-05-14 - simplified listing
• 2019-05-09 - used to only check that mechanisms had traumas, added check that traumas have mechanisms.