HES England dataextract specification

							                                Department of Social Medicine
                                  Hospital Episode Statistics

                                     Part I: JOB REQUEST
Request Reference:                               Priority: Urgent/Routine
                                                 Date Required:
Name:

Title of study:

Funding body/Funder:

Details (description of requirements, purpose, possible analysis of data)
(e.g. All episodes with I21(ICD10) in main diagnosis field for HES year 96/97, 97/98, crosstab by sex,
age (5 year bands), DHA of residence)




Contact Person:                                      Contact telephone:
Email address:
Head of project/supervisor/staff member responsible for confidentiality of the dataset:
Name of person responsible:
Signature and date:
                           Part II – Internal Assessment
Recommendation: Approve / Reject
Supervisor signature and date :

                    Part III – Approval by Data Custodian
Decision:    Approve/Reject/Keep In View/Further information needed
HES Data Custodian signature and date:


                                        Part IV - ACTION
Details:
a. t-sql file:
b. data extract:




Done by:                                             Completed on:


Note: Please complete Part I and Annex A. Print and post the request form to Davidson Ho, Dept of
Social Medicine, University of Bristol, Canynge Hall, Whiteladies Road, Bristol BS1 6FE.

Form: HES101
8eb610ea-4d5a-499a-9c27-e41d8f02ac96.doc
                                                                            Annex A
HES Extract specification form

1.      Data years: (please tick)

1991/92
1992/93
1993/94
1994/95
1995/96
1996/97
1997/98
1998/99
1999/00
2000/01
2001/02
2002/03
2003/04
2004/05

2.     Details of selection/filter criteria
Please circle the following criteria (if applicable).

Age: a. NA b.1 year age band c.5 year age band d.OTHER – please specify

Sex: a. NA b.Male/Female/Others c. Male/Female/Persons d. Other – please specify


Diagnosis: a. NA b. Main Diagnosis c. Any diagnosis: d. cause
ICD 9 codes (if applicable):
ICD 10 codes (if applicable): N70-N77


Operation procedure (OPCS4): a. NA b. Main Operation c. Any operation
OPCS4 codes (if applicable):

Admission cases only (epiorder=”1”): Yes/No
Regional Health Office: a. NA b. resident c. treatment d. Other – please specify
District Health Authority: a. NA b. resident c. treatment d. Other – please specify
NHS Hospital trusts: a. NA b. All c. Other – please specify
Primary Care Trusts: a. NA b. All c. Other – please specify


Other criteria (please specify):

3. Details of custom derived fields (if required)




Form: HES101
8eb610ea-4d5a-499a-9c27-e41d8f02ac96.doc
* Further details on data definition can be found at: http://www.epi.bris.ac.uk/dept/general/datadict.htm
4.       Fields to be extracted (For registered HES users only, please tick)

ADMIDATE                                           GROSS_A
ADMIMETH                                           GROSS_B
BEDYEAR                                            HATREAT
CATEGORY                                           HESID (from 97)
CAUSE                                              MAINSPEF
CLASSPAT                                           MARSTAT
DIAG_1                                             OPER_1
DIAG_2                                             OPER_2
DIAG_3                                             OPER_3
DIAG_4                                             OPER_4
DIAG_5                                             PROCODE
DIAG_6                                             PRODMUT
DIAG_7                                             PURCODE
DISDATE                                            RESHA
DISDEST                                            RESPCT
DISMETH                                            RESRO
YEAR_DOB                                           ROTREAT
ELECDATE                                           SEX
ELECDUR                                            SPELDUR
ENDAGE                                             STARTAGE
EPISTART                                           WARD91
EPIEND                                             WARD98*
EPIORDER                                           PATID*
EPITYPE

* ward98 and patid are derived fields
5. Sketch of table requested.
e.g.
Regional Health Office     Age                   Sex               Episodes
South West RO              0-4                   1                 10
South West RO              5-9                   1                 20
South West RO              10-14                 1                 30

Your draft table




Note: only registered HES user has access to row level records only.


Form: HES101
8eb610ea-4d5a-499a-9c27-e41d8f02ac96.doc