Accident and Emergency Statistics. There are two types: episode and aggregate level data.

ADR  > NHS Tayside and Fife Accident & Emergency Dataset (PHS/National) @ 126

Accident and Emergency Statistics. The A&E datamart was established in June 2007 to monitor the compliance of each NHS Board against the 4 hour wait standard. In July 2010 the A&E data mart was extended further to collect items such as diagnosis, several injury fields and an alcohol involved flag, which will be used to identify whether the patient’s alcohol consumption was a factor in the attendance. The collection of the new fields has been driven by a variety of SG policy decisions and interest from a number of organisations. Although there is now the facility to submit these additional fields, they are still under development and PHS are working with the NHS Boards to support data collection and quality. There are two types of data submitted to the A&E datamart: episode and aggregate level data. All hospitals with Emergency Departments submit episode level data containing a detailed record for each patient attendance. Some smaller sites with minor injury units or community hospitals only submit aggregate files containing monthly summary attendance and compliance figures only. This is because they do not have the information systems and support to enable collection of detailed patient based information. Sites that submit episode level data account for around 94% of all attendances at A&E.

Scottish Health Data

PHS/ NHS Tayside & Fife

This field represents the date the patient arrived at A&E..

ARRIVAL_TIME_DATE

Accident and Emergency Statistics. The A&E datamart was established in June 2007 to monitor the compliance of each NHS Board against the 4 hour wait standard. In July 2010 the A&E data mart was extended further to collect items such as diagnosis, several injury fields and an alcohol involved flag, which will be used to identify whether the patient’s alcohol consumption was a factor in the attendance. The collection of the new fields has been driven by a variety of SG policy decisions and interest from a number of organisations. Although there is now the facility to submit these additional fields, they are still under development and ISD are working with the NHS Boards to support data collection and quality. There are two types of data submitted to the A&E datamart: episode and aggregate level data. All hospitals with Emergency Departments submit episode level data containing a detailed record for each patient attendance. Some smaller sites with minor injury units or community hospitals only submit aggregate files containing monthly summary attendance and compliance figures only. This is because they do not have the information systems and support to enable collection of detailed patient based information. Sites that submit episode level data account for around 94% of all attendances at A&E.

Accident and Emergency (ISD T+F)

This field represents the Completion Of Treatment Time and Date.

COT_TIME_DATE

This field represents the date and time of Discharge, Admission or Transfer.

DAT_TIME_DATE

This field represents the Health Board where treatment was received.  F NHS FIFE  T NHS TAYSIDE.

HB_TREATMENT_CODE

This field represents the description for HB_TREATMENT_CODE.

HB_TREATMENT_DESC

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

This field represents the description for TREATMENT_LOCATION_CODE.

TREATMENT_LOCATION_NAME

Sending Location is a five character alpha-numeric code used in data processing to identify the NHS organisation where an SMR submission has been sent from.  Sending Location is used in conjunction with the Episode Record Key and SMR record type to provide a unique code for each SMR record on the national file. .

SENDING_LOCATION_CODE

This field represents the marital statement of the patient  A     Never married nor registered civil partnership    B     Married    C     Registered civil partnership    D    Separated, but still married    E     Separated, but still in civil partnership    F     Divorced    G    Dissolved civil partnership    H     Widowed    J     Surviving civil partner    Y    Other    Z    Not known   .

PAT_MARITAL_STATUS_CODE

This field represents the description for PAT_MARITAL_STATUS_CODE.

PAT_MARITAL_STATUS_DESC

This field represents the current ethnicity classification (2011 Census categories).     Group A - White  1A     Scottish    1B     Other British    1C     Irish    1K     Gypsy/ Traveller    1L     Polish    1Z     Other white ethnic group    Group B - Mixed or multiple ethnic groups  2A     Any mixed or multiple ethnic groups    Group C - Asian, Asian Scottish or Asian British  3F     Pakistani, Pakistani Scottish or Pakistani British    3G     Indian, Indian Scottish or Indian British    3H     Bangladeshi, Bangladeshi Scottish or Bangladeshi British    3J     Chinese, Chinese Scottish or Chinese British    3Z     Other Asian, Asian Scottish or Asian British    Group D - African  4D     African, African Scottish or African British    4Y     Other African    Group E - Caribbean or Black  5C     Caribbean, Caribbean Scottish or Caribbean British    5D     Black, Black Scottish or Black British    5Y     Other Caribbean or Black    Group F - Other ethnic group  6A     Arab, Arab Scottish or Arab British    6Z     Other ethnic group    Group G - Refused/Not provided by patient  98     Refused/Not provided by patient    Group H - Not Known  99     Not Known  .

PAT_ETHNIC_GROUP_CODE

This field represents the description for PAT_ETHINC_GROUP_CODE.

PAT_ETHINC_GROUP_DESC

This field indicates whether the patient is dead.  Y Or N.

PAT_DEATH_INDICATOR

This field represents the patients date of death.

PAT_DATE_OF_DEATH

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 ARRIVAL_MODE_CODE.

ARRIVAL_MODE_DESC

This field represents one of a group of organisations, professionals and other individuals who make a referral to an A&E department.  01 Self referral  01A Self referral - Patient  01B          Associated Person eg. parent, friend, employer, neighbour.   02 Healthcare professional/service/organisation  02A Healthcare professional/service/organisation - GP  02B Healthcare professional/service/organisation - out of hours service  02C Healthcare professional/service/organisation - 999 emergency services  02D Healthcare professional/service/organisation - NHS24  02E Healthcare professional/service/organisation - Minor injuries unit  02F Healthcare professional/service/organisation - same hospital  02G Healthcare professional/service/organisation - other hospital  02H Healthcare professional/service/organisation - other healthcare professional  02J Healthcare professional/service/organisation - GP referral for admission  03 Local authority  03A Local authority - education  03B Local authority - social services  03C Local authority - police  03D Local authority - other local authority dept.  03E Local Authority - care/nursing home  04 Private professional/agency/organisation  04A Private - care/nursing home  05 Other agency  05A Other agency - prison/penal establishment  05B Other agency - judicial  05C Other agency - voluntary organisation  05D Other agency - armed forces  98 Other  99 Not known.

AE_REFERRAL_SOURCE_CODE

This field represents the description for AE_REFERRAL_SOURCE_CODE.

AE_REFERRAL_SOURCE_DESC

This field represents where the person was when the incident started.   This refers to the high level type of area, building or place where the injury event commenced.  01 Place of residence  01A Place of residence - home  01B Place of residence - residential institution  02 Transport area  02A Transport area - public highway, street or road  02B Transport area - other transport area  03 Business area (exl. Recreation & sports areas)  03A Business area - industrial or construction area  03B Business area - farm or other place of primary production  03C Business area - commercial area - non recreational  04 School, educational area  05 Sports & Recreational area  05A Sports & Recreational area - sports and athletic area  05B Sports & Recreational area - recreational area, cultural area or public building  05C Sports & Recreational area - countryside / open nature area  06 Medical service area/ healthcare area  98 Other specified  99 Not known.

PLACE_OF_INCIDENT_CODE

This field represents the description for PLACE_OF_INCIDENT_CODE.

PLACE_OF_INCIDENT_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 DISCHARGE_DESTINATION_CODE.

DISCHARGE_DESTINATION_DESC

This field represents the professionals, services or organisations a patient may be referred on to for the purpose of further investigation and/or ongoing care following an attendance at an A&E department.    01 - Clinic  01A A&E Clinic    01B Fracture Clinic    01Z Other Clinic    02 - Healthcare Professional/Service or Organisation  02A GP    02B Practice Nurse    02C Community Nurse Excludes Community Psychiatric Nurse   02D Specialist nurse    02E Physiotherapist    02F Other AHP    02G Dentist    02H Mental Health Service Includes Community Psychiatric Nurse   02J Community pharmacy    02Z Other    03 - Local Authority  03A Education    03B Social Work    03Z Other Includes Police   04 - Private Agency / Organisation  05 - Other Agency    Includes voluntary agency   06 - Drug/alcohol service    May be provided by health service, local authority, private or voluntary agency   98 - Other  99 - Not Known.

REFERRED_TO_1_CODE

This field represents the description for REFERRED_TO_1_CODE.

REFERRED_TO_1_DESC

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 for ATTENDANCE_CATEGORY.

ATTENDANCE_CATEGORY_DESC

This field represents the reason(s) for keeping the patient in the A&E department if the patient waited longer than 4 hours between arriving at the A&E department and admission, discharge or transfer.  00 - No Delay Patient's whose stay in A&E is < 4 hours   01 - Wait for a bed  02 - Wait for transport     Commissioned by A&E   03 - Wait for treatment - Refers to the initial A&E treatment  03A To commence    03B To be completed    05 - Wait for diagnostic test(s)  05A To be performed    05B Awaiting results Refers to results which will determine the next step in the patient journey   06 - Wait for first assessment  07 - Clinical reason(s)  In the judgement of the senior emergency department doctor and/ or nurse involved, the patient's condition mandates a stay in the emergency department of greater than four hours, i.e. where the patient is too ill to be moved     98 - Other reason (specify).

REASON_FOR_LONG_WAIT_CODE

This field represents the description for REASON_FOR_LONG_WAIT_CODE.

REASON_FOR_LONG_WAIT_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 represents the description for PATIENT_FLOW_CODE.

PATIENT_FLOW_DESC

This field represents the main complaint that that the patient presents with at the Emergency Department.

AE_PRESENTING_COMPLAINT_TEXT

This field represents a subjective judgement about whether or not the person’s alcohol consumption constituted a factor in this attendance at the Emergency Department.    01 Yes  02 No.

ALCOHOL_INVOLVED_CODE

This field represents the description for ALCOHOL_INVOLVED_CODE.

ALCOHOL_INVOLVED_DESC

This field represents the category assigned to a patient as a result of an initial assessment by medical or nursing staff in an A&E department.  00 Not triaged  01 Immediate resuscitation  02 Very urgent  03 Urgent  04 Standard  05 Non-urgent.

TRIAGE_CATEGORY_CODE

This field represents the description for TRIAGE_CATEGORY_CODE.

TRIAGE_CATEGORY_DESC

This field represents a retrospective classification of the patient according to the clinical management received during their A&E attendance.  01     Resuscitation Patients underwent resuscitation, regardless of outcome   02     Major Patients required a longer period of assessment and observation in addition to diagnostics and treatment   03     Minor Patients treated and discharged relatively quickly and who may have had straightforward diagnostic assessment eg.           Single plain X-ray   99     Not Known  .

PAT_MGT_CATEGORY_CODE

This field represents the description for PAT_MGT_CATEGORY_CODE.

PAT_MGT_CATEGORY_DESCRIPTION

This field represents the time since the event.  01 Up to 6 hours  02 6 to 12 hours  03 12 to 24 hours  04 24 to 48 hours  05 Over 48 hours.

TIME_BAND_SINCE_EVENT_CODE

This field represents the description for TIME_BAND_SINCE_EVENT_CODE.

TIME_BAND_SINCE_EVENT_DESC

This field represents the bodily location of the injury chiefly responsible for occasioning the attendance of the person at the health care facility.  00      None  01        Intracranial/brain  01A      Focal  01B      Diffuse  01C      Extradural  01D      Subdural  01Z       Other intracranial  02         Head  02A      Scalp  02B      Frontal  02C      Parietal  02D      Occipital  02E      Temporal  02F       Cranial nerves  02Z       Other head  03         Face  03A      Orbit  03B      Maxilla  03C      Zygoma  03D      Cheek  03E      Upper lip  03F       Lower lip  03G      Temporomandibular joint  03H       Mandible  03Z       Other face  04         Eye  04A      Upper eyelid  04B      Lower eyelid  04C      Periorbital area  04D      Cornea  04E      Sclera  04F       Conjunctiva  04G      Lens  04H      Intraorbital tissue  04Z       Other eye  05         Nose  05A      Skin  05B      Nasal bones  05C      Nasal septum  05D      Nasal cavity  05Z       Other nose  06         Ear  06A      Pinna  06B      Lobe  06C      Ear canal/external auditory canal  06D      Ear drum/tympanic membrane  06E      Middle ear  06F       Inner ear  06Z       Other ear  07         Oral cavity  07A      Oral mucosa  07B      Tongue  07C      Teeth  07D      Tonsil  07E      Epiglottis  07F       Uvula  07G      Gingiva  07H      Palate  07J       Vallecula  07Z       Other oral cavity  08         Neck  08A      Skin and superficial area  08B      Larynx and trachea  08C      Oesophagus (cervical)  08D      Blood vessels  08E      Vertebra/spine (cervical)  08F       Cervical cord  08G      Brachial plexus  08Z       Other neck  09         Thorax  09A      Skin and superficial fascia  09B      Front wall of chest  09C      Back wall of chest  09D      Breast  09E      Ribs  09F      Sternum  09G      Vertebrae/spine (thoracic)  09H      Spinal cord (thoracic)  09J       Major blood vessels  09K      Heart and pericardium  09L       Oesophagus (thoracic)  09M      Trachea (thoracic)  09N      Bronchus  09P      Lungs  09Q      Diaphragm  09Z       Other thorax  10         Abdomen  10A      Skin  10B      Abdominal wall  10C      Stomach  10D      Small bowel  10E      Large bowel  11         Back  11A      Skin  11B      Buttocks  11C      Lumbar spine  11D      Lumbar spinal cord  11E      Nerves of lumbar plexus  11Z       Other back  12         Genitalia / Reproductive organs  12A      Foreskin  12B      Penis  12C      Testes  12D      Scrotum  12E      Vulva  12F       Vagina  12G      Uterus & adnexa  12Z       Other genitalia  13         Anorectal  13A      Rectum  13B      Anus  14         Pelvis  14A      Sacrum  14B      Coccyx  14C      Sacro-iliac joint  14D      Pubic ramus  14E      Ilium  14F      Acetabulum  14G      Pubic symphysis  14H      Cauda equina  14Z       Other pelvis  15         Shoulder  15A      Skin  15B      Clavicle  15C      Scapula  15D      Head of humerus  15E      Neck of humerus  15F      Tuberosity of humerus  15G      Shoulder joint  15H      Acromioclavicular joint  15J       Sternoclavicular joint  15K      Sub-acromial bursa  15L       Rotator cuff  15M      Deltoid  15N      Other muscle  15Z       Other shoulder  16         Axilla  16A      Skin  16B      Axillary blood vessels  16C      Nerves  16Z      Other axilla  17         Upper arm  17A      Skin  17B      Shaft of humerus  17C      Distal end of humerus  17D      Radial nerve  17E      Blood vessels  17F       Biceps  17G      Triceps  17H      Other muscle  17Z       Other upper arm  18         Elbow  18A      Skin  18B      Supracondylar  18C      Lateral epicondyle  18D      Medial epicondyle  18E      Head of radius  18F       Neck of radius  18G      Olecranon  18H      Elbow joint  18J       Biceps tendon  18K      Nerves  18L       Blood vessels  18Z       Other elbow  19         Forearm  19A      Skin  19B      Radius  19C      Ulna  19D      Radius and ulna  19E      Nerves  19F       Blood vessels  19G      Muscles / tendons  19Z       Other forearm  20         Wrist  20A      Skin  20B      Radius  20C      Ulna  20D      Radius and ulna  20E      Tubercle of scaphoid  20F       Scaphoid  20G      Other carpal bones  20H      Carpal ligaments  20J       Wrist joint  20K      Nerves  20L       Artery  20M      Tendons  20Z       Other wrist  21         Hand  21A      Skin of dorsum  21B      Skin of palm  21C      Metacarpal  21D      Metacarpophalangeal joint  21E      Other carpal bones  21F       Carpometacarpal joint  21G      Nerves  21H      Artery  21J       Muscles  21Z       Other hand  22         Thumb  22A      Distal phalanx  22B      Interphalangeal joint  22C      Proximal phalanx  22D      Metacarpophalangeal joint  22E      Metacarpal  22F       Carpometacarpal joint  22G      Trapezium  22H      Muscles  22J       Artery  22K      Nerves  23         Finger  23A      Index finger  23B      Middle finger  23C      Ring finger  23D      Little finger  23E      Digital arteries  23F       Digital nerves  24         Hip  24A      Skin  24B      Neck of femur  24C      Trochanter  24D      Hip joint  25         Thigh  25A      Skin  25B      Shaft of femur  25C      Distal end of femur  25D      Muscles  25E      Blood vessels  25F      Nerves  25Z      Other thigh  26         Knee  26A      Skin  26B      Patella  26C      Femoral condyle  26D      Proximal end of tibia  26E      Knee joint  26F       Ligaments  26G      Cartilage  26H      Medial meniscus  26J       Lateral meniscus  26K      Nerves  26L       Blood vessels  26M      Quadriceps tendon  26Z       Other knee  27         Lower leg  27A      Skin  27B      Tibia  27C      Fibula  27D      Tibia and fibula  27E      Achilles tendon  27F       Muscles  27G      Blood vessels  27H      Nerves  27Z       Other lower leg  28         Ankle  28A      Skin  28B      Ligaments  28C      Lateral malleolus  28D      Medial malleolus  28E      Talus  28F       Ankle joint  28Z       Other bones  29         Foot  29A      Skin  29B      1st metatarsal  29C      2nd metatarsal  29D      3rd metatarsal  29E      4th metatarsal  29F       5th metatarsal shaft /neck / head  29G      5th metatarsal base  29H      Calcaneus  29J       Other bones  29K      Joints  29L       Blood vessels  29M      Tendons / muscles  29N      Nerves  30         Toes  30A      Big toe  30B      2nd toe  30C      3rd toe  30D      4th toe  30E      5th toe  31         Multiple body regions.

BODILY_LOCATION_OF_INJURY_CODE

This field represents the description for BODILY_LOCATION_OF_INJURY_CODE.

BODILY_LOCATION_OF_INJURY_DESC

The nature of the injury chiefly responsible for occasioning the attendance of the person at the health care facility.  NULL NULL  00 None  01 Wound  01A Abrasion  01B Contusion  01C Blisters  01D Laceration  01E Incision  01F Needlestick  01G Bite - animal  01H Bite - human  01J Bite/sting - insect  01K Flap laceration  01L Degloving wound  01M Penetrating wound  01N Skin avulsion  01Z Other  02 Bone and joint injury  02A Closed fracture  02B Open fracture  02C Dislocation of joint  02D Fracture dislocation  03 Soft tissue injury  03A Crush injury  03B Ligament avulsion  03C Ligament tear  03D         Ligament rupture  03E         Ligament strain  03F         Muscle avulsion  03G Muscle tear  03H Muscle rupture  03J Muscle strain  03K          Tendon dislocation  03L Tendon rupture  03M         Tendon subluxation  03N         Tendon strain  03P Tendon division  03Q          Neuropraxia  03R          Nerve complression  03S Complete transaction of nerve  03T Partial division of nerve  03U Nerve contusion  03V          Nerve entrapment  03Z Other Soft tissue injury  04 Head injury  04A Concussion  04B Extradural haemorrhage  04C Subdural haemorrhage  04D         Traumatic Cerebal oedema  04Z Other head injury  05 Dental injury  05A Avulsion  05B Fracture  05Z Other dental injury  06 Vascular injury  06A         Arterial haemorrhage    06B         Arterial contusion    06C         Arterial avulsion    06D         Arterial perforation    06E         Arterial rupture    06F         Arterial transection    06G        Venous haemorrhage    06H        Venous contusion    06J         Venous avulsion    06K        Venous rupture    06L        Venous transaction    06Z       Other vascular   07 Visceral injury  07A         Traumatic haemothorax    07B         Traumatic pneumothorax    07C         Pulmonary contusion    07D        Traumatic haemopneumothorax    07E        Traumatic haemopericardium    07F         Cardiac contusion    07G        Pneumomediastinum    07H        Rupture Refer bodily location for specific visceral organs   07J         Perforation Refer bodily location for specific visceral organs   07K        Avulsion Refer bodily location for specific visceral organs   08 Burn  08A 1st Degree/ Superficial  08B 2nd Degree/ Partial thickness  08C 3rd Degree/ Full thickness  09 Scald  10            Corrosion    10A         1st Degree    10B         2nd Degree    10C         3rd Degree    11           Injury related to heat exposure    11A         Heat rash Heat rash is a skin irritation caused by excessive sweating during hot, humid weather   11B         Heat cramps Painful muscle spasms in the abdomen, arms, or legs following strenuous activity. Often are caused by a                        lack of salt in the body   11C         Heat exhaustion A warning that the body is getting too hot. The body temperature is usually normal and the pulse is                         normal or raised   11D         Heat/sunstroke Heat stroke occurs when the body becomes unable to control its temperature. Can be life threatening   11Z          Other injuries related to heat exposure    12 Hypothermia  13            Frostbite    13A         Superficial    13B         With tissue necrosis    13Z         Other frostbite  14 Poisoning  15 Electric shock  16 Multiple injuries  98 Other nature of injury.

AE_NATURE_OF_INJURY_CODE

This field represents the description for  AE_NATURE_OF_INJURY_CODE.

AE_NATURE_OF_INJURY_CODE_DESC

This field represents the event, circumstance or condition associated with the occurrence of injury, poisoning or violence.  00 - None     01 - Transport  02 - Falls  03 - Poisons & drugs   04 - Thermal  05 - Contact with object or animal  06 - Contact with person  07 - Crushing force  08 - Piercing/penetrating force  09 - Mechanical threat to breathing  10 - Drowning/near drowning  11 - Foreign body  12 - Complication of medical/surgical care  98 - Other external cause  99 - Not known  .

EXTERNAL_CAUSE_OF_INJURY_CODE

This field represents the description for EXTERNAL_CAUSE_OF_INJURY_CODE.

EXTERNAL_CAUSE_OF_INJURY_DESC

This field represents the role of human intent in the occurrence of the injury as assessed by the treating practitioner.  01      Unintentional Includes accidental injury event. Injuries to children under age five years who harm themselves should be                   regarded as unintentional, except in the case of a child who bangs his or her head in anger or frustration. Includes injuries                  resulting from animal attacks, unless the animal was used as a weapon by a person intent on inflicting injury.  02      Deliberate self-harm    02A    Self-mutilation    02B    Child intentional self-harm Includes injuries to children under age five years who harm themselves by banging his or her head            in anger or frustration.   02C    Attempted suicide Includes suicide, parasuicide (incomplete suicide attempt)   02Z    Other self-harm    03      Assault    03A    Sexual    03B     Use of bodily force Excludes sexual assault   03C     By use of objects /substances Objects/substances involved in producing injury   03D     Indirect involvement Includes injuries sustained by a bystander to a violent event, or by a non-combatant in a conflict.   03Z     Other    98       Other intent    98A     Legal/political Includes legal intervention, operations of war, terrorism or civil conflict.   98B     Complications of medical or surgical care Only if relevant to nature of injury   98Z     Other Includes euthanasia   99       Not known Includes unspecified intent and injury resulting from unknown event .

INTENT_OF_INJURY_CODE

This field represents the description for INTENT_OF_INJURY_CODE.

INTENT_OF_INJURY_DESC

This field represents the type of activity the injured person was engaged in when the injury occurred.  The codes are:  01            Work  01A Work - Paid  01B Work - Unpaid  02 Education  03 Organized sports  04 Leisure play, exercise or physical activity  05 Travelling  05A Travelling - Work related  05B          Travelling - Commuting  05Z          Travelling - Other  98            Other specified activity  98A Vital Activity  98B Being taken care of  98C Religious/spiritual activities  98D General home activities not elsewhere classified  99 Not known.

ACTIVITY_WHEN_INJURED_CODE

This field represents the description for ACTIVITY_WHEN_INJURED_CODE.

ACTIVITY_WHEN_INJURED_DESC

This field represents the broad coding of types of procedure which may be performed upon a patient during attendance at an A&E department.  00 - None  01 - Wound care   01A Toilet only    01B Debridement    01C Removal of foreign material    01D Dressing    01E Wound closure    01Z Other wound care    02 - Burn care  02A Toilet only    02B Debridement    02C Removal of slough    02D Dressing    02Z Other burn care    03 - Limb immobilisation  03A Plaster immobilisation    03B Splint immobilisation    03Z Other limb immobilisation    04 - Procedure on bones & joints  04A Reduction of dislocation    04B Manipulation of fracture    04C Joint aspiration / injection    04Z Other procedure on bones & joints    05 - Airway management  05A Nasopharyngeal airway    05B Laryngeal mask    05C Intubation    05D Surgical airway    05Z Other airway management    06 - Ventilation  06A Manual    06B Mechanical    07 - Circulatory support  07A External cardiac massage    07B Cardio-version including defibrillation    07C Temporary pacing    07D Fluid resuscitation    07E Blood transfusion    07Z Other circulatory support    08 - Vascular access  08A Central venous access (including femoral)    08B Arterial line    08C Intra-osseous access    08Z Other vascular access    09 - Pleural cavity procedures  09A Aspiration    09B Insertion of chest drain    09Z Other pleural cavity procedures    10 - Decontamination  11 - Other specific procedures  11A Removal of foreign body from orifice    11B Gastric lavage    11C Urinary catheterisation    11D Incision & drainage    98 - Other  99 - Not Known.

PROCEDURE_1_CODE

This field represents the description for PROCEDURE_1_CODE.

PROCEDURE_1_DESC

PROCEDURE_2_CODE

This field represents the description for PROCEDURE_2_CODE.

PROCEDURE_2_DESC

PROCEDURE_3_CODE

This field represents the description for PROCEDURE_3_CODE.

PROCEDURE_3_DESC

This field represents the working diagnosis(es) on discharge from A&E, or where no working diagnosis is made, the main symptom, abnormal finding, or problem.  00    Nothing abnormal detected    01    Trauma/ injury/ poisoning Refer to Injury Surveillance Dataset   02    Alcohol &/or substance use problems    03    Cardiovascular    04    Dental Does not include dental injury - refer to Injury Surveillance Dataset   05    Dermatology Does not include skin injury - refer to Injury Surveillance Dataset   06    Endocrine/metabolic    07    ENT Does not include foreign bodies - refer to Injury Surveillance Dataset   08    Gastrointestinal    09    Gynaecological  10    Haematology    11    Infection It may be necessary to notify communicable diseases.Excludes infections specific to particular anatomical site or                 physiological system, e.g. skin, respiratory system.  12    Musculoskeletal    13    Neurology    14    Obstetrics    15    Ophthalmology Does not include foreign bodies or eye injury - refer to Injury Surveillance Dataset   16    Psychiatry    17    Respiratory    18    Genito-urinary    19    Social circumstances    99    Diagnosis not known  .

DIAGNOSIS_1_CODE

This field represents the description for DIAGNOSIS_1.

DIAGNOSIS_1_DESC

This field represents a free text description of diagnosis e.g. 'Foreign body in ear', 'PSYCHOTIC ILLNESS'.  Sometimes this is populated when CODE and DESC are not.

DIAGNOSIS_1_TEXT

DIAGNOSIS_2_CODE

This field represents the description for DIAGNOSIS_2.

DIAGNOSIS_2_DESC

DIAGNOSIS_2_TEXT

DIAGNOSIS_3_CODE

This field represents the description for DIAGNOSIS_3.

DIAGNOSIS_3_DESC

DIAGNOSIS_3_TEXT

This field represents the Disease/ailment of the patient  This code is a ICD10 code..

DISEASE_1_CODE

This field represents the description for  DISEASE_1_CODE .

DISEASE_1_DESC

DISEASE_2_CODE

This field represents the description for DISEASE_2_CODE.

DISEASE_2_DESC

DISEASE_3_CODE

This field represents the description for DISEASE_3_CODE.

DISEASE_3_DESC

This field represents the time in minutes before patient was treated.    Note that there is also an (unreleased) field called WAIT_TO_ASSESSMENT_MIN which appears to be unpopulated..

NHS Tayside and Fife Accident & Emergency Dataset (PHS/National)

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin