forked from ethercis/VirtualEhr
-
Notifications
You must be signed in to change notification settings - Fork 2
/
population-composition-evaluation.aql
35 lines (30 loc) · 1.81 KB
/
population-composition-evaluation.aql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
select
e/ehr_id/value as ehrId,
e/ehr_status/subject/external_ref/id/value as subjectId,
e/ehr_status/subject/external_ref/namespace as subjectNamespace,
a/context/start_time/value as compositionStartTime,
a/uid/value as compositionId,
a/composer/name as composerName,
a/composer/external_ref/id/value as composerId,
a/composer/external_ref/namespace as composerNamespace,
b_a/uid/value as entryId,
b_a/protocol[at0042]/items[at0062]/value/value as AssertedDate,
b_a/data[at0001]/items[at0002] as Causative_agent,
b_a/data[at0001]/items[at0063]/value/defining_code/code_string as Status_code,
b_a/data[at0001]/items[at0101]/value/defining_code/code_string as Criticality_code,
b_a/data[at0001]/items[at0120]/value/defining_code/code_string as Category_code,
b_a/data[at0001]/items[at0117]/value/value as Onset_of_last_reaction,
b_a/data[at0001]/items[at0058]/value/defining_code/code_string as Reaction_mechanism_code,
b_a/data[at0001]/items[at0006]/value/value as Comment,
b_a/data[at0001]/items[at0009]/items[at0010] as Specific_substance,
b_a/data[at0001]/items[at0009]/items[at0021]/value/defining_code/code_string as Certainty_code,
b_a/data[at0001]/items[at0009]/items[at0011] as Manifestation,
b_a/data[at0001]/items[at0009]/items[at0012]/value/value as Reaction_description,
b_a/data[at0001]/items[at0009]/items[at0027]/value/value as Onset_of_reaction,
b_a/data[at0001]/items[at0009]/items[at0089]/value/defining_code/code_string as Severity_code,
b_a/data[at0001]/items[at0009]/items[at0106] as Route_of_exposure,
b_a/data[at0001]/items[at0009]/items[at0032]/value/value as Adverse_reaction_risk_Comment
from EHR e
contains COMPOSITION a[openEHR-EHR-COMPOSITION.adverse_reaction_list.v1]
contains EVALUATION b_a[openEHR-EHR-EVALUATION.adverse_reaction_risk.v1]
where a/name/value='Adverse reaction list'