(Replaced content with "== Table: appointment == {| class="wikitable sortable mw-collapsible mw-collapsed" |'''Column name''' |'''Comments''' |'''Providing publisher''' |- |id |Unique Id of the a...") Tags: Replaced Visual edit |
No edit summary |
||
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]] | ||
|} | |} | ||
Revision as of 11:44, 18 May 2021
Table: appointment
Column name | Comments | Providing publisher |
id | Unique Id of the appointment (specific to the database) | |
organization_id | Owning organisation (i.e. publisher) | 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 |
schedule_id | The schedule the patient was put on to book multiple appointments. ID unique to the applied schedule | |
start_date | The start date of the appointment | EMIS |
planned_duration | The time allocated for the appointment, not necessarily the actual duration always in minutes | EMIS |
actual_duration | Time between sent in and left always in minutes | EMIS |
appointment_status_concept_id | The status of the appointment e.g. arrived/sent in/left/DNA | EMIS |
patient_wait | How long the patient waited from being marked as arrived to being sent in | |
patient_delay | How long the patient was delayed for | |
date_time_sent_in | Date and time the patient was sent into the practitioner | EMIS |
date_time_left | Date and time the patient left the practitioner | EMIS |
source_id | Unique reference to the source of the appointment | EMIS |
cancelled_date | The date the appointment was cancelled | EMIS |
Table: episode_of_care
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
Column name | Comments | Providing publisher |
id | Unique Id of the patient | |
organization_id | Owning organisation (i.e. publisher) | EMIS, ADT, BHRUT |
person_id | Unique individual across all organisations | |
title | The title of the patient | EMIS, ADT, BHRUT |
first_names | The first names of the patient | EMIS, ADT, BHRUT |
last_name | The last name of the patient | EMIS, ADT, BHRUT |
gender_concept_id | Reference to the gender of the patient | EMIS, ADT, BHRUT |
nhs_number | The NHS number of the patient | EMIS, ADT, BHRUT |
date_of_birth | The date of birth of the patient | EMIS, ADT, BHRUT |
date_of_death | The date of death of the patient | EMIS, ADT, BHRUT |
current_address_id | Reference to the current address of the patient | EMIS, ADT, BHRUT |
ethnic_code_concept_id | Reference to the ethnicity of the patient | EMIS, ADT, BHRUT |
registered_practice_organization_id | Reference to the organisation the patient is registered at | EMIS, ADT, BHRUT |
birth_year | EMIS, ADT, BHRUT | |
birth_month | EMIS, ADT, BHRUT | |
birth_week | EMIS, ADT, BHRUT |
Table: patient_additional
Column name | Comments | Providing publisher |
id | Unique Id of the patient | |
property_id | IM reference (e.g. cause of death) | |
value_id | IM reference (e.g. COVID) | |
json_value | Where there is no mapped value_id, just raw JSON | |
text_value | Where there is no mapped value_id or raw JSON, just a basic text value |