The Rapid Preliminary Inpatient Data (RAPID) dataset contains the underlying admissions data which is used by System Watch. It enables access to the hospital admissions data  submitted in its unprocessed state e.g. it does not contain predictions.

MDW Discover  > RAPID (Hospital Stay Level Data) @ 58

MDW Discover

Browse All

London SDE

West Midlands SDE

Kent, Medway & Sussex SDE

MDW - Discover

https://publichealthscotland.scot/services/data-research-and-innovation-services/electronic-data-research-and-innovation-service-edris/overview/what-is-edris/

The data collection known as "System Watch" was developed in 2001 to meet the requirements of the System Watch product, which monitors and predicts emergency admissions and bed occupancy in mainland NHS Boards. The data collection is now known as "RAPID". The data collected are management information and have very limited validation.

HDR UK

None

Main OPCS3/OPCS4 code for the operation/procedure carried out on the individual representing the code responsible for the greatest use of resource

OPERATION_1A_CODE

RAPID

DISCHARGE_DATE

SHORT FORM DESCRIPTION OF THE TYPE OF LOCATION, EG. GPPRA -> GP PRACTICE, HOSP -> HOSPITAL. PART OF THE NATURAL KEY ALONG WITH LOCATION CODE.

GP_PRACTICE_LOCATION_TYPE

THE LOCATION CODE. UNIQUE TO A LOCATION FOR CERTAIN LOCATION TYPES BUT NOT FOR OTHERS (EG. GP PRACTICES AND DENTAL PRACTICES CAN HAVE THE SAME CODE). PART OF THE NATURAL KEY IN CONJUNCTION WITH LOCATION TYPE.

HOSPITAL_OF_TREATMENT_LOCATION_CODE

The description, i.e. name of the Significant Facility, which is a type of clinical facility, identified for clinical and/or costing purposes.

WARD_SIGNIFICANT_FACILITY_DESCRIPTION

CIS_LENGTH_OF_STAY

ADMISSION_DATE

Current configuration health board code aka cypher. This is a candidate natural key for each territorial health board, however only some special boards have codes and some have none.

HEALTH_BOARD_OF_RESIDENCE_CODE_CURRENT

OPERATION_3B_CODE

Diagnosis description associated with code specified at aggregated 4-character level representing the code responsible for the greatest use of resource

DIAGNOSIS_1_DESCRIPTION

DISCHARGE_TIME

THE NAME/DESCRIPTION OF THE LOCATION (TYPE 1 - CURRENT)

SENDING_LOCATION_NAME

OPERATION_2A_CODE

Name describing the specialty.  A specialty is a division of medicine covering a specific area of clinical activity and identified within one of the Royal Colleges or Faculties.  For a complete list of specialties, please see: http://www.datadictionaryadmin.scot.nhs.uk/isddd/9751.html.<br><br>\n\nThis classification only became applicable to SMR1/SMR01 records from 1 April 1997 onwards.  For discharges prior to this date this field is NULL.  For records admitted prior to this date and where the patient is still considered to be a resident (i.e. no discharge date available), a mapping has been applied to assign a specialty based on the consultant responsible for the care of the patient.

SPECIALTY_DESCRIPTION

Diagnosis code specified at aggregated 4-character level representing the code responsible for the greatest use of resource

DIAGNOSIS_6_CODE_4CHAR

A two-character code representing Discharge Transfer To which categorises the destination following discharge, or type of location, to which a patient has been discharged. This item is only applicable to discharges from 1 April 1997.

DISCHARGE_TRANSFER_TO_TYPE

OPERATION_4A_CODE

GP_PRACTICE_NHS_BOARD_NAME_CURRENT

DIAGNOSIS_5_DESCRIPTION

Main OPCS3/OPCS4 code description for the operation/procedure carried out on the individual representing the code responsible for the greatest use of resource

OPERATION_2A_DESCRIPTION

The description i.e. name, of the Management of Patient i.e. the patient type and the pattern of bed use of a patient.  In summary, it distinguishes inpatient from day case care.   This item is only applicable to discharges from 1 April 1997.

MANAGEMENT_OF_PATIENT_DESCRIPTION

A two-character code representing Admitted Transfer From which categorises the source of admission, or type of location, from which a patient has been admitted. This item is only applicable to discharges from 1 April 1997.

ADMITTED_TRANSFER_FROM_TYPE

OPERATION_3A_DESCRIPTION

OPERATION_4B_CODE

OPERATION_1B_CODE

Gender code for the patient
M = Male
F = Female

PATIENT_GENDER_CODE

A two-character code representing the Significant Facility which is a type of clinical facility, identified for clinical and/or costing purposes.

WARD_SIGNIFICANT_FACILITY

OPERATION_1A_DESCRIPTION

The description, i.e., name of the Admitted Transfer From Code, which categorises the source of admission, or type of location, from which a patient has been admitted.  This item is only applicable to discharges from 1 April 1997.

ADMITTED_TRANSFER_FROM_DESCRIPTION

DIAGNOSIS_4_CODE_4CHAR

Natural Key. The postcode formatted to 7 digits using standard format postcode function.

POSTCODE

ADMISSION_TIME

HOSPITAL_OF_TREATMENT_LOCATION_TYPE

PSEUDO-ANONYMISED ID NUMBER

DIAGNOSIS_2_CODE_4_CHAR

Maximum three character code representing the specialty.  A specialty is a division of medicine covering a specific area of clinical activity and identified within one of the Royal Colleges or Faculties.  For a complete list of specialties, please see: http://www.datadictionaryadmin.scot.nhs.uk/isddd/9751.html<br><br>\n\nThis classification only became applicable to SMR1/SMR01 records from 1 April 1997 onwards.  For discharges prior to this date this field is NULL.  For records admitted prior to this date and where the patient is still considered to be a resident (i.e. no discharge date available), a mapping has been applied to assign a specialty based on the consultant responsible for the care of the patient.

SPECIALTY

DIAGNOSIS_1_CODE_4_CHAR

A two-character code representing the Inpatient Day Case Identifier, which indicates whether the patient was treated as an inpatient or a day case.\nSystem Watch currently only deals with Inpatient records, however it is possible that this will be extended in the future to cover day cases.

INPATIENT_DAYCASE_IDENTIFIER_CODE

Y or N flag indicating if the episode related to an emergency admission.

EMERGENCY_ADMISSION_FLAG

SENDING_LOCATION_CODE

OPERATION_4A_DESCRIPTION

GP_PRACTICE_LOCATION_NAME

The description, i.e. name, of the Inpatient Day Case Identifier, which indicates whether the patient was treated as an inpatient or a day case.\nSystem Watch currently only deals with Inpatient records, however it is possible that this will be extended in the future to cover day cases.

INPATIENT_DAYCASE_IDENTIFIER_DESCRIPTION

The description, i.e., name of the Discharge Type, which categorises, generally, whether the patient was discharged regularly, irregularly or because of death.  This item is only applicable to discharges from 1 April 1997.

DISCHARGE_TYPE_DESCRIPTION

LEGACY - retained to support existing applications. Source data is no longer updated.

SIMD_SCOTLAND_DECILE

Date of Birth is the patient's full date of birth (derived from their CHI record).

PATIENT_DOB_DATE

NUMBER_OF_STAYS

OPERATION_2B_CODE

Current configuration Health and Social Care Partnership (HSCP) name

HSCP_OF_RESIDENCE_NAME_CURRENT

OPERATION_3B_DESCRIPTION

OPERATION_3A_CODE

CURRENT CONFIGURATION HEALTH BOARD 9-DIGIT CODE.

GP_PRACTICE_NHS_BOARD_CODE

DIAGNOSIS_5_CODE_4CHAR

Current configuration Health and Social Care Partnership (HSCP) 9 digit code

HSCP_OF_RESIDENCE_CODE_CURRENT

PATIENT_GENDER_DESCRIPTION

DIAGNOSIS_4_DESCRIPTION

The date on which a file extract occurs in an NHS Board. For stay-level records, the extract date will be the extract date for the latest episode in the stay.

EXTRACT_DATE

A grouping of Specialty Code into
1 (SURGICAL)
2 (MEDICAL)
3 (PAEDIATRICS)
Also includes a group 0 (OTHER) for non System-Watch specialties

SPECIALTY_GROUP

DIAGNOSIS_3_DESCRIPTION

OPERATION_4B_DESCRIPTION

CURRENT CONFIGURATION SUB HEALTH BOARD NAME

HOSPITAL_OF_TREATMENT_NHS_BOARD_NAME_CURRENT

OPERATION_1B_DESCRIPTION

A one-character code representing the Management of Patient i.e. the patient type and the pattern of bed use of a patient.  In summary, it distinguishes inpatient from day case care.   This item is only applicable to discharges from 1 April 1997.

MANAGEMENT_OF_PATIENT

A two character code representing the Discharge Type which categorises, generally, whether the patient was discharged regularly, irregularly or because of death.  This item is only applicable to discharges from 1 April 1997.

DISCHARGE_TYPE

CURRENT CONFIGURATION SUB HEALTH BOARD CODE. SUB HEALTH BOARD IS DEPRECATED PAST 1ST APRIL 2014 AND IS THEREAFTER SYNONYMOUS WITH THE HEALTH BOARD CODE

HOSPITAL_OF_TREATMENT_NHS_BOARD_CODE_CURRENT

A two-character code representing the Admission Type, which categorises, generally, whether the patient was admitted routinely, urgently or as an emergency.

ADMISSION_TYPE

DIAGNOSIS_2_DESCRIPTION

The description, i.e., name of the  Discharge Transfer To which categorises the destination following discharge, or type of location, to which a patient has been discharged. This item is only applicable to discharges from 1 April 1997.

DISCHARGE_TRANSFER_TO_DESCRIPTION

DIAGNOSIS_6_DESCRIPTION

DIAGNOSIS_3_CODE_4_CHAR

Indicates whether the hospital where the episode of treatment took place is considered 'large' i.e. treats a substantial number of patients

HOSPITAL_OF_TREATMENT_LARGE_HOSPITAL

OPERATION_2B_DESCRIPTION

SIMD_SCOTLAND_QUINTILE

HOSPITAL_OF_TREATMENT_LOCATION_NAME

GP_PRACTICE_LOCATION_CODE

A numerical marker which is unique per patient per stay.

For example, all the individual episodes within a single stay will have the same CIS Marker.

CIS_MARKER

The description, ie. name of the Admission Type which categorises, generally, whether the  patient was admitted routinely, urgently or as an emergency.

ADMISSION_TYPE_DESCRIPTION

Age on Admission (years) records the difference in full years from the patient's date of birth to their date of admission.  This field is more usually just referred to as "age".

AGE_ON_ADMISSION

SIMD_SCORE

This dimension object allows users to report on stay based measures (e.g. the number of stays) by the length of stay. In this context is behaves slightly differently to the Length of Stay measure, which will be the same for a single stay, however the measure will give the aggregate sum length when dealing with more than one stay.

STAY_LENGTH

The data collection known as 'System Watch' was developed in 2001 to meet the requirements of the System Watch product, which monitors and predicts emergency admissions and bed occupancy in mainland NHS Boards. The data collection is now known as 'RAPID'. The data collected are management information and have very limited validation.

RAPID (Hospital Stay Level Data)

Documentation

Coverage

Provenance

Origin

Temporal

Accessibility

Access

Usage

Format and Standards

Observations

Origin