EMIS GP published data transformation and mapping - Revision history

AdminJo: /* Prescribing_IssueRecord */

2024-11-15T10:34:28Z

Prescribing_IssueRecord

← Older revision		Revision as of 10:34, 15 November 2024
Line 2,442:		Line 2,442:
	! scope="col" width="25%" \|FHIR		! scope="col" width="25%" \|FHIR
	! scope="col" width="15%" \|Table		! scope="col" width="15%" \|Table
	~~! scope="col" width="15%" \|Field~~
	! scope="col" width="15%" \|Field		! scope="col" width="15%" \|Field
	\|-		\|-

AdminJo: /* Prescribing_DrugRecord End Dates */

2024-11-15T10:33:40Z

Prescribing_DrugRecord End Dates

← Older revision		Revision as of 10:33, 15 November 2024
Line 2,600:		Line 2,600:
	=== Prescribing_DrugRecord End Dates ===		=== Prescribing_DrugRecord End Dates ===

	The Prescribing_DrugRecord file contains both a Boolean active indicator (IsActive) and the medication end date (CancellationDate). Within ~~Emis~~ Web, it’s the IsActive indicator that is used to determine whether medication is active or not, the CancellationDate just providing additional information for ended medication. Analysing the received data has highlighted that there are a number of cases where the CancellationDate doesn’t match what the IsActive flag states:		The Prescribing_DrugRecord file contains both a Boolean active indicator (IsActive) and the medication end date (CancellationDate). Within EMIS Web, it’s the IsActive indicator that is used to determine whether medication is active or not, the CancellationDate just providing additional information for ended medication. Analysing the received data has highlighted that there are a number of cases where the CancellationDate doesn’t match what the IsActive flag states:
	<pre>		<pre>
	1) IsActive = true but a CancellationDate is present;		1) IsActive = true but a CancellationDate is present;
	2) IsActive = false but a CancellationDate is absent. </pre>		2) IsActive = false but a CancellationDate is absent. </pre>

	From the dates of affected data, these appear to be related to either a service moving to ~~Emis~~ Web from another GP system, and are an artefact of that transfer.		From the dates of affected data, these appear to be related to either a service moving to EMIS Web from another GP system, and are an artefact of that transfer.

	To ensure consistency in the FHIR MedicationStatements created from this file, the Cancellation date will only be carried over if the DrugRecord is non-active. If no cancellation date is present, it will be derived from the medication start and course length (found from the associated Prescribing_IssueRecord file).		To ensure consistency in the FHIR MedicationStatements created from this file, the Cancellation date will only be carried over if the DrugRecord is non-active. If no cancellation date is present, it will be derived from the medication start and course length (found from the associated Prescribing_IssueRecord file).
Line 2,785:		Line 2,785:
	\| Mapping File		\| Mapping File
	\|-		\|-
	\| Admin_Patient::PatientTypeDescription		\| Admin_Patient::
			PatientTypeDescription
	\| [https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisPatientTypeMap.csv https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisPatientTypeMap.csv]		\| [https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisPatientTypeMap.csv https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisPatientTypeMap.csv]

