Compass 2 Schema Mappings - Revision history

JoshuA at 08:22, 25 May 2021

2021-05-25T08:22:57Z

← Older revision		Revision as of 08:22, 25 May 2021
Line 27:		Line 27:
	\|schedule_id		\|schedule_id
	\|The schedule the patient was put on to book multiple appointments. ID unique to the applied schedule		\|The schedule the patient was put on to book multiple appointments. ID unique to the applied schedule
	\|		\|[[EMIS published data transformation and mapping\|EMIS]]
	\|-		\|-
	\|start_date		\|start_date
Line 47:		Line 47:
	\|patient_wait		\|patient_wait
	\|How long the patient waited from being marked as arrived to being sent in		\|How long the patient waited from being marked as arrived to being sent in
	\|		\|[[EMIS published data transformation and mapping\|EMIS]]
	\|-		\|-
	\|patient_delay		\|patient_delay
	\|How long the patient was delayed for		\|How long the patient was delayed for
	\|		\|[[EMIS published data transformation and mapping\|EMIS]]
	\|-		\|-
	\|date_time_sent_in		\|date_time_sent_in

JoshuA at 08:07, 25 May 2021

2021-05-25T08:07:04Z

← Older revision		Revision as of 08:07, 25 May 2021
Line 121:		Line 121:
	\|id		\|id
	\|Unique Id of the patient		\|Unique Id of the patient
	\|		\| style="color:grey;" \|'''–'''
	\|-		\|-
	\|organization_id		\|organization_id

JoshuA at 08:06, 25 May 2021

2021-05-25T08:06:23Z

← Older revision		Revision as of 08:06, 25 May 2021
Line 192:		Line 192:
	\|id		\|id
	\|Unique Id of the patient		\|Unique Id of the patient
	\|		\| style="color:grey;" \|'''–'''
	\|-		\|-
	\|property_id		\|property_id
	\|IM reference (e.g. cause of death)		\|IM reference (e.g. cause of death)
	\|		\|[[BHRUT Medway Extract FHIR Mapping\|BHRUT]]
	\|-		\|-
	\|value_id		\|value_id
	\|IM reference (e.g. COVID)		\|IM reference (e.g. COVID)
	\|		\|[[BHRUT Medway Extract FHIR Mapping\|BHRUT]]
	\|-		\|-
	\|json_value		\|json_value
	\|Where there is no mapped value_id, just raw JSON		\|Where there is no mapped value_id, just raw JSON
	\|		\| style="color:grey;" \|'''–'''
	\|-		\|-
	\|text_value		\|text_value
	\|Where there is no mapped value_id or raw JSON, just a basic text value		\|Where there is no mapped value_id or raw JSON, just a basic text value
	\|		\| style="color:grey;" \|'''–'''
	\|}<br />		\|}<br />__FORCETOC____INDEX____NONEWSECTIONLINK__
	~~__FORCETOC__~~
	~~__INDEX__~~
	~~__NONEWSECTIONLINK__~~

JoshuA at 11:44, 18 May 2021

2021-05-18T11:44:42Z

← Older revision		Revision as of 11:44, 18 May 2021
Line 133:		Line 133:
	\|title		\|title
	\|The title of the patient		\|The title of the patient
	\|[[EMIS published data transformation and mapping\|EMIS]]		\|[[EMIS published data transformation and mapping\|EMIS]], [[HL7 ADT\|ADT]], [[BHRUT Medway Extract FHIR Mapping\|BHRUT]]
	\|-		\|-
	\|first_names		\|first_names
	\|The first names of the patient		\|The first names of the patient
	\|[[EMIS published data transformation and mapping\|EMIS]]		\|[[EMIS published data transformation and mapping\|EMIS]], [[HL7 ADT\|ADT]], [[BHRUT Medway Extract FHIR Mapping\|BHRUT]]
	\|-		\|-
	\|last_name		\|last_name
	\|The last name of the patient		\|The last name of the patient
	\|[[EMIS published data transformation and mapping\|EMIS]]		\|[[EMIS published data transformation and mapping\|EMIS]], [[HL7 ADT\|ADT]], [[BHRUT Medway Extract FHIR Mapping\|BHRUT]]
	\|-		\|-
	\|gender_concept_id		\|gender_concept_id
	\|Reference to the gender of the patient		\|Reference to the gender of the patient
	\|[[EMIS published data transformation and mapping\|EMIS]]		\|[[EMIS published data transformation and mapping\|EMIS]], [[HL7 ADT\|ADT]], [[BHRUT Medway Extract FHIR Mapping\|BHRUT]]
	\|-		\|-
	\|nhs_number		\|nhs_number
	\|The NHS number of the patient		\|The NHS number of the patient
	\|[[EMIS published data transformation and mapping\|EMIS]]		\|[[EMIS published data transformation and mapping\|EMIS]], [[HL7 ADT\|ADT]], [[BHRUT Medway Extract FHIR Mapping\|BHRUT]]
	\|-		\|-
	\|date_of_birth		\|date_of_birth
	\|The date of birth of the patient		\|The date of birth of the patient
	\|[[EMIS published data transformation and mapping\|EMIS]]		\|[[EMIS published data transformation and mapping\|EMIS]], [[HL7 ADT\|ADT]], [[BHRUT Medway Extract FHIR Mapping\|BHRUT]]
	\|-		\|-
	\|date_of_death		\|date_of_death
	\|The date of death of the patient		\|The date of death of the patient
	\|[[EMIS published data transformation and mapping\|EMIS]]		\|[[EMIS published data transformation and mapping\|EMIS]], [[HL7 ADT\|ADT]], [[BHRUT Medway Extract FHIR Mapping\|BHRUT]]
	\|-		\|-
	\|current_address_id		\|current_address_id
	\|Reference to the current address of the patient		\|Reference to the current address of the patient
	\|[[EMIS published data transformation and mapping\|EMIS]]		\|[[EMIS published data transformation and mapping\|EMIS]], [[HL7 ADT\|ADT]], [[BHRUT Medway Extract FHIR Mapping\|BHRUT]]
	\|-		\|-
	\|ethnic_code_concept_id		\|ethnic_code_concept_id
	\|Reference to the ethnicity of the patient		\|Reference to the ethnicity of the patient
	\|[[EMIS published data transformation and mapping\|EMIS]]		\|[[EMIS published data transformation and mapping\|EMIS]], [[HL7 ADT\|ADT]], [[BHRUT Medway Extract FHIR Mapping\|BHRUT]]
	\|-		\|-
	\|registered_practice_organization_id		\|registered_practice_organization_id
	\|Reference to the organisation the patient is registered at		\|Reference to the organisation the patient is registered at
	\|[[EMIS published data transformation and mapping\|EMIS]]		\|[[EMIS published data transformation and mapping\|EMIS]], [[HL7 ADT\|ADT]], [[BHRUT Medway Extract FHIR Mapping\|BHRUT]]
	\|-		\|-
	\|birth_year		\|birth_year
	\|		\|
	\|[[EMIS published data transformation and mapping\|EMIS]]		\|[[EMIS published data transformation and mapping\|EMIS]], [[HL7 ADT\|ADT]], [[BHRUT Medway Extract FHIR Mapping\|BHRUT]]
	\|-		\|-
	\|birth_month		\|birth_month
	\|		\|
	\|[[EMIS published data transformation and mapping\|EMIS]]		\|[[EMIS published data transformation and mapping\|EMIS]], [[HL7 ADT\|ADT]], [[BHRUT Medway Extract FHIR Mapping\|BHRUT]]
	\|-		\|-
	\|birth_week		\|birth_week
	\|		\|
	\|[[EMIS published data transformation and mapping\|EMIS]]		\|[[EMIS published data transformation and mapping\|EMIS]], [[HL7 ADT\|ADT]], [[BHRUT Medway Extract FHIR Mapping\|BHRUT]]
	\|}		\|}

JoshuA: Replaced content with "== Table: appointment == {| class="wikitable sortable mw-collapsible mw-collapsed" |'''Column name''' |'''Comments''' |'''Providing publisher''' |- |id |Unique Id of the a..."

2021-05-18T11:44:01Z

Replaced content with "== Table: appointment == {| class="wikitable sortable mw-collapsible mw-collapsed" |'''Column name''' |'''Comments''' |'''Providing publisher''' |- |id |Unique Id of the a..."

Show changes

JoshuA: Created page with "== Table: allergy_intolerance == PRIMARY KEY (organization_id,person_id,id) {| class="wikitable sortable mw-collapsible mw-collapsed" |'''Column name''' |'''Data type''' |'''C..."

2021-05-18T11:18:57Z

Created page with "== Table: allergy_intolerance == PRIMARY KEY (organization_id,person_id,id) {| class="wikitable sortable mw-collapsible mw-collapsed" |'''Column name''' |'''Data type''' |'''C..."

Show changes