SMS Pro Aviation Safety Software Blog 4 Airlines & Airports

Understanding Complex Aviation SMS Database Configurations - Portals

Posted by Christopher Howell on Jun 6, 2016 6:00:00 AM Find me on:

Saving Money Implementing Aviation SMS ProgramsLearn Advanced Aviation Safety Management System Database Configurations

Not all aviation service providers are created equal.

  • Charter operators; 
  • Aviation maintenance organizations (AMO);
  • Flight schools; or 
  • FBOs.

Other larger operators may be more complex, having parent companies with a combination of:

  • Airlines;
  • Helicopter operations; and
  • AMOs.

Likewise, there are many aviation service providers operating simultaneously in multiple theaters, such as:

  • North America;
  • South America;
  • Middle East; or
  • Asia.

In this article, we'll discuss some common-sense database configurations for aviation safety management systems (SMS). This article is not intended for a beginner or for a simple operator.

Some complex operators have a desire to save money by having one database for the entire parent company. There are times when this could work, and other times when it will come back and bite you in the tender regions.

 

Watch 3 Risk Management Solution Demo Videos

What is an Aviation Safety Database Portal?

Before we start discussing aviation SMS database configurations for complex service providers, we should first define what is an aviation SMS database portal.

A Web-based SMS database portal is an access site to data and documents commonly belonging to a single company. Data is logically segregatated to ensure other companies do not see safety data from other companies.

Safety data may include:

  • Safety policies and procedures;
  • Hazard reports;
  • Trending charts;
  • Audits and checklists;
  • Corrective action preventive action tracking data;
  • Pictures or images of safety reports;
  • Operational documentation;
  • Safety surveys; and
  • Meeting minutes.

This list is not all inclusive. But you should know users access to this database of information is based on permissions granted to the user by an administrator. For example, all users with the Department Head role can access all data that is designed to be accessed by department heads. Likewise, all safety managers with access to a portal can see the same data. There may be some granual settings to further isolate access, but logic based on permissions is commonplace among SMS database configurations.

Trying to Save a Dollar For Required Safety Databases

The majority of aviation service providers are required to have an aviation safety database to store hazard reports. This includes most operators in Europe, as this became a law in November 2015. An Excel spreadsheet is not a database; therefore, operators storing hazard reports solely in a spreadsheet are not compliant.

Most aviation service providers are profit driven. Therefore, they want to do as much possible by expending the least amount of resources. It is natural for complex operators to want to use a single database for all their SMS database needs. Let's look to see if you need more than one safety database.

Common Scenarios For Aviation SMS Database Configurations

A homogenous company with fewer than 100 employees operating at a single location will commonly have:

  • One safety portal with one division.safety-management-systems SMS for complex operators should be considered carefully to avoid future problems

By homogenous, I'm referring to a single type of operation, such as an:

  • Airline;
  • Helicopter operator;
  • AMO;
  • FBO;
  • Charter operator; or 
  • Flight school.

To understand the concept of aviation safety divisions within SMS Pro, please refer to these two articles:

 

Larger Aviation Operations 

Airlines with more than 100 employees commonly have multiple divisions (or you may call them departments), such as:

  • Flight ops;
  • Ground ops;
  • Engineering;
  • Administration; and
  • Safety & Quality.

These operators will have one portal storing all safety management system data in one database, but separated logically by division. This allows an operator to generate meaningful reports that can focus on a specific division, or aggregate data across the entire company.

There are many aviation service provider with mixed types of operations, such as 

  • Fixed wing;
  • Rotor wing.

They may not have a certificated AMO. Smaller mixed operators may consider a single safety portal with multiple divisions, with each division focusing on a different type of operation. However, if these two types of operations exist under separate certificates, or are at different locations, it is best to have a separate safety portal for each type of operation.

 

Why Does it Matter How Safety Data Are Stored?

In most cases, management requires reports for each type of operation. When all data are bunched together, it becomes increasingly difficult to identify risk management strategies for a particular type of operation based on data thrown into a single bucket.

Furthermore, management may want to isolate data from employees belonging to other operating segment types. For example, management may find it overwhelming or irrelevant for employees in the rotor-wing operation to see data belonging to the fixed wing, and vice-versa.

When a complex operator has separate companies operating in different countries, such as Canada and Chile, then this operator is recommended to have two separate portals that can be answerable to respective regulatory authorities.

Important Note: Each company segment with separate portals can store data in the same aviation safety database. Data is logically separated, but sharing the same data structure.

Because safety portals are commmonly using the same database, safety reports and key performance indicator (KPI) data can be aggregated simply in real time, provided a user possesses the proper permissions. These reports are often aggregated in a "management portal."

This is an important concept to understand: although data is logically separated from employees in separate portals, a management portal possesses the ability to aggregate reports of all configured child (or associated) portals.

 

Large Groups of Simple Operations - Keep it Simple

You may have a company with:

  1. 20 FBOs; or 
  2. 6 AMOs, 3 FBOs and a charter operation.

In the first case of the 20 FBOs, you may want to group your FBOs by region, and create a division for each region. You should still have only one portal for ease of management.

Larger companies with many FBOs may have a safety manager for each region that reports to the Director of Safety. In rare cases, I have seen companies with only one safety manager for the entire group. In any case, when a hazard is reported, the safety manager must know which Department Head to assign the issue. If you are a safety manager in this scenario, and you don't know who should treat a reported issue for an specific FBO or AMO under your charge, you have three options:Aviation safety management systems SMS databases for complex operators with both Airlines FBOs MROs is often focused on saving money in the short run.

  1. Get another safety manager for that group; or
  2. Learn more intimate organizational details about the organization's other holdings; or
  3. Do nothing and hope for the best.

In the second case above of the six AMOs, you may want a division for the FBOs, another division for the charter operator; and if possible, either put all the AMOs into a single division, or break them out into geographic regions. 

There are other companies with other simple group configurations, such as:

  • A flight school;
  • A couple FBOs; and
  • A charter operation.

In cases like this, you are recommended to have one portal, with each business as a division.

 

How Will You Use Aviation Safety Data in the Long Term?

When making decisions as to how to structure your aviation safety database, you should be considering how your company will be using this data in the long run.

You may think you are saving a few dollars in the short term by putting all your data into the same basket. In the long run, you may be crippling your SMS trending report capabilities.

Conversely, we have seen operators who try to "over-architect" their SMS database. There is a time to keep it simple. If in doubt, consult an SMS datbase professional.

We have worked with literally hundreds of aviation service providers around the world. And no, I have not yet seen it all. I am still learning new things about how aviation service providers structure their companies. 

If you have questions about structuring your aviation safety database, feel free to contact us. No obligations. We will share our insights freely.


Contact Us - Free Consultation

 

Some have incredibly simple operations, such as small

Topics: Aviation SMS Database

Site content provided by Northwest Data Solutions is meant for informational purposes only. Opinions presented here are not provided by any civil aviation authority or standards body.

 

 

What is the FAA Part 5 Automation Tool?

Part 5 Automation Tool Logo

Request Live Demo

Live Demo Part 5 Automation Tool

Best Practices for SMS Programs

 

Watch SMS Pro Demo Videos

These two on-demand videos offer:

  • High-level overview of SMS Pro;
  • Hazard Reporting & Risk Management walk-through.
Watch SMS Demo Videos
 
 
 
 

Subscribe to Email Updates

Recent Posts