Assignment 3: Module 2 Medical Indicators
(2023-2024)
Report Assignment Indicators
Assignment 3: Module 2 Medical Indicators (2023-2024) 1
Indicators 2
Reflection 32
Time spending 34
,Indicators
10. Indicator: Patients with non-small cell lung carcinoma and hypertension
Numerator Number of patients diagnosed with a primary non-small cell lung carcinoma
where patients have received medication for hypertension
Denominator Total number of patients diagnosed with primary non-small cell lung carcinoma
Inclusion
Exclusion
Reporting choose a year (2018)
Year
Example on how to do it:
Step 1: Concepts non-small cell carcinoma of lung (SNOMED code: 424132000)
(linking to an ontology) Hypertension (SNOMED code: 59521000)
Step 2: bind concept to model Table conditions, CODE (424132000)
Table medications, REASONCODE (59521000)
Step 3: Reporting year table careplan
2018-01-01 <= careplans.STOP <= 2018-12-31 OR
careplan.STOP == NIL
Step 4: temporal constraints none
Step 5: numeric constraints none
Step 6: textual constraints none
Step 7: boolean constraints none
Step 8: Exclusion criteria / none
Inclusion criteria
Step 9: Numerator medications.REASONCODE = 59521000 (Hypertension)
(only in numerator)
,Computation of the quality indicator on the given data:
You can neglect the reporting year.
Description how you computed the result:
Example:
=QUERY(Conditions!$A2:$F4050;"select A, B, C,D, E,F where E = 424132000")
4 patients.
=QUERY(Medications!$A2:$M55665;"select A, B, C, D, E, F, G, H, I, J, K,L,M
where L = 59621000")
For the 4 patients with the conditions query:
=VLOOKUP(C3;C11:C22913;1;FALSE)
1 patient
Numerator: 1
Denominator: 4
Result: 0,25
See: spreadsheet
11. Indicator: Patients with primary non-small cell lung carcinoma who have had “MRI
for measurement of brain volume (procedure)” treatment
Numerator number of patients diagnosed with primary non-small cell lung carcinoma with
an “MRI for measurement of brain volume (procedure)” performed in 2000
Denominator total number of patients diagnosed with primary non-small cell lung carcinoma
Inclusion
Exclusion
Reporting 2012
Year
Step 1: Non-small cell carcinoma of lung (SCTID: 424132000)
Concepts Magnetic resonance imaging (SCTID: 698354004)
(linking to Magnetic resonance imaging for measurement of brain volume (procedure)
an ontology)
, Step 2: bind Table conditions, CODE (424132000)
concept to Tabel procedures, CODE (698354004)
model
Step 3: Table careplan
Reporting 2012-01-01 <= careplans.STOP <= 2012-12-31
year
Step 4: procedure.DATE <= 2000-12-31
temporal procedure.DATE >= 2000-01-01
constraints
Step 5: none
numeric
constraints
Step 6: none
textual
constraints
Step 7: none
boolean
constraints
Step 8: none
Exclusion
criteria /
Inclusion
criteria
Step 9: procedures.CODE = 698354004
Numerator
(only
in
numerator)
Using Excel:
(2023-2024)
Report Assignment Indicators
Assignment 3: Module 2 Medical Indicators (2023-2024) 1
Indicators 2
Reflection 32
Time spending 34
,Indicators
10. Indicator: Patients with non-small cell lung carcinoma and hypertension
Numerator Number of patients diagnosed with a primary non-small cell lung carcinoma
where patients have received medication for hypertension
Denominator Total number of patients diagnosed with primary non-small cell lung carcinoma
Inclusion
Exclusion
Reporting choose a year (2018)
Year
Example on how to do it:
Step 1: Concepts non-small cell carcinoma of lung (SNOMED code: 424132000)
(linking to an ontology) Hypertension (SNOMED code: 59521000)
Step 2: bind concept to model Table conditions, CODE (424132000)
Table medications, REASONCODE (59521000)
Step 3: Reporting year table careplan
2018-01-01 <= careplans.STOP <= 2018-12-31 OR
careplan.STOP == NIL
Step 4: temporal constraints none
Step 5: numeric constraints none
Step 6: textual constraints none
Step 7: boolean constraints none
Step 8: Exclusion criteria / none
Inclusion criteria
Step 9: Numerator medications.REASONCODE = 59521000 (Hypertension)
(only in numerator)
,Computation of the quality indicator on the given data:
You can neglect the reporting year.
Description how you computed the result:
Example:
=QUERY(Conditions!$A2:$F4050;"select A, B, C,D, E,F where E = 424132000")
4 patients.
=QUERY(Medications!$A2:$M55665;"select A, B, C, D, E, F, G, H, I, J, K,L,M
where L = 59621000")
For the 4 patients with the conditions query:
=VLOOKUP(C3;C11:C22913;1;FALSE)
1 patient
Numerator: 1
Denominator: 4
Result: 0,25
See: spreadsheet
11. Indicator: Patients with primary non-small cell lung carcinoma who have had “MRI
for measurement of brain volume (procedure)” treatment
Numerator number of patients diagnosed with primary non-small cell lung carcinoma with
an “MRI for measurement of brain volume (procedure)” performed in 2000
Denominator total number of patients diagnosed with primary non-small cell lung carcinoma
Inclusion
Exclusion
Reporting 2012
Year
Step 1: Non-small cell carcinoma of lung (SCTID: 424132000)
Concepts Magnetic resonance imaging (SCTID: 698354004)
(linking to Magnetic resonance imaging for measurement of brain volume (procedure)
an ontology)
, Step 2: bind Table conditions, CODE (424132000)
concept to Tabel procedures, CODE (698354004)
model
Step 3: Table careplan
Reporting 2012-01-01 <= careplans.STOP <= 2012-12-31
year
Step 4: procedure.DATE <= 2000-12-31
temporal procedure.DATE >= 2000-01-01
constraints
Step 5: none
numeric
constraints
Step 6: none
textual
constraints
Step 7: none
boolean
constraints
Step 8: none
Exclusion
criteria /
Inclusion
criteria
Step 9: procedures.CODE = 698354004
Numerator
(only
in
numerator)
Using Excel:
