Core Table Descriptions

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

Note: The Core layer is out in an early release and bigger changes can happen in the future

Dim Form Configurations

ewa_core.dim_form_configurations: Dimension table containing metadata about form configurations.

Column Name	Data Type	Description
sk_form	String	Surrogate key for the form dimension.
form_name	String	Name of the form as defined by the user.
form_state	Int	State of the form (0 = non-completed, 1 = completed).
metadata_inserted_at	DateTime	Timestamp for when the row was first inserted.
metadata_updated_at	DateTime	Timestamp for the last update of the row.

Dim Form Sections

ewa_core.dim_form_sections: Dimension table for form sections, linked to dim_form.

Column Name	Data Type	Description
sk_section	String	Surrogate key for the section dimension.
section_id	String	Unique identifier for the section, used in form responses.
section_title	String	Title or heading of the section.
section_description	String	Optional description or help text for the section.
metadata_inserted_at	DateTime	Timestamp for when the row was first inserted.
metadata_updated_at	DateTime	Timestamp for the last update of the row.

Dim Form Elements

ewa_core.dim_form_elements: Dimension table for form elements/questions.

Column Name	Data Type	Description
sk_element	String	Surrogate key for the element dimension.
section_id	String	Foreign key reference to the section the element belongs to.
element_id	String	Unique identifier for the element, used in form responses.
element_field_type	String	Type of the element (e.g., text input, dropdown, checkbox).
element_label	String	Label shown to the user for the element/question.
element_description	String	Optional description or help text for the element.
metadata_inserted_at	DateTime	Timestamp for when the row was first inserted.
metadata_updated_at	DateTime	Timestamp for the last update of the row.

Dim Form Options

ewa_core.dim_form_options: Dimension table for selectable options within form elements.

Column Name	Data Type	Description
sk_option	String	Surrogate key for the option dimension.
section_id	String	Key reference to the section containing the element.
option_id	String	Key reference to the option.
element_id	String	Key reference to the element the option belongs to.
option_value	String	Display value shown to the user (e.g., "Yes", "No").
option_score	Int	Numeric score associated with the option, used for calculations.
metadata_inserted_at	DateTime	Timestamp for when the row was first inserted.
metadata_updated_at	DateTime	Timestamp for the last update of the row.

Fact Form Responses

ewa_core.fact_form_responses: Fact table capturing individual responses to form elements.

Column Name	Data Type	Description
sk_response	String	Surrogate key for this response record.
sk_form	String	Foreign key reference to the form configuration.
sk_section	String	Foreign key reference to the section containing the element.
sk_element	String	Foreign key reference to the question or form element.
sk_option	String	Foreign key reference to the selected option (if applicable).
response_id	String	Unique ID representing a specific form response.
form_id	String	Foreign key reference to the form being responded to.
section_id	String	Foreign key reference to the section containing the element.
element_id	String	Foreign key reference to the question or form element.
option_id	String	Foreign key reference to the selected option (if applicable).
element_response_value	String	The raw value entered or selected by the user.
element_response_type	String	The input type of the element (e.g., text, number, multiple_choice).
response_score	Int	Score calculated for this response (option-based or parsed from input).
record_id	Int	Foreign key to the record/context where the form was submitted.
metadata_inserted_at	DateTime	Timestamp for when the row was first inserted.
metadata_updated_at	DateTime	Timestamp for the last update of the row.

Bridge Accompanying Personnel

ewa_core.bridge_accompanying_personnel: Bridge table used to connect fact_records together with dim_accompanying_personnel.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
sk_accompanying_personnel	String	Surrogate key generated for each unique accompanying personnel entry.
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.

Bridge Assistance

ewa_core.bridge_assistance: Bridge table used to connect fact_records together with dim_assistance.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
sk_assistance	String	Surrogate key generated for each unique assistance entry.
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.

Bridge Circumstances

ewa_core.bridge_circumstances: Bridge table used to connect fact_records together with dim_circumstances.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
sk_circumstance	String	Surrogate key generated for each unique circumstance entry.
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.

Bridge Drugs

ewa_core.bridge_drugs: Bridge table used to connect fact_records together with dim_drugs and dim_personnel.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
sk_drug	String	Surrogate key generated for each unique drug entry.
dose	String	The dose of the drug administered.
unit	String	The unit of the drug dose, such as mg, stk, etc.
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.

Bridge Interventions

ewa_core.bridge_interventions: Bridge table used to connect fact_records together with dim_interventions and dim_personnel.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
sk_intervention	String	Surrogate key generated for each unique intervention based on name and intervention group.
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.

Bridge Locations

ewa_core.bridge_locations: Bridge table used to connect fact_records together with dim_locations and dim_location_types.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
sk_location	String	Surrogate key generated for each unique location based on location GUID.
sk_location_type	String	Surrogate key generated for each unique location type (incident, via, start, destination).
zip	String	The ZIP code of the location, if available.
city	String	The city 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.
description	String	A description of the location or its purpose.
address	String	The full address of the location, if available.
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.

Bridge Personnel

ewa_core.bridge_personnel: Bridge table used to connect fact_records together with dim_personnel and dim_personnel_roles.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
sk_personnel_role	String	Surrogate key generated for each unique personnel role. Combines crew role type and resource type for configurable crew roles, or just crew role type for standard personnel records.
sk_personnel	String	Surrogate key generated for each unique personnel member based on user ID and full name.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Bridge Times

ewa_core.bridge_times: Bridge table used to connect fact_records together with dim_time_types.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
time_id	DateTime	The actual timestamp when the event occurred.
sk_time_type	String	Surrogate key generated for each unique time type (e.g., arrival, departure, treatment start).
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.

Dim Accompanying Personnel

ewa_core.dim_accompanying_personnel: Dimension table containing unique accompanying personnel entries.

Column Name	Data Type	Description
sk_accompanying_personnel	String	Surrogate key generated for each unique accompanying personnel entry.
accompanying_personnel	String	The name or identifier of the accompanying personnel.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Assistance

ewa_core.dim_assistance: Dimension table containing unique assistance entries.

Column Name	Data Type	Description
sk_assistance	String	Surrogate key generated for each unique assistance entry.
assistance	String	The type of assistance provided.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Chief Complaints

ewa_core.dim_chief_complaints: Dimension table containing unique chief complaint entries.

Column Name	Data Type	Description
sk_chief_complaint	String	Surrogate key generated for each unique chief complaint based on group and complaint.
sk_chief_complaint_group	String	Surrogate key generated for each unique chief complaint group.
chief_complaint_group	String	The group or category of the chief complaint.
chief_complaint	String	Specific chief complaint recorded in the record.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Circumstances

ewa_core.dim_circumstances: Dimension table containing unique circumstance entries.

Column Name	Data Type	Description
sk_circumstance	String	Surrogate key generated for each unique circumstance entry.
circumstance	String	The specific circumstance recorded for the medical record.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Contagions

ewa_core.dim_contagions: Dimension table containing unique contagion risk entries.

Column Name	Data Type	Description
sk_contagion	String	Surrogate key generated for each unique contagion risk entry.
risk_text	String	Description text for the contagion risk.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Drugs

ewa_core.dim_drugs: Dimension table containing unique drug entries.

Column Name	Data Type	Description
sk_drug	String	Surrogate key generated for each unique drug entry.
drug_name	String	The name of the drug administered.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Interventions

ewa_core.dim_interventions: Dimension table containing unique intervention entries.

Column Name	Data Type	Description
sk_intervention	String	Surrogate key generated for each unique intervention based on name and intervention group.
sk_intervention_group	String	Surrogate key generated for each unique intervention group.
intervention	String	The name of the intervention performed.
intervention_group	String	The group or category of the intervention.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Location Types

ewa_core.dim_location_types: Dimension table containing unique location type entries.

Column Name	Data Type	Description
sk_location_type	String	Surrogate key generated for each unique location type.
location_type	String	The type of location, indicating whether it is an incident, via, start, or destination place.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Locations

ewa_core.dim_locations: Dimension table containing unique location entries.

Column Name	Data Type	Description
sk_location	String	Surrogate key generated for each unique location based on location GUID.
county_id	Int	The unique identifier for the county where the location is situated.
county_name	String	The name of the county where the location is situated.
municipality_id	Int	The unique identifier for the municipality where the location is situated.
municipality_name	String	The name of the municipality where the location is situated.
location_group_id	Int	The unique identifier for the location group.
location_group_name	String	The name of the location group.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Mission Types

ewa_core.dim_mission_types: Dimension table containing unique mission type entries.

Column Name	Data Type	Description
sk_mission_type	String	Surrogate key generated for each unique mission type.
mission_type_id	String	The predecessor mission type id, if applicable.
mission_type_name	String	The name of the configurable mission type.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Organizations

ewa_core.dim_organizations: Dimension table containing unique organization entries.

Column Name	Data Type	Description
sk_organization	String	Surrogate key generated for each unique organization.
organization_id	Int	Unique identifier from EWA for each organization.
organization_name	String	Name of 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.

Dim Oxygen

ewa_core.dim_oxygen: Dimension table containing unique oxygen administration entries.

Column Name	Data Type	Description
sk_oxygen	String	Surrogate key generated for each unique combination of oxygen route, quantity, and unit.
route	String	The method of oxygen administration.
quantity	String	The quantity of oxygen administered.
unit	String	The unit of oxygen quantity, typically liters (L).
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Patients

ewa_core.dim_patients: Dimension table containing unique patient entries.

Column Name	Data Type	Description
sk_patient	String	Surrogate key for each unique patient entry, using the unique_id from the source table.
record_id	Int	The unique identifier for a record.
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_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.
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.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Personnel Roles

ewa_core.dim_personnel_roles: Dimension table containing unique personnel role entries.

Column Name	Data Type	Description
sk_personnel_role	String	Surrogate key generated for each unique personnel role.
sk_resource_type	String	Surrogate key generated for each unique resource type.
personnel_role	String	The name of the personnel role or crew role type.
resource_type_id	String	The identifier for the resource type associated with the crew role.
resource_type_name	String	The name of the resource type.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Personnel

ewa_core.dim_personnel: Dimension table containing unique personnel entries.

Column Name	Data Type	Description
sk_personnel	String	Surrogate key generated for each unique personnel member based on user ID and full name.
user_id	String	The unique identifier for the user associated with the personnel.
full_name	String	The full name of the personnel member.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Resource Types

ewa_core.dim_resource_types: Dimension table containing unique resource type entries.

Column Name	Data Type	Description
sk_resource_type	String	Surrogate key generated for each unique resource type.
resource_type_id	String	The unique identifier for the resource type.
resource_type_name	String	The name of the resource type.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Resources

ewa_core.dim_resources: Dimension table containing unique resource entries.

Column Name	Data Type	Description
sk_resource	String	Surrogate key generated for each unique resource.
sk_resource_type	String	Surrogate key for the resource type associated with this resource.
resource_id	Int	The unique identifier for the resource.
resource_name	String	The name of the resource.
station_id	Int	The identifier of the station to which the resource is linked.
station_name	String	The name of the station to which the resource is linked.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Retts Priority Levels

ewa_core.dim_retts_priority_levels: Dimension table containing unique RETTS priority level entries.

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

Dim Sats Priority Levels

ewa_core.dim_sats_priority_levels: Dimension table containing unique SATS priority level entries.

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

Dim Stations

ewa_core.dim_stations: Dimension table containing unique station entries.

Column Name	Data Type	Description
sk_station	String	Surrogate key generated for each unique station.
organization_id	Int	The identifier for the organization that owns the station.
station_id	Int	Unique identifier for each station.
station_name	String	Name of the station.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Time Types

ewa_core.dim_time_types: Dimension table containing unique time type entries.

Column Name	Data Type	Description
sk_time_type	String	Surrogate key generated for each unique time type.
time_type	String	Type of the timestamp event.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Times

ewa_core.dim_times: Dimension table containing unique time entries with date/time attributes.

Column Name	Data Type	Description
time_id	DateTime	The timestamp converted to UTC for consistency.
year	Int	Year extracted from the timestamp.
month	Int	Month extracted from the timestamp.
day	Int	Day extracted from the timestamp.
day_of_the_week	Int	Day of the week extracted from the timestamp.
hour_of_the_day	Int	Hour of the day extracted from the timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Transferred Locations

ewa_core.dim_transferred_locations: Dimension table containing unique transferred location entries.

Column Name	Data Type	Description
sk_transferred_location	String	Surrogate key generated for each unique transferred location.
transferred_location_name	String	The name of the location where the patient was transferred from or to.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Translations

ewa_core.dim_translations: Dimension table containing multilingual translations for various entities.

Column Name	Data Type	Description
id	Int	Auto-generated sequential identifier for each translation entry.
entity_type	String	Type of entity being translated (urgency_levels, mission_types).
sk_entity_id	String	Surrogate key of the entity being translated.
field_name	String	Name of the field being translated.
language_code	String	Language code for the translation (en-GB, da-DK, fr-FR, etc.).
translated_value	String	The translated text value in the specified language.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Dim Urgency Levels

ewa_core.dim_urgency_levels: Dimension table containing unique urgency level entries.

Column Name	Data Type	Description
sk_urgency_level	String	Surrogate key generated for each unique urgency level based on ID and name.
urgency_id	String	Unique identifier for each urgency level.
urgency_level_name	String	The name of the urgency level in the default language.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Fact Records

ewa_core.fact_records: Central fact table containing medical emergency records with foreign keys to all related dimensions.

Column Name	Data Type	Description
record_id	Int	The unique identifier for a record.
start_time_stamp	DateTime	The primary timestamp for the record, using ambulance alerted time when available, otherwise falling back to record created timestamp.
sk_resource	String	Surrogate key linking to the resource dimension.
sk_resource_type	String	Surrogate key linking to the resource type dimension.
sk_station	String	Surrogate key linking to the station dimension.
sk_organization	String	Surrogate key linking to the organization dimension.
sk_mission_type	String	Surrogate key linking to the mission type dimension.
sk_oxygen	String	Surrogate key linking to the oxygen dimension.
sk_contagion	String	Surrogate key linking to the contagion dimension.
sk_chief_complaint	String	Surrogate key linking to the chief complaint dimension.
sk_urgency_level	String	Surrogate key linking to the urgency level dimension.
sk_retts_priority_level	String	Surrogate key linking to the RETTS priority level dimension.
sk_sats_priority_level	String	Surrogate key linking to the SATS priority level dimension.
sk_transferred_from_location	String	Surrogate key linking to the transferred from location dimension.
sk_transferred_to_location	String	Surrogate key linking to the transferred to location dimension.
sk_patient	String	Surrogate key linking to the patient dimension.
record_updated_at	DateTime	The timestamp when the record was last updated in EWA.
created_at	DateTime	Created at timestamp.
metadata_inserted_at	DateTime	Row inserted at timestamp.
metadata_updated_at	DateTime	Row updated at timestamp.

Fact Missions

ewa_core.fact_missions: Fact table containing mission-specific information for medical emergency records.

Column Name	Data Type	Description
sk_mission	String	Surrogate key for the mission.
record_id	Int	The unique identifier for a record.
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.
distance	Int	The distance covered during the mission, if recorded.
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.

Fact Triages

ewa_core.fact_triages: Fact table containing triage assessment scores for medical emergency records.

Column Name	Data Type	Description
sk_triage	String	Surrogate key for the triage.
record_id	Int	The unique identifier for a record.
sats_total_score	String	The total SATS (Severity Assessment Triage System) score for the patient.
news_total_score	Int	The total NEWS2 (National Early Warning Score 2) for the patient.
gcs_total_score	Int	The total GCS (Glasgow Coma Scale) score calculated by summing motor response, verbal response, and eye opening scores.
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.