Purpose and Benefits
Ward management is part of the In-Patient Module and is used to set wards and bed location.
Bahmni expects that the wards setup in a 2 level hierarchy. i.e Beds are mapped to a Room/Sub ward which is a child location of the a parent ward.
Example for valid Bahmni Wards setup is as below.
Configuration
Setup Variables
Setup variables that have to be used for Ward Management
| Code Block | ||
|---|---|---|
| ||
SET @parent_location_id = (select location_id from location where name='General Ward'); SET @location_id = (select location_id from location where name='Physical General Ward'); SET @location_tag_id = (select location_tag_id from location_tag where name='Admission Location'); |
Setup wards
| Code Block | ||||
|---|---|---|---|---|
| ||||
insert into location (name, description, creator, retired, date_created, uuid) values('General Ward', 'General Ward', 1, 0, NOW(), UUID());
insert into location (name, description, creator, retired, date_created, uuid, parent_location) values('Physical General Ward', '1st Floor of General Ward', 1, 0, NOW(), UUID(), @parent_location_id);
insert into location_tag_map values( @parent_location_id , @location_tag_id);
insert into location_tag_map values( @location_id , @location_tag_id); |
Add Bed Types
| Code Block | ||
|---|---|---|
| ||
insert into bed_type values(1, 'deluxe', 'deluxe bed', 'DLX'); |
Add Beds
| Code Block | ||
|---|---|---|
| ||
insert into bed (bed_id, bed_number, status, bed_type_id, uuid, creator, date_created, voided) values(1, '304-a', 'AVAILABLE', 1, UUID(), 1, NOW(), false); |
Map beds to ward list
| Code Block | ||
|---|---|---|
| ||
insert into bed_location_map(bed_location_map_id, location_id, row_number, column_number, bed_id) values(1, @location_id, 1, 1, 1); |
Sample Bed Management SQL file
This sample bed management sql file adds Bed types and Beds and maps beds to ward list. One can change the sql file as per their need and import it to openmrs database.
| Code Block | ||
|---|---|---|
| ||
mysql -uroot -ppassword openmrs < bed_management_locations.sql |
| Tip | ||||
|---|---|---|---|---|
| ||||
|
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||