Shows only users of the selected group. When the “Users browser” opens, the dropdown menu is set on “ALL”, and the full list is visible. Select the group from the menu, and the corrispondono row are automatically shown.

Data:

same of chapter 2.1

Adds a new OH user to the “user” database. Choose the user group from the dropdown menu, enter the username in the “Name” field, then type the password, retype it on the “Retype password” field, and add an optional description to help identify the user. Click “OK” to confirm, or “Cancel” to return to the users table. If “OK” was clicked and no password was inserted, an error window shows the “please insert a password” message. Click “OK” to return to “New User Record” window. If the two passwords don’t match, an error window shows the “password incorrect, please retype”. Click “OK” to return to “New User Record” and retype the passwords. If they match, the new user is added to the users table (top on next page).

Data:

all “user” attributes

Updates the user description. Select a row from the “Users browser” and click “Edit”. An “Editing user record” window opens. The “Description” field is freely editable. Click “OK” to save changes, or “Cancel” to return to the users menu.

If a row is not selected before clicking “Edit”, a “please select a row” window opens. Click “OK” to close the window to return to the user menu. This message will appear on every OH table, for all editing and deleting options.

Data:

• user.US_ID_A (primary key, username)

• user.US_DESC (user description)

To change the password for a given user, select a row from the users browser and click “Reset Password”. Insert the new password on the new window (left).

Then click “OK”. Retype the new password on a second window similar to the first one and click “OK”.

If the passwords don’t match, an error message (left) is shown, else a confirmation window opens (right) and the new password is stored in the users DB (bottom window). Clicking “Cancel” anytime, the operation is aborted and there will be no changes to the users DB.

Data:

• user.US_ID_A (username)

• usergroup.UG_ID_A (password)

Removes the selected user from the user list. Select a row and click “Delete”. As in most “delete” operations, a confirmation window opens: click “Yes” to definitely remove the user from the list, or “No” to abort the operation.

Data:

• user.US_ID_A (primary key, username)

Closes the “Users browser” window. Click “Close” to return to the main menu.

Creates a new user group. Click “New” on the “groups browser”. Add the name and an optional description in the new window, then click “OK” to confirm. If the name doesn’t exist in the “usergroup" database, the group will be added, else a “the group is already present” message appears. If no name is inserted, a “please insert a valid user group” message is shown.

Click “OK” after both unsuccessful cases to add a proper name. Once a valid name is entered, the new group is added to the “group browser” table (right).

Data:

both “usergroup” attributes

Edits the group’s description. It’s similar to the “Edit User” option (2.1.3). Select a row, click “Edit” and type the (optional) description in the new window. Click “OK” to save changes, or “Cancel” to abort the operation.

Data:

both “usergroup” attributes

Removes an existing group, except the “admin” and groups which have users assigned to.

Select a row from the “Group Browser” and click “Delete”. The confirmation window is shown: click “No” to abort the operation, or “Yes” to remove the group. If “admin” is selected, a “You can’t delete admin” message appears; if there are users belonging to the selected group, a “This group has users” window is shown. The “usergroup” database remains unchanged after both unsuccessful cases. For the latter case, first remove those users before deleting the group. Then create a new group (2.2.1) and add the users (2.1.2).

Data:

• usergroup.UG_ID_A (primary key, group name)

• user.US_UG_ID_A (foreign key referencing user group, to which the user belongs; if the selected group has users, it can’t be deleted)

Allows the administrator, and all the users with this feature enabled, to manage privileges for every group in the “usergroup” database. Select a group from the “Group Browser” window and click “GroupMenu”. A new window “Menu Item Browser” (left), reproducing OH’s main menu, opens. Click on the triangles to expand the menu items. Enabled functions are shown in black, while disabled options are shown in light grey. Double click on a single option to activate/deactivate it. Click “Update” to save changes, or close the window to abort the operation.

As seen in chapter 1,

“Eduardo” can’t read the user menu (“HELP” option) by default. The administrator, or any user with permission to edit groups, selects the “guest” row, clicks “GroupMenu”, then double-clicks “HELP” on the “Menu Item

Browser” window (left) and clicks “Update”. Now Eduardo can access the user guide, as the menu pictured on the right shows the “HELP” button.

Data:

• groupmenu.GM_ID (primary key, option ID)

• groupmenu.GM_UG_ID_A (user)

• groupmenu.GM_MNI_ID_A (option name)

• groupmenu.GM_ACTIVE (Y if the option is enabled, else N)

Closes the “groups browser” window. Click “Close” to return to the main menu.

The “Admission Type Browsing” table shows the different ways a patient is admitted in to the hospital. Default types are:

“A” (Ambulance, an ambulance carries the patient)

“R” (Referral, patient coming from another hospital / ward)

“I” (Self, patient coming by him/herself). Below is a screenshot from the “New Admission” option (8.5.1), where a dropdown menu is used to select admission types.

Data:

• admissiontype.ADMT_ID_A (primary key, admission type ID)

• admissiontype.ADMT_DESC (admission type description)

The “Discharge type browsing” table defines the different ways a patient can be dismissed from the hospital. Default types are: “D” (Dead, patient deceased), “ES” (Escape, the patient escaped from the hospital), “EQ” (Normal Discharge), “B” (Referred, a further visit is planned for that patient).

Data:

• dischargetype.DIST_ID_A (primary key, discharge type ID)

• dischargetype.DIST_DESC (discharge type description)

The “Delivery type browsing” table defines the ways of assisting pregnant mothers in the event of a delivery. Default types are: “C” (Caesarian delivery), “V” (Vacuum extraction), “N” (No assistance).

Data:

• deliverytype.DRT_ID_A (primary key, delivery type ID)

• deliverytype.DRT_DESC (delivery type ID)

The “Delivery result type browsing” table defines the different delivery outcomes. Default types are shown below:

Data:

• deliveryresulttype.DRT_ID_A (primary key, delivery result type ID)

• deliveryresulttype.DRT_DESC (delivery result type description)

