Diabetes Sample Database

From Ajexus



User Guide

Administration Guide

Configuration Guide

Engine Guide

Installation and Maintenance

Frequently Asked Questions

Sample configurations

  • Diabetes
Sample databases are automatically installed when you install Ajexus.

To start the diabetes sample database from the START Menu, click Start, Ajexus 4, Samples, then diabetes Database.

Note: Ajexus is suitable for any healthcare provider. The sample databases provided show how Ajexus might be configured to meet specific needs. If you have different requirements, remember that in Ajexus you define the information that is to be recorded, therefore Ajexus can easily be tailored to your needs.

The diabetes sample database supplied with Ajexus covers the fictitious organisation 'Sefton Heights Healthcare'.


Logins available

The following User Names are available in the sample database. For ease of use, use the administrator User Name.

  • 'administrator' has full rights to all information as well as rights to the Data Dictionary

The Password for all the users in the sample database is 'password'.

For information on logging into Ajexus refer to Getting Started in the Operation section in the User Guide.

Patients Available

To view a list of available patients, select the 'All Patients' predefined report on the Select screen. The following patients have a fairly extended record of diabetes care:

For information on selecting records, refer to Select a Patient Record in the Record section in the User Guide.

Episodes - Continuum of care

Sefton Heights Healthcare has identified the following continuum of care to provide their patients. They have set up episodes within Ajexus to cover this continuum of care.

The continuum of care covers the following key stages. It should be noted that where an organisation provides a range of services (such as a large hospital), a patient may have more than one continuum of care active at any one time.


This is when a patient is first referred to the service, and the referral is triaged to decide whether Sefton Heights Healthcare is able to assist. If so, the referral will be accepted, and the patient will pass to the assessment stage. If not, the referral will be declined, and the patient will possibly be referred on to a more appropriate service.


This is when investigations, tests and assessments are carried out on the patient, with the objective being to arrive at a suitable diagnosis, and to create a care or treatment plan for the patient.

Assessment is linked to sub elements for the recording of Vital Signs, Risk Factors and Symptoms.


Sefton Heights Healthcare has a statistical requirement to record the specific diagnoses made by the physicians.


Treatment is recorded in separate elements, depending on the type of treatment: Medication, Invasive, Care Plan or Therapy.


This stage covers the tasks involved with the discharge of the patient. The patient may be deceased, may be referred on to another service, or to their own resources. Diagnosis on discharge can be recorded, and an evaluation made on whether the outcome goals identified in the Treatment phase were reached (or exceeded).


Within the main stages outlined above, Sefton Heights Healthcare has identified what information to collect.

These elements represent just one possible medical recording set up. Our other sample databases demonstrate several different layouts, however, Ajexus users are able to create any set of elements appropriate to their service.

One consideration may be what kind of statistical analyses you may want to run on your data. Ajexus enables you to instantly create summary and total reports, and this is made especially simple if you have defined elements on which to base your report criteria. For instance, a medication element for recording every medication that is provided, affords easy reporting of statistical data pertaining to individual drugs or drug groups.

In addition to the key stage elements mentioned above, Sefton Heights Healthcare has decided the following is required:


This is used to record any alerts or warnings for the patient. These may range from allergies (such as penicillin) to surgical alerts. Alerts can be entered in any stage of the care process.


Generally, patients are implicitly assigned to the various health professionals by the entering of elements with these people, for example, an assessment by a cardiologist has this person designated as their cardiologist. However, there are times when there is a need to explicitly assign a particular person, and this is done with the assign element. Assign elements can be entered at any stage of the care process.


At the conclusion of the assessment process an initial (working) diagnosis may be made along with one or more alternate diagnosis. Diagnosis can be recorded at the assessment, treatment, or discharge stages.


This records the actual discharge of the patient. Generally patients are discharged when deceased, treatment is complete, or they are better served by another service. Patients can also request that they be discharged (subject to any applicable laws). The date and reasons for discharge along with any other details can be recorded.

Equipment Issue and Return

These elements record the issue and return of any equipment. Equipment issued in this way is recorded against their inventory list, and the same item cannot be issued to more than one patient at the same time. Items may be issued at any stage of the patients care.

Inpatient Admission

The inpatient admission element is used to record the assignment of a bed. This element is designated as an equipment element, therefore the equipment scheduling capabilities of Ajexus can be utilised. In addition, equipment such as beds are assigned from an equipment list, and can only be assigned to one person at one time (although they can be booked in advance).

Inpatient Discharge

This is a companion element to the inpatient admission, and records the patients discharge for a bed. This is not to be confused with a discharge from the service, as, for instance, their status may be changing an after care patient. The workflow capabilities of Ajexus are used to automatically assign an outcome to the inpatient admission element when the inpatient discharge element is entered.

Intensive Care Admission and Discharge

Sefton Heights also has a need to record entries and exits from its intensive care facility. Beds are allocated and deallocated as required.


Medication information is an important part of the patients record. Sefton Heights is able to record the existing medications, any medications newly prescribed during care, together with any medications discontinued, by entering a medication element. Medication elements may be entered during any part of the patients care.


Within the Assessment element, a sub element is used to record symptoms. By providing the healthcare professional with a list of symptoms from which to make multiple selections (if necessary), Sefton Heights Healthcare is able to perform statistical analysis relating to symptoms and eventual outcomes.

Tests - Order and Results

Sefton Heights has a requirement to record the ordering of tests and the results of tests separately. Test results are recorded in subelements that allow the tester to record multiple test results against the same record element.

Treatment Outcome

At the conclusion of the treatment stage, a treatment outcome element is entered to indicate how successful the treatment plan has been. The patient may have fully recovered, their condition may have improved, remained constant, deteriorated, or they may be deceased.

Note: this is only an example of the different elements that may be set up within Ajexus to record patient details. Practically any information can be stored in the patients record.

Element Lists

In 'Full Record - Group By Episode', the full medical record for the patient has been grouped by the episodes. This element list would be useful for someone wishing to fully acquaint themselves with the medical history, such as a new clinician taking over the case. Over time this element list can become unwieldy as a large amount of information accumulates. More refined element reports have been created here to show specific elements of the record. In the Sefton Heights sample, these are Diagnoses, Alerts and Medications, but Ajexus users can easily refine the element list in a variety of other ways using different element criteria.

Summary Reports

Various summary reports have been created in our Sefton Heights Healthcare sample. They cover things like 'All surgeries this year', 'All referrals today', 'All implants issued this year'. The list could be endless and Ajexus users will find that this ad hoc reporting facility is so easy that many of these reports can be one-off and hence deleted as soon as they are run.

Attached Images

Several of the medical records set for Sefton Heights Healthcare have attached images. In particular, look at the medical records for Michael Falstaff and Simon Peters (using the Full Record Group By Episode element list), as they have fairly extended diabetes treatment and images are attached to some of their elements in relation to ECG, Nuclear Imaging and Angiography.

If your imaging equipment and Ajexus have the same access to folders on your network server, then it is a simple matter to apply images to the patient record as soon as they are made available by the imaging departments.