: Record Table 1065

Record Table 1065

Title:	HES inpatient critical care
Access field:	41290 (Records in HES inpatient critical care dataset)

Table name

hesin_critical

Table group

HES

Debut

May 2020

Row count

37,000+

Parent table

hesin

Version

Mar 2023

Size

3MB

Stability

Ongoing

Cost Tier

d1 o1 s1

29 Columns

#	Column	Type	Notes
1	eid	integer	Encoded participant identifier. This identifier is the same encoded id used in the main dataset.
2	ins_index	integer	Instance index. A numerical index which together with the eid uniquely identifies the corresponding record in the main HESIN table.
3	arr_index	integer	Array index. A numerical index which together with the eid and ins_index uniquely identifies this record, i.e. eid, ins_index and arr_index together form a primary key for this table.
4	dsource	string, coding 1970	Critical care record origin. Currently only HES (England).
5	source	integer, coding 263	Critical care record format. A finer split of the format of data released from each dsource. Currently only 60.
6	ccstartdate	date	Date on which the critical care period started.
7	ccadmitype	integer, coding 7003	Critical care admission type. Whether a critical care period was initiated as a result of a non-emergency treatment plan, for example, for non-elective surgery. This relates only to the period of critical care and not to the nature of the hospital admission.
8	ccadmisorc	integer, coding 7004	Source of admission to critical care. Whether the patient originated from the same or a different NHS hospital, an independent hospital provider, a non-hospital UK source, or a non-UK source.
9	ccsorcloc	integer, coding 7005	Location of the source of admission. The type of location the patient was in prior to the start of the critical care period.
10	ccdisdate	date	Date of discharge from critical care. Discharge date from unit if alive, date of death or date of declaration of brain stem death.
11	ccdisrdydate	date	Ready-to-discharge date from critical care. The date on which the patient has been declared clinically ready for discharge or transfer from the clinical care period.
12	ccdisstat	integer, coding 7009	Critical care discharge status. The patient status at time of discharge, for example whether they were fully ready for discharge, whether their discharge was early or delayed, whether they self-discharged, or whether they died rather than being discharged (and their organ-donor status if so).
13	ccdisdest	integer, coding 7010	Critical care discharge destination. Whether the patient was discharged to the same or a different NHS hospital, an independent hospital provider, a non-hospital UK destination or to a non-UK source, or whether the patient died in the unit.
14	ccdisloc	integer, coding 7011	Critical care discharge location. The principal location that the patient was discharged to for further care at the end of the critical care period.
15	ccapcrel	integer, coding 7012	Critical care APC relationship id. A comparison of the dates of the critical care period and those of the associated admitted patient care episode.
16	bressupdays	integer, coding 7006	Basic respiratory support days. Number of days of basic respiratory support. For the definition of basic respiratory support see Resource 141140 or the NHS CC Data Dictionary.
17	aressupdays	integer, coding 7006	Advanced respiratory support days. Number of days of advanced respiratory support. For the definition of advanced respiratory support see Resource 141140 or the NHS CC Data Dictionary.
18	bcardsupdays	integer, coding 7006	Basic cardiovascular support days. Number of days of basic cardiovascular support. For the definition of basic cardiovascular support see Resource 141140 or the NHS CC Data Dictionary.
19	acardsupdays	integer, coding 7006	Advanced cardiovascular support days. Number of days of advanced cardiovascular support. For the definition of advanced cardiovascular support see Resource 141140 or the NHS CC Data Dictionary.
20	rensupdays	integer, coding 7006	Renal support days. Number of days of renal support in the context of critical illness. For the definition of renal support see Resource 141140 or the NHS CC Data Dictionary.
21	neurosupdays	integer, coding 7006	Neurological support days. Number of days of neurological support. For the definition of neurological support see Resource 141140 or the NHS CC Data Dictionary.
22	gisupdays	integer, coding 7006	Gastrointestinal support days. Number of days of gastrointestinal support. For the definition of gastrointestinal support see Resource 141140 or the NHS CC Data Dictionary.
23	dermsupdays	integer, coding 7006	Dermatological support days. Number of days of dermatological support. For the definition of dermatological support see Resource 141140 or the NHS CC Data Dictionary.
24	liversupdays	integer, coding 7006	Liver support days. Number of days of liver support. For the definition of liver support see Resource 141140 or the NHS CC Data Dictionary.
25	orgsupmax	integer	Organ support maximum. Maximum number of organ systems supported at any one time, at any point in the critical care period (note that both basic and advanced categories cannot be counted at the same time). This may not be the same as the total number of organs supported throughout the critical care admission. The minimum for this variable is 0 and the maximum is 7.
26	cclev2days	integer, coding 7006	Critical care level 2 days. Total calendar days during which level 2 care alone was provided during the period.
27	cclev3days	integer, coding 7006	Critical care level 3 days. Total calendar days during which level 3 care alone was provided during the period.
28	ccunitfun	integer, coding 7001	Critical care unit function. The type of area to which the patient was admitted during a critical care period. This is the principal clinical service provided within the ward.
29	unitbedconfig	integer, coding 7002	Critical care unit bed configuration. The composition of bed types for the critical care unit.

Column

Type

Notes

eid

integer

Encoded participant identifier. This identifier is the same encoded id used in the main dataset.

ins_index

integer

Instance index. A numerical index which together with the eid uniquely identifies the corresponding record in the main HESIN table.

arr_index

integer

Array index. A numerical index which together with the eid and ins_index uniquely identifies this record, i.e. eid, ins_index and arr_index together form a primary key for this table.

dsource

string, coding 1970

Critical care record origin. Currently only HES (England).

source

integer, coding 263

Critical care record format. A finer split of the format of data released from each dsource. Currently only 60.

ccstartdate

date

Date on which the critical care period started.

ccadmitype

integer, coding 7003

Critical care admission type. Whether a critical care period was initiated as a result of a non-emergency treatment plan, for example, for non-elective surgery. This relates only to the period of critical care and not to the nature of the hospital admission.

ccadmisorc

integer, coding 7004

Source of admission to critical care. Whether the patient originated from the same or a different NHS hospital, an independent hospital provider, a non-hospital UK source, or a non-UK source.

ccsorcloc

integer, coding 7005

Location of the source of admission. The type of location the patient was in prior to the start of the critical care period.

ccdisdate

date

Date of discharge from critical care. Discharge date from unit if alive, date of death or date of declaration of brain stem death.

ccdisrdydate

date

Ready-to-discharge date from critical care. The date on which the patient has been declared clinically ready for discharge or transfer from the clinical care period.

ccdisstat

integer, coding 7009

Critical care discharge status. The patient status at time of discharge, for example whether they were fully ready for discharge, whether their discharge was early or delayed, whether they self-discharged, or whether they died rather than being discharged (and their organ-donor status if so).

ccdisdest

integer, coding 7010

Critical care discharge destination. Whether the patient was discharged to the same or a different NHS hospital, an independent hospital provider, a non-hospital UK destination or to a non-UK source, or whether the patient died in the unit.

ccdisloc

integer, coding 7011

Critical care discharge location. The principal location that the patient was discharged to for further care at the end of the critical care period.

ccapcrel

integer, coding 7012

Critical care APC relationship id. A comparison of the dates of the critical care period and those of the associated admitted patient care episode.

bressupdays

integer, coding 7006

Basic respiratory support days. Number of days of basic respiratory support. For the definition of basic respiratory support see Resource 141140 or the NHS CC Data Dictionary.

aressupdays

integer, coding 7006

Advanced respiratory support days. Number of days of advanced respiratory support. For the definition of advanced respiratory support see Resource 141140 or the NHS CC Data Dictionary.

bcardsupdays

integer, coding 7006

Basic cardiovascular support days. Number of days of basic cardiovascular support. For the definition of basic cardiovascular support see Resource 141140 or the NHS CC Data Dictionary.

acardsupdays

integer, coding 7006

Advanced cardiovascular support days. Number of days of advanced cardiovascular support. For the definition of advanced cardiovascular support see Resource 141140 or the NHS CC Data Dictionary.

rensupdays

integer, coding 7006

Renal support days. Number of days of renal support in the context of critical illness. For the definition of renal support see Resource 141140 or the NHS CC Data Dictionary.

neurosupdays

integer, coding 7006

Neurological support days. Number of days of neurological support. For the definition of neurological support see Resource 141140 or the NHS CC Data Dictionary.

gisupdays

integer, coding 7006

Gastrointestinal support days. Number of days of gastrointestinal support. For the definition of gastrointestinal support see Resource 141140 or the NHS CC Data Dictionary.

dermsupdays

integer, coding 7006

Dermatological support days. Number of days of dermatological support. For the definition of dermatological support see Resource 141140 or the NHS CC Data Dictionary.

liversupdays

integer, coding 7006

Liver support days. Number of days of liver support. For the definition of liver support see Resource 141140 or the NHS CC Data Dictionary.

orgsupmax

integer

Organ support maximum. Maximum number of organ systems supported at any one time, at any point in the critical care period (note that both basic and advanced categories cannot be counted at the same time). This may not be the same as the total number of organs supported throughout the critical care admission. The minimum for this variable is 0 and the maximum is 7.

cclev2days

integer, coding 7006

Critical care level 2 days. Total calendar days during which level 2 care alone was provided during the period.

cclev3days

integer, coding 7006

Critical care level 3 days. Total calendar days during which level 3 care alone was provided during the period.

ccunitfun

integer, coding 7001

Critical care unit function. The type of area to which the patient was admitted during a critical care period. This is the principal clinical service provided within the ward.

unitbedconfig

integer, coding 7002

Critical care unit bed configuration. The composition of bed types for the critical care unit.

Table ID	Table	Title
1063	hesin	HES inpatient core dataset
1066	hesin_delivery	HES inpatient delivery
1067	hesin_diag	HES inpatient diagnoses
1068	hesin_maternity	HES inpatient maternity
1069	hesin_oper	HES inpatient operations
1070	hesin_psych	HES inpatient psychiatric

Table ID

Table

Title

1063

hesin

HES inpatient core dataset

1066

hesin_delivery

HES inpatient delivery

1067

hesin_diag

HES inpatient diagnoses