Specification

The first piece of information which is determined for each year is the average number of inpatient days per patient treated in the appropriate year. There has to be exactly one entry in the table stat1 for each stationary reception. If at least one examination has been done, an entry in the table stat3 is created for each day in hospital, and the field day (tag) contains the according day number. So for each inpatient stay, the length can be determined by seeking for the highest tag entry. All those are added up and divided by the number of patients that have been medicated inpatient or ambulant.        

The next piece of information is the average frequency of outpatient treatments. This is done for each quarter and each year by adding up the entries in the table progression (verlauf) which is then divided by the total space of time examined. For each period of time, the last examination done in an earlier period is also needed for evaluating the correct while before the first date of medication in the actual period.  

Patients that are treated only rarely influence the quality  of the information given by this statistic  a lot. Due to this, for every year, the percentage of patients who were medicated only once is also determined. So in each year, the last entry for each patient is selected. If there is no ambulant entry for this patient during the 12 months before this last one, this patient is considered to be treated only once. 

Next, the percentage of patients who received a diabetic schooling compared to the total number of patients is determined for every quarter and every year. Each entry in the table schooling (schulung) is set on a level with a diabetic schooling for the appropriate patient.      

Then the quality of the patients' self-monitoring is checked. A statistical information is produced about the frequency of the blood and the urine sugar concentration checks. For each quarter and each year the patients' values have been entered for, those patients are divided into three groups: patients checking only once a week, patients checking two or three times a week, or patients who check their sugar concentrations  four or more times a week. The number of checks per week are saved in the field self_blood_sugar (selbst_bz) for the blood values and in the field self_urine_sugar (selbst_uz) for the urine values in the table progression (verlauf). If one of the fields selbst_bz and selbst_uz is -- due to several examinations -- filled out multiple times for one patients in the same period of time, the average value has to be used.

Last, but not least, information about the patient's number of daily insulin  injections is gathered. All medicated patients are divided into the following six groups: zero to four injections a day, or group six: patients using an insulin pump. If a patient is not using such a pump, the information about the number of his injections is taken from the table progression (verlauf) out of the fields about the old insulin dose and the fields about the recommended insulin dose. If both kinds of information are available, the fields about the recommended insulin dose are used. If multiple examinations have been done in the same period of time and those fields have been filled out multiple times, only the latest set has to be used.