This data originates from the Ad Astra system.

ADR  > Unscheduled Care @ 107

Feed was initially set up in May 2020 to cover COVID-19 epademic as this system was used within the emergency COVID hubs that were set up prior to being admitted to hospital.
Feed included 2 years of back data, from January 2019 onwards.
Data Dictionary and other ISD documentation here: https://www.isdscotland.org/Products-and-Services/eDRIS/COVID-19/

Scottish Health Data

NHS Fife and Tayside

PROCHI

NHS24 Data from Unscheduled Care Data Mart

COVID19 - Unscheduled Care - NHS24

chi_number

this field represents the unique call id and is anonymised on release.

call_id

Raw data - the date column for the dataset, but as a VARCHAR - replaced by date_call_received which is a proper date column and is set during load.

call_received_date_time

This field represents the call outcome by code.

call_outcome_code

This field represents the descriptive value for the call outcome code.

call_outcome_description

This field represents the call outcome group. the data is defined by:      999   A&E   DENTAL   GP TELEPHONE ADVICE   HOME VISIT   NO PARTNER ACTION   OTHER PARTNER ACTION   PCEC   PRE-PRIORITISED   .

call_outcome_group

patient_date_of_birth

patient_gender

patient_gender_description

postcode

This field represents  Diagnosis  The final algorithm title, which is a free text  field detailing the indicator of patient’s  present symptoms..

protocol

This field represents the reason for contact.

call_reason

This field represents the call origin code.

call_origin_code

This field is the descriptive field linked to the call origin id.

call_origin_description

This field represents the healthboard number.

service_provider_hb_code_9_0

This field represents the healthboard name attributed to the healthboard number..

service_provider_hb_name

This field represents whether the person has covid or not.    The data is defined by NULL, Y or N.

covid19_flag

A Continuous Urgent Care Pathway (CUP) is an unbroken time that a person spends in a series of emergency/urgent care services which occur within 24 hours of each other. This id is anonymised on extraction.

cup_id

A Continuous Urgent Care Pathway (CUP) is an unbroken time that a person spends in a series of emergency/urgent care services which occur within 24 hours of each other.

cup_no

This field represents a numerical episode number within Continuous Urgent Care Pathway (CUP).

episode_within_cup

This field represents the date the call was received.

date_call_received

hic_dataLoadRunID

hic_validFrom

COVID19 - Unscheduled Care - GP Out Of Hours (OOH)

This field represents the record number. This is anonymised on release.

record_id

This field represents the Out Of Hours Unique Case Reference ID. This is anonymised on output.

ooh_guid

patient_gender_code

postcode_of_residence

gp_practice_code

This field represents the health board treatment code.

hb_of_treatment_code_9

This field is the descriptive column for the code_9.

hb_of_treatment_name

This field represents the  the NHS call id. This field is anonymised on output.

call_id_nhs24

This field represents the source of the referral  The data is defined by:    A&E   FAMILY MEMBER/NEIGHBOUR/FRIEND/MEMBER OF PUBLIC   HCP - CHEMIST/PHARMACIST   HCP - CPN/DISTRICT NURSE/MIDWIFE   HCP - DOCTOR (GP)   HCP - HOSPITAL   HCP - LABORATORY   HCP - NURSE   HCP - NURSING HOME/CARE HOME/RESIDENTIAL HOME   HCP - OTHER HCP   HCP - OTHER OOH SERVICE   MIU   NHS 24   OTHER   PATIENT IS CALLER   POLICE/PRISON   SAS   SOCIAL SERVICES   WALK-IN   .

referral_source

This field represents the department that triaged the contact  The data is defined by:   NHS 24   NHS 24 UNTRIAGED   OOH CENTRE STAFF   OTHER   .

triaged_by

This field represents the diagnosis code given.

diagnosis_code

This field is the descriptive field for the diagnosis code.

diagnosis_description

This field represents the outcome of the contact/case.  The data is defined by:      999/AMBULANCE   ADVISED TO CONTACT OWN GP SURGERY/GP TO CONTACT PATIENT   DEATH   EMERGENCY ADMISSION   OTHER   REFERRED TO A&E   REFERRED TO CPN/DISTRICT NURSE/MIDWIFE   REFERRED TO MIU   REFERRED TO SOCIAL SERVICES   TREATMENT COMPLETED AT OOH/DISCHARGED/NO FOLLOW-UP   .

case_outcome

This field represents whether a home visit was required.  The data is defined by Y or N.

home_visit

This field represents Primary Care Emergency Centre consultation.  The data is defined with Y or N.

pcec_pcc_consultation

This field represents the date and time of contact.

Unscheduled Care

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin