View source for Compass 2 Schema Mappings

== Table: appointment ==
{| class="wikitable sortable mw-collapsible mw-collapsed"
|'''Column name'''
|'''Comments'''
|'''Providing publisher'''
|-
|id
|Unique Id of the appointment (specific to the database)
|
|-
|organization_id
|Owning organisation (i.e.  publisher)
|[[EMIS published data transformation and mapping|EMIS]]
|-
|patient_id
|The organisations record for this person’s registration. Patients may have multiple records across  clinical systems and may have registered at an organisation multiple times
|
|-
|person_id
|Unique individual across all  organisations
|
|-
|practitioner_id
|The clinician the activity is  recorded against
|[[EMIS published data transformation and mapping|EMIS]]
|-
|schedule_id
|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
|The start date of the  appointment
|[[EMIS published data transformation and mapping|EMIS]]
|-
|planned_duration
|The time allocated for the  appointment, not necessarily the actual duration always in minutes
|[[EMIS published data transformation and mapping|EMIS]]
|-
|actual_duration
|Time between sent in and left  always in minutes
|[[EMIS published data transformation and mapping|EMIS]]
|-
|appointment_status_concept_id
|The status of the appointment  e.g. arrived/sent in/left/DNA
|[[EMIS published data transformation and mapping|EMIS]]
|-
|patient_wait
|How long the patient waited  from being marked as arrived to being sent in
|[[EMIS published data transformation and mapping|EMIS]]
|-
|patient_delay
|How long the patient was  delayed for
|[[EMIS published data transformation and mapping|EMIS]]
|-
|date_time_sent_in
|Date and time the patient was  sent into the practitioner
|[[EMIS published data transformation and mapping|EMIS]]
|-
|date_time_left
|Date and time the patient left  the practitioner
|[[EMIS published data transformation and mapping|EMIS]]
|-
|source_id
|Unique reference to the source  of the appointment
|[[EMIS published data transformation and mapping|EMIS]]
|-
|cancelled_date
|The date the appointment was  cancelled
|[[EMIS published data transformation and mapping|EMIS]]
|}

== Table: episode_of_care ==
{| class="wikitable sortable mw-collapsible mw-collapsed"
|'''Column name'''
|'''Comments'''
|'''Providing publisher'''
|-
|id
|Unique Id of the episode of  care
|
|-
|organization_id
|Owning organisation (i.e.  publisher)
|
|-
|patient_id
|The organisations record for  this person’s registration. Patients may have multiple records across  clinical systems and may have registered at an organisation multiple times
|
|-
|person_id
|Unique individual across all organisations
|
|-
|registration_type_concept_id
|Reference to the registration  type of the patient
|
|-
|registration_status_concept_id
|Reference to the registration  status of the patient
|
|-
|date_registered
|The date the registration was  started  for this episode of care
|
|-
|date_registered_end
|The date the registration was  ended  for this episode of care
|
|-
|usual_gp_practitioner_id
|Reference to the usual GP for  this episode of care
|
|}

== Table: patient ==
{| class="wikitable sortable mw-collapsible mw-collapsed"
|'''Column name'''
|'''Comments'''
|'''Providing publisher'''
|-
|id
|Unique Id of the patient
| style="color:grey;" |'''&#8211;'''
|-
|organization_id
|Owning organisation (i.e. publisher)
|[[EMIS published data transformation and mapping|EMIS]], [[HL7 ADT|ADT]], [[BHRUT Medway Extract FHIR Mapping|BHRUT]]
|-
|person_id
|Unique individual across all  organisations
|
|-
|title
|The title of the patient
|[[EMIS published data transformation and mapping|EMIS]], [[HL7 ADT|ADT]], [[BHRUT Medway Extract FHIR Mapping|BHRUT]]
|-
|first_names
|The first names of the patient
|[[EMIS published data transformation and mapping|EMIS]], [[HL7 ADT|ADT]], [[BHRUT Medway Extract FHIR Mapping|BHRUT]]
|-
|last_name
|The last name of the patient
|[[EMIS published data transformation and mapping|EMIS]], [[HL7 ADT|ADT]], [[BHRUT Medway Extract FHIR Mapping|BHRUT]]
|-
|gender_concept_id
|Reference to the gender of the  patient
|[[EMIS published data transformation and mapping|EMIS]], [[HL7 ADT|ADT]], [[BHRUT Medway Extract FHIR Mapping|BHRUT]]
|-
|nhs_number
|The NHS number of the patient
|[[EMIS published data transformation and mapping|EMIS]], [[HL7 ADT|ADT]], [[BHRUT Medway Extract FHIR Mapping|BHRUT]]
|-
|date_of_birth
|The date of birth of the patient
|[[EMIS published data transformation and mapping|EMIS]], [[HL7 ADT|ADT]], [[BHRUT Medway Extract FHIR Mapping|BHRUT]]
|-
|date_of_death
|The date of death of the patient
|[[EMIS published data transformation and mapping|EMIS]], [[HL7 ADT|ADT]], [[BHRUT Medway Extract FHIR Mapping|BHRUT]]
|-
|current_address_id
|Reference to the current  address of the  patient
|[[EMIS published data transformation and mapping|EMIS]], [[HL7 ADT|ADT]], [[BHRUT Medway Extract FHIR Mapping|BHRUT]]
|-
|ethnic_code_concept_id
|Reference to the ethnicity of the patient
|[[EMIS published data transformation and mapping|EMIS]], [[HL7 ADT|ADT]], [[BHRUT Medway Extract FHIR Mapping|BHRUT]]
|-
|registered_practice_organization_id
|Reference to the organisation  the patient is registered at
|[[EMIS published data transformation and mapping|EMIS]], [[HL7 ADT|ADT]], [[BHRUT Medway Extract FHIR Mapping|BHRUT]]
|-
|birth_year
|
|[[EMIS published data transformation and mapping|EMIS]], [[HL7 ADT|ADT]], [[BHRUT Medway Extract FHIR Mapping|BHRUT]]
|-
|birth_month
|
|[[EMIS published data transformation and mapping|EMIS]], [[HL7 ADT|ADT]], [[BHRUT Medway Extract FHIR Mapping|BHRUT]]
|-
|birth_week
|
|[[EMIS published data transformation and mapping|EMIS]], [[HL7 ADT|ADT]], [[BHRUT Medway Extract FHIR Mapping|BHRUT]]
|}

== Table: patient_additional ==
{| class="wikitable sortable mw-collapsible mw-collapsed"
|'''Column name'''
|'''Comments'''
|'''Providing publisher'''
|-
|id
|Unique Id of the patient
| style="color:grey;" |'''&#8211;'''
|-
|property_id
|IM reference (e.g. cause of death)
|[[BHRUT Medway Extract FHIR Mapping|BHRUT]]
|-
|value_id
|IM reference (e.g. COVID)
|[[BHRUT Medway Extract FHIR Mapping|BHRUT]]
|-
|json_value
|Where there is no mapped value_id, just raw JSON
| style="color:grey;" |'''&#8211;'''
|-
|text_value
|Where there is no mapped value_id or raw JSON, just a basic text value
| style="color:grey;" |'''&#8211;'''
|}<br />__FORCETOC____INDEX____NONEWSECTIONLINK__