The table “Disease type browsing” defines the different disease categories used in OH, including “OPD”. Default types: “ND” (Notifiable diseases), “OC” (Infective diseases), “MP” (Maternal / perinatal diseases), “NC” (Non communicable diseases), “AO” (All other diseases).

Data:

• diseasetype.DCL_ID_A (primary key, disease type ID)

• diseasetype.DCL_DESC (disease type description)

The “Exam Type Browsing” table defines the different exam categories used in OH, including “Laboratory”. Default types are shown below:

Data:

• examtype.EXC_ID_A (primary key, exam type ID)

• examtype.EXC_DESC (exam type description)

The “Medicals Stock Movement Type Browsing” table shows the different money movements involving the hospital. The two basic elements (below) are: “Charge”, for incomes (+), and “Discharge”, for payments (-).

Data:

• medicaldsrstockmovtype.MMVT_ID_A (primary key, movement type ID)

• medicaldsrstockmovtype.MMVT_ID_DESC (movement type description)

• medicaldsrstockmovtype.MMVT_ID_A (“+” or “-“)

The “Medical Type Browsing” table defines the different categories for medicals and other items used by the hospital. Default types are shown below.

Data:

• medicaldsrtype.MMVT_ID_A (primary key, medical type ID)

• medicaldsrtype.MMVT_ID_DESC (medical type description)

The “Operation Type Browsing” table defines the operation categories. Default types are shown below:

Data:

• operationtype.OCL_ID_A (primary key, operation type ID)

• operationtype.OCL_DESC (operation type description)

• operationtype.OCL_TYPE (operation status, can be “MAJOR” or “MINOR”; currently unused)

The “Pregnant Treatment Type Browsing” table defines the types of treatments to pregnant mothers. Default types are shown below:

Data:

• pregnanttreatmenttype.PTT_ID_A (primary key, pregnant treatment type ID)

• pregnanttreatmenttype.DESC(pregnant treatment type description)

Defines specific prices lists, which will be stored in a separate “pricesothers” database.

When a patient is register in OH’s “patient” database, it’s not always possible to determine his/her age, since the birthdate is unknown. In this case, the user can choose the age interval from a dropdown menu in the “New Patient” option. The “Age type browsing“ table below defines the age ranges. Every row determines, respectively, the code of the interval, the minimum age, the maximum age, and the description of the range.

Data:

• agetype.AT_CODE (primary key, age type ID)

• agetype.AT_FROM (minimum age)

• agetype.AT_TO (maximum age)

• agetype.AT_DESC (description of the range)

The “Vaccine Type Browsing” table defines all vaccine types. Default categories are:

• C (Vaccines for children)

• P (Vaccines for pregnant women)

• N (Vaccines for adults, except pregnant women)

Data:

• vaccinetype.VACT_ID_A (primary key, vaccine type ID)

• vaccinetype.VACT_DESC (vaccine type description)

Adds a new ward in the hospital. Click “New” in the “Wards browser”. A “New ward record” window opens. Fill the mandatory text fields, marked with the * sign, and add phone, fax and e-mail contacts if necessary. Tick the “ward with pharmacy” checkbox if the ward will have its own pharmacy; do the same on “male ward” if it’ll be allowed to men, and on “female ward” if women can access in it. Click “OK” to confirm or “Cancel” to abort the operation. If all data required are correct, the ward will be added to the “ward” database, else an error window is shown:

• “Code already in use”

• “Please insert a code” (if the code character has not been added)

• “Insert a valid beds/nurses/doctors/ number” (if a non-numeric value has been added).

After all unsuccessful cases click “OK” to return to the “New ward record” window.

Data:

see chapter 3.3

Select a row form “Wards Browser” and click “Edit”. An “Editing ward record” window opens; all elements except the code are editable. Once changes have been made, click “OK” to confirm or “Cancel” to abort the operation. If all data required are correct, the ward will be updated in the “ward” database, else an error window is shown (see 3.3.1).

Data:

see chapter 3.3

Removes a ward from the “ward” database, if it has no patients registered in the “Admission/Patient” menu. Select a row form “Wards Browser” and click “Delete”. Click “OK” on the confirmation window, or “Cancel” to abort the operation.

If there’s at least one patient admitted in the selected ward, there will be no deletion and a “Selected ward has X patients” window is shown. Pictured left is the example of the children ward, that has 123 patients registered.

Here is a screenshot from the “Admission/Patient” window, where 7 of the 123 patients from the children ward are visible (codes from 474 to 482). All patients from a ward must be discharged before removing it.

Data:

• ward.WRD_ID (primary key, ward ID)

• admission.WRD_ID_A (foreign key referencing to “ward”, to check if there are admitting patients in the selected ward)

Click “Close” on the “Wards Browser” window to return to the main menu.

To help search a disease, click the dropdown menu on the bottom of the “Diseases Browser” window, and select a type, or “ALL” to visualize all records.

Data:

• disease.DIS_ID_A (primary key, disease ID)

• disease.DIS_DCL_ID_A (foreign key referencing to “diseasetype”)

Adds a new disease to the “disease” database. Click “New” on the “Diseases browser” window. A “New disease” window opens. Select the type from the dropdown menu, enter a code and the description (i.e. the name of the disease, used in “OPD” and “Diagnosis IN” / “Diagnosis OUT” lists of the “Admission/Patient” menu). Then tick at least one checkbox to assign the disease to “OPD” (OutPatient

Dept.), “IPD IN” (“Diagnosis IN”) and “IPD OUT” (“Diagnosis OUT”). Click “OK” to confirm or “Cancel” to abort the operation. If all data required are correct, the disease will be added to the “disease” database, else an error window is shown:

• “Code already in use”

• “Please insert a code” (if the code character has not been added)

• “Insert a valid description” (if the description has not been added).

After all unsuccessful cases click “OK” to return to the “New disease” window.

Data:

• disease.DIS_ID_A (primary key, disease ID)

• disease.DIS_DCL_ID_A (foreign key referencing to “diseasetype”)

• disease.DIS_DESC (disease name)

• disease.DIS_OPD_INCLUDE (1 if the disease is included in the “OPD” list, else 0)

• disease.DIS_IPD_IN_INCLUDE (1 if the disease is included in the “IPD IN” list, else 0)

• disease.DIS_IPD_OUT_INCLUDE (1 if the disease is included in the “IPD OUT” list, else 0)

Select a row from “Diseases Browser” and click “Edit”. An “Edit disease” window opens; all elements except the code are editable. Once changes have been made, click “OK” to confirm or “Cancel” to abort the operation. If all data required are correct, the disease will be updated in its database, else an error window is shown (see 3.4.2).

Data:

see chapter 3.4.2

Removes a disease from its database. Select a row from “Diseases browser” and click “Delete”. Click “OK” on the confirmation window, or “Cancel” to abort the operation.

Data:

• disease.DIS_ID_A (primary key, disease ID)

Click “Close” on the “Diseases Browser” window to return to the main menu.

To help search an exam, click the dropdown menu on the bottom of the “Exams Browsing” window, and select a type, or “ALL” to visualize all records.

Data:

• exam.EXA_ID_A (primary key, exam ID)

• exam.EXA_EXC_ID_A (foreign key referencing “examtype”, exam type)

Click “New” on the “Exams Browsing” window. A “New exam” window opens. Select the exam type from the first dropdown menu, enter the code, a description (i.e. the name of the exam), select the procedure type and enter the default result. Click “OK” to confirm or “Cancel” to abort the operation. If all data required are correct, the exam will be added to the “exam” database, else an error window is shown:

• “Change the code because is already in use”

• “Insert a valid code and/or description”

After all unsuccessful cases click “OK” to return to the “New exam” window.

Data:

see chapter 3.5

Select a row from “Exams Browsing” and click “Edit”. An “Edit exam” window opens; only the description and default result are editable. Once changes have been made, click “OK” to confirm or “Cancel” to abort the operation. If all data required are correct, the exam will be updated in its database, else an error window is shown (see 3.5.2).

Data:

• exam.EXA_ID_A (primary key, exam ID)

• exam.EXA_DESC (exam name)

• exam.EXA_DEFAULT (default result)

Removes a exam from its database. Select a row from “Exams browsing” and click “Delete”. Click “OK” on the confirmation window, or “Cancel” to abort the operation.

Data:

• exam.EXA_ID_A (primary key, exam ID)

Every exam has a set of possible results (for example: positive / negative). The outcome of an exam is reported in the “Laboratory browsing” table, pictured left (see also chapter 6).

OH allows to manage the set of results for every recorded exam. Select a row from the “Exam Browsing” window and click “Result”. A new window shows a table with all outcomes, each with a code and a description. Here is an example of the “SUGAR” glucose exam (highlighted in the table at chapter 3.5).

To add a new result, click “New”, enter the description, then click “OK” to confirm or “Cancel” to abort the operation. Considering the example shown above, a “Very Low” level is added to “High”, “Low” and “Normal”.

The “Sugar results” table is updated with the new row (the code is automatically generated since it’s an auto-increment integer).

To remove a result, click “Delete” then click “OK” on the confirmation window, or “Cancel” to abort the operation.

To close the results table, click “Close” to return to the “Exams browsing” table.

Data:

• exam.EXA_ID_A (exam ID)

• examrow.EXR_ID (primary key, result ID)

• examrow.EXR_EXA_ID_A (foreign key referencing to exam.EXA_ID_A)

• examrow.EXR_DESC (result description)

Click “Close” on the “Exam Browsing” window to return to the main menu.

To help search an operation, click the dropdown menu on the bottom of the “Operations browser” window, and select a type, or “ALL” to visualize all records.

Data:

• operation.OPE_ID_A (primary key, operation ID)

• operationtype.OCL_ID_A (foreign key referencing “operation”, operation type)

Click “New” on the “Operations Browser” window. A “New operation record” window opens. Select the operation type from the first menu, enter the code, a description (i.e. the name of the operation). Status - major or minor - is currently unused in OH, however the user can choose it with the radio buttons. Click “OK” to confirm or “Cancel” to close the window without saving data inserted. If all data required are correct, the operation will be added to the “operation” database, else an error window is shown:

• “Code already in use”

• “Please insert a valid description”

• “Operation already present” (if there’s one with the same description).

After all unsuccessful cases click “OK” to return to the “New operation record” window.

Data:

• operation.OPE_ID_A (primary key, operation ID)

• operationtype.OCL_ID_A (foreign key referencing “operation”, operation type)

• operation.OPE_DESC (operation name)

• operation.OPE_STAT (operation status, “MAJOR” or “MINOR”, currently unused)

Select a row from “Operations Browser” and click “Edit”. An “Editing operation record” window opens; only description and status are editable. Once changes have been made, click “OK” to confirm or “Cancel” to return to close the window without saving changes. If data required are correct, the operation will be updated in its database, else an error window is shown (see 3.6.2).

Data:

• operation.OPE_ID_A (primary key, operation ID)

• operation.OPE_DESC (operation name)

• operation.OPE_STAT (operation status, “MAJOR” or “MINOR”, currently unused)

Removes an operation from its database. Select a row from “Operations browser” and click “Delete”. Click “OK” on the confirmation window, or “Cancel” to abort the deletion.

Data:

• operation.OPE_ID_A (primary key, operation ID)

Click Close” on the “Operations browsing” window to return to the main menu.

To help search a vaccine, click the dropdown menu on the bottom of the “Operations browser” window, and select a type, or “ALL” to visualize all records.

Data:

• vaccine.VAC_ID_A (primary key, vaccine ID)

• vaccine.VAC_VACT_ID_A (foreign key referencing “vaccinetype” database)

Click “New” on the “Vaccine Browser” window. A “New vaccine record” window opens. Select the vaccine type from the dropdown menu, enter the code and description (i.e. the name of the vaccine). Click “OK” to confirm or “Cancel” to abort the operation. If all data required are correct, the vaccine will be added to the “vaccine” database, else an error window is shown:

• “Code already in use”

• “Please insert a code/description”

After both unsuccessful cases click “OK” to return to the “New vaccine record” window.

Data:

• see chapter 3.7

Select a row from “Vaccine Browser” and click “Edit”. An “Editing vaccine record” window opens; only the description field is editable. Once changes have been made, click “OK” to confirm or “Cancel” to return to close the window without saving changes. If data required are correct, the operation will be updated in its database, else an error window is shown (see 3.7.2).

Data:

• vaccine.VAC_ID_A (primary key, vaccine ID)

• vaccine.VAC_DESC (vaccine description)

Removes a vaccine from its database. Select a row from “Vaccine browser” and click “Delete”. Click “OK” on the confirmation window, or “Cancel” to abort the deletion.

Data:

• vaccine.VAC_ID_A (primary key, vaccine ID)

Click “Close” on the “Vaccine browser” window to return to the main menu.

The “Prices Browser” window has a dropdown menu on the top, to choose

between the lists created with the “Manage List” option (3.8.2). Every time the user switches to a different list, a confirmation window (right) is shown. Click “OK” to confirm, or Cancel to return to the current list.

Data:

• pricelists.LST_ID

• pricelists.LST_CODE

Click the “Manager Lists” button on the right top of the “Prices browser” window. A “List browser” window opens. It has a table with the list records, showing the code, the name, the description and the currency used.

Some buttons on the bottom allow to create, edit and delete lists.

Data:

• pricelists.LST_ID (primary key, not shown in the table)

• pricelists.LST_CODE (price list code)

• pricelists.LST_NAME (price list name)

• pricelists.LST_DESC (price list description)

• pricelists.LST_CURRENCY (currency used in the list)

After editing the items within a price list, changes must be saved before closing the “Prices browser” window. Click the “SAVE” button and then “OK” on the confirmation window (left). To discard changes, click “Cancel”.

Generates a report containing the rows of the selected list. Click “Print” on the “Prices Browser” window. The Jasper Viewer opens; it has some buttons (below) to save in .PDF, print, update, scroll the pages, fit the document to the computer screen and zoom.

Click “Close” on the “Prices Browser” menu to return to the main menu.

Click “New” on the “Supplier Browser” window. A “New supplier” window opens. Enter the attributes seen in chapter 3.9. “Name” is the only mandatory field, while “ID” is auto-generated. Click “OK” to confirm or “Cancel” to abort the operation. If the name has been inserted, the supplier will be added to the “supplier” database, else a “Please insert a name” window is shown. In this case, click “OK” to return to the “New supplier” window.

Data:

• supplier.SUP_NAME (supplier name)

• supplier.SUP_ADDRESS (supplier address)

• supplier.SUP_TAXCODE (supplier tax number ID)

• supplier.SUP_PHONE (supplier phone number)

• supplier.SUP_FAX (supplier fax number)

• supplier.SUP_EMAIL (supplier e-mail address)

• supplier.SUP_NOTE (optional notes)

Select a row from “Supplier browser” and click “Edit”. The “Edit List” window opens. All data except the ID, are freely editable. If the “Deleted” checkbox has been previously ticked, the editing options allows to undelete the supplier (see 3.9.3). If the name has been inserted, the supplier will be updated, else a “Please insert a name” window is shown. In this case, click “OK” to return to the “Edit supplier” window.

Data:

see chapter 3.9

Select a row from “Supplier browser” and click “Delete”. This operation is different from other deletion operations. The record is not removed from the database, it will be unactive for the OH menus needing the supplier DB. Click “Yes” on the confirmation window to virtually remove the supplier, else “No” to abort the operation. If the “deletion” is confirmed, the “Deleted” checkbox on the “Supplier browser” table is checked. To undelete a supplier, select it and, click “Edit” and deselect the checkbox (3.9.2).

Data:

• supplier.SUP_ID

• supplier.SUP_DELETED

Click “Close” on the “Supplier Browser” window to return to the main menu.

To help search SMS sent on a given time interval, the user can type the DD/MM/YYYY “from” and “to” dates on the top of the “SMS Manager” window, or choosing them clicking on the calendar icons. This will open a calendar application. Choose the month from the dropdown menu and the year, then click on the day number; the selected date is automatically inserted. If the dates are correct, they’ll be showed in green, and the table will show only SMS sent in the selected range.

Data:

• sms.SMS_ID

• sms.SMS_DATE

To send an SMS, click “New” on the “SMS Manager” window. Enter the patient’s scheduled date either by typing it in a DD/MM/YY format or by clicking on the calendar icon (3.10.1).

Then enter the scheduled time either by typing it in HH:MM format or by clicking on the clock icon. Click on the hour and the minute on the new window (right), then click “OK” to confirm and return to the “New SMS” window.

Type the phone number, or choose it by clicking on the tag icon. A “Patient Selection” window opens (left). Select a row and click “Select”; the number will be automatically inserted. Finally, enter the message and click “OK” to send the SMS. If the text and the phone number have been inserted, the message will be sent, else an error window is shown:

• “Please insert a text”

• “Please insert a valid telephone number”

After all unsuccessful cases click “OK” to return to the “New SMS” window.

Data: see chapter 3.10

Select a row from “SMS manager” and click “Delete”. Click “Yes” on the confirmation window to remove the sms form the “sms” database, else “No” to abort the operation.

Data:

• sms.SMS_ID

Click “Close” on the “SMS manager” window to return to the main menu.

Filters the “Pharmaceutical browsing” table by item type. Choose the type from the dropdown menu on the bottom of the window, or “ALL” to visualize the full list.

Data:

• medicaldsr.MDSR_MDSRT_ID_A

• medicaldsr.MDSR_ID

Adds a new item to the “medicaldsr” database. Click “New” on the “Pharmaceutical Browsing” window. A “New medical record” window opens. Select the item type from the dropdown menu, then enter a code, a description (i.e. the name of the item), the number of pieces in a single packet (for pills or tablets; insert 0 for other indivisible items) and the critical level (insert 0 if no minimum quantity required). All data except “code” are mandatory. Click “OK” to confirm or “Cancel” to abort the operation. If the required data have been inserted, the item will be added to the “medicaldsr” database, else a “Insert a valid value” window is shown. In this case, click “OK” to return to the “New medical record” window. When a item is added, the “Out of Stock” checkbox is ticked. Pictured below is the table after adding aspirin as seen above.

