format-validity

name	format-validity
description	Validate format of medical codes (ICD-9/10/11, SNOMED-CT, RxNorm, LOINC, ATC) in a QUIQ-format table. Identifies code type from variable name/description, then validates each value against the corresponding regex. Use for data quality assessment of medical code fields.

Format Validity

Validates the format of medical codes in a QUIQ-format table. Targets rows where Mapping_info_1 = 'medical_code', identifies the code system (e.g. ICD-10), and checks whether each value matches the expected format via regex.

When to Use This Skill

• After QUIQ conversion, to verify that medical codes follow standard format rules
• To detect malformed ICD codes, LOINC codes, etc.
• As part of LYDUS quality management assessment

Supported Code Types

Code System	Regex Pattern	Detection Keywords
ICD-9	^[0-9]{3}(\.[0-9]{1,2})?$	icd + 9
ICD-10	^[A-Z]{1}[0-9]{2}(\.[0-9]{1,2})?$	icd + 10
ICD-11	^[A-Z0-9][A-Z][0-9][A-Z0-9](\.[A-Z0-9]{1,2})?$	icd + 11
SNOMED-CT	^[0-9]{6,18}$	snomed + ct
RxNorm	^[0-9]{5,9}$	rxnorm
LOINC	^[0-9]{1,6}-[0-9]{1}$	loinc
ATC	^[A-Z][0-9]{2}[A-Z]{2}[0-9]{2}$	atc

Unknown code types → Is_valid = NULL (SQL) or (Python without LLM)