I'm finding some odd things that are labels as LOINCs. Here are some examples:
CONCEPT_CODE CONCEPT_NAME
LP102526-3 Enterococcus faecalis
LP163953-5 Base excess.100% oxygenated | Blood capillary
PUBLICHEALTH Public Health
PULM Pulmonary ventilator management
LA8967-7 Good
SELECT *
FROM CONCEPT c
WHERE VOCABULARY_ID = 'LOINC'
AND (CASE
WHEN SUBSTRING(c.concept_code,LEN(c.concept_code) -1,1) = '-' AND SUBSTRING(c.concept_code,LEN(c.concept_code),1) IN ('0','1','2','3','4','5','6','7','8','9') THEN
CASE
WHEN LEN(c.concept_code) =3 THEN 1
WHEN LEN(c.concept_code) =4 AND SUBSTRING(c.concept_code, 2,1) IN ('0','1','2','3','4','5','6','7','8','9') THEN 1
WHEN LEN(c.concept_code) =5 AND SUBSTRING(c.concept_code, 2,1) IN ('0','1','2','3','4','5','6','7','8','9') AND SUBSTRING(c.concept_code, 3,1) IN ('0','1','2','3','4','5','6','7','8','9') THEN 1
WHEN LEN(c.concept_code) =6 AND SUBSTRING(c.concept_code, 2,1) IN ('0','1','2','3','4','5','6','7','8','9') AND SUBSTRING(c.concept_code, 3,1) IN ('0','1','2','3','4','5','6','7','8','9') AND SUBSTRING(c.concept_code, 4,1) IN ('0','1','2','3','4','5','6','7','8','9') THEN 1
WHEN LEN(c.concept_code) =7 AND SUBSTRING(c.concept_code, 2,1) IN ('0','1','2','3','4','5','6','7','8','9') AND SUBSTRING(c.concept_code, 3,1) IN ('0','1','2','3','4','5','6','7','8','9') AND SUBSTRING(c.concept_code, 4,1) IN ('0','1','2','3','4','5','6','7','8','9') AND SUBSTRING(c.concept_code, 5,1) IN ('0','1','2','3','4','5','6','7','8','9') THEN 1
ELSE 0
END
ELSE 0
END
) =0
AND c.invalid_reason IS NULL
ericaVoss
commented
9 years ago
VERSION v5.0 21-Mar-2015
I'm finding some odd things that are labels as LOINCs. Here are some examples: