This query accepts a SNOMED-CT pathogen ID as input and returns all conditions caused by the pathogen or disease causing agent identified using queries C07 or C08.
Input:
Parameter |
Example |
Mandatory |
Notes |
SNOMED-CT Concept ID |
4248851 |
Yes |
Concept Identifier for ‘Treponema pallidum’ |
As of date |
Sysdate |
No |
Valid record as of specific date. Current date – sysdate is a default |
Sample query run:
The following is a sample run of the query to list conditions caused by pathogen or causative agent. Sample parameter substitution is highlighted in blue.
SELECT A.concept_Id Condition_ID,
A.concept_Name Condition_name,
A.concept_Code Condition_code,
A.concept_Class Condition_class,
A.vocabulary_id Condition_vocab_ID,
VA.vocabulary_name Condition_vocab_name,
D.concept_Id Causative_agent_ID,
D.concept_Name Causative_agent_Name,
D.concept_Code Causative_agent_Code,
D.concept_Class Causative_agent_Class,
D.vocabulary_id Causative_agent_vocab_ID,
VS.vocabulary_name Causative_agent_vocab_name
FROM vocabulary.concept_relationship CR,
vocabulary.concept A,
vocabulary.concept D,
vocabulary.vocabulary VA,
vocabulary.vocabulary VS,
vocabulary.relationship RT
WHERE CR.relationship_ID = 55
AND CR.concept_id_1 = A.concept_id
AND A.vocabulary_id = VA.vocabulary_id
AND CR.concept_id_2 = D.concept_id
AND D.concept_id = 4248851
AND D.vocabulary_id = VS.vocabulary_id
AND CR.relationship_ID = RT.relationship_ID
AND sysdate BETWEEN CR.valid_start_date AND CR.valid_end_date
Output:
Output field list:
Field |
Description |
Condition_ID |
Condition concept Identifier |
Condition_Name |
Name of the standard condition concept |
Condition_Code |
Concept code of the standard concept in the source vocabulary |
Condition_Class |
Concept class of standard vocabulary concept |
Condition_Vocab_ID |
Vocabulary the standard concept is derived from as vocabulary ID |
Condition_Vocab_Name |
Name of the vocabulary the standard concept is derived from |
Causative_Agent_ID |
Pathogen concept ID entered as input |
Causative_Agent_Name |
Pathogen Name |
Causative_Agent_Code |
Concept Code of pathogen concept |
Causative_Agent_Class |
Concept Class of pathogen concept |
Causative_Agent_Vocab_ID |
Vocabulary the pathogen concept is derived from as vocabulary ID |
Causative_Agent_Vocab_Name |
Name of the vocabulary the pathogen concept is derived from |
Sample output record:
Field |
Value |
Condition_ID |
4326735 |
Condition_Name |
Spastic spinal syphilitic paralysis |
Condition_Code |
75299005 |
Condition_Class |
Clinical finding |
Condition_Vocab_ID |
1 |
Condition_Vocab_Name |
SNOMED-CT |
Causative_Agent_ID |
4248851 |
Causative_Agent_Name |
Treponema pallidum |
Causative_Agent_Code |
72904005 |
Causative_Agent_Class |
Organism |
Causative_Agent_Vocab_ID |
1 |
Causative_Agent_Vocab_Name |
SNOMED-CT |
|
|