Clean Table Descriptions

(Last updated: 2025-09-26, Created: 2025-09-26)

Form Configurations

ewa_clean.form_configurations: This table contains information about the content of a form and how it is configured.

Column Name	Data Type	Description
unique_id	String	Unique id for this table, only based on form_id.
form_id	String	Form Configuration Id from source, unique id for each form.
form_name	String	Name of the form created in EWA.
form_state	Int	State of the form, 0 = draft, 1 = published.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Form Configuration Sections

ewa_clean.form_configuration_sections: This table contains information about the content of a section in a form and how it is configured.

Column Name	Data Type	Description
unique_id	String	Unique id for this table, only based on section_id.
section_id	String	Form Configuration Section Id from source, unique id for each section in a form.
form_id	String	Form Configuration Id from source, unique id for each form.
section_title	String	Title of the section.
section_description	String	Description of the section.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Form Configuration Elements

ewa_clean.form_configuration_elements: This table contains information about elements and element options in a form section.

Column Name	Data Type	Description
unique_id	String	Unique id for this table, based on element_id, section_id and option_id.
element_id	String	Form Configuration Element Id from source, unique id for each element in a form section.
section_id	String	Form Configuration Section Id from source, unique id for each section in a form.
option_id	String	Form Configuration Option Id from source, unique id for each option in a form element.
element_field_type	String	Field type of the element.
element_label	String	Label of the element.
element_description	String	Description of the element.
option_value	String	Value of the option.
option_score	Int	Score assigned to the option.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Form Responses

ewa_clean.form_responses: This table contains information about responses to a form.

Column Name	Data Type	Description
unique_id	String	Unique id for this table, only based on response_id.
response_id	String	Form Response Id from source, unique id for each response to a form.
form_id	String	Form Configuration Id from source, unique id for each form.
response_state	Int	State of the response, 0 = started, 1 = finished.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Form Response Elements

ewa_clean.form_response_elements: This table contains information about responses to elements in a form section.

Column Name	Data Type	Description
unique_id	String	Unique id for this table.
response_section_id	String	Form Response Section Id from source, unique id for each response to a section in a form.
section_id	String	Form Configuration Section Id from source, unique id for each section in a form.
element_id	String	Form Configuration Element Id from source, unique id for each element in a form section.
option_id	String	Form Configuration Option Id from source, unique id for each option in a form element.
element_response_value	String	Response value provided for the element.
element_response_type	String	Response type provided for the element.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Forms

ewa_clean.records_forms: Bridge table to connect records to form responses.

Column Name	Data Type	Description
unique_id	String	Unique id for this table, based on response_id and record_id.
response_id	String	Form Response Id from source, unique id for each response to a form.
record_id	Int	Record Id from source, unique id for each record. Used to connect to the records table.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Cardiac Arrest Forms

ewa_clean.cardiac_arrest_forms: The ewa_clean__cardiac_arrest_forms table contains information about the information in a cardiac arrest forms.

Column Name	Data Type	Description
id	Int	The unique identifier from EWA for each cardiac arrest form.
unique_id	String	A unique identifier in Analytics generated for each table.
record_id	Int	The unique identifier for a record.
form_status	String	The status of the cardiac arrest form, indicating if it's completed or ongoing.
emcc_alerted_time_known	String	Indicates if the time when the EMCC was alerted is known.
emcc_alerted_time_stamp	DateTime	Timestamp indicating when the EMCC was alerted.
event_time_known	String	Indicates if the time of the cardiac arrest is known.
event_time_stamp	DateTime	Timestamp of the cardiac arrest.
reported	String	Indicates if it was reported as a cardiac arrest.
ambulance_arrival_time_stamp	DateTime	Timestamp when the ambulance arrived at the scene.
cardiac_arrest_place	String	Location where the cardiac arrest took place.
collapse_seen	String	Indicator of whether the collapse was witnessed.
cardiac_arrest_cause	String	The cause of the cardiac arrest.
acute_breast_pain	String	Indicator if the patient experienced acute breast pain prior to the arrest.
cardiac_arrest_conjunction_exercise	String	Indicates whether the cardiac arrest occurred during exercise.
cpr_performed_bystanders	String	Indicates if CPR was performed by bystanders.
cpr_method	String	The method of CPR performed.
cpr_performed_first_responder	String	Indicator of whether the first responder performed CPR.
cpr_method_first_respondent	String	The method of CPR used by the first respondent.
aed_connected	String	Indicates if an AED was connected.
shocks_administered	String	Indicates if an AED did shock administration.
first_shock_time_stamp	DateTime	Timestamp indicating when the first shock was given.
first_heart_rhythm	String	The patient's initial heart rhythm at first contact.
cpr_performed_paramedics	String	Indicates if CPR was performed by paramedics.
cpr_not_started	String	Reason why CPR was not initiated, if applicable.
cpr_started_time_stamp	DateTime	Timestamp indicating when CPR was initiated.
defibrillation_paramedics	String	Indicates if defibrillation was performed by paramedics.
number_shocks	String	Total number of shocks.
airways_management	String	Details about airway management procedures performed.
capnography	String	Use of capnography during resuscitation.
adrenalin	String	Indicates if adrenalin was administered.
amiodarone	String	Indicates if amiodarone was administered.
prehospital_thrombolysis	String	Indicates if prehospital thrombolysis was done.
chest_compression_machine	String	Indicates if a chest compression machine was used.
chest_compression_machine_time_stamp	DateTime	Timestamp indicating when the chest compression machine was initiated.
cpr_was_stopped	String	Indicator if CPR was stopped.
cpr_stopped_time_stamp	DateTime	Timestamp indicating when CPR was stopped.
cpr_stop_cause	String	Reason for stopping CPR.
rosc_achieved	String	Indicator if ROSC was achieved.
continuous_rosc_achieved	String	Indicator if continuous ROSC was achieved.
continuous_rosc_time_stamp	DateTime	Timestamp indicating when continuous ROSC was achieved.
active_cooling_started	String	Indicator if active cooling treatment was started.
active_cooling_started_time_stamp	DateTime	Timestamp indicating when active cooling was initiated.
twelve_lead_ecg	String	Indicates if a 12-lead ECG was performed.
patient_transported_hospital	String	Indicates if the patient was transported to a hospital.
direct_transport_hospital	String	Indicates if direct transport to a hospital with Angio/PCI-lab occurred.
direct_transport_pci	String	Indicates if direct transport to a PCI-lab occurred.
status_at_hospital_arrival	String	Patient's status at arrival at the hospital.
hospital_arrival_time_known	String	Indicates if the time when the patient arrived at the hospital is known.
hospital_arrival_time_stamp	DateTime	Timestamp indicating when the patient arrived at the hospital.
delivery_hospital	String	The hospital to which the patient was delivered.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Checklist Configuration Items

ewa_clean.checklist_configuration_items: The checklist_configuration_items table defines the items in a checklist and holds information about that specific checklist.

Column Name	Data Type	Description
id	String	Unique identifier for the checklist configuration item. Based on the id and the item_number.
unique_id	String	A unique identifier in Analytics generated for each table.
checklist_configuration_id	Int	Identifier for the checklist configuration.
checklist_guid	String	Globally unique identifier (GUID) for the checklist.
checklist_name	String	Name of the checklist.
item_number	String	The item number within the checklist.
item_description	String	Description of the checklist item.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Checklist Response Items

ewa_clean.checklist_response_items: The checklist_responses table contains records of individual checklist responses, including responses to specific checklist items.

Column Name	Data Type	Description
unique_id	String	A unique identifier in Analytics generated for each table.
checklist_configuration_item_id	String	Identifier for the checklist item associated with the response.
record_id	Int	The unique identifier for a record.
completed_time_stamp	DateTime	Timestamp when the checklist was completed.
item_number	String	The item number within the checklist.
item_response_is_selected	String	Indicates whether the checklist item was selected as a response (true/false).
item_response_text	String	Text response provided for the checklist item.
item_response_value	String	Value associated with the checklist item's response.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Configurable Mission Types

ewa_clean.configurable_mission_types: This model unpacks and transforms data related to configurable mission types, with multilingual support for names.

Column Name	Data Type	Description
id	String	The unique identifier from EWA for each configurable mission type.
unique_id	String	A unique identifier in Analytics generated for each table.
name	String	The default name of the configurable mission type.
name_en_US	String	The name of the mission type in US English (en-US).
name_en_GB	String	The name of the mission type in British English (en-GB).
name_da_DK	String	The name of the mission type in Danish (da-DK).
name_fr_FR	String	The name of the mission type in French (fr-FR).
name_de_DE	String	The name of the mission type in German (de-DE).
name_nb_NO	String	The name of the mission type in Norwegian (nb-NO).
name_sv_SE	String	The name of the mission type in Swedish (sv-SE).
priority_level	Int	The priority level associated with the mission type.
is_system_mission_type	String	Indicates whether the mission type is a system-defined type.
predecessor	String	The predecessor mission type id, if applicable.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Emcc Tickets

