Table descriptions
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 |
| 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 |
| id | Form Configuration Section Id from source, unique id for each section in a form |
| form_configuration_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 |
| id | Form Configuration Element Id from source, unique id for each element in a form section |
| form_configuration_section_id | Form Configuration Section Id from source, unique id for each section in a form |
| form_configuration_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 |
| id | Form Response Id from source, unique id for each response to a form |
| form_configuration_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 |
| form_response_section_id | Form Response Section Id from source, unique id for each response to a section in a form |
| form_configuration_section_id | Form Configuration Section Id from source, unique id for each section in a form |
| form_configuration_element_id | Form Configuration Element Id from source, unique id for each element in a form section |
| form_configuration_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 |
| form_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 |
| 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.billable_information
This model extracts and transforms billable information from the staged records data.
| Column Name | Description |
|---|---|
| record_id | The unique identifier for the record associated with billable information. |
| unique_id | A unique identifier generated for each record in the clean layer. |
| 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 as provided in the staged records. |
| record_updated_at | The timestamp when the record was last updated in the source data. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. |
ewa_clean.records_configurable_mission_types
This model extracts and transforms data on configurable mission types and bridge them with a associated record.
| Column Name | Description |
|---|---|
| id | The unique identifier for each record-configurable mission type entry. |
| unique_id | A generated unique identifier for each entry in the clean layer. |
| configurable_mission_type_id | The identifier linking to the specific configurable mission type associated with the record. |
| record_id | The identifier linking to the record associated with the configurable mission type. |
| updated_at | The timestamp when this entry was last updated in the source data. |
| created_at | The timestamp when this entry was initially created in the source data. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. |
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 for each configurable mission type. |
| unique_id | A generated unique identifier for each mission type in the clean layer. |
| 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. |
| updated_at | The timestamp when the mission type was last updated. |
| created_at | The timestamp when the mission type was initially created. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. |
ewa_clean.contagion
This model extracts and transforms contagion-related data from the staged records.
| Column Name | Description |
|---|---|
| record_id | The unique identifier for the record associated with contagion data. |
| unique_id | A generated unique identifier for each contagion risk entry in the clean layer, based on the record ID and risk ID. |
| contagion | Contagion true or false, as extracted from JSON data. |
| risk_id | The unique identifier for the specific contagion risk. |
| risk_text | Description text for the contagion risk. |
| record_status | The status of the record as provided in the staged records. |
| record_updated_at | The timestamp when the record was last updated in the source data. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. |
ewa_clean.drugs
This model extracts and transforms data related to drugs administered as part of records.
| Column Name | Description |
|---|---|
| record_id | The unique identifier for the record associated with drug administration. Example: '8159'. |
| unique_id | A generated unique identifier for each drug entry in the clean layer, based on record ID, drug order, and personnel details. Example: '00c3af7490680534bc29122a56a5ce1d'. |
| 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 as provided in the staged records. Example: '2'. |
| record_updated_at | The timestamp when the record was last updated in the source data. Example: '2023-02-20 12:17:16.6730000'. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. Example: '2024-10-30 08:38:48.1479501'. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. Example: '2024-10-30 08:38:48.1479501'. |
ewa_clean.gcs
This model extracts and transforms data related to Glasgow Coma Scale (GCS) scores, including motor, verbal, and eye-opening responses.
| Column Name | Description |
|---|---|
| record_id | The unique identifier for the record associated with GCS data. Example: '11472'. |
| unique_id | A generated unique identifier for each GCS entry, based on record ID, response type, and GCS order. Example: '000ec9103e8ce1419e05d63fe6770835'. |
| 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 as provided in the staged records. Example: '3'. |
| record_updated_at | The timestamp when the record was last updated in the source data. Example: '2023-12-06 08:45:40.8770000'. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. Example: '2024-10-29 12:58:05.2920484'. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. Example: '2024-10-29 12:58:05.2920484'. |
ewa_clean.history_of_presenting_complaint
This model extracts and transforms data related to History of Presenting Complaint entries.
| Column Name | Description |
|---|---|
| record_id | The unique identifier for the record associated with the History of Presenting Complaint data. Example: '11472'. |
| abcde_a | The A component of the ABCDE assessment, related to airway. Example: 'Holder frie luftveier selv'. |
| abcde_b | The B component of the ABCDE assessment, related to breathing. Example: 'Normal respirasjon'. |
| abcde_c | The C component of the ABCDE assessment, related to circulation. Example: 'Normal sirkulasjon'. |
| marchon | The MARCH-ON system for assessing critical care priorities in mass casualty triage. Example: 'Grønn'. |
| sampler | The SAMPLER system used to gather patient history. Example: 'Pasienten er allergisk mot penicillin'. |
| sample | An abbreviated version of SAMPLER. Example: 'Ingen kjente allergier'. |
| opqrst | The OPQRST acronym used to assess pain. Example: 'Smertene startet plutselig og er skarpe'. |
| traume | Information regarding any trauma the patient has experienced. Example: 'Falt fra høyde'. |
| primsurv | Primary survival assessment related to critical care. Example: 'Stabil hjertefrekvens og blodtrykk'. |
| secsuv | Secondary survival assessment, used for follow-up evaluation.. Example: 'Ingen tegn til indre blødninger'. |
| atmist | The ATMIST system for trauma and medical assessment. Example: 'Hendelsen skjedde for 3 timer siden'. |
| free_text | A free-text field for capturing additional relevant information about the patient's history. 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.infusions
This model extracts and transforms data related to infusion records.
| Column Name | Description |
|---|---|
| record_id | The unique identifier for the record associated with infusion data. Example: '4628'. |
| unique_id | A generated unique identifier for each infusion entry in the clean layer, based on record ID, infusion order, and personnel details. Example: '0183a4b6835f15b43d1a645eca390b6'. |
| 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 as provided in the staged records. Example: '3'. |
| record_updated_at | The timestamp when the record was last updated in the source data. Example: '2022-07-21 06:27:39.4670000'. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. Example: '2024-10-29 12:59:30.3074766'. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. Example: '2024-10-29 12:59:30.3074766'. |
ewa_clean.interventions
This model extracts and transforms data related to medical interventions performed during the record.
| Column Name | Description |
|---|---|
| record_id | The unique identifier for the record associated with intervention data. Example: '11509'. |
| unique_id | A generated unique identifier for each intervention entry, based on record ID, intervention order, and personnel details. Example: '00b4b36eabd9d041cedc92cae9a3e8be'. |
| 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 as provided in the staged records. Example: '0'. |
| record_updated_at | The timestamp when the record was last updated in the source data. Example: '2023-12-07 08:55:21.9770000'. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. Example: '2024-10-29 12:59:58.6980168'. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. Example: '2024-10-29 12:59:58.6980168'. |
ewa_clean.locations
This model extracts and transforms location data related to records, including incident, via, start, and destination places.
| Column Name | Description |
|---|---|
| record_id | The unique identifier for the record associated with location data. Example: '12799'. |
| unique_id | A generated unique identifier for each location entry, based on record ID and location type. Example: '0209b74d3a56cf9b4c050a5b63488a06'. |
| id | The unique identifier for the specific location. Example: '5632'. |
| address_or_place | The address or name of the place associated with the location. Example: 'Grimstad'. |
| house_number | The house number of the location, if available. Example: '25a'. |
| zip | The ZIP code of the location, if available. Example: '4887'. |
| city | The city where the location is situated. Example: 'Grimstad'. |
| municipality_or_country | 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'. |
| 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. |
| 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 as provided in the staged records. Example: '3'. |
| record_updated_at | The timestamp when the record was last updated in the source data. Example: '2023-04-23 14:09:18.6300000'. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. Example: '2024-10-30 09:05:54.7377396'. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. Example: '2024-10-30 09:05:54.7377396'. |
ewa_clean.miscellaneous_information
This model extracts and transforms miscellaneous information related to records, including extra persons, assistance, and circumstances.
| Column Name | Description |
|---|---|
| record_id | The unique identifier for the record associated with miscellaneous information. Example: '9845'. |
| unique_id | A generated unique identifier for each miscellaneous information entry in the clean layer. Example: '0060abc3ae7c5b3a6a1f0a6162e34997'. |
| 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 as provided in the staged records. Example: '3'. |
| record_updated_at | The timestamp when the record was last updated in the source data. Example: '2023-07-25 12:54:39.9270000'. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. Example: '2024-10-29 13:00:32.7291937'. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. Example: '2024-10-29 13:00:32.7291937'. |
ewa_clean.miscellaneous_medical
This model extracts and transforms miscellaneous medical information associated with records, including energy assessments, injury types, and chief complaints.
| Column Name | Description |
|---|---|
| record_id | The unique identifier for the record associated with miscellaneous medical information. Example: '9845'. |
| unique_id | A generated unique identifier for each entry in the clean layer. Example: '013acb3a04eecb944c7192e34b8743a7'. |
| 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 as provided in the staged records. Example: '3'. |
| record_updated_at | The timestamp when the record was last updated in the source data. Example: '2023-07-25 12:54:39.9270000'. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. Example: '2024-10-29 13:00:32.7291937'. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. Example: '2024-10-29 13:00:32.7291937'. |
ewa_clean.missions
This model extracts and transforms data related to missions, including mission types, dispatch codes, and distances.
| Column Name | Description |
|---|---|
| record_id | The unique identifier for the record associated with the mission. Example: '9834'. |
| unique_id | A generated unique identifier for each mission entry in the clean layer. Example: '00064e4921b4ddce24ba17312407633'. |
| emmc_mission_id | (DEPRECATION: 2025.02.01) The mission identifier in the EMCC system. Example: '33644994'. |
| emcc_mission_id | The mission identifier in the EMCC system. Example: '33644994'. |
| 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 as provided in the staged records. Example: '1'. |
| record_updated_at | The timestamp when the record was last updated in the source data. Example: '2023-07-25 12:01:29.9100000'. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. Example: '2024-10-29 13:00:42.1198027'. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. Example: '2024-10-29 13:00:42.1198027'. |
ewa_clean.news2
This model extracts and transforms data related to NEWS2 examinations, including total scores and COPD status.
| Column Name | Description |
|---|---|
| record_id | The unique identifier for the record associated with the NEWS2 examination. Example: '880'. |
| unique_id | A generated unique identifier for each NEWS2 entry in the clean layer, based on record ID and examination GUID. Example: '00aa9c658a8c2b094cc321cdd2620ddf'. |
| 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 as provided in the staged records. Example: '2'. |
| record_updated_at | The timestamp when the record was last updated in the source data. Example: '2022-05-25 10:26:17.9530000'. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. Example: '2024-10-29 13:00:46.4322902'. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. Example: '2024-10-29 13:00:46.4322902'. |
ewa_clean.oxygen
This model extracts and transforms data related to oxygen administration, including routes, quantities, and timestamps.
| Column Name | Description |
|---|---|
| record_id | The unique identifier for the record associated with oxygen administration data. Example: '13122'. |
| unique_id | A generated unique identifier for each oxygen administration entry, based on record ID and oxygen order. Example: '00097d554f4d154f0f1e4530b243b8bf'. |
| 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 as provided in the staged records. Example: '0'. |
| record_updated_at | The timestamp when the record was last updated in the source data. Example: '2024-06-05 11:26:20.0570000'. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. Example: '2024-10-29 13:00:48.2916602'. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. Example: '2024-10-29 13:00:48.2916602'. |
ewa_clean.patients
This model extracts and transforms patient data, including identification, address, and next-of-kin information.
| Column Name | Description |
|---|---|
| record_id | The unique identifier for the record associated with the patient. Example: '13122'. |
| unique_id | A generated unique identifier for each patient entry, based on record ID and patient ID. Example: '00097d554f4d154f0f1e4530b243b8bf'. |
| id | The unique identifier for the patient. Example: '20'. |
| 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 | The system or standard used for the temporary ID, e.g., "Hjelpenummer" in Norway. |
| 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_or_country | 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 as provided in the staged records. Example: '0'. |
| record_updated_at | The timestamp when the record was last updated in the source data. Example: '2024-06-05 11:26:20.0570000'. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. Example: '2024-10-29 13:01:16.0728664'. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. Example: '2024-10-29 13:01:16.0728664'. |
ewa_clean.personnel
This model extracts and transforms personnel data, including roles (Driver, Treater, etc.), names, and user IDs associated with records.
| Column Name | Description |
|---|---|
| record_id | The unique identifier for the record associated with the personnel data. Example: '7362'. |
| unique_id | A generated unique identifier for each personnel entry, based on user ID, record ID, and personnel type. Example: '000bc40b13f60ff4e2374f25cdf30d00'. |
| 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 as provided in the staged records. Example: '3'. |
| record_updated_at | The timestamp when the record was last updated in the source data. Example: '2022-11-29 07:57:25.3300000'. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. Example: '2024-10-29 13:01:20.3384620'. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. Example: '2024-10-29 13:01:20.3384620'. |
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 for the crew role. Example: '134a5054-6de5-4041-9d5e-e6308dba91fc'. |
| unique_id | A generated unique identifier for each crew role entry based on crew role ID and a static value. Example: 'b884d821872577332e5ba6357fd4f433'. |
| 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'. |
| created_at | The timestamp when the crew role was created. Example: '2024-06-27 13:19:48.4907828'. |
| updated_at | The timestamp when the crew role was last updated. Example: '2024-06-27 13:19:48.4900000'. |
| deleted_at | The timestamp when the crew role was deleted, if applicable. Example: 'NULL'. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. Example: '2024-10-30 09:43:20.5294313'. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. Example: '2024-10-29 12:57:29.1202417'. |
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 for the medical record crew entry. Example: '003712ea-42e0-4890-94d3-abc1aa8d3fb4'. |
| unique_id | A generated unique identifier for each medical record crew entry based on the medical record crew ID and a static value. Example: 'f459782f69e19e9438d8b32d9ced40b2e'. |
| record_id | The identifier for the medical record associated with the crew member. Example: '13328'. |
| 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'. |
| name | (DEPRECATION: 2025.02.01) The full name of the crew member associated with the record. Example: 'Maneevannan Rajkummar'. |
| full_name | The full name of the crew member associated with the record. Example: 'Maneevannan Rajkummar'. |
| updated_at | The timestamp when the medical record crew entry was last updated. Example: '2024-07-02 09:13:57.3130000'. |
| created_at | The timestamp when the medical record crew entry was created. Example: '2024-07-02 09:13:57.3123541'. |
| deleted_at | The timestamp when the medical record crew entry was deleted, if applicable. Example: 'NULL'. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. Example: '2024-10-30 09:43:20.5294313'. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. Example: '2024-10-29 12:57:29.1202417'. |
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 for the user entry. Example: '0944ab38-1321-4187-8103-9b21814da4fb'. |
| unique_id | A generated unique identifier for each user entry based on the user ID and a static value. Example: '0e955a0e2a40e6a30445ddce9f03101'. |
| 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'. |
| name | (DEPRECATION 2025.02.01) The full name of the user. Example: 'Eric Sundet'. |
| 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 of the last update to the user entry. Example: '2024-09-05 20:18:33.4130000'. |
| created_at | The timestamp of when the user entry was created. Example: '2024-09-05 20:18:33.4120041'. |
| deleted_at | The timestamp when the user entry was deleted, if applicable. Example: 'NULL'. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. Example: '2024-10-29 13:00:42.1198027'. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. Example: '2024-10-29 13:00:42.1198027'. |
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 for the record entry. Example: '1'. |
| unique_id | A generated unique identifier for each record entry based on the record ID and a static value. Example: 'ea66c06c1e1c05fa9f1aa39d98dc5bc1'. |
| model_version | The version of the model associated with the record. Example: '2'. |
| status | The status code of the record. Example: '2'. |
| en_GB | The status description in British English. Example: 'Deleted'. |
| updated_at | The timestamp of the last update to the record entry. Example: '2022-05-25 10:47:30.2570000'. |
| created_at | The timestamp when the record entry was created. Example: '2022-02-24 10:59:08.3966667'. |
| deleted_at | The timestamp when the record entry was deleted, if applicable. Example: 'NULL'. |
| metadata_inserted_at | The timestamp when the metadata was inserted for tracking purposes. Example: '2024-10-29 13:01:24.6822111'. |
| metadata_updated_at | The timestamp when the metadata was last updated for tracking purposes. Example: '2024-10-29 13:01:24.6822111'. |
ewa_clean.resources
This table contains resource-related information linked to each record, such as station ID and callsign.
| Column Name | Description |
|---|---|
| record_id | The unique identifier for the record to which this resource entry is associated. Example: '9834'. |
| unique_id | A generated unique identifier for each resource entry based on the record ID and a static value. Example: '00064e94921b4ddce24ba17312407633'. |
| id | The unique identifier for the resource. Example: '45'. |
| 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 current status of the record, indicating its active or inactive state. Example: '1'. |
| record_updated_at | The timestamp when the record was last updated. Example: '2023-07-25 12:01:29.9100000'. |
| metadata_inserted_at | The timestamp when metadata was inserted for tracking. Example: '2024-10-29 13:01:27.7915687'. |
| metadata_updated_at | The timestamp when metadata was last updated for tracking. Example: '2024-10-29 13:01:27.7915687'. |
ewa_clean.retts
The RETTS (Rapid Emergency Triage and Treatment System) table contains triage data for patients, including various health assessments and risk levels related to their symptoms and conditions. This table includes details such as ESS numbers, symptoms, heart rate, and triage levels. Data is drawn from JSON data unpacked in the RETTS triage process, and records can be uniquely identified by record_id and triages_type.
| Column Name | Description |
|---|---|
| record_id | Unique identifier for each record. |
| unique_id | Surrogate unique identifier for the table, generated as a combination of record_id and triages_type. |
| 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 | Status of the record, indicating the current state in the workflow. Example: '3' |
| record_updated_at | Timestamp of the last update made to the record. Example: '2024-06-05 11:26:20.0570000 +02:00' |
| metadata_inserted_at | Timestamp when the record was first inserted into the database. Example: '2024-10-29 13:01:31.8384454' |
| metadata_updated_at | Timestamp when the record was last updated in the database. Example: '2024-10-29 13:01:31.8384454' |
ewa_clean.sats
The ewa_clean__sats table records detailed SATS (Severity Assessment Triage System) information, capturing a wide range of clinical signs, triage measurements, healthcare professionals' decisions, and configuration details.
| Column Name | Description |
|---|---|
| record_id | Unique identifier for each record entry. Example: 14223 |
| 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_decisions_justification | Justification provided by senior healthcare professionals for decisions. |
| senior_healthcare_professionals_decisions_time_stamp | Timestamp when senior healthcare professionals provided their decision. Example: '2024-10-23T21:39:00.000000+02:00' |
| senior_healthcare_professionals_decisions_priority_level | Priority level assigned by senior healthcare professionals' decisions. 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 | 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.sepsis
The ewa_clean__sepsis table records sepsis-related indicators and flags, including SIRS and qSOFA criteria, along with timestamps and status information.
| Column Name | Description |
|---|---|
| record_id | Unique identifier for each sepsis record entry. Example: '13122' |
| unique_id | Generated unique identifier combining record_id and additional criteria for uniqueness. |
| 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 | Status of the sepsis record. Example values: '0', '2', '3' |
| record_updated_at | Timestamp of the last update to the record. Example: '2024-06-05 11:26:20.0570000 +02:00' |
| 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.time
The ewa_clean__time table logs various event timestamps related to records, capturing critical points in the response and incident handling timeline.
| Column Name | Description |
|---|---|
| record_id | Unique identifier for each record entry. Example: '13107' |
| unique_id | Generated unique identifier combining record_id and time_type to ensure row uniqueness. |
| 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 | Status of the record at the time of the event. Examples: '0', '2', '3' |
| record_updated_at | Timestamp of the last update to the record. Example: '2024-06-04 10:37:52.4330000 +02:00' |
| metadata_inserted_at | Timestamp when the metadata was first inserted. Example: '2024-10-29 13:01:35.9790564' |
| metadata_updated_at | Timestamp when the metadata was last updated. Example: '2024-10-29 13:01:35.9790564' |
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. Example: '1' |
| unique_id | Generated unique identifier to ensure row uniqueness. |
| name | Name of the Station |
| organization_id | Reference id for the organization |
| updated_at | Timestamp of the last update to the organization record. Example: '2023-12-04 18:25:17.9800000 +01:00' |
| created_at | Timestamp when the organization record was first created. Example: '2022-02-23 18:22:58.8100000 +01:00' |
| metadata_inserted_at | Timestamp when the metadata was first inserted. Example: '2024-10-28 19:05:09.0962873' |
| metadata_updated_at | Timestamp when the metadata was last updated. Example: '2024-10-28 19:05:09.0962873' |
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 for each organization. Example: '1' |
| unique_id | Generated unique identifier combining the organization id, record_id, and name to ensure row uniqueness. |
| record_id | Unique identifier for each sepsis record entry. Example: '13122' |
| name | Name of the organization. Example: 'Bliksund HF' |
| organization_reference | Reference number or name for the organization. Example: '123456789' |
| updated_at | Timestamp of the last update to the organization record. Example: '2023-12-04 18:25:17.9800000 +01:00' |
| created_at | Timestamp when the organization record was first created. Example: '2022-02-23 18:22:58.8100000 +01:00' |
| metadata_inserted_at | Timestamp when the metadata was first inserted. Example: '2024-10-28 19:05:09.0962873' |
| metadata_updated_at | Timestamp when the metadata was last updated. Example: '2024-10-28 19:05:09.0962873' |
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 | Unique identifier for each cardiac arrest form (from EWA) |
| unique_id | Unique identifier for each cardiac arrest form (from Analytics) |
| record_id | The unique identifier for the record associated with the cardiac_arrest_forms. Example: '13122'. |
| 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 | Timestamp of the last update to the cardiac arrest form. |
| created_at | Timestamp when the cardiac arrest form record was created. |
| metadata_inserted_at | Timestamp when the metadata was first inserted. Example: '2024-10-28 19:05:09.0962873' |
| metadata_updated_at | Timestamp when the metadata was last updated. Example: '2024-10-28 19:05:09.0962873' |
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 | Generated unique identifier combining the id and a constant value to ensure row uniqueness. |
| 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 | Timestamp of the last update to the urgency level record. Example: '2023-12-04 18:25:17.9800000 +01:00'. |
| created_at | Timestamp when the urgency level record was first created. Example: '2022-02-23 18:22:58.8100000 +01:00'. |
| metadata_inserted_at | Timestamp when the metadata was first inserted. Example: '2024-10-28 19:05:09.0962873'. |
| metadata_updated_at | Timestamp when the metadata was last updated. Example: '2024-10-28 19:05:09.0962873'. |
ewa_clean.record_urgency_levels
The ewa_clean__record_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 | Generated unique identifier combining the id and a constant value to ensure row uniqueness. |
| urgency_level_id | Identifier for the associated urgency level. Example: 'a1b2c3d4'. |
| record_id | Identifier for the associated record. Example: '9834'. |
| updated_at | Timestamp of the last update to the record urgency level mapping. Example: '2023-12-04 18:25:17.9800000 +01:00'. |
| created_at | Timestamp when the record urgency level mapping was first created. Example: '2022-02-23 18:22:58.8100000 +01:00'. |
| metadata_inserted_at | Timestamp when the metadata was first inserted. Example: '2024-10-28 19:05:09.0962873'. |
| metadata_updated_at | Timestamp when the metadata was last updated. Example: '2024-10-28 19:05:09.0962873'. |
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 | Generated unique identifier for the checklist response. Based on the id, item_number and record_id. |
| checklist_configuration_item_id | Identifier for the checklist item associated with the response. |
| record_id | Identifier for the record to which the checklist response is linked. |
| 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 | Timestamp of the last update to the checklist response. |
| created_at | Timestamp when the checklist response was first created. |
| deleted_at | Timestamp when the checklist response was deleted. |
| metadata_inserted_at | Timestamp when the metadata was first inserted |
| metadata_updated_at | Timestamp when the metadata 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 | Generated unique identifier for the checklist configuration item. Based on the id and the item_number. |
| 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 | Timestamp of the last update to the checklist configuration. |
| created_at | Timestamp when the checklist configuration was first created. |
| deleted_at | Timestamp when the checklist configuration was deleted. |
| metadata_inserted_at | Timestamp when the metadata was first inserted |
| metadata_updated_at | Timestamp when the metadata 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 for each emcc ticket |
| unique_id | Generated unique identifier combining the id and a constant value to ensure row uniqueness. |
| 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 | Timestamp of the last update to the emcc ticket. |
| metadata_inserted_at | Timestamp when the metadata was first inserted. |
| metadata_updated_at | Timestamp when the metadata 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 | Generated unique identifier in Analytics |
| emcc_ticket_id | Unique identifier for each emcc ticket. |
| record_id | Unique identifier for the record associated with the emcc ticket. |
| updated_at | Timestamp of the last update to the emcc_ticket. |
| created_at | Timestamp when the emcc_ticket was first created. |
| metadata_inserted_at | Timestamp when the metadata was first inserted. |
| metadata_updated_at | Timestamp when the metadata was last updated. |
ewa_clean.measurements
The measurements table contains information about various measurement records taken from patients.
| Column Name | Description |
|---|---|
| id | Generated unique identifier for each measurement, consisting of the record id, the measurement type and the timestamp of the measurement. |
| record_id | Identifier for the record to which the measurement is linked. |
| measurement_type_id | ID of the type of measurement, e.g., 1 = pulse, 3 = temperature, 10 = heart rate. |
| time_stamp | The time when the measurement was recorded. |
| value | The value of the measurement. |
| created_at | Timestamp when the measurement was initially created. |
| updated_at | Timestamp when the measurement was updated. |
| metadata_inserted_at | Timestamp when the metadata was first inserted. |
| metadata_updated_at | Timestamp when the metadata was last updated. |