Compass Database Mappings - Revision history

JoshuA: /* Pathology result */

2022-04-27T09:16:37Z

Pathology result

← Older revision		Revision as of 09:16, 27 April 2022
Line 536:		Line 536:
	\|practitioner_id		\|practitioner_id
	\|practitioner.id		\|practitioner.id
	~~\|-style='background-color: #da614e;'~~
	~~\|There is no Organization on DiagnosticReport. Potentially it could come by populating the Encounter relationship~~
	~~\|observation~~
	~~\|organization_id~~
	~~\|organization.id~~
	\|}		\|}

Line 599:		Line 594:
	\|practitioner_id		\|practitioner_id
	\|practitioner.id		\|practitioner.id
	\|- ~~style="background-color: #da614e;"~~		\|-
	\|~~There is no Organization on Observation. Potentially it could come by populating the Encounter relationship~~		\|extension = PARENT_RESOURCE
	\|observation		\|observation
	\|~~organization_id~~		\|parent_observation_id
	\|~~organization.id~~		\|
	\|}		\|}

Line 616:		Line 611:
	!foreign key		!foreign key
	\|-		\|-
	\|~~text OR mediumtext~~		\|valueString
	\|observation		\|observation
	\|result_text		\|result_text*
	\|		\|
	\|}		\|}
			<nowiki>*</nowiki>if the valuestring is significantly longer than text allows, consider changing this to mediumtext.

	<u>Numeric result</u>		<u>Numeric result</u>
	{\| class="wikitable"		{\| class="wikitable"

2022-04-25T10:26:09Z

Pathology result

← Older revision		Revision as of 10:26, 25 April 2022
Line 615:		Line 615:
	!column		!column
	!foreign key		!foreign key
	\|- ~~style="background-color: #da614e;~~		\|-
	\|~~vaueString - is the column wide enough? Might be better to store the report outside of the Observation table and reference it~~		\|text OR mediumtext
	\|observation		\|observation
	\|result_text		\|result_text

2021-07-20T13:34:34Z

Pathology result

← Older revision		Revision as of 13:34, 20 July 2021
Line 615:		Line 615:
	!column		!column
	!foreign key		!foreign key
	\|-		\|- style="background-color: #da614e;
	\|vaueString - is the column wide enough? Might be better to store the report outside of the Observation table and reference it		\|vaueString - is the column wide enough? Might be better to store the report outside of the Observation table and reference it
	\|observation		\|observation

2021-07-20T13:34:07Z

Radiology result

2021-07-20T13:33:54Z

Pathology result

2021-07-20T13:32:47Z

DiagnosticReport

@@ Line 544: / Line 544: @@
 === Observation ===
-May need some words about radioalogy and also microbiology (composite/reflex/battery)
+Observation resources are mapped differently depending upon whether or not the data represents a pathology, microbiology or a radiology result (see [[FHIR Store Mappings#OBX%20-%20Observation%20or%20result|FHIR Store Mappings]] for details on how an Observation is used to store these different kinds of result)
 {| class="wikitable"
 !property
@@ Line 560: / Line 564: @@
 |core_concept_id
+|
-|-style='background-color: #ddd;'
+|- style="background-color: #ddd;"
 |code.coding.display
+|
+|
+|
-|-style='background-color: #ddd;'
+|- style="background-color: #ddd;"
 |code.coding.system
+|
+|
+|
-|-style='background-color: #ddd;'
+|- style="background-color: #ddd;"
 |code.text
+|
@@ Line 580: / Line 584: @@
 |clinical_effective_date
+|
-|-style='background-color: #ddd;'
+|- style="background-color: #ddd;"
 |category
+|
@@ Line 595: / Line 599: @@
 |practitioner_id
 |practitioner.id
-|-style='background-color: #da614e;'
+|- style="background-color: #da614e;"
-|There is no Organization on DiagnosticReport. Potentially it could come by populating the Encounter relationship
+|There is no Organization on Observation. Potentially it could come by populating the Encounter relationship
 |observation
 |organization_id
 |organization.id
 |}

2021-07-16T12:40:01Z

Observation

← Older revision		Revision as of 12:40, 16 July 2021
Line 544:		Line 544:

	=== Observation ===		=== Observation ===
			May need some words about radioalogy and also microbiology (composite/reflex/battery)
	{\| class="wikitable"		{\| class="wikitable"
	!property		!property

2021-07-16T12:39:12Z

DiagnosticReport

@@ Line 486: / Line 486: @@
 === DiagnosticReport ===
 {| class="wikitable"
 !property

2021-07-16T12:38:43Z

DiagnosticReport

← Older revision		Revision as of 12:38, 16 July 2021
Line 537:		Line 537:
	\|practitioner.id		\|practitioner.id
	\|-style='background-color: #da614e;'		\|-style='background-color: #da614e;'
	\|There is no Organization on DiagnosticReport. Potentially it could come ~~through~~ the Encounter relationship		\|There is no Organization on DiagnosticReport. Potentially it could come by populating the Encounter relationship
	\|observation		\|observation
	\|organization_id		\|organization_id
	\|organization.id		\|organization.id
	\|}		\|}

2021-07-16T12:37:33Z

Procedure

← Older revision		Revision as of 12:37, 16 July 2021
Line 478:		Line 478:
	\|practitioner_id		\|practitioner_id
	\|practitioner.id		\|practitioner.id
	\|-~~style='background-color: #da614e;'~~		\|-
	\|~~There is no Organization on DiagnosticReport. Potentially it could come through the Encounter relationship~~		\|encounter
	\|observation		\|observation
	\|~~organization_id~~		\|encounter_id
	\|~~organization~~.id		\|encounter.id
	\|}		\|}