ewa_clean.emcc_tickets: The emcc_tickets table contains ticket data related to EMCC missions, including mission IDs, urgency levels, and dispatch code information.

Column Name	Data Type	Description
id	String	Unique identifier from EWA for each emcc ticket.
unique_id	String	A unique identifier in Analytics generated for each table.
full_emcc_mission_id	String	The mission identifier in the EMCC system including the resource assigned to the mission.
emcc_mission_id	String	The mission identifier in the EMCC system.
mission_resource_id	String	The identifier for the resource assigned to the mission.
full_emcc_mission_id_updated_at	DateTime	Timestamp of the last update to the full mission ID.
emcc_alerted_time_stamp	DateTime	Timestamp when the EMCC was alerted.
emcc_alerted_time_stamp_updated_at	DateTime	Timestamp of the last update to the alerted timestamp.
dispatch_code	String	The dispatch code associated with the emcc ticket.
dispatch_code_updated_at	DateTime	Timestamp of the last update to the dispatch code.
dispatch_code_description	String	Description of the dispatch code.
dispatch_code_description_updated_at	DateTime	Timestamp of the last update to the dispatch code description.
urgency_level	String	The urgency level of the emcc ticket.
urgency_level_updated_at	DateTime	Timestamp of the last update to the urgency level.
problem_description	String	A description of the problem associated with the emcc ticket.
updated_at	DateTime	Updated at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Locations

ewa_clean.locations: Locations registered in EWA with their associated metadata and a tag id.

Column Name	Data Type	Description
id	Int	The unique identifier from EWA for each location.
unique_id	String	A unique identifier in Analytics generated for each table.
location_name	String	The name of the location.
tag_id	String	The tag id for the location id, used to connect to the tag table.
location_guid	String	The location guid.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Organizations

ewa_clean.organizations: The ewa_clean__organizations table contains details about organizations, including related record information and metadata timestamps. One organization is also referred to as a health trust.

Column Name	Data Type	Description
id	Int	Unique identifier from EWA for each organization.
unique_id	String	A unique identifier in Analytics generated for each table.
name	String	Name of the organization.
organization_reference	String	Reference number or name for the organization.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Pr Crewroles

ewa_clean.pr_crewroles: This model extracts and transforms crew roles data, including role names, resource types, and timestamps.

Column Name	Data Type	Description
id	String	The unique identifier from EWA for the crew role.
unique_id	String	A unique identifier in Analytics generated for each table.
resource_type_id	String	The identifier for the resource type associated with the crew role.
name	String	The name of the crew role.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Pr Medical Record Crews

ewa_clean.pr_medical_record_crews: This model serves as a bridge between the configurable crew roles and a specific record, linking crew members to records.

Column Name	Data Type	Description
id	String	The unique identifier from EWA for the medical record crew entry.
unique_id	String	A unique identifier in Analytics generated for each table.
record_id	Int	The unique identifier for a record.
crewrole_id	String	The identifier for the crew role associated with this medical record crew entry, linking to the configurable crew roles.
user_id	String	The unique identifier for the user (crew member) linked to this record.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Pr Users

ewa_clean.pr_users: This model contains user information including email, full name, and metadata for tracking user updates and deletions.

Column Name	Data Type	Description
id	String	The unique identifier from EWA for each user.
unique_id	String	A unique identifier in Analytics generated for each table.
user_id	String	The user information used as the user identifier. Depends on the AD configuration, but it is usually the email.
full_name	String	The full name of the user.
email	String	The email address of the user.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Record Status

ewa_clean.record_status: The ewa_clean__record_status table contains information about the status of records in EWA.

Column Name	Data Type	Description
status_code_id	Int	The unique identifier from EWA for each record status.
nb_NO	String	Name of the record status in Norwegian.
en_GB	String	Name of the record status in English.

Records

ewa_clean.records: This main table connects the other tables in the model that contains different information from the records. The table contains essential record information such as status, and timestamps.

Column Name	Data Type	Description
id	Int	The unique identifier from EWA for each record.
unique_id	String	Unique id for this table, based on record_id from EWA.
model_version	Int	The version of the model associated with the record.
status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
en_GB	String	The status description in English.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Billable Information

ewa_clean.records_billable_information: Data filled out in the Billing tile in EWA.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
unique_id	String	Unique id for this table, based on record_id from EWA.
attachment_ids	String	Comma-separated list of attachment IDs related to the billable information.
insurance_company	String	The name of the insurance company associated with the record's billable information.
insurance_policy_number	String	The policy number for the insurance associated with the record.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Configurable Mission Types

ewa_clean.records_configurable_mission_types: The bridge between configurable mission types and associated records.

Column Name	Data Type	Description
id	String	The unique identifier from EWA for each configurable mission type.
unique_id	String	Unique id for this table, based on configurable_mission_type_id and record_id from EWA.
configurable_mission_type_id	String	The identifier linking to the specific configurable mission type associated with the record.
record_id	Int	The unique identifier for a record.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Contagion

ewa_clean.records_contagion: Data filled out in the contagion tile in EWA.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
unique_id	String	A unique identifier in Analytics generated for each table.
contagion	Int	Contagion true or false, as extracted from JSON data.
risk_id	Int	The unique identifier from EWA for each contagion risk.
risk_text	String	Description text for the contagion risk.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Drugs

ewa_clean.records_drugs: Data filled out in the drug tile in EWA.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
unique_id	String	A unique identifier in Analytics generated for each table.
name	String	The name of the drug administered.
time_stamp	DateTime	The timestamp when the drug was administered.
dose	String	The dose of the drug administered.
unit	String	The unit of the drug dose, such as mg, stk, etc.
route	String	The route or form of administration for the drug.
drugs_order	Int	The order number of the drug within the record, indicating sequence.
given_by_type	String	The type or role of the person who administered the drug.
given_by_full_name	String	The full name of the personnel who administered the drug.
given_by_user_id	String	The user ID of the personnel who administered the drug.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Emcc Tickets

ewa_clean.records_emcc_tickets: The records_emcc_tickets bridges the EMCC tickets to their associated records.

Column Name	Data Type	Description
id	String	Unique identifier.
unique_id	String	A unique identifier in Analytics generated for each table.
emcc_ticket_id	String	Unique identifier for each emcc ticket.
record_id	Int	The unique identifier for a record.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Gcs

ewa_clean.records_gcs: Data filled out in the gcs tile in EWA.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
unique_id	String	A unique identifier in Analytics generated for each table.
time_stamp	DateTime	The timestamp when the GCS score was recorded.
patient_type	Int	The type of patient associated with the GCS entry, as an integer.
type	String	The type of GCS response (e.g., motor, verbal, or eye opening).
description	String	Description of the GCS response type.
score	Int	The score associated with the GCS response.
gcs_order	Int	The order number of the GCS entry within the record, indicating sequence.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records History Of Presenting Complaint Legacy

ewa_clean.records_history_of_presenting_complaint_legacy: This model extracts and transforms data related to the old History of Illness entries that were replaced by the new History of Presenting Complaint tables. See ewa_clean.history_of_presenting_complaint for the new entries.

Column Name	Data Type	Description
record_id	Int	The unique identifier for the record associated with the History of Presenting Complaint data.
abcde_a	String	Airway status (A) from the ABCDE assessment.
abcde_b	String	Breathing (B) from the ABCDE assessment.
abcde_c	String	Circulation (C) from the ABCDE assessment.
abcde_d	String	Disability (D) from the ABCDE assessment.
abcde_e	String	Exposure (E) from the ABCDE assessment.
sampler_s	String	Signs and Symptoms from the SAMPLER assessment.
sampler_a	String	Allergies from the SAMPLER assessment.
sampler_m	String	Medications from the SAMPLER assessment.
sampler_p	String	Past Medical History from the SAMPLER assessment.
sampler_l	String	Last Oral Intake from the SAMPLER assessment.
sampler_e	String	Events Leading Up to Present Illness/Injury from the SAMPLER assessment.
sampler_r	String	Risk Factors from the SAMPLER assessment.
opqrst_o	String	Onset from the OPQRST assessment.
opqrst_p	String	Provocation/Palliation from the OPQRST assessment.
opqrst_q	String	Quality from the OPQRST assessment.
opqrst_r	String	Region/Radiation from the OPQRST assessment.
opqrst_s	String	Severity from the OPQRST assessment.
opqrst_t	String	Time (duration/progression) from the OPQRST assessment.
traume_h	String	Head findings from the TRAUME assessment.
traume_n	String	Neck/throat findings from the TRAUME assessment.
traume_t	String	Thorax findings from the TRAUME assessment.
traume_a	String	Abdomen findings from the TRAUME assessment.
traume_b	String	Pelvis findings from the TRAUME assessment.
traume_u	String	Lower extremity findings from the TRAUME assessment.
traume_o	String	Upper extremity findings from the TRAUME assessment.
traume_r	String	Back findings from the TRAUME assessment.
free_text	String	A free-text field for capturing any additional or unstructured information about the patient's history of illness.
record_status	Int	Status code of the record.
record_updated_at	DateTime	Timestamp of the last update to the record.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Infusions

ewa_clean.records_infusions: Data filled out in the infusion tile in EWA.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
unique_id	String	A unique identifier in Analytics generated for each table.
start_time_stamp	DateTime	The timestamp when the infusion started.
end_time_stamp	DateTime	The timestamp when the infusion ended.
amount	String	The amount administered during the infusion.
unit	String	The unit of the infusion amount, such as ml or mg.
infusion_order	Int	The order number of the infusion within the record, indicating sequence.
given_by_full_name	String	The full name of the personnel who administered the infusion.
given_by_user_id	String	The user ID of the personnel who administered the infusion.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Interventions

ewa_clean.records_interventions: Data filled out in the intervention tile in EWA.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
unique_id	String	A unique identifier in Analytics generated for each table.
name	String	The name of the intervention performed.
time_stamp	DateTime	The timestamp when the intervention was performed.
intervention_group	String	The group or category of the intervention.
given_by_full_name	String	The full name of the personnel who performed the intervention.
given_by_user_id	String	The user ID of the personnel who performed the intervention.
intervention_order	Int	The order number of the intervention within the record, indicating sequence.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Locations

ewa_clean.records_locations: Data filled out in the different types of location tiles (incident, via, start, destination) in EWA for a record.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
unique_id	String	A unique identifier in Analytics generated for each table.
location_id	Int	The unique identifier from EWA for each location.
address_or_place	String	The address or name of the place associated with the location.
zip	String	The ZIP code of the location, if available.
city	String	The city where the location is situated.
municipality	String	The municipality or country where the location is situated.
latitude	String	The latitude coordinate of the location, if available.
longitude	String	The longitude coordinate of the location, if available.
location_name	String	The name of the location.
description	String	A description of the location or its purpose.
address	String	The full address of the location, if available.
location_type	String	The type of location, indicating whether it is an incident, via, start, or destination place.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Miscellaneous Information

ewa_clean.records_miscellaneous_information: Data filled out in the tiles for extra persons, circumstances and transferred from and to in EWA.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
unique_id	String	A unique identifier in Analytics generated for each table.
extra_persons	String	List of any extra persons associated with the record.
assistance	String	Type of assistance provided, if any.
circumstances	String	Any special circumstances noted for the record.
transferred_from	String	Indicates if the record was transferred from another entity.
transferred_to	String	Indicates if the record was transferred to another entity.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Miscellaneous Medical

ewa_clean.records_miscellaneous_medical: Data filled out in the different medical tiles in EWA.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
unique_id	String	A unique identifier in Analytics generated for each table.
energy_assessment	String	Energy assessment details associated with the record.
mechanism_of_injury	String	The mechanism of injury recorded.
safety_equipment	String	Safety equipment involved, if any.
type_of_injury	String	Types of injuries associated with the record.
trauma	String	Indicates whether trauma is recorded in the record.
allergies	String	Allergies recorded for the individual associated with the record.
notes	String	Additional notes related to the record.
chief_complaint_group	String	The group or category of the chief complaint, if recorded.
chief_complaint	String	Specific chief complaint recorded in the record.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Missions

ewa_clean.records_missions: Data from EWA about the mission.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
unique_id	String	A unique identifier in Analytics generated for each table.
emcc_mission_id	String	The mission identifier in the EMCC system.
mission_resource_id	String	The identifier for the resource assigned to the mission.
dispatch_code	String	The dispatch code associated with the mission.
mission_type	String	The type of mission, indicating its purpose or classification.
distance	Int	The distance covered during the mission, if recorded.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records News2

