Working in health implies having control of aspects that go beyond medical practice. Managing health has special demands and features aimed to gather, access, protect and control the sensitive data that constitutes all patient files. Systems like this Healthcare Facility Management template are based on the aim of the proper handling of relational information related to the health state of individuals and stakeholders in healthcare organizations. In this order of ideas, such relational information should be easily created, shared, managed and consulted by authorized health professionals within a specific healthcare organization while protecting their confidentiality.  With healthcare information typically fragmented across multiple specialties and bits of data, this Healthcare Facility Management template takes the hassle out of managing everything from one coherent location. Here are the template’s features and highlights, by table:

Patients

This is an anchor point of healthcare management. As health care begins in patients, the medical history of individuals needs to be linked to their unique data.

Fields

• Name. The patient’s full name.
• Photo. A photograph of the patient for record keeping and security purposes.
• Date of birth. The patient’s cake day.
• Address. The patient’s current address.
• Email. The patient’s email address. It’s often used to send medical outcomes, lab results, appointment reminders, bills, and more.
• Phone. The phone number where the patient can best be reached.
• SSN/TIN. The Social Security Number or Tax Identification Number for the patient.
• Appt. type. This is a linked field to the Appointment types table, specifying the type of appointment(s) that the patient has been scheduled for.
• Specialty. This is a linked field to the Specialties table, specifying the medical field that the patient needs/wants to attend.
• Doctor. This is a linked field to the Doctors table, specifying the name of the doctor scheduled for the patient.
• Nurse. This is a linked field to the Nurses table, specifying the name of the nurse accompanying the doctors and related specialties, if applicable.
• Symptoms: organs and systems. A single select field for categorizing the patient’s symptoms and reason(s) for visiting.
• Last visit. Date and time that the patient last visited the healthcare facility.
• Medications. This is a linked field to the Medications table. It consists of treatments, medicines and dosage prescribed by the medical practitioner.
• Vaccinations. This is a linked field to the Vaccines table. It contains a running tally of vaccinations that the patient has received.
• Allergies/reactions. This is a linked field to the Allergies table. It’s a list of allergies or allergic reactions that the patient currently has or has previously experienced.
• Family medical history. A long notes to add relevant information to the patient’s family medical history.
• Illnesses and hospitalization. A notes field to elaborate on important information related to recent or past illnesses/hospitalizations, their evolution, and prognosis.
• Medical record. A field to add physical scans, as well as images and PDF forms related to the patient.
• Insured. A checkbox field that allows you to select if the patient has insurance or not.
• Insurance name. A space to note the name of the insurance carrier for those patients who are insured.
• Notes. A catch-all space to jot down notes, comments, and other knick-knacks about the patient.
• Appointments. This is a linked field to the Appointments table, specifying all the appointments this patient has. This field is hidden by default.

Views

• All patients. Displays all patients, sorted in alphabetical order by patient name.
• Uninsured. Displays all patients who are uninsured or missing insurance per the medical records, sorted in alphabetical order by patient name.
• Allergies. Displays all patients who have allergies or allergic reactions, sorted in alphabetical order by patient name.
• New patient. Displays a form for new patients. Share this form with patients, have them fill it out, and submit. Their information will automatically be added to the Patients table with their respective answers from the form.
• Patients gallery. Displays a gallery of all patients, sorted alphabetically by Name from A to Z.

Doctors

It’d be pretty tough to take care of patients without doctors!

Fields

• Name. The doctor’s full name.
• Photo. A photograph of the doctor for record keeping and security purposes.
• Specialty. This is a linked field to the Specialties table, specifying the particular field each doctor devotes is devoted to.
• Nurses. This is a linked field to the Nurses table. It consists of the nurse(s) that the doctor typically works with.
• Patients. This is a linked field to the Patients table. It consists of all of the patients that the doctor tends.
• Active. A checkbox field to determine if the doctor is currently active at a given point in time.
• Notes. A general purpose field to capture any other important notes about the facility’s doctors.
• Appointments. This is a linked field to the Appointments table, specifying all the appointments this doctor has. This field is hidden by default.

Views

• All doctors. Displays all doctors, sorted in alphabetical order by the doctor’s name.
• Inactive. Displays all doctors that are currently marked as inactive, sorted in alphabetical order by the doctor’s name.
• Doctors gallery. Displays a gallery of all doctors, sorted alphabetically by Name from A to Z.

Nurses

Nurses are a critical part of healthcare. Remember—while doctors diagnose, nurses heal!

Fields

• Name. The nurse’s full name.
• Photo. A photograph of the nurse for record keeping and security purposes.
• Shift schedule. Usually nurses are available in particular shifts. This field allows you to note their regular shifts at the medical organization.
• Specialty. This is a linked field to the Specialties table. Nurses can be assigned to one or more specialties, which is reflected in this field.
• Assisting. This is a linked field to the Doctors table. It denotes the doctor that the nurse primarily (but not necessarily exclusively) assists.
• Patients. This is a linked field to the Patients table. The same way doctors have patients, so too do nurses. This field contains a recollection of the patients each nurse has assisted.
• Notes. Use this space to add comments, advice, and other catch-all items.

Views

• All nurses. Displays all nurses, sorted alphabetically by name.
• Night shift. Displays all nurses who work night shifts, sorted alphabetically by name.
• Nurses gallery. Displays a gallery of all nurses, sorted alphabetically by Name from A to Z.

Specialties

Health organizations are usually composed of different disciplines interacting in the same physical space. This table currently contains 10 specialties which you can always extend and customize.

Fields

• Name. The name of the specialty/medical field.
• Associated doctors. This is a linked field to the Doctors table. It consists of the doctor(s) practicing the respective speciality.
• Associated nurses. This is a linked field to the Nurses table. The nurses who assist the doctors in the respective speciality.
• Associated patients. This is a linked field to the Patients table. It consists of the patient(s) who’ve attended the respective speciality.
• Floor. The floor where the specialty is located.
• Shortcode. A designated shortcode that describes the specialty.

Views

• All specialties. Displays all specialties, sorted in alphabetical order by name.

Allergies

This space is preloaded with 19 common allergies you can choose from to fill out the patient’s health chart. Pick those you need to add to each patient, and if you can’t find the allergy or allergic reaction you need, you can add it.

Fields

• Name. The name of the allergy.
• Patients with allergy. A linked field to the Patients table with the patients reporting a particular allergy/allergic reaction.
• Notes. Use this final space to add comments, advice and all those items you need to add to your hospital health record, but you’re not totally sure where they should be placed.

Views

• All allergies. Displays all allergies, sorted in alphabetical order by allergy name.

Vaccines

Vaccines help prevent, mitigate, and even eradicate deadly diseases, helping humankind live longer. There are a lot of vaccines in existence, all of which can be added to this table.

Fields

• Name. The name of the vaccine.
• Patient. This is a linked field to the Patients table. It contains all patients who have been vaccinated with the respective vaccine.
• Notes. Use this final space to add comments, advice and all those items you need to add to your hospital health record, but you’re not totally sure where they should be placed.

Views

• All vaccines. Displays all vaccines, sorted in alphabetical order by name.

Medications

A good chunk of healthcare includes taking medications. Whether for preventive or healing purposes, medications are important to help the improvement or control of chronic conditions.

Fields

• Name. A space to add the medications’ name prescribed by the facultative.
• Standard dose. The standard dosage of the respective medication. While different patients require different doses, medications typically have standard doses. Note that units are both in milligrams and milliliters.
• Patients. A linked field to the Patients table. It contains the names (or names) of patients who received said medication.

Views

• All medications. Displays all medications, sorted alphabetically by name.

Appointments

Having an organized method of making appointments helps doctor visits run smoothly. Healthcare staff can better prepare for patients arrival, and patient wait time can be decreased. Use this table to organize all the different appointments for each patient with the respective doctor.

Fields

• Appointment ID. The unique appointment ID used to reference the specific appointment.
• Date/time slot. The date in year/month/day format along with a time slot for the appointment in 24H time.
• Patient. This field links to the Patients table, indicating the specific patient the appointment is for.
• Doctor. This field links to the Doctors **table, displaying the doctor being visited.
• Appointment type. This field links to the Appointment types **table, displaying the type of appointment made.
• Checked in. This field serves as a checked or blank field, indicating whether the patient was checked in or if they did not show up for their appointment.
• Notes. Additional notes for the visit.

Views

• All appointments. Displays all appointments sorted by earliest appointment slot to the latest appointment slot.

Appointment Types

It’s impossible to book a doctor’s appointment without providing a reason. Thus, this table was born. Use it to track the types of appointments that patients are booking for a well-rounded picture of what’s happening at the hospital, as it helps the facility prepare and guide patients as necessary.

Fields

• Purpose. The appointment type’s purpose.
• Priority. Denotes the general priority of the appointment type. After all, emergencies are prioritized higher than other types, such as initial visits and general checkups.
• Avg per week. A number field for the average number of appointments per week for this type.
• Patients. This is a linked field to the Patients table. It contains all of the patients that have visited the facility for the respective appointment type.
• Notes. An internal notes field about the appointment type.
• Appointments. This is a linked field to the Appointments table, specifying all the appointments this record is associated. This field is hidden by default.

Views

• All types. Displays all appointment types, sorted alphabetically by name.