Table 2.

Defined mapping rules for OMOP CDM concept_id, LOINC code, and test results from the molecular study pathology reports.

Test name	CONCEPT_ID	LOINC code	RESULT_Attribute	Normalization rules for results value concept
NRAS mutation	3001274	21719-0	Codon 12 (exon 2), Codon 13 (exon 2), Codon 61 (exon 3)	If 1 or more positive values are present, treat as total positive
KRAS mutation	36203353	85509-8	Codon 12 (exon 2), Codon 13 (exon 2), Codon 61 (exon 3)	If 1 or more positive values are present, treat as total positive
MSIa	3047348	43368-0	BAT26, BAT25, D5S346, D17S250, D2S123	Categorized as MSI-H (high) if more than 1 value is positive, MSI-L (low) if 1 value is positive, and MSSb if no positive value is present
BRAF mutation	40761583	58483-9	V600E, K601E	If more than 1 positive value is present, treat as total positive

^aMSI: microsatellite instability.

^bMSS: microsatellite stable.