ewa_clean.records_news2: Data filled out in the news2 tile in EWA.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
unique_id	String	A unique identifier in Analytics generated for each table.
examination_guid	String	The GUID for the specific NEWS2 examination instance.
time_stamp	DateTime	The timestamp when the NEWS2 examination was conducted.
has_copd	String	Indicates whether the patient has COPD.
scoring_params_id	Int	The identifier for the scoring parameters used in the NEWS2 examination.
scoring_params_title	String	The title of the scoring parameters used in the NEWS2 examination.
scoring_params_item_id	Int	The identifier for the scoring parameter item in the NEWS2 examination.
scoring_params_item_text	String	The text of the scoring parameter item in the NEWS2 examination.
scoring_params_item_score	Int	The score associated with the scoring parameter item in the NEWS2 examination.
total_score	Int	The total NEWS2 score recorded for the examination.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Oxygen

ewa_clean.records_oxygen: Data filled out in the oxygen tile in EWA.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
unique_id	String	A unique identifier in Analytics generated for each table.
route	String	The method of oxygen administration.
start_time_stamp	DateTime	The timestamp when oxygen administration started.
end_time_stamp	DateTime	The timestamp when oxygen administration ended, if applicable.
quantity	String	The quantity of oxygen administered.
unit	String	The unit of oxygen quantity, typically liters (L).
oxygen_order	Int	The order number of oxygen administration within the record, indicating sequence.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Patients

ewa_clean.records_patients: Data filled out in the patient tile in EWA.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
unique_id	String	A unique identifier in Analytics generated for each table.
patient_id	Int	The unique identifier from EWA for each patient.
full_name	String	The full name of the patient, generated by concatenating first and last names.
date_of_birth	DateTime	The date of birth of the patient.
id_type	Int	Type of identification used.
national_id_number	String	The national identification number for the patient.
unknown_patient_identification_number	String	A temporary ID assigned to unidentified patients, e.g., during mass casualty events.
unknown_patient_identification_type	String	A predefined numeric enum representing the type of temporary patient ID.
unknown_patient_identification_type_name	String	A human-readable name for the temporary patient ID type corresponding to the 'unknown_patient_identification_type' table.
home_address_or_place	String	The home address or place of residence for the patient.
home_zip	Int	The ZIP code of the patient's residence.
home_city	String	The city of the patient's residence.
home_municipality	String	The municipality or country of the patient's residence, if available.
gender	String	Gender of the patient.
extra_text	String	Additional information related to the patient, if available.
weight	Int	The weight of the patient, if recorded.
patient_id_verification_method	String	Method used to verify the patient's identity.
patient_id_verification_level	Int	Level of identity verification conducted.
next_of_kin_relationship	String	The relationship of the next of kin to the patient.
next_of_kin_notification	String	Additional information regarding notification of next of kin.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Personnel

ewa_clean.records_personnel: Data filled out in the personnel tiles in EWA.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
unique_id	String	A unique identifier in Analytics generated for each table.
user_id	String	The unique identifier for the user associated with the personnel.
full_name	String	The full name of the personnel, generated by concatenating first and last names.
type	String	The role or type of the personnel in the record, such as Driver, Treater, etc.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Resources Stations

ewa_clean.records_resources_stations: Data from EWA about the station and the resource at the time when the record was saved.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
unique_id	String	A unique identifier in Analytics generated for each table.
resource_id	Int	The unique identifier from EWA for each resource.
station_id	Int	The identifier of the station to which the resource is linked.
callsign	String	The callsign of the resource, typically representing its operational name.
station_name	String	The identifier for the resource's station.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Retts

ewa_clean.records_retts: Data filled out in the retts tile in EWA.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
unique_id	String	A unique identifier in Analytics generated for each table.
version	String	The version of the RETTS triage system used.
ess_number	Int	Emergency Severity Score (ESS) number for categorizing the severity of the patient's condition.
ess_risk_level	Int	Risk level associated with the ESS number.
contact_reason	String	Reason for contacting emergency services.
symptoms	String	Symptoms presented by the patient at the time of triage.
triages_type	Int	Type of triage process used.
triages_total_risk_level	Int	Overall risk level assessed during the triage process.
triages_time_stamp	DateTime	Timestamp for when the triage assessment was performed.
triages_age	String	Age group of the patient, such as 'adult', 'child', etc.
triages_obstetric_patient	String	Boolean indicating if the patient is obstetric.
triages_heart_rate	String	Patient's heart rate during the triage process.
triages_heart_rate_risk_level	Int	Risk level associated with the patient's heart rate.
triages_gcs	String	Glasgow Coma Scale (GCS) score recorded during the triage.
triages_gcs_risk_level	Int	Risk level associated with the patient's GCS score.
triages_spo2	String	Oxygen saturation (SpO2) level of the patient.
triages_spo2_risk_level	Int	Risk level associated with the patient's SpO2 level.
triages_airways	String	Assessment of the patient's airway status.
triages_airways_risk_level	Int	Risk level associated with the patient's airway status.
triages_temperature	String	Temperature reading taken during the triage.
triages_temperature_risk_level	Int	Risk level associated with the patient's temperature.
triages_respiratory_rate	String	Respiratory rate of the patient.
triages_respiratory_rate_risk_level	Int	Risk level associated with the patient's respiratory rate.
triages_spasms	String	Information on whether spasms are observed in the patient.
triages_spasms_risk_level	Int	Risk level associated with the patient's spasms.
triages_ess_risk_level	Int	ESS risk level recorded for the patient.
triages_systolic_blood_pressure	String	Patient's systolic blood pressure reading during triage.
triages_systolic_blood_pressure_risk_level	Int	Risk level associated with the patient's systolic blood pressure.
triages_diastolic_blood_pressure	String	Patient's diastolic blood pressure reading during triage.
triages_diastolic_blood_pressure_risk_level	Int	Risk level associated with the patient's diastolic blood pressure.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Sats

ewa_clean.records_sats: Data filled out in the sats tile in EWA.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
clinical_signs_patient_age_group	String	The age group of the patient as observed in clinical signs.
clinical_signs_time_stamp	DateTime	Timestamp of when clinical signs were recorded.
clinical_signs_priority_level	Int	Priority level assigned based on clinical signs.
clinical_signs_selections_priority_level	String	Priority level from clinical signs selections.
clinical_signs_selections_priority_type	Int	Type of priority assigned in clinical selections.
clinical_signs_selections_order	Int	Order of clinical signs selections.
clinical_signs_selections_justification_text	String	Justification text for clinical signs selections.
clinical_signs_selections_foot_note	Int	Footnote associated with clinical signs selections.
triage_configuration_id	Int	Unique identifier for the triage configuration.
triage_configuration_version_name	String	Version name of the triage configuration.
triage_configuration_revision	Int	Revision number of the triage configuration.
triage_type	Int	Type of triage conducted.
triage_total_score	Int	Total score from the triage assessment.
triage_is_complete	String	Indicates whether the triage is complete.
triage_time_stamp	DateTime	Timestamp when the triage was completed.
triage_priority_level	Int	Overall priority level from the triage assessment.
triage_tews_selected_params_id	Int	Unique identifier of the selected TEWS parameter.
triage_tews_selected_params_title	String	Title of the selected TEWS parameter.
triage_tews_selected_params_item_id	Int	Identifier of the match in the TEWS parameter for a vital sign.
triage_tews_selected_params_item_text	String	Text of the match in the TEWS parameter for a vital sign.
triage_tews_selected_params_item_score	Int	Score of the match in the TEWS parameter for a vital sign.
senior_healthcare_professionals_discretions_justification	String	Justification provided by senior healthcare professionals for discretions.
senior_healthcare_professionals_discretions_time_stamp	String	Timestamp when senior healthcare professionals provided their discretions.
senior_healthcare_professionals_discretions_priority_level	Int	Priority level assigned by senior healthcare professionals' discretions.
time_stamp	DateTime	Overall timestamp for the SATS assessment.
not_applicable	String	Indicator if SATS is not applicable for the patient.
performed_sats_complete	String	Indicates if SATS assessment was fully performed.
age_selection	String	Age selection for the SATS configuration.
configuration_id	Int	Unique identifier for the SATS configuration.
configuration_version_name	String	Version name of the SATS configuration.
configuration_revision	Int	Revision number of the SATS configuration.
priority_level_total	String	Total priority level calculated in SATS.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Sepsis

ewa_clean.records_sepsis: Data filled out in the sepsis tile in EWA.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
unique_id	String	A unique identifier in Analytics generated for each table.
time_stamp	DateTime	Timestamp of when the sepsis-related data was recorded.
sirs_heart_rate	String	Indicates if the SIRS heart rate criterion is met.
sirs_respiratory_rate	String	Indicates if the SIRS respiratory rate criterion is met.
sirs_temp	String	Indicates if the SIRS temperature criterion is met.
qsofa_respiratory_rate	String	Indicates if the qSOFA respiratory rate criterion is met.
qsofa_systolic_blood_pressure	String	Indicates if the qSOFA systolic blood pressure criterion is met.
qsofa_gcs	String	Indicates if the qSOFA Glasgow Coma Scale criterion is met.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Time

ewa_clean.records_time: Data filled out in the different time tiles in EWA.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
unique_id	String	A unique identifier in Analytics generated for each table.
time_stamp	DateTime	Timestamp of the event.
time_type	String	Type of the timestamp event.
record_status	Int	The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3).
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Records Urgency Levels

ewa_clean.records_urgency_levels: The ewa_clean__records_urgency_levels table contains information about the relationship between records and urgency levels. Each row represents a mapping between a record and its associated urgency level.

Column Name	Data Type	Description
id	String	Unique identifier for each record urgency level mapping.
unique_id	String	A unique identifier in Analytics generated for each table.
urgency_level_id	String	Identifier for the associated urgency level.
record_id	Int	The unique identifier for a record.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Resource Types

ewa_clean.resource_types: This table contains information about resource types, including their names and metadata timestamps.

Column Name	Data Type	Description
id	String	The unique identifier for the resource type.
name	String	The name of the resource type.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Resources

ewa_clean.resources: This table contains information about individual resources, including their type, station association, and metadata timestamps.

Column Name	Data Type	Description
id	Int	The unique identifier for the resource.
name	String	The name of the resource.
station_id	String	The identifier of the station to which the resource is linked.
resource_type_id	String	The identifier for the resource's type, linking to the resource type table.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Retts Priority Levels

ewa_clean.retts_priority_levels: The ewa_clean__retts_priority_levels table contains information about RETTS (Rapid Emergency Triage and Treatment System) priority levels.

Column Name	Data Type	Description
id	Int	The unique identifier from EWA for each retts priority level.
color	String	Color associated with the RETTS priority level.

Sats Priority Levels

ewa_clean.sats_priority_levels: The ewa_clean__sats_priority_levels table contains information about SATS (Severity Assessment Triage System) priority levels.

Column Name	Data Type	Description
id	Int	The unique identifier from EWA for each sats priority level.
color	String	Color associated with the SATS priority level.

Stations

ewa_clean.stations: The ewa_clean__stations table contains details about stations, including related record information and metadata timestamps.

Column Name	Data Type	Description
id	Int	Unique identifier for each station.
unique_id	String	A unique identifier in Analytics generated for each table.
name	String	Name of the Station.
organization_id	String	Reference id for the organization.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Tags

ewa_clean.tags: Data about different hierarchy levels, used for example together with locations.

Column Name	Data Type	Description
id	Int	The unique identifier from EWA for each tag.
unique_id	String	A unique identifier in Analytics generated for each table.
value	String	The value of the tag.
parent_id	String	The parent id for the tag id.
type	String	The type of the tag.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Unknown Patient Id Types

ewa_clean.unknown_patient_id_types: A seeded reference table for mapping internal IDs to the type values for identification systems used to temporarily identify unknown patients. The table contains types like 'NotRelevant', 'HNumber', and 'FHNumber'.

Column Name	Data Type	Description
unique_id	String	A unique identifier generated for each record, combining the type_id and type fields.
type_id	Int	The internal ID representing the unknown patient ID type.
type	String	The name of the unknown patient ID type.

Urgency Levels

ewa_clean.urgency_levels: The ewa_clean__urgency_levels table contains information about urgency levels. Each row represents an urgency level with details about when it was created and updated.

Column Name	Data Type	Description
id	String	Unique identifier for each urgency level.
unique_id	String	A unique identifier in Analytics generated for each table.
name	String	The name of the urgency level in the default language.
name_en_GB	String	The name of the urgency level in British English.
name_da_DK	String	The name of the urgency level in Danish.
name_fr_FR	String	The name of the urgency level in French.
name_de_DE	String	The name of the urgency level in German.
name_nb_NO	String	The name of the urgency level in Norwegian Bokmål.
name_sv_SE	String	The name of the urgency level in Swedish.
color	String	The color code associated with the urgency level.
updated_at	DateTime	Updated at timestamp.
created_at	DateTime	Created at timestamp.
deleted_at	DateTime	Deleted at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.