Line 2,793:		Line 2,794:
	\| [https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisOrganisationTypeMap.csv https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisOrganisationTypeMap.csv]		\| [https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisOrganisationTypeMap.csv https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisOrganisationTypeMap.csv]
	\|-		\|-
	\| CareRecord_ObservationReferral::ReferralUrgency		\| CareRecord_ObservationReferral::
			ReferralUrgency
	\| [https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisReferralPriorityMap.csv https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisReferralPriorityMap.csv]		\| [https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisReferralPriorityMap.csv https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisReferralPriorityMap.csv]
	\|-		\|-
	\| CareRecord_ObservationReferral::ReferralServiceType		\| CareRecord_ObservationReferral::
			ReferralServiceType
	\| [https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisReferralServiceTypeMap.csv https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisReferralServiceTypeMap.csv]		\| [https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisReferralServiceTypeMap.csv https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisReferralServiceTypeMap.csv]
	\|-		\|-
	\| CareRecord_ObservationReferral::ReferralMode		\| CareRecord_ObservationReferral::
			ReferralMode
	\| [https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisReferalModeMap.csv https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisReferalModeMap.csv]		\| [https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisReferalModeMap.csv https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisReferalModeMap.csv]
	\|-		\|-
	\| CareRecord_Problem::ParentProblemRelationship		\| CareRecord_Problem::
			ParentProblemRelationship
	\| [https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisProblemRelationshipTypeMap.csv https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisProblemRelationshipTypeMap.csv]		\| [https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisProblemRelationshipTypeMap.csv https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisProblemRelationshipTypeMap.csv]
	\|-		\|-
	\| CareRecord_Problem::SignificanceDescription		\| CareRecord_Problem::
			SignificanceDescription
	\| [https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisProblemSeverityMap.csv https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisProblemSeverityMap.csv]		\| [https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisProblemSeverityMap.csv https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisProblemSeverityMap.csv]
	\|-		\|-
	\| Prescribing_DrugRecord::PrescriptionType		\| Prescribing_DrugRecord::
			PrescriptionType
	\| [https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisDrugRecordPrescriptionTypeMap.csv https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisDrugRecordPrescriptionTypeMap.csv]		\| [https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisDrugRecordPrescriptionTypeMap.csv https://github.com/endeavourhealth/Transforms/blob/master/src/main/resources/EmisDrugRecordPrescriptionTypeMap.csv]
	\|-		\|-

AdminJo: /* Prescribing_DrugRecord End Dates */

2024-11-15T10:31:22Z

Prescribing_DrugRecord End Dates

← Older revision		Revision as of 10:31, 15 November 2024
Line 2,602:		Line 2,602:
	The Prescribing_DrugRecord file contains both a Boolean active indicator (IsActive) and the medication end date (CancellationDate). Within Emis Web, it’s the IsActive indicator that is used to determine whether medication is active or not, the CancellationDate just providing additional information for ended medication. Analysing the received data has highlighted that there are a number of cases where the CancellationDate doesn’t match what the IsActive flag states:		The Prescribing_DrugRecord file contains both a Boolean active indicator (IsActive) and the medication end date (CancellationDate). Within Emis Web, it’s the IsActive indicator that is used to determine whether medication is active or not, the CancellationDate just providing additional information for ended medication. Analysing the received data has highlighted that there are a number of cases where the CancellationDate doesn’t match what the IsActive flag states:
	<pre>		<pre>
	#IsActive = true but a CancellationDate is present;		1) IsActive = true but a CancellationDate is present;
	#IsActive = false but a CancellationDate is absent. </pre>		2) IsActive = false but a CancellationDate is absent. </pre>

	From the dates of affected data, these appear to be related to either a service moving to Emis Web from another GP system, and are an artefact of that transfer.		From the dates of affected data, these appear to be related to either a service moving to Emis Web from another GP system, and are an artefact of that transfer.

AdminJo: /* Prescribing_DrugRecord End Dates */

2024-11-15T10:30:54Z

Prescribing_DrugRecord End Dates

← Older revision		Revision as of 10:30, 15 November 2024
Line 2,601:		Line 2,601:

	The Prescribing_DrugRecord file contains both a Boolean active indicator (IsActive) and the medication end date (CancellationDate). Within Emis Web, it’s the IsActive indicator that is used to determine whether medication is active or not, the CancellationDate just providing additional information for ended medication. Analysing the received data has highlighted that there are a number of cases where the CancellationDate doesn’t match what the IsActive flag states:		The Prescribing_DrugRecord file contains both a Boolean active indicator (IsActive) and the medication end date (CancellationDate). Within Emis Web, it’s the IsActive indicator that is used to determine whether medication is active or not, the CancellationDate just providing additional information for ended medication. Analysing the received data has highlighted that there are a number of cases where the CancellationDate doesn’t match what the IsActive flag states:
			<pre>
	#IsActive = true but a CancellationDate is present;		#IsActive = true but a CancellationDate is present;
	#IsActive = false but a CancellationDate is absent.		#IsActive = false but a CancellationDate is absent. </pre>

	From the dates of affected data, these appear to be related to either a service moving to Emis Web from another GP system, and are an artefact of that transfer.		From the dates of affected data, these appear to be related to either a service moving to Emis Web from another GP system, and are an artefact of that transfer.

AdminJo: /* CareRecord_ObservationReferral */

2024-11-15T10:29:51Z

CareRecord_ObservationReferral

← Older revision		Revision as of 10:29, 15 November 2024
Line 2,027:		Line 2,027:
	\|-		\|-
	\| PatientGuid		\| PatientGuid
	\| Link to Dimension.Patient.PatientGuid		\| Link to Dimension.Patient.
			PatientGuid
	\|<used to match to the CareRecord_Observation record>		\|<used to match to the CareRecord_Observation record>
	\|referral_request		\|referral_request
Line 2,033:		Line 2,034:
	\|-		\|-
	\| OrganisationGuid		\| OrganisationGuid
	\| Link to Admin_Organisation.OrganisationGuid		\| Link to Admin_Organisation.
			OrganisationGuid
	\|<not mapped>		\|<not mapped>
	\|		\|
Line 2,039:		Line 2,041:
	\|-		\|-
	\| ReferralTargetOrganisationGuid		\| ReferralTargetOrganisationGuid
	\| Link to Admin_Organisation.OrganisationGuid		\| Link to Admin_Organisation.
			OrganisationGuid
	\|Recipient::Reference *		\|Recipient::Reference *
	\|referral_request		\|referral_request
Line 2,087:		Line 2,090:
	\|-		\|-
	\| ReferralSourceOrganisationGuid*		\| ReferralSourceOrganisationGuid*
	\| Link to Admin_Organisation.OrganisationGuid		\| Link to Admin_Organisation.
			OrganisationGuid
	\|Requester::Reference *		\|Requester::Reference *
	\|referral_request		\|referral_request
Line 2,171:		Line 2,175:
	\|-		\|-
	\| OrganisationGuid		\| OrganisationGuid
	\| Link to Admin_Organisation.OrganisationGuid		\| Link to Admin_Organisation.
			OrganisationGuid
	\|<not mapped>		\|<not mapped>
	\| -		\| -
	\| -		\| -
	\|-		\|-
	\| ~~ParentProblemObservationGuid~~		\| ParentProblem
	\| If this observation has a parent code the link to the ParentObservationGuid is provided here		ObservationGuid
			\| If this observation has a parent
			code the link to the ParentObservationGuid is
			provided here
	\|primarycare-problem-related-extension::Target::ReferenceValue *		\|primarycare-problem-related-extension::Target::ReferenceValue *
	\|observation		\|observation
Line 2,225:		Line 2,233:
	\|-		\|-
	\| LastReviewUserInRoleGuid		\| LastReviewUserInRoleGuid
	\| Link to Admin_UserInRole.UserInRoleGuid		\| Link to Admin_UserInRole.
			UserInRoleGuid
	\|primarycare-problem-lastreviewed-extension::Performer::ReferenceValue *		\|primarycare-problem-lastreviewed-extension::Performer::ReferenceValue *
	\| -		\| -
Line 2,249:		Line 2,258:
	\|-		\|-
	\| ProcessingId		\| ProcessingId
	\| Sequentual identifier indicating the order to process the items		\| Sequentual identifier indicating
			the order to process the items
	\|**		\|**
	\| -		\| -
Line 2,293:		Line 2,303:
	\|-		\|-
	\| OrganisationGuid		\| OrganisationGuid
	\| Link to Admin_Organisation.OrganisationGuid		\| Link to Admin_Organisation.
			OrganisationGuid
	\|<not mapped>		\|<not mapped>
	\| -		\| -
Line 2,359:		Line 2,370:
	\|-		\|-
	\| ProblemObservationGuid		\| ProblemObservationGuid
	\| Link to CareRecord_Observation.ProblemGuid		\| Link to CareRecord_Observation.
			ProblemGuid
	\|ReasonForUseReference::Reference *		\|ReasonForUseReference::Reference *
	(target Condition resource is also updated with a reference back to this one)		(target Condition resource is also updated with a reference back to this one)
Line 2,369:		Line 2,381:
	\|primarycare-medication-authorisation-type-extension::CodeableConceptValue ***		\|primarycare-medication-authorisation-type-extension::CodeableConceptValue ***
	\|medication_statement		\|medication_statement
	\|~~authorisation_type_concept_id~~		\|authorisation_type_
			concept_id
	\|-		\|-
	\| IsActive		\| IsActive
Line 2,439:		Line 2,452:
	\|-		\|-
	\| PatientGuid		\| PatientGuid
	\| Link to Admin_Patient.PatientGuid		\| Link to Admin_Patient.
			PatientGuid
	\|Patient::Reference *		\|Patient::Reference *
	\|medication_order		\|medication_order
Line 2,445:		Line 2,459:
	\|-		\|-
	\| OrganisationGuid		\| OrganisationGuid
	\| Link to Admin_Organisation.OrganisationGuid		\| Link to Admin_Organisation.
			OrganisationGuid
	\|<not mapped>		\|<not mapped>
	\|medication_order		\|medication_order
Line 2,451:		Line 2,466:
	\|-		\|-
	\| DrugRecordGuid		\| DrugRecordGuid
	\| Link to Prescribing_DrugRecord.DrugRecordGuid		\| Link to Prescribing_DrugRecord.
			DrugRecordGuid
	\|primarycare-medication-order-authorisation-extension::ValueReference *		\|primarycare-medication-order-authorisation-extension::ValueReference *
	\|medication_order		\|medication_order
Line 2,518:		Line 2,534:
	\|-		\|-
	\| ProblemObservationGuid		\| ProblemObservationGuid
	\| Link to CareRecord_Observation.ProblemGuid		\| Link to CareRecord_Observation.
			ProblemGuid
	\|Reason::Reference *		\|Reason::Reference *
	(target Condition resource is also updated with a reference back to this one)		(target Condition resource is also updated with a reference back to this one)
Line 2,526:		Line 2,543:
	\| CourseDurationInDays		\| CourseDurationInDays
	\| Number of days the course was due to last (where known)		\| Number of days the course was due to last (where known)
	\|DispenseRequest.~~ExpectedSupplyDuration~~.Value		\|DispenseRequest.Expected
			SupplyDuration.Value
	\|medication_order		\|medication_order
	\|duration_days		\|duration_days

AdminJo: /* CareRecord_ObservationReferral */

2024-11-15T10:24:49Z

CareRecord_ObservationReferral

← Older revision		Revision as of 10:24, 15 November 2024
Line 2,009:		Line 2,009:
	This file is used to provide additional data for CareRecord_Observation records, populating the extra data onto FHIR ReferralRequest resources.		This file is used to provide additional data for CareRecord_Observation records, populating the extra data onto FHIR ReferralRequest resources.

	{\| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:60%;"		{\| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;"
	! colspan="2" style="color:#04466b" \|'''Publisher'''		! colspan="2" style="color:#04466b" \|'''Publisher'''
	!style="color:#04466b"\|DDS Core		!style="color:#04466b"\|DDS Core

AdminJo at 10:19, 15 November 2024

2024-11-15T10:19:11Z

Show changes

AdminJo: /* Mapping to FHIR Value Sets */

2024-11-14T12:28:19Z

Mapping to FHIR Value Sets

← Older revision		Revision as of 12:28, 14 November 2024
Line 2,701:		Line 2,701:
	There are a number of fields in the Emis extract that are mapped to FHIR fields that are value sets. In these cases, the mappings are performed using the files listed below. In each case, if a code is found that isn’t in the relevant mapping file, then an exception is thrown and the transform halted.		There are a number of fields in the Emis extract that are mapped to FHIR fields that are value sets. In these cases, the mappings are performed using the files listed below. In each case, if a code is found that isn’t in the relevant mapping file, then an exception is thrown and the transform halted.

	{\| border="1"
			{\| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;"

	\|-		\|-
			\|- style="background-color:#04466b; color: white; vertical-align: top;"
	\| Field		\| Field
	\| Mapping File		\| Mapping File

AdminJo: /* Prescribing_IssueRecord */

2024-11-14T12:25:17Z

Prescribing_IssueRecord

← Older revision		Revision as of 12:25, 14 November 2024
Line 2,362:		Line 2,362:
	Each record in this file is mapped to a FHIR MedicationOrder resource.		Each record in this file is mapped to a FHIR MedicationOrder resource.

	{\| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:70%;"		{\| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;"
	! colspan="2" style="color:#~~90A4AE~~" \|'''Publisher'''		! colspan="2" style="color:#04466b" \|'''Publisher'''
	!style="color:#~~90A4AE~~"\|DDS Core		!style="color:#04466b"\|DDS Core
	! colspan="2" style="color:#~~90A4AE~~"\|Compass V2		! colspan="2" style="color:#04466b"\|Compass V2
	\|- style="background-color:#~~90A4AE~~; color: white; vertical-align: top;"		\|- style="background-color:#04466b; color: white; vertical-align: top;"
	! scope="col" width="15%" \|Field Name		! scope="col" width="15%" \|Field Name
	! scope="col" width="15%" \|Data/Coding Type		! scope="col" width="15%" \|Data/Coding Type
	! scope="col" width="25%" \|FHIR		! scope="col" width="25%" \|FHIR
	! scope="col" width="15%" \|Table		! scope="col" width="15%" \|Table
			! scope="col" width="15%" \|Field
	! scope="col" width="15%" \|Field		! scope="col" width="15%" \|Field
	\|-		\|-

AdminJo: /* Prescribing_DrugRecord */

2024-11-14T12:25:06Z

Prescribing_DrugRecord

← Older revision		Revision as of 12:25, 14 November 2024
Line 2,211:		Line 2,211:
	Each record in this file is mapped to a FHIR MedicationStatement resource.		Each record in this file is mapped to a FHIR MedicationStatement resource.

	{\| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:70%;"		{\| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;"
	! colspan="2" style="color:#~~90A4AE~~" \|'''Publisher'''		! colspan="2" style="color:#04466b" \|'''Publisher'''
	!style="color:#~~90A4AE~~"\|DDS Core		!style="color:#04466b"\|DDS Core
	! colspan="2" style="color:#~~90A4AE~~"\|Compass V2		! colspan="2" style="color:#04466b"\|Compass V2
	\|- style="background-color:#~~90A4AE~~; color: white; vertical-align: top;"		\|- style="background-color:#04466b; color: white; vertical-align: top;"
	! scope="col" width="15%" \|Field Name		! scope="col" width="15%" \|Field Name
	! scope="col" width="15%" \|Data/Coding Type		! scope="col" width="15%" \|Data/Coding Type

← Older revision		Revision as of 10:34, 15 November 2024
Line 2,442:		Line 2,442:
	! scope="col" width="25%" \|FHIR		! scope="col" width="25%" \|FHIR
	! scope="col" width="15%" \|Table		! scope="col" width="15%" \|Table
	~~! scope="col" width="15%" \|Field~~
	! scope="col" width="15%" \|Field		! scope="col" width="15%" \|Field
	\|-		\|-

← Older revision		Revision as of 12:25, 14 November 2024
Line 2,362:		Line 2,362:
	Each record in this file is mapped to a FHIR MedicationOrder resource.		Each record in this file is mapped to a FHIR MedicationOrder resource.

	{\| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:70%;"		{\| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;"
	! colspan="2" style="color:#~~90A4AE~~" \|'''Publisher'''		! colspan="2" style="color:#04466b" \|'''Publisher'''
	!style="color:#~~90A4AE~~"\|DDS Core		!style="color:#04466b"\|DDS Core
	! colspan="2" style="color:#~~90A4AE~~"\|Compass V2		! colspan="2" style="color:#04466b"\|Compass V2
	\|- style="background-color:#~~90A4AE~~; color: white; vertical-align: top;"		\|- style="background-color:#04466b; color: white; vertical-align: top;"
	! scope="col" width="15%" \|Field Name		! scope="col" width="15%" \|Field Name
	! scope="col" width="15%" \|Data/Coding Type		! scope="col" width="15%" \|Data/Coding Type
	! scope="col" width="25%" \|FHIR		! scope="col" width="25%" \|FHIR
	! scope="col" width="15%" \|Table		! scope="col" width="15%" \|Table
			! scope="col" width="15%" \|Field
	! scope="col" width="15%" \|Field		! scope="col" width="15%" \|Field
	\|-		\|-

← Older revision		Revision as of 12:25, 14 November 2024
Line 2,211:		Line 2,211:
	Each record in this file is mapped to a FHIR MedicationStatement resource.		Each record in this file is mapped to a FHIR MedicationStatement resource.

	{\| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:70%;"		{\| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;"
	! colspan="2" style="color:#~~90A4AE~~" \|'''Publisher'''		! colspan="2" style="color:#04466b" \|'''Publisher'''
	!style="color:#~~90A4AE~~"\|DDS Core		!style="color:#04466b"\|DDS Core
	! colspan="2" style="color:#~~90A4AE~~"\|Compass V2		! colspan="2" style="color:#04466b"\|Compass V2
	\|- style="background-color:#~~90A4AE~~; color: white; vertical-align: top;"		\|- style="background-color:#04466b; color: white; vertical-align: top;"
	! scope="col" width="15%" \|Field Name		! scope="col" width="15%" \|Field Name
	! scope="col" width="15%" \|Data/Coding Type		! scope="col" width="15%" \|Data/Coding Type