Variable Name
dx_fatigueRefreshed Date
2023-10
Files
1 Download↓
Tags
Level of Review
Data Model
Vocabularies
This concept set is inteded to identify patients with a diagnosis of fatigue.
Variable Status
Funder(s)
Provenance
The concept set was developed for the study "Preserving Kidney Function in Children with Chronic Kidney Disease" (PRESERVE) for diagnoses and symptoms fatigue.
Description
This condition concept set includes all fatigue-related conditions. It was generated by taking all descendants of the SNOMED code 84229001 for Fatigue, related ICD9CM/10/10CM codes, and searching all mentions of ‘fatigue’ in the concept_name. ICD codes are included with and without decimal points, indicated by cc_decimal_removal. This concept set is limited to ICD9, ICD10, ICD10CM and SNOMED diagnosis codes. Diagnoses related to pregnancy/gestation were excluded.
Medication Term Classes
Clinical Subjects Headings
Development Code
select * from concept where concept_code = '84229001' and vocabulary_id = 'SNOMED'; --"fatigue" clinical finding
--SM descendants
select distinct concept_id, concept_code, concept_name, vocabulary_id,
case when vocabulary_id = 'ICD9CM' then '09'
when vocabulary_id in ('ICD10', 'ICD10CM') then '10'
when vocabulary_id = 'SNOMED' then 'SM'
end pcornet_vocabulary_id
from concept where concept_id in (
select descendant_concept_id
from concept_ancestor
where ancestor_concept_id in (4223659) -- fatigue
and vocabulary_id in ('ICD9CM', 'ICD10', 'ICD10CM', 'SNOMED')
)
and lower(concept_name) not like '%pregnancy%'
and lower(concept_name) not like '%gestational%'
union
--mapping of SM codes to ICD
select distinct concept_id, concept_code, concept_name, vocabulary_id,
case when vocabulary_id = 'ICD9CM' then '09'
when vocabulary_id in ('ICD10', 'ICD10CM') then '10'
when vocabulary_id = 'SNOMED' then 'SM'
end pcornet_vocabulary_id
from concept where concept_id in (
select concept_id_1 from concept_relationship
where relationship_id = 'Maps to'
and concept_id_2 in (
select descendant_concept_id
from concept_ancestor
where ancestor_concept_id in (4223659)
))
and vocabulary_id in ('ICD9CM', 'ICD10', 'ICD10CM', 'SNOMED')
union
--string matching (in SM, catches non-standard codes in case other sites are using)
select distinct concept_id, concept_code, concept_name, vocabulary_id,
case when vocabulary_id = 'ICD9CM' then '09'
when vocabulary_id in ('ICD10', 'ICD10CM') then '10'
when vocabulary_id = 'SNOMED' then 'SM'
end pcornet_vocabulary_id
from concept
where ((lower(concept_name) like '%fatigue%')
and lower(concept_name) not like '%fracture%'
and lower(concept_name) not like '%no fatigue%'
and lower(concept_name) not like '%no history of fatigue%'
and lower(concept_name) not like '%no h/o fatigue%'
and lower(concept_name) not like '%fh:%'
and lower(concept_name) not like '%family history%'
and lower(concept_name) not like '%pregnancy%'
and lower(concept_name) not like '%gestational%'
and lower(concept_name) not like '%management%'
and lower(concept_name) not like '%score%'
and lower(concept_name) not like '%level of fatigue%'
and lower(concept_name) not like '%referral%'
and domain_id not in ('Drug', 'Procedure', 'Measurement', 'Type Concept', 'Metadata', 'Device')
--and concept_class_id not in ('Body Structure','Morph Abnormality')
and vocabulary_id in ('ICD9CM', 'ICD10', 'ICD10CM', 'SNOMED')
)
order by vocabulary_id, concept_codeCreative Commons license
Except where otherwised noted, this item's license is described as a CC-BY Attribution 4.0 License.