Provide to Hemonc.org examples of timestamped begin/end date concepts and concept relationship assertions.

[mgurley]

• Example 1: Name change examples stable identifier stays stable (ICD10CM).
  • Reason: Giving more explicit definition of a disorder. In this case we just keep the last version of the name.
  • Revise from: Panic disorder without agoraphobia
  • Revise to: Panic disorder [episodic paroxysmal anxiety]
  • Reason: Typo
  • Revise from: Trichiasis without entropian
  • Revise to: Trichiasis without entropion

Before:

concept_id	concept_name	concept_code	valid_start_date	valid_end_date	invalid_reason
1	Panic disorder without agoraphobia	F41.0	1/1/2007	12/31/2099
2	Trichiasis without entropian	H02.05	1/1/2012	12/31/2099

After:

concept_id	concept_name	concept_code	valid_start_date	valid_end_date	invalid_reason
1	Panic disorder [episodic paroxysmal anxiety]	F41.0	1/1/2007	12/31/2099
2	Trichiasis without entropion	H02.05	1/1/2012	12/31/2099

• Example 2: Concept deprecation (ICD10CM).
  • Reason: The concepts created by mistake. There're two phalangs only in thumb, so "proximal or distal interphalangeal joint" localization is applied to other fingers but not a thumb. In this case we put the date of concept withdrawal and mark invalid_reason as "D" (deprecated).
  • Deprecation: Subluxation and dislocation of proximal interphalangeal joint of thumb
  • Deprecation: Subluxation and dislocation of distal interphalangeal joint of thumb

Before:

concept_id	concept_name	concept_code	valid_start_date	valid_end_date	invalid_reason
3	Subluxation and dislocation of proximal interphalangeal joint of thumb	S63.13	1/1/2012	12/31/2099
4	Subluxation and dislocation of distal interphalangeal joint of thumb	S63.14	1/1/2012	12/31/2099

After:

concept_id	concept_name	concept_code	valid_start_date	valid_end_date	invalid_reason
3	Subluxation and dislocation of proximal interphalangeal joint of thumb	S63.13	1/1/2012	9/30/2017	D
4	Subluxation and dislocation of distal interphalangeal joint of thumb	S63.14	1/1/2012	9/30/2017	D

• Example 3: Relationship assertion between two concepts retired.
  • Reason: Better relationship found (it relates now "Laryngeal structure" and "Neoplasm of uncertain behavior" respectively). We put the date of relationship withdrawal and mark invalid_reason as "D" (deprecated)
  • Deprecation: 22274(Neoplasm of uncertain behavior of larynx) Has finding site 4240671 (Anatomical structure)

Before:

concept_id_1	concept_id_2	relationship_id	valid_start_date	valid_end_date	invalid_reason
22274(Neoplasm of uncertain behavior of larynx)	4240671 (Anatomical structure)	Has finding site	7/31/2011	12/31/2099

After:

concept_id_1	concept_id_2	relationship_id	valid_start_date	valid_end_date	invalid_reason
22274(Neoplasm of uncertain behavior of larynx)	4240671 (Anatomical structure)	Has finding site	7/31/2011	1/30/2013	D
22274(Neoplasm of uncertain behavior of larynx)	4262229 (Laryngeal structure)	Has finding site	1/31/2013	12/31/2099