Patients classification System

tools for
Cost management

tools for
Quality management

tools for
HOSPITAL PLANNING

4 Why to choose US

4 implementation

4 ANECDOTE

4 contact

4 Logic

4 diagnoses

4 procedures

4 inpatients

4 outpatients

4 insurance

4 readmissions

4 reoperations

4 complications

4 deaths

4 length of stay

4 day surgery

4 unjustified stays

DATA PREPARATION SWITZERLAND Content of SQLape_input.txt file

Fields

Swiss Federal Office of Statistics designation

Format

 

Field 1

Hospital stay identifier

-

text

 

Field 2

Hospital identifier

0.1.V02

text

 

Field 3

Location

0.1.V03

text

 

Field 4

Patient identifier

0.2.V01

text

 

Field 5

Stay definition

0.2.V02

text

 

Field 6

Gender

1.1.V01

number

integer

Field 7

Age at admission

1.1.V03

number

integer

Field 8

Residence

1.1.V04

text

 

Field 9

Admission date *

1.2.V01

YYYYMMDD

(text)

Field 10

Stay before admission

1.2.V02

number

integer

Field 11

Admission mode

1.2.V03

number

integer

Field 12

Type of stay

1.3.V01

number

integer

Field 13

Vacations

1.3.V04

number

integer

Field 14

Department

1.4.V01

text

 

Field 15

Discharge date*

1.5.V01

YYYYMMDD

(text)

Field 16

Discharge decision

1.5.V02

number

integer

Field 17

Stay after discharge

1.5.V03

number

integer

Field 18

Length of stay

-

number

integer

Field 19

Hospital cost

-

number

real

Field 20

Weight at birth

2.2.V04

number

integer

Field 21

Main diagnosis

4.2.V010

text

 

Field 22

Complement to main diagnosis

4.2.V020

text

 

Fields 23-71

Diagnoses 2 to 50

4.2.V030-4.2.V510

text

 

Field 72

Procedure 1

4.3.V010

text

 

Field 73

Procedure 2

4.3.V020

text

 

Fields 74-171

Procedures 3 to 100

4.3.V030-4.3.V1000

text

 

Field 172

Procedure 1 date

4.3.V015

YYYYMMDD

(text)

Field 173

Procedure 2 date

4.3.V025

YYYYMMDD

(text)

Fields 174-271

Procedure 3 to 100 dates

4.3.V035-4.3.V1005

YYYYMMDD

(text)

Field 272

1st interruption, discharge date

4.7.V01

YYYYMMDD

(text)

Field 273

1st interruption, readmission date

4.7.V02

YYYYMMDD

(text)

Field 274

Reason of 1st interruption

4.7.V03

number

integer

Field 275

2nd interruption, discharge date

4.7.V11

YYYYMMDD

(text)

Field 276

2nd interruption, readmission

4.7.V12

YYYYMMDD

(text)

Field 277

Reason of 2nd interruption

4.7.V13

number

integer

Field 278

3rd interruption, discharge date

4.7.V21

YYYYMMDD

(text)

Field 279

3rd interruption, readmission

4.7.V22

YYYYMMDD

(text)

Field 280

Reason of 3rd interruption

4.7.V23

number

integer

Field 281

4th interruption, discharge date

4.7.V31

YYYYMMDD

(text)

Field 282

4th interruption, readmission

4.7.V32

YYYYMMDD

(text)

Field 283

Reason of 4th interruption

4.7.V33

number

integer

*if the exact time in hours is indicated at the end of the date, the computation will go ahead without taking time into account.

For more details: 4 SWISS NOMENCLATURES


Please pay attention to following specifications

        The stay identifier must be unique in the whole SQLape_input file, not only for each hospital or site. Do not use the underscore _ character in the identifier.

        The patient identifier must be unique for the whole calculation period, independently of the year (important to identify readmissions on the next year).

        Missing dates must be empty (no character).

        ICD-10 diagnostic and ICD-9-CM procedure codes can be used with or without point (47.01 or 4701 for instance are both acceptable).

        ICD-9-CM codes must be in text format (0109 is different from 109 for instance)

        Fields 18 and 19 are only required to compute length of stay and hospital cost. They can be kept empty for other indicators. Hospital cost is not included in hospital medical records; this information corresponds to hospital the total cost computed for SwissDRGs. The length of stay is defined as following:
discharge date admission date + 1 vacation duration (hours/24).

Temporal delimitation

The usual setting includes all discharges from January 1st to December 31th, but shorter periods might also be used. If several years are included in the SQLape_input.txt file, the analysis will take into account the discharges of the more recent year if they represent more than 10% of cases; otherwise, the analysis will be applied to the year including the most cases.

If you are interested in readmissions indicators, please also consider following recommendations:

1.        To compute unbiased observed rates, the input file must include other available hospitals to identify external readmissions.

2.        To compute unbiased expected rates, the input file must be extended to June 1st of the previous year. This extension is necessary to adjust for possible six months previous hospital stays.

Data transfer from the Swiss Federal Office of Statistics:

You might gain time in preparing the SQLape_input.txt file by transferring directly data from the Swiss Federal Office of Statistics format:

4 FREUDIGER TRANSFER TOOL

If you want to have results with your own hospital and patient identifiers or medical services you may need to update the fields 1, 4 or 14.

Data quality assessment

It is recommended to assess the quality of data before to interpret the results.

4 DATA QUality

SQLape s..r.l. 2014. Last update: 20.05.2014