Contains data on episode level new and unscheduled attendances at Emergency Departments and some smaller community hospitals and minor injury units (MIUs).

ADR  > Covid 19 Accident and Emergency Statistics @ 106

Scottish Health Data

NHS Fife and Tayside

This field represents the treatment location based on the location code.

treatment_location_code_Desc

COVID19 - Accident and Emergency

chi_number

This field represents the accident and emergency record number. this is anonymised on release.

record_id

patient_gender_code

This field represents Gender and is defined Male or Female.

patient_gender_description

patient_date_of_birth

arrival_date_time

discharge_date_time

This field represents the substantive means by which a patient arrived at an A&E department.    01 Ambulance (road)  02 Ambulance (air)  03 Ambulance + A&E retrieval team  04 Out of hours transport  05 Private transport  06 Public transport  07 Walking  08 Police/prison transport  98 Other  99 Not known.

arrival_mode_code

This field represents the description for the arrival code:   Ambulance (air)   Ambulance (road)   Ambulance + A&E retrieval team   Not known   Other   Out of hours transport   Police/prison transport   Private transport   Public transport   Walking   .

arrival_mode_description

This field represents a record of whether a patient is making a first or follow-up attendance at a particular A&E department.  01 New  02 Return - planned  03 Return - unplanned  04 Recall.

attendance_category_code

This field represents the description to accompany the attendance category code.

attendance_category_desc

This field represents the immediate destination of the patient on discharge from the A&E department.  00      Death  01      Private Residence  01A   Usual place of residence    01B   Not usual place of residence e.g. staying with relatives or friends   02     Residential institution   02A   Usual place of residence    02B   Not usual place of residence  03     Temporary residence  03A   Holiday accommodation    03B    Student accommodation    03C    Legal establishment /prison    03D    No fixed abode    03Z    Other temporary residence    04       Admission to same NHS healthcare provider / hospital  04A    A&E Ward Includes A&E observation ward, A&E short stay ward, etc   04B    Assessment unit    04C    Medical Ward Includes medical admissions unit, coronary care unit   04D   Surgical Ward Includes surgical admissions unit, orthopaedic ward   04Z    Other Ward    05     Transfer to same/other hospital  05A   Psychiatric hospital    05B   Other specialist centre e.g. eye hospital, paediatric hospital   05C   Community hospital   05D   Transferred to Out of Hours (triaged in A&E)  05E   Transferred to Out of Hours (not triaged in A&E)  05F   Advised to attend GP/Primary Care  05G   A&E  05H   NHS24   05Z   Other NHS hospital    06     Private healthcare provider  98     Other  99     Other.

discharge_destination_code

This field represents the description for the discharge code. This specifies where the patient was discharged to for example: Death, Private Healthcare, Private Residence.

discharge_destination_desc

This field represents the diagnosis code. This is a numerical field 1 -14 and 99.

diagnosis_code_1

This field represents the diagnostic description.

ecds_diagnosis_desc_1

This field represents the location where treatment was carried out.  Each location in Scotland, at which events pertinent to the Scottish Health Service take place, is allocated a location code.   The code is a five character code and is maintained jointly by ISD and General Register Office (Scotland).  F704H VICTORIA HOSPITAL  F805H QUEEN MARGARET HOSPITAL  T101H NINEWELLS HOSPITAL  T202H PERTH ROYAL INFIRMARY  T205H ST MARGARET'S HOSPITAL  T207H ABERFELDY COTTAGE HOSPITAL  T208H IRVINE MEMORIAL HOSPITAL  T209H BLAIRGOWRIE & RATTRAY COTTAGE HOSPITAL  T304H ARBROATH INFIRMARY  T305H BRECHIN INFIRMARY  T316H CRIEFF COMMUNITY HOSPITAL  T319H WHITEHILLS HEALTH AND COMMUNITY CARE CENTRE  T320H PITLOCHRY COMMUNITY HOSPITAL  T357C LINKS HEALTH CENTRE.

treatment_location_code

patient_postcode

This field represents the source of referral by code.

referral_source_code

This field is the descriptive value relating to the referral source code.

referral_source_desc

This field represents the patients’ predominant need for ongoing assessment to determine the next step in their care pathways.  NULL NULL  1 Flow 1: Minor Injury & Illness  2 Flow 2: Acute assessment - includes major injuries  3 Flow 3: Medical Admissions  4 Flow 4: Surgical Admissions  5 Flow 5: Out of Hospital Care.

patient_flow_code

This field is the descriptive value relating to the patient flow code.

patient_flow_desc

This field represents how the patient reported his or her injury to A&E reception on arrival (e.g., CHEST PAIN, wrist injury, LEFT EYE INJURY).  It is a free-format text field.  chest pain  unwell  HEAD INJURY  ABDO PAIN.

Covid 19 Accident and Emergency Statistics

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin