v2.0.0 Table descriptions
(Last updated: 2025-09-26, Created: 2025-06-27)
This documentation will include the documentation for v2.0.0
ewa_clean.form_configurations
This table contains information about the content of a form and how it is configured
| Column Name | Description |
|---|---|
| unique_id | Unique id for this table |
| form_id | Form Configuration Id from source, unique id for each form |
| form_name | Name of the form |
| form_state | State of the form, 0 = draft, 1 = published |
| updated_at | Updated at timestamp |
| created_at | Created at timestamp |
| deleted_at | Deleted at timestamp |
| metadata_inserted_at | Row inserted at timestamp |
| metadata_updated_at | Row updated at timestamp |
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 | Description |
|---|---|
| unique_id | Unique id for this table |
| section_id | Form Configuration Section Id from source, unique id for each section in a form |
| form_id | Form Configuration Id from source, unique id for each form |
| section_title | Title of the section |
| section_description | Description of the section |
| updated_at | Updated at timestamp |
| created_at | Created at timestamp |
| deleted_at | Deleted at timestamp |
| metadata_inserted_at | Row inserted at timestamp |
| metadata_updated_at | Row updated at timestamp |
ewa_clean.form_configuration_elements
This table contains information about elements and element options in a form section
| Column Name | Description |
|---|---|
| unique_id | Unique id for this table |
| element_id | Form Configuration Element Id from source, unique id for each element in a form section |
| section_id | Form Configuration Section Id from source, unique id for each section in a form |
| option_id | Form Configuration Option Id from source, unique id for each option in a form element |
| element_field_type | Field type of the element |
| element_label | Label of the element |
| element_description | Description of the element |
| option_value | Value of the option |
| option_score | Score assigned to the option |
| updated_at | Updated at timestamp |
| created_at | Created at timestamp |
| deleted_at | Deleted at timestamp |
| metadata_inserted_at | Row inserted at timestamp |
| metadata_updated_at | Row updated at timestamp |
ewa_clean.form_responses
This table contains information about responses to a form
| Column Name | Description |
|---|---|
| unique_id | Unique id for this table |
| response_id | Form Response Id from source, unique id for each response to a form |
| form_id | Form Configuration Id from source, unique id for each form |
| response_state | State of the response, 0 = started, 1 = finished |
| updated_at | Updated at timestamp |
| created_at | Created at timestamp |
| deleted_at | Deleted at timestamp |
| metadata_inserted_at | Row inserted at timestamp |
| metadata_updated_at | Row updated at timestamp |
ewa_clean.form_response_elements
This table contains information about responses to elements in a form section
| Column Name | Description |
|---|---|
| unique_id | Unique id for this table |
| response_section_id | Form Response Section Id from source, unique id for each response to a section in a form |
| section_id | Form Configuration Section Id from source, unique id for each section in a form |
| element_id | Form Configuration Element Id from source, unique id for each element in a form section |
| option_id | Form Configuration Option Id from source, unique id for each option in a form element |
| element_response_value | Response value provided for the element |
| element_response_type | Response type provided for the element |
| updated_at | Updated at timestamp |
| created_at | Created at timestamp |
| deleted_at | Deleted at timestamp |
| metadata_inserted_at | Row inserted at timestamp |
| metadata_updated_at | Row updated at timestamp |
ewa_clean.records_forms
Bridge table for forms records from performed checklists
| Column Name | Description |
|---|---|
| unique_id | Unique id for this table |
| response_id | Form Response Id from source, unique id for each response to a form |
| record_id | Record Id from source, unique id for each record. Used to connect to records |
| updated_at | Updated at timestamp |
| created_at | Created at timestamp |
| deleted_at | Deleted at timestamp |
| metadata_inserted_at | Row inserted at timestamp |
| metadata_updated_at | Row updated at timestamp |
ewa_clean.records
This main table connects the other tables in the model, containing essential record information such as model version, status, and timestamps.
| Column Name | Description |
|---|---|
| id | The unique identifier from EWA for each record. |
| unique_id | A unique identifier in Analytics generated for each table |
| model_version | The version of the model associated with the record. Example: '2'. |
| status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| en_GB | The status description in British English. Example: 'Deleted'. |
| updated_at | The timestamp when this entry was last updated in EWA |
| created_at | The timestamp when this entry was created in EWA |
| deleted_at | The timestamp when this entry was deleted in EWA, if applicable |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_billable_information
Data filled out in the Billing tile in EWA
| Column Name | Description |
|---|---|
| record_id | The unique identifier for a record |
| unique_id | A unique identifier in Analytics generated for each table |
| attachment_ids | Comma-separated list of attachment IDs related to the billable information. |
| insurance_company | The name of the insurance company associated with the record's billable information. |
| insurance_policy_number | The policy number for the insurance associated with the record. |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_configurable_mission_types
The bridge between configurable mission types and associated records.
| Column Name | Description |
|---|---|
| id | The unique identifier from EWA for each configurable mission type |
| unique_id | A unique identifier in Analytics generated for each table |
| configurable_mission_type_id | The identifier linking to the specific configurable mission type associated with the record. |
| record_id | The unique identifier for a record |
| updated_at | The timestamp when this entry was last updated in EWA |
| created_at | The timestamp when this entry was created in EWA |
| deleted_at | The timestamp when this entry was deleted in EWA, if applicable |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.configurable_mission_types
This model unpacks and transforms data related to configurable mission types, with multilingual support for names.
| Column Name | Description |
|---|---|
| id | The unique identifier from EWA for each configurable mission type. |
| unique_id | A unique identifier in Analytics generated for each table |
| name | The default name of the configurable mission type. |
| name_en_US | The name of the mission type in US English (en-US). |
| name_en_GB | The name of the mission type in British English (en-GB). |
| name_da_DK | The name of the mission type in Danish (da-DK). |
| name_fr_FR | The name of the mission type in French (fr-FR). |
| name_de_DE | The name of the mission type in German (de-DE). |
| name_nb_NO | The name of the mission type in Norwegian (nb-NO). |
| name_sv_SE | The name of the mission type in Swedish (sv-SE). |
| priority_level | The priority level associated with the mission type. |
| is_system_mission_type | Indicates whether the mission type is a system-defined type. |
| predecessor | The predecessor mission type id, if applicable. |
| updated_at | The timestamp when this entry was last updated in EWA |
| created_at | The timestamp when this entry was created in EWA |
| deleted_at | The timestamp when this entry was deleted in EWA, if applicable |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_contagion
Data filled out in the contagion tile in EWA
| Column Name | Description |
|---|---|
| record_id | The unique identifier for a record |
| unique_id | A unique identifier in Analytics generated for each table |
| contagion | Contagion true or false, as extracted from JSON data. |
| risk_id | The unique identifier from EWA for each contagion risk. |
| risk_text | Description text for the contagion risk. |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_drugs
Data filled out in the drug tile in EWA
| Column Name | Description |
|---|---|
| record_id | The unique identifier for a record |
| unique_id | A unique identifier in Analytics generated for each table |
| name | The name of the drug administered. Example: 'EMLA plaster'. |
| time_stamp | The timestamp when the drug was administered. Example: '2023-02-20 12:17:00.0000000'. |
| dose | The dose of the drug administered. Example: '2'. |
| unit | The unit of the drug dose, such as mg, stk, etc. Example: 'stk'. |
| route | The route or form of administration for the drug. Example: 'Transc.'. |
| drugs_order | The order number of the drug within the record, indicating sequence. Example: '1'. |
| given_by_type | The type or role of the person who administered the drug. Example: 'Active'. |
| given_by_full_name | The full name of the personnel who administered the drug. Example: 'Mykke Plasme'. |
| given_by_user_id | The user ID of the personnel who administered the drug. Example: 'mykke.plasme@bliksundhf.no'. |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_gcs
Data filled out in the gcs tile in EWA
| Column Name | Description |
|---|---|
| record_id | The unique identifier for a record |
| unique_id | A unique identifier in Analytics generated for each table |
| time_stamp | The timestamp when the GCS score was recorded. Example: '2023-12-06 06:01:00.0000000'. |
| patient_type | The type of patient associated with the GCS entry, as an integer. Example: '0'. |
| type | The type of GCS response (e.g., motor, verbal, or eye opening). Example: 'verbal_response'. |
| description | Description of the GCS response type. Example: 'Orientert'. |
| score | The score associated with the GCS response. Example: '5'. |
| gcs_order | The order number of the GCS entry within the record, indicating sequence. Example: '1'. |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_infusions
Data filled out in the infusion tile in EWA
| Column Name | Description |
|---|---|
| record_id | The unique identifier for a record |
| unique_id | A unique identifier in Analytics generated for each table |
| start_time_stamp | The timestamp when the infusion started. Example: '2022-07-21 05:53:00.0000000'. |
| end_time_stamp | The timestamp when the infusion ended. Example: '2022-07-21 06:25:00.0000000'. |
| amount | The amount administered during the infusion. Example: '20'. |
| unit | The unit of the infusion amount, such as ml or mg. Example: 'ml'. |
| infusion_order | The order number of the infusion within the record, indicating sequence. Example: '1'. |
| given_by_full_name | The full name of the personnel who administered the infusion. Example: 'Mykke Plasme'. |
| given_by_user_id | The user ID of the personnel who administered the infusion. Example: 'mykke.plasme@bliksundhf.no'. |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_interventions
Data filled out in the intervention tile in EWA
| Column Name | Description |
|---|---|
| record_id | The unique identifier for a record |
| unique_id | A unique identifier in Analytics generated for each table |
| name | The name of the intervention performed. Example: 'Thorakal trykkavlastning'. |
| time_stamp | The timestamp when the intervention was performed. Example: '2023-12-07 08:41:00.0000000'. |
| intervention_group | The group or category of the intervention. Example: 'Skader'. |
| given_by_full_name | The full name of the personnel who performed the intervention. Example: 'Mykke Plasme'. |
| given_by_user_id | The user ID of the personnel who performed the intervention. Example: 'mykke.plasme@bliksundhf.no'. |
| intervention_order | The order number of the intervention within the record, indicating sequence. Example: '7'. |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
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 | Description |
|---|---|
| record_id | The unique identifier for a record |
| unique_id | A unique identifier in Analytics generated for each table |
| location_id | The unique identifier from EWA for each location. |
| address_or_place | The address or name of the place associated with the location. Example: 'Grimstad'. |
| zip | The ZIP code of the location, if available. Example: '4887'. |
| city | The city where the location is situated. Example: 'Grimstad'. |
| municipality | The municipality or country where the location is situated. Example: 'Evje og Hornnes'. |
| latitude | The latitude coordinate of the location, if available. Example: '58.3456'. |
| longitude | The longitude coordinate of the location, if available. Example: '8.1234'. |
| location_name | The name of the location. Example: 'Ambulanse Grimstad'. |
| description | A description of the location or its purpose. Example: 'Ambulanse Grimstad, flere etapper'. |
| address | The full address of the location, if available. |
| location_type | The type of location, indicating whether it is an incident, via, start, or destination place. Example: 'destination_place'. |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_miscellaneous_information
Data filled out in the tiles for extra persons, circumstances and transferred from and to in EWA
| Column Name | Description |
|---|---|
| record_id | The unique identifier for a record |
| unique_id | A unique identifier in Analytics generated for each table |
| extra_persons | List of any extra persons associated with the record. Example: 'Ingen'. |
| assistance | Type of assistance provided, if any. Example: 'Ingen'. |
| circumstances | Any special circumstances noted for the record. Example: 'Ingen spesielle omstendigheter'. |
| transferred_from | Indicates if the record was transferred from another entity. Example: 'Nei'. |
| transferred_to | Indicates if the record was transferred to another entity. Example: 'Nei'. |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_miscellaneous_medical
Data filled out in the different medical tiles in EWA
| Column Name | Description |
|---|---|
| record_id | The unique identifier for a record |
| unique_id | A unique identifier in Analytics generated for each table |
| energy_assessment | Energy assessment details associated with the record. Example: 'Fall > 3m (barn)'. |
| mechanism_of_injury | The mechanism of injury recorded. Example: 'Fly'. |
| safety_equipment | Safety equipment involved, if any. Example: 'Ingen kjent'. |
| type_of_injury | Types of injuries associated with the record. Example: 'Fall'. |
| trauma | Indicates whether trauma is recorded in the record. Example: 'Ja'. |
| allergies | Allergies recorded for the individual associated with the record. Example: 'Kjent for: asa'. |
| notes | Additional notes related to the record. Example: 'Oppdraget er feilsendt fra AMK.'. |
| chief_complaint_group | The group or category of the chief complaint, if recorded. Example: 'Kirurgisk - Annen ulykke'. |
| chief_complaint | Specific chief complaint recorded in the record. Example: 'Hypotermi'. |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_missions
Data from EWA about the mission
| Column Name | Description |
|---|---|
| record_id | The unique identifier for a record |
| unique_id | A unique identifier in Analytics generated for each table |
| emcc_mission_id | The mission identifier in the EMCC system |
| mission_resource_id | The identifier for the resource assigned to the mission |
| dispatch_code | The dispatch code associated with the mission. |
| mission_type | The type of mission, indicating its purpose or classification. Example: 'Aborted'. |
| distance | The distance covered during the mission, if recorded. Example: '16'. |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_news2
Data filled out in the news2 tile in EWA
| Column Name | Description |
|---|---|
| record_id | The unique identifier for a record |
| unique_id | A unique identifier in Analytics generated for each table |
| examination_guid | The GUID for the specific NEWS2 examination instance. Example: '37270af3-7a7d-4bd2-b112-cc896937ae80'. |
| time_stamp | The timestamp when the NEWS2 examination was conducted. Example: '2022-04-27 10:05:00.0000000'. |
| has_copd | Indicates whether the patient has COPD. Example: 'false'. |
| scoring_params_id | The identifier for the scoring parameters used in the NEWS2 examination. Example: '1'. |
| scoring_params_title | The title of the scoring parameters used in the NEWS2 examination. Example: 'Respirasjonsfrekvens (pr. min)'. |
| scoring_params_item_id | The identifier for the scoring parameter item in the NEWS2 examination. Example: '4'. |
| scoring_params_item_text | The text of the scoring parameter item in the NEWS2 examination. Example: '21-24'. |
| scoring_params_item_score | The score associated with the scoring parameter item in the NEWS2 examination. Example: '2'. |
| total_score | The total NEWS2 score recorded for the examination. Example: '8'. |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_oxygen
Data filled out in the oxygen tile in EWA
| Column Name | Description |
|---|---|
| record_id | The unique identifier for a record |
| unique_id | A unique identifier in Analytics generated for each table |
| route | The method of oxygen administration. Example: 'Maske med reservoir'. |
| start_time_stamp | The timestamp when oxygen administration started. Example: '2024-06-05 11:08:00.0000000'. |
| end_time_stamp | The timestamp when oxygen administration ended, if applicable. Example: '2023-07-25 12:49:00.0000000'. |
| quantity | The quantity of oxygen administered. Example: '8'. |
| unit | The unit of oxygen quantity, typically liters (L). Example: 'L'. |
| oxygen_order | The order number of oxygen administration within the record, indicating sequence. Example: '1'. |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_patients
Data filled out in the patient tile in EWA
| Column Name | Description |
|---|---|
| record_id | The unique identifier for a record |
| unique_id | A unique identifier in Analytics generated for each table |
| id | The unique identifier from EWA for each patient. |
| full_name | The full name of the patient, generated by concatenating first and last names. Example: 'Line Danner'. |
| date_of_birth | The date of birth of the patient. Example: '1969-11-13 00:00:00.0000000'. |
| id_type | Type of identification used. Example: '1' (ID card). |
| national_id_number | The national identification number for the patient. Example: '1311600216'. |
| unknown_patient_identification_number | A temporary ID assigned to unidentified patients, e.g., during mass casualty events. Example: '11100000005'. |
| unknown_patient_identification_type | A predefined numeric enum representing the type of temporary patient ID. Values: -1 = NotRelevant, 0 = HNumber, 1 = FHNumber. |
| unknown_patient_identification_type_name | A human-readable name for the temporary patient ID type corresponding to the 'unknown_patient_identification_type' table. Examples: 'NotRelevant', 'HNumber', 'FHNumber'. |
| home_address_or_place | The home address or place of residence for the patient. Example: 'Numedalsveien 52, 3602 Kongsberg'. |
| home_house_number | The house number of the patient's residence. Example: '25a'. |
| home_zip | The ZIP code of the patient's residence. Example: '3602'. |
| home_city | The city of the patient's residence. Example: 'Kongsberg'. |
| home_municipality | The municipality or country of the patient's residence, if available. |
| gender | Gender of the patient. Example: 'F' for female. |
| extra_text | Additional information related to the patient, if available. |
| weight | The weight of the patient, if recorded. Example: '74'. |
| patient_id_verification_method | Method used to verify the patient's identity. Example: 'Fødselsnummer angitt av pasienten'. |
| patient_id_verification_level | Level of identity verification conducted. Example: '1' for basic verification. |
| next_of_kin_relationship | The relationship of the next of kin to the patient. Example: 'Kjæreste'. |
| next_of_kin_notification | Additional information regarding notification of next of kin. Example: 'Er melder'. |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_personnel
Data filled out in the personnel tiles in EWA
| Column Name | Description |
|---|---|
| record_id | The unique identifier for a record |
| unique_id | A unique identifier in Analytics generated for each table |
| user_id | The unique identifier for the user associated with the personnel. Example: 'anders.k.egge@bliksund.no'. |
| full_name | The full name of the personnel, generated by concatenating first and last names. Example: 'Anders Kirste Egge'. |
| type | The role or type of the personnel in the record, such as Driver, Treater, etc. Example: 'Treater'. |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.pr_crewroles
This model extracts and transforms crew roles data, including role names, resource types, and timestamps.
| Column Name | Description |
|---|---|
| id | The unique identifier from EWA for the crew role. |
| unique_id | A unique identifier in Analytics generated for each table |
| resource_type_id | The identifier for the resource type associated with the crew role. Example: '450b6b9a-c55f-4704-89e6-ffd55d607adb'. |
| name | The name of the crew role. Example: 'Redningsmann'. |
| updated_at | The timestamp when this entry was last updated in EWA |
| created_at | The timestamp when this entry was created in EWA |
| deleted_at | The timestamp when this entry was deleted in EWA, if applicable |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
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 | Description |
|---|---|
| id | The unique identifier from EWA for the medical record crew entry. |
| unique_id | A unique identifier in Analytics generated for each table |
| record_id | The unique identifier for a record |
| crewrole_id | The identifier for the crew role associated with this medical record crew entry, linking to the configurable crew roles. Example: '36bff978-15c0-4e3c-a41b-e73f604c7be8'. |
| user_id | The unique identifier for the user (crew member) linked to this record. Example: '2A02AFB8-AA3B-4DAA-A8BE-D9B86FB20B9A'. |
| updated_at | The timestamp when this entry was last updated in EWA |
| created_at | The timestamp when this entry was created in EWA |
| deleted_at | The timestamp when this entry was deleted in EWA, if applicable |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.pr_users
This model contains user information including email, full name, and metadata for tracking user updates and deletions.
| Column Name | Description |
|---|---|
| id | The unique identifier from EWA for each user. |
| unique_id | A unique identifier in Analytics generated for each table |
| user_id | The user information used as the user identifier. Depends on the AD configuration, but it is usually the email. Example: 'eric.sundet@hemit.no'. |
| full_name | The full name of the user. Example: 'Eric Sundet'. |
| The email address of the user. Example: 'maren.ronneseth@docs.com'. | |
| updated_at | The timestamp when this entry was last updated in EWA |
| created_at | The timestamp when this entry was created in EWA |
| deleted_at | The timestamp when this entry was deleted in EWA, if applicable |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_resources_stations
Data from EWA about the station and the resource at the time when the record was saved
| Column Name | Description |
|---|---|
| record_id | The unique identifier for a record |
| unique_id | A unique identifier in Analytics generated for each table |
| id | The unique identifier from EWA for each resource. |
| station_id | The identifier of the station to which the resource is linked. Example: '1'. |
| callsign | The callsign of the resource, typically representing its operational name. Example: 'Maneevannan'. |
| station_name | The identifier for the resource's station. Example: 'Nannestad'. |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_retts
Data filled out in the retts tile in EWA
| Column Name | Description |
|---|---|
| record_id | The unique identifier for a record |
| unique_id | A unique identifier in Analytics generated for each table |
| version | The version of the RETTS triage system used. Example: '2024' or '2021' |
| ess_number | Emergency Severity Score (ESS) number for categorizing the severity of the patient's condition. Example: '5' |
| ess_risk_level | Risk level associated with the ESS number. Example: '2' |
| contact_reason | Reason for contacting emergency services. Example: 'Brystsmerter / smerter i brystkassen' |
| symptoms | Symptoms presented by the patient at the time of triage. Example: 'ST-heving på EKG (STEMI)' |
| triages_type | Type of triage process used. Example: '1' |
| triages_total_risk_level | Overall risk level assessed during the triage process. Example: '1' |
| triages_time_stamp | Timestamp for when the triage assessment was performed. Example: '2024-06-05 13:09:00.0001107' |
| triages_age | Age group of the patient, such as 'adult', 'child', etc. Example: 'adult' or '1_year' |
| triages_obstetric_patient | Boolean indicating if the patient is obstetric. Example: 'false' |
| triages_heart_rate | Patient's heart rate during the triage process. Example: 'HF/puls 50 - 110 /min' |
| triages_heart_rate_risk_level | Risk level associated with the patient's heart rate. Example: '4' |
| triages_gcs | Glasgow Coma Scale (GCS) score recorded during the triage. Example: 'GCS = 15' |
| triages_gcs_risk_level | Risk level associated with the patient's GCS score. Example: '4' |
| triages_spo2 | Oxygen saturation (SpO2) level of the patient. Example: 'SpO2 med O2 93 - 100 %' |
| triages_spo2_risk_level | Risk level associated with the patient's SpO2 level. Example: '3' |
| triages_airways | Assessment of the patient's airway status. Example: 'Fri luftvei' |
| triages_airways_risk_level | Risk level associated with the patient's airway status. Example: '4' |
| triages_temperature | Temperature reading taken during the triage. Example: 'Temp. 35,0 - 38,5 °C' |
| triages_temperature_risk_level | Risk level associated with the patient's temperature. Example: '4' |
| triages_respiratory_rate | Respiratory rate of the patient. Example: 'RF 8 - 25 /min' |
| triages_respiratory_rate_risk_level | Risk level associated with the patient's respiratory rate. Example: '4' |
| triages_spasms | Information on whether spasms are observed in the patient. Example: 'Ingen kramper' |
| triages_spasms_risk_level | Risk level associated with the patient's spasms. Example: '4' |
| triages_ess_risk_level | ESS risk level recorded for the patient. Example: '1' |
| triages_systolic_blood_pressure | Patient's systolic blood pressure reading during triage. Example: 'SBT >= 90 mmHg' |
| triages_systolic_blood_pressure_risk_level | Risk level associated with the patient's systolic blood pressure. Example: '4' |
| triages_diastolic_blood_pressure | Patient's diastolic blood pressure reading during triage. Example: 'DBT <= 95 mmHg' |
| triages_diastolic_blood_pressure_risk_level | Risk level associated with the patient's diastolic blood pressure. Example: '4' |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_sats
Data filled out in the sats tile in EWA
| Column Name | Description |
|---|---|
| record_id | The unique identifier for a record |
| clinical_signs_patient_age_group | The age group of the patient as observed in clinical signs. Examples: 'Child', 'Adult' |
| clinical_signs_time_stamp | Timestamp of when clinical signs were recorded. Example: '2024-10-23 19:28:00.000000' |
| clinical_signs_priority_level | Priority level assigned based on clinical signs. Example: '4' |
| clinical_signs_selections_priority_level | Priority level from clinical signs selections. Example: '4' |
| clinical_signs_selections_priority_type | Type of priority assigned in clinical selections. Example: '0' |
| clinical_signs_selections_order | Order of clinical signs selections. Example: '0' |
| clinical_signs_selections_justification_text | Justification text for clinical signs selections. Example: 'Tungpustethet; svært anstrengt/obstruktiv eller apnéer' |
| clinical_signs_selections_foot_note | Footnote associated with clinical signs selections. Example: '0' |
| triage_configuration_id | Unique identifier for the triage configuration. Example: '64' |
| triage_configuration_version_name | Version name of the triage configuration. Example: 'NEWS2/TEWS 5.1' |
| triage_configuration_revision | Revision number of the triage configuration. Example: '19' |
| triage_type | Type of triage conducted. Example: '0' |
| triage_total_score | Total score from the triage assessment. Example: '11' |
| triage_is_complete | Indicates whether the triage is complete. Example: 'true' |
| triage_time_stamp | Timestamp when the triage was completed. Example: '2024-10-23 19:28:00.000000' |
| triage_priority_level | Overall priority level from the triage assessment. Example: '4' |
| triage_tews_selected_params_id | Unique identifier of the selected TEWS parameter. Example: '1' |
| triage_tews_selected_params_title | Title of the selected TEWS parameter. Example: 'Resp. frekv' |
| triage_tews_selected_params_item_id | Identifier of the match in the TEWS parameter for a vital sign. Example: '4' |
| triage_tews_selected_params_item_text | Text of the match in the TEWS parameter for a vital sign. Example: '22-29' |
| triage_tews_selected_params_item_score | Score of the match in the TEWS parameter for a vital sign. Example: '2' |
| senior_healthcare_professionals_discretions_justification | Justification provided by senior healthcare professionals for discretions. |
| senior_healthcare_professionals_discretions_time_stamp | Timestamp when senior healthcare professionals provided their discretions. Example: '2024-10-23T21:39:00.000000+02:00' |
| senior_healthcare_professionals_discretions_priority_level | Priority level assigned by senior healthcare professionals' discretions. Example: '1' |
| time_stamp | Overall timestamp for the SATS assessment. Example: '2024-10-23 21:39:41.660000' |
| not_applicable | Indicator if SATS is not applicable for the patient. Example: 'false' |
| performed_sats_complete | Indicates if SATS assessment was fully performed. Example: 'true' |
| age_selection | Age selection for the SATS configuration. Example: '6' |
| configuration_id | Unique identifier for the SATS configuration. Example: '63' |
| configuration_version_name | Version name of the SATS configuration. Example: 'SATS Norge 5.1' |
| configuration_revision | Revision number of the SATS configuration. Example: '27' |
| priority_level_total | Total priority level calculated in SATS. Example: '1' |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_sepsis
Data filled out in the sepsis tile in EWA
| Column Name | Description |
|---|---|
| record_id | The unique identifier for a record |
| unique_id | A unique identifier in Analytics generated for each table |
| time_stamp | Timestamp of when the sepsis-related data was recorded. Example: '2024-06-05 11:12:48.8903543' |
| sirs_heart_rate | Indicates if the SIRS heart rate criterion is met. Examples: 'true', 'false' |
| sirs_respiratory_rate | Indicates if the SIRS respiratory rate criterion is met. Examples: 'true', 'false' |
| sirs_temp | Indicates if the SIRS temperature criterion is met. Examples: 'true', 'false' |
| qsofa_respiratory_rate | Indicates if the qSOFA respiratory rate criterion is met. Examples: 'true', 'false' |
| qsofa_systolic_blood_pressure | Indicates if the qSOFA systolic blood pressure criterion is met. Examples: 'true', 'false' |
| qsofa_gcs | Indicates if the qSOFA Glasgow Coma Scale criterion is met. Examples: 'true', 'false' |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_time
Data filled out in the different time tiles in EWA
| Column Name | Description |
|---|---|
| record_id | The unique identifier for a record |
| unique_id | A unique identifier in Analytics generated for each table |
| time_stamp | Timestamp of the event. Examples: '2024-06-04 12:37:38.0491777', '2023-12-22 07:58:31.1500000' |
| time_type | Type of the timestamp event. Examples: 'free', 'ambulance_alerted', 'at_place_of_incident' |
| record_status | The status of the record (Ongoing - 0, Aborted - 1, Deleted - 2, Completed - 3) |
| record_updated_at | The timestamp when the record was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.stations
The ewa_clean__stations table contains details about stations, including related record information and metadata timestamps.
| Column Name | Description |
|---|---|
| id | Unique identifier for each station |
| unique_id | A unique identifier in Analytics generated for each table |
| name | Name of the Station |
| organization_id | Reference id for the organization |
| updated_at | The timestamp when this entry was last updated in EWA |
| created_at | The timestamp when this entry was created in EWA |
| deleted_at | The timestamp when this entry was deleted in EWA, if applicable |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
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 | Description |
|---|---|
| id | Unique identifier from EWA for each organization |
| unique_id | A unique identifier in Analytics generated for each table |
| name | Name of the organization. Example: 'Bliksund HF' |
| organization_reference | Reference number or name for the organization. Example: '123456789' |
| updated_at | The timestamp when this entry was last updated in EWA |
| created_at | The timestamp when this entry was created in EWA |
| deleted_at | The timestamp when this entry was deleted in EWA, if applicable |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.cardiac_arrest_forms
The ewa_clean__cardiac_arrest_forms table contains information about the information in a cardiac arrest forms.
| Column Name | Description |
|---|---|
| id | The unique identifier from EWA for each cardiac arrest form |
| unique_id | A unique identifier in Analytics generated for each table |
| record_id | The unique identifier for a record |
| form_status | The status of the cardiac arrest form, indicating if it's completed or ongoing. |
| emcc_alerted_time_known | Indicates if the time when the EMCC was alerted is known. Example: 'Yes' or 'No'. |
| emcc_alerted_time_stamp | Timestamp indicating when the EMCC was alerted. |
| event_time_known | Indicates if the time of the cardiac arrest is known. Example: 'Yes' or 'No'. |
| event_time_stamp | Timestamp of the cardiac arrest. |
| reported | Indicates if it was reported as a cardiac arrest. Example: 'Yes', 'No', or 'Unknown'. |
| ambulance_arrival_time_stamp | Timestamp when the ambulance arrived at the scene. |
| cardiac_arrest_place | Location where the cardiac arrest took place. |
| collapse_seen | Indicator of whether the collapse was witnessed. |
| cardiac_arrest_cause | The cause of the cardiac arrest. |
| acute_breast_pain | Indicator if the patient experienced acute breast pain prior to the arrest. |
| cardiac_arrest_conjunction_exercise | Indicates whether the cardiac arrest occurred during exercise. |
| cpr_performed_bystanders | Indicates if CPR was performed by bystanders. |
| cpr_method | The method of CPR performed. |
| cpr_performed_first_responder | Indicator of whether the first responder performed CPR. |
| cpr_method_first_respondent | The method of CPR used by the first respondent. |
| aed_connected | Indicates if an AED was connected. |
| shocks_administered | Indicates if an AED did shock administration |
| first_shock_time_stamp | Timestamp indicating when the first shock was given. |
| first_heart_rhythm | The patient's initial heart rhythm at first contact. |
| cpr_performed_paramedics | Indicates if CPR was performed by paramedics. Example: 'Yes' or 'No'. |
| cpr_not_started | Reason why CPR was not initiated, if applicable. |
| cpr_started_time_stamp | Timestamp indicating when CPR was initiated. |
| defibrillation_paramedics | Indicates if defibrillation was performed by paramedics. |
| number_shocks | Total number of shocks. |
| airways_management | Details about airway management procedures performed. |
| capnography | Use of capnography during resuscitation. Example: 'Yes' or 'No'. |
| adrenalin | Indicates if adrenalin was administered. Example: 'Yes' or 'No'. |
| amiodarone | Indicates if amiodarone was administered. Example: 'Yes' or 'No'. |
| prehospital_thrombolysis | Indicates if prehospital thrombolysis was done. |
| chest_compression_machine | Indicates if a chest compression machine was used. |
| chest_compression_machine_time_stamp | Timestamp indicating when the chest compression machine was initiated. |
| cpr_was_stopped | Indicator if CPR was stopped. Example: 'Yes' or 'No'. |
| cpr_stopped_time_stamp | Timestamp indicating when CPR was stopped. |
| cpr_stop_cause | Reason for stopping CPR. |
| rosc_achieved | Indicator if ROSC was achieved. |
| continuous_rosc_achieved | Indicator if continuous ROSC was achieved. Example: 'Yes' or 'No'. |
| continuous_rosc_time_stamp | Timestamp indicating when continuous ROSC was achieved. |
| active_cooling_started | Indicator if active cooling treatment was started. |
| active_cooling_started_time_stamp | Timestamp indicating when active cooling was initiated. |
| twelve_lead_ecg | Indicates if a 12-lead ECG was performed. |
| patient_transported_hospital | Indicates if the patient was transported to a hospital. Example: 'Yes' or 'No'. |
| direct_transport_hospital | Indicates if direct transport to a hospital with Angio/PCI-lab occurred. Example: 'Yes' or 'No'. |
| direct_transport_pci | Indicates if direct transport to a PCI-lab occurred. Example: 'Yes' or 'No'. |
| status_at_hospital_arrival | Patient's status at arrival at the hospital. |
| hospital_arrival_time_known | Indicates if the time when the patient arrived at the hospital is known. Values: 'Yes' or 'No'. |
| hospital_arrival_time_stamp | Timestamp indicating when the patient arrived at the hospital. |
| delivery_hospital | The hospital to which the patient was delivered. |
| updated_at | The timestamp when this entry was last updated in EWA |
| created_at | The timestamp when this entry was created in EWA |
| deleted_at | The timestamp when this entry was deleted in EWA, if applicable |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
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 | Description |
|---|---|
| id | Unique identifier for each urgency level. Example: '12345'. |
| unique_id | A unique identifier in Analytics generated for each table |
| name | The name of the urgency level in the default language. Example: 'Acute'. |
| name_en_GB | The name of the urgency level in British English. Example: 'Acute'. |
| name_da_DK | The name of the urgency level in Danish. Example: 'Akut'. |
| name_fr_FR | The name of the urgency level in French. Example: 'Aigu'. |
| name_de_DE | The name of the urgency level in German. Example: 'Akut'. |
| name_nb_NO | The name of the urgency level in Norwegian Bokmål. Example: 'Akutt'. |
| name_sv_SE | The name of the urgency level in Swedish. Example: 'Akut'. |
| color | The color code associated with the urgency level. Example: 'red'. |
| updated_at | The timestamp when this entry was last updated in EWA |
| created_at | The timestamp when this entry was created in EWA |
| deleted_at | The timestamp when this entry was deleted in EWA, if applicable |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
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 | Description |
|---|---|
| id | Unique identifier for each record urgency level mapping. Example: '12345'. |
| unique_id | A unique identifier in Analytics generated for each table |
| urgency_level_id | Identifier for the associated urgency level. Example: 'a1b2c3d4'. |
| record_id | The unique identifier for a record |
| updated_at | The timestamp when this entry was last updated in EWA |
| created_at | The timestamp when this entry was created in EWA |
| deleted_at | The timestamp when this entry was deleted in EWA, if applicable |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.checklist_response_items
The checklist_responses table contains records of individual checklist responses, including responses to specific checklist items.
| Column Name | Description |
|---|---|
| unique_id | A unique identifier in Analytics generated for each table |
| checklist_configuration_item_id | Identifier for the checklist item associated with the response. |
| record_id | The unique identifier for a record |
| completed_time_stamp | Timestamp when the checklist was completed. |
| item_number | The item number within the checklist. |
| item_response_is_selected | Indicates whether the checklist item was selected as a response (true/false). |
| item_response_text | Text response provided for the checklist item. |
| item_response_value | Value associated with the checklist item's response. |
| updated_at | The timestamp when this entry was last updated in EWA |
| created_at | The timestamp when this entry was created in EWA |
| deleted_at | The timestamp when this entry was deleted in EWA, if applicable |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
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 | Description |
|---|---|
| id | Unique identifier for the checklist configuration item. Based on the id and the item_number. |
| unique_id | A unique identifier in Analytics generated for each table |
| checklist_configuration_id | Identifier for the checklist configuration. |
| checklist_guid | Globally unique identifier (GUID) for the checklist. |
| checklist_name | Name of the checklist. |
| item_number | The item number within the checklist. |
| item_description | Description of the checklist item. |
| updated_at | The timestamp when this entry was last updated in EWA |
| created_at | The timestamp when this entry was created in EWA |
| deleted_at | The timestamp when this entry was deleted in EWA, if applicable |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
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 | Description |
|---|---|
| id | Unique identifier from EWA for each emcc ticket |
| unique_id | A unique identifier in Analytics generated for each table |
| full_emcc_mission_id | The mission identifier in the EMCC system including the resource assigned to the mission. |
| emcc_mission_id | The mission identifier in the EMCC system. Example: '33644994'. |
| mission_resource_id | The identifier for the resource assigned to the mission. |
| full_emcc_mission_id_updated_at | Timestamp of the last update to the full mission ID. |
| emcc_alerted_time_stamp | Timestamp when the EMCC was alerted. |
| emcc_alerted_time_stamp_updated_at | Timestamp of the last update to the alerted timestamp. |
| dispatch_code | The dispatch code associated with the emcc ticket. |
| dispatch_code_updated_at | Timestamp of the last update to the dispatch code. |
| dispatch_code_description | Description of the dispatch code. |
| dispatch_code_description_updated_at | Timestamp of the last update to the dispatch code description. |
| urgency_level | The urgency level of the emcc ticket. |
| urgency_level_updated_at | Timestamp of the last update to the urgency level. |
| problem_description | A description of the problem associated with the emcc ticket. |
| updated_at | The timestamp when this entry was last updated in EWA |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.records_emcc_tickets
The records_emcc_tickets bridges the EMCC tickets to their associated records.
| Column Name | Description |
|---|---|
| id | Unique identifier |
| unique_id | A unique identifier in Analytics generated for each table |
| emcc_ticket_id | Unique identifier for each emcc ticket. |
| record_id | The unique identifier for a record |
| updated_at | The timestamp when this entry was last updated in EWA |
| created_at | The timestamp when this entry was created in EWA |
| deleted_at | The timestamp when this entry was deleted in EWA, if applicable |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.resources
This table contains information about individual resources, including their type, station association, and metadata timestamps.
| Column Name | Description |
|---|---|
| id | The unique identifier for the resource. Example: '10'. |
| name | The name of the resource |
| station_id | The identifier of the station to which the resource is linked. Example: '10'. |
| resource_type_id | The identifier for the resource's type, linking to the resource type table. Example: '49bddc91-09b1-4cef-a08c-a2ae72abcde7'. |
| updated_at | The timestamp when this entry was last updated in EWA |
| created_at | The timestamp when this entry was created in EWA |
| deleted_at | The timestamp when this entry was deleted in EWA, if applicable |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.resource_types
This table contains information about resource types, including their names and metadata timestamps.
| Column Name | Description |
|---|---|
| id | The unique identifier for the resource type. Example: '49bddc91-09b1-4cef-a08c-a2ae72abcde7'. |
| name | The name of the resource type. Example: 'Ambulance'. |
| updated_at | The timestamp when this entry was last updated in EWA |
| created_at | The timestamp when this entry was created in EWA |
| deleted_at | The timestamp when this entry was deleted in EWA, if applicable |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
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 | Description |
|---|---|
| id | The unique identifier from EWA for each retts priority level |
| color | Color associated with the RETTS priority level. Example: 'Red'. |
ewa_clean.sats_priority_levels
The ewa_clean__sats_priority_levels table contains information about SATS (Severity Assessment Triage System) priority levels
| Column Name | Description |
|---|---|
| id | The unique identifier from EWA for each sats priority level |
| color | Color associated with the SATS priority level. Example: 'Red'. |
ewa_clean.codes_status
The ewa_clean__codes_status table contains information about the status of records in EWA
| Column Name | Description |
|---|---|
| status_code_id | The unique identifier from EWA for each record status |
| nb_NO | Name of the record status in Norwegian. Example: 'Fullført' |
| en_GB | Name of the record status in English. Example: 'Completed' |
ewa_clean.tags
Data about different hierarchy levels, used for example together with locations
| Column Name | Description |
|---|---|
| id | The unique identifier from EWA for each tag |
| unique_id | A unique identifier in Analytics generated for each table |
| value | The value of the tag. Example: 'Sykehus' |
| parent_id | The parent id for the tag id |
| type | The type of the tag |
| updated_at | The timestamp when this entry was last updated in EWA |
| created_at | The timestamp when this entry was created in EWA |
| deleted_at | The timestamp when this entry was deleted in EWA, if applicable |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
ewa_clean.locations
Locations registered in EWA with their associated metadata and a tag id.
| Column Name | Description |
|---|---|
| id | The unique identifier from EWA for each location |
| unique_id | A unique identifier in Analytics generated for each table |
| location_name | The name of the location. Example: 'Sykehus' |
| tag_id | The tag id for the location id, used to connect to the tag table |
| location_guid | The location guid |
| updated_at | The timestamp when this entry was last updated in EWA |
| created_at | The timestamp when this entry was created in EWA |
| deleted_at | The timestamp when this entry was deleted in EWA, if applicable |
| metadata_inserted_at | Metadata about when the row was inserted |
| metadata_updated_at | Metadata about when the row was last updated |
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 | Description |
|---|---|
| record_id | The unique identifier for the record associated with the History of Presenting Complaint data. Example: '14892'. |
| abcde_a | Airway status (A) from the ABCDE assessment. Example: 'Holder frie luftveier selv.' |
| abcde_b | Breathing (B) from the ABCDE assessment. Example: 'Langsom respirasjon.' |
| abcde_c | Circulation (C) from the ABCDE assessment. Example: 'Blek hudfarge.' |
| abcde_d | Disability (D) from the ABCDE assessment. Example: 'Lar seg vekke.' |
| abcde_e | Exposure (E) from the ABCDE assessment. Example: 'Sårskader/blødninger: ' |
| sampler_s | Signs and Symptoms from the SAMPLER assessment. Example: 'FAST symptom: ' |
| sampler_a | Allergies from the SAMPLER assessment. Example: 'Ikke mulig å skaffe opplysninger om allergier.' |
| sampler_m | Medications from the SAMPLER assessment. Example: 'Benytter medisin(-er): ' |
| sampler_p | Past Medical History from the SAMPLER assessment. Example: 'Kjent demenssykdom.' |
| sampler_l | Last Oral Intake from the SAMPLER assessment. Example: 'Inntak av klar væske ca. kl.: ' |
| sampler_e | Events Leading Up to Present Illness/Injury from the SAMPLER assessment. Example: 'blabla' |
| sampler_r | Risk Factors from the SAMPLER assessment. Example: 'Kjent blødertendens.' |
| opqrst_o | Onset from the OPQRST assessment. Example: 'Symptomene tiltok gradvis fra kl: ' |
| opqrst_p | Provocation/Palliation from the OPQRST assessment. Example: 'Fysisk anstrengelse forverrer symptomer.' |
| opqrst_q | Quality from the OPQRST assessment. Example: 'Smertene oppleves som brennende.' |
| opqrst_r | Region/Radiation from the OPQRST assessment. Example: 'Smerter er lokalisert i/på hodet.' |
| opqrst_s | Severity from the OPQRST assessment. Example: 'Pasienten angir sterke smerter/ubehag' |
| opqrst_t | Time (duration/progression) from the OPQRST assessment. Example: 'Ikke mulig å skaffe opplysninger om varigheten av smerter.' |
| traume_h | Head findings from the TRAUME assessment. Example: 'høyre side.' |
| traume_n | Neck/throat findings from the TRAUME assessment. Example: 'Sårskade' |
| traume_t | Thorax findings from the TRAUME assessment. Example: 'Sårskade' |
| traume_a | Abdomen findings from the TRAUME assessment. Example: 'Hematom' |
| traume_b | Pelvis findings from the TRAUME assessment. Example: 'Kontusjonsmerke' |
| traume_u | Lower extremity findings from the TRAUME assessment. Example: 'legg: ' |
| traume_o | Upper extremity findings from the TRAUME assessment. Example: 'overarm: ' |
| traume_r | Back findings from the TRAUME assessment. Example: 'Smerte' |
| free_text | A free-text field for capturing any additional or unstructured information about the patient's history of illness. Example: 'Pasienten opplevde brystsmerter tidligere'. |
| record_status | Status code of the record. Examples: '0', '3' |
| record_updated_at | Timestamp of the last update to the record. Example: '2024-10-23 21:39:41.660000' |
| metadata_inserted_at | Timestamp when the metadata was first inserted. Example: '2024-10-29 13:01:31.838445' |
| metadata_updated_at | Timestamp when the metadata was last updated. Example: '2024-10-29 13:01:31.838445' |
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 | Description |
|---|---|
| unique_id | A unique identifier generated for each record, combining the type_id and type fields. |
| type_id | The internal ID representing the unknown patient ID type. |
| type | The name of the unknown patient ID type. Examples: 'NotRelevant', 'HNumber', and 'FHNumber'. |