Data:

• medicaldsr.MDSR_MDSRT_ID_A

• medicaldsr.MDSR_ID

• medicaldsr.MDSR_DESC

• medicaldsr.MDSR_CODE

• medicaldsr.MDSR_PCS_X_PCK

• medicaldsr.MDSR_MIN_STOCK_QTI

Select a row from the “Pharmaceutical browsing” window and click “Edit”. An “Editing medical record OPD registration” window opens. All data except the type are editable. Once changes have been made, click “OK” to update or “Cancel” to abort the operation. If the required data have been inserted, the item will be updated, else an error window is shown (5.1.2).

Data:

• medicaldsr.MDSR_MDSRT_ID_A

• medicaldsr.MDSR_ID

• medicaldsr.MDSR_DESC

• medicaldsr.MDSR_CODE

• medicaldsr.MDSR_PCS_X_PCK

• medicaldsr.MDSR_MIN_STOCK_QTI

Removes an item form the “medicaldsr” database, if it has no recorded stock movements. Select a row from “Pharmaceutical Browsing” and click “Delete”. Click “Yes” on the confirmation window (left) to remove item from its database, else “No” to abort the operation.

If there’s at least one stock movement in the “medicaldsrstockmov” database, containing the selected item, the deletion will be aborted and an error window (left) opens.

Data:

• medicaldsr.MDSR_ID

• medicaldsrstockmov.MMV_MDSR_ID (foreign key referenicing to the “medicaldsr” database)

Saves an .xls copy of the current “medicaldsr” database on the computer. Click “Export” on the “Pharmaceutical browsing” window. A “Save” window opens; enter the name of the file in the “Save As” field, and select the folder where the file will be saved. To save the file in a non-existing folder, click “New

Folder”, enter the name in the new window, and click “Create”. The new folder appears in the “Save” window, in the current visible path. Complete the operation clicking “Save” (or “Cancel” to abort).

Data: see chapter 5.1

Generates a report with the current “medicaldsr” database. Click “STOCK” on the “Pharmaceutical Browsing” window. The Jasper Viewer opens (see 3.8.4 for .PDF export / print / zoom / navigation operations). The document shows first all in stock items, sorted alphabetically by name, with the in stock and critical level quantities, then all out of stock items.

Data:

• medicaldsr.MDSR_ID

• medicaldsr.MDSR_DESC

• medicaldsr.MDSR_INI_STOCK_QTI

• medicaldsr.MDSR_MIN_STOCK_QTI

Click “Order” on the “Pharmaceutical Browsing” window. The Jasper Viewer opens (see 3.8.4 for .PDF export / print / zoom / navigation operations). The document shows all items, sorted by item name, with the in stock quantitites and the critical level. If the former value is greater, the difference between stock and the minimum required is shown in the “Still” column, else the “Order” column reports the amount to reach the critical level.

Data:

• medicaldsr.MDSR_ID

• medicaldsr.MDSR_DESC

• medicaldsr.MDSR_INI_STOCK_QTI

• medicaldsr.MDSR_MIN_STOCK_QTI

This option generates a Jasper document (see 3.8.4 for .PDF export / print / zoom / navigation operations), containing medical stocks expired or close to due date. Click “Expiring” on the “Pharmaceutical Browsing” window. Select the period on the new window (left). There are three options: “Today”,

“This month” and “Other month” (opens a window, pictured right, to choose the month and the year; click “OK” to confirm). The document will report all medicals to order, depending on the chosen period, each with the code, the description and the necessary amount to reach the critical level.

Click “Close” on the “Pharmaceutical Browsing” window to return to the main menu.

The left side of the “Stock Movement Browser” window provides a selection panel to help search stock movements. It has 4 main sections:

Pharmaceutical: Select an item from the “Description” dropdown, or “ALL” to show all item’s records.

Movement: Select a movement type (3.1.7) from the “Type” dropdown or “ALL” to show all movement’s records. Add dates, in DD / MM / YYYY format, in the “From” and “To” fields format to filter by movement date.

Lot preparation date: enter values, in DD / MM / YYYY format, in the “From” and “To” fields format to filter by lot preparation date.

Lot due date: enter values, in DD / MM / YYYY format, in the “From” and “To” fields format to filter by lot due date.

Tick the “Keep” checkbox to keep these filters active after clicking on Filter.

Once the selections have been made, click “Filter” to show only the matching movements.

Data:

• medicaldsrstockmov.MMV_ID

• medicaldsrstockmov.MMV_REFNO

• medicaldsrstockmov.MMV_DATE

• medicaldsrstockmov.MMV_MMVT_ID_A

• medicaldsrstockmov.MMV_WRD_ID_A

• medicaldsrstockmov.MMV_MDSR_ID

• medicaldsrlot.LT_PREP_DATE

• medicaldsrlot.LT_DUE_DATE

Click “Charge” on the “Stock Movement Browser” window. A “Stock Movement” window opens; charge information is shown on the top. Type the reference number on the “Reference No.” field, then choose the charge type (3.1.7) and the supplier (3.9). Enter part of the name or of the code on the “Type a code or a description and press ENTER”. After clicking the “Enter” button on the computer, select the medical among the ones matching the string inserted and click “Yes”.

Once the medical has been selected, insert the quantity in the “Input” window and click “OK” to confirm.

A “Lot informations” window opens. Assign the lot number

(it will be assigned automatically if “AUTOMATICLOT=yes” in the rsc/generalData.properties file) and enter the lot preparation and due dates, in a DD/MM/YYYY format (see 3.10.1 for the calendar icon). After clicking “OK”, the “Stock Movement” window (below) shows

the new charge.

Click “Save” to save the charge, else “Cancel” to discard.

If the data required have been inserted, the charge will be added to the stock movement DB, else an error window is shown:

• “The inserted reference number already exists”

• “Please select a supplier”

Click “OK” to return to the “Stock Movement” window.

