Table descriptions
ewa_clean.form_configurations
This table contains information about the content of a form and how it is configured
| Column Name | Description |
|---|---|
| form_configuration_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, and all associated elements and options, in a form and how it is configured
| Column Name | Description |
|---|---|
| form_configuration_section_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 |
| 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 |
| 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_responses
This table contains information about responses to a form
| Column Name | Description |
|---|---|
| form_response_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 reponse, 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_sections
This table contains information about the responses to a section, and all associated elements and options, in a form
| Column Name | Description |
|---|---|
| form_response_section_id | Form Response Section Id from source, unique id for each response to a section in a form |
| form_response_id | Form Response Id from source, unique id for each response to 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 and null if the element is not a choice question |
| 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 |
|---|---|
| id | id for the connection from dbo.PerformedChecklists |
| checklist_id | ID of the checklist |
| record_id | ID of the journal record |
| updated_at | Timestamp of the last update |
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.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'. |
| 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'. |
| 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 | The mission identifier in the EMMC system. Example: '33644994'. |
| mission_resource_id | The identifier for the resource assigned to the mission. Example: '9ca5b560-daf1-47b9-8389-d221c9916737'. |
| dispatch_code | The dispatch code associated with the mission. Example: '1'. |
| 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'. |
| 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'. |
| home_address_or_place | The home address or place of residence for the patient. Example: 'Numedalsveien 52, 3602 Kongsberg'. |
| 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 | 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'. |
| 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' discretions, 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' |
| senior_healthcare_professionals_discretions_justification | Justification provided by senior healthcare professionals for discretions. Example: 'løk1' |
| senior_healthcare_professionals_discretions_time_stamp | Timestamp when senior healthcare professionals provided their discretion. 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 | 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 alse reffered 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 | Record ID associated with each organization. Examples: '9834', '14144', '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' |