Inpatient Admision Discharge Analysis

Overview

In order to create an Inpatient Admission Discharge Analysis with the Performance Toolkit you will have to import an episode-level data file that meets a certain set of specifications. This document will provide you with the necessary information to successfully set up such a file.

The setup of your file will look similar to the example extract below.

The next few bullet points form a short summary of the data set requirements; the following sections explain each point in more detail.

Data file format: comma-separated values (CSV)
Required columns

Hospital Name
Row Identifier
Admission Date & Time
Discharge Date & Time
Admission Type Code

Permisible column values of Hospital Name and Row Identifier are free text
Permissible column values of Admission Date & Time, Discharge Date & Time according to en-GB culture settings; definitions according to local definitions
Permissible column values of Admission Type Code according to ISD's SMR Data Dictionary
The data should include all admisions and discharges that occured during the week of interest

File Type

The Performance Toolkit only accepts comma-separated value files, referred to as CSV files. Most commonly you will set up your CSV file in one of two ways:

directly download the required extracts from your internal systems
save the data in an Excel workbook as a CSV file

You can follow this link to learn more about importing and exporting CSV files by using Microsoft Excel.

Data Columns

Description

The CSV file has to contain five columns in the order specified below. The permissible values for each column are either free text or defined in accordance with the SMR Data Dictionary, published by Information Services Scotland. The required columns are summarized in the table below.

Field Name	Description	Defined By
Hospital Name	Name of Hospital	Local
Row Identifier	Unique identification of data set row	Local
Admission Date & Time	Date and time of inpatient admission	Local
Discharge Date & Time	Date and time of dischage from hospital	Local
Admission Type Code	Inpatient admission category	SMR01

Several data quality checks will be executed upon import of the data file to the Performance Toolkit. Data rows that do not pass these checks will be highlighted and omitted from analysis. To correct invalid data items you are able to export your data set with additional columns that indicate whether the data rows have passed validation.

Admission Date & Time and Discharge Date & Time

The admission date & time is defined as the date and time on which an inpatient admission occurs.

The discharge date & time is defined as the date and time on which a patient is discharged from an episode of care.

The Performance Toolkit accepts DateTime values in any of the en-GB culture formats shown in the below table. You can follow this link to learn more about how to set a custom number format in Excel.

Excel Custom Format	Example Output
dd MMMM yyyy HH:mm	28 August 2014 12:28
dd MMMM yyyy H:mm	28 August 2014 12:28
dd MMMM yyyy hh:mm tt	28 August 2014 12:28 PM
dd MMMM yyyy h:mm tt	28 August 2014 12:28 PM
d MMMM yyyy HH:mm	28 August 2014 12:28
d MMMM yyyy H:mm	28 August 2014 12:28
d MMMM yyyy hh:mm tt	28 August 2014 12:28 PM
d MMMM yyyy h:mm tt	28 August 2014 12:28 PM
dd MMMM yyyy HH:mm:ss	28 August 2014 12:28:30
dd MMMM yyyy H:mm:ss	28 August 2014 12:28:30
dd MMMM yyyy hh:mm:ss tt	28 August 2014 12:28:30 PM
dd MMMM yyyy h:mm:ss tt	28 August 2014 12:28:30 PM
d MMMM yyyy HH:mm:ss	28 August 2014 12:28:30
d MMMM yyyy H:mm:ss	28 August 2014 12:28:30
d MMMM yyyy hh:mm:ss tt	28 August 2014 12:28:30 PM
d MMMM yyyy h:mm:ss tt	28 August 2014 12:28:30 PM
dd/MM/yyyy HH:mm	28/08/2014 12:28
dd/MM/yyyy H:mm	28/08/2014 12:28
dd/MM/yyyy hh:mm tt	28/08/2014 12:28 PM
dd/MM/yyyy h:mm tt	28/08/2014 12:28 PM
dd/MM/yy HH:mm	28/08/14 12:28
dd/MM/yy H:mm	28/08/14 12:28
dd/MM/yy hh:mm tt	28/08/14 12:28 PM
dd/MM/yy h:mm tt	28/08/14 12:28 PM
d/M/yy HH:mm	28/8/14 12:28
d/M/yy H:mm	28/8/14 12:28
d/M/yy hh:mm tt	28/8/14 12:28 PM
d/M/yy h:mm tt	28/8/14 12:28 PM
d.M.yy HH:mm	28.8.14 12:28
d.M.yy H:mm	28.8.14 12:28
d.M.yy hh:mm tt	28.8.14 12:28 PM
d.M.yy h:mm tt	28.8.14 12:28 PM
yyyy-MM-dd HH:mm	2014-08-28 12:28
yyyy-MM-dd H:mm	2014-08-28 12:28
yyyy-MM-dd hh:mm tt	2014-08-28 12:28 PM
yyyy-MM-dd h:mm tt	2014-08-28 12:28 PM
dd/MM/yyyy HH:mm:ss	28/08/2014 12:28:30
dd/MM/yyyy H:mm:ss	28/08/2014 12:28:30
dd/MM/yyyy hh:mm:ss tt	28/08/2014 12:28:30 PM
dd/MM/yyyy h:mm:ss tt	28/08/2014 12:28:30 PM
dd/MM/yy HH:mm:ss	28/08/14 12:28:30
dd/MM/yy H:mm:ss	28/08/14 12:28:30
dd/MM/yy hh:mm:ss tt	28/08/14 12:28:30 PM
dd/MM/yy h:mm:ss tt	28/08/14 12:28:30 PM
d/M/yy HH:mm:ss	28/8/14 12:28:30
d/M/yy H:mm:ss	28/8/14 12:28:30
d/M/yy hh:mm:ss tt	28/8/14 12:28:30 PM
d/M/yy h:mm:ss tt	28/8/14 12:28:30 PM
d.M.yy HH:mm:ss	28.8.14 12:28:30
d.M.yy H:mm:ss	28.8.14 12:28:30
d.M.yy hh:mm:ss tt	28.8.14 12:28:30 PM
d.M.yy h:mm:ss tt	28.8.14 12:28:30 PM
yyyy-MM-dd HH:mm:ss	2014-08-28 12:28:30
yyyy-MM-dd H:mm:ss	2014-08-28 12:28:30
yyyy-MM-dd hh:mm:ss tt	2014-08-28 12:28:30 PM
yyyy-MM-dd h:mm:ss tt	2014-08-28 12:28:30 PM
yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK	2014-08-28T12:28:30.0000000
yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK	2014-08-28T12:28:30.0000000
ddd, dd MMM yyyy HH':'mm':'ss 'GMT'	Thu, 28 Aug 2014 12:28:30 GMT
ddd, dd MMM yyyy HH':'mm':'ss 'GMT'	Thu, 28 Aug 2014 12:28:30 GMT
yyyy'-'MM'-'dd'T'HH':'mm':'ss	2014-08-28T12:28:30
yyyy'-'MM'-'dd HH':'mm':'ss'Z'	2014-08-28 12:28:30Z
dd MMMM yyyy HH:mm:ss	28 August 2014 12:28:30
dd MMMM yyyy H:mm:ss	28 August 2014 12:28:30
dd MMMM yyyy hh:mm:ss tt	28 August 2014 12:28:30 PM
dd MMMM yyyy h:mm:ss tt	28 August 2014 12:28:30 PM
d MMMM yyyy HH:mm:ss	28 August 2014 12:28:30
d MMMM yyyy H:mm:ss	28 August 2014 12:28:30
d MMMM yyyy hh:mm:ss tt	28 August 2014 12:28:30 PM
d MMMM yyyy h:mm:ss tt	28 August 2014 12:28:30 PM

Admission Type Code

The Admission Type is defined as “an inpatient is categorised as an emergency, urgent or routine inpatient admission except Maternity and Neonatal admissions. The appropriate admission category depends on the clinical condition of the patient as assessed by the receiving consultant.”

National Code	Value
10	Routine admission – no additional detail added
11	Routine elective (i.e. from waiting list as planned, excludes planned transfers)
12	Patient admitted on day of decision to admit, or following day, not for medical reasons, but because suitable resources are available
18	Planned transfers
19	Routine admission – type not known
20	Urgent admission – no additional detail added
21	Patient delay (for domestic, legal or other practical reasons)
22	Hospital delay (for administrative or clinical reasons e.g. arranging appropriate facilities, for tests to be carried out, specialist equipment, etc.)
30	Emergency admission – no additional detail added
31	Patient injury – self-inflicted (injury or poisoning)
32	Patient injury – road traffic accident (RTA)
33	Patient injury – home incident (incl. assault or accidental poisoning)
34	Patient injury – incident at work (incl. assault or accidental poisoning)
35	Patient injury – other injury (incl. assault or accidental poisoning other than in the home or work)
36	Patient non-injury (e.g. stroke, MI, ruptured appendix)
38	Other emergency admission (incl. emergency transfers)
39	Emergency admission – type not known
40	Other admission types, no additional detail added
42	Maternity admission (SMR02 only)
48	Other