Data:

• medicaldsrstockmov.MMV_REFNO

• medicaldsrstockmov.MMV_DATE

• medicaldsrstockmov.MMV_MMVT_ID_A

• medicaldsrstockmov.MMV_WRD_ID_A

• medicaldsrstockmov.MMV_QTY

• medicaldsrstockmov.MMV_MDSR_ID

• medicaldsrstockmov.MMV_LT_ID_A (lot number)

• medicaldsrtype.MDSRT_DESC

• medicaldsrlot.LT_PREP_DATE

• medicaldsrlot.LT_DUE_DATE

• medicaldsrlot.LT_COST

Assigns an item ordered after a “Charge” operation. Click “Discharge” on the “Stock Movement Browser” window. The “Stock Movement” panel is similar to the one seen in chapter 5.2.2. The differences are in both dropdown menus: the first includes all discharge types (“-“ sign), the second contains the hospital wards, to which the medical is discharged. See 5.2.2 for reference number and medical selection.

Once the medical has been selected, insert the quantity in the “Input” window and click “OK” to confirm. Quantity must not exceed the “Lying in stock” shown.

After confirming the quantity, the “Lot informations” window opens. Select the lot among those recorded in the database (the previously created 012 in this example), then click “OK”. Now the “Stock Movement” window (below) shows the new discharge. Now the “Stock Movement” window shows the new discharge. Click “Save” to save the discharge,

else “Cancel” to discard.

If the data required have been inserted, the charge will be added to the stock movement DB, else an error window is shown:

• “The inserted reference number already exists”

• “Please select a ward”

• “The quantity is not available” (right)

Click “OK” to return to the “Stock Movement” window. Picture below is the movements browser after the charge and the discharge.

Data: see chapter 5.2.2

Saves an .xls copy of the current “medicaldsrstockmov” database on the computer. Click “Export on excel” on the “Stock Movement Browser” window. The function is identical to the pharmacy export seen in chapter 5.1.5.

Click “Close” on the “Stock Movement Browser” window to return to the main menu.

Click “Pharmaceutical Stock Ward” in the “Pharmacy” menu. A small window (left) opens. Select the ward among those having an own pharmacy (3.3). Once the ward has been selected, the “Ward Pharmacy” expands as pictured below. The internal pharmacy, too, has a selection panel to help search records. Type two dates in the “From” and “To” fields on the right top of the window, in a DD/MM/YY format, or choose them clicking on the calendar icons (3.10.1). Then select medical type and item from the dropdown menus (4.1), filter by patient sex and weight range (4.1). Click “Filter” to show only matching records. Click “Reset” to remove all filters.

The “Ward Pharmacy” browser provides three different tables. Click on the tabs above the table to choose between:

“Drugs”: the table shown when opening the P.S. Ward menu, records all available items in the selected ward.

“Incomings”: shows all discharges from the main pharmacy (5.2.2).

“Outcomes”: shows all movements from the main pharmacy to the ward pharmacies. The buttons on the bottom of the window are referred to this visualization.

Data:

see chapter 5.3

Click “New” on the “Ward Pharmacy” window to add a new movement. A “New/Edit” window (left) opens. Select the destination clicking on the “Patient” or the “Internal use” radio button. If the former is selected, click “Pick Patient” to open the “Patient selection” window (or create a new one, if not already registered in the “patient” DB, clicking on the pencil icon; see chapter 8 “Admission/Patient”).

Click on the magnifier icon to show the patient list (if a string has been written in the “Search Patient” field, only rows containing that string are visibile) Once selected the row,

click “Select”. If no weight data are available, a “The selected patient has no weight defined” warning is shown (left; see chapter 8.6 to add weight and other information). Click “OK” to return to the “New/Edit” window. The “Pick Patient” buttons becomes “Change Patient”, and the nearby icon to delete the inserted name, is enabled.

Select the medical(s) to assign. Click “+ Medical” on the “New/Edit” window. Pick an item from the dropdown menu (left) and click “OK”.

Then enter the quantity (right) and click “OK”. Quantity must not exceed the available stock shown in the “Quantity” window.

Repeat the operation to add more medicals to the movement. To remove an item, select it and click “X Remove Item”. Pictured left is the “New/Edit” window after inserting 3 units of Albendazole. Click “OK” to add the record to the “Outcomes” table.

In case of items to assign to the ward (internal use), the record will be shown in bold blue in the “Outcomes” browser. Pictured below is the table after a record for a given patient of the children’s ward, and a record for internal use in that ward.

Data: see chapter 5.3

Click “Report” on the “Ward Pharmacy” window. The Jasper Viewer opens (see 3.8.4 for .PDF export / print / zoom / navigation operations). The document shows all outcome records, sorted by date and medical, each with the quantities for internal and patient use.

Data:

• medicaldsrward.MDSRWRD_WRD_ID_A

• medicaldsrward.MDSRWRD_MDSR_ID (foreign key referencing to the “medicaldsr”, item ID)

• medicaldsrward.MDSRWRD_IN_QTI (available quantity)

• medicaldsrstockmovward.MMVN_DATE

• medicaldsrstockmovward.MMVN_UNITS

Excel

Saves an .csv copy of the data shown in chapter 5.3.3. Click “Export” on the “Ward Pharmacy” window. The function is identical to the pharmacy export seen in chapter 5.1.5.

Click “Rectify” in “Ward Pharmacy”. The “Rectify” window opens. It allows the user to update the stock in the ward pharmacy, if the item is damaged or stolen. Select an item form the dropdown menu and enter the new actual quantity. Add the reason for the rectifying operation, if necessary. Click “OK” to update or “Cancel” to abort.

Click “Close” on the “Ward Pharmacy” window, to return to the main menu.

See chapter 7.1.

Select a row from “Patients Bills Management” and click “Edit”. The “New Bill” window opens; you can add items, payments and refunds as seen in chapter 7.1.“X Remove Item” and “X Remove Payment” buttons are disabled, while “Print Receipt” is enabled. Click on it, then click “Yes” on the confirmation window (left). If the rsc/generalData.properties file shows “RECEIPTPRINTER=yes” and the printer is connected to the computer, the bill will be printed.

Data: attributes from “billitems” and “billpayments”

The function doesn’t remove the bill from the “bills” database. It turns its status to “D” (for Deleted); so it’ll be visible only under the “Bills” tab. “Deleted” rows are shown in red (left) and their amounts won’t be calculated in the reports. Select an open or close bill, and click “Edit”. Click “Yes” on the confirmation window, or “No” to abort the operation.

Data:

• bills.BLL_ID

• bills.BLL_STATUS

Select a bill from “Patients Bills Management” and click “Receipt”, to print the bill and its items. The function is similar to the “Print Receipt” button in “Edit Bill” (7.2.2).

Creates a Jasper Viewer (see 3.8.4 for .PDF export / print / zoom / navigation operations), to show bills recorded (and the total amount of them) in a given period of time. Click “Report” on the “Patient bills management” window.

Select the time period form the dropdown menu. Options include:

• Today (closure): only amounts of the current day

• Today: bills of the current day

• Period: bills of the period chosen in the “Patients Bills Management” window (7.2).

• This Month: bills of the current month

• Other Month: bills of a month chosen from the calendar that opens if this option is selected.

Then click “OK” to confirm.

Once the time option is selected, if it’s not “Today (closure)”, a “Report” window opens (left). Select between two options:

• Short report: returns pending bills, and the total amount of the closed ones.

• Full report: returns closed and pending bills in detail.

Click “OK” to confirm and generate the document (below).

Data:

• bills.BLL_ID

• bills.BLL_DATE

• bills.BLL_PAT_ID

• bills.BLL_USR_ID_A (user genersting the report, default “admin”)

• sum(bills.BLL_AMOUNT) (sum of all amounts in the given period)

• bills.BLL_STATUS

Click “Close” on the “Patients Bill Management” window to return to OH’s main menu.

Select a “Not Admitted” patient (the ones where “Ward” column is empty) and click “Admission”. A “New Admission” window opens (below). It has three tabs (four for female patients). Add in the first one, “Admission/Discharge”, the following data:

• Ward: select the ward from the dropdown menu

• From Health Unit: optional, if the patient comes form another hospital / ward

• admission date (DD/MM/YY or by calendar icon)

• admission type (3.1.1)

• malnutrition: if checked, patient has malnutrition issues; see chapter 8.9.3)

• the diagnosis for which the patient is admitted.

• the diagnoses for which the patient is dismissed (optional)

• discharge type (if it’s the same of the admission type, click “Yes” on the confirmation window)

• optional notes

Click the “Operation” tab to add optional information on operations related to the

diagnosis. Click the “Delivery” tab to add optional information about the delivery (for female patients). Click on the “Notes” tab to add optional notes about the admission record. Finally, click “Save” to save the admission data. If all required fields (*) have been filled, the admission record is saved, and the patient is included in the “admitted” table; else a ìn error message is shown:

• “Ward without free beds”

• “Please select a valid Diagnosis -IN-“)

• “Please select a valid admission type“)

• “Please select a valid discharge type“)

• “Future date not allowed, please insert a valid discharge date”

• “Discharge date must be after admission date”

Data:

• admission.ADM_PAT_ID (foreign key referencing to the “patient” database, patient ID)

• admission.ADM_WRD_ID_A (foreign key referencing to the “ward” database, ward in which the patient is admitted to)

• admission.ADM_FHU (“From health unit”)

• admission.ADM_YPROG (serial admission number in a calendar year, 1 … N)

• admission.ADM_DATE (admission date)

• admission.ADM_ADMT_ID_A_ADM (foreign key referencing to the “admissiontype” database)

• admission.ADM_IN_DIS_ID_A (foreign key referencing to the “disease” database, admission diagnosis

• admission.ADM_OUT_DIS_ID_A (foreign key referencing to the “disease” database, discharge diagnosis)

• admission.ADM_OUT_DIS_ID_A_2 (foreign key referencing to the “disease” database, second optional discharge diagnosis)

• admission.ADM_OUT_DIS_ID_A_3 (foreign key referencing to the “disease” database, third optional discharge diagnosis)

• admission.ADM_DATE_DIS (discharge date)

• admission.ADM_DIST_ID_A (foreign key referencing to the “dischargetype” database)

• admission.ADM_NOTE (optional notes)

• admission.ADM_OPE_ID_A (foreign key referencing to the “operation” database)

• admission.ADM_DATE_OP (operation date)

• admission.ADM_RESOP (operation result: “P” if positive, “N” if negative, “U” if unknown)

• admission.ADM_TRANS (transfusional unit)

Discharges an admitted patient. Select an “Admitted” row from “Patients Browser”, (the ones where the “Ward” column is not empty vuota) and click “Admission”. An “Edit Admission Record, window opens (below). All data seen in chapter 8.5.1 are editable. Click “Save” to update information. If all conditions previously explained have been respected, the data will be updated.

Data: see chapter 8.5.1

Select a row of “Patient Data” and click “Edit”. The “Edit admission” opens (8.5.2).

Select a row of “Patient Data” and click “Delete”. Click “Yes” on the confirmation window to remove the row, or “No” to abort.

Select a row of “Patient Data” (if the “Malnutrition control” checkbox has previously been ticked; see chapter 8.5.1), then click “Malnutrition control”. A “Malnutrition Browser” window opens (left). It provides a table with four columns: further date (date of the measurement), approval date (date of next scheduled measurement), height and weight (both referred to the current measurement. These data are completely independent from those collected via the “Examination” menu (8.6).

Click “Close” on the “Patient Data” window to return to OH’s main menu.

Select a row from “Patient Data” where the column “Ward” is “OPD” (left) and click “OPD Chart”. This generates a report with a summary of the visit. Information includes patient data and visit details (ID, date, type, diagnosis, notes).

If there are no “OPD” records, a “Please select an OPD” window is shown. Click “OK” to close it.

Data:

• patient.PAT_ID

• patient.PAT_NAME (patient’s first and second name, concatenated)

• patient.PAT_SEX

• patient.PAT_BDATE

• patient.PAT_AGE

• patient.PAT_CITY

• patient.PAT_HEIGHT

• patient.PAT_WEIGHT

• patient.PAT_PHOTO

• opd.OPD_ID

• opd.OPD_DATE

• opd.OPD_TYPE

• opd.OPD_NOTE (“Clinical Remarks”)

• opd.OPD_DIS_ID_A

• opd.OPD_DIS_ID_A_1

• opd.OPD_DIS_ID_A_2

Select a row from “Patient Data” where the column “Ward” has the name of a ward (left). and click “Admission Chart”. This generates a report with a summary of the visit. Information includes patient data and admission details (ID, date, type, admission diagnosis, notes, duration, discharge diagnosis).

Data:

• all “patient” attributes used in 8.10.1

• admission.ADM_ID

• admission.ADM_WRD_ID_A

• admission.ADM_FHU

• admission.ADM_YPROG

• admission.ADM_DATE

• admission.ADM_ADMT_ID_A_ADM

• admission.ADM_IN_DIS_ID_A

• admission.ADM_OUT_DIS_ID_A

• admission.ADM_OUT_DIS_ID_A_2

• admission.ADM_OUT_DIS_ID_A_3

• admission.ADM_DATE_DIS

• admission.ADM_DIST_ID_A

Select a row from “Patient Data” where the column “Ward” has the name of a ward (left). and click “Discharge Chart”. This generates the admission chart seen in chapter 8.10.2, plus the discharge details.

Data: see chapter 8.10.2

Select a row from “Patient Data” and click “Discharge Chart”. This generates the admission chart (8.10.2), plus a report of the patient’s exams and their results.

Data:

• all “patient” attributes used in 8.10.1

• exam.EXA_DESC

• laboratory.LAB_DATE

• laboratory.LAB_RESULT

Click “DICOM” on the ”Patient Data” window to activate the DICOM Viewer, a tool used to analyze sonograms. The window has two buttons on the bottom. When opened, only the “Load DICOM” button is enabled. Click to upload a .dicom video. Once the file has been opened, the “Zoom” and “Frames” sliders are enabled. The former zooms the current image, while the latter shows the current video frame. You can load more files, and choose the one to visualize, clicking on the thumbnails on the left side of the window. Click “Delete DICOM” to remove a video from the window.

Data:

all attributes from the “dicom” database.

Click “Close” on the “Patient Data” window to return to the “Patients browser” window.

To add a new therapy for the selected patient, click “Add Therapy”. A “Therapy Entry Form - New” window opens. Select the medical, determine the quantity either typing the number or using the slider. Select the daily frequency clicking on the “1”, “2”, “3” or “4” radio buttons. Type the interval in days (“frequency within period”).

Fill the fields on the right side to determine the duration of the therapy (in months, weeks and days), then select the start date either by clicking on the calendar icon or typing the DD/MM/YY date. Finally, add optional date if necessary. Once the data have been inserted, click “OK” (or “Cancel” to abort the operation. If the data are correct, the therapy memo will be added to the calendar, else an error window will be shown:

• “Select a pharmaceutical”

• “Please insert a quantity greater than 0” (for numeric fields)

Data:

• therapies.THR_ID (primary key, therapy ID)

• therapies.THR_PAT_ID (foreign key referencing the “patient” database)

• therapies.THR_STARTDATE (therapy start date)

• therapies.THR_ENDDATE (therapy end date)

• therapies.THR_MDSR_ID (medical ID)

• therapies.THR_QTY (quantity)

• therapies.THR_FREQINDAY (daily frequence)

• therapies.THR_FREQINPRD (fréquence)

• therapies.THR_NOTE (optional notes)

• therapies.THR_SMS (1 if a notification SMS was sent to the patient, else 0; see 8.11.7)

Select a therapy stored in the calendar and click “Edit Therapy”. All data are editable. Click “OK” to update, or “Cancel” to abort.

Data: see chapter 8.11.1

Select a therapy stored in the calendar and click “Remove Therapy”. It will be automatically deleted.

Data:

• therapies.THR_ID

Checks the availability of the medical for every stored therapy. When the therapy is added, it is “NOT CHECKED”. Select a therapy and click “Check Availability”. If the medical is available in the pharmacy the icon shown under that button turns to “AVAILABLE”, else a message window opens as a warning to the user (left). To update the medical DB, see chapter 5.1.

To add a visit for the selected patient, click “Add Visit”. Enter the DD/MM/YY date or choose it clicking on the calendar icon (3.10.1). Then type the scheduled HH:MM time or select it clicking on the clock icon (3.10.2). Once date and time have been inserted, click “OK” to confirm.

Data:

• visits.VST_ID (primary key, visit ID)

• visits.VST_PAT_ID (foreign key referencing the “patient” database)

• patient.PAT_TELE (patient’s phone number for SMS; see 8.11.7)

• visits.VST_DATE (visit date and time)

• visits.VST_NOTE (optional notes)

• visits.VST_SMS (1 if a notification SMS was sent to the patient, else 0; see 8.11.7)

Select a visit stored in the calendar and click “Remove Visit”. It will be automatically deleted.

Data:

• visits.VST_ID

Select a visit / therapy and tick the “SMS” checkbox to send a text notification, with the scheduled date and time, to the patient. If the

patient has no phone number recorded, a message window (left) asks the user to add a number. If “OK” is clicked, type the number on the new window (right), to add it to the “patient” database.

Data:

• visits.VST_ID

• visits.VST_PAT_ID

• patient.PAT_TELE

Saves data inserted / edited. Click “Save” and a confirmation window (left) appears. Click “OK” to close it and return to the calendar. If changes are not saved, the “Close” window (right) is shown. Click:

• “Yes” (saves changes and closes the calendar window)

• “No” (closes the calendar window without saving changes)

• “Cancel” (back to the calendar).

Click “Close” on the calendar window to return to the “Admission / Patient” menu. If changes have been made after the last saving, the “Close” window opens; see 8.11.8 for options.