2021-11-04 - SLPG Meeting
Date & Time
20:00 to 21:00 UTC Thursday 4th November 2021
Location
Zoom meeting link (password: 764978)
Goals
Review draft syntax updates for ECL v1.7
Suggest examples to include for ECL v1.7
Attendees
Chair: Former user (Deleted)
Project Group: michael lawley Daniel KarlssonAlejandro Lopez OsornioFeikje Hielkema (Unlicensed) Kai Kewley Rob Hausam roger.jane (Unlicensed) Anne Randorff Højen
Observers: Jeremy Rogers (Unlicensed)Brian Carlsen Elena IlyukhinaAndrew Perry (Unlicensed) András Peteri
Agenda and Meeting Notes
Description | Owner | Notes |
|---|---|---|
Welcome and agenda | Former user (Deleted) | Welcome to new attendees |
ECL v1.7 - Access to historical refsets | All | Proposal To leverage the existing memberOf (^) function, which currently only brings back the 'referencedComponentId', rather than the whole 'member' (i.e. row) as you might expect a 'memberOf' function to do. If we defined an expanded form of the current 'memberOf' function, which explicitly shows that by default we're selecting attributeOrder = 0 from the member, then the following 2 ECL would be equivalent.
This would allow us to select other columns of the refset using the same memberOf function - e.g.
And we could then introduce a 'Member filter' with a similar attribute reference - e.g.
Additional Examples
Questions
Reference set descriptor templates (for easy reference)
See discussion below "Querying Refset Attributes" |
onlyThe items below are currently on hold | ||
Postcoordination Topics |
|
|
Dynamic Templates |
|
|
Postcoordination Use Case Examples | All | Example 1 - Dentistry / Odontogram
Example 2 - Terminology binding
Example 3 - Mapping
Example 4 - Natural Language Processing
|
Postcoordination Guidance | Former user (Deleted) , Anne Randorff Højen , Kai Kewley | Practical Guide to Postcoordination
|
The items below are currently on hold | ||
Other Options for Future Progress |
|
|
URIs for Extended Editions |
| ON HOLD - How to refer to an 'extended edition' using a URI - e.g. "International Edition plus the following 2 nursing modules: 733983009 |IHTSDO Nursing Health Issues module|and 733984003 |IHTSDO Nursing Activities module| Use Case - Need to execute an ECL, that refers to "^ 733991000 | Nursing Health Issues Reference Set (foundation metadata concept) |" and/or "^ 733990004 | Nursing Activities Reference Set (foundation metadata concept) |", where the substrate includes the international edition, plus the modules that include these reference sets July 2020 International Edition URI: http://snomed.info/sct/900000000000207008/version/20200731 July 2020 International Edition + nursing modules URI ?? - For example:
|
Querying Refset Attributes | Former user (Deleted) | ON HOLD - Proposed syntax to support querying and return of alternative refset attributes (To be included in the SNOMED Query Language)
|
Returning Attributes | michael lawley | ON HOLD - Proposal (by Michael) for discussion
For example, I can write: << 404684003|Clinical finding| : 363698007|Finding site| = <<66019005|Limb structure| << 404684003|Clinical finding| . 363698007|Finding site| But I can't get all the attribute names that are used by << 404684003|Clinical finding|
|
Reverse Member Of | michael lawley | ON HOLD - Proposal for discussion What refsets is a given concept (e.g. 421235005 |Structure of femur|) a member of?
|
Expression Templates | Peter Williams |
Examples: [[+id]]: [[1..*] @my_group sameValue(morphology)] { |Finding site| = [[ +id (<<123037004 |Body structure (body structure)| MINUS << $site[! SELF ] ) @site ]] , |Associated morphology| = [[ +id @my_morphology ]]}
Note that QI Project is coming from a radically different use case. Instead of filling template slots, we're looking at existing content and asking "exactly how does this concept fail to comply to this template?" For discussion: {"timestamp":1792736229151,"msg":"A unknown Exception Occurred","errorMsg":"The provided AtlassianHostUser did not specify a user to act as.","code":"500"} Is it correct to say either one of the cardinality blocks is redundant? What are the implications of 1..1 on either side? This is less obvious for the self grouped case. Road Forward for SI
Additional note: QI project is no longer working in subhierarchies. Every 'set' of concepts is selected via ECL. In fact most reports should now move to this way of working since a subhierarchy is the trivial case. For a given template, we additionally specify the "domain" to which it should be applied via ECL. This is much more specific than using the focus concept which is usually the PPP eg Disease. FYI Michael Chu |
Description Templates | Kai Kewley |
|
Query Language
| Former user (Deleted) | FUTURE WORK Examples: version and dialect
Notes
|
Agenda and Meeting Notes
Description | Owner | Notes |
|---|---|---|
Welcome and agenda | Former user (Deleted) |
|
Postcoordination Transformations |
|
|
Dynamic Templates |
|
|
Postcoordination Use Case Examples | All | Example 1 - Dentistry / Odontogram
Example 2 - Terminology binding
Example 3 - Mapping
Example 4 - Natural Language Processing
|
Postcoordination Guidance | Former user (Deleted) , Anne Randorff Højen , Kai Kewley | Practical Guide to Postcoordination
|
The items below are currently on hold | ||
Other Options for Future Progress |
|
|
URIs for Extended Editions |
| ON HOLD - How to refer to an 'extended edition' using a URI - e.g. "International Edition plus the following 2 nursing modules: 733983009 |IHTSDO Nursing Health Issues module|and 733984003 |IHTSDO Nursing Activities module| Use Case - Need to execute an ECL, that refers to "^ 733991000 | Nursing Health Issues Reference Set (foundation metadata concept) |" and/or "^ 733990004 | Nursing Activities Reference Set (foundation metadata concept) |", where the substrate includes the international edition, plus the modules that include these reference sets July 2020 International Edition URI: http://snomed.info/sct/900000000000207008/version/20200731 July 2020 International Edition + nursing modules URI ?? - For example:
|
Querying Refset Attributes | Former user (Deleted) | ON HOLD - Proposed syntax to support querying and return of alternative refset attributes (To be included in the SNOMED Query Language)
|
Returning Attributes | michael lawley | ON HOLD - Proposal (by Michael) for discussion
For example, I can write: << 404684003|Clinical finding| : 363698007|Finding site| = <<66019005|Limb structure| << 404684003|Clinical finding| . 363698007|Finding site| But I can't get all the attribute names that are used by << 404684003|Clinical finding|
|
Reverse Member Of | michael lawley | ON HOLD - Proposal for discussion What refsets is a given concept (e.g. 421235005 |Structure of femur|) a member of?
|
Linda asked me to dig a little more in the MOVED_TO | MOVED_FROM stuff, and provide examples:
Over the years to Jan 2021, the International Core has "gifted" a cumulative total of 17,590 codes to a select band of exactly five other loci of editorial control as recipients, with each such transfer being signalled by 2 elements:
make the code inactive within the International Core data
add a new MOVED_TO historical association within the International Core data, pointing to a metadata concept within <<370136006|Namespace concept| whose preferred term will then reference a specific namespace that is owned by intended the new loci of editorial control and in which - at least in the RF1 era for which this particular handover mechanism was invented - it is expected (but not guaranteed) that a new semantically equivalent conceptID will eventually be stood up.
This MOVED_TO manoevre is ongoing today:
2002
14
2003
883
2004
7
2005
77
2006
107
2007
47
2008
366
2009
12890
2010
46
2011
6
2014
2423
2015
67
2016
88
2017
16
2018
190
2019
77
2020
181
2021
105
The lucky recipients of this traffic have so far been limited to just these five namespaces:
12062 codes to 370137002 Extension Namespace 1000000
415 codes to 370138007 Extension Namespace 1000001
167 codes to 384597007 Extension Namespace 1000002
4931 codes to 416516009 Extension Namespace 1000009
15 codes to 442502009 Extension Namespace 1000124
...which we can (rather painfully) decode using the not-very-machine-readable Namespace Identifier Registry at https://cis.ihtsdotools.org/info/index.html?home=namespaces to be actually:
12062 codes to 370137002 Extension Namespace 1000000 → UK Clinical Extension
415 codes to 370138007 Extension Namespace 1000001 → UK Drug Extension
167 codes to 384597007 Extension Namespace 1000002 → SNOMED International (huh?)
4931 codes to 416516009 Extension Namespace 1000009 → Veterinary Terminology Service Laboratory, USA (Veterinary Extension)
15 codes to 442502009 Extension Namespace 1000124 → National Library of Medicine (US Drug Extension)
Note that there has also been some quantity of traffic in the reverse direction.
For example, the UK Extensions record that they've historically MOVED a total of 764 conceptIds to the International Core:
2005
34
2006
4
2007
4
2010
249
2011
446
2012
27
Regardless of who is giving what to whom, however, from the point of view of any effort to repair data involving inactive codes, the MOVED_TO association is of course utterly useless.
What you really need are the MOVED_FROM relationships that the MOVED_TOs live in hope of eventually matching up with: each MOVED_FROM relationship will state a 1:1 bidirectional equivalent relationship that holds eternally between the original inactive identifier and an entirely different and new identifier that was created by the recipient NRC in a different namespace, after editorial control of the underlying idea MOVED_TO it.
As an example of such pairing, in the UK we have the following pair of lines in the union of all der2_cRefset_AssociationSnapshot files in our current release:
id
effectiveTime
active
moduleId
refsetid
referencedComponentID
linkedComponentId
5064db37-c7b3-4f5c-a6b0-52963a88d3ee
20180731
1
900000000000207008
900000000000524003
412785001
370137002
4828ec3e-1d0f-58ce-96ea-4d88b77c67fd
20181001
1
999000011000000103
900000000000525002
725291000000102
412785001
or, in more human readable form:
20180731 (CORE) 412785001 Women's refuge (qualifier value) MOVED_TO 370137002 Extension Namespace 1000000 (namespace concept)
20181001 (UK CLINICAL) 725291000000102 Women's refuge (qualifier value) MOVED_FROM 412785001 Women's refuge (qualifier value)
NB how MOVED_FROM is encoded here, with the referencedComponentId being the new active code!
Other examples from the UK Extension content of the same phenomenon include:
MOVED_TO
effectiveTime
OLD ID
OLD FSN
MOVED_FROM
effectiveTime
NEW ID
NEW FSN
20080131
294861006
Acset allergy (disorder)
20080401
338451000000103
Acset allergy (disorder)
20090131
213576007
[X]Traumatic amputation of other parts of foot (disorder)
20090401
470771000000109
[X]Traumatic amputation of other parts of foot (disorder)
20090131
274590004
[EDTA] Diabetes Type II (non-insulin-dependent) associated with renal failure (disorder)
20090401
453171000000101
Diabetes Type II (non-insulin-dependent) associated with renal failure - European Dialysis and Transplant Association (disorder)
20100731
183652002
Mental therapy follow-up (administrative concept)
20101001
749201000000109
Mental health therapy follow-up (record artifact)
20140731
270611000
Patient died in part 4 accommodation (finding)
20141001
929161000000107
Patient died in Part IV accommodation (finding)
20140731
185376003
Referred by NHS Direct (finding)
20141001
929141000000106
Referred by NHS Direct (finding)
20160731
303209007
Unfit to plead Criminal Procedure (Insanity & Unfitness to Plead) Act 1991 (finding)
20161001
1052741000000105
Unfit to plead under Criminal Procedure (Insanity and Unfitness to Plead) Act 1991 (finding)
20160731
414386002
Health visitor accident and emergency attendance follow up visit (procedure)
20161001
1052861000000102
Accident and emergency attendance follow-up visit by health visitor (procedure)
20180131
288831009
Care Program Approach assessment (procedure)
20180401
1092341000000101
Care Programme Approach assessment (procedure)
20180731
311129002
Technician - Royal Army Medical Corps (occupation)
20181001
1100841000000100
Technician - Royal Army Medical Corps (occupation)
20180731
310945005
Technician - Royal Electrical and Mechanical Engineers (occupation)
20181001
1100391000000103
Technician - Royal Electrical and Mechanical Engineers (occupation)
20180731
311090006
Telecommunications operator - Royal Signals (occupation)
20181001
1100761000000108
Telecommunications operator - Royal Signals (occupation)
20180731
311087000
Telecommunications technician - Royal Signals (occupation)
20181001
1100751000000105
Telecommunications technician - Royal Signals (occupation)
20180731
225927009
Utilities (qualifier value)
20181001
1099991000000104
Utilities (qualifier value)
We might reasonably suppose that, as other recent and continuing recipients of concepts that have been MOVED_TO them, both the Veterinary and US Extensions may also have MOVED_FROM associations.
For example, here are some very recent MOVED_TOs where content has been sent to the 1000009 namespace of the Veterinary Extension:
20180131 428593008|Abortion due to Brucella canis (disorder)|
20180131 6176008|Mycotic abortion (disorder)|
20180731 726858007|Entire infraorbital sinus (body structure)|
20180731 727198003|Entire palatine sinus (body structure)|
20180731 727411004|Entire subiliac lymph node (body structure)|
20180731 727146000|Entire supramammary lymph node (body structure)|
20180731 95642002|Granulomatous meningoencephalitis (disorder)|
20180731 10079006|Infection caused by Cysticercus cellulosae (disorder)|
20180731 1858000|Infection caused by Stilezia globipunctata (disorder)|
20180731 13218000|Infraorbital sinus (body structure)|
20180731 62248006|Juvenile pyoderma (disorder)|
20180731 471379007|Necrotizing mycotic dermatitis (disorder)|
20180731 71214009|Palatine sinus (body structure)|
20180731 113338001|Subiliac lymph node (body structure)|
20180731 127165003|Subiliac lymphadenopathy (disorder)|
20180731 62630005|Supramammary lymph node (body structure)|
20180731 127108004|Supramammary lymphadenopathy (disorder)|
20190131 82816005|Application of Kirschner-Ehmer splint (procedure)|
20190131 26484003|Bordetellosis (disorder)|
20190131 15477001|Coligranuloma (disorder)|
20190131 727055004|Entire prefemoral lymph node (body structure)|
20190131 292715003|Episioplasty (procedure)|
20190131 35047007|Infection caused by Histomonas (disorder)|
20190131 3660008|Lethal glossopharyngeal defect (disorder)|
20190131 48193007|Prefemoral lymph node (body structure)|
20190131 127201003|Prefemoral lymphadenopathy (disorder)|
20190131 9480005|Viral papular dermatitis (disorder)|
20190731 37649008|Acute metritis (disorder)|
20190731 196111003|Bacterial hemorrhagic septicemia (disorder)|
20190731 111908007|Branchiomycosis (disorder)|
20190731 370470002|Diskospondylitis (disorder)|
20190731 9772004|Hemorrhagic septicemia due to Pasteurella multocida (disorder)|
20190731 32701000|Infectious pustular vulvovaginitis (disorder)|
20190731 409935006|Juvenile pubic symphysiodesis (procedure)|
20190731 417293005|Laryngeal tie-forward (procedure)|
20190731 64230001|Mastitis-metritis-agalactia syndrome (disorder)|
20190731 15363000|Metritis (disorder)|
20190731 398048002|Placental lactogen measurement (procedure)|
20200131 6501005|Atrophic myositis (disorder)|
20200131 449238002|Canine coronavirus vaccine (substance)|
20200131 398758009|Chlamydophila psittaci vaccine (substance)|
20200131 399283001|Everted laryngeal saccules (disorder)|
20200131 195284000|Hemorrhagic septicemia barbone (disorder)|
20200131 198462004|Hemorrhagic septicemia caused by Pasteurella multocida (disorder)|
20200131 398976007|Parvovirus vaccine (substance)|
20200731 398856000|Bordetella vaccine (substance)|
20200731 7230005|Brucella vaccine (product)|
20200731 396421002|Brucella vaccine (substance)|
20200731 7141001|Brucellosis vaccination (procedure)|
20200731 64546005|Carpal hygroma (disorder)|
20200731 424548006|Elbow hygroma (disorder)|
20200731 730496001|Entire posterior medullary spinothalamic tract (body structure)|
20200731 370525007|Exudative diathesis (disorder)|
20200731 8605003|Immunization for bordetella (procedure)|
20200731 4118000|Multilobular chondroma and osteoma (morphologic abnormality)|
20200731 41039001|Omphalophlebitis (disorder)|
20200731 95731004|Pigmentary keratitis (disorder)|
20200731 449332004|Porphyromonas denticanis + porphyromonas gulae + porphyromonas salivosa vaccine (substance)|
20200731 361556005|Posterior medullary spinothalamic tract (body structure)|
20200731 399134006|Primary seborrhea (disorder)|
20200731 111355005|Pyogranulomatous serositis (disorder)|
20200731 398776002|Reovirus vaccine (substance)|
20200731 81970008|Swine influenza virus vaccine (product)|
20200731 428771000|Swine influenza virus vaccine (substance)|
20200731 38719000|Toxicoinfectious botulism (disorder)|
20200731 75211007|Trefoil dermatitis (disorder)|
20200731 370459009|West Nile virus vaccine (product)|
20200731 398775003|West Nile virus vaccine (substance)|
20210131 31437008|Lymphocytic-plasmacytic colitis (disorder)|
20210131 7024001|Lymphocytic-plasmacytic enteritis